P_PrjBlgElmRevnAmount

DDL: P_PRJBLGELMREVNAMOUNT Type: view_entity CONSUMPTION Package: VDM_PROJECTBILLINGELEMENT
4 Fields 1 Data Sources

Calculated Amounts for Billing Element

P_PrjBlgElmRevnAmount is a Consumption CDS View that provides data about "Calculated Amounts for Billing Element" in SAP S/4HANA. It reads from 1 data source (I_ProjectBillingElement) and exposes 4 fields with key field ProjectBillingElementUUID. Part of development package VDM_PROJECTBILLINGELEMENT.

Data Sources (1)

SourceAliasJoin Type
I_ProjectBillingElement _ProjectBillingElement from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Calculated Amounts for Billing Element view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingElementUUID I_ProjectBillingElement ProjectBillingElementUUID PBE UUID
DocumentCurrency I_ProjectBillingElement DocumentCurrency Document Currency
BillableRevenueAmtInDocCrcy _PrjBlgElmBllbleRevnAmt BillableRevenueAmtInDocCrcy Billable Revenue
BillgReqdRevenueAmtInDocCrcy

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_PrjBlgElmRevnAmount.
-- 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_PrjBlgElmRevnAmount AS
SELECT
  _ProjectBillingElement.ProjectBillingElementUUID AS ProjectBillingElementUUID,
  _ProjectBillingElement.DocumentCurrency AS DocumentCurrency,
  _PrjBlgElmBllbleRevnAmt.BillableRevenueAmtInDocCrcy AS BillableRevenueAmtInDocCrcy,
  cast(sum(_PrjBlgElmBillingReqRevnAmt.BillgReqdRevenueAmtInDocCrcy) as abap.curr( 23, 2 ) ) AS BillgReqdRevenueAmtInDocCrcy
FROM I_ProjectBillingElement AS _ProjectBillingElement
;

Learn More