P_ProjDocumentCurrencySDM

DDL: P_PROJDOCUMENTCURRENCYSDM Type: view_entity BASIC Package: PROJECT_BILLING_SDM
23 Fields 1 Data Sources

View for SDM to update new fields

P_ProjDocumentCurrencySDM is a Basic CDS View that provides data about "View for SDM to update new fields" in SAP S/4HANA. It reads from 1 data source (projbillgelmnt) and exposes 23 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 new fields 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 (23)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingElementUUID projbillgelmnt projectbillingelementuuid PBE UUID
PbeDocumentCurrency projbillgelmnt documentcurrency Document Currency
PbeProjBillingProfile projbillgelmnt projbillingprofile Proj. Billg Profile
PbeProjectBillingCategory projbillgelmnt projectbillingcategory PBF Category
ProjBillgElmntEntrItmUUID pbee projbillgelmntentritmuuid PBE Entry UUID
PbeeTransactionCurrency pbee transactioncurrency Transaction Currency
PbeeProjectCurrency pbee projectcurrency Project Currency
PbeeGlobalCurrency pbee globalcurrency GM Billing Element: Global Currency
PbeeQuantityUnit pbee quantityunit Unit of measure
PbriProjBillgRequestItemUUID pbri projectbillingrequestitemuuid Item UUID
PbriProjBillgRequestUUID pbri projectbillingrequestuuid Proj Billg Req UUID
PbriProjBillgElmntEntriItmUUID pbri projbillgelmntentritmuuid PBE Entry UUID
PbriProjBillgElementUUID pbri projectbillingelementuuid PBE UUID
PbriLongText pbri projbillingrequestitemlongtext Note
PbeeFlwProjEEItemFlowUUID pbeeflw projbillgelmntentritmflowuuid PBE Flow UUID
PbeeFlwProjBillgEEItemUUID pbeeflw projbillgelmntentritmuuid PBE Entry UUID
PbeeFlwPBRILongText pbeeflw projbillingrequestitemlongtext Note
PbeeFlwBillingDocument pbeeflw billingdocument SD Document
PbeeFlwBillingDocumentItem pbeeflw billingdocumentitem Item
PbeeFlwDocumentStatus pbeeflw documentbillingstatus PBEE BDR Status
PbeeDocumentCurrency pbee documentcurrency Document Currency
PbriDocumentCurrency pbri documentcurrency Document Currency
PbeeFlwDocumentCurrency pbeeflw documentcurrency Document Currency

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_ProjDocumentCurrencySDM.
-- 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_ProjDocumentCurrencySDM AS
SELECT
  pbe.projectbillingelementuuid AS ProjectBillingElementUUID,
  pbe.documentcurrency AS PbeDocumentCurrency,
  pbe.projbillingprofile AS PbeProjBillingProfile,
  pbe.projectbillingcategory AS PbeProjectBillingCategory,
  pbee.projbillgelmntentritmuuid AS ProjBillgElmntEntrItmUUID,
  pbee.transactioncurrency AS PbeeTransactionCurrency,
  pbee.projectcurrency AS PbeeProjectCurrency,
  pbee.globalcurrency AS PbeeGlobalCurrency,
  pbee.quantityunit AS PbeeQuantityUnit,
  pbri.projectbillingrequestitemuuid AS PbriProjBillgRequestItemUUID,
  pbri.projectbillingrequestuuid AS PbriProjBillgRequestUUID,
  pbri.projbillgelmntentritmuuid AS PbriProjBillgElmntEntriItmUUID,
  pbri.projectbillingelementuuid AS PbriProjBillgElementUUID,
  pbri.projbillingrequestitemlongtext AS PbriLongText,
  pbeeflw.projbillgelmntentritmflowuuid AS PbeeFlwProjEEItemFlowUUID,
  pbeeflw.projbillgelmntentritmuuid AS PbeeFlwProjBillgEEItemUUID,
  pbeeflw.projbillingrequestitemlongtext AS PbeeFlwPBRILongText,
  pbeeflw.billingdocument AS PbeeFlwBillingDocument,
  pbeeflw.billingdocumentitem AS PbeeFlwBillingDocumentItem,
  pbeeflw.documentbillingstatus AS PbeeFlwDocumentStatus,
  pbee.documentcurrency AS PbeeDocumentCurrency,
  pbri.documentcurrency AS PbriDocumentCurrency,
  pbeeflw.documentcurrency AS PbeeFlwDocumentCurrency
FROM projbillgelmnt AS pbe
;

Learn More