- 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_CmmdtyMTMEndOfDayQry
MtM End of Day Query
| view: CMTMPFEODQRY | TRAN
| Extraction:
Not supported
| Component: Basic Functions
| Column Name | Description | |
|---|---|---|
| PricingKey | A key required to access versioned pricing data | |
| Version | Version of an MtM Valuation Record | |
| PricingDocumentItem | Condition item number | |
| VersStockRecordUUID | GUID assigned to the VlogP stock delta record | |
| CommodityPriceExposure | Commodity Price Exposure ID | |
| CommodityExposureCategory | Exposure Category | Show values |
| CommodityPriceSubExposure | Hash key |
| Column Name | Description | |
|---|---|---|
| 💲 Statistics Currency (StatisticsCurrency): | ||
| ConditionTermValueInStstcCrcy | Value in Statistical Currency | |
| Column Name | Description | |
|---|---|---|
| 📏 Unit of Measure for Commodity (CommodityUnit): | ||
| CommodityQuantity | Commodity Quantity | |
| 📏 Price UoM (ConditionTermRateQuantityUnit): | ||
| CommodityQuantityInTermUnit | Commodity Quantity in Price Unit | |
| Column Name | Description | |
|---|---|---|
| EndOfDaySnapshotDate | Snapshot Date | |
| ValidityStartDate | Last Changed Date | |
| MaturityKeyDate | Maturity Key Date | |
| QuotationPeriodReferenceDate | Reference Date | |
| ExpectedPaymentDate | Payment Date | |
| ExchRateEvaluationDate | Exchange Rate Evaluation Date | |
| DocToStstcCrcyExchRateEvalDate | Document to Statistics Currency Evaluation Date | |
| OldestQuotationDate | Oldest Quotation Date | |
| CndnTermRateFixationDate | Rate Fixation Date | |
| CndnTermRateFixationTime | Rate Fixation Time | |
| CndnTermExchRateFixationDate | FX Fixation Date | |
| CndnTermExchRateFixationTime | FX Fixation Time | |
| ExchRateMaturityDate | Maturity Date | |
| BasisMarketRefKeyDate | Basis Market reference maturity keydate | |
| ExposureDueDate | Date on which the exposure is due and expires | |
| ReportingDate | Reporting Date | |
| EvaluationDate | null | |
| DeliveryDate | Delivery Date |
| Column Name | Description | |
|---|---|---|
| CommodityExposureCategory | Exposure Category | Show values |
| MTMConditionGroupCategory | Categorization of Condition Group | Show values |
| PricingStatus | Future/Basis Price Fixation Status | Show values |
| MTMAdjustmentType | Type of adjustment for the MtM or TPL calculation | Show values |
| IsIntercompanyTransfer | Intercompany Transfer | Show values |
| ConditionTermExchRateIsFixed | Indicates that the term is fixed | Show values |
| ConditionTermRateIsFixed | Indicates that the term is fixed | Show values |
| CashFlowDirection | Transaction Flow Direction | Show values |
| TreasuryPositionLongShortCode | Code: Long or Short Position | Show values |
| CmmdtyForwardIndexTiming | Timing/Periodicity of Commodity Forward Indexes | Show values |
| MTMDataSourceType | Type of Data Record | Show values |
| HasError | Flag: Error occured | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| CompanyCode | Company Code | BUKRS | |
| ProfitCenter | Profit Center | PRCTR | |
| Plant | Plant | WERKS | |
| PhysicalCommodity | Commodity | TBA_STOEFFCHEN | |
| Material | Material Number | MATNR | |
| OriginReferenceDocument | Root Document | CMM_MTM_OBJID | |
| SourceDocument | Source Document | CMM_MTM_OBJID | |
| SourceDocumentItem | Source Document Item | ||
| SourceDocumentBusObjType | Source Document Business Object Type | ||
| IncotermsClassification | Incoterms (Part 1) | INCO1 | |
| IncotermsTransferLocation | Incoterms (Part 2) | INCO2 | |
| ConditionApplication | Application | KAPPL | |
| MTMCalculationGroup | MtM Calculation Group | CMM_MTM_CGROUP | |
| DerivativeContractMaturityCode | Contract Maturity Code | TBA_CONTRACT_CODE | |
| BasisID | Basis ID | TBAC_BASIS_ID | |
| DerivativeContrSpecification | Derivative Contract Specification ID | TBA_DCSID | |
| MarketIdentifierCode | Market Identifier Code | TBA_MIC | |
| ConditionTermRateFixation | Fixation ID | ||
| ConditionType | Condition Type | KSCHL | |
| SubConditionType | The key of a sub-condition type | CMM_VLOGP_SUBKEY | |
| ConditionTermValueInDocCrcy | Value in Document Currency | ||
| ConditionTermRate | Price | ||
| MarketToDocExchRate | Exchange Rate: Market to Document Currency | ||
| DocToStatisticalExchRate | Exchange Rate: Document to Statistics Currency | ||
| SalesOrganization | Sales Organization | VKORG | |
| DistributionChannel | Distribution Channel | VTWEG | |
| Division | Division | SPART | |
| Creditor | Account Number of Supplier | LIFNR | |
| SoldToParty | Customer Number | KUNNR | |
| StorageLocation | Storage location | LGORT | |
| Batch | Batch Number | CHARG | |
| GoodsMovementType | Movement type (inventory management) | BWART | |
| ReferenceDocument | Predecessor Document | CMM_MTM_OBJID | |
| ReferenceDocumentItem | Predecessor Document Item | CMM_VLOGP_REF_ITEM | |
| ReferenceDocBusObjType | Ref (BOR) Object Type | OJ_NAME | |
| BusinessArea | Business Area | GSBER | |
| PurchasingOrganization | Purchasing organization | EKORG | |
| MaterialGroup | Material Group | MATKL | |
| ConditionTermRateQuantity | Price Unit | ||
| BasisType | Basis Type | TBAC_BASIS_TYPE | |
| QuotationPriceType | Type of Price Quotation | VVSKURSART | |
| MTMConditionGroup | MtM Condition Group | CMM_MTM_CGROUP | |
| MTMCalcGrpMarketPriceCondition | Market Price Condition within a calculation group | KSCHL | |
| BasisMarketRefRate | Original Basis Market reference rate | CMM_GMDA_PRICE | |
| BasisMarketRefAdjustmentSpread | Adjustment Value | CMM_GMDA_PRICE | |
| MarketToDocFrozenExchRate | Exchange Rate: Market to Document Currency at a Key Date | ||
| BsMktRefDrvtvContrMaturityCode | Basis Market Reference Contract Maturity Code | CMM_BAS_MKT_REF_CONTRACT_CODE | |
| ConditionTermFactor | CPE condition type term factor | ||
| MaximumVersion | Highest Version Number | CMM_MTM_VERSION | |
| TimeToMaturity | Time to Maturity | TBA_TENOR | |
| CmmdtyForwardIndexTimingText | Short Text for Fixed Values | DDTEXT | |
| FinancialInstrProductCategory | Product Category | VVSANLF | |
| FinancialAssetsMgmtProductType | Product Type | VVSART | |
| FinInstrTransactionCategory | Transaction Category | T_SFGTYP | |
| FinancialInstrumentProductType | Financial Transaction Type | T_SFHAART | |
| FinancialInstrActivityCategory | Transaction Activity Category | T_SFGZUTY | |
| OriginReferenceDocumentItem | Root Document Item | CMM_VLOGP_ROOT_ITEM | |
| OriginReferenceDocBusObjType | Root Document (BOR) Object Type | OJ_NAME | |
| DeliveryYear | Abjusted Reporting Year | ||
| DeliveryMonth | Adjusted Reporting Month | CHAR3 | |
| ExternalKeyFigureValue | External Key figures | ||
| OptionDeltaFactor | Option Delta Factor Value | CDS_OPTION_DELTA_FACTOR | |
| FinInstrExternalReference | External Reference | FTI_CHAR16LOW | |
| SystemMessageText | Message Text | NATXT |