P_MaterialOverdueSITPrediction

Prediction Model of Overdue SIT to be consumed by Framework | view: PMATOVERDUESITPD | TRAN | Extraction: Not supported | Component: VDM Stock and Goods Movements
Tables used: LIKPLIPSMATDOCEKKOEKPOEKETMARAT001WMARA
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
GoodsIssueMaterialDocument Material Document of Goods Issue
GoodsIssueMaterialDocumentItem Material Document Item of Goods Issue
GoodsIssueMaterialDocumentYear Material Document Year of Goods Issue
GoodsReceiptMaterialDocument Material Document of Goods Receipt
GoodsReceiptMaterialDocItem Material Document Item of Goods Receipt
GoodsReceiptMaterialDocYear Material Document Year of Goods Receipt
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
Column Name Description
📏 Purchase Order Unit of Measure (BaseUnit):
PurchaseOrderItemQuantity Quantity (PO)
GoodsIssueQuantity Goods Issue Quantity
GoodsReceiptQuantity Goods Receipt Quantity
running_quant_m_sum Calculated Quantity Sum per Month
running_quant_m_min Calculated Quantity Minimum per Month
running_quant_m_max Calculated Quantity Maximum per Month
📏 Volume unit (volumeunit):
materialvolume Volume
Column Name Description
CreationDate Purchasing Document Date
GoodsIssuePostingDate Posting Date of Goods Issue
GoodsReceiptPostingDate Posting Date of Goods Receipt
LastPostingDateOfMaterialDoc Last Posting Date of Material Document
ScheduleLineDeliveryDate Item delivery date
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 Issuing Plant Name TEXT30
CreatedByUser Purchase Order Created by User XUBNAME
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
MaterialName Material Description TEXT40
NumbersOfDaysSincePurOrdPostg Days since Posting Date
DifferenceOfGRAndGIDate Duration between GI and GR posting date
UnitOfMeasure 3-Byte field CHAR3
GoodsIssueMovementType Movement Type of Goods Issue BWART
ReceivingPlantName Plant Name TEXT30
GoodsReceiptMovementType Movement Type of Goods Receipt BWART
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
running_m_count Calculated Count per Month
running_quant_m_avg Calculated Quantity Average per Month
running_diff1_m_min Calculated Difference1 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_diff1_m_avg Calculated Difference1 Average per Month
running_diff1_m_max Calculated Difference1 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_diff2_m_min Calculated Difference2 Minimum per Month NSDM_PRED_DIFFERENCE_IN_DAYS
running_diff2_m_avg Calculated Difference2 Average per Month
running_diff2_m_max Calculated Difference2 Average per Month NSDM_PRED_DIFFERENCE_IN_DAYS
lowlevelcode Low-Level Code DISST
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_MATERIALOVERDUESITPREDICTION.MANDT == T006.MANDT
  • P_MATERIALOVERDUESITPREDICTION.BASEUNIT == T006.MSEHI
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • P_MATERIALOVERDUESITPREDICTION.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • P_MATERIALOVERDUESITPREDICTION.MANDT == T148.MANDT
Issuing Company Code
  • Client
  • Issuing Company Code
  • Receiving Company Code
  • P_MATERIALOVERDUESITPREDICTION.MANDT == T001.MANDT
  • P_MATERIALOVERDUESITPREDICTION.ISSUINGCOMPANYCODE == T001.BUKRS
  • P_MATERIALOVERDUESITPREDICTION.RECEIVINGCOMPANYCODE == T001.BUKRS
Issuing Plant
  • Client
  • Issuing Plant
  • P_MATERIALOVERDUESITPREDICTION.MANDT == T001W.MANDT
  • P_MATERIALOVERDUESITPREDICTION.ISSUINGPLANT == T001W.WERKS
Material Number
  • Material Number
  • Client
  • P_MATERIALOVERDUESITPREDICTION.MATERIAL == MARA.MATNR
  • P_MATERIALOVERDUESITPREDICTION.MANDT == MARA.MANDT
Material Group
  • Product Group
  • Client
  • P_MATERIALOVERDUESITPREDICTION.PRODUCTGROUP == T023.MATKL
  • P_MATERIALOVERDUESITPREDICTION.MANDT == T023.MANDT
Product Hierarchy
  • Product hierarchy
  • Client
  • P_MATERIALOVERDUESITPREDICTION.PRODUCTHIERARCHY == T179.PRODH
  • P_MATERIALOVERDUESITPREDICTION.MANDT == T179.MANDT
Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_MATERIALOVERDUESITPREDICTION.MANDT == T006.MANDT
  • P_MATERIALOVERDUESITPREDICTION.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Document Type
  • Purchasing Document Category
  • Purchasing Document Type
  • Client
  • P_MATERIALOVERDUESITPREDICTION.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_MATERIALOVERDUESITPREDICTION.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_MATERIALOVERDUESITPREDICTION.MANDT == T161.MANDT
Receiving Company Code
  • Client
  • Issuing Company Code
  • Receiving Company Code
  • P_MATERIALOVERDUESITPREDICTION.MANDT == T001.MANDT
  • P_MATERIALOVERDUESITPREDICTION.ISSUINGCOMPANYCODE == T001.BUKRS
  • P_MATERIALOVERDUESITPREDICTION.RECEIVINGCOMPANYCODE == T001.BUKRS
Receiving Plant
  • Receiving Plant
  • Client
  • P_MATERIALOVERDUESITPREDICTION.RECEIVINGPLANT == T001W.WERKS
  • P_MATERIALOVERDUESITPREDICTION.MANDT == T001W.MANDT
Volume Unit
  • Client
  • Volume unit
  • P_MATERIALOVERDUESITPREDICTION.MANDT == T006.MANDT
  • P_MATERIALOVERDUESITPREDICTION.VOLUMEUNIT == T006.MSEHI