C_Cmmdtybppnlvalue_Query
Commodity BP PnL Value
C_Cmmdtybppnlvalue_Query is a Consumption CDS View that provides data about "Commodity BP PnL Value" in SAP S/4HANA. It reads from 1 data source (I_Cmmdtybppnlvalue_Cube) and exposes 118 fields.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_Cmmdtybppnlvalue_Cube | I_Cmmdtybppnlvalue_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 | CCMMBPPNLVALUE | view | |
| EndUserText.label | Commodity BP 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_CMMDTYBEGINPOSPNLVALQRY | view |
Fields (118)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 | ||
| MTMAdjustmentType | cube | MTMAdjustmentType | ||
| OriginReferenceDocument | cube | OriginReferenceDocument | Root Document | |
| 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 | |
| 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 | |
| ComparativeMarketDCS | cube | ComparativeMarketDCS | ||
| ComparMktMarketIdentifierCode | cube | ComparMktMarketIdentifierCode | ||
| ComparMktMaturityKeyDate | cube | ComparMktMaturityKeyDate | ||
| ComparMktDrvtvContrCode | cube | ComparMktDrvtvContrCode | ||
| ComparMarketBasisID | cube | ComparMarketBasisID | ||
| ComparMarketBasisType | cube | ComparMarketBasisType | ||
| ComparMktQuotationPriceType | cube | ComparMktQuotationPriceType | ||
| PricingStatus | cube | PricingStatus | ||
| SubConditionType | cube | SubConditionType | ||
| HasError | cube | HasError | TRUE | |
| SystemMessageNumber | cube | SystemMessageNumber | Message Number | |
| CommodityUnit | cube | CommodityUnit | Order Unit | |
| ConditionTermRateQuantityUnit | cube | ConditionTermRateQuantityUnit | ||
| StatisticsCurrency | cube | StatisticsCurrency | ||
| PnLValue | cube | PnLValue | ||
| MktPricePnLValue | cube | MktPricePnLValue | ||
| SpreadPnLValue | cube | SpreadPnLValue | ||
| DocToStstcFXPnLValue | cube | DocToStstcFXPnLValue | ||
| MktToStstcFXPnLValue | cube | MktToStstcFXPnLValue | ||
| MktValAdjmtFXBroughtFwdVal | cube | MktValAdjmtFXBroughtFwdVal | ||
| CommodityQuantityInTermUnit | cube | CommodityQuantityInTermUnit | ||
| ComparCmmdtyQuantityInTermUnit | cube | ComparCmmdtyQuantityInTermUnit | ||
| PnLCalculationRelevantQuantity | cube | PnLCalculationRelevantQuantity | ||
| MarketConditionTermRate | cube | MarketConditionTermRate | ||
| ComparMktConditionTermRate | cube | ComparMktConditionTermRate | ||
| PnLCalculationRelevantValue | cube | PnLCalculationRelevantValue | ||
| ContrSpreadCndnTermRate | ||||
| ComparContrSpreadCndnTermRate | ||||
| FixedMktSpreadCndnTermRate | ||||
| FloatingMktSpreadCndnTermRate | ||||
| ContractConditionTermRate | cube | ContractConditionTermRate | ||
| ComparContrCndnTermRate | cube | ComparContrCndnTermRate | ||
| MktMarketToDocExchRate | cube | MktMarketToDocExchRate | ||
| ComparMktMarketToDocExchRate | cube | ComparMktMarketToDocExchRate | ||
| ContractMktToDocExchRate | cube | ContractMktToDocExchRate | ||
| MktDocToStstcExchRate | cube | MktDocToStstcExchRate | ||
| ComparMktDocToStstcExchRate | cube | ComparMktDocToStstcExchRate | ||
| MktMarketToStstcExchRate | cube | MktMarketToStstcExchRate | ||
| ComparMktMarketToStstcExchRate | cube | ComparMktMarketToStstcExchRate | ||
| MktAdjmtValDocToStstcExchRate | cube | MktAdjmtValDocToStstcExchRate | ||
| MktAdjmtValueCndnTermValue | cube | MktAdjmtValueCndnTermValue | ||
| ConditionTermFactor | cube | ConditionTermFactor | ||
| ComparConditionTermFactor | cube | ComparConditionTermFactor | ||
| SalesOrganization | cube | SalesOrganization | Sales Organization | |
| 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 | ||
| QuotationPeriodReferenceDate | cube | QuotationPeriodReferenceDate | ||
| ComparQtanPeriodReferenceDate | cube | ComparQtanPeriodReferenceDate | ||
| 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 | ||
| MTMCalcGrpMarketPriceCondition | cube | MTMCalcGrpMarketPriceCondition | ||
| PriceIsRealized | cube | PriceIsRealized | ||
| PricingKey | cube | PricingKey | Pricing Key | |
| CmmdtyPriceExpsrQtyInMassUnit | cube | CmmdtyPriceExpsrQtyInMassUnit | ||
| CmmdtyPriceExpsrMassUnit | cube | CmmdtyPriceExpsrMassUnit | ||
| CmmdtyPriceExpsrQtyInVolUnit | cube | CmmdtyPriceExpsrQtyInVolUnit | ||
| CmmdtyPriceExpsrVolumeUnit | cube | CmmdtyPriceExpsrVolumeUnit | ||
| SystemMessageText | ||||
| ConditionTermRateCurrency | cube | ConditionTermRateCurrency | ||
| 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_Cmmdtybppnlvalue_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: CCMMBPPNLVALUE
-- Parameters: P_EndOfDaySnapshotToDate : cmm_snapshot_end, P_EndOfDaySnapshotFromDate : cmm_snapshot_start, P_Language : spras
CREATE VIEW C_Cmmdtybppnlvalue_Query AS
SELECT
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.MTMAdjustmentType AS MTMAdjustmentType,
cube.OriginReferenceDocument AS OriginReferenceDocument,
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.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.ComparativeMarketDCS AS ComparativeMarketDCS,
cube.ComparMktMarketIdentifierCode AS ComparMktMarketIdentifierCode,
cube.ComparMktMaturityKeyDate AS ComparMktMaturityKeyDate,
cube.ComparMktDrvtvContrCode AS ComparMktDrvtvContrCode,
cube.ComparMarketBasisID AS ComparMarketBasisID,
cube.ComparMarketBasisType AS ComparMarketBasisType,
cube.ComparMktQuotationPriceType AS ComparMktQuotationPriceType,
cube.PricingStatus AS PricingStatus,
cube.SubConditionType AS SubConditionType,
cube.HasError AS HasError,
cube.SystemMessageNumber AS SystemMessageNumber,
cube.CommodityUnit AS CommodityUnit,
cube.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
cube.StatisticsCurrency AS StatisticsCurrency,
cube.PnLValue AS PnLValue,
cube.MktPricePnLValue AS MktPricePnLValue,
cube.SpreadPnLValue AS SpreadPnLValue,
cube.DocToStstcFXPnLValue AS DocToStstcFXPnLValue,
cube.MktToStstcFXPnLValue AS MktToStstcFXPnLValue,
cube.MktValAdjmtFXBroughtFwdVal AS MktValAdjmtFXBroughtFwdVal,
cube.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
cube.ComparCmmdtyQuantityInTermUnit AS ComparCmmdtyQuantityInTermUnit,
cube.PnLCalculationRelevantQuantity AS PnLCalculationRelevantQuantity,
cube.MarketConditionTermRate AS MarketConditionTermRate,
cube.ComparMktConditionTermRate AS ComparMktConditionTermRate,
cube.PnLCalculationRelevantValue AS PnLCalculationRelevantValue,
cube.ContractConditionTermRate AS ContractConditionTermRate,
cube.ComparContrCndnTermRate AS ComparContrCndnTermRate,
cube.MktMarketToDocExchRate AS MktMarketToDocExchRate,
cube.ComparMktMarketToDocExchRate AS ComparMktMarketToDocExchRate,
cube.ContractMktToDocExchRate AS ContractMktToDocExchRate,
cube.MktDocToStstcExchRate AS MktDocToStstcExchRate,
cube.ComparMktDocToStstcExchRate AS ComparMktDocToStstcExchRate,
cube.MktMarketToStstcExchRate AS MktMarketToStstcExchRate,
cube.ComparMktMarketToStstcExchRate AS ComparMktMarketToStstcExchRate,
cube.MktAdjmtValDocToStstcExchRate AS MktAdjmtValDocToStstcExchRate,
cube.MktAdjmtValueCndnTermValue AS MktAdjmtValueCndnTermValue,
cube.ConditionTermFactor AS ConditionTermFactor,
cube.ComparConditionTermFactor AS ComparConditionTermFactor,
cube.SalesOrganization AS SalesOrganization,
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.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
cube.ComparQtanPeriodReferenceDate AS ComparQtanPeriodReferenceDate,
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.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
cube.PriceIsRealized AS PriceIsRealized,
cube.PricingKey AS PricingKey,
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.ConditionTermRateCurrency AS ConditionTermRateCurrency,
cube.PriceSettingMethod AS PriceSettingMethod,
cube.PriceSettingMethodStatus AS PriceSettingMethodStatus,
cube.ValidToDateTime AS ValidToDateTime,
cube.PricingProcedure AS PricingProcedure,
cube.PricingConditionTerm AS PricingConditionTerm
FROM I_Cmmdtybppnlvalue_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