- 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_CmmdtyPosCurrentDateQry
Commodity Position Current Date Query
| view: CCMMPOSCURQRY | TRAN
| Extraction:
Not supported
| Component: Basic Functions
Tables used:
CMM_FINSYNC, CMM_DEND_RUN, CMM_VFIND, CMM_VFINR, CMM_VLOGP_KONVD, CMM_NB_KEYDATE, CMM_VLOGP_TSER, TBAC_TENOR, CMM_VLOGP, T100
- 🔑 Keys (6)
- 💰 Amounts
- ∑ Quantities (15)
- 📅 Dates (7)
- ☰ Categorical (12)
- Other (47)
- 🔗 Relations
| Column Name | Description | |
|---|---|---|
| CommodityTransactionType | Paper/Physical Indicator for Exposure Group | Show values |
| PricingKey | A key required to access versioned pricing data | |
| ConditionType | Condition Type | |
| EvaluationDate | Latest Evaluation Date | |
| CompanyCode | Company Code | |
| CommodityExposureCategory | Exposure Category | Show values |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| 📏 Unit of Measure for Commodity (CommodityUnit): | ||
| UnpricedUndeliveredCtrExpsrQty | Unpriced Undelivered Contract Quantity | |
| UnpricedContrPriceExposureQty | Unpriced Contract Quantity | |
| PricedUndeliveredContrExpsrQty | Priced Undelivered Contract Quantity | |
| PricedContractsExposureQty | Priced Contract Quantity | |
| TodayPricedUndeliveredExpsrQty | Today Priced Undelivered Quantity | |
| UnrlzdMarketPriceExposureQty | Unrealized Market Exposure Quantity | |
| UnrealizedGoodsRcptPrcExpsrQty | Unrealized Goods Receipt Quantity | |
| UnrealizedGoodsIssPrcExpsrQty | Unrealized Goods Issue Quantity | |
| MaterialStockExposureQty | Stock on Hand | |
| RealizedMaterialStkPrcExpsrQty | Realized Stock Quantity | |
| OutrightPriceExposureQty | Outright Exposure Quantity | |
| 📏 Material Stock Unit of Measure (MaterialStockPriceExposureUnit): | ||
| UnpricedDeliveredCtrExpsrQty | Unpriced Delivered Contract Quantity | |
| PricedDeliveredContrExpsrQty | Priced Delivered Contract Quantity | |
| UndeliveredMarketPrExposureQty | Undelivered Market Exposure Quantity | |
| DeliveredMarketPrExposureQty | Delivered Market Exposure | |
| Column Name | Description | |
|---|---|---|
| EvaluationDate | Latest Evaluation Date | |
| EndOfDaySnapshotFromDate | Evaluation Date | |
| EndOfDaySnapshotToDate | Prev. Evaluation Date (to be compared with Evaluation Date) | |
| DeliveryDate | Delivery Date | |
| ExpectedPaymentDate | Payment Date | |
| MaturityKeyDate | Maturity Key Date | |
| AdjustedReportingDate | Adjusted Reporting Date |
| Column Name | Description | |
|---|---|---|
| CommodityTransactionType | Paper/Physical Indicator for Exposure Group | Show values |
| CommodityExposureCategory | Exposure Category | Show values |
| MTMDataSelectionType | VLOGP Data Selection Type | Show values |
| MTMDataSourceType | Type of Data Record | Show values |
| IsIntercompanyTransfer | Intercompany Transfer | Show values |
| TreasuryPositionLongShortCode | Code: Long or Short Position | Show values |
| CmmdtyForwardIndexTiming | Timing/Periodicity of Commodity Forward Indexes | Show values |
| OptionPutCallCode | Put/Call Indicator | Show values |
| PriceIsRealized | Indicates that the MtM value is realized | Show values |
| ImplicitFixationIsRelevant | Implicit Fixation Relevant | Show values |
| ConditionTermRateIsFixed | Indicates that the term is fixed | Show values |
| HasError | Error Flag for Data Record of Commodity Risk Analytics | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| FinInstrExternalReference | External Reference | FTI_CHAR16LOW | |
| SalesOrganization | Sales Organization | VKORG | |
| DistributionChannel | Distribution Channel | VTWEG | |
| Division | Division | SPART | |
| Creditor | Vendor's account number | LIFNR | |
| SoldToParty | Sold-to Party | KUNNR | |
| PhysicalCommodity | Commodity | TBA_STOEFFCHEN | |
| Material | Material Number | MATNR | |
| Plant | Plant | WERKS | |
| StorageLocation | Storage location | LGORT | |
| Batch | Batch Number | CHARG | |
| IncotermsClassification | Incoterms (Part 1) | INCO1 | |
| IncotermsTransferLocation | Incoterms (Part 2) | INCO2 | |
| SourceDocument | Document | CMM_MTM_OBJID | |
| SourceDocumentItem | Condition item number | NUM6 | |
| SourceDocumentBusObjType | Document Type | OJ_NAME | |
| OriginReferenceDocument | Root Document | CMM_MTM_OBJID | |
| OriginReferenceDocumentItem | Root Document Item | CMM_VLOGP_ROOT_ITEM | |
| OriginReferenceDocBusObjType | Root Document Type | OJ_NAME | |
| ReferenceDocument | Predecessor Document | CMM_MTM_OBJID | |
| ReferenceDocumentItem | Predecessor Document Item | CMM_VLOGP_REF_ITEM | |
| ReferenceDocBusObjType | Predecessor Document Type | OJ_NAME | |
| ProfitCenter | Profit Center | PRCTR | |
| BusinessArea | Business Area | GSBER | |
| PurchasingOrganization | Purchasing organization | EKORG | |
| MaterialGroup | Material Group | MATKL | |
| MTMConditionGroup | MtM Condition Group | CMM_MTM_CGROUP | |
| TimeToMaturity | Time to Maturity | TBA_TENOR | |
| CmmdtyForwardIndexTimingText | Short Text for Fixed Values | ||
| DerivativeContractMaturityCode | Contract Maturity Code | TBA_CONTRACT_CODE | |
| FinancialAssetsMgmtProductType | Product Type | VVSART | |
| FinInstrTransactionCategory | Transaction Category | T_SFGTYP | |
| FinancialInstrumentProductType | Financial Transaction Type | T_SFHAART | |
| OptionStrikeCurrency | Currency Unit of the Rate | VVSRUNIT | |
| OptionStrikePrice | Option Strike Price | ||
| ExternalKeyFigureValue | External Key figures | ||
| OptionDeltaFactor | Option Delta Factor Value | CDS_OPTION_DELTA_FACTOR | |
| DerivativeContrSpecification | Derivative Contract Specification ID | TBA_DCSID | |
| MarketIdentifierCode | Market Identifier Code | TBA_MIC | |
| AdjustedReportingYear | Abjusted Reporting Year | ||
| AdjustedReportingMonth | Adjusted Reporting Month | ||
| SystemMessageText | Message Text | NATXT | |
| PriceSettingMethod | Price Setting Method | CPE_PSMETHOD | |
| PriceSettingMethodStatus | Price Setting Method Status | CPE_PSMSTATUS | |
| ValidToDateTime | Valid-To Timestamp | TZNTSTMPS | |
| PricingProcedure | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM | |
| PricingConditionTerm | CPE Term - Number in Formula | NUMC5 |