P_MaterialOverdueSIT

Material Overdue Stock in Transit | view: PMATOVERDUESIT | Extraction: Not supported | Component: Basic Functions
Tables used: LIKP, LIPS, MATDOC, EKKO, EKPO, EKET, T001W
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
MatlOverdueSitSitnAnchrID Overdue Sit Situation Anchor ID
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 Purchasing Document Date
PurchasingDocumentOrderDate Purchasing Document Date
SystemDate null
GoodsIssueDelivDocItmCrtnDte Goods Issue for Delivery Document Item Creation Date
GoodsReceiptDelivDocItmCrtnDte Goods Receipt for Delivery Document Item Creation 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
GoodsReceiptIsCanceled Item has been Cancelled 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
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
DifferenceOfGRAndGIDate Duration between GI and GR posting date
DurationBetweenPOAndGI Duration between PO and GI posting date
UnitOfMeasure 3-Byte field CHAR3
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
GoodsIssueMovementType Movement Type of Goods Issue BWART
ReceivingPlantName Plant Name TEXT30
GoodsReceiptMovementType Movement Type of Goods Receipt BWART
IssuingStorageLocation Issuing Storage Location LGORT
IssuingBatch Issuing Batch CHARG
ScheduleLine Delivery Schedule Line Counter EETEN
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Base Unit of Goods Receipt
  • Client
  • P_MATERIALOVERDUESIT.BASEUNIT == T006.MSEHI
  • P_MATERIALOVERDUESIT.MATERIALBASEUNIT == T006.MSEHI
  • P_MATERIALOVERDUESIT.MANDT == T006.MANDT
Currency Key
  • Currency Key
  • Client
  • P_MATERIALOVERDUESIT.DOCUMENTCURRENCY == TCURC.WAERS
  • P_MATERIALOVERDUESIT.MANDT == TCURC.MANDT
Goods Issue for Delivery Document Item Batch
  • Material Number
  • Receiving Plant
  • Goods Receipt for Delivery Document Item Batch
  • Goods Issue for Delivery Document Item Batch
  • Client
  • P_MATERIALOVERDUESIT.MATERIAL == MCHA.MATNR
  • P_MATERIALOVERDUESIT.RECEIVINGPLANT == MCHA.WERKS
  • P_MATERIALOVERDUESIT.GOODSRECEIPTDELIVDOCITMBATCH == MCHA.CHARG
  • P_MATERIALOVERDUESIT.GOODSISSUEDELIVDOCITMBATCH == MCHA.CHARG
  • P_MATERIALOVERDUESIT.MANDT == MCHA.MANDT
Goods Issue for Delivery Document Type
  • Goods Issue for Delivery Document Type
  • Goods Receipt for Delivery Document Type
  • Client
  • P_MATERIALOVERDUESIT.GOODSISSUEDELIVDOCTYPE == TVLK.LFART
  • P_MATERIALOVERDUESIT.GOODSRECEIPTDELIVDOCTYPE == TVLK.LFART
  • P_MATERIALOVERDUESIT.MANDT == TVLK.MANDT
Goods Receipt for Delivery Document Item Batch
  • Material Number
  • Receiving Plant
  • Goods Receipt for Delivery Document Item Batch
  • Goods Issue for Delivery Document Item Batch
  • Client
  • P_MATERIALOVERDUESIT.MATERIAL == MCHA.MATNR
  • P_MATERIALOVERDUESIT.RECEIVINGPLANT == MCHA.WERKS
  • P_MATERIALOVERDUESIT.GOODSRECEIPTDELIVDOCITMBATCH == MCHA.CHARG
  • P_MATERIALOVERDUESIT.GOODSISSUEDELIVDOCITMBATCH == MCHA.CHARG
  • P_MATERIALOVERDUESIT.MANDT == MCHA.MANDT
Goods Receipt for Delivery Document Type
  • Goods Issue for Delivery Document Type
  • Goods Receipt for Delivery Document Type
  • Client
  • P_MATERIALOVERDUESIT.GOODSISSUEDELIVDOCTYPE == TVLK.LFART
  • P_MATERIALOVERDUESIT.GOODSRECEIPTDELIVDOCTYPE == TVLK.LFART
  • P_MATERIALOVERDUESIT.MANDT == TVLK.MANDT
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • P_MATERIALOVERDUESIT.MANDT == T148.MANDT
  • P_MATERIALOVERDUESIT.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Issuing Company Code
  • Issuing Company Code
  • Receiving Company Code
  • Client
  • P_MATERIALOVERDUESIT.ISSUINGCOMPANYCODE == T001.BUKRS
  • P_MATERIALOVERDUESIT.RECEIVINGCOMPANYCODE == T001.BUKRS
  • P_MATERIALOVERDUESIT.MANDT == T001.MANDT
Issuing Plant
  • Issuing Plant
  • Client
  • P_MATERIALOVERDUESIT.ISSUINGPLANT == T001W.WERKS
  • P_MATERIALOVERDUESIT.MANDT == T001W.MANDT
Material Number
  • Material Number
  • Client
  • P_MATERIALOVERDUESIT.MATERIAL == MARA.MATNR
  • P_MATERIALOVERDUESIT.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • P_MATERIALOVERDUESIT.MANDT == T023.MANDT
  • P_MATERIALOVERDUESIT.MATERIALGROUP == T023.MATKL
Purchasing Document Type
  • Purchasing Document Category
  • Client
  • Purchasing Document Type
  • P_MATERIALOVERDUESIT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_MATERIALOVERDUESIT.MANDT == T161.MANDT
  • P_MATERIALOVERDUESIT.PURCHASINGDOCUMENTTYPE == T161.BSART
Receiving Company Code
  • Issuing Company Code
  • Receiving Company Code
  • Client
  • P_MATERIALOVERDUESIT.ISSUINGCOMPANYCODE == T001.BUKRS
  • P_MATERIALOVERDUESIT.RECEIVINGCOMPANYCODE == T001.BUKRS
  • P_MATERIALOVERDUESIT.MANDT == T001.MANDT
Receiving Plant
  • Receiving Plant
  • Client
  • P_MATERIALOVERDUESIT.RECEIVINGPLANT == T001W.WERKS
  • P_MATERIALOVERDUESIT.MANDT == T001W.MANDT
Supplying Storage Location (PO)
  • Receiving Plant
  • Client
  • Supplying Storage Location (PO)
  • P_MATERIALOVERDUESIT.RECEIVINGPLANT == T001L.WERKS
  • P_MATERIALOVERDUESIT.MANDT == T001L.MANDT
  • P_MATERIALOVERDUESIT.SUPPLYINGSTORAGELOCATION == T001L.LGORT