C_SalesOrderQuery

Sales Order - Query | view: CSDSLSORDHDRQRY | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, SCAL_TT_DATE, VBKD, VEDA, VBAK, FPLT, VBAK, VBAP, VBKD, VEDA, VBAK, VBAP, VBKD, VEDA, VBEP, /CPD/D_MP_HDR, /CPD/D_MP_ITEM, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, TVKO, CVI_VEND_LINK, USR21
Column Name Description
SalesOrder Sales Order
Column Name Description
💲 Display Currency (DisplayCurrency):
IncomingSalesOrdersNetAmtInDC Incoming Sales Orders Net Value In Display Currency
OpnSOForOrdReltdInvcsNetAmtDC Open Sales Orders for Ord.Reltd Billing Net Amount IDC
OpnSlsOrdsForDelivAmtInDspCrcy Open Sales Orders for Deliveries Net Amt in Displ. Crcy
OpnSlsOrdsForInvcPlansNetAmtDC Open Sls Orders for Billing Plans Net Amt in Displ. Crcy
OpenSalesOrdersNetAmountInDC Open Sales Orders Net Amount In Display Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
SalesOrderDate Document Date (Date Received/Sent)
CustomerPurchaseOrderDate Customer Reference Date
ServicesRenderedDate Date on which services are rendered
RequestedDeliveryDate Requested Delivery Date
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
Column Name Description
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallPurchaseConfStatus Purchasing Confirmation Status (All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallDelivConfStatus Delivery Confirmation Status (All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
OverallDeliveryBlockStatus Overall Delivery Block Status (All Items) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
OverallBillingBlockStatus Billing Block Status (All Items) Show values
OverallTotalSDDocRefStatus Overall Reference Status (All Items) Show values
OverallSDDocReferenceStatus Reference Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
MaxDocValueCreditCheckStatus Status of Credit Check Against Maximum Document Value Show values
PaymentTermCreditCheckStatus Status of Credit Check Against Terms of Payment Show values
FinDocCreditCheckStatus Status of Credit Check Against Financial Document Show values
ExprtInsurCreditCheckStatus Status of Credit Check Against Export Credit Insurance Show values
PaytAuthsnCreditCheckSts Status of Credit Check Against Payment Card Authorization Show values
CentralCreditCheckStatus Central Credit Check Status Show values
CentralCreditChkTechErrSts Status of Technical Error SAP Credit Management Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
Column Name Description Domain name
NumberOfIncomingSalesOrders Number of Incoming Sales Orders
NumberOfOpenSalesOrders Number of Open Sales Orders
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreationDateYear Year of Creation NUM4
CreationDateYearQuarter Year/Quarter of Creation NUM5
CreationDateYearMonth Year/Month of Creation NUM6
SalesOrderDateYear Year of Order NUM4
SalesOrderDateYearQuarter Quarter of Order NUM5
SalesOrderDateYearMonth Month of Order NUM6
PurchaseOrderByCustomer Customer Reference BSTKD
CustomerPurchaseOrderSuplmnt Purchase order number supplement BSTZD
SalesOrderCondition Sales Order Condition KNUMV
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
CustomerProject Commercial Project ID /CPD/MP_ID
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
CostCenter Cost Center KOSTL
ReferenceSDDocument Document number of the reference document VBELN
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • C_SALESORDERQUERY.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • C_SALESORDERQUERY.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • C_SALESORDERQUERY.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • C_SALESORDERQUERY.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • C_SALESORDERQUERY.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • C_SALESORDERQUERY.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • C_SALESORDERQUERY.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • C_SALESORDERQUERY.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • C_SALESORDERQUERY.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • C_SALESORDERQUERY.MANDT == TVV5.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • C_SALESORDERQUERY.BILLINGCOMPANYCODE == T001.BUKRS
  • C_SALESORDERQUERY.MANDT == T001.MANDT
Customer - Document Customer
  • Payer
  • Ship-to Party
  • Sold-to Party
  • Bill-to Party
  • Client
  • C_SALESORDERQUERY.PAYERPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.SHIPTOPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.BILLTOPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.MANDT == KNA1.MANDT
Business Area
  • Business Area
  • Client
  • C_SALESORDERQUERY.BUSINESSAREA == TGSB.GSBER
  • C_SALESORDERQUERY.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_SALESORDERQUERY.CONTROLLINGAREA == TKA01.KOKRS
  • C_SALESORDERQUERY.MANDT == TKA01.MANDT
Business Area from Cost Center
  • Business Area from Cost Center
  • Client
  • C_SALESORDERQUERY.COSTCENTERBUSINESSAREA == TGSB.GSBER
  • C_SALESORDERQUERY.MANDT == TGSB.MANDT
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • C_SALESORDERQUERY.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • C_SALESORDERQUERY.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • C_SALESORDERQUERY.CUSTOMERGROUP == T151.KDGRP
  • C_SALESORDERQUERY.MANDT == T151.MANDT
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • C_SALESORDERQUERY.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • C_SALESORDERQUERY.MANDT == T176.MANDT
Customer Rebate Agreement
  • Customer Rebate Agreement
  • Client
  • C_SALESORDERQUERY.CUSTOMERREBATEAGREEMENT == KONA.KNUMA
  • C_SALESORDERQUERY.MANDT == KONA.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SALESORDERQUERY.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SALESORDERQUERY.MANDT == TVLS.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • C_SALESORDERQUERY.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESORDERQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SALESORDERQUERY.MANDT == TVKOV.MANDT
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • C_SALESORDERQUERY.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SALESORDERQUERY.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_SALESORDERQUERY.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_SALESORDERQUERY.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_SALESORDERQUERY.INCOTERMSVERSION == TINCV.INCOV
  • C_SALESORDERQUERY.MANDT == TINCV.MANDT
Order Number
  • Order Number
  • Client
  • C_SALESORDERQUERY.ORDERID == AUFK.AUFNR
  • C_SALESORDERQUERY.MANDT == AUFK.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Organization Division
  • Client
  • C_SALESORDERQUERY.SALESORGANIZATION == TVTA.VKORG
  • C_SALESORDERQUERY.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SALESORDERQUERY.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESORDERQUERY.MANDT == TVTA.MANDT
Customer - Document Customer
  • Payer
  • Ship-to Party
  • Sold-to Party
  • Bill-to Party
  • Client
  • C_SALESORDERQUERY.PAYERPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.SHIPTOPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.BILLTOPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.MANDT == KNA1.MANDT
Payment Method
  • Payment Method
  • ?
  • Client
  • C_SALESORDERQUERY.PAYMENTMETHOD == T042Z.ZLSCH
  • C_SALESORDERQUERY.[column in domain "LAND1"] == T042Z.LAND1
  • C_SALESORDERQUERY.MANDT == T042Z.MANDT
Product Catalog
  • Product Catalog Number
  • Client
  • C_SALESORDERQUERY.PRODUCTCATALOG == WWMI.WMINR
  • C_SALESORDERQUERY.MANDT == WWMI.MANDT
Retail promotion
  • Retail Promotion
  • Client
  • C_SALESORDERQUERY.RETAILPROMOTION == WAKH.AKTNR
  • C_SALESORDERQUERY.MANDT == WAKH.MANDT
Sales District
  • Sales District
  • Client
  • C_SALESORDERQUERY.SALESDISTRICT == T171.BZIRK
  • C_SALESORDERQUERY.MANDT == T171.MANDT
Sales group
  • Sales office
  • Sales group
  • Client
  • C_SALESORDERQUERY.SALESOFFICE == TVBVK.VKBUR
  • C_SALESORDERQUERY.SALESGROUP == TVBVK.VKGRP
  • C_SALESORDERQUERY.MANDT == TVBVK.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_SALESORDERQUERY.SALESORDERTYPE == TVAK.AUART
  • C_SALESORDERQUERY.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_SALESORDERQUERY.SALESORGANIZATION == TVKO.VKORG
  • C_SALESORDERQUERY.MANDT == TVKO.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • C_SALESORDERQUERY.SDDOCUMENTREASON == TVAU.AUGRU
  • C_SALESORDERQUERY.MANDT == TVAU.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • C_SALESORDERQUERY.SHIPPINGCONDITION == TVSB.VSBED
  • C_SALESORDERQUERY.MANDT == TVSB.MANDT
Shipping Type
  • Client
  • Shipping Type
  • C_SALESORDERQUERY.MANDT == T173.MANDT
  • C_SALESORDERQUERY.SHIPPINGTYPE == T173.VSART
Customer - Document Customer
  • Payer
  • Ship-to Party
  • Sold-to Party
  • Bill-to Party
  • Client
  • C_SALESORDERQUERY.PAYERPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.SHIPTOPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.BILLTOPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.MANDT == KNA1.MANDT
Sold-to Party
  • Payer
  • Ship-to Party
  • Sold-to Party
  • Bill-to Party
  • Client
  • C_SALESORDERQUERY.PAYERPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.SHIPTOPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.BILLTOPARTY == KNA1.KUNNR
  • C_SALESORDERQUERY.MANDT == KNA1.MANDT
Customer Classification
  • Customer Classification
  • Client
  • C_SALESORDERQUERY.SOLDTOPARTYCLASSIFICATION == TKUKL.KUKLA
  • C_SALESORDERQUERY.MANDT == TKUKL.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Sales Organization
  • Distribution Channel
  • Organization Division
  • Client
  • C_SALESORDERQUERY.SALESOFFICE == TVKBZ.VKBUR
  • C_SALESORDERQUERY.SALESORGANIZATION == TVKBZ.VKORG
  • C_SALESORDERQUERY.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_SALESORDERQUERY.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_SALESORDERQUERY.MANDT == TVKBZ.MANDT