P_ProjectBillingElementSDM

DDL: P_PROJECTBILLINGELEMENTSDM Type: view_entity BASIC Package: PROJECT_BILLING_SDM
8 Fields 1 Data Sources

View for SDM to update the PBE table

P_ProjectBillingElementSDM is a Basic CDS View that provides data about "View for SDM to update the PBE table" in SAP S/4HANA. It reads from 1 data source (projbillgelmnt) and exposes 8 fields with key field ProjectBillingElementUUID. Part of development package PROJECT_BILLING_SDM.

Data Sources (1)

SourceAliasJoin Type
projbillgelmnt pbe from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label View for SDM to update the PBE table view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingElementUUID projbillgelmnt projectbillingelementuuid PBE UUID
BillingWBSElementInternalID projbillgelmnt billingwbselementinternalid WBS Internal ID
SalesDocument projbillgelmnt salesdocument SD Document
SalesDocumentItem projbillgelmnt salesdocumentitem Sales Document Item
DocumentCurrency projbillgelmnt documentcurrency Document Currency
SalesOrder salesorder vbeln SD Sched. Agmt
SalesOrderItem salesorder posnr WBS Element
BillingPlan salesorder fplnr_ana Bill. Plan No.

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_ProjectBillingElementSDM.
-- 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_ProjectBillingElementSDM AS
SELECT
  pbe.projectbillingelementuuid AS ProjectBillingElementUUID,
  pbe.billingwbselementinternalid AS BillingWBSElementInternalID,
  pbe.salesdocument AS SalesDocument,
  pbe.salesdocumentitem AS SalesDocumentItem,
  pbe.documentcurrency AS DocumentCurrency,
  salesorder.vbeln AS SalesOrder,
  salesorder.posnr AS SalesOrderItem,
  salesorder.fplnr_ana AS BillingPlan
FROM projbillgelmnt AS pbe
;

Learn More