I_TmpProjectBillingRequest

DDL: I_TMPPROJECTBILLINGREQUEST SQL: ITMPPROJBILLGREQ Type: view_entity COMPOSITE Package: VDM_PROJECTBILLINGELEMENT
6 Fields 2 Data Sources

Temporary Project Billing Request

I_TmpProjectBillingRequest is a Composite CDS View that provides data about "Temporary Project Billing Request" in SAP S/4HANA. It reads from 2 data sources (I_ProjBillgReqObjectLink, I_ProjectBillingRequest) and exposes 6 fields with key fields ProjectBillingElementUUID, ProjectBillingRequestUUID. Part of development package VDM_PROJECTBILLINGELEMENT.

Data Sources (2)

SourceAliasJoin Type
I_ProjBillgReqObjectLink ProjBillgReqObjectLink from
I_ProjectBillingRequest ProjectBillingRequest inner

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
EndUserText.label Temporary Project Billing Request view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingElementUUID I_ProjBillgReqObjectLink ReferencedObjectUUID Referenced Object
KEY ProjectBillingRequestUUID I_ProjectBillingRequest ProjectBillingRequestUUID Proj Billg Req UUID
ProjectBillingRequest I_ProjectBillingRequest ProjectBillingRequest PBR
ProjectBillingRequestStatus I_ProjectBillingRequest ProjectBillingRequestStatus Billing Req Status
SalesDocument I_ProjectBillingRequest SalesDocument SD Document
ProjectInternalID I_ProjectBillingRequest ProjectInternalID Project Def.

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_TmpProjectBillingRequest.
-- 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: ITMPPROJBILLGREQ

CREATE VIEW I_TmpProjectBillingRequest AS
SELECT
  ProjBillgReqObjectLink.ReferencedObjectUUID AS ProjectBillingElementUUID,
  ProjectBillingRequest.ProjectBillingRequestUUID AS ProjectBillingRequestUUID,
  ProjectBillingRequest.ProjectBillingRequest AS ProjectBillingRequest,
  ProjectBillingRequest.ProjectBillingRequestStatus AS ProjectBillingRequestStatus,
  ProjectBillingRequest.SalesDocument AS SalesDocument,
  ProjectBillingRequest.ProjectInternalID AS ProjectInternalID
FROM I_ProjBillgReqObjectLink AS ProjBillgReqObjectLink
INNER JOIN I_ProjectBillingRequest AS ProjectBillingRequest ON /* join condition not captured in parsed metadata */
;

Learn More