C_SlsDocFlfmtSlsDoc

Sales Doc Fulfillment: Sales Document | view: CSOFSLSDOC | Extraction: Not supported | Component: Sales Analytics
Tables used: FPLA, VBKD, VEDA, VBAK, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, /CPD/D_MP_HDR, /CPD/D_MP_ITEM, JEST, JSTO, VBPA, VBPA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, T005, T005T, T014, UKM_KKBER2SGM, KNA1, CVI_CUST_LINK, CVI_VEND_LINK, PROJ, TJ07, TJ31
Column Name Description
SalesDocument Sales Document
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
NextCreditCheckDate Date of Next Credit Check of Document
RequestedDeliveryDate Requested Delivery Date
BillingDocumentDate Billing Date
Column Name Description
SDDocumentCategory SD Document Category Show values
SalesDocumentProcessingType SD document indicator Show values
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
PaymentCardIsBlockedForAuthzn Payment Cards: Authorization Block Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
SalesDocApprovalStatus Document Approval Status Show values
OverallPurchaseConfStatus Purchasing Confirmation Status (All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallOrdReltdBillgStatus Order-Related Billing 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
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
CentralCreditCheckStatus Central Credit Check Status 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
CtrlgObjStatusIsDeliveryBlkd User Status Delivery Blocked Show values
CtrlgObjStatusIsBillingBlkd User Status Invoicing Blocked Show values
OverallChmlCmplncStatus Product Marketability Status (All Items) Show values
OverallDangerousGoodsStatus Dangerous Goods Status (All Items) Show values
OverallSafetyDataSheetStatus Safety Data Sheet Status (All Items) Show values
OverallTrdCmplncEmbargoSts Embargo Status (All Items) Show values
OvrlTrdCmplncSnctndListChkSts Screening Status (All Items) Show values
OvrlTrdCmplncLegalCtrlChkSts Legal Control Status (All Items) Show values
AddressObjectType Address type (1=Organization, 2=Person, 3=Contact person) Show values
ShipToPartyAddressObjectType Address type (1=Organization, 2=Person, 3=Contact person) Show values
Column Name Description Domain name
SemanticObject 30 Characters CHAR30
CustomerPaymentTerms Terms of payment key ZTERM
PurchaseOrderByCustomer Customer Reference BSTKD
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
SoldToPartyName Name of Sold-to Party TEXT80
SoldToPartyFullName Full Name of Sold-to Party TEXT80
AddressID Address ADRNR
SoldToPartyFormattedAddress Sold-to Party: Formatted Address
ShipToPartyName Name of Ship-to Party TEXT80
ShipToPartyFullName Full Name of Sold-to Party TEXT80
ShipToPartyCountryName Ship-to Party Country or Region TEXT50
ShipToPartyAddressID Address ADRNR
ShipToPartyFormattedAddress Ship-to Party: Formatted Address
ResponsibleEmployee Employee Responsible PERNR
ResponsibleEmployeeName Name of Employee Responsible TEXT80
BillToPartyName Name of Bill-to Party TEXT80
PayerPartyName Payer Name TEXT80
BusinessPartner Business Partner Number BU_PARTNER
CustomerProject Commercial Project ID /CPD/MP_ID
CustomerProjectName Customer Project Name /CPD/SHORT_TEXT
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
SalesDocApprovalStsCriticality null
HdrGenIncompltnStsCriticality null
HdrDelivIncompltnStsCritlty null
HdrBillgIncompltnStsCritlty null
OvrlItmGenIncompltnStsCritlty null
OvrlItmDelivIncompltnCritlty null
OvrlItmBillgIncompltnCritlty null
OvrlPrcgIncompltnStsCritlty null
CtrlgObjStsIsDelivBlkdCritlty null
DeliveryBlockReasonCriticality null
CtrlgObjStsIsBillgBlkdCritlty null
HdrBillgBlockReasonCriticality null
CentralCreditChkStsCriticality null
PaytAuthCrdtChkStsCriticality null
FinDocCrdtCheckStsCriticality null
ExprtInsurCrdtChkStsCritlty null
OvrlChmlCmplncStsCriticality null
OvrlDngrsGdsStsCriticality null
OvrlSftyDataSheetStsCritlty null
OvrlTrdCmplncEmbargoStsCritlty null
OvrlTrdCmplncSnctndListCritlty null
OvrlTrdCmplncLglCtrlStsCritlty null
PurchaseConfStatusCriticality null
SalesDocumentRjcnReason Reason for Rejection of Sales Documents ABGRU_VA
Master Data Relations Join Conditions
Person Number
  • Person Number
  • Person Number
  • ?
  • ?
  • Client
  • C_SLSDOCFLFMTSLSDOC.ADDRESSPERSONID == ADRP.PERSNUMBER
  • C_SLSDOCFLFMTSLSDOC.SHIPTOPARTYADDRESSPERSONID == ADRP.PERSNUMBER
  • C_SLSDOCFLFMTSLSDOC.[column in domain "AD_NATION"] == ADRP.NATION
  • C_SLSDOCFLFMTSLSDOC.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • C_SLSDOCFLFMTSLSDOC.MANDT == ADRP.CLIENT
Customer - Document Customer
  • Ship-to Party
  • Sold-to Party
  • Payer
  • Bill-to Party
  • Client
  • C_SLSDOCFLFMTSLSDOC.SHIPTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.SOLDTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.PAYERPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.BILLTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.MANDT == KNA1.MANDT
Credit Segment
  • Client
  • Credit Segment
Customer Classification
  • Client
  • Customer Classification
  • C_SLSDOCFLFMTSLSDOC.MANDT == TKUKL.MANDT
  • C_SLSDOCFLFMTSLSDOC.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • C_SLSDOCFLFMTSLSDOC.MANDT == TVLS.MANDT
  • C_SLSDOCFLFMTSLSDOC.DELIVERYBLOCKREASON == TVLS.LIFSP
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • C_SLSDOCFLFMTSLSDOC.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SLSDOCFLFMTSLSDOC.MANDT == TVKOV.MANDT
  • C_SLSDOCFLFMTSLSDOC.SALESORGANIZATION == TVKOV.VKORG
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • C_SLSDOCFLFMTSLSDOC.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SLSDOCFLFMTSLSDOC.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_SLSDOCFLFMTSLSDOC.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_SLSDOCFLFMTSLSDOC.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_SLSDOCFLFMTSLSDOC.INCOTERMSVERSION == TINCV.INCOV
  • C_SLSDOCFLFMTSLSDOC.MANDT == TINCV.MANDT
Division in order header
  • Distribution Channel
  • Division
  • Client
  • Sales Organization
  • C_SLSDOCFLFMTSLSDOC.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SLSDOCFLFMTSLSDOC.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SLSDOCFLFMTSLSDOC.MANDT == TVTA.MANDT
  • C_SLSDOCFLFMTSLSDOC.SALESORGANIZATION == TVTA.VKORG
Customer - Document Customer
  • Ship-to Party
  • Sold-to Party
  • Payer
  • Bill-to Party
  • Client
  • C_SLSDOCFLFMTSLSDOC.SHIPTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.SOLDTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.PAYERPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.BILLTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.MANDT == KNA1.MANDT
Approval Request Reason ID
  • Approval Request Reason ID
  • Client
  • C_SLSDOCFLFMTSLSDOC.SALESDOCAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
  • C_SLSDOCFLFMTSLSDOC.MANDT == SDAPMAPRR.CLIENT
Order type in order header
  • Sales Document Type
  • Client
  • C_SLSDOCFLFMTSLSDOC.SALESDOCUMENTTYPE == TVAK.AUART
  • C_SLSDOCFLFMTSLSDOC.MANDT == TVAK.MANDT
Sales group
  • Client
  • Sales office
  • Sales group
  • C_SLSDOCFLFMTSLSDOC.MANDT == TVBVK.MANDT
  • C_SLSDOCFLFMTSLSDOC.SALESOFFICE == TVBVK.VKBUR
  • C_SLSDOCFLFMTSLSDOC.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • C_SLSDOCFLFMTSLSDOC.MANDT == TVKO.MANDT
  • C_SLSDOCFLFMTSLSDOC.SALESORGANIZATION == TVKO.VKORG
Shipping Conditions
  • Shipping Conditions
  • Client
  • C_SLSDOCFLFMTSLSDOC.SHIPPINGCONDITION == TVSB.VSBED
  • C_SLSDOCFLFMTSLSDOC.MANDT == TVSB.MANDT
Shipping Type
  • Client
  • Shipping Type
  • C_SLSDOCFLFMTSLSDOC.MANDT == T173.MANDT
  • C_SLSDOCFLFMTSLSDOC.SHIPPINGTYPE == T173.VSART
Customer - Document Customer
  • Ship-to Party
  • Sold-to Party
  • Payer
  • Bill-to Party
  • Client
  • C_SLSDOCFLFMTSLSDOC.SHIPTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.SOLDTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.PAYERPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.BILLTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.MANDT == KNA1.MANDT
Person Number
  • Person Number
  • Person Number
  • ?
  • ?
  • Client
  • C_SLSDOCFLFMTSLSDOC.ADDRESSPERSONID == ADRP.PERSNUMBER
  • C_SLSDOCFLFMTSLSDOC.SHIPTOPARTYADDRESSPERSONID == ADRP.PERSNUMBER
  • C_SLSDOCFLFMTSLSDOC.[column in domain "AD_NATION"] == ADRP.NATION
  • C_SLSDOCFLFMTSLSDOC.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • C_SLSDOCFLFMTSLSDOC.MANDT == ADRP.CLIENT
Country key
  • Client
  • Ship-to Party Country or Region
  • C_SLSDOCFLFMTSLSDOC.MANDT == T005.MANDT
  • C_SLSDOCFLFMTSLSDOC.SHIPTOPARTYCOUNTRY == T005.LAND1
Sold-to Party
  • Ship-to Party
  • Sold-to Party
  • Payer
  • Bill-to Party
  • Client
  • C_SLSDOCFLFMTSLSDOC.SHIPTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.SOLDTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.PAYERPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.BILLTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTSLSDOC.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • C_SLSDOCFLFMTSLSDOC.MANDT == TCURC.MANDT
  • C_SLSDOCFLFMTSLSDOC.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Distribution Channel
  • Division
  • Client
  • Sales office
  • Sales Organization
  • C_SLSDOCFLFMTSLSDOC.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_SLSDOCFLFMTSLSDOC.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_SLSDOCFLFMTSLSDOC.MANDT == TVKBZ.MANDT
  • C_SLSDOCFLFMTSLSDOC.SALESOFFICE == TVKBZ.VKBUR
  • C_SLSDOCFLFMTSLSDOC.SALESORGANIZATION == TVKBZ.VKORG