C_SlsDocItemOverdueDeliv

Sales Doc Item Delivery Issue | view: CSLSDOCITEMSO05 | Extraction: Not supported | Component: Sales Analytics
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
RequestedQuantity Requested Quantity
📏 Sales unit (OrderQuantityUnit):
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
Column Name Description
DueDate Due Date
RequestedDeliveryDate Requested Delivery Date
DeliveryCreationDate Planned Delivery Creation Date of Confirmed Schedule Lines
Column Name Description
TotalDeliveryStatus Overall Delivery Status (Item) Show values
DeliveryStatus Delivery Status (Item) Show values
SDProcessStatus Overall Processing Status (Item) Show values
PurchaseConfirmationStatus Purchasing Confirmation Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
ChmlCmplncStatus Product Marketability Status (Item) Show values
DangerousGoodsStatus Dangerous Goods Status (Item) Show values
SafetyDataSheetStatus Safety Data Sheet Status (Item) Show values
TrdCmplncEmbargoSts Embargo Status (Item) Show values
TrdCmplncSnctndListChkSts Screening Status (Item) Show values
OvrlTrdCmplncLegalCtrlChkSts Legal Control Status (All Schedule Lines) Show values
Column Name Description Domain name
DueDays Next Action in Days DUE_DAYS
MaterialName Material Description TEXT40
Plant Plant (Own or External) WERKS
MaterialByCustomer Material Number Used by Customer IDNEX
SalesDocumentItemText Short text for sales order item TEXT40
ShippingPointName Description TEXT30
ShippingPointCountry Shipping Point Country or Region LAND1
ShippingPointCountryName Shipping Point Country or Region TEXT50
ShipFromPartyCountryName Ship-to Party Country or Region TEXT50
ShipToParty Ship-to Party KUNNR
ShipToPartyName Name of Ship-to Party TEXT80
ShipToPartyCountry Ship-to Party Country or Region LAND1
ShipToPartyCountryName Ship-to Party Country or Region TEXT50
PrdtdDelivCrtnDelayInDays Predicted Delay of Delivery Creation in Days
PrdtdDelivCrtnDelayConfidence Confidence (-/+ Days) of Predicted Delivery Creation Delay
PrdtdDelivProcgDelayInDays Predicted Delay of Delivery Processing in Days
TotalDeliveryStatusCriticality null
ChmlCmplncStsCriticality null
DngrsGdsStsCriticality null
Master Data Relations Join Conditions
Batch Number
  • Plant (Own or External)
  • Batch Number
  • Client
  • Product Number
  • C_SLSDOCITEMOVERDUEDELIV.PLANT == MCHA.WERKS
  • C_SLSDOCITEMOVERDUEDELIV.BATCH == MCHA.CHARG
  • C_SLSDOCITEMOVERDUEDELIV.MANDT == MCHA.MANDT
  • C_SLSDOCITEMOVERDUEDELIV.MATERIAL == MCHA.MATNR
Material: order item
  • Client
  • Product Number
  • C_SLSDOCITEMOVERDUEDELIV.MANDT == MARA.MANDT
  • C_SLSDOCITEMOVERDUEDELIV.MATERIAL == MARA.MATNR
Product Group
  • Client
  • Product Group
  • C_SLSDOCITEMOVERDUEDELIV.MANDT == T023.MANDT
  • C_SLSDOCITEMOVERDUEDELIV.MATERIALGROUP == T023.MATKL
Sales unit
  • Sales unit
  • Client
  • C_SLSDOCITEMOVERDUEDELIV.ORDERQUANTITYUNIT == T006.MSEHI
  • C_SLSDOCITEMOVERDUEDELIV.MANDT == T006.MANDT
Sales document item category
  • Client
  • Sales document item category
  • C_SLSDOCITEMOVERDUEDELIV.MANDT == TVPT.MANDT
  • C_SLSDOCITEMOVERDUEDELIV.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Country key
  • Ship-from Party Country or Region
  • Client
  • C_SLSDOCITEMOVERDUEDELIV.SHIPFROMPARTYCOUNTRY == T005.LAND1
  • C_SLSDOCITEMOVERDUEDELIV.MANDT == T005.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_SLSDOCITEMOVERDUEDELIV.SHIPPINGPOINT == TVST.VSTEL
  • C_SLSDOCITEMOVERDUEDELIV.MANDT == TVST.MANDT
Storage location
  • Storage location
  • Plant (Own or External)
  • Client
  • C_SLSDOCITEMOVERDUEDELIV.STORAGELOCATION == T001L.LGORT
  • C_SLSDOCITEMOVERDUEDELIV.PLANT == T001L.WERKS
  • C_SLSDOCITEMOVERDUEDELIV.MANDT == T001L.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • C_SLSDOCITEMOVERDUEDELIV.MANDT == TCURC.MANDT
  • C_SLSDOCITEMOVERDUEDELIV.TRANSACTIONCURRENCY == TCURC.WAERS