P_ProductOverdueSITPredict

Material Overdue SIT Prediction | view: POVERDUEPRED | TRAN | Extraction: Not supported | Component: Basis
Tables used: SCAL_TT_DATE, MATDOC, EKKO, EKPO, EKET, MARA, MARC, T001W
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
GoodsIssueMaterialDocument Number of Material Document
GoodsIssueMaterialDocumentItem Item in Material Document
GoodsIssueMaterialDocumentYear Fiscal Year
GoodsReceiptMaterialDocument Number of Material Document
GoodsReceiptMaterialDocItem Item in Material Document
GoodsReceiptMaterialDocYear Fiscal Year
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
Column Name Description
📏 Purchase Order Unit of Measure (BaseUnit):
PurchaseOrderItemQuantity Purchase Order Quantity
GoodsIssueQuantity Goods Issue Quantity
GoodsReceiptQuantity Goods Receipt Quantity
running_quant_m_sum Confirmed Quantity
running_quant_m_min Confirmed Quantity
running_quant_m_max Confirmed Quantity
prev_quant_m_sum Confirmed Quantity
prev_quant_m_min Confirmed Quantity
prev_quant_m_max Confirmed Quantity
running_quant_w_sum Confirmed Quantity
running_quant_w_min Confirmed Quantity
running_quant_w_max Confirmed Quantity
prev_quant_w_sum Confirmed Quantity
prev_quant_w_min Confirmed Quantity
prev_quant_w_max Confirmed Quantity
running_rpm_quant_m_sum Confirmed Quantity
running_rpm_quant_m_min Confirmed Quantity
running_rpm_quant_m_max Confirmed Quantity
prev_rpm_quant_m_sum Confirmed Quantity
prev_rpm_quant_m_min Confirmed Quantity
prev_rpm_quant_m_max Confirmed Quantity
running_rpm_quant_w_sum Confirmed Quantity
running_rpm_quant_w_min Confirmed Quantity
running_rpm_quant_w_max Confirmed Quantity
prev_rpm_quant_w_sum Confirmed Quantity
prev_rpm_quant_w_min Confirmed Quantity
prev_rpm_quant_w_max Confirmed Quantity
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
📏 Volume unit (VolumeUnit):
MaterialVolume Volume
Column Name Description
CreationDate Creation Date of Purchasing Document
GoodsIssuePostingDate Posting Date in the Document
GoodsReceiptPostingDate Posting Date in the Document
LastPostingDateOfMaterialDoc Date
ScheduleLineDeliveryDate Item delivery date
creationdate_2 Creation Date of Purchasing Document
ProductCreationDate Created On
CrossPlantStatusValidityDate Date from which the cross-plant material status is valid
SalesStatusValidityDate Date from which the X-distr.-chain material status is valid
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
StockInTransitProcessType SIT Process Type Show values
Column Name Description Domain name
IssuingPlantName Name TEXT30
CreatedByUser User of person who created a purchasing document USNAM
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
MaterialName Material Description TEXT40
DifferenceOfGRAndGIDate Delta of GR Date and GI Date
UnitOfMeasure 3-Byte field CHAR3
GoodsIssueMovementType Movement Type of Goods Issue BWART
ReceivingPlant Receiving Plant WERKS
ReceivingPlantName Receiving Plant Name TEXT30
GoodsReceiptMovementType Movement Type of Goods Receipt BWART
ReceivingCompanyCode Receiving Company Code BUKRS
StorageLocation Storage location LGORT
Batch Batch Number CHARG
ScheduleLine Delivery Schedule Line Counter EETEN
target Predicted Deviation between Planned and Predicted Date NSDM_PRED_DEVIATION_IN_DAYS
both_plant Concatenate of Issuing and Receiving Plant CHAR10
rp_m null
create_month Calendar Month NUM2
week_number Calendar Week NUM2
running_m_count Calculated Count per Month
running_quant_m_avg null
running_diff1_m_sum null
running_diff1_m_min Calculated Difference1 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_diff1_m_avg null
running_diff1_m_max Calculated Difference1 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_diff2_m_sum null
running_diff2_m_min Calculated Difference2 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_diff2_m_avg null
running_diff2_m_max Calculated Difference2 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_m_count Calculated Count per Month
prev_quant_m_avg null
prev_diff1_m_sum null
prev_diff1_m_min Calculated Difference1 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_diff1_m_avg null
prev_diff1_m_max Calculated Difference1 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_diff2_m_sum null
prev_diff2_m_min Calculated Difference2 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_diff2_m_avg null
prev_diff2_m_max Calculated Difference2 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_w_count Calculated Count per Month
running_quant_w_avg null
running_diff1_w_sum null
running_diff1_w_min Calculated Difference1 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_diff1_w_avg null
running_diff1_w_max Calculated Difference1 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_diff2_w_sum null
running_diff2_w_min Calculated Difference2 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_diff2_w_avg null
running_diff2_w_max Calculated Difference2 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_w_count Calculated Count per Month
prev_quant_w_avg null
prev_diff1_w_sum null
prev_diff1_w_min Calculated Difference1 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_diff1_w_avg null
prev_diff1_w_max Calculated Difference1 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_diff2_w_sum null
prev_diff2_w_min Calculated Difference2 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_diff2_w_avg null
prev_diff2_w_max Calculated Difference2 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_rpm_m_count Calculated Count per Month
running_rpm_quant_m_avg null
running_rpm_diff1_m_sum null
running_rpm_diff1_m_min Calculated Difference1 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_rpm_diff1_m_avg null
running_rpm_diff1_m_max Calculated Difference1 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_rpm_diff2_m_sum null
running_rpm_diff2_m_min Calculated Difference2 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_rpm_diff2_m_avg null
running_rpm_diff2_m_max Calculated Difference2 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_rpm_m_count Calculated Count per Month
prev_rpm_quant_m_avg null
prev_rpm_diff1_m_sum null
prev_rpm_diff1_m_min Calculated Difference1 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_rpm_diff1_m_avg null
prev_rpm_diff1_m_max Calculated Difference1 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_rpm_diff2_m_sum null
prev_rpm_diff2_m_min Calculated Difference2 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_rpm_diff2_m_avg null
prev_rpm_diff2_m_max Calculated Difference2 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_rpm_w_count Calculated Count per Month
running_rpm_quant_w_avg null
running_rpm_diff1_w_sum null
running_rpm_diff1_w_min Calculated Difference1 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_rpm_diff1_w_avg null
running_rpm_diff1_w_max Calculated Difference1 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_rpm_diff2_w_sum null
running_rpm_diff2_w_min Calculated Difference2 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_rpm_diff2_w_avg null
running_rpm_diff2_w_max Calculated Difference2 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_rpm_w_count Calculated Count per Month
prev_rpm_quant_w_avg null
prev_rpm_diff1_w_sum null
prev_rpm_diff1_w_min Calculated Difference1 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_rpm_diff1_w_avg null
prev_rpm_diff1_w_max Calculated Difference1 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_rpm_diff2_w_sum null
prev_rpm_diff2_w_min Calculated Difference2 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
prev_rpm_diff2_w_avg null
prev_rpm_diff2_w_max Calculated Difference2 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
diff_w_count null
diff_w_avg_quant null
diff_w_sum_diff1 null
diff_w_min_diff1 null
diff_w_avg_diff1 null
diff_w_max_diff1 null
diff_w_sum_diff2 null
diff_w_min_diff2 null
diff_w_avg_diff2 null
diff_w_max_diff2 null
diff_m_count null
diff_m_avg_quant null
diff_m_sum_diff1 null
diff_m_min_diff1 null
diff_m_avg_diff1 null
diff_m_max_diff1 null
diff_m_sum_diff2 null
diff_m_min_diff2 null
diff_m_avg_diff2 null
diff_m_max_diff2 null
LowLevelCode Low-Level Code DISST
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_PRODUCTOVERDUESITPREDICT.MANDT == T006.MANDT
  • P_PRODUCTOVERDUESITPREDICT.BASEUNIT == T006.MSEHI
Currency Key
  • Currency Key
  • Client
  • P_PRODUCTOVERDUESITPREDICT.DOCUMENTCURRENCY == TCURC.WAERS
  • P_PRODUCTOVERDUESITPREDICT.MANDT == TCURC.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • P_PRODUCTOVERDUESITPREDICT.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • P_PRODUCTOVERDUESITPREDICT.MANDT == T148.MANDT
Default storage location for external procurement
  • Default storage location for external procurement
  • Default storage location for external procurement
  • Client
  • ?
  • P_PRODUCTOVERDUESITPREDICT.ISSPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT
  • P_PRODUCTOVERDUESITPREDICT.RECPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT
  • P_PRODUCTOVERDUESITPREDICT.MANDT == T001L.MANDT
  • P_PRODUCTOVERDUESITPREDICT.[column in domain "WERKS_D"] == T001L.WERKS
MRP controller
  • MRP Controller
  • MRP Controller
  • Client
  • ?
  • P_PRODUCTOVERDUESITPREDICT.RECPMRPCONTROLLER == T024D.DISPO
  • P_PRODUCTOVERDUESITPREDICT.ISSPMRPCONTROLLER == T024D.DISPO
  • P_PRODUCTOVERDUESITPREDICT.MANDT == T024D.MANDT
  • P_PRODUCTOVERDUESITPREDICT.[column in domain "WERKS_D"] == T024D.WERKS
Company Code
  • Company Code
  • Client
  • P_PRODUCTOVERDUESITPREDICT.ISSUINGCOMPANYCODE == T001.BUKRS
  • P_PRODUCTOVERDUESITPREDICT.MANDT == T001.MANDT
Plant
  • Plant
  • Client
  • P_PRODUCTOVERDUESITPREDICT.ISSUINGPLANT == T001W.WERKS
  • P_PRODUCTOVERDUESITPREDICT.MANDT == T001W.MANDT
Material Number
  • Client
  • Material Number
  • P_PRODUCTOVERDUESITPREDICT.MANDT == MARA.MANDT
  • P_PRODUCTOVERDUESITPREDICT.MATERIAL == MARA.MATNR
MRP Area
  • MRP Area
  • Client
  • P_PRODUCTOVERDUESITPREDICT.MRPAREA == MDLV.BERID
  • P_PRODUCTOVERDUESITPREDICT.MANDT == MDLV.MANDT
Material Group
  • Client
  • Product Group
  • P_PRODUCTOVERDUESITPREDICT.MANDT == T023.MANDT
  • P_PRODUCTOVERDUESITPREDICT.PRODUCTGROUP == T023.MATKL
Product Hierarchy
  • Product hierarchy
  • Client
  • P_PRODUCTOVERDUESITPREDICT.PRODUCTHIERARCHY == T179.PRODH
  • P_PRODUCTOVERDUESITPREDICT.MANDT == T179.MANDT
Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_PRODUCTOVERDUESITPREDICT.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_PRODUCTOVERDUESITPREDICT.MANDT == T006.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • Purchasing Document Category
  • P_PRODUCTOVERDUESITPREDICT.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_PRODUCTOVERDUESITPREDICT.MANDT == T161.MANDT
  • P_PRODUCTOVERDUESITPREDICT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Default storage location for external procurement
  • Default storage location for external procurement
  • Default storage location for external procurement
  • Client
  • ?
  • P_PRODUCTOVERDUESITPREDICT.ISSPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT
  • P_PRODUCTOVERDUESITPREDICT.RECPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT
  • P_PRODUCTOVERDUESITPREDICT.MANDT == T001L.MANDT
  • P_PRODUCTOVERDUESITPREDICT.[column in domain "WERKS_D"] == T001L.WERKS
MRP controller
  • MRP Controller
  • MRP Controller
  • Client
  • ?
  • P_PRODUCTOVERDUESITPREDICT.RECPMRPCONTROLLER == T024D.DISPO
  • P_PRODUCTOVERDUESITPREDICT.ISSPMRPCONTROLLER == T024D.DISPO
  • P_PRODUCTOVERDUESITPREDICT.MANDT == T024D.MANDT
  • P_PRODUCTOVERDUESITPREDICT.[column in domain "WERKS_D"] == T024D.WERKS
Volume Unit
  • Client
  • Volume unit
  • P_PRODUCTOVERDUESITPREDICT.MANDT == T006.MANDT
  • P_PRODUCTOVERDUESITPREDICT.VOLUMEUNIT == T006.MSEHI