- 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)
I_CmmdtyPosValueAtRiskCube
Commodity Position Interface Cube
| view: ICMMPOSVALRSKCUB | TRAN
| Extraction:
Not supported
| Component: Basic Functions
Tables used:
CMM_FINSYNC, CMM_DEND_RUN, CMM_VFIND, CMM_VFINR, CMM_VLOGP_KONVD, MARA, T001, TKA02, TBAC_DCS, VTBFHA, CMM_GMDACC, CMM_NB_KEYDATE, MARM, CMM_VLOGP_TSER, TBAC_TENOR, T006, T006T, CMM_VLOGP, TBACT_MIC_HANDPL, TBAC_DCS_CTY, CMM_VAR_PRICETYP, CMM_MTM_BUKRS
- 🔑 Keys (13)
- 💰 Amounts (1)
- ∑ Quantities (35)
- 📅 Dates (27)
- ☰ Categorical (27)
- Other (78)
- 🔗 Relations (2)
| Column Name | Description | |
|---|---|---|
| CommodityTransactionType | Paper/Physical Indicator for Exposure Group | Show values |
| PricingKey | A key required to access versioned pricing data | |
| Version | null | |
| PricingDocumentItem | Condition item number | |
| ConditionType | Condition Type | |
| SubConditionType | The key of a sub-condition type | |
| VersStockRecordUUID | GUID assigned to the VlogP stock delta record | |
| EvaluationDate | Latest Evaluation Date | |
| PriceQuotationDate | Date of Price Quotation | |
| CompanyCode | Company Code | |
| CommodityPriceExposure | Commodity Price Exposure ID | |
| CommodityExposureCategory | Exposure Category | Show values |
| CommodityPriceSubExposure | Hash key |
| Column Name | Description | |
|---|---|---|
| 💲 CPE Term - Currency (ConditionTermValueCurrency): | ||
| ConditionTermValue | CPE Term - Value | |
| Column Name | Description | |
|---|---|---|
| 📏 CPE Term - Unit of Measure (ConditionTermRateQuantityUnit): | ||
| CommodityQuantityInTermUnit | null | |
| PricedUndeliveredContrExpsrQty | Priced Undelivered Contract Quantity | |
| UnpricedUndeliveredCtrExpsrQty | Unpriced Undelivered Contract Quantity | |
| UndeliveredMarketPrExposureQty | Undelivered Market Exposure Quantity | |
| UnpricedDeliveredCtrExpsrQty | Unpriced Delivered Contract Quantity | |
| PricedDeliveredContrExpsrQty | Priced Delivered Contract Quantity | |
| DeliveredMarketPrExposureQty | Delivered Market Exposure | |
| UnpricedContrPriceExposureQty | Unpriced Contract Quantity | |
| UnrlzdMarketPriceExposureQty | Unrealized Market Exposure Quantity | |
| PricedContractsExposureQty | Priced Contract Quantity | |
| RealizedMaterialStkPrcExpsrQty | Realized Stock Quantity | |
| TodayPricedUndeliveredExpsrQty | Today Priced Undelivered Quantity | |
| UnrealizedPriceExposureQty | Not Realized Quantity | |
| UnpricedUnrealizedPrcExpsrQty | Unpriced Not Realized Quantity | |
| TodayUnpricedUnrlzdCtrExpsrQty | Today Unpriced Not Realized Quantity | |
| ReducnNoPrcEstablishedExpsrQty | Reducing NPE Quantity | |
| NoFutureEstabPurchaseContrQty | null | |
| NoFutureEstabSalesContrQty | null | |
| FlatPricedContractsQty | FLAT Contracts Quantity | |
| NoFutrEstablishedContrExpsrQty | NFE Contracts Quantity | |
| NoBsEstablishedContrExpsrQty | NBE Contracts Quantity | |
| NoPrcEstablishedContrExpsrQty | NPE Contracts Quantity | |
| FixPricedDelivsPriceExpsrQty | Priced Delivered Quantity | |
| UndeliveredFixPrCtrPrExpsrQty | Undelivered Not Realized Contract Quantity | |
| UnpricedUnrlzdGdsIssExpsrQty | Unpriced Not Realized GR Quantity | |
| UnpricedUnrlzdGdsRcptExpsrQty | Unpriced Not Realized GR Quantity | |
| FixPricedContrPriceExpsrQty | Fix Priced Contract Quantity | |
| TodayPricedContractsExpsrQty | Today Priced Contracts Exposure Quantity | |
| InventoryAndContractsQty | Inventory and Contracts Quantity | |
| TotalPhysicalPositionQty | Total Physical Position quantity | |
| ImpliedFuturesPositionQty | Implied Futures Position Quantity | |
| BasisPositionQty | Basis Position Quantity | |
| 📏 Material Stock Unit of Measure (MaterialStockPriceExposureUnit): | ||
| MaterialStockExposureQty | Stock on Hand | |
| UnrealizedGoodsRcptPrcExpsrQty | Unrealized Goods Receipt Quantity | |
| UnrealizedGoodsIssPrcExpsrQty | Unrealized Goods Issue Quantity | |
| Column Name | Description | |
|---|---|---|
| EvaluationDate | Latest Evaluation Date | |
| PriceQuotationDate | Date of Price Quotation | |
| EndOfDaySnapshotFromDate | Evaluation Date | |
| EndOfDaySnapshotToDate | Prev. Evaluation Date (to be compared with Evaluation Date) | |
| ExpectedPaymentDate | Payment Date | |
| QuotationPeriodReferenceDate | Reference Date | |
| QuotationPeriodStartDate | Start Date of Quotation Period | |
| QuotationPeriodEndDate | End Date of Quotation Period | |
| CndnTermRateFixationDate | Rate Fixation Date | |
| CndnTermRateFixationTime | Rate Fixation Time | |
| CndnTermExchRateFixationDate | FX Fixation Date | |
| CndnTermExchRateFixationTime | FX Fixation Time | |
| FixedExchRateDate | Date when forward FX rate is frozen | |
| ExchRateMaturityDate | Maturity Date | |
| AdjustedReportingDate | Adjusted Reporting Date | |
| ExposureDueDate | Date on which the exposure is due and expires | |
| SubstitutePriceQuotationDate | Substitution Date | |
| TermStartDate | Term Start | |
| TermEndDate | Term End | |
| EndOfDaySnapshotDate | Snapshot Date | |
| ValidityStartDate | Valid-From Date | |
| ValidityStartTime | Valid-From Time | |
| ValidityEndDate | Valid-To Date | |
| ValidityEndTime | Valid-To Time | |
| DeliveryDate | Delivery Date | |
| ReportingDate | Reporting Date | |
| MaturityKeyDate | Nearby Maturity Key Date |
| Column Name | Description | |
|---|---|---|
| CommodityTransactionType | Paper/Physical Indicator for Exposure Group | Show values |
| CommodityExposureCategory | Exposure Category | Show values |
| MTMDataSourceType | Type of Data Record | Show values |
| IsIntercompanyTransfer | Intercompany Transfer | Show values |
| CmmdtyPriceFixationStatusShort | Future/Basis Price Fixation Status | Show values |
| ConditionTermRateIsRounded | Indicates whether the term rate is rounded | Show values |
| ConditionTermExtensionUsage | CPE Extension Usage | Show values |
| MaturitySelectionType | Maturity Selection Type | Show values |
| QuotationKeyType | Quotation Key Type in Document UI (all values) | Show values |
| QuotationGroupCalculationRule | Quotation Group Operation | Show values |
| PricingStatus | Future/Basis Price Fixation Status | Show values |
| DCSPeriodType | Period Type | Show values |
| MTMConditionGroupCategory | Categorization of Condition Group | Show values |
| MTMAdjustmentType | Type of adjustment for the MtM or TPL calculation | Show values |
| PriceIsRealized | Indicates that the MtM value is realized | Show values |
| ContrPriceExposureIsExecuted | Indicates that the goods movement has been executed | Show values |
| ImplicitFixationIsRelevant | Implicit Fixation Relevant | Show values |
| ConditionTermLimitRateStatus | Pricing Status for Rate Limit | Show values |
| CashFlowDirectionShort | Transaction Flow Direction | 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 |
| MTMDataSelectionType | VLOGP Data Selection Type | Show values |
| DerivativeContractSpecCategory | Derivative Category | Show values |
| DisplayView | View Variant | 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 | |
|---|---|---|---|
| EndOfDaySnapshotDateTimeFrom | Timestamp defining a End-of-day snapshot | TZNTSTMPS | |
| EndOfDaySnapshotDateTimeTo | Timestamp defining a End-of-day snapshot | TZNTSTMPS | |
| MaximumVersion | Highest Version Number | CMM_MTM_VERSION | |
| PreviousVersion | Version of an MtM Valuation Record | CMM_MTM_VERSION | |
| SalesOrganization | Sales Organization | VKORG | |
| DistributionChannel | Distribution Channel | VTWEG | |
| Division | Division | SPART | |
| Creditor | Vendor's account number | LIFNR | |
| SoldToParty | Sold-to Party | KUNNR | |
| 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 | |
| ConditionApplication | Application | KAPPL | |
| SourceDocument | Document | CMM_MTM_OBJID | |
| SourceDocumentBusObjType | Document Type | OJ_NAME | |
| OriginReferenceDocumentItem | Root Document Item | CMM_VLOGP_ROOT_ITEM | |
| OriginReferenceDocBusObjType | Root Document Type | OJ_NAME | |
| ReferenceDocumentLongNumber | 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 | |
| ConditionTermRate | Term Rate | ||
| ConditionTermRateQuantity | CPE Term - Price Unit | CPE_PRUN | |
| ConditionTermName | Description | TEXT40 | |
| ConditionTermStatus | CPE Term - Status | CPE_TERMSTATUS | |
| RoundingDecimalPlaces | Decimals of Calculated Term/Formula Rate | INT1 | |
| ConditionTermRateNmrtr | Rate factor numerator | ||
| ConditionTermRateDnmntr | Rate factor denominator | ||
| CommodityCurve | GMDACC Key | CHAR40 | |
| QuotationPriceType | Type of Price Quotation | VVSKURSART | |
| QuotationDateList | The key of a date list | CHAR40 | |
| BasisType | Basis Type | TBAC_BASIS_TYPE | |
| BasisID | Basis ID | TBAC_BASIS_ID | |
| QuotationGroup | Quotation Group (Technical Key Field) | CHAR40 | |
| ConditionTermRateFixation | CPE Term - Number in Formula | NUMC5 | |
| MaturitySelectionRoutine | Maturity Selection Routine | CPE_ROUTINE | |
| QuantitySign | Sign of Quantity | CMM_VLOGP_SIGNAGE_QTY | |
| MTMConditionGroup | MtM Condition Group | CMM_MTM_CGROUP | |
| MTMCalculationGroup | MtM Calculation Group | CMM_MTM_CGROUP | |
| MTMCalcGrpMarketPriceCondition | Market Price Condition within a calculation group | KSCHL | |
| MinimumConditionTermLimitRate | Minimum of Commodity Rate Calculation | ||
| MaximumConditionTermLimitRate | Maximum of Commodity Rate Calculation | ||
| ConditionTermLimitRateQuantity | CPE Term - Price Unit of Rate Calculation Limits | CPE_PRUN | |
| AdjustedReportingYear | Abjusted Reporting Year | ||
| AdjustedReportingMonth | Adjusted Reporting Month | CHAR3 | |
| GoodsMovementLongNumber | Document | CMM_MTM_OBJID | |
| TimeToMaturity | Time to Maturity | TBA_TENOR | |
| DerivativeContractMaturityCode | Contract Maturity Code | TBA_CONTRACT_CODE | |
| 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 | |
| FinancialObject | Financial Object Number | J_OBJNR | |
| NumberOfCommodityContracts | Number of Contracts | ||
| TreasuryPositionAccount | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | |
| DerivativeContract | Contract for Listed Options and Futures | WP_RANL | |
| OptionStrikePrice | Option Strike Price | ||
| OptionStrikeCurrencyUnit | Currency Unit of the Rate | VVSRUNIT | |
| EndOfDaySnapshotDateTime | Timestamp defining a End-of-day snapshot | TZNTSTMPS | |
| ValidityStartDateTime | Valid-From Timestamp | TZNTSTMPS | |
| ValidityEndDateTime | Valid-To Timestamp | TZNTSTMPS | |
| PhysicalCommodity | Commodity | TBA_STOEFFCHEN | |
| DerivativeContrSpecification | Derivative Contract Specification ID | TBA_DCSID | |
| MarketIdentifierCode | Market Identifier Code | TBA_MIC | |
| CommodityReportingYear | Reporting Year | ||
| ReportingMonth | Reporting Period | TEM_PLANNING_PERIOD | |
| SystemMessageNumber | System Message Number | ||
| CommodityPriceExposureQuantity | null | ||
| OutrightPriceExposureQty | null | ||
| OriginReferenceDocument | Root Document | CMM_MTM_OBJID | |
| Counterparty | Sold-to Party | KUNNR |
| Master Data Relations | Join Conditions |
|---|---|
Quotation Currency
| |
Controlling Area
|