P_RAAnlytsUnitPriceByItem

DDL: P_RAANLYTSUNITPRICEBYITEM Type: view_entity COMPOSITE
31 Fields 2 Data Sources

P_RAAnlytsUnitPriceByItem is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_RAAnlytsPerfOblgnTransPrice, P_RAAnlytsPriceOfTmeBsdItem) and exposes 31 fields with key fields PerformanceObligation, PerformanceObligationClass, PerformanceObligationClass.

Data Sources (2)

SourceAliasJoin Type
P_RAAnlytsPerfOblgnTransPrice _RAAnlytsPerfOblgnTransPrice union
P_RAAnlytsPriceOfTmeBsdItem _RAAnlytsPriceOfTmeBsdItem from

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation P_RAAnlytsPriceOfTmeBsdItem PerformanceObligation Performance Obligation
KEY PerformanceObligationClass P_RAAnlytsPriceOfTmeBsdItem PerformanceObligationClass Performance Obligation Name
RevenueAccountingContract P_RAAnlytsPriceOfTmeBsdItem RevenueAccountingContract Revenue Contract
CompanyCode P_RAAnlytsPriceOfTmeBsdItem CompanyCode Receiver Company Code
AccountingPrinciple P_RAAnlytsPriceOfTmeBsdItem AccountingPrinciple AP Ledger/CoCode
RAPerfOblgnInceptionDate P_RAAnlytsPriceOfTmeBsdItem RAPerfOblgnInceptionDate Created On
PerfOblgnFulfillmentType P_RAAnlytsPriceOfTmeBsdItem PerfOblgnFulfillmentType Fulfillment Type
SalesDocumentCurrency P_RAAnlytsPriceOfTmeBsdItem SalesDocumentCurrency Currency
ContractualPrcInSlsDocCrcy P_RAAnlytsPriceOfTmeBsdItem ContractualPrcInSlsDocCrcy Contractual Price
SSPriceInSalesDocCrcy P_RAAnlytsPriceOfTmeBsdItem SSPriceInSalesDocCrcy Standalone Selling Price
PerfOblgnContractualQtyUnit P_RAAnlytsPriceOfTmeBsdItem PerfOblgnContractualQtyUnit Unit of Measure
PerfOblgnContractualQuantity P_RAAnlytsPriceOfTmeBsdItem PerfOblgnContractualQuantity2 Quantity
PerfOblgnEffectiveQuantityUnit P_RAAnlytsPriceOfTmeBsdItem PerfOblgnEffectiveQuantityUnit Unit of Measure
PerfOblgnEffectiveQuantity P_RAAnlytsPriceOfTmeBsdItem PerfOblgnEffectiveQuantity2 Effective Quantity
dec236asContractualUnitPrcInSlsDocCrcy
PerformanceObligation Performance Obligation
KEY PerformanceObligationClass P_RAAnlytsPerfOblgnTransPrice PerformanceObligationClass Performance Obligation Name
RevenueAccountingContract P_RAAnlytsPerfOblgnTransPrice RevenueAccountingContract Revenue Contract
CompanyCode P_RAAnlytsPerfOblgnTransPrice CompanyCode Receiver Company Code
AccountingPrinciple P_RAAnlytsPerfOblgnTransPrice AccountingPrinciple AP Ledger/CoCode
RAPerfOblgnInceptionDate P_RAAnlytsPerfOblgnTransPrice RAPerfOblgnInceptionDate Created On
PerfOblgnFulfillmentType P_RAAnlytsPerfOblgnTransPrice PerfOblgnFulfillmentType Fulfillment Type
SalesDocumentCurrency P_RAAnlytsPerfOblgnTransPrice SalesDocumentCurrency Currency
ContractualPrcInSlsDocCrcy P_RAAnlytsPerfOblgnTransPrice ContractualPrcInSlsDocCrcy Contractual Price
SSPriceInSalesDocCrcy P_RAAnlytsPerfOblgnTransPrice SSPriceInSalesDocCrcy Standalone Selling Price
PerfOblgnContractualQtyUnit P_RAAnlytsPerfOblgnTransPrice PerfOblgnContractualQtyUnit Unit of Measure
PerfOblgnContractualQuantity P_RAAnlytsPerfOblgnTransPrice PerfOblgnContractualQuantity2 Quantity
PerfOblgnEffectiveQuantityUnit P_RAAnlytsPerfOblgnTransPrice PerfOblgnEffectiveQuantityUnit Unit of Measure
PerfOblgnEffectiveQuantity P_RAAnlytsPerfOblgnTransPrice PerfOblgnEffectiveQuantity2 Effective Quantity
dec236asContractualUnitPrcInSlsDocCrcy
dec236asUnitSSPriceInSalesDocCrcy

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_RAAnlytsUnitPriceByItem.
-- 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.

CREATE VIEW P_RAAnlytsUnitPriceByItem AS
SELECT
  _RAAnlytsPriceOfTmeBsdItem.PerformanceObligation AS PerformanceObligation,
  _RAAnlytsPriceOfTmeBsdItem.PerformanceObligationClass AS PerformanceObligationClass,
  _RAAnlytsPriceOfTmeBsdItem.RevenueAccountingContract AS RevenueAccountingContract,
  _RAAnlytsPriceOfTmeBsdItem.CompanyCode AS CompanyCode,
  _RAAnlytsPriceOfTmeBsdItem.AccountingPrinciple AS AccountingPrinciple,
  _RAAnlytsPriceOfTmeBsdItem.RAPerfOblgnInceptionDate AS RAPerfOblgnInceptionDate,
  _RAAnlytsPriceOfTmeBsdItem.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  _RAAnlytsPriceOfTmeBsdItem.SalesDocumentCurrency AS SalesDocumentCurrency,
  _RAAnlytsPriceOfTmeBsdItem.ContractualPrcInSlsDocCrcy AS ContractualPrcInSlsDocCrcy,
  _RAAnlytsPriceOfTmeBsdItem.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  _RAAnlytsPriceOfTmeBsdItem.PerfOblgnContractualQtyUnit AS PerfOblgnContractualQtyUnit,
  _RAAnlytsPriceOfTmeBsdItem.PerfOblgnContractualQuantity2 AS PerfOblgnContractualQuantity,
  _RAAnlytsPriceOfTmeBsdItem.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  _RAAnlytsPriceOfTmeBsdItem.PerfOblgnEffectiveQuantity2 AS PerfOblgnEffectiveQuantity,
  cast(round( division( _RAAnlytsPriceOfTmeBsdItem.ContractualUnitPrcInSlsDocCrcy, _RAAnlytsPriceOfTmeBsdItem.PerfOblgnEffectiveQuantity, 6), 4) as abap.dec(23,6)) as ContractualUnitPrcInSlsDocCrcy AS dec236asContractualUnitPrcInSlsDocCrcy,
  cast(round( division( _RAAnlytsPerfOblgnTransPrice.UnitSSPriceInSalesDocCrcy, _RAAnlytsPerfOblgnTransPrice.PerfOblgnContractualQuantity, 6), 4) as abap.dec(23,6)) as UnitSSPriceInSalesDocCrcy AS dec236asUnitSSPriceInSalesDocCrcy
FROM P_RAAnlytsPriceOfTmeBsdItem AS _RAAnlytsPriceOfTmeBsdItem
-- UNION with additional select branch(es): P_RAAnlytsPerfOblgnTransPrice
;

Learn More