- 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_Cmmdtynapnlvalue_Query
Commodity NA PnL Value
| view: CCMMNAPNLVALUE | TRAN
| Extraction:
Not supported
| Component: Basic Functions
Tables used:
CMM_TPL_EVENTS, T100
Column Name | Description | |
---|---|---|
PricingKey | A key required to access versioned pricing data |
Column Name | Description | |
---|---|---|
💲 Statistics Currency (StatisticsCurrency): | ||
PnLValue | PnLValue | |
SpreadPnLValue | PnL Spreads 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 | |
📏 CPE Term - Unit of Measure (MarketPriceQuantityUnit): | ||
PnLCalcRelevantMarketQuantity | PnL Calculation Relevant Market Rate Quantity | |
CmmdtyPriceExpsrQtyInMassUnit | Open Commodity Quantity In MASS | |
CmmdtyPriceExpsrQtyInVolUnit | Open Commodity Quantity In Volume |
Column Name | Description | |
---|---|---|
EvaluationDate | Snapshot End Date | |
ComparativeEvaluationDate | Snapshot Start Date | |
QuotationPeriodReferenceDate | Reference Date | |
ContractMaturityKeyDate | Contract Maturity Key Date | |
MktMaturityKeyDate | Market Maturity Key Date | |
ValidityStartDate | Valid-From Date | |
ValidityStartDateTime | Valid-From Time | |
DeliveryDate | Delivery Date | |
ExpectedPaymentDate | Payment Date | |
ExchRateMaturityDate | Maturity Date | |
FixedExchRateDate | Date when forward FX rate is frozen | |
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 |
Column Name | Description | |
---|---|---|
PnLEventGroup | Profit and Loss Event Group | Show values |
MTMDataSourceType | Type of Data Record | Show values |
PricingStatus | Future/Basis Price Fixation Status | Show values |
HasError | Flag: Error occured | Show values |
IsIntercompanyTransfer | Intercompany Transfer | Show values |
QuotationGroupCalculationRule | Quotation Group Operation | Show values |
MTMAdjustmentType | Type of adjustment for the MtM or TPL calculation | Show values |
PriceIsRealized | Indicates that the MtM value is realized | Show values |
Column Name | Description | Domain name | |
---|---|---|---|
CompanyCode | Company Code | BUKRS | |
ProfitCenter | Profit Center | PRCTR | |
Plant | Plant | WERKS | |
Commodity | Commodity | TBA_STOEFFCHEN | |
MTMCalculationGroup | MtM Calculation Group | CMM_MTM_CGROUP | |
PnLEventType | Profit and Loss Event Type | CMM_EVENT | |
PnLElementaryEventType | Profit and Loss Elementary Event Type | CMM_EVENT | |
OriginReferenceDocument | Root Document | CMM_MTM_OBJID | |
OriginReferenceDocumentItem | Origin Reference Document Item | ||
OriginReferenceDocBusObjType | Root Document (BOR) Object Type | OJ_NAME | |
SourceDocument | Document | CMM_MTM_OBJID | |
SourceDocumentItem | Source Document Item | ||
SourceDocumentBusObjType | Document (BOR) Object Type | OJ_NAME | |
ConditionTermRateFixation | Fixation ID | ||
ConditionType | Condition Type | KSCHL | |
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 | |
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 | |
SubConditionType | The key of a sub-condition type | CMM_VLOGP_SUBKEY | |
SystemMessageNumber | System Message Number | ||
ContractConditionTermRate | Contract Condition Term Rate | ||
ComparContrCndnTermRate | Comparative Contract Condition Term Rate | ||
ConditionTermFactor | CPE condition type term factor | ||
ComparConditionTermFactor | Comparative CPE condition type term factor | ||
MarketConditionTermRate | Market Term Rate | ||
ContrSpreadCndnTermRate | Contract Spread Term Rate | ||
FixedMktSpreadCndnTermRate | Fixed Market Spread Term Rate | ||
FloatingMktSpreadCndnTermRate | Floating Market Spread Term Rate | ||
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. | ||
MktMarketToDocExchRate | Market Exchange Rate: Market to Document Currency | ||
MktDocToStstcExchRate | Market Exchange Rate: Document to Statistics Currency | ||
MktMarketToStstcExchRate | Market Exchange Rate: Market to Statistics Currency | ||
CalcRelContrConditionTermRate | Calculation Relevant Contract Condition Term Rate | ||
CalcRelComparContrCndnTermRate | CalculationRelevant Comparative Contract Condition Term Rate | ||
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 | |
StorageLocation | Storage location | LGORT | |
Batch | Batch Number | CHARG | |
IncotermsClassification | Incoterms (Part 1) | INCO1 | |
IncotermsTransferLocation | Incoterms (Part 2) | INCO2 | |
ConditionApplication | Application | KAPPL | |
ReferenceDocument | Predecessor Document | CMM_MTM_OBJID | |
ReferenceDocumentItem | Reference Document Item | ||
ReferenceDocBusObjType | Ref (BOR) Object Type | OJ_NAME | |
BusinessArea | Business Area | GSBER | |
PurchasingOrganization | Purchasing organization | EKORG | |
MaterialGroup | Material Group | MATKL | |
QuotationGroup | Quotation Group (Technical Key Field) | CHAR40 | |
MTMConditionGroupCategoryName | Short Text for Fixed Values | DDTEXT | |
MTMConditionGroup | MtM Condition Group | CMM_MTM_CGROUP | |
MTMCalcGrpMarketPriceCondition | Market Price Condition within a calculation group | KSCHL | |
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 |
Master Data Relations | Join Conditions |
---|---|
Profit and Loss Event Category
|
|