C_ProjBillgElmntEntrSrceAttrib

DDL: C_PROJBILLGELMNTENTRSRCEATTRIB Type: view_entity CONSUMPTION Package: VDM_PROJBILLINGELEMENTENTRY
21 Fields 4 Data Sources

Proj Billg Elmnt Entr Source Attributes

C_ProjBillgElmntEntrSrceAttrib is a Consumption CDS View that provides data about "Proj Billg Elmnt Entr Source Attributes" in SAP S/4HANA. It reads from 4 data sources (I_SalesDocItemBillingPlanItem, I_GLAccountLineItemRawData, I_PrjBlgElmEntrBillgPlnLink, I_PrjBlgElmEntrJrnlEntrLink) and exposes 21 fields with key field ProjBillgElmntEntrItmUUID. Part of development package VDM_PROJBILLINGELEMENTENTRY.

Data Sources (4)

SourceAliasJoin Type
I_SalesDocItemBillingPlanItem BillingPlanItem inner
I_GLAccountLineItemRawData JournalEntryItem inner
I_PrjBlgElmEntrBillgPlnLink PrjBlgElmEntrBillgPlnLink union
I_PrjBlgElmEntrJrnlEntrLink PrjBlgElmEntrJrnlEntrLink from

Annotations (7)

NameValueLevelField
EndUserText.label Proj Billg Elmnt Entr Source Attributes view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
Metadata.ignorePropagatedAnnotations true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ProjBillgElmntEntrItmUUID I_PrjBlgElmEntrJrnlEntrLink ProjBillgElmntEntrItmUUID PBE Entry UUID
ProjectBillingElementUUID
Ledger I_PrjBlgElmEntrJrnlEntrLink Ledger Ledger
CompanyCode I_PrjBlgElmEntrJrnlEntrLink CompanyCode Receiver Company Code
FiscalYear I_PrjBlgElmEntrJrnlEntrLink FiscalYear G/L Fiscal Year
AccountingDocument I_PrjBlgElmEntrJrnlEntrLink AccountingDocument Journal Entry
LedgerGLLineItem I_PrjBlgElmEntrJrnlEntrLink LedgerGLLineItem Journal Entry Item
BillingPlan Bill. Plan No.
BillingPlanItem Item
ActivityType I_GLAccountLineItemRawData OriginCostCtrActivityType OrigAct.
ProjBillgElmntEntrItmUUID PBE Entry UUID
ProjectBillingElementUUID
Ledger Ledger
CompanyCode Receiver Company Code
FiscalYear G/L Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Journal Entry Item
BillingPlan I_PrjBlgElmEntrBillgPlnLink BillingPlan Bill. Plan No.
BillingPlanItem I_PrjBlgElmEntrBillgPlnLink BillingPlanItem Item
ActivityType OrigAct.
Material

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 C_ProjBillgElmntEntrSrceAttrib.
-- 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 C_ProjBillgElmntEntrSrceAttrib AS
SELECT
  PrjBlgElmEntrJrnlEntrLink.ProjBillgElmntEntrItmUUID AS ProjBillgElmntEntrItmUUID,
  PrjBlgElmEntrJrnlEntrLink._ProjectBillingElementEntry.ProjectBillingElementUUID AS ProjectBillingElementUUID,
  PrjBlgElmEntrJrnlEntrLink.Ledger AS Ledger,
  PrjBlgElmEntrJrnlEntrLink.CompanyCode AS CompanyCode,
  PrjBlgElmEntrJrnlEntrLink.FiscalYear AS FiscalYear,
  PrjBlgElmEntrJrnlEntrLink.AccountingDocument AS AccountingDocument,
  PrjBlgElmEntrJrnlEntrLink.LedgerGLLineItem AS LedgerGLLineItem,
  cast('' as fplnr) AS BillingPlan,
  cast('' as fpltr) AS BillingPlanItem,
  JournalEntryItem.OriginCostCtrActivityType AS ActivityType,
  cast('' as matnr) AS Material
FROM I_PrjBlgElmEntrJrnlEntrLink AS PrjBlgElmEntrJrnlEntrLink
INNER JOIN I_GLAccountLineItemRawData AS JournalEntryItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocItemBillingPlanItem AS BillingPlanItem ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_PrjBlgElmEntrBillgPlnLink
;

Learn More