- 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_CmmdtyNewActPnLValCube
Commodity PnL Value - Cube
| view: ICMMNAPNLVALCUB2 | TRAN
| Extraction:
Not supported
| Component: Basic Functions
- 🔑 Keys (5)
- 💰 Amounts (6)
- ∑ Quantities (7)
- 📅 Dates (17)
- ☰ Categorical (16)
- Other (89)
- 🔗 Relations (2)
Column Name | Description | |
---|---|---|
PricingKey | A key required to access versioned pricing data | |
LogisticsDocumentVersion | Version of an MtM Valuation Record | |
SourceDocumentItem | Source Document Item | |
ConditionType | Condition Type | |
SubConditionType | The key of a sub-condition type |
Column Name | Description | |
---|---|---|
💲 Condition Term Rate Currency (ConditionTermRateCurrency): | ||
ConditionRateAmount | Condition Amount or Percentage | |
💲 Statistics Currency (StatisticsCurrency): | ||
PnLValue | PnLValue | |
MktPricePnLValue | PnL Price Value | |
SpreadPnLValue | PnL Spreads Value | |
DocToStstcFXPnLValue | PnL Document to Statistics FX Value | |
MktToStstcFXPnLValue | PnL Market to Statistics FX Value |
Column Name | Description | |
---|---|---|
📏 Price UoM (ConditionTermRateQuantityUnit): | ||
CommodityQuantityInTermUnit | Commodity Quantity in Price Unit | |
ComparCmmdtyQuantityInTermUnit | Comparative Contract Commodity Qty in Term Unit of Measure | |
PnLCalculationRelevantQuantity | PnLRelevantTermQty | |
📏 Unit of Measure for Commodity (CommodityUnit): | ||
CommodityQuantity | Commodity Quantity | |
📏 CPE Term - Unit of Measure (MarketPriceQuantityUnit): | ||
PnLCalcRelevantMarketQuantity | PnL Calculation Relevant Market Rate Quantity | |
📏 Mass Unit of Measure (CmmdtyPriceExpsrMassUnit): | ||
CmmdtyPriceExpsrQtyInMassUnit | Open Commodity Quantity In MASS | |
📏 QuantityVolume UoM (CmmdtyPriceExpsrVolumeUnit): | ||
CmmdtyPriceExpsrQtyInVolUnit | Open Commodity Quantity In Volume |
Column Name | Description | |
---|---|---|
EvaluationDate | Snapshot End Date | |
ComparativeEvaluationDate | Snapshot Start Date | |
MktMaturityKeyDate | Market Maturity Key Date | |
ValidityStartDate | Valid-From Date | |
ValidityStartTime | Valid-From Time | |
DeliveryDate | Delivery Date | |
ExpectedPaymentDate | Payment Date | |
ExchRateMaturityDate | Maturity Date | |
FixedExchRateDate | Date when forward FX rate is frozen | |
QuotationPeriodReferenceDate | Reference Date | |
QuotationPeriodStartDate | Start Date of Quotation Period | |
QuotationPeriodEndDate | End Date of Quotation Period | |
ContractMaturityKeyDate | Contract Maturity Key Date | |
CndnTermRateFixationDate | Rate Fixation Date | |
CndnTermRateFixationTime | Rate Fixation Time | |
CndnTermExchRateFixationDate | FX Fixation Date | |
CndnTermExchRateFixationTime | FX Fixation Time |
Column Name | Description | |
---|---|---|
MTMDataSourceType | Type of Data Record | Show values |
IsIntercompanyTransfer | Intercompany Transfer | Show values |
ConditionCalculationTypeShort | Calculation Type for Condition | 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 |
MTMConditionGroupCategory | Categorization of Condition Group | Show values |
MTMAdjustmentType | Type of adjustment for the MtM or TPL calculation | Show values |
ConditionTermRateIsFixed | Indicates that the term is fixed | Show values |
ConditionTermExchRateIsFixed | Indicates that the term is fixed | Show values |
PriceIsRealized | Indicates that the MtM value is realized | Show values |
PnLEventGroup | Profit and Loss Event Group | Show values |
HasError | Flag: Error occured | Show values |
Column Name | Description | Domain name | |
---|---|---|---|
MarketDCS | Comparative Market Derivative Contract Specification ID | TBA_DCSID | |
MktMarketIdentifierCode | Comparative Market Market Identifier Code | TBA_MIC | |
MktDrvtvContrMaturityCode | Comparative Market Contract Maturity Code | TBA_CONTRACT_CODE | |
MarketBasisType | Comparative Market Basis Type | TBAC_BASIS_TYPE | |
MarketBasisID | Comparative Market Basis ID | TBAC_BASIS_ID | |
MktQuotationPriceType | Comparative Market Type of Price Quotation | VVSKURSART | |
CmmdtyEndOfDayBusinessEntyKey | Key of an Business Entity End-of-day snapshot:Char format | ||
CompanyCode | Company Code | BUKRS | |
SalesOrganization | Sales Organization | VKORG | |
DistributionChannel | Distribution Channel | VTWEG | |
Division | Division | SPART | |
Creditor | Account Number of Supplier | LIFNR | |
SoldToParty | Customer Number | KUNNR | |
Material | Material Number | MATNR | |
Commodity | Commodity | TBA_STOEFFCHEN | |
Plant | Plant | WERKS | |
StorageLocation | Storage location | LGORT | |
Batch | Batch Number | CHARG | |
IncotermsClassification | Incoterms (Part 1) | INCO1 | |
IncotermsTransferLocation | Incoterms (Part 2) | INCO2 | |
ConditionApplication | Application | KAPPL | |
SourceDocumentShortNumber | Document | CMM_DOCUMENT_CHAR10 | |
SourceDocument | Document | CMM_MTM_OBJID | |
SourceDocumentBusObjType | Document (BOR) Object Type | OJ_NAME | |
OrignRefDocumentShortNumber | Root Document | CMM_DOCUMENT_CHAR10 | |
OriginReferenceDocument | Root Document | CMM_MTM_OBJID | |
OriginReferenceDocumentItem | Origin Reference Document Item | ||
OriginReferenceDocBusObjType | Root Document (BOR) Object Type | OJ_NAME | |
ReferenceDocumentLongNumber | Predecessor Document | CMM_MTM_OBJID | |
ReferenceDocumentItem | Reference Document Item | ||
ReferenceDocBusObjType | Ref (BOR) Object Type | OJ_NAME | |
ProfitCenter | Profit Center | PRCTR | |
BusinessArea | Business Area | GSBER | |
PurchasingOrganization | Purchasing organization | EKORG | |
MaterialGroup | Material Group | MATKL | |
ConditionQuantity | Condition Pricing Unit | KPEIN | |
ConditionTermRateQuantity | Price Unit | ||
ConditionTermValue | CPE Term - Rate in Term Currency(up to 14 decimals) | CPE_INTERNAL_VALUE | |
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 | ||
ContractConditionType | Contract Price Condition Type | KSCHL | |
ContractDCS | Contractual Derivative Contract Specification ID | TBA_DCSID | |
ContractMarketIdentifierCode | Contract Market Identifier Code | TBA_MIC | |
ContrDrvtvContrMaturityCode | Contractual Contract Maturity Code | TBA_CONTRACT_CODE | |
ContractBasisType | Contract Basis Type | TBAC_BASIS_TYPE | |
ContractBasisID | Contract Basis ID | TBAC_BASIS_ID | |
ContractQuotationPriceType | Contract Type of Price Quotation | VVSKURSART | |
QuotationGroup | Quotation Group (Technical Key Field) | CHAR40 | |
ConditionTermRateFixation | Fixation ID | ||
MTMConditionGroup | MtM Condition Group | CMM_MTM_CGROUP | |
MTMCalculationGroup | MtM Calculation Group | CMM_MTM_CGROUP | |
MTMCalcGrpMarketPriceCondition | Market Price Condition within a calculation group | KSCHL | |
PnLEventType | Profit and Loss Event Type | CMM_EVENT | |
PnLElementaryEventType | Profit and Loss Elementary Event Type | CMM_EVENT | |
SystemMessageNumber | System Message Number | ||
ConditionTermFactor | CPE condition type term factor | ||
ComparConditionTermFactor | Comparative CPE condition type term factor | ||
ConditionTermRate | Market Term Rate | ||
MarketConditionTermRate | Market Term Rate | ||
ComparMktConditionTermRate | PnLCalculationRelevantValue | ||
ContractConditionTermRate | Contract Condition Term Rate | ||
ComparContrCndnTermRate | Comparative Contract Condition Term Rate | ||
ContrSpreadCndnTermRate | Contract Spread Term Rate | ||
ComparContrSpreadCndnTermRate | PnLCalculationRelevantValue | ||
FixedMktSpreadCndnTermRate | Fixed Market Spread Term Rate | ||
FloatingMktSpreadCndnTermRate | Floating Market Spread Term Rate | ||
MktMarketToDocExchRate | Market Exchange Rate: Market to Document Currency | ||
MktDocToStstcExchRate | Market Exchange Rate: Document to Statistics Currency | ||
ContractMktToDocExchRate | Contract Exchange Rate: Market to Document Currency | ||
ComparContrMktToDocExchRate | Comparative Contract Exchange Rate: Market to Document Curr. | ||
ContrDocToStstcExchRate | Contract Exchange Rate: Document to Statistics Currency | ||
ComparContrDocToStstcExchRate | Comparative Contr. Exch. Rate: Document to Statistics Curr. | ||
PnLCalculationRelevantValue | PnLCalculationRelevantValue | ||
MktMarketToStstcExchRate | Market Exchange Rate: Market to Statistics Currency | ||
ComparMktMarketToStstcExchRate | PnLCalculationRelevantValue | ||
CalcRelContrConditionTermRate | Calculation Relevant Contract Condition Term Rate | ||
CalcRelComparContrCndnTermRate | CalculationRelevant Comparative Contract Condition Term Rate | ||
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 | |
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 |
Master Data Relations | Join Conditions |
---|---|
Controlling Area
| |
Profit and Loss Event Category
|
|