P_ProductOverdueSITPredictCalc

Material Overdue SIT Prediction Calc | view: POVERDUECALC | TRAN | Extraction: Not supported | Component: Basis
Tables used: SCAL_TT_DATEMATDOCEKKOEKPOEKETMARAMARCT001W
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 Purchase Order Quantity
GoodsIssueQuantity Goods Issue Quantity
GoodsReceiptQuantity Goods Receipt Quantity
running_quant_m_sum null
running_quant_m_min null
running_quant_m_max null
prev_quant_m_sum null
prev_quant_m_min null
prev_quant_m_max null
running_quant_w_sum null
running_quant_w_min null
running_quant_w_max null
prev_quant_w_sum null
prev_quant_w_min null
prev_quant_w_max null
running_rpm_quant_m_sum null
running_rpm_quant_m_min null
running_rpm_quant_m_max null
prev_rpm_quant_m_sum null
prev_rpm_quant_m_min null
prev_rpm_quant_m_max null
running_rpm_quant_w_sum null
running_rpm_quant_w_min null
running_rpm_quant_w_max null
prev_rpm_quant_w_sum null
prev_rpm_quant_w_min null
prev_rpm_quant_w_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
📏 Volume unit (VolumeUnit):
MaterialVolume Volume
Column Name Description
CreationDate Creation Date of Purchasing Document
GoodsIssuePostingDate Posting Date in the Document
creationdate_2 Creation Date of Purchasing Document
GoodsReceiptPostingDate Posting Date in the Document
LastPostingDateOfMaterialDoc null
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
PurchaseOrderItem Item Number of Purchase Order EBELP
GoodsIssueMaterialDocument Number of Material Document BELNR
GoodsIssueMaterialDocumentItem Item in Material Document MBLPO
GoodsIssueMaterialDocumentYear Fiscal Year GJAHR
GoodsReceiptMaterialDocument Number of Material Document BELNR
GoodsReceiptMaterialDocItem Item in Material Document MBLPO
GoodsReceiptMaterialDocYear Fiscal Year GJAHR
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 null
both_plant null
rp_m null
create_month Calendar Month NUM2
week_number Calendar Week NUM2
running_m_count null
running_quant_m_avg null
running_diff1_m_sum null
running_diff1_m_min null
running_diff1_m_avg null
running_diff1_m_max null
running_diff2_m_sum null
running_diff2_m_min null
running_diff2_m_avg null
running_diff2_m_max null
prev_m_count null
prev_quant_m_avg null
prev_diff1_m_sum null
prev_diff1_m_min null
prev_diff1_m_avg null
prev_diff1_m_max null
prev_diff2_m_sum null
prev_diff2_m_min null
prev_diff2_m_avg null
prev_diff2_m_max null
running_w_count null
running_quant_w_avg null
running_diff1_w_sum null
running_diff1_w_min null
running_diff1_w_avg null
running_diff1_w_max null
running_diff2_w_sum null
running_diff2_w_min null
running_diff2_w_avg null
running_diff2_w_max null
prev_w_count null
prev_quant_w_avg null
prev_diff1_w_sum null
prev_diff1_w_min null
prev_diff1_w_avg null
prev_diff1_w_max null
prev_diff2_w_sum null
prev_diff2_w_min null
prev_diff2_w_avg null
prev_diff2_w_max null
running_rpm_m_count null
running_rpm_quant_m_avg null
running_rpm_diff1_m_sum null
running_rpm_diff1_m_min null
running_rpm_diff1_m_avg null
running_rpm_diff1_m_max null
running_rpm_diff2_m_sum null
running_rpm_diff2_m_min null
running_rpm_diff2_m_avg null
running_rpm_diff2_m_max null
prev_rpm_m_count null
prev_rpm_quant_m_avg null
prev_rpm_diff1_m_sum null
prev_rpm_diff1_m_min null
prev_rpm_diff1_m_avg null
prev_rpm_diff1_m_max null
prev_rpm_diff2_m_sum null
prev_rpm_diff2_m_min null
prev_rpm_diff2_m_avg null
prev_rpm_diff2_m_max null
running_rpm_w_count null
running_rpm_quant_w_avg null
running_rpm_diff1_w_sum null
running_rpm_diff1_w_min null
running_rpm_diff1_w_avg null
running_rpm_diff1_w_max null
running_rpm_diff2_w_sum null
running_rpm_diff2_w_min null
running_rpm_diff2_w_avg null
running_rpm_diff2_w_max null
prev_rpm_w_count null
prev_rpm_quant_w_avg null
prev_rpm_diff1_w_sum null
prev_rpm_diff1_w_min null
prev_rpm_diff1_w_avg null
prev_rpm_diff1_w_max null
prev_rpm_diff2_w_sum null
prev_rpm_diff2_w_min null
prev_rpm_diff2_w_avg null
prev_rpm_diff2_w_max null
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_PRODUCTOVERDUESITPREDICTCALC.MANDT == T006.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.BASEUNIT == T006.MSEHI
Currency Key
  • Client
  • Currency Key
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == TCURC.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.DOCUMENTCURRENCY == TCURC.WAERS
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == T148.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Default storage location for external procurement
  • Client
  • Receiving Plant
  • Default storage location for external procurement
  • Default storage location for external procurement
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == T001L.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.RECEIVINGPLANT == T001L.WERKS
  • P_PRODUCTOVERDUESITPREDICTCALC.ISSPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT
  • P_PRODUCTOVERDUESITPREDICTCALC.RECPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT
MRP controller
  • MRP Controller
  • MRP Controller
  • Client
  • Receiving Plant
  • P_PRODUCTOVERDUESITPREDICTCALC.ISSPMRPCONTROLLER == T024D.DISPO
  • P_PRODUCTOVERDUESITPREDICTCALC.RECPMRPCONTROLLER == T024D.DISPO
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == T024D.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.RECEIVINGPLANT == T024D.WERKS
Company Code
  • Company Code
  • Receiving Company Code
  • Client
  • P_PRODUCTOVERDUESITPREDICTCALC.ISSUINGCOMPANYCODE == T001.BUKRS
  • P_PRODUCTOVERDUESITPREDICTCALC.RECEIVINGCOMPANYCODE == T001.BUKRS
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == T001.MANDT
Plant
  • Client
  • Plant
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == T001W.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.ISSUINGPLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == MARA.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.MATERIAL == MARA.MATNR
MRP Area
  • Client
  • MRP Area
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == MDLV.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.MRPAREA == MDLV.BERID
Material Group
  • Client
  • Product Group
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == T023.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.PRODUCTGROUP == T023.MATKL
Product Hierarchy
  • Client
  • Product hierarchy
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == T179.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.PRODUCTHIERARCHY == T179.PRODH
Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_PRODUCTOVERDUESITPREDICTCALC.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == T006.MANDT
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • Purchasing Document Category
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == T161.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_PRODUCTOVERDUESITPREDICTCALC.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Default storage location for external procurement
  • Client
  • Receiving Plant
  • Default storage location for external procurement
  • Default storage location for external procurement
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == T001L.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.RECEIVINGPLANT == T001L.WERKS
  • P_PRODUCTOVERDUESITPREDICTCALC.ISSPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT
  • P_PRODUCTOVERDUESITPREDICTCALC.RECPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT
MRP controller
  • MRP Controller
  • MRP Controller
  • Client
  • Receiving Plant
  • P_PRODUCTOVERDUESITPREDICTCALC.ISSPMRPCONTROLLER == T024D.DISPO
  • P_PRODUCTOVERDUESITPREDICTCALC.RECPMRPCONTROLLER == T024D.DISPO
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == T024D.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.RECEIVINGPLANT == T024D.WERKS
Volume Unit
  • Client
  • Volume unit
  • P_PRODUCTOVERDUESITPREDICTCALC.MANDT == T006.MANDT
  • P_PRODUCTOVERDUESITPREDICTCALC.VOLUMEUNIT == T006.MSEHI