C_SlsDocItemPrdtdDelivDelay

Predicted Delivery Delay | view: CPRDTDELIVDELAY | Extraction: Not supported | Component: Sales Analytics

Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, MAKT, MDLV, T001W, TVSTT, T001L, CVI_VEND_LINK

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities (2)
📅 Dates (2)
☰ Categorical (9)
Other (19)
🔗 Relations (18)

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
PlannedDeliveryCreationDate	Planned Delivery Creation Date of Confirmed Schedule Lines
RequestedDeliveryDate	Requested Delivery Date

Column Name	Description
TotalPrdtdDelivDelaySts	Overall Predicted Delivery Delay Status	Show values
DeliveryBlockStatus	Delivery Block Status (Item)	Show values
DeliveryConfirmationStatus	Delivery Confirmation Status (Item)	Show values
TotalCreditCheckStatus	Overall Status of Credit Checks	Show values
ItemGeneralIncompletionStatus	Incompletion Status (Item)	Show values
ItemDeliveryIncompletionStatus	Delivery Incompletion Status (Item)	Show values
HdrGeneralIncompletionStatus	Incompletion Status (Header)	Show values
HeaderDelivIncompletionStatus	Delivery Incompletion Status (Header)	Show values
OverallDeliveryBlockStatus	Overall Delivery Block Status (All Items)	Show values

Column Name	Description	Domain name
NmbrOfSlsDocItems	Number of Sales Document Items
PrdtdDelivCrtnDelayInDays	Predicted Delay of Delivery Creation in Days
PrdtdDelivCrtnDelayConfidence	Confidence (-/+ Days) of Predicted Delivery Creation Delay
PrdtdDelivProcgDelayInDays	Predicted Delay of Delivery Processing in Days
TotPrdtdDelivDelayStsCritlty	null
SemanticObject	null
MaterialName	Material Description	TEXT40
Plant	Plant (Own or External)	WERKS
PlantName	Plant Name	TEXT30
MRPArea	MRP Area	BERID
MRPAreaText	MRP Area Text	BERTX
SoldToPartyName	Name of Sold-to Party	TEXT80
SalesDocumentItemText	Short text for sales order item	TEXT40
CustomerPaymentTerms	Terms of payment key	ZTERM
ShippingPointName	Description	TEXT30
StorageLocationName	Storage Location Name	TEXT16
OrganizationBPName1	Name 1	NAME
OrganizationBPName2	Name 2	NAME
PurchaseOrderByCustomer	Customer Reference	BSTKD

Master Data Relations	Join Conditions
Batch Number Client Batch Number Product Number Plant (Own or External)	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == MCHA.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.BATCH == MCHA.CHARG` `C_SLSDOCITEMPRDTDDELIVDELAY.MATERIAL == MCHA.MATNR` `C_SLSDOCITEMPRDTDDELIVDELAY.PLANT == MCHA.WERKS`
Delivery Block (Document Header) Client Delivery Block (Document Header)	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == TVLS.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.DELIVERYBLOCKREASON == TVLS.LIFSP`
Distribution channel in order header Client Distribution Channel Sales Organization	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == TVKOV.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `C_SLSDOCITEMPRDTDDELIVDELAY.SALESORGANIZATION == TVKOV.VKORG`
Material: order item Client Product Number	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == MARA.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.MATERIAL == MARA.MATNR`
Product Group Client Product Group	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == T023.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.MATERIALGROUP == T023.MATKL`
Sales unit Client Sales unit	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == T006.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.ORDERQUANTITYUNIT == T006.MSEHI`
Division in order header Client Distribution Channel Division Sales Organization	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == TVTA.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `C_SLSDOCITEMPRDTDDELIVDELAY.ORGANIZATIONDIVISION == TVTA.SPART` `C_SLSDOCITEMPRDTDDELIVDELAY.SALESORGANIZATION == TVTA.VKORG`
Route Client Route	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == TVRO.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.ROUTE == TVRO.ROUTE`
Sales document item category Client Sales document item category	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == TVPT.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV`
Order type in order header Client Sales Document Type	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == TVAK.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.SALESDOCUMENTTYPE == TVAK.AUART`
Sales group Client Sales office Sales group	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == TVBVK.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.SALESOFFICE == TVBVK.VKBUR` `C_SLSDOCITEMPRDTDDELIVDELAY.SALESGROUP == TVBVK.VKGRP`
Sales organization in order header Client Sales Organization	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == TVKO.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.SALESORGANIZATION == TVKO.VKORG`
Shipping Point / Receiving Point Client Shipping Point / Receiving Point	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == TVST.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.SHIPPINGPOINT == TVST.VSTEL`
Sold-to Party Client Sold-to Party	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == KNA1.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.SOLDTOPARTY == KNA1.KUNNR`
Storage location Storage location Client Plant (Own or External)	`C_SLSDOCITEMPRDTDDELIVDELAY.STORAGELOCATION == T001L.LGORT` `C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == T001L.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.PLANT == T001L.WERKS`
SD Document Currency Client SD Document Currency	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == TCURC.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.TRANSACTIONCURRENCY == TCURC.WAERS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Sales office Client Sales office Distribution Channel Division Sales Organization	`C_SLSDOCITEMPRDTDDELIVDELAY.MANDT == TVKBZ.MANDT` `C_SLSDOCITEMPRDTDDELIVDELAY.SALESOFFICE == TVKBZ.VKBUR` `C_SLSDOCITEMPRDTDDELIVDELAY.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG` `C_SLSDOCITEMPRDTDDELIVDELAY.ORGANIZATIONDIVISION == TVKBZ.SPART` `C_SLSDOCITEMPRDTDDELIVDELAY.SALESORGANIZATION == TVKBZ.VKORG`