P_MaterialOverdueSITPredCalc

Prediction calculation | view: PMATOVERDUESITCA | TRAN | Extraction: Not supported | Component: VDM Stock and Goods Movements
Tables used: LIKPLIPSMATDOCEKKOEKPOEKETT001W
Column Name Description
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 null
running_quant_m_min null
running_quant_m_max null
Column Name Description
CreationDate Purchasing Document Date
GoodsIssuePostingDate Posting Date of Goods Issue
GoodsReceiptPostingDate Posting Date of Goods Receipt
LastPostingDateOfMaterialDoc null
ScheduleLineDeliveryDate Item delivery date
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
PurchaseOrderItem Item Number of Purchase Order EBELP
GoodsIssueMaterialDocument Material Document of Goods Issue BELNR
GoodsIssueMaterialDocumentItem Material Document Item of Goods Issue MBLPO
GoodsIssueMaterialDocumentYear Material Document Year of Goods Issue GJAHR
GoodsReceiptMaterialDocument Material Document of Goods Receipt BELNR
GoodsReceiptMaterialDocItem Material Document Item of Goods Receipt MBLPO
GoodsReceiptMaterialDocYear Material Document Year of Goods Receipt GJAHR
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 null
both_plant null
running_m_count null
running_quant_m_avg 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
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_MATERIALOVERDUESITPREDCALC.MANDT == T006.MANDT
  • P_MATERIALOVERDUESITPREDCALC.BASEUNIT == T006.MSEHI
Currency Key
  • Client
  • Currency Key
  • P_MATERIALOVERDUESITPREDCALC.MANDT == TCURC.MANDT
  • P_MATERIALOVERDUESITPREDCALC.DOCUMENTCURRENCY == TCURC.WAERS
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • P_MATERIALOVERDUESITPREDCALC.MANDT == T148.MANDT
  • P_MATERIALOVERDUESITPREDCALC.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Issuing Company Code
  • Client
  • Issuing Company Code
  • Receiving Company Code
  • P_MATERIALOVERDUESITPREDCALC.MANDT == T001.MANDT
  • P_MATERIALOVERDUESITPREDCALC.ISSUINGCOMPANYCODE == T001.BUKRS
  • P_MATERIALOVERDUESITPREDCALC.RECEIVINGCOMPANYCODE == T001.BUKRS
Issuing Plant
  • Client
  • Issuing Plant
  • P_MATERIALOVERDUESITPREDCALC.MANDT == T001W.MANDT
  • P_MATERIALOVERDUESITPREDCALC.ISSUINGPLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • P_MATERIALOVERDUESITPREDCALC.MANDT == MARA.MANDT
  • P_MATERIALOVERDUESITPREDCALC.MATERIAL == MARA.MATNR
Purchasing Document Type
  • Purchasing Document Category
  • Client
  • Purchasing Document Type
  • P_MATERIALOVERDUESITPREDCALC.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_MATERIALOVERDUESITPREDCALC.MANDT == T161.MANDT
  • P_MATERIALOVERDUESITPREDCALC.PURCHASINGDOCUMENTTYPE == T161.BSART
Receiving Company Code
  • Client
  • Issuing Company Code
  • Receiving Company Code
  • P_MATERIALOVERDUESITPREDCALC.MANDT == T001.MANDT
  • P_MATERIALOVERDUESITPREDCALC.ISSUINGCOMPANYCODE == T001.BUKRS
  • P_MATERIALOVERDUESITPREDCALC.RECEIVINGCOMPANYCODE == T001.BUKRS
Receiving Plant
  • Client
  • Receiving Plant
  • P_MATERIALOVERDUESITPREDCALC.MANDT == T001W.MANDT
  • P_MATERIALOVERDUESITPREDCALC.RECEIVINGPLANT == T001W.WERKS