P_EntProjProfnlSrvcRblsInTC

DDL: P_ENTPROJPROFNLSRVCRBLSINTC Type: view_entity COMPOSITE Package: ODATA_PPM_PRO_CTRL_PROFNL_SRVC
8 Fields 4 Data Sources

Billg Doc Receivables in TransactionCrcy

P_EntProjProfnlSrvcRblsInTC is a Composite CDS View that provides data about "Billg Doc Receivables in TransactionCrcy" in SAP S/4HANA. It reads from 4 data sources (I_BillingDocument, I_BillingDocumentItem, I_ReceivablesPayablesItem, I_EnterpriseProjectElement) and exposes 8 fields with key fields ProjectUUID, BillingDocument, BillingDocumentItem. Part of development package ODATA_PPM_PRO_CTRL_PROFNL_SRVC.

Data Sources (4)

SourceAliasJoin Type
I_BillingDocument BillingDocument inner
I_BillingDocumentItem BillingDocumentItem inner
I_ReceivablesPayablesItem Payables inner
I_EnterpriseProjectElement ProjectElement inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Billg Doc Receivables in TransactionCrcy view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID Project ProjectUUID Project UUID
KEY BillingDocument I_BillingDocumentItem BillingDocument SD Document
KEY BillingDocumentItem I_BillingDocumentItem BillingDocumentItem Item
Project Project Project WBS Element
ProjectCurrency Project Currency Valuation Crcy
PricingDate I_BillingDocumentItem PricingDate Pricing Date
TransactionCurrency I_BillingDocumentItem TransactionCurrency Transaction Currency
NetAmountendasReceivables

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_EntProjProfnlSrvcRblsInTC.
-- 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_EntProjProfnlSrvcRblsInTC AS
SELECT
  Project.ProjectUUID AS ProjectUUID,
  BillingDocumentItem.BillingDocument AS BillingDocument,
  BillingDocumentItem.BillingDocumentItem AS BillingDocumentItem,
  Project.Project AS Project,
  Project.Currency AS ProjectCurrency,
  BillingDocumentItem.PricingDate AS PricingDate,
  BillingDocumentItem.TransactionCurrency AS TransactionCurrency,
  case when BillingDocumentItem.ReturnItemProcessingType = 'X' or BillingDocumentItem.ReturnItemProcessingType = 'B' then BillingDocumentItem.NetAmount * -1 else BillingDocumentItem.NetAmount end as Receivables AS NetAmountendasReceivables
INNER JOIN I_EnterpriseProjectElement AS ProjectElement ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillingDocumentItem AS BillingDocumentItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillingDocument AS BillingDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_ReceivablesPayablesItem AS Payables ON /* join condition not captured in parsed metadata */
;

Learn More