C_SlsDocFlfmtDelivDoc

Sales Doc Fulfillment: Delivery Document | view: CSOFDELIVDOC | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, LIKP, LIPS, VBAK, VBAP, VBKD, VEDA, VBPA, VBPA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, T005, T005T, KNA1, CVI_CUST_LINK, TVST, TVSTT, CVI_VEND_LINK
Column Name Description
DeliveryDocument Delivery
Column Name Description
💲 SD Document Currency (TransactionCurrency):
ActualDeliveryAmount Net Value in Document Currency
Column Name Description
📏 Weight Unit (HeaderWeightUnit):
HeaderGrossWeight Total Weight
Column Name Description
PickingDate Picking Date
LoadingDate Loading Date
DeliveryDate Delivery Date
TransportationPlanningDate Transport Planning Date
PlannedGoodsIssueDate Planned Goods Movement Date
ActualGoodsMovementDate Actual Goods Movement Date
ProofOfDeliveryDate Date (Proof of Delivery)
BillingDocumentDate Billing Date
Column Name Description
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? 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
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
TransportationPlanningStatus Transportation Planning Status (Header) Show values
OverallDelivReltdBillgStatus Delivery-Related Billing Status (All Items) Show values
OverallGoodsMovementStatus Goods Movement Status (All Items) Show values
OverallWarehouseActivityStatus Warehouse Management Status (All Items) Show values
OverallProofOfDeliveryStatus POD Status on Header Level Show values
OverallPackingStatus Packing Status (All Items) Show values
OverallPickingStatus Picking Status/Putaway Status (All Items) Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
HeaderPackingIncompletionSts Packing Incompletion Status (Header) Show values
HeaderPickgIncompletionStatus Picking/Putaway Incompletion Status (Header) Show values
HdrGoodsMvtIncompletionStatus Goods Movement Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
OvrlItmPackingIncompletionSts Packing Incompletion Status (All Items) Show values
OvrlItmPickingIncompletionSts Picking/Putaway Incompletion Status (All Items) Show values
OvrlItmGdsMvtIncompletionSts Goods Movement 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
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
Column Name Description Domain name
ShippingPointName Description TEXT30
TotalNumberOfPackage Total Number of Packages in Delivery ANZPK
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 Ship-to Party TEXT80
ShipToPartyAddressID Address ADRNR
ShipToPartyFormattedAddress Ship-to Party: Formatted Address
ShipToPartyCountryName Ship-to Party Country or Region TEXT50
DeliveryBlockReasonCriticality null
CentralCreditChkStsCriticality null
PaytAuthCrdtChkStsCriticality null
FinDocCrdtCheckStsCriticality null
ExprtInsurCrdtChkStsCritlty null
HdrGenIncompltnStsCriticality null
HdrDelivIncompltnStsCritlty null
HdrPickingIncompltnStsCritlty null
HdrPackgIncompltnStsCritlty null
HdrGdsMvtIncompltnStsCritlty null
HdrBillgIncompltnStsCritlty null
OvrlItmGenIncompltnStsCritlty null
OvrlItmDelivIncompltnCritlty null
OvrlItmPickingIncompltnCritlty null
OvrlItmPackgIncompltnCritlty null
OvrlItmGdsMvtIncompltnCritlty null
OvrlDelivReltdBillgStsCritlty null
TransportationPlngStsCritlty null
OverallPickingStsCriticality null
OvrlGdsMovementStsCriticality null
OvrlChmlCmplncStsCriticality null
OvrlDngrsGdsStsCriticality null
OvrlSftyDataSheetStsCritlty null
Master Data Relations Join Conditions
Person Number
  • ?
  • ?
  • Person Number
  • Person Number
  • Client
  • C_SLSDOCFLFMTDELIVDOC.[column in domain "AD_NATION"] == ADRP.NATION
  • C_SLSDOCFLFMTDELIVDOC.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • C_SLSDOCFLFMTDELIVDOC.ADDRESSPERSONID == ADRP.PERSNUMBER
  • C_SLSDOCFLFMTDELIVDOC.SHIPTOPARTYADDRESSPERSONID == ADRP.PERSNUMBER
  • C_SLSDOCFLFMTDELIVDOC.MANDT == ADRP.CLIENT
Customer Classification
  • Client
  • Customer Classification
  • C_SLSDOCFLFMTDELIVDOC.MANDT == TKUKL.MANDT
  • C_SLSDOCFLFMTDELIVDOC.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SLSDOCFLFMTDELIVDOC.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SLSDOCFLFMTDELIVDOC.MANDT == TVLS.MANDT
Delivery Type
  • Delivery Type
  • Client
  • C_SLSDOCFLFMTDELIVDOC.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • C_SLSDOCFLFMTDELIVDOC.MANDT == TVLK.MANDT
Weight Unit
  • Client
  • Weight Unit
  • C_SLSDOCFLFMTDELIVDOC.MANDT == T006.MANDT
  • C_SLSDOCFLFMTDELIVDOC.HEADERWEIGHTUNIT == T006.MSEHI
Sales Organization
  • Client
  • Sales Organization
  • C_SLSDOCFLFMTDELIVDOC.MANDT == TVKO.MANDT
  • C_SLSDOCFLFMTDELIVDOC.SALESORGANIZATION == TVKO.VKORG
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_SLSDOCFLFMTDELIVDOC.MANDT == TVSB.MANDT
  • C_SLSDOCFLFMTDELIVDOC.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_SLSDOCFLFMTDELIVDOC.MANDT == TVST.MANDT
  • C_SLSDOCFLFMTDELIVDOC.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Shipping Type
  • Client
  • C_SLSDOCFLFMTDELIVDOC.SHIPPINGTYPE == T173.VSART
  • C_SLSDOCFLFMTDELIVDOC.MANDT == T173.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • C_SLSDOCFLFMTDELIVDOC.SHIPTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTDELIVDOC.MANDT == KNA1.MANDT
Person Number
  • ?
  • ?
  • Person Number
  • Person Number
  • Client
  • C_SLSDOCFLFMTDELIVDOC.[column in domain "AD_NATION"] == ADRP.NATION
  • C_SLSDOCFLFMTDELIVDOC.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • C_SLSDOCFLFMTDELIVDOC.ADDRESSPERSONID == ADRP.PERSNUMBER
  • C_SLSDOCFLFMTDELIVDOC.SHIPTOPARTYADDRESSPERSONID == ADRP.PERSNUMBER
  • C_SLSDOCFLFMTDELIVDOC.MANDT == ADRP.CLIENT
Country key
  • Ship-to Party Country or Region
  • Client
  • C_SLSDOCFLFMTDELIVDOC.SHIPTOPARTYCOUNTRY == T005.LAND1
  • C_SLSDOCFLFMTDELIVDOC.MANDT == T005.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_SLSDOCFLFMTDELIVDOC.SOLDTOPARTY == KNA1.KUNNR
  • C_SLSDOCFLFMTDELIVDOC.MANDT == KNA1.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • C_SLSDOCFLFMTDELIVDOC.MANDT == TCURC.MANDT
  • C_SLSDOCFLFMTDELIVDOC.TRANSACTIONCURRENCY == TCURC.WAERS