P_EProjBillgElmntEntrLink

DDL: P_EPROJBILLGELMNTENTRLINK SQL: PBLELENTLNK Type: view COMPOSITE Package: CPD_CDS
7 Fields 2 Data Sources

Get Engagement Project billing entry items

P_EProjBillgElmntEntrLink is a Composite CDS View that provides data about "Get Engagement Project billing entry items" in SAP S/4HANA. It reads from 2 data sources (I_ProjectBillingElementEntry, I_PrjBlgElmEntrJrnlEntrLink) and exposes 7 fields with key fields ProjBillgElmntEntrItmUUID, ProjectBillingElementUUID, AccountingDocument. Part of development package CPD_CDS.

Data Sources (2)

SourceAliasJoin Type
I_ProjectBillingElementEntry _ProjectBillingElementEntry inner
I_PrjBlgElmEntrJrnlEntrLink I_PrjBlgElmEntrJrnlEntrLink from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PBLELENTLNK view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ProjBillgElmntEntrItmUUID I_ProjectBillingElementEntry ProjBillgElmntEntrItmUUID PBE Entry UUID
KEY ProjectBillingElementUUID I_ProjectBillingElementEntry ProjectBillingElementUUID PBE UUID
KEY AccountingDocument I_PrjBlgElmEntrJrnlEntrLink AccountingDocument Journal Entry
CompanyCode I_PrjBlgElmEntrJrnlEntrLink CompanyCode Receiver Company Code
LedgerGLLineItem I_PrjBlgElmEntrJrnlEntrLink LedgerGLLineItem Journal Entry Item
FiscalYear I_PrjBlgElmEntrJrnlEntrLink FiscalYear G/L Fiscal Year
WBSElementInternalID I_ProjectBillingElementEntry WBSElementInternalID WBS Internal ID

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_EProjBillgElmntEntrLink.
-- 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: PBLELENTLNK

CREATE VIEW P_EProjBillgElmntEntrLink AS
SELECT
  _ProjectBillingElementEntry.ProjBillgElmntEntrItmUUID AS ProjBillgElmntEntrItmUUID,
  _ProjectBillingElementEntry.ProjectBillingElementUUID AS ProjectBillingElementUUID,
  I_PrjBlgElmEntrJrnlEntrLink.AccountingDocument AS AccountingDocument,
  I_PrjBlgElmEntrJrnlEntrLink.CompanyCode AS CompanyCode,
  I_PrjBlgElmEntrJrnlEntrLink.LedgerGLLineItem AS LedgerGLLineItem,
  I_PrjBlgElmEntrJrnlEntrLink.FiscalYear AS FiscalYear,
  _ProjectBillingElementEntry.WBSElementInternalID AS WBSElementInternalID
FROM I_PrjBlgElmEntrJrnlEntrLink
INNER JOIN I_ProjectBillingElementEntry AS _ProjectBillingElementEntry ON /* join condition not captured in parsed metadata */
;

Learn More