- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_MaterialOverdueSIT
Consumption view for Stock Overdues
| view: CMATOVERDUESIT
| Extraction:
Not supported
| Component: Basic Functions
Tables used:
LIKP, LIPS, MATDOC, EKKO, EKPO, EKET, SIT_INST, SIT_INST_QUEUE, SIT_INST_QUEUE, MATDOC_EXTRACT, MARA, T001W, MARA, T161T, SIT_DEF, SIT_T_DEF, USR21, /SAPSLL/CLSNR, /SAPSLL/MARITC, /SAPSLL/NOSCA, MARC, T001W, /SAPSLL/TUNOS
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
| |
Currency Key
| |
Goods Issue for Delivery Document Item Batch
|
|
Goods Issue for Delivery Document Type
| |
Goods Receipt for Delivery Document Item Batch
|
|
Goods Receipt for Delivery Document Type
| |
Special Stock Indicator
| |
Issuing Company Code
| |
Issuing Plant
| |
Material Number
| |
Material Group
| |
Purchasing Document Type
| |
Receiving Company Code
| |
Receiving Plant
| |
Supplying Storage Location (PO)
|