P_ContrNetBegPnLCmmdty
P_ContrNetBegPnLCmmdty is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_Cmmdtybppnlvalue_Cube) and exposes 139 fields with key fields PricingKey, Version, PricingDocumentItem, ConditionType, SubConditionType.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_Cmmdtybppnlvalue_Cube | I_Cmmdtybppnlvalue_Cube | from |
Parameters (5)
| Name | Type | Default |
|---|---|---|
| P_EvaluationDate | cmm_eval_keydate | |
| P_ExchRateEvaluationDate | cmm_eval_keydate | |
| P_EndOfDaySnapshotFromDate | cmm_dend_cutdate | |
| P_EndOfDaySnapshotToDate | cmm_dend_cutdate | |
| P_CompanyCode | bukrs |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PNETBPPNLCMD | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| VDM.private | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view |
Fields (139)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PricingKey | cube | PricingKey | Pricing Key |
| KEY | Version | cube | Version | XML Vers. |
| KEY | PricingDocumentItem | cube | PricingDocumentItem | Item |
| KEY | ConditionType | cube | ConditionType | Condition type |
| KEY | SubConditionType | cube | SubConditionType | |
| ConditionTermRateQuantityUnit | cube | ConditionTermRateQuantityUnit | ||
| 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 | ||
| 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 | ||
| 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 | ||
| HasError | cube | HasError | TRUE | |
| SystemMessageNumber | cube | SystemMessageNumber | Message Number | |
| CommodityUnit | cube | CommodityUnit | Order Unit | |
| StatisticsCurrency | cube | StatisticsCurrency | ||
| PnLValue | ||||
| MktPricePnLValue | ||||
| SpreadPnLValue | ||||
| DocToStstcFXPnLValue | cube | DocToStstcFXPnLValue | ||
| MktToStstcFXPnLValue | cube | MktToStstcFXPnLValue | ||
| MktValAdjmtFXBroughtFwdVal | cube | MktValAdjmtFXBroughtFwdVal | ||
| CommodityQuantityInTermUnit | ||||
| ComparCmmdtyQuantityInTermUnit | ||||
| 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 | |
| ConditionTermRateCurrency | cube | ConditionTermRateCurrency | ||
| 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 | ||
| MTMConditionGroupCategory | cube | MTMConditionGroupCategory | ||
| _MTMConditionGroupCategory | cube | _MTMConditionGroupCategory | ||
| MTMConditionGroup | cube | MTMConditionGroup | ||
| MTMCalcGrpMarketPriceCondition | cube | MTMCalcGrpMarketPriceCondition | ||
| PriceIsRealized | cube | PriceIsRealized | ||
| _BasisID | cube | _BasisID | ||
| _CommodityUnit | cube | _CommodityUnit | ||
| _CompanyCode | cube | _CompanyCode | ||
| _ComparativeMarketDCS | cube | _ComparativeMarketDCS | ||
| _ComparMktMarketIdentifierCode | cube | _ComparMktMarketIdentifierCode | ||
| _ConditionTermRateCurrency | cube | _ConditionTermRateCurrency | ||
| _ConditionTermRateQuantityUnit | cube | _ConditionTermRateQuantityUnit | ||
| _Creditor | cube | _Creditor | ||
| _DocumentCurrency | cube | _DocumentCurrency | ||
| _SpreadCurrency | cube | _SpreadCurrency | ||
| _IncotermsClassification | ||||
| _MarketDCS | cube | _MarketDCS | ||
| _CmmdtyMtmMessage | cube | _CmmdtyMtmMessage | ||
| _Material | cube | _Material | ||
| _MktMarketIdentifierCode | cube | _MktMarketIdentifierCode | ||
| _MTMAdjustmentType | cube | _MTMAdjustmentType | ||
| _MTMCalculationGroup | cube | _MTMCalculationGroup | ||
| _MTMConditionGroup | cube | _MTMConditionGroup | ||
| _MTMDataSourceType | cube | _MTMDataSourceType | ||
| _OriginReferenceDocBusObjType | cube | _OriginReferenceDocBusObjType | ||
| _Commodity | cube | _Commodity | ||
| _Plant | cube | _Plant | ||
| _PricingStatus | cube | _PricingStatus | ||
| _ReferenceDocBusObjType | cube | _ReferenceDocBusObjType | ||
| _SoldToParty | cube | _SoldToParty | ||
| _SourceDocumentBusObjType | cube | _SourceDocumentBusObjType | ||
| _StatisticsCurrency | cube | _StatisticsCurrency | ||
| _StorageLocation | cube | _StorageLocation |
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 P_ContrNetBegPnLCmmdty.
-- 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: PNETBPPNLCMD
-- Parameters: P_EvaluationDate : cmm_eval_keydate, P_ExchRateEvaluationDate : cmm_eval_keydate, P_EndOfDaySnapshotFromDate : cmm_dend_cutdate, P_EndOfDaySnapshotToDate : cmm_dend_cutdate, P_CompanyCode : bukrs
CREATE VIEW P_ContrNetBegPnLCmmdty AS
SELECT
cube.PricingKey AS PricingKey,
cube.Version AS Version,
cube.PricingDocumentItem AS PricingDocumentItem,
cube.ConditionType AS ConditionType,
cube.SubConditionType AS SubConditionType,
cube.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
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.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.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.HasError AS HasError,
cube.SystemMessageNumber AS SystemMessageNumber,
cube.CommodityUnit AS CommodityUnit,
cube.StatisticsCurrency AS StatisticsCurrency,
sum( cube.PnLValue ) AS PnLValue,
sum( cube.MktPricePnLValue ) AS MktPricePnLValue,
sum( cube.SpreadPnLValue ) AS SpreadPnLValue,
cube.DocToStstcFXPnLValue AS DocToStstcFXPnLValue,
cube.MktToStstcFXPnLValue AS MktToStstcFXPnLValue,
cube.MktValAdjmtFXBroughtFwdVal AS MktValAdjmtFXBroughtFwdVal,
sum( cube.CommodityQuantityInTermUnit ) AS CommodityQuantityInTermUnit,
sum( cube.ComparCmmdtyQuantityInTermUnit ) AS ComparCmmdtyQuantityInTermUnit,
sum( 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.ConditionTermRateCurrency AS ConditionTermRateCurrency,
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 AS MTMConditionGroupCategory,
cube._MTMConditionGroupCategory AS _MTMConditionGroupCategory,
cube.MTMConditionGroup AS MTMConditionGroup,
cube.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
cube.PriceIsRealized AS PriceIsRealized,
cube._BasisID AS _BasisID,
cube._CommodityUnit AS _CommodityUnit,
cube._CompanyCode AS _CompanyCode,
cube._ComparativeMarketDCS AS _ComparativeMarketDCS,
cube._ComparMktMarketIdentifierCode AS _ComparMktMarketIdentifierCode,
cube._ConditionTermRateCurrency AS _ConditionTermRateCurrency,
cube._ConditionTermRateQuantityUnit AS _ConditionTermRateQuantityUnit,
cube._Creditor AS _Creditor,
cube._DocumentCurrency AS _DocumentCurrency,
cube._SpreadCurrency AS _SpreadCurrency,
cube._MarketDCS AS _MarketDCS,
cube._CmmdtyMtmMessage AS _CmmdtyMtmMessage,
cube._Material AS _Material,
cube._MktMarketIdentifierCode AS _MktMarketIdentifierCode,
cube._MTMAdjustmentType AS _MTMAdjustmentType,
cube._MTMCalculationGroup AS _MTMCalculationGroup,
cube._MTMConditionGroup AS _MTMConditionGroup,
cube._MTMDataSourceType AS _MTMDataSourceType,
cube._OriginReferenceDocBusObjType AS _OriginReferenceDocBusObjType,
cube._Commodity AS _Commodity,
cube._Plant AS _Plant,
cube._PricingStatus AS _PricingStatus,
cube._ReferenceDocBusObjType AS _ReferenceDocBusObjType,
cube._SoldToParty AS _SoldToParty,
cube._SourceDocumentBusObjType AS _SourceDocumentBusObjType,
cube._StatisticsCurrency AS _StatisticsCurrency,
cube._StorageLocation AS _StorageLocation
FROM I_Cmmdtybppnlvalue_Cube
;Learn More
- 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
- S/4HANA CDS View Deprecation: What You Need to Know
- 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