C_SlsOrdFlfmtSalesOrderQ

SOFM Sales Order Query | view: CSOFSLSORDQ | Extraction: Not supported | Component: Sales Analytics
Tables used: VBKD, VEDA, VBAK, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, /CPD/D_MP_HDR, /CPD/D_MP_ITEM, JEST, JSTO, VBPA, VBPA, TVFS, TVFST, CVI_CUST_CT_LINK, BUT000, UKM_KKBER2SGM, KNA1, TKUKL, TKUKT, TVZB, TVZBT, CVI_CUST_LINK, TVLS, TVLST, TVTW, TVTWT, TSPA, TSPAT, TINC, TINCT, TINCV, TINCVT, TVAK, TVAKT, TVKO, TVKOT, TVSB, TVSBT, T173, T173T, CVI_VEND_LINK, PROJ, TVBST, TVBST, TVBST, TVBST, TVBST, TVBST, TVBST, TVBST, TJ07, TJ31
Column Name Description
SalesOrder Sales Order
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document 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)
NextCreditCheckDate Date of Next Credit Check of Document
RequestedDeliveryDate Requested Delivery Date
BillingDocumentDate Billing Date
Column Name Description
SDDocumentCategory SD Document Category Show values
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
OverallDelivConfStatus Delivery Confirmation Status (All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) 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
CtrlgObjStatusIsDeliveryBlkd User Status Delivery Blocked Show values
CtrlgObjStatusIsBillingBlkd User Status Invoicing Blocked Show values
Column Name Description Domain name
SalesOrderTypeName Sales Document Type Description TEXT20
CreatedByUser Name of Person Responsible for Creating the Object USNAM
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
SoldToPartyName Name of Sold-to Party TEXT80
ShipToPartyName Name of Ship-to Party TEXT80
BillToPartyName Name of Bill-to Party TEXT80
PayerPartyName Payer Name TEXT80
CustomerClassificationDesc Customer Classification Description TEXT20
PurchaseOrderByCustomer Customer Reference BSTKD
DeliveryBlockReasonText Description TEXT20
ShippingConditionName Shipping Conditions Description TEXT20
IncotermsClassificationName Description TEXT30
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
IncotermsVersionName Description TEXT30
ShippingTypeName Shipping Type Description TEXT20
BillingBlockReasonDescription Billing Block Description TEXT20
CustomerPaymentTerms Terms of payment key ZTERM
CustomerPaymentTermsName Description of terms of payment TEXT30
HdrGenIncompletionStatusDesc General Incompletion Status Description (Header) TEXT20
HdrDelivIncompletionStatusDesc Delivery Incompletion Status Description (Header) TEXT20
OverallPrcIncompletionStsDesc Overall Items Pricing Incompletion Status Description TEXT20
HdrBillgIncompletionStatusDesc Billing Incompletion Status Description (Header) TEXT20
FinDocCreditCheckStatusDesc Status Description TEXT20
ExprtInsurCreditCheckStsDesc Status Description TEXT20
PaytAuthsnCreditCheckStsDesc Status of Credit Check Against Payment Card Authzn Desc. TEXT20
CentralCreditCheckStatusDesc Status Description TEXT20
CustomerProject Commercial Project ID /CPD/MP_ID
CustomerProjectName Customer Project Name /CPD/SHORT_TEXT
Master Data Relations Join Conditions
Customer - Document Customer
  • Payer
  • Ship-to Party
  • Bill-to Party
  • Sold-to Party
  • Client
  • C_SLSORDFLFMTSALESORDERQ.PAYERPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.SHIPTOPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.BILLTOPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.SOLDTOPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.MANDT == KNA1.MANDT
Customer Classification
  • Customer Classification
  • Client
  • C_SLSORDFLFMTSALESORDERQ.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • C_SLSORDFLFMTSALESORDERQ.MANDT == TKUKL.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SLSORDFLFMTSALESORDERQ.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SLSORDFLFMTSALESORDERQ.MANDT == TVLS.MANDT
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • C_SLSORDFLFMTSALESORDERQ.MANDT == TVKOV.MANDT
  • C_SLSORDFLFMTSALESORDERQ.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SLSORDFLFMTSALESORDERQ.SALESORGANIZATION == TVKOV.VKORG
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • C_SLSORDFLFMTSALESORDERQ.MANDT == TVFS.MANDT
  • C_SLSORDFLFMTSALESORDERQ.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_SLSORDFLFMTSALESORDERQ.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_SLSORDFLFMTSALESORDERQ.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_SLSORDFLFMTSALESORDERQ.INCOTERMSVERSION == TINCV.INCOV
  • C_SLSORDFLFMTSALESORDERQ.MANDT == TINCV.MANDT
Division in order header
  • Division
  • Client
  • Distribution Channel
  • Sales Organization
  • C_SLSORDFLFMTSALESORDERQ.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SLSORDFLFMTSALESORDERQ.MANDT == TVTA.MANDT
  • C_SLSORDFLFMTSALESORDERQ.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SLSORDFLFMTSALESORDERQ.SALESORGANIZATION == TVTA.VKORG
Customer - Document Customer
  • Payer
  • Ship-to Party
  • Bill-to Party
  • Sold-to Party
  • Client
  • C_SLSORDFLFMTSALESORDERQ.PAYERPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.SHIPTOPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.BILLTOPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.SOLDTOPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.MANDT == KNA1.MANDT
Sales group
  • Client
  • Sales office
  • Sales group
  • C_SLSORDFLFMTSALESORDERQ.MANDT == TVBVK.MANDT
  • C_SLSORDFLFMTSALESORDERQ.SALESOFFICE == TVBVK.VKBUR
  • C_SLSORDFLFMTSALESORDERQ.SALESGROUP == TVBVK.VKGRP
Order type in order header
  • Client
  • Sales Document Type
  • C_SLSORDFLFMTSALESORDERQ.MANDT == TVAK.MANDT
  • C_SLSORDFLFMTSALESORDERQ.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • C_SLSORDFLFMTSALESORDERQ.MANDT == TVKO.MANDT
  • C_SLSORDFLFMTSALESORDERQ.SALESORGANIZATION == TVKO.VKORG
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_SLSORDFLFMTSALESORDERQ.MANDT == TVSB.MANDT
  • C_SLSORDFLFMTSALESORDERQ.SHIPPINGCONDITION == TVSB.VSBED
Shipping Type
  • Client
  • Shipping Type
  • C_SLSORDFLFMTSALESORDERQ.MANDT == T173.MANDT
  • C_SLSORDFLFMTSALESORDERQ.SHIPPINGTYPE == T173.VSART
Customer - Document Customer
  • Payer
  • Ship-to Party
  • Bill-to Party
  • Sold-to Party
  • Client
  • C_SLSORDFLFMTSALESORDERQ.PAYERPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.SHIPTOPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.BILLTOPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.SOLDTOPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.MANDT == KNA1.MANDT
Sold-to Party
  • Payer
  • Ship-to Party
  • Bill-to Party
  • Sold-to Party
  • Client
  • C_SLSORDFLFMTSALESORDERQ.PAYERPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.SHIPTOPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.BILLTOPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.SOLDTOPARTY == KNA1.KUNNR
  • C_SLSORDFLFMTSALESORDERQ.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • C_SLSORDFLFMTSALESORDERQ.MANDT == TCURC.MANDT
  • C_SLSORDFLFMTSALESORDERQ.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Client
  • Sales office
  • Distribution Channel
  • Sales Organization
  • C_SLSORDFLFMTSALESORDERQ.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_SLSORDFLFMTSALESORDERQ.MANDT == TVKBZ.MANDT
  • C_SLSORDFLFMTSALESORDERQ.SALESOFFICE == TVKBZ.VKBUR
  • C_SLSORDFLFMTSALESORDERQ.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_SLSORDFLFMTSALESORDERQ.SALESORGANIZATION == TVKBZ.VKORG