P_PrdtdDelivProcgDlyTrngData

Predicted Delivery Processing Delay Training Data | view: PDELIVPROCGPTD | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, SCAL_TT_DATE, LIKP, LIPS, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, CVI_VEND_LINK
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
NetPriceAmount Net Price
Subtotal1Amount Subtotal 1 from Pricing Procedure for Price Element
Subtotal2Amount Subtotal 2 from Pricing Procedure for Price Element
Subtotal3Amount Subtotal 3 from Pricing Procedure for Price Element
Subtotal4Amount Subtotal 4 from Pricing Procedure for Price Element
Subtotal5Amount Subtotal 5 from Pricing Procedure for Price Element
Subtotal6Amount Subtotal 6 from Pricing Procedure for Price Element
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
TargetDelivQtyInOrderQtyUnit Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines)
📏 Base Unit of Measure (BaseUnit):
ConfdDeliveryQtyInBaseUnit Cumulative Confirmed Quantity in Base Unit
RequestedQuantityInBaseUnit Requested Order Quantity in Base Unit
MinDeliveryQtyInBaseUnit Minimum Delivery Quantity in Delivery Note Processing
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
RequestedQuantity Requested Quantity
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross Weight of the Item
ItemNetWeight Net Weight of the Item
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume of the item
Column Name Description
ItemCreationDate Date on which the record was created
ItemCreationTime Time at Which Record Was Created
ItemLastChangeDate Last Changed On
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
SalesDocumentDate Document Date (Date Received/Sent)
Column Name Description
SDDocumentCategory SD Document Category Show values
SalesDocumentItemType Item Type Show values
CompletionRule Completion Rule for Quotation / Contract Show values
SalesDocumentProcessingType SD document indicator Show values
QuantityIsFixed Quantity is fixed Show values
DeliveryDateQuantityIsFixed Delivery Date and Quantity Fixed Show values
PartialDeliveryIsAllowed Partial Delivery at Item Level Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
OpenDeliveryLeadingUnitCode ID: Leading unit of measure for completing a transaction Show values
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
Column Name Description Domain name
DelivProcgDelayInDays Delivery Processing Delay in Days
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
ItemCreationDateYear Year of Creation NUM4
ItemCreationCalendarMonth Month of Creation NUM2
ItemCreationCalendarWeek Week of Creation NUM2
MaterialByCustomer Material Number Used by Customer IDNEX
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
ProductConfiguration Configuration CUOBJ
MRPArea MRP Area BERID
BillOfMaterial Bill of Material STNUM
ShipToParty Ship-to Party KUNNR
SalesDocumentItemText Short text for sales order item TEXT40
RequirementSegment Requirement Segment SGT_SRCA
NetPriceQuantity Condition Pricing Unit KPEIN
Plant Plant (Own or External) WERKS
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
MaxNmbrOfPartialDelivery Number of Allowed Partial Deliveries ANTLF
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
ShippingGroupNumber PSST Group RFM_PSST_GROUP_ID
ShippingGroupRule PSST Grouping Rule RFM_PSST_RULE
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
ProfitCenter Profit Center PRCTR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
CostCenter Cost Center KOSTL
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVV1.MANDT
Customer Group 2
  • Client
  • Customer Group 2
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVV2.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVV5.MANDT
Material Group 1
  • Material Group 1
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVM1.MANDT
Material Group 2
  • Client
  • Material Group 2
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVM2.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVM3.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Material Group 4
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVM4.MANDT
Material Group 5
  • Client
  • Material Group 5
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVM5.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.BASEUNIT == T006.MSEHI
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T006.MANDT
Batch Number
  • Batch Number
  • Client
  • Material Number
  • Plant (Own or External)
  • P_PRDTDDELIVPROCGDLYTRNGDATA.BATCH == MCHA.CHARG
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == MCHA.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MATERIAL == MCHA.MATNR
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PLANT == MCHA.WERKS
Business Area
  • Business Area
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.BUSINESSAREA == TGSB.GSBER
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TGSB.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TKA01.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.CONTROLLINGAREA == TKA01.KOKRS
Credit control area
  • Client
  • Credit control area
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T014.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.CREDITCONTROLAREA == T014.KKBER
Customer Group
  • Customer Group
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.CUSTOMERGROUP == T151.KDGRP
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T151.MANDT
Delivery Priority
  • Client
  • Delivery Priority
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TPRIO.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.DELIVERYPRIORITY == TPRIO.LPRIO
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SALESORGANIZATION == TVKOV.VKORG
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVKOV.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Client
  • Organization Division
  • Division
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TSPA.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ORGANIZATIONDIVISION == TSPA.SPART
  • P_PRDTDDELIVPROCGDLYTRNGDATA.DIVISION == TSPA.SPART
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.INCOTERMSCLASSIFICATION == TINC.INCO1
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TINC.MANDT
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T148.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Volume unit
  • Volume unit
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ITEMVOLUMEUNIT == T006.MSEHI
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T006.MANDT
Weight Unit
  • Weight Unit
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ITEMWEIGHTUNIT == T006.MSEHI
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T006.MANDT
Material: order item
  • Client
  • Material Number
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == MARA.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MATERIALGROUP == T023.MATKL
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T023.MANDT
Material Price Group
  • Material Price Group
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MATERIALPRICINGGROUP == T178.KONDM
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T178.MANDT
Reason for material substitution
  • Client
  • Reason for material substitution
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVSU.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MATERIALSUBSTITUTIONREASON == TVSU.SUGRD
Condition Unit
  • Condition Unit
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.NETPRICEQUANTITYUNIT == T006.MSEHI
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T006.MANDT
Order Number
  • Client
  • Order Number
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == AUFK.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ORDERID == AUFK.AUFNR
Sales unit
  • Client
  • Sales unit
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T006.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ORDERQUANTITYUNIT == T006.MSEHI
Division in order header
  • Sales Organization
  • Client
  • Organization Division
  • Division
  • Distribution Channel
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SALESORGANIZATION == TVTA.VKORG
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVTA.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ORGANIZATIONDIVISION == TVTA.SPART
  • P_PRDTDDELIVPROCGDLYTRNGDATA.DIVISION == TVTA.SPART
  • P_PRDTDDELIVPROCGDLYTRNGDATA.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Material Entered
  • Client
  • Material Entered
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == MARA.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Payment Method
  • ?
  • Payment Method
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.[column in domain "LAND1"] == T042Z.LAND1
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PAYMENTMETHOD == T042Z.ZLSCH
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T042Z.MANDT
Checking Group for Availability Check
  • Checking Group for Availability Check
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PRODAVAILABILITYCHECKGROUP == TMVF.MTVFP
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TMVF.MANDT
Product Catalog
  • Client
  • Product catalog number
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == WWMI.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PRODUCTCATALOG == WWMI.WMINR
Fashion Collection
  • Fashion Collection
  • Season Year
  • Season
  • Client
Product hierarchy: order item
  • Product hierarchy
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PRODUCTHIERARCHYNODE == T179.PRODH
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T179.MANDT
Season
  • Season Year
  • Season
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season Year
  • Season
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Fashion Collection
  • Season Year
  • Season
  • Client
  • Fashion Theme
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == FSH_THEMES.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PRODUCTTHEME == FSH_THEMES.FSH_THEME
Retail promotion
  • Retail Promotion
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.RETAILPROMOTION == WAKH.AKTNR
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == WAKH.MANDT
Route
  • Client
  • Route
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVRO.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ROUTE == TVRO.ROUTE
Sales Deal
  • Client
  • Sales Deal
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == KONA.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SALESDEAL == KONA.KNUMA
Sales District
  • Sales District
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SALESDISTRICT == T171.BZIRK
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T171.MANDT
Sales document item category
  • Client
  • Sales document item category
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVPT.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Order type in order header
  • Sales Document Type
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SALESDOCUMENTTYPE == TVAK.AUART
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVAK.MANDT
Sales group
  • Client
  • Sales group
  • Sales office
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVBVK.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SALESGROUP == TVBVK.VKGRP
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Sales Organization
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SALESORGANIZATION == TVKO.VKORG
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVKO.MANDT
Sales Promotion
  • Client
  • Sales Promotion
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == KONA.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SALESPROMOTION == KONA.KNUMA
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SDDOCUMENTREASON == TVAU.AUGRU
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVAU.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SHIPPINGCONDITION == TVSB.VSBED
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVSB.MANDT
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVST.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Shipping Type
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SHIPPINGTYPE == T173.VSART
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T173.MANDT
Sold-to Party
  • Client
  • Sold-to Party
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == KNA1.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SOLDTOPARTY == KNA1.KUNNR
Storage location
  • Storage location
  • Client
  • Plant (Own or External)
  • P_PRDTDDELIVPROCGDLYTRNGDATA.STORAGELOCATION == T001L.LGORT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == T001L.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.PLANT == T001L.WERKS
SD Document Currency
  • SD Document Currency
  • Client
  • P_PRDTDDELIVPROCGDLYTRNGDATA.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Client
  • Organization Division
  • Division
  • Sales office
  • Distribution Channel
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SALESORGANIZATION == TVKBZ.VKORG
  • P_PRDTDDELIVPROCGDLYTRNGDATA.MANDT == TVKBZ.MANDT
  • P_PRDTDDELIVPROCGDLYTRNGDATA.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_PRDTDDELIVPROCGDLYTRNGDATA.DIVISION == TVKBZ.SPART
  • P_PRDTDDELIVPROCGDLYTRNGDATA.SALESOFFICE == TVKBZ.VKBUR
  • P_PRDTDDELIVPROCGDLYTRNGDATA.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG