P_ProjBillgElmntSalesDets2

DDL: P_PROJBILLGELMNTSALESDETS2 Type: view_entity COMPOSITE
19 Fields 1 Data Sources 4 Associations

Project Billing Elements

P_ProjBillgElmntSalesDets2 is a Composite CDS View that provides data about "Project Billing Elements" in SAP S/4HANA. It reads from 1 data source (I_ProjectBillingElement) and exposes 19 fields with key field ProjectBillingElementUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProjectBillingElement ProjectBillingElement from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_SalesOrderItem _SalesOrderItem ProjectBillingElement.BillingWBSElementInternalID = _SalesOrderItem.WBSElementInternalID
[1..1] P_MyProjectBillingElements2 _MyProjectBillingElements $projection.ProjectBillingElementUUID = _MyProjectBillingElements.ProjectBillingElementUUID --
[1..1] P_ProjectBillingElmntDueDate3 _ProjBillgElmntDueDate $projection.ProjectBillingElementUUID = _ProjBillgElmntDueDate.ProjectBillingElementUUID
[0..1] I_SDBillingPlan _SDBillingPlan $projection.BillingPlan = _SDBillingPlan.BillingPlan

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Project Billing Elements view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingElementUUID I_ProjectBillingElement ProjectBillingElementUUID PBE UUID
BillingWBSElementInternalID I_ProjectBillingElement BillingWBSElementInternalID WBS Internal ID
SalesOrder _SalesOrderItem SalesOrder SD Document
SalesOrderItem _SalesOrderItem SalesOrderItem Sales Order Item
BillingPlan _SalesOrderItem BillingPlan Bill. Plan No.
TransactionCurrency _SalesOrderItem TransactionCurrency Transaction Currency
CappedNetAmount _SalesOrderItem CappedNetAmount
Customer
BillingBlockStatus _SalesOrderItem BillingBlockStatus
BillingBlockReason _SalesOrderItem ItemBillingBlockReason Billing Block
SalesDocumentRjcnReason _SalesOrderItem SalesDocumentRjcnReason RejectionReason
SDDocumentRejectionStatus _SalesOrderItem SDDocumentRejectionStatus
WBSElementDescription _SalesOrderItem SalesOrderItemText
UserID _MyProjectBillingElements UserID User Name
DueBillingDate
_MyProjectBillingElements _MyProjectBillingElements
_SalesOrderItem _SalesOrderItem
_SalesOrder _SalesOrderItem _SalesOrder
_SalesDocItemBillPlan _SDBillingPlan

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_ProjBillgElmntSalesDets2.
-- 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_ProjBillgElmntSalesDets2 AS
SELECT
  ProjectBillingElement.ProjectBillingElementUUID AS ProjectBillingElementUUID,
  ProjectBillingElement.BillingWBSElementInternalID AS BillingWBSElementInternalID,
  _SalesOrderItem.SalesOrder AS SalesOrder,
  _SalesOrderItem.SalesOrderItem AS SalesOrderItem,
  _SalesOrderItem.BillingPlan AS BillingPlan,
  _SalesOrderItem.TransactionCurrency AS TransactionCurrency,
  _SalesOrderItem.CappedNetAmount AS CappedNetAmount,
  _SalesOrderItem._SalesOrder.SoldToParty AS Customer,
  _SalesOrderItem.BillingBlockStatus AS BillingBlockStatus,
  _SalesOrderItem.ItemBillingBlockReason AS BillingBlockReason,
  _SalesOrderItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  _SalesOrderItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  _SalesOrderItem.SalesOrderItemText AS WBSElementDescription,
  _MyProjectBillingElements.UserID AS UserID,
  _SalesOrderItem._SalesOrder AS _SalesOrder
FROM I_ProjectBillingElement AS ProjectBillingElement
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON ProjectBillingElement.BillingWBSElementInternalID = _SalesOrderItem.WBSElementInternalID  -- association [1..1]
LEFT OUTER JOIN P_MyProjectBillingElements2 AS _MyProjectBillingElements ON ProjectBillingElementUUID = _MyProjectBillingElements.ProjectBillingElementUUID  -- association [1..1]
LEFT OUTER JOIN P_ProjectBillingElmntDueDate3 AS _ProjBillgElmntDueDate ON ProjectBillingElementUUID = _ProjBillgElmntDueDate.ProjectBillingElementUUID  -- association [1..1]
LEFT OUTER JOIN I_SDBillingPlan AS _SDBillingPlan ON BillingPlan = _SDBillingPlan.BillingPlan  -- association [0..1]
;

Learn More