P_ProjectBillingElmntDueDate2

DDL: P_PROJECTBILLINGELMNTDUEDATE2 Type: view_entity COMPOSITE
3 Fields 1 Data Sources 2 Associations

Billing Due Date of Billing Element (2)

P_ProjectBillingElmntDueDate2 is a Composite CDS View that provides data about "Billing Due Date of Billing Element (2)" in SAP S/4HANA. It reads from 1 data source (P_ProjBillingElmntAllBillDate) and exposes 3 fields with key field ProjectBillingElementUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_ProjBillingElmntAllBillDate AllBillDate from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_ProjBillingElmntMaxBillDate MaxBillDate $projection.BillingPlan = MaxBillDate.BillingPlan
[0..1] P_ProjBillingElmntMinBillDate MinBillDate $projection.BillingPlan = MinBillDate.BillingPlan

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Billing Due Date of Billing Element (2) 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 (3)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingElementUUID P_ProjBillingElmntAllBillDate ProjectBillingElementUUID PBE UUID
BillingPlan P_ProjBillingElmntAllBillDate BillingPlan Bill. Plan No.
BillingDateendasDueBillingDate

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_ProjectBillingElmntDueDate2.
-- 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_ProjectBillingElmntDueDate2 AS
SELECT
  AllBillDate.ProjectBillingElementUUID AS ProjectBillingElementUUID,
  AllBillDate.BillingPlan AS BillingPlan,
  case when MaxBillDate.BillingDate is not null then MaxBillDate.BillingDate when MinBillDate.BillingDate is not null then MinBillDate.BillingDate when AllBillDate.BillingDate is not null then AllBillDate.BillingDate end as DueBillingDate AS BillingDateendasDueBillingDate
FROM P_ProjBillingElmntAllBillDate AS AllBillDate
LEFT OUTER JOIN P_ProjBillingElmntMaxBillDate AS MaxBillDate ON BillingPlan = MaxBillDate.BillingPlan  -- association [0..1]
LEFT OUTER JOIN P_ProjBillingElmntMinBillDate AS MinBillDate ON BillingPlan = MinBillDate.BillingPlan  -- association [0..1]
;

Learn More