C_SlsOrdFlfmtDeliveryDocQ

SOFM Delivery Document Query | view: CSOFDELIVDOCQ | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAPLIKPLIPSVBAKVBAPVBKDVEDATVFSTVFSTKNA1TVLSTVLSTTINCTINCTTVSBTVSBTTVSTTVSTTT173T173TTVBSTTVBSTTVBSTTVBSTTVBSTTVBSTTVBSTTVBSTTVBSTTVBSTTVBSTTVBSTTVBSTTVBSTTVBSTTVBST
Column Name Description
OutboundDelivery Outbound Delivery
Column Name Description
💲 SD Document Currency (TransactionCurrency):
ActualDeliveryAmount Invoice amount of a non-invoiced delivery
Column Name Description
📏 Weight Unit (HeaderWeightUnit):
HeaderGrossWeight Total Weight
HeaderNetWeight Net weight
Column Name Description
PickingDate Picking Date
DeliveryDate Delivery Date
TransportationPlanningDate Transportation Planning Date
PlannedGoodsIssueDate Planned Goods Movement Date
ActualGoodsMovementDate Actual Goods Movement Date
BillingDocumentDate Billing Date
Column Name Description
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallPickingStatus Picking Status/Putaway Status (All Items) Show values
OverallWarehouseActivityStatus Status of Warehouse Management Activities (All Items) Show values
OverallGoodsMovementStatus Goods Movement Status (All Items) Show values
OverallPackingStatus Packing Status (All Items) Show values
TransportationPlanningStatus Transportation Planning Status (Header) Show values
HdrGeneralIncompletionStatus 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
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
HdrGoodsMvtIncompletionStatus Goods Movement 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
Column Name Description Domain name
ShippingPointName Description TEXT30
DeliveryBlockReasonText Description TEXT20
TotalNumberOfPackage Total Number of Packages in Delivery ANZPK
SoldToParty Sold-to Party KUNNR
SoldToPartyName Name of Sold-to Party TEXT80
ShipToParty Ship-to Party KUNNR
ShipToPartyName Name of Ship-to Party TEXT80
ShippingTypeName Shipping Type Description TEXT20
ShippingConditionName Shipping Conditions Description TEXT20
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsClassificationName Description TEXT30
BillingBlockReasonDescription Billing Block Description TEXT20
OverallSDProcessStatusDesc Status Description TEXT20
OverallPickingStatusDesc Status Description TEXT20
OvrlWarehouseActyStatusDesc Status Description TEXT20
OverallGoodsMovementStatusDesc Status Description TEXT20
OverallPackingStatusDesc Status Description TEXT20
TransportationPlanningStsDesc Status Description TEXT20
HdrGenIncompletionStatusDesc General Incompletion Status Description (Header) TEXT20
HdrBillgIncompletionStatusDesc Billing Incompletion Status Description (Header) TEXT20
HdrPackingIncompltnStatusDesc Status Description TEXT20
HdrPickgIncompltnStatusDesc Status Description TEXT20
HdrDelivIncompletionStatusDesc Delivery Incompletion Status Description (Header) TEXT20
HdrGoodsMvtIncompltnStatusDesc Status Description TEXT20
FinDocCreditCheckStatusDesc Status Description TEXT20
ExprtInsurCreditCheckStsDesc Status Description TEXT20
PaytAuthsnCreditCheckStsDesc Status of Credit Check Against Payment Card Authzn Desc. TEXT20
CentralCreditCheckStatusDesc Status Description TEXT20
Master Data Relations Join Conditions
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SLSORDFLFMTDELIVERYDOCQ.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SLSORDFLFMTDELIVERYDOCQ.MANDT == TVLS.MANDT
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • C_SLSORDFLFMTDELIVERYDOCQ.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SLSORDFLFMTDELIVERYDOCQ.MANDT == TVFS.MANDT
Weight Unit
  • Weight Unit
  • Client
  • C_SLSORDFLFMTDELIVERYDOCQ.HEADERWEIGHTUNIT == T006.MSEHI
  • C_SLSORDFLFMTDELIVERYDOCQ.MANDT == T006.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_SLSORDFLFMTDELIVERYDOCQ.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_SLSORDFLFMTDELIVERYDOCQ.MANDT == TINC.MANDT
Sales Organization
  • Client
  • Sales Organization
  • C_SLSORDFLFMTDELIVERYDOCQ.MANDT == TVKO.MANDT
  • C_SLSORDFLFMTDELIVERYDOCQ.SALESORGANIZATION == TVKO.VKORG
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_SLSORDFLFMTDELIVERYDOCQ.MANDT == TVSB.MANDT
  • C_SLSORDFLFMTDELIVERYDOCQ.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_SLSORDFLFMTDELIVERYDOCQ.MANDT == TVST.MANDT
  • C_SLSORDFLFMTDELIVERYDOCQ.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Shipping Type
  • Client
  • C_SLSORDFLFMTDELIVERYDOCQ.SHIPPINGTYPE == T173.VSART
  • C_SLSORDFLFMTDELIVERYDOCQ.MANDT == T173.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • C_SLSORDFLFMTDELIVERYDOCQ.MANDT == TCURC.MANDT
  • C_SLSORDFLFMTDELIVERYDOCQ.TRANSACTIONCURRENCY == TCURC.WAERS