I_MaterialOverdueSIT

Interface View for Material Overdue SIT | view: IMATOVERDUESIT | Extraction: Not supported | Component: Basic Functions
Tables used: LIKP, LIPS, MATDOC, EKKO, EKPO, EKET, 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 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
GoodsIssuePostingDate Posting Date of Goods Issue
GoodsReceiptPostingDate Posting Date of Goods Receipt
LastPostingDateOfMaterialDoc null
ScheduleLineDeliveryDate Item delivery date
RealOrExpectedMaterialPostgDte null
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 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
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
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
NumbersOfDaysSincePurOrdPostg Days since Posting Date
DifferenceOfGRAndGIDate Duration between GI and GR posting date
DurationBetweenPOAndGI Duration between PO and GI 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
IssuingStorageLocation Issuing Storage Location LGORT
IssuingBatch Issuing Batch CHARG
ScheduleLine Delivery Schedule Line Counter EETEN
DaysInTransit Number of Days a Stock has been in Transit
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
  • Base Unit of Goods Receipt
  • Purchase Order Unit of Measure
  • I_MATERIALOVERDUESIT.MANDT == T006.MANDT
  • I_MATERIALOVERDUESIT.MATERIALBASEUNIT == T006.MSEHI
  • I_MATERIALOVERDUESIT.BASEUNIT == T006.MSEHI
Currency Key
  • Client
  • Currency Key
  • I_MATERIALOVERDUESIT.MANDT == TCURC.MANDT
  • I_MATERIALOVERDUESIT.DOCUMENTCURRENCY == TCURC.WAERS
Goods Issue for Delivery Document Item Batch
  • Client
  • Material Number
  • Receiving Plant
  • Goods Issue for Delivery Document Item Batch
  • Batch Number
  • Goods Receipt for Delivery Document Item Batch
  • I_MATERIALOVERDUESIT.MANDT == MCHA.MANDT
  • I_MATERIALOVERDUESIT.MATERIAL == MCHA.MATNR
  • I_MATERIALOVERDUESIT.RECEIVINGPLANT == MCHA.WERKS
  • I_MATERIALOVERDUESIT.GOODSISSUEDELIVDOCITMBATCH == MCHA.CHARG
  • I_MATERIALOVERDUESIT.BATCH == MCHA.CHARG
  • I_MATERIALOVERDUESIT.GOODSRECEIPTDELIVDOCITMBATCH == MCHA.CHARG
Goods Issue for Delivery Document Type
  • Goods Issue for Delivery Document Type
  • Goods Receipt for Delivery Document Type
  • Client
  • I_MATERIALOVERDUESIT.GOODSISSUEDELIVDOCTYPE == TVLK.LFART
  • I_MATERIALOVERDUESIT.GOODSRECEIPTDELIVDOCTYPE == TVLK.LFART
  • I_MATERIALOVERDUESIT.MANDT == TVLK.MANDT
Goods Receipt for Delivery Document Item Batch
  • Client
  • Material Number
  • Receiving Plant
  • Goods Issue for Delivery Document Item Batch
  • Batch Number
  • Goods Receipt for Delivery Document Item Batch
  • I_MATERIALOVERDUESIT.MANDT == MCHA.MANDT
  • I_MATERIALOVERDUESIT.MATERIAL == MCHA.MATNR
  • I_MATERIALOVERDUESIT.RECEIVINGPLANT == MCHA.WERKS
  • I_MATERIALOVERDUESIT.GOODSISSUEDELIVDOCITMBATCH == MCHA.CHARG
  • I_MATERIALOVERDUESIT.BATCH == MCHA.CHARG
  • I_MATERIALOVERDUESIT.GOODSRECEIPTDELIVDOCITMBATCH == MCHA.CHARG
Goods Receipt for Delivery Document Type
  • Goods Issue for Delivery Document Type
  • Goods Receipt for Delivery Document Type
  • Client
  • I_MATERIALOVERDUESIT.GOODSISSUEDELIVDOCTYPE == TVLK.LFART
  • I_MATERIALOVERDUESIT.GOODSRECEIPTDELIVDOCTYPE == TVLK.LFART
  • I_MATERIALOVERDUESIT.MANDT == TVLK.MANDT
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • I_MATERIALOVERDUESIT.MANDT == T148.MANDT
  • I_MATERIALOVERDUESIT.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Issuing Company Code
  • Client
  • Issuing Company Code
  • Receiving Company Code
  • I_MATERIALOVERDUESIT.MANDT == T001.MANDT
  • I_MATERIALOVERDUESIT.ISSUINGCOMPANYCODE == T001.BUKRS
  • I_MATERIALOVERDUESIT.RECEIVINGCOMPANYCODE == T001.BUKRS
Issuing Plant
  • Client
  • Issuing Plant
  • I_MATERIALOVERDUESIT.MANDT == T001W.MANDT
  • I_MATERIALOVERDUESIT.ISSUINGPLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • I_MATERIALOVERDUESIT.MANDT == MARA.MANDT
  • I_MATERIALOVERDUESIT.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_MATERIALOVERDUESIT.MANDT == T023.MANDT
  • I_MATERIALOVERDUESIT.MATERIALGROUP == T023.MATKL
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • Purchasing Document Category
  • I_MATERIALOVERDUESIT.MANDT == T161.MANDT
  • I_MATERIALOVERDUESIT.PURCHASINGDOCUMENTTYPE == T161.BSART
  • I_MATERIALOVERDUESIT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Receiving Company Code
  • Client
  • Issuing Company Code
  • Receiving Company Code
  • I_MATERIALOVERDUESIT.MANDT == T001.MANDT
  • I_MATERIALOVERDUESIT.ISSUINGCOMPANYCODE == T001.BUKRS
  • I_MATERIALOVERDUESIT.RECEIVINGCOMPANYCODE == T001.BUKRS
Receiving Plant
  • Client
  • Receiving Plant
  • I_MATERIALOVERDUESIT.MANDT == T001W.MANDT
  • I_MATERIALOVERDUESIT.RECEIVINGPLANT == T001W.WERKS
Supplying Storage Location (PO)
  • Client
  • Receiving Plant
  • Supplying Storage Location (PO)
  • Storage location
  • I_MATERIALOVERDUESIT.MANDT == T001L.MANDT
  • I_MATERIALOVERDUESIT.RECEIVINGPLANT == T001L.WERKS
  • I_MATERIALOVERDUESIT.SUPPLYINGSTORAGELOCATION == T001L.LGORT
  • I_MATERIALOVERDUESIT.STORAGELOCATION == T001L.LGORT