I_PrjBlgElmEntrForPrepayment

DDL: I_PRJBLGELMENTRFORPREPAYMENT SQL: IPBEEFORPREPAYT Type: view COMPOSITE
13 Fields 1 Data Sources 5 Associations

Prepayments for Project Billing Element

I_PrjBlgElmEntrForPrepayment is a Composite CDS View that provides data about "Prepayments for Project Billing Element" in SAP S/4HANA. It reads from 1 data source (I_PrjBlgElmEntrBillgPlnLink) and exposes 13 fields with key fields ProjectBillingElementUUID, ProjBillgElmntEntrItmUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PrjBlgElmEntrBillgPlnLink PrjBlgElmEntrBillgPlnLink from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_ProjectBillingElementEntry _ProjectBillingElementEntry PrjBlgElmEntrBillgPlnLink.ProjBillgElmntEntrItmUUID = _ProjectBillingElementEntry.ProjBillgElmntEntrItmUUID
[1..1] I_SDBillingPlanItem _SalesDocumentBillingPlanItem PrjBlgElmEntrBillgPlnLink.BillingPlan = _SalesDocumentBillingPlanItem.BillingPlan and PrjBlgElmEntrBillgPlnLink.BillingPlanItem = _SalesDocumentBillingPlanItem.BillingPlanItem
[0..1] I_WBSElementBasicData _WBSElement $projection.BillingWBSElementInternalID = _WBSElement.WBSElementInternalID --
[0..1] I_MyProjectBillingElements _MyProjectBillingElements _MyProjectBillingElements.BillingWBSElementInternalID = $projection.BillingWBSElementInternalID -- and _MyProjectBillingElements.UserID = $session.user
[0..*] P_ProjBillgElmntSalesDets _ProjBillgElmntSalesDets PrjBlgElmEntrBillgPlnLink.BillingPlan = _ProjBillgElmntSalesDets.BillingPlan

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPBEEFORPREPAYT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Prepayments for Project Billing Element view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingElementUUID _ProjectBillingElementEntry ProjectBillingElementUUID PBE UUID
KEY ProjBillgElmntEntrItmUUID _ProjectBillingElementEntry ProjBillgElmntEntrItmUUID PBE Entry UUID
BillingWBSElementInternalID
ProjectCurrency _ProjectBillingElementEntry ProjectCurrency Project Currency
DocumentCurrency
ServicesRenderedDate _ProjectBillingElementEntry ServicesRenderedDate Services Rendered Date
PlndPrepaymentAmtInProjCrcy _ProjectBillingElementEntry ToBeBilledAmtInProjCurrency To Be Blld Proj Crcy
BillingPlanItemUsage _SalesDocumentBillingPlanItem BillingPlanItemUsage Usage
PrjBlgElmEntrLastChgdAtDteTme _ProjectBillingElementEntry PrjBlgElmEntrLastChgdAtDteTme PBE Entry Changed On
_WBSElement _WBSElement
SalesOrder
SalesOrderItem _ProjBillgElmntSalesDets SalesOrderItem Sales Order Item
UserID _ProjBillgElmntSalesDets UserID User Name

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 I_PrjBlgElmEntrForPrepayment.
-- 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: IPBEEFORPREPAYT

CREATE VIEW I_PrjBlgElmEntrForPrepayment AS
SELECT
  _ProjectBillingElementEntry.ProjectBillingElementUUID AS ProjectBillingElementUUID,
  _ProjectBillingElementEntry.ProjBillgElmntEntrItmUUID AS ProjBillgElmntEntrItmUUID,
  _ProjectBillingElementEntry._ProjectBillingElement.BillingWBSElementInternalID AS BillingWBSElementInternalID,
  _ProjectBillingElementEntry.ProjectCurrency AS ProjectCurrency,
  _ProjectBillingElementEntry._ProjectBillingElement.DocumentCurrency AS DocumentCurrency,
  _ProjectBillingElementEntry.ServicesRenderedDate AS ServicesRenderedDate,
  _ProjectBillingElementEntry.ToBeBilledAmtInProjCurrency AS PlndPrepaymentAmtInProjCrcy,
  _SalesDocumentBillingPlanItem.BillingPlanItemUsage AS BillingPlanItemUsage,
  _ProjectBillingElementEntry.PrjBlgElmEntrLastChgdAtDteTme AS PrjBlgElmEntrLastChgdAtDteTme,
  _ProjBillgElmntSalesDets.SalesOrderItem AS SalesOrderItem,
  _ProjBillgElmntSalesDets.UserID AS UserID
FROM I_PrjBlgElmEntrBillgPlnLink AS PrjBlgElmEntrBillgPlnLink
LEFT OUTER JOIN I_ProjectBillingElementEntry AS _ProjectBillingElementEntry ON PrjBlgElmEntrBillgPlnLink.ProjBillgElmntEntrItmUUID = _ProjectBillingElementEntry.ProjBillgElmntEntrItmUUID  -- association [1..1]
LEFT OUTER JOIN I_SDBillingPlanItem AS _SalesDocumentBillingPlanItem ON PrjBlgElmEntrBillgPlnLink.BillingPlan = _SalesDocumentBillingPlanItem.BillingPlan AND PrjBlgElmEntrBillgPlnLink.BillingPlanItem = _SalesDocumentBillingPlanItem.BillingPlanItem  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON BillingWBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_MyProjectBillingElements AS _MyProjectBillingElements ON _MyProjectBillingElements.BillingWBSElementInternalID = BillingWBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN P_ProjBillgElmntSalesDets AS _ProjBillgElmntSalesDets ON PrjBlgElmEntrBillgPlnLink.BillingPlan = _ProjBillgElmntSalesDets.BillingPlan  -- association [0..*]
;

Learn More