P_SupplierDeliveryPrediction

Supplier Delivery Prediction | view: PSUPLRDELPRED | Extraction: Not supported | Component: Purchase Orders
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem FK Item Number of Purchasing Document
ScheduleLine Delivery Schedule Line Counter
Column Name Description
Column Name Description
PurchaseOrderItemQty Purchase Order Quantity
prev_quant_w_sum null
prev_quant_w_min null
prev_quant_w_max null
prev_quant_m_sum null
prev_quant_m_min null
prev_quant_m_max null
diff_w_sum_quant null
diff_w_min_quant null
diff_w_max_quant null
diff_m_sum_quant null
diff_m_min_quant null
diff_m_max_quant null
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
ScheduleLineOrderQuantity Scheduled Quantity
Column Name Description
PurchaseOrderDate Purchase Order Date
SchedLineStscDeliveryDate Statistics-Relevant Delivery Date
LastPostingDateOfMaterialDoc null
Column Name Description
PurgDocMigrtnIsCmpltdForAnlyts Indicator for Data Migration of Schedule Line Show values
Column Name Description Domain name
MRPRelevantMaterial null
MaterialClassification ABC Indicator MAABC
POIncotermsTransferLocation Incoterms (Part 2) INCO2
POIncotermsLocation1 Incoterms Location 1 INCO_L
POIncotermsLocation2 Incoterms Location 2 INCO_L
ItemIncotermsTransferLocation Incoterms (Part 2) INCO2
ItemIncotermsLocation1 Incoterms Location 1 INCO_L
ItemIncotermsLocation2 Incoterms Location 2 INCO_L
ExpectedNoOfDays null
ActualNoOfDays null
DelayInNoOfDays null
DeliveryBehavior null
SupplierPlant null
WeekNumber Calendar Week NUM2
PreviousWeekNumber null
CreatedMonth Calendar Month NUM2
PreviousMonthNumber null
GoodsReceiptMaterialDocYear Calendar Year NUM4
diff_create_giposting null
diff_giposting null
diff_create null
running_w_count null
running_quant_w_sum null
running_quant_w_min null
running_quant_w_avg null
running_quant_w_max null
running_diff1_w_min null
running_diff1_w_avg null
running_diff1_w_max null
running_diff2_w_min null
running_diff2_w_avg null
running_diff2_w_max null
running_m_count null
running_quant_m_sum null
running_quant_m_min null
running_quant_m_avg null
running_quant_m_max null
running_diff1_m_min null
running_diff1_m_avg null
running_diff1_m_max null
running_diff2_m_min null
running_diff2_m_avg null
running_diff2_m_max null
PreviousWeek null
prev_w_count null
prev_quant_w_avg null
prev_diff1_w_sum null
prev_diff1_w_max null
prev_diff1_w_min null
prev_diff1_w_avg null
prev_diff2_w_sum null
prev_diff2_w_max null
prev_diff2_w_min null
prev_diff_w_avg null
PreviousMonth null
prev_m_count null
prev_quant_m_avg null
prev_diff1_m_sum null
prev_diff1_m_max null
prev_diff1_m_min null
prev_diff1_m_avg null
prev_diff2_m_sum null
prev_diff2_m_max null
prev_diff2_m_min null
prev_diff2_m_avg null
diff_w_count null
diff_w_avg_quant null
running_diff1_w_sum null
diff_w_max_diff1 null
diff_w_min_diff1 null
diff_w_avg_diff1 null
running_diff2_w_sum null
diff_w_max_diff2 null
diff_w_min_diff2 null
diff_w_avg_diff2 null
diff_m_count null
diff_m_avg_quant null
running_diff1_m_sum null
diff_m_max_diff1 null
diff_m_min_diff1 null
diff_m_avg_diff1 null
running_diff2_m_sum null
diff_m_max_diff2 null
diff_m_min_diff2 null
diff_m_avg_diff2 null
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • P_SUPPLIERDELIVERYPREDICTION.MANDT == T163K.MANDT
  • P_SUPPLIERDELIVERYPREDICTION.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • P_SUPPLIERDELIVERYPREDICTION.POINCOTERMSCLASSIFICATION == TINC.INCO1
  • P_SUPPLIERDELIVERYPREDICTION.ITEMINCOTERMSCLASSIFICATION == TINC.INCO1
  • P_SUPPLIERDELIVERYPREDICTION.MANDT == TINC.MANDT
Material Number
  • Material Number
  • Client
  • P_SUPPLIERDELIVERYPREDICTION.MATERIAL == MARA.MATNR
  • P_SUPPLIERDELIVERYPREDICTION.MANDT == MARA.MANDT
Unit of Measure
  • Base Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_SUPPLIERDELIVERYPREDICTION.MATERIALBASEUNIT == T006.MSEHI
  • P_SUPPLIERDELIVERYPREDICTION.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_SUPPLIERDELIVERYPREDICTION.MANDT == T006.MANDT
Material Group
  • Material Group
  • Client
  • P_SUPPLIERDELIVERYPREDICTION.MATERIALGROUP == T023.MATKL
  • P_SUPPLIERDELIVERYPREDICTION.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • P_SUPPLIERDELIVERYPREDICTION.PLANT == T001W.WERKS
  • P_SUPPLIERDELIVERYPREDICTION.MANDT == T001W.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • P_SUPPLIERDELIVERYPREDICTION.POINCOTERMSCLASSIFICATION == TINC.INCO1
  • P_SUPPLIERDELIVERYPREDICTION.ITEMINCOTERMSCLASSIFICATION == TINC.INCO1
  • P_SUPPLIERDELIVERYPREDICTION.MANDT == TINC.MANDT
Purchase Order Unit of Measure
  • Base Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_SUPPLIERDELIVERYPREDICTION.MATERIALBASEUNIT == T006.MSEHI
  • P_SUPPLIERDELIVERYPREDICTION.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_SUPPLIERDELIVERYPREDICTION.MANDT == T006.MANDT
Supplier
  • Client
  • Supplier
  • P_SUPPLIERDELIVERYPREDICTION.MANDT == LFA1.MANDT
  • P_SUPPLIERDELIVERYPREDICTION.SUPPLIER == LFA1.LIFNR
Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • P_SUPPLIERDELIVERYPREDICTION.SUPPLYINGPLANT == T001W.WERKS
  • P_SUPPLIERDELIVERYPREDICTION.MANDT == T001W.MANDT
x
  • Dimension key
  • Client
  • P_SUPPLIERDELIVERYPREDICTION.UNITOFMEASUREDIMENSION == T006D.DIMID
  • P_SUPPLIERDELIVERYPREDICTION.MANDT == T006D.MANDT