C_ProjBillingInProcessDetails

DDL: C_PROJBILLINGINPROCESSDETAILS Type: view_entity CONSUMPTION Package: VDM_PROJECTBILLINGELEMENT
10 Fields 1 Data Sources 1 Associations 3 OData Services

Details of Billing in Process

C_ProjBillingInProcessDetails is a Consumption CDS View that provides data about "Details of Billing in Process" in SAP S/4HANA. It reads from 1 data source (P_ProjBillgInProcAggrgdDetails) and exposes 10 fields with key fields ProjectBillingElementUUID, ProjectBillingRequest, BillingDocumentRequest. It has 1 association to related views. It is exposed through 3 OData services (ASQL_F4374A, PROJECTBILLINGELEMENT_SD, UI_PROJECTBILLINGELEMENT). Part of development package VDM_PROJECTBILLINGELEMENT.

Data Sources (1)

SourceAliasJoin Type
P_ProjBillgInProcAggrgdDetails P_ProjBillgInProcAggrgdDetails from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BillingDocumentTypeText_2 _BillingDocumentTypeText $projection.BillingDocumentType = _BillingDocumentTypeText.BillingDocumentType and _BillingDocumentTypeText.Language = $session.system_language

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Details of Billing in Process view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

OData Services (3)

ServiceBindingVersionContractRelease
ASQL_F4374A ASQL_F4374A C2 NOT_RELEASED
PROJECTBILLINGELEMENT_SD UI_PROJBILLGELMNT_SB_V2 V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_PROJECTBILLINGELEMENT UI_PROJECTBILLINGELEMENT V4 C1 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingElementUUID ProjectBillingElementUUID PBE UUID
KEY ProjectBillingRequest ProjectBillingRequest PBR
KEY BillingDocumentRequest BillingDocumentRequest BDR
BillingDocumentType BillingDocumentType Billing Type
ProjectBillingRequestUUID ProjectBillingRequestUUID Proj Billg Req UUID
ProjBillgReqApprovalStatusText ProjBillgReqApprovalStatusText PBR Approval Status
PrjBlgElmEntrDocBillgStsText PrjBlgElmEntrDocBillgStsText
DocumentCurrency DocumentCurrency Document Currency
BillgReqdRevenueAmtInDocCrcy BillgReqdRevenueAmtInDocCrcy Net Amount
_BillingDocumentTypeText _BillingDocumentTypeText

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 C_ProjBillingInProcessDetails.
-- 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 C_ProjBillingInProcessDetails AS
SELECT
  ProjectBillingElementUUID,
  ProjectBillingRequest,
  BillingDocumentRequest,
  BillingDocumentType,
  ProjectBillingRequestUUID,
  ProjBillgReqApprovalStatusText,
  PrjBlgElmEntrDocBillgStsText,
  DocumentCurrency,
  BillgReqdRevenueAmtInDocCrcy
FROM P_ProjBillgInProcAggrgdDetails
LEFT OUTER JOIN I_BillingDocumentTypeText_2 AS _BillingDocumentTypeText ON BillingDocumentType = _BillingDocumentTypeText.BillingDocumentType AND _BillingDocumentTypeText.Language = $session.system_language  -- association [0..1]
;

Learn More