C_MaterialOverdueSIT

Consumption view for Stock Overdues | view: CMATOVERDUESIT | Extraction: Not supported | Component: Basic Functions
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
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)
GoodsIssueQtyInOrderUnit Goods Issue Quantity
GoodsReceiptQtyInOrderUnit Goods Receipt Quantity
📏 Base Unit of Goods Receipt (MaterialBaseUnit):
GoodsIssueQuantity Goods Issue Quantity
GoodsReceiptQuantity Goods Receipt Quantity
Column Name Description
CreationDate Purchase Order Posting Date
GoodsIssuePostingDate Posting Date of Goods Issue
GoodsReceiptPostingDate Posting Date of Goods Receipt
PredictedDelivDte Forecast Delivery Date
RealOrExpectedMaterialPostgDte Actual Delivery Date (System Date or last GR Date)
ScheduleLineDeliveryDate Planned Delivery Date in Purchase Order Item
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
MatlOverdueSitSitnAnchrID Overdue Sit Situation Anchor ID
SitnNumberOfInstances Number of Situations INT4
SitnRowCriticalityCode Row Criticality
PurchaseOrderItemCnctntdID Purchase Order / Purchase Order Item
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
PurchasingDocumentCategoryName Purchasing Document Category Name DDTEXT
CreatedByUser Purchase Order Created by User XUBNAME
CreatedByUserDescription User Description SUIDTECHDESC
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
PurDocDeletionCodeName Short Text for Fixed Values DDTEXT
IssuingPlantName Issuing Plant Name TEXT30
MaterialName Material Description TEXT40
CompletelyDeliveredExLmt null
GoodsIssueMovementType Movement Type of Goods Issue BWART
GICreatedByUser Goods Issue Created By User XUBNAME
GICreatedByUserDescription User Description SUIDTECHDESC
GoodsReceiptMovementType Movement Type of Goods Receipt BWART
GRCreatedByUser Goods Receipt Created By User XUBNAME
GRCreatedByUserDescription User Description SUIDTECHDESC
ReceivingPlantName Plant Name TEXT30
ReceivingStorageLocation Storage location LGORT
ReceivingBatch Batch Number CHARG
IssuingStorageLocation Issuing Storage Location LGORT
IssuingBatch Issuing Batch CHARG
DaysInTransit Number of Days a Stock has been in Transit
NumbersOfDaysSincePurOrdPostg Days since Posting Date
DifferenceOfGRAndGIDate Duration between GI and GR posting date
DurationBetweenPOAndGI Duration between PO and GI posting date
StockInTransitProcessTypeName Short Text for Fixed Values DDTEXT
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
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
ReceivingPlantMRPResponsible MRP controller (GR) DISPO
TotalGoodsIssuedForPOQty Total Goods Issued Quantity for PO
TotalGoodsReceiptForPOQty Total Goods Receipt Quantity for PO
TotalGoodsIssuedQtyExLmt null
TotalGoodsReceiptQtyExLmt null
DaysInTransitExLmt null
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_MATERIALOVERDUESIT.MANDT == T006.MANDT
  • C_MATERIALOVERDUESIT.BASEUNIT == T006.MSEHI
Currency Key
  • Client
  • Currency Key
  • C_MATERIALOVERDUESIT.MANDT == TCURC.MANDT
  • C_MATERIALOVERDUESIT.DOCUMENTCURRENCY == TCURC.WAERS
Goods Issue for Delivery Document Item Batch
  • Client
  • Receiving Plant
  • Goods Issue for Delivery Document Item Batch
  • Goods Receipt for Delivery Document Item Batch
  • Batch Number
  • Material Number
  • C_MATERIALOVERDUESIT.MANDT == MCHA.MANDT
  • C_MATERIALOVERDUESIT.RECEIVINGPLANT == MCHA.WERKS
  • C_MATERIALOVERDUESIT.GOODSISSUEDELIVDOCITMBATCH == MCHA.CHARG
  • C_MATERIALOVERDUESIT.GOODSRECEIPTDELIVDOCITMBATCH == MCHA.CHARG
  • C_MATERIALOVERDUESIT.RECEIVINGBATCH == MCHA.CHARG
  • C_MATERIALOVERDUESIT.MATERIAL == MCHA.MATNR
Goods Issue for Delivery Document Type
  • Client
  • Goods Receipt for Delivery Document Type
  • Goods Issue for Delivery Document Type
  • C_MATERIALOVERDUESIT.MANDT == TVLK.MANDT
  • C_MATERIALOVERDUESIT.GOODSRECEIPTDELIVDOCTYPE == TVLK.LFART
  • C_MATERIALOVERDUESIT.GOODSISSUEDELIVDOCTYPE == TVLK.LFART
Goods Receipt for Delivery Document Item Batch
  • Client
  • Receiving Plant
  • Goods Issue for Delivery Document Item Batch
  • Goods Receipt for Delivery Document Item Batch
  • Batch Number
  • Material Number
  • C_MATERIALOVERDUESIT.MANDT == MCHA.MANDT
  • C_MATERIALOVERDUESIT.RECEIVINGPLANT == MCHA.WERKS
  • C_MATERIALOVERDUESIT.GOODSISSUEDELIVDOCITMBATCH == MCHA.CHARG
  • C_MATERIALOVERDUESIT.GOODSRECEIPTDELIVDOCITMBATCH == MCHA.CHARG
  • C_MATERIALOVERDUESIT.RECEIVINGBATCH == MCHA.CHARG
  • C_MATERIALOVERDUESIT.MATERIAL == MCHA.MATNR
Goods Receipt for Delivery Document Type
  • Client
  • Goods Receipt for Delivery Document Type
  • Goods Issue for Delivery Document Type
  • C_MATERIALOVERDUESIT.MANDT == TVLK.MANDT
  • C_MATERIALOVERDUESIT.GOODSRECEIPTDELIVDOCTYPE == TVLK.LFART
  • C_MATERIALOVERDUESIT.GOODSISSUEDELIVDOCTYPE == TVLK.LFART
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • C_MATERIALOVERDUESIT.MANDT == T148.MANDT
  • C_MATERIALOVERDUESIT.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Issuing Company Code
  • Client
  • Issuing Company Code
  • Receiving Company Code
  • C_MATERIALOVERDUESIT.MANDT == T001.MANDT
  • C_MATERIALOVERDUESIT.ISSUINGCOMPANYCODE == T001.BUKRS
  • C_MATERIALOVERDUESIT.RECEIVINGCOMPANYCODE == T001.BUKRS
Issuing Plant
  • Client
  • Issuing Plant
  • C_MATERIALOVERDUESIT.MANDT == T001W.MANDT
  • C_MATERIALOVERDUESIT.ISSUINGPLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • C_MATERIALOVERDUESIT.MANDT == MARA.MANDT
  • C_MATERIALOVERDUESIT.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_MATERIALOVERDUESIT.MANDT == T023.MANDT
  • C_MATERIALOVERDUESIT.MATERIALGROUP == T023.MATKL
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • Purchasing Document Category
  • C_MATERIALOVERDUESIT.MANDT == T161.MANDT
  • C_MATERIALOVERDUESIT.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_MATERIALOVERDUESIT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Receiving Company Code
  • Client
  • Issuing Company Code
  • Receiving Company Code
  • C_MATERIALOVERDUESIT.MANDT == T001.MANDT
  • C_MATERIALOVERDUESIT.ISSUINGCOMPANYCODE == T001.BUKRS
  • C_MATERIALOVERDUESIT.RECEIVINGCOMPANYCODE == T001.BUKRS
Receiving Plant
  • Client
  • Receiving Plant
  • C_MATERIALOVERDUESIT.MANDT == T001W.MANDT
  • C_MATERIALOVERDUESIT.RECEIVINGPLANT == T001W.WERKS
Supplying Storage Location (PO)
  • Storage location
  • Supplying Storage Location (PO)
  • Client
  • Receiving Plant
  • C_MATERIALOVERDUESIT.RECEIVINGSTORAGELOCATION == T001L.LGORT
  • C_MATERIALOVERDUESIT.SUPPLYINGSTORAGELOCATION == T001L.LGORT
  • C_MATERIALOVERDUESIT.MANDT == T001L.MANDT
  • C_MATERIALOVERDUESIT.RECEIVINGPLANT == T001L.WERKS