P_RAFinCmplncUnitTransPrcByNam

DDL: P_RAFINCMPLNCUNITTRANSPRCBYNAM Type: view_entity COMPOSITE
9 Fields 1 Data Sources

P_RAFinCmplncUnitTransPrcByNam is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_RAFinCmplncUnitPriceByItem) and exposes 9 fields with key fields PerformanceObligationClass, SalesDocumentCurrency, ContractualUnitPrcInSlsDocCrcy, PerfOblgnContractualQtyUnit, PerfOblgnEffectiveQuantityUnit.

Data Sources (1)

SourceAliasJoin Type
P_RAFinCmplncUnitPriceByItem _RAFinCmplncUnitPriceByItem from

Parameters (4)

NameTypeDefault
P_CompanyCode bukrs
P_AccountingPrinciple accounting_principle
P_StartDate farr_effective_date
P_EndDate farr_effective_date

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligationClass P_RAFinCmplncUnitPriceByItem PerformanceObligationClass Performance Obligation Name
KEY SalesDocumentCurrency P_RAFinCmplncUnitPriceByItem SalesDocumentCurrency Currency
KEY ContractualUnitPrcInSlsDocCrcy
KEY PerfOblgnContractualQtyUnit P_RAFinCmplncUnitPriceByItem PerfOblgnContractualQtyUnit Unit of Measure
KEY PerfOblgnEffectiveQuantityUnit P_RAFinCmplncUnitPriceByItem PerfOblgnEffectiveQuantityUnit Unit of Measure
KEY YearQuarter P_RAFinCmplncUnitPriceByItem YearQuarter Year Quarter
CompanyCode P_RAFinCmplncUnitPriceByItem CompanyCode Receiver Company Code
AccountingPrinciple P_RAFinCmplncUnitPriceByItem AccountingPrinciple AP Ledger/CoCode
CountNumber

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_RAFinCmplncUnitTransPrcByNam.
-- 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.
-- Parameters: P_CompanyCode : bukrs, P_AccountingPrinciple : accounting_principle, P_StartDate : farr_effective_date, P_EndDate : farr_effective_date

CREATE VIEW P_RAFinCmplncUnitTransPrcByNam AS
SELECT
  _RAFinCmplncUnitPriceByItem.PerformanceObligationClass AS PerformanceObligationClass,
  _RAFinCmplncUnitPriceByItem.SalesDocumentCurrency AS SalesDocumentCurrency,
  cast(_RAFinCmplncUnitPriceByItem.ContractualUnitPrcInSlsDocCrcy as abap.dec(23,6)) AS ContractualUnitPrcInSlsDocCrcy,
  _RAFinCmplncUnitPriceByItem.PerfOblgnContractualQtyUnit AS PerfOblgnContractualQtyUnit,
  _RAFinCmplncUnitPriceByItem.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  _RAFinCmplncUnitPriceByItem.YearQuarter AS YearQuarter,
  _RAFinCmplncUnitPriceByItem.CompanyCode AS CompanyCode,
  _RAFinCmplncUnitPriceByItem.AccountingPrinciple AS AccountingPrinciple,
  count(distinct _RAFinCmplncUnitPriceByItem.PerformanceObligation) AS CountNumber
FROM P_RAFinCmplncUnitPriceByItem AS _RAFinCmplncUnitPriceByItem
;

Learn More