P_ProductOverdueSITPredictConv

Material Overdue SIT Prediction Conv | view: PMATOVERDUEPC | TRAN | Extraction: Not supported | Component: Basis
Tables used: MATDOC, EKKO, EKPO, EKET, MARA, MARC, T001W
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
📏 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 null
ScheduleLineDeliveryDate Item delivery date
creationdate_2 Creation Date of Purchasing Document
GoodsReceiptPostingDate_2 Posting Date in the Document
ScheduleLineDeliveryDate_2 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
diff_create_giposting null
diff_giposting null
diff_gireceipt null
diff_create null
create_month null
LowLevelCode Low-Level Code DISST
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == T006.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.BASEUNIT == T006.MSEHI
Currency Key
  • Client
  • Currency Key
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == TCURC.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.DOCUMENTCURRENCY == TCURC.WAERS
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == T148.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Default storage location for external procurement
  • Default storage location for external procurement
  • Default storage location for external procurement
  • Client
  • Receiving Plant
  • P_PRODUCTOVERDUESITPREDICTCONV.ISSPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT
  • P_PRODUCTOVERDUESITPREDICTCONV.RECPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == T001L.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.RECEIVINGPLANT == T001L.WERKS
MRP controller
  • MRP Controller
  • MRP Controller
  • Client
  • Receiving Plant
  • P_PRODUCTOVERDUESITPREDICTCONV.ISSPMRPCONTROLLER == T024D.DISPO
  • P_PRODUCTOVERDUESITPREDICTCONV.RECPMRPCONTROLLER == T024D.DISPO
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == T024D.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.RECEIVINGPLANT == T024D.WERKS
Company Code
  • Company Code
  • Receiving Company Code
  • Client
  • P_PRODUCTOVERDUESITPREDICTCONV.ISSUINGCOMPANYCODE == T001.BUKRS
  • P_PRODUCTOVERDUESITPREDICTCONV.RECEIVINGCOMPANYCODE == T001.BUKRS
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == T001.MANDT
Plant
  • Client
  • Plant
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == T001W.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.ISSUINGPLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == MARA.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.MATERIAL == MARA.MATNR
MRP Area
  • Client
  • MRP Area
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == MDLV.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.MRPAREA == MDLV.BERID
Material Group
  • Client
  • Product Group
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == T023.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.PRODUCTGROUP == T023.MATKL
Product Hierarchy
  • Client
  • Product hierarchy
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == T179.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.PRODUCTHIERARCHY == T179.PRODH
Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == T006.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • Purchasing Document Category
  • P_PRODUCTOVERDUESITPREDICTCONV.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == T161.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Default storage location for external procurement
  • Default storage location for external procurement
  • Default storage location for external procurement
  • Client
  • Receiving Plant
  • P_PRODUCTOVERDUESITPREDICTCONV.ISSPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT
  • P_PRODUCTOVERDUESITPREDICTCONV.RECPDFLTSTORLOCFOREXTPROCMT == T001L.LGORT
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == T001L.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.RECEIVINGPLANT == T001L.WERKS
MRP controller
  • MRP Controller
  • MRP Controller
  • Client
  • Receiving Plant
  • P_PRODUCTOVERDUESITPREDICTCONV.ISSPMRPCONTROLLER == T024D.DISPO
  • P_PRODUCTOVERDUESITPREDICTCONV.RECPMRPCONTROLLER == T024D.DISPO
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == T024D.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.RECEIVINGPLANT == T024D.WERKS
Volume Unit
  • Client
  • Volume unit
  • P_PRODUCTOVERDUESITPREDICTCONV.MANDT == T006.MANDT
  • P_PRODUCTOVERDUESITPREDICTCONV.VOLUMEUNIT == T006.MSEHI