R_ProjectBillingElementTP

DDL: R_PROJECTBILLINGELEMENTTP SQL: RPRJBLGELMTP Type: view_entity TRANSACTIONAL Package: VDM_PROJECTBILLINGELEMENT_TP
60 Fields 1 Data Sources 23 Associations

Details of Billing Element

R_ProjectBillingElementTP is a Transactional CDS View that provides data about "Details of Billing Element" in SAP S/4HANA. It reads from 1 data source (I_ProjectBillingElement) and exposes 60 fields with key field ProjectBillingElementUUID. It has 23 associations to related views. Part of development package VDM_PROJECTBILLINGELEMENT_TP.

Data Sources (1)

SourceAliasJoin Type
I_ProjectBillingElement ProjectBillingElement from

Associations (23)

CardinalityTargetAliasCondition
[1..1] I_EnterpriseProjectElement _EnterpriseProjectElement $projection.ProjectElementUUID = _EnterpriseProjectElement.ProjectElementUUID
[1..1] I_EnterpriseProject _EnterpriseProject $projection.ProjectUUID = _EnterpriseProject.ProjectUUID
[1..1] I_SalesDocumentItem _SalesOrderItem $projection.SalesDocument = _SalesOrderItem.SalesDocument and $projection.SalesDocumentItem = _SalesOrderItem.SalesDocumentItem
[1..1] I_SalesDocument _SalesOrder $projection.SalesDocument = _SalesOrder.SalesDocument
[0..1] I_SDBillingPlan _SDBillingPlan $projection.BillingPlan = _SDBillingPlan.BillingPlan
[0..1] I_MyProjectBillingElements _MyProjectBillingElements $projection.ProjectBillingElementUUID = _MyProjectBillingElements.ProjectBillingElementUUID --
[1..1] P_ProjBillgElmntSalesDets2 _ProjBillgElmntSalesDets $projection.ProjectBillingElementUUID = _ProjBillgElmntSalesDets.ProjectBillingElementUUID
[1..1] P_ProjectBillingElmntDueDate3 _DueBillingDate $projection.ProjectBillingElementUUID = _DueBillingDate.ProjectBillingElementUUID
[0..1] I_TmpProjectBillingRequest _TmpProjectBillingRequest $projection.ProjectBillingElementUUID = _TmpProjectBillingRequest.ProjectBillingElementUUID
[0..1] I_PrjBlgElmOverduePrepayment _PrjBlgElmOverduePrepayment $projection.ProjectBillingElementUUID = _PrjBlgElmOverduePrepayment.ProjectBillingElementUUID
[0..1] I_PrjBlgElmPrepaymentAmount _PrjBlgElmPrepaymentAmount $projection.ProjectBillingElementUUID = _PrjBlgElmPrepaymentAmount.ProjectBillingElementUUID
[0..1] I_PrjBlgElmBllbleRevnAmt _PrjBlgElmBllbleRevnAmt $projection.ProjectBillingElementUUID = _PrjBlgElmBllbleRevnAmt.ProjectBillingElementUUID -- POC Sort / Filter on ToBill amount
[0..1] I_MyPrjBillgElmntBllbleRevnAmt _MyPrjBillgElmntBllbleRevnAmt $projection.ProjectBillingElementUUID = _MyPrjBillgElmntBllbleRevnAmt.ProjectBillingElementUUID -- Moved to C_ProjectBillingElementTP -- can be moved to C_
[0..*] R_ProjectBillingRequestItemTP _ProjectBillingRequestItemTP $projection.ProjectBillingElementUUID = _ProjectBillingRequestItemTP.ProjectBillingElementUUID
[1..1] I_ProfitCenterText _ProfitCenterName $projection.WBSElementProfitCenter = _ProfitCenterName.ProfitCenter and $projection.ControllingArea = _ProfitCenterName.ControllingArea and _ProfitCenterName.ValidityEndDate >= $session.system_date and _ProfitCenterName.ValidityStartDate <= $session.system_date and _ProfitCenterName.Language = $session.system_language
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[1..1] I_Customer _ShipToParty $projection.ShipToParty = _ShipToParty.Customer
[1..1] I_Customer _BillToParty $projection.BillToParty = _BillToParty.Customer
[1..1] I_Customer _PayerParty $projection.PayerParty = _PayerParty.Customer -- Moved from I_ to C_
[0..1] I_EngagementProjectSrvcOrgText _ServiceOrganizationText _ServiceOrganizationText.EngagementProjectServiceOrg = $projection.EngagementProjectServiceOrg and _ServiceOrganizationText.Language = $session.system_language
[0..1] E_ProjectBillingElement _Extension $projection.ProjectBillingElementUUID = _Extension.ProjectBillingElementUUID
[0..*] R_ProjectBillingElementEntryTP _ProjectBillingElementEntry
[0..1] R_ProjBillgElmObjectLinkTP _ProjBillgElmObjectLink

Annotations (9)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.sapObjectNodeType.name ProjectBillingElement view
EndUserText.label Details of Billing Element view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingElementUUID I_ProjectBillingElement ProjectBillingElementUUID PBE UUID
BillingWBSElementInternalID I_ProjectBillingElement BillingWBSElementInternalID WBS Internal ID
DocumentCurrency I_ProjectBillingElement DocumentCurrency Document Currency
BilledRevenueAmtInDocCrcy I_ProjectBillingElement BilledRevenueAmtInDocCrcy Billed Revenue
WrittenOffRevenueAmtInDocCrcy I_ProjectBillingElement WrittenOffRevenueAmtInDocCrcy Written-off Revenue
ProjBillingProfile I_ProjectBillingElement ProjBillingProfile Proj. Billg Profile
ProjectBillingCategory I_ProjectBillingElement ProjectBillingCategory PBF Category
ProjBillgElmntCreatedByUser I_ProjectBillingElement ProjBillgElmntCreatedByUser PBE Created By
ProjBillgElmntCreatedAtDteTme I_ProjectBillingElement ProjBillgElmntCreatedAtDteTme PBE Created On
ProjBillgElmntLastChgdByUser I_ProjectBillingElement ProjBillgElmntLastChgdByUser PBE Changed By
ProjBillgElmntLastChgdAtDteTme I_ProjectBillingElement ProjBillgElmntLastChgdAtDteTme PBE Changed On
SalesDocument I_ProjectBillingElement SalesDocument SD Document
SalesDocumentItem I_ProjectBillingElement SalesDocumentItem Sales Document Item
ProjBillgSlsOrdBillingPlan I_ProjectBillingElement BillingPlan Bill. Plan No.
ProjectUUID I_ProjectBillingElement ProjectUUID Project UUID
ProjectElementUUID I_ProjectBillingElement ProjectElementUUID Obj Link Entity GUID
ProjectInternalID
WBSElementProfitCenter _EnterpriseProjectElement ProfitCenter Profit Center
WBSElementExternalID
ControllingArea _EnterpriseProject ControllingArea Controlling Area
Project _EnterpriseProject Project WBS Element
ProfitCenter _EnterpriseProject ProfitCenter Profit Center
ProcessingStatus _EnterpriseProject ProcessingStatus Worklist Status
ProjectStartDate _EnterpriseProject ProjectStartDate Latest Planned Start
ProjectEndDate _EnterpriseProject ProjectEndDate Ltst Planned Finish
ProjectBillingRequest _TmpProjectBillingRequest ProjectBillingRequest PBR
ProjectBillingRequestUUID _TmpProjectBillingRequest ProjectBillingRequestUUID Proj Billg Req UUID
BillingPlan I_ProjectBillingElement BillingPlan Bill. Plan No.
SalesOrder I_ProjectBillingElement SalesDocument SD Document
SalesOrderItem I_ProjectBillingElement SalesDocumentItem Sales Document Item
TransactionCurrency _SalesOrderItem TransactionCurrency Transaction Currency
SoldToPartyasCustomer
ShipToParty _SalesOrderItem ShipToParty Ship-To Party (obsolete)
BillToParty _SalesOrderItem BillToParty Inv. Recipient
PayerParty _SalesOrderItem PayerParty Payer
BillingBlockStatus _SalesOrderItem BillingBlockStatus
BillingBlockReason _SalesOrderItem ItemBillingBlockReason Billing Block
SalesDocumentRjcnReason _SalesOrderItem SalesDocumentRjcnReason RejectionReason
OverallBillingBlockStatus _SalesOrder OverallBillingBlockStatus
HeaderBillingBlockReason _SalesOrder HeaderBillingBlockReason Billing Block
CappedNetAmount _SalesOrderItem CappedNetAmount
DueBillingDate _DueBillingDate DueBillingDate
UserID _MyProjectBillingElements UserID User Name
BillableRevenueAmtInDocCrcy _PrjBlgElmBllbleRevnAmt BillableRevenueAmtInDocCrcy Billable Revenue
PrjBlgElmPlndPrepaymentIsOvrd _PrjBlgElmOverduePrepayment PrjBlgElmPlndPrepaymentIsOvrd
PlndPrepaymentAmtInProjCrcy _PrjBlgElmPrepaymentAmount PlndPrepaymentAmtInProjCrcy
_ProfitCenterName _ProfitCenterName
_SalesOrderItem _SalesOrderItem
_SalesOrder _SalesOrder
_ProjectBillingElementEntry _ProjectBillingElementEntry
_WBSElement I_ProjectBillingElement _WBSElement
_ProjectBillingRequestItemTP _ProjectBillingRequestItemTP
_Customer _Customer
_ShipToParty _ShipToParty
_PayerParty _PayerParty
_BillToParty _BillToParty
_EnterpriseProjectElement _EnterpriseProjectElement
_PrjBlgElmPrepaymentAmount _PrjBlgElmPrepaymentAmount
_PrjBlgElmOverduePrepayment _PrjBlgElmOverduePrepayment
_ProjBillgElmObjectLink _ProjBillgElmObjectLink

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 R_ProjectBillingElementTP.
-- 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: RPRJBLGELMTP

CREATE VIEW R_ProjectBillingElementTP AS
SELECT
  ProjectBillingElement.ProjectBillingElementUUID AS ProjectBillingElementUUID,
  ProjectBillingElement.BillingWBSElementInternalID AS BillingWBSElementInternalID,
  ProjectBillingElement.DocumentCurrency AS DocumentCurrency,
  ProjectBillingElement.BilledRevenueAmtInDocCrcy AS BilledRevenueAmtInDocCrcy,
  ProjectBillingElement.WrittenOffRevenueAmtInDocCrcy AS WrittenOffRevenueAmtInDocCrcy,
  ProjectBillingElement.ProjBillingProfile AS ProjBillingProfile,
  ProjectBillingElement.ProjectBillingCategory AS ProjectBillingCategory,
  ProjectBillingElement.ProjBillgElmntCreatedByUser AS ProjBillgElmntCreatedByUser,
  ProjectBillingElement.ProjBillgElmntCreatedAtDteTme AS ProjBillgElmntCreatedAtDteTme,
  ProjectBillingElement.ProjBillgElmntLastChgdByUser AS ProjBillgElmntLastChgdByUser,
  ProjectBillingElement.ProjBillgElmntLastChgdAtDteTme AS ProjBillgElmntLastChgdAtDteTme,
  ProjectBillingElement.SalesDocument AS SalesDocument,
  ProjectBillingElement.SalesDocumentItem AS SalesDocumentItem,
  ProjectBillingElement.BillingPlan AS ProjBillgSlsOrdBillingPlan,
  ProjectBillingElement.ProjectUUID AS ProjectUUID,
  ProjectBillingElement.ProjectElementUUID AS ProjectElementUUID,
  cast ( _EnterpriseProjectElement.ProjectInternalID as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
  _EnterpriseProjectElement.ProfitCenter AS WBSElementProfitCenter,
  cast( _EnterpriseProjectElement.ProjectElement as ps_posid_edit preserving type ) AS WBSElementExternalID,
  _EnterpriseProject.ControllingArea AS ControllingArea,
  _EnterpriseProject.Project AS Project,
  _EnterpriseProject.ProfitCenter AS ProfitCenter,
  _EnterpriseProject.ProcessingStatus AS ProcessingStatus,
  _EnterpriseProject.ProjectStartDate AS ProjectStartDate,
  _EnterpriseProject.ProjectEndDate AS ProjectEndDate,
  _TmpProjectBillingRequest.ProjectBillingRequest AS ProjectBillingRequest,
  _TmpProjectBillingRequest.ProjectBillingRequestUUID AS ProjectBillingRequestUUID,
  ProjectBillingElement.BillingPlan AS BillingPlan,
  ProjectBillingElement.SalesDocument AS SalesOrder,
  ProjectBillingElement.SalesDocumentItem AS SalesOrderItem,
  _SalesOrderItem.TransactionCurrency AS TransactionCurrency,
  _SalesOrderItem.ShipToParty AS ShipToParty,
  _SalesOrderItem.BillToParty AS BillToParty,
  _SalesOrderItem.PayerParty AS PayerParty,
  _SalesOrderItem.BillingBlockStatus AS BillingBlockStatus,
  _SalesOrderItem.ItemBillingBlockReason AS BillingBlockReason,
  _SalesOrderItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  _SalesOrder.OverallBillingBlockStatus AS OverallBillingBlockStatus,
  _SalesOrder.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  _SalesOrderItem.CappedNetAmount AS CappedNetAmount,
  _DueBillingDate.DueBillingDate AS DueBillingDate,
  _MyProjectBillingElements.UserID AS UserID,
  _PrjBlgElmBllbleRevnAmt.BillableRevenueAmtInDocCrcy AS BillableRevenueAmtInDocCrcy,
  _PrjBlgElmOverduePrepayment.PrjBlgElmPlndPrepaymentIsOvrd AS PrjBlgElmPlndPrepaymentIsOvrd,
  _PrjBlgElmPrepaymentAmount.PlndPrepaymentAmtInProjCrcy AS PlndPrepaymentAmtInProjCrcy,
  ProjectBillingElement._WBSElement AS _WBSElement
FROM I_ProjectBillingElement AS ProjectBillingElement
LEFT OUTER JOIN I_EnterpriseProjectElement AS _EnterpriseProjectElement ON ProjectElementUUID = _EnterpriseProjectElement.ProjectElementUUID  -- association [1..1]
LEFT OUTER JOIN I_EnterpriseProject AS _EnterpriseProject ON ProjectUUID = _EnterpriseProject.ProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesOrderItem ON SalesDocument = _SalesOrderItem.SalesDocument AND SalesDocumentItem = _SalesOrderItem.SalesDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesOrder ON SalesDocument = _SalesOrder.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_SDBillingPlan AS _SDBillingPlan ON BillingPlan = _SDBillingPlan.BillingPlan  -- association [0..1]
LEFT OUTER JOIN I_MyProjectBillingElements AS _MyProjectBillingElements ON ProjectBillingElementUUID = _MyProjectBillingElements.ProjectBillingElementUUID  -- association [0..1]
LEFT OUTER JOIN P_ProjBillgElmntSalesDets2 AS _ProjBillgElmntSalesDets ON ProjectBillingElementUUID = _ProjBillgElmntSalesDets.ProjectBillingElementUUID  -- association [1..1]
LEFT OUTER JOIN P_ProjectBillingElmntDueDate3 AS _DueBillingDate ON ProjectBillingElementUUID = _DueBillingDate.ProjectBillingElementUUID  -- association [1..1]
LEFT OUTER JOIN I_TmpProjectBillingRequest AS _TmpProjectBillingRequest ON ProjectBillingElementUUID = _TmpProjectBillingRequest.ProjectBillingElementUUID  -- association [0..1]
LEFT OUTER JOIN I_PrjBlgElmOverduePrepayment AS _PrjBlgElmOverduePrepayment ON ProjectBillingElementUUID = _PrjBlgElmOverduePrepayment.ProjectBillingElementUUID  -- association [0..1]
LEFT OUTER JOIN I_PrjBlgElmPrepaymentAmount AS _PrjBlgElmPrepaymentAmount ON ProjectBillingElementUUID = _PrjBlgElmPrepaymentAmount.ProjectBillingElementUUID  -- association [0..1]
LEFT OUTER JOIN I_PrjBlgElmBllbleRevnAmt AS _PrjBlgElmBllbleRevnAmt ON ProjectBillingElementUUID = _PrjBlgElmBllbleRevnAmt.ProjectBillingElementUUID  -- association [0..1]
LEFT OUTER JOIN I_MyPrjBillgElmntBllbleRevnAmt AS _MyPrjBillgElmntBllbleRevnAmt ON ProjectBillingElementUUID = _MyPrjBillgElmntBllbleRevnAmt.ProjectBillingElementUUID  -- association [0..1]
LEFT OUTER JOIN R_ProjectBillingRequestItemTP AS _ProjectBillingRequestItemTP ON ProjectBillingElementUUID = _ProjectBillingRequestItemTP.ProjectBillingElementUUID  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterName ON WBSElementProfitCenter = _ProfitCenterName.ProfitCenter AND ControllingArea = _ProfitCenterName.ControllingArea AND _ProfitCenterName.ValidityEndDate >= $session.system_date AND _ProfitCenterName.ValidityStartDate <= $session.system_date AND _ProfitCenterName.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _PayerParty ON PayerParty = _PayerParty.Customer  -- association [1..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrgText AS _ServiceOrganizationText ON _ServiceOrganizationText.EngagementProjectServiceOrg = EngagementProjectServiceOrg AND _ServiceOrganizationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_ProjectBillingElement AS _Extension ON ProjectBillingElementUUID = _Extension.ProjectBillingElementUUID  -- association [0..1]
LEFT OUTER JOIN R_ProjectBillingElementEntryTP AS _ProjectBillingElementEntry ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ProjBillgElmObjectLinkTP AS _ProjBillgElmObjectLink ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More