I_MatlOvrdStInTrPredictedDte

Inter View for Predicted Date in Material Overdue SIT | view: IMATOVRDSITPD | 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
GoodsIssueQtyInOrderUnit Goods Issue Quantity
GoodsReceiptQtyInOrderUnit Goods Receipt Quantity
📏 Base Unit of Goods Receipt (MaterialBaseUnit):
GoodsReceiptQuantity Goods Receipt Quantity
Column Name Description
CreationDate Purchase Order Posting Date
GoodsIssuePostingDate Posting Date of Goods Issue
GoodsReceiptPostingDate Posting Date of Goods Receipt
LastPostingDateOfMaterialDoc null
ScheduleLineDeliveryDate Planned Delivery Date in Purchase Order Item
PredictedDelivDte Forecast Delivery Date
RealOrExpectedMaterialPostgDte Actual Delivery Date (System Date or last GR Date)
GoodsIssueDelivDocItmCrtnDte Goods Issue for Delivery Document Item Creation Date
GoodsReceiptDelivDocItmCrtnDte Goods Receipt for Delivery Document Item Creation Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
StockInTransitProcessType SIT Process Type Show values
GoodsReceiptIsCanceled Cancellation Indicator Goods Receipt Show values
GoodsIssueIsCanceled Item has been Cancelled Show values
GoodsIssueDelivDocItmStatus Goods Issue for Delivery Document Item Status Show values
GoodsReceiptDelivDocItmStatus Goods Receipt for Delivery Document Item Status 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
MatlOverdueSitSitnAnchrID Overdue Sit Situation Anchor ID
PurchaseOrderItemCnctntdID Purchase Order / Purchase Order Item
IssuingPlantName Issuing Plant Name TEXT30
CreatedByUser Purchase Order Created by User XUBNAME
GRCreatedByUser Goods Receipt Created By User XUBNAME
GICreatedByUser Goods Issue Created By User XUBNAME
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
MaterialName Material Description TEXT40
CompletelyDeliveredExLmt null
NumbersOfDaysSincePurOrdPostg Days since Posting Date
DifferenceOfGRAndGIDate Duration between GI and GR posting date
DurationBetweenPOAndGI Duration between PO and GI posting date
DaysInTransit Number of Days a Stock has been in Transit
GoodsIssueMovementType Movement Type of Goods Issue BWART
ReceivingPlantName Plant Name TEXT30
GoodsReceiptMovementType Movement Type of Goods Receipt BWART
ReceivingStorageLocation Storage location LGORT
ReceivingBatch Batch Number CHARG
IssuingStorageLocation Issuing Storage Location LGORT
IssuingBatch Issuing Batch CHARG
ScheduleLine Delivery Schedule Line Counter EETEN
PredictedDaysOfDelivDeviation null
StartOfStockTransportOrder null
PredictedDelDaysRltnPOPostDate Predicted Delivery Days in Relation to PO Posting Date
PlannedDelDaysRltnPOPostDate Planned Delivery Days in Relation to PO Posting Date
ShippingDaysSincePOPostingDate Current Duration of Shipping
StkInTransitDelivDteCritlty null
DaysInTransitExLmt null
GoodsIssueForDeliveryDoc Goods Issue Delivery Document VBELN
GoodsIssueForDeliveryDocItem Goods Issue Delivery Document Item POSNR
GoodsIssueDelivDocItmQty Goods Issue for Delivery Document Item Quantity
GoodsReceiptForDeliveryDoc Goods Receipt Delivery Document VBELN
GoodsReceiptForDeliveryDocItem Goods Receipt Delivery Document Item POSNR
GoodsReceiptDelivDocItmQty Goods Receipt for Delivery Document Item Quantity
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • Base Unit of Goods Receipt
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == T006.MANDT
  • I_MATLOVRDSTINTRPREDICTEDDTE.BASEUNIT == T006.MSEHI
  • I_MATLOVRDSTINTRPREDICTEDDTE.MATERIALBASEUNIT == T006.MSEHI
Currency Key
  • Currency Key
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.DOCUMENTCURRENCY == TCURC.WAERS
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == TCURC.MANDT
Goods Issue for Delivery Document Item Batch
  • Goods Receipt for Delivery Document Item Batch
  • Batch Number
  • Goods Issue for Delivery Document Item Batch
  • Material Number
  • Receiving Plant
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.GOODSRECEIPTDELIVDOCITMBATCH == MCHA.CHARG
  • I_MATLOVRDSTINTRPREDICTEDDTE.RECEIVINGBATCH == MCHA.CHARG
  • I_MATLOVRDSTINTRPREDICTEDDTE.GOODSISSUEDELIVDOCITMBATCH == MCHA.CHARG
  • I_MATLOVRDSTINTRPREDICTEDDTE.MATERIAL == MCHA.MATNR
  • I_MATLOVRDSTINTRPREDICTEDDTE.RECEIVINGPLANT == MCHA.WERKS
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == MCHA.MANDT
Goods Issue for Delivery Document Type
  • Goods Receipt for Delivery Document Type
  • Goods Issue for Delivery Document Type
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.GOODSRECEIPTDELIVDOCTYPE == TVLK.LFART
  • I_MATLOVRDSTINTRPREDICTEDDTE.GOODSISSUEDELIVDOCTYPE == TVLK.LFART
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == TVLK.MANDT
Goods Receipt for Delivery Document Item Batch
  • Goods Receipt for Delivery Document Item Batch
  • Batch Number
  • Goods Issue for Delivery Document Item Batch
  • Material Number
  • Receiving Plant
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.GOODSRECEIPTDELIVDOCITMBATCH == MCHA.CHARG
  • I_MATLOVRDSTINTRPREDICTEDDTE.RECEIVINGBATCH == MCHA.CHARG
  • I_MATLOVRDSTINTRPREDICTEDDTE.GOODSISSUEDELIVDOCITMBATCH == MCHA.CHARG
  • I_MATLOVRDSTINTRPREDICTEDDTE.MATERIAL == MCHA.MATNR
  • I_MATLOVRDSTINTRPREDICTEDDTE.RECEIVINGPLANT == MCHA.WERKS
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == MCHA.MANDT
Goods Receipt for Delivery Document Type
  • Goods Receipt for Delivery Document Type
  • Goods Issue for Delivery Document Type
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.GOODSRECEIPTDELIVDOCTYPE == TVLK.LFART
  • I_MATLOVRDSTINTRPREDICTEDDTE.GOODSISSUEDELIVDOCTYPE == TVLK.LFART
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == TVLK.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == T148.MANDT
Issuing Company Code
  • Receiving Company Code
  • Issuing Company Code
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.RECEIVINGCOMPANYCODE == T001.BUKRS
  • I_MATLOVRDSTINTRPREDICTEDDTE.ISSUINGCOMPANYCODE == T001.BUKRS
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == T001.MANDT
Issuing Plant
  • Issuing Plant
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.ISSUINGPLANT == T001W.WERKS
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == T001W.MANDT
Material Number
  • Material Number
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.MATERIAL == MARA.MATNR
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.MATERIALGROUP == T023.MATKL
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == T023.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.PURCHASINGDOCUMENTTYPE == T161.BSART
  • I_MATLOVRDSTINTRPREDICTEDDTE.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == T161.MANDT
Receiving Company Code
  • Receiving Company Code
  • Issuing Company Code
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.RECEIVINGCOMPANYCODE == T001.BUKRS
  • I_MATLOVRDSTINTRPREDICTEDDTE.ISSUINGCOMPANYCODE == T001.BUKRS
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == T001.MANDT
Receiving Plant
  • Receiving Plant
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.RECEIVINGPLANT == T001W.WERKS
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == T001W.MANDT
Supplying Storage Location (PO)
  • Supplying Storage Location (PO)
  • Storage location
  • Receiving Plant
  • Client
  • I_MATLOVRDSTINTRPREDICTEDDTE.SUPPLYINGSTORAGELOCATION == T001L.LGORT
  • I_MATLOVRDSTINTRPREDICTEDDTE.RECEIVINGSTORAGELOCATION == T001L.LGORT
  • I_MATLOVRDSTINTRPREDICTEDDTE.RECEIVINGPLANT == T001L.WERKS
  • I_MATLOVRDSTINTRPREDICTEDDTE.MANDT == T001L.MANDT