C_Cmmdtynapnlvalue_Query
Commodity NA PnL Value
C_Cmmdtynapnlvalue_Query is a Consumption CDS View that provides data about "Commodity NA PnL Value" in SAP S/4HANA. It reads from 1 data source (I_Cmmdtynapnlvalue_Cube) and exposes 123 fields with key field PricingKey.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_Cmmdtynapnlvalue_Cube | I_Cmmdtynapnlvalue_Cube | from |
Parameters (3)
| Name | Type | Default |
|---|---|---|
| P_EndOfDaySnapshotToDate | cmm_snapshot_end | |
| P_EndOfDaySnapshotFromDate | cmm_snapshot_start | |
| P_Language | spras |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| Analytics.query | true | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| AbapCatalog.sqlViewName | CCMMNAPNLVALUE | view | |
| EndUserText.label | Commodity NA PnL Value | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.lifecycle.status | #DEPRECATED | view | |
| VDM.lifecycle.successor | C_CMMDTYNEWACTPNLVALQRY | view |
Fields (123)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PricingKey | cube | PricingKey | Pricing Key |
| EvaluationDate | cube | EvaluationDate | ||
| ComparativeEvaluationDate | cube | ComparativeEvaluationDate | ||
| CompanyCode | cube | CompanyCode | Receiver Company Code | |
| ProfitCenter | cube | ProfitCenter | Profit Center | |
| Plant | cube | Plant | Valuation Area | |
| Commodity | cube | Commodity | Commodity Code | |
| MTMCalculationGroup | cube | MTMCalculationGroup | ||
| PnLEventGroup | cube | PnLEventGroup | ||
| PnLEventCategory | cube | PnLEventCategory | ||
| PnLEventType | cube | PnLEventType | ||
| PnLElementaryEventType | cube | PnLElementaryEventType | ||
| MTMAdjustmentType | ||||
| OriginReferenceDocument | ||||
| QuotationPeriodReferenceDate | cube | QuotationPeriodReferenceDate | ||
| OriginReferenceDocumentItem | cube | OriginReferenceDocumentItem | Root Document Item | |
| OriginReferenceDocBusObjType | cube | OriginReferenceDocBusObjType | Root (BOR) Obj. Type | |
| SourceDocument | cube | SourceDocument | Document | |
| SourceDocumentItem | cube | SourceDocumentItem | ||
| SourceDocumentBusObjType | cube | SourceDocumentBusObjType | ||
| ConditionTermRateFixation | cube | ConditionTermRateFixation | ||
| ConditionType | cube | ConditionType | Condition type | |
| ContractConditionType | ||||
| ContractDCS | ||||
| ContractMarketIdentifierCode | cube | ContractMarketIdentifierCode | ||
| ContrDrvtvContrMaturityCode | cube | ContrDrvtvContrMaturityCode | ||
| ContractMaturityKeyDate | cube | ContractMaturityKeyDate | ||
| ContractBasisType | cube | ContractBasisType | ||
| ContractBasisID | cube | ContractBasisID | ||
| ContractQuotationPriceType | cube | ContractQuotationPriceType | ||
| MarketDCS | cube | MarketDCS | ||
| MktMarketIdentifierCode | cube | MktMarketIdentifierCode | ||
| MktDrvtvContrMaturityCode | cube | MktDrvtvContrMaturityCode | ||
| MktMaturityKeyDate | cube | MktMaturityKeyDate | ||
| MarketBasisType | cube | MarketBasisType | ||
| MarketBasisID | cube | MarketBasisID | ||
| MktQuotationPriceType | cube | MktQuotationPriceType | ||
| MTMDataSourceType | cube | MTMDataSourceType | Type of Data Record | |
| PricingStatus | cube | PricingStatus | ||
| ValidityStartDate | cube | ValidityStartDate | Validity Start Date | |
| ValidityStartDateTime | cube | ValidityStartDateTime | Valid From Timestamp | |
| SubConditionType | cube | SubConditionType | ||
| HasError | cube | HasError | TRUE | |
| SystemMessageNumber | cube | SystemMessageNumber | Message Number | |
| CommodityUnit | cube | CommodityUnit | Order Unit | |
| ConditionTermRateQuantityUnit | cube | ConditionTermRateQuantityUnit | ||
| MarketPriceQuantityUnit | ||||
| StatisticsCurrency | ||||
| PnLValue | cube | PnLValue | ||
| SpreadPnLValue | cube | SpreadPnLValue | ||
| CommodityQuantityInTermUnit | cube | CommodityQuantityInTermUnit | ||
| ComparCmmdtyQuantityInTermUnit | cube | ComparCmmdtyQuantityInTermUnit | ||
| PnLCalculationRelevantQuantity | cube | PnLCalculationRelevantQuantity | ||
| ContractConditionTermRate | cube | ContractConditionTermRate | ||
| ComparContrCndnTermRate | ||||
| ConditionTermFactor | cube | ConditionTermFactor | ||
| ComparConditionTermFactor | cube | ComparConditionTermFactor | ||
| PnLCalcRelevantMarketQuantity | ||||
| MarketConditionTermRate | ||||
| ContrSpreadCndnTermRate | ||||
| FixedMktSpreadCndnTermRate | ||||
| FloatingMktSpreadCndnTermRate | ||||
| ContractMktToDocExchRate | cube | ContractMktToDocExchRate | ||
| ComparContrMktToDocExchRate | cube | ComparContrMktToDocExchRate | ||
| ContrDocToStstcExchRate | cube | ContrDocToStstcExchRate | ||
| ComparContrDocToStstcExchRate | cube | ComparContrDocToStstcExchRate | ||
| MktMarketToDocExchRate | cube | MktMarketToDocExchRate | ||
| MktDocToStstcExchRate | cube | MktDocToStstcExchRate | ||
| MktMarketToStstcExchRate | cube | MktMarketToStstcExchRate | ||
| CalcRelContrConditionTermRate | ||||
| CalcRelComparContrCndnTermRate | cube | CalcRelComparContrCndnTermRate | ||
| SalesOrganization | ||||
| DistributionChannel | cube | DistributionChannel | RefDistCh-Cust/Mat. | |
| Division | cube | Division | Internal Division ID | |
| Creditor | cube | Creditor | Supplier | |
| SoldToParty | cube | SoldToParty | Sold-to Party | |
| Material | cube | Material | Vehicle Model | |
| StorageLocation | cube | StorageLocation | StorageLocation | |
| Batch | cube | Batch | Lot No. | |
| IncotermsClassification | cube | IncotermsClassification | Incoterms | |
| IncotermsTransferLocation | cube | IncotermsTransferLocation | Incoterms 2 | |
| ConditionApplication | cube | ConditionApplication | Application | |
| ReferenceDocument | cube | ReferenceDocument | Reference Document | |
| ReferenceDocumentItem | cube | ReferenceDocumentItem | Reference item | |
| ReferenceDocBusObjType | cube | ReferenceDocBusObjType | Pred(BOR) Object Typ | |
| DeliveryDate | cube | DeliveryDate | Delivery Date | |
| ExpectedPaymentDate | cube | ExpectedPaymentDate | ||
| DocumentCurrency | cube | DocumentCurrency | Document Currency | |
| SpreadCurrency | cube | SpreadCurrency | ||
| BusinessArea | ||||
| PurchasingOrganization | cube | PurchasingOrganization | Purchasing Organization | |
| MaterialGroup | cube | MaterialGroup | Product Group | |
| IsIntercompanyTransfer | cube | IsIntercompanyTransfer | ||
| ExchRateMaturityDate | cube | ExchRateMaturityDate | ||
| FixedExchRateDate | cube | FixedExchRateDate | ||
| QuotationPeriodStartDate | cube | QuotationPeriodStartDate | ||
| QuotationPeriodEndDate | cube | QuotationPeriodEndDate | ||
| QuotationGroup | cube | QuotationGroup | ||
| QuotationGroupCalculationRule | cube | QuotationGroupCalculationRule | ||
| CndnTermRateFixationDate | cube | CndnTermRateFixationDate | ||
| CndnTermRateFixationTime | cube | CndnTermRateFixationTime | ||
| CndnTermExchRateFixationDate | cube | CndnTermExchRateFixationDate | ||
| CndnTermExchRateFixationTime | cube | CndnTermExchRateFixationTime | ||
| MTMConditionGroupCategoryName | ||||
| MTMConditionGroup | cube | MTMConditionGroup | ||
| MTMAdjustmentType | cube | MTMAdjustmentType | ||
| MTMCalcGrpMarketPriceCondition | ||||
| PriceIsRealized | cube | PriceIsRealized | ||
| CmmdtyPriceExpsrQtyInMassUnit | cube | CmmdtyPriceExpsrQtyInMassUnit | ||
| CmmdtyPriceExpsrMassUnit | cube | CmmdtyPriceExpsrMassUnit | ||
| CmmdtyPriceExpsrQtyInVolUnit | cube | CmmdtyPriceExpsrQtyInVolUnit | ||
| CmmdtyPriceExpsrVolumeUnit | cube | CmmdtyPriceExpsrVolumeUnit | ||
| SystemMessageText | ||||
| CalcRlvtComparCndnTrmRateCrcy | cube | CalcRlvtComparCndnTrmRateCrcy | ||
| ComparContrCndnTrmRateCurrency | cube | ComparContrCndnTrmRateCurrency | ||
| CalcRlvtContrCndnTrmRateCrcy | cube | CalcRlvtContrCndnTrmRateCrcy | ||
| ConditionTermRateCurrency | cube | ConditionTermRateCurrency | ||
| ContrConditionTermRateCurrency | cube | ContrConditionTermRateCurrency | ||
| PriceSettingMethod | cube | PriceSettingMethod | ||
| PriceSettingMethodStatus | cube | PriceSettingMethodStatus | ||
| ValidToDateTime | cube | ValidToDateTime | Time Stamp | |
| PricingProcedure | cube | PricingProcedure | Procedure | |
| PricingConditionTerm | cube | PricingConditionTerm | Term Number |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view C_Cmmdtynapnlvalue_Query.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CCMMNAPNLVALUE
-- Parameters: P_EndOfDaySnapshotToDate : cmm_snapshot_end, P_EndOfDaySnapshotFromDate : cmm_snapshot_start, P_Language : spras
CREATE VIEW C_Cmmdtynapnlvalue_Query AS
SELECT
cube.PricingKey AS PricingKey,
cube.EvaluationDate AS EvaluationDate,
cube.ComparativeEvaluationDate AS ComparativeEvaluationDate,
cube.CompanyCode AS CompanyCode,
cube.ProfitCenter AS ProfitCenter,
cube.Plant AS Plant,
cube.Commodity AS Commodity,
cube.MTMCalculationGroup AS MTMCalculationGroup,
cube.PnLEventGroup AS PnLEventGroup,
cube.PnLEventCategory AS PnLEventCategory,
cube.PnLEventType AS PnLEventType,
cube.PnLElementaryEventType AS PnLElementaryEventType,
cube.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
cube.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
cube.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
cube.SourceDocument AS SourceDocument,
cube.SourceDocumentItem AS SourceDocumentItem,
cube.SourceDocumentBusObjType AS SourceDocumentBusObjType,
cube.ConditionTermRateFixation AS ConditionTermRateFixation,
cube.ConditionType AS ConditionType,
cube.ContractMarketIdentifierCode AS ContractMarketIdentifierCode,
cube.ContrDrvtvContrMaturityCode AS ContrDrvtvContrMaturityCode,
cube.ContractMaturityKeyDate AS ContractMaturityKeyDate,
cube.ContractBasisType AS ContractBasisType,
cube.ContractBasisID AS ContractBasisID,
cube.ContractQuotationPriceType AS ContractQuotationPriceType,
cube.MarketDCS AS MarketDCS,
cube.MktMarketIdentifierCode AS MktMarketIdentifierCode,
cube.MktDrvtvContrMaturityCode AS MktDrvtvContrMaturityCode,
cube.MktMaturityKeyDate AS MktMaturityKeyDate,
cube.MarketBasisType AS MarketBasisType,
cube.MarketBasisID AS MarketBasisID,
cube.MktQuotationPriceType AS MktQuotationPriceType,
cube.MTMDataSourceType AS MTMDataSourceType,
cube.PricingStatus AS PricingStatus,
cube.ValidityStartDate AS ValidityStartDate,
cube.ValidityStartDateTime AS ValidityStartDateTime,
cube.SubConditionType AS SubConditionType,
cube.HasError AS HasError,
cube.SystemMessageNumber AS SystemMessageNumber,
cube.CommodityUnit AS CommodityUnit,
cube.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
cube.PnLValue AS PnLValue,
cube.SpreadPnLValue AS SpreadPnLValue,
cube.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
cube.ComparCmmdtyQuantityInTermUnit AS ComparCmmdtyQuantityInTermUnit,
cube.PnLCalculationRelevantQuantity AS PnLCalculationRelevantQuantity,
cube.ContractConditionTermRate AS ContractConditionTermRate,
cube.ConditionTermFactor AS ConditionTermFactor,
cube.ComparConditionTermFactor AS ComparConditionTermFactor,
cube.ContractMktToDocExchRate AS ContractMktToDocExchRate,
cube.ComparContrMktToDocExchRate AS ComparContrMktToDocExchRate,
cube.ContrDocToStstcExchRate AS ContrDocToStstcExchRate,
cube.ComparContrDocToStstcExchRate AS ComparContrDocToStstcExchRate,
cube.MktMarketToDocExchRate AS MktMarketToDocExchRate,
cube.MktDocToStstcExchRate AS MktDocToStstcExchRate,
cube.MktMarketToStstcExchRate AS MktMarketToStstcExchRate,
cube.CalcRelComparContrCndnTermRate AS CalcRelComparContrCndnTermRate,
cube.DistributionChannel AS DistributionChannel,
cube.Division AS Division,
cube.Creditor AS Creditor,
cube.SoldToParty AS SoldToParty,
cube.Material AS Material,
cube.StorageLocation AS StorageLocation,
cube.Batch AS Batch,
cube.IncotermsClassification AS IncotermsClassification,
cube.IncotermsTransferLocation AS IncotermsTransferLocation,
cube.ConditionApplication AS ConditionApplication,
cube.ReferenceDocument AS ReferenceDocument,
cube.ReferenceDocumentItem AS ReferenceDocumentItem,
cube.ReferenceDocBusObjType AS ReferenceDocBusObjType,
cube.DeliveryDate AS DeliveryDate,
cube.ExpectedPaymentDate AS ExpectedPaymentDate,
cube.DocumentCurrency AS DocumentCurrency,
cube.SpreadCurrency AS SpreadCurrency,
cube.PurchasingOrganization AS PurchasingOrganization,
cube.MaterialGroup AS MaterialGroup,
cube.IsIntercompanyTransfer AS IsIntercompanyTransfer,
cube.ExchRateMaturityDate AS ExchRateMaturityDate,
cube.FixedExchRateDate AS FixedExchRateDate,
cube.QuotationPeriodStartDate AS QuotationPeriodStartDate,
cube.QuotationPeriodEndDate AS QuotationPeriodEndDate,
cube.QuotationGroup AS QuotationGroup,
cube.QuotationGroupCalculationRule AS QuotationGroupCalculationRule,
cube.CndnTermRateFixationDate AS CndnTermRateFixationDate,
cube.CndnTermRateFixationTime AS CndnTermRateFixationTime,
cube.CndnTermExchRateFixationDate AS CndnTermExchRateFixationDate,
cube.CndnTermExchRateFixationTime AS CndnTermExchRateFixationTime,
cube._MTMConditionGroupCategory._MtmConditionGroupCategoryT[1:Language = :P_Language].MTMConditionGroupCategoryName AS MTMConditionGroupCategoryName,
cube.MTMConditionGroup AS MTMConditionGroup,
cube.MTMAdjustmentType AS MTMAdjustmentType,
cube.PriceIsRealized AS PriceIsRealized,
cube.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
cube.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
cube.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
cube.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
cube._CmmdtyMtmMessage[1:Language = :P_Language].SystemMessageText AS SystemMessageText,
cube.CalcRlvtComparCndnTrmRateCrcy AS CalcRlvtComparCndnTrmRateCrcy,
cube.ComparContrCndnTrmRateCurrency AS ComparContrCndnTrmRateCurrency,
cube.CalcRlvtContrCndnTrmRateCrcy AS CalcRlvtContrCndnTrmRateCrcy,
cube.ConditionTermRateCurrency AS ConditionTermRateCurrency,
cube.ContrConditionTermRateCurrency AS ContrConditionTermRateCurrency,
cube.PriceSettingMethod AS PriceSettingMethod,
cube.PriceSettingMethodStatus AS PriceSettingMethodStatus,
cube.ValidToDateTime AS ValidToDateTime,
cube.PricingProcedure AS PricingProcedure,
cube.PricingConditionTerm AS PricingConditionTerm
FROM I_Cmmdtynapnlvalue_Cube
;Learn More
- S/4HANA CDS View Deprecation: What You Need to Know
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA