- 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)
- Advanced Returns Management (LO-ARM)
- Batches (LO-BM)
- Commodity Management in Logistics (LO-CMM)
- ERP Logistik Integration (LO-INT)
- Engineering Change Management (LO-ECH)
- Global Trade (LO-GT)
- Handling Unit Management (LO-HU)
- Logistics Basic Data (LO-MD)
- Logistics Information System (LIS) (LO-LIS)
- Product Data Management (LO-PDM)
- Retail & Fashion Management in S/4HANA (LO-RFM)
- SAP Agricultural Contract Management (LO-AGR)
- Segmentation (LO-SGT)
- Settlement Management (LO-AB)
- Variant Configuration (LO-VC)
- Variant configuration on HANA (LO-VCH)
- Warranty Claim Processing (LO-WTY)
- 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_CmmdtyStockEndOfDayQry
End-of-Day MtM for Material Stock
| view: CCOSTOCKEODQRY | TRAN
| Extraction:
Not supported
| Component: Basic Functions
Tables used:
MARA, TBACC_BAS_ID, TBACC_BAS_ID_T, TBAC_PHYSCOMM, TBAC_PHYSCOMMT, T001, TKA02, TBAC_DCST, TBAC_DCS, T156, T156HT, TINC, TINCT, TBAC_MIC, TBAC_MICT, CMM_MTM_CGROUPTT, T001W, CMM_FBFIX_STTXT, MARA, MAKT, T001L, T100, CMM_VLOGP_C_GRP
| Column Name | Description | |
|---|---|---|
| PricingKey | A key required to access versioned pricing data |
| Column Name | Description | |
|---|---|---|
| 💲 Price Currency (ConditionTermRateCurrency): | ||
| ConditionTermRate | Price | |
| 💲 Statistics Currency (StatisticsCurrency): | ||
| ConditionTermValueInStstcCrcy | Value in Statistical Currency | |
| Column Name | Description | |
|---|---|---|
| 📏 Unit of Measure for Commodity (CommodityUnit): | ||
| CommodityQuantity | Commodity Quantity | |
| Column Name | Description | |
|---|---|---|
| QuotationPeriodReferenceDate | Reference Date | |
| DeliveryDate | Delivery Date | |
| ExpectedPaymentDate | Payment Date | |
| ExchRateEvaluationDate | Exchange Rate Evaluation Date | |
| OldestQuotationDate | Oldest Quotation Date | |
| QuotationPeriodStartDate | Start Date of Quotation Period | |
| QuotationPeriodEndDate | End Date of Quotation Period | |
| ExchRateMaturityDate | Maturity Date |
| Column Name | Description | |
|---|---|---|
| IsIntercompanyTransfer | Intercompany Transfer | Show values |
| HasError | Flag: Error occured | Show values |
| CmmdtyForwardIndexTiming | Timing/Periodicity of Commodity Forward Indexes | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| CompanyCodeName | Name of Company Code or Company | TEXT25 | |
| ProfitCenter | Profit Center | PRCTR | |
| PlantName | Plant Name | TEXT30 | |
| StorageLocationName | Storage Location Name | TEXT16 | |
| CommodityName | Commodity Description | TEXT40 | |
| ProductName | Product Description | TEXT40 | |
| MTMDataSourceTypeName | Short Text for Fixed Values | DDTEXT | |
| MTMConditionGroupCategoryName | Short Text for Fixed Values | DDTEXT | |
| MTMCalculationGroupName | Condition Group - Description | TEXT20 | |
| SourceDocumentBusObjTypeName | Name | TEXT20 | |
| SourceDocumentShortNumber | Document | CMM_DOCUMENT_CHAR10 | |
| SourceDocument | Source Document | CMM_MTM_OBJID | |
| MarketToDocExchRate | Exchange Rate: Market to Document Currency | ||
| DocToStatisticalExchRate | Exchange Rate: Document to Statistics Currency | ||
| ConditionTermValueInDocCrcy | Value in Document Currency | ||
| ConditionType | Condition Type | KSCHL | |
| SubConditionType | The key of a sub-condition type | CMM_VLOGP_SUBKEY | |
| CompanyCode | Company Code | BUKRS | |
| PhysicalCommodity | Commodity | TBA_STOEFFCHEN | |
| Material | Material Number | MATNR | |
| MaterialGroup | Material Group | MATKL | |
| Plant | Plant | WERKS | |
| GoodsMovementType | Movement type (inventory management) | BWART | |
| GoodsMovementTypeName | Movement Type Text (Inventory Management) | BTEXT | |
| IncotermsClassificationName | Description | TEXT30 | |
| IncotermsTransferLocation | Incoterms (Part 2) | INCO2 | |
| SourceDocumentItem | Source Document Item | ||
| OrignRefDocumentShortNumber | Root Document | CMM_DOCUMENT_CHAR10 | |
| OriginReferenceDocument | Root Document | CMM_MTM_OBJID | |
| OriginRefDocBusObjTypeName | Name | TEXT20 | |
| OriginReferenceDocBusObjType | Root Document (BOR) Object Type | OJ_NAME | |
| OriginReferenceDocumentItem | Root Document Item | CMM_VLOGP_ROOT_ITEM | |
| ReferenceDocumentLongNumber | Predecessor Document | CMM_MTM_OBJID | |
| ReferenceDocBusObjTypeName | Name | TEXT20 | |
| ReferenceDocBusObjType | Ref (BOR) Object Type | OJ_NAME | |
| ReferenceDocumentItem | Predecessor Document Item | CMM_VLOGP_REF_ITEM | |
| DeliveryYear | Abjusted Reporting Year | ||
| DeliveryMonth | Adjusted Reporting Month | CHAR3 | |
| ConditionTermRateQuantity | Price Unit | ||
| ConditionTermFactor | CPE condition type term factor | ||
| DerivativeContrSpecName | Description of Derivative Contract Specification | TEXT40 | |
| MarketIdentifierCodeName | Market Identifier Code Description | TEXT40 | |
| BasisIDName | Basis ID Description | TBAC_BASIS_ID_TEXT | |
| ConditionTermRateFixation | Fixation ID | ||
| PricingStatusName | Future/Basis Price Fixation Status - Long Text | TEXT50 | |
| Batch | Batch Number | CHARG | |
| MTMAdjustmentTypeName | Short Text for Fixed Values | DDTEXT | |
| SystemMessageText | Message Text | NATXT | |
| CmmdtyForwardIndexTimingText | Short Text for Fixed Values | DDTEXT | |
| MarketToTermExchangeRateType | Exch. Rate Type for Conversion from Market to Term Currency | KURST | |
| CndnToStstcExchangeRateType | Exch. Rate Type for Conv. from Condition to Document Crcy | KURST | |
| ConditionToDocExchangeRateType | Exch Rate Type for Conv. from Document to Statistics Crcy | KURST | |
| DocToStstcExchangeRateType | Exch. Rate Type for Conv. from Condition to Stat. Crcy | KURST |