P_ProjBillgReqDetails

DDL: P_PROJBILLGREQDETAILS Type: view_entity TRANSACTIONAL
6 Fields 3 Data Sources

P view for Proj Billing Request details

P_ProjBillgReqDetails is a Transactional CDS View that provides data about "P view for Proj Billing Request details" in SAP S/4HANA. It reads from 3 data sources (I_ProjBillgReqApprvlStatusText, I_ProjectBillingRequest, I_ProjectBillingRequestItem) and exposes 6 fields.

Data Sources (3)

SourceAliasJoin Type
I_ProjBillgReqApprvlStatusText _ProjBillgReqApprvlStatusText inner
I_ProjectBillingRequest _ProjectBillingRequest from
I_ProjectBillingRequestItem _ProjectBillingRequestItem inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label P view for Proj Billing Request details view

Fields (6)

KeyFieldSource TableSource FieldDescription
ProjectBillingRequestUUID I_ProjectBillingRequest ProjectBillingRequestUUID Proj Billg Req UUID
ProjectBillingRequest I_ProjectBillingRequest ProjectBillingRequest PBR
ProjectBillingRequestStatus I_ProjectBillingRequest ProjectBillingRequestStatus Billing Req Status
ProjBillgReqApprovalStatus I_ProjectBillingRequest ProjBillgReqApprovalStatus PBR Apprvl Sts
ProjBillgReqApprovalStatusText I_ProjBillgReqApprvlStatusText ProjBillgReqApprovalStatusText Short text
DocumentCurrency I_ProjectBillingRequestItem DocumentCurrency Document Currency

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_ProjBillgReqDetails.
-- 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_ProjBillgReqDetails AS
SELECT
  _ProjectBillingRequest.ProjectBillingRequestUUID AS ProjectBillingRequestUUID,
  _ProjectBillingRequest.ProjectBillingRequest AS ProjectBillingRequest,
  _ProjectBillingRequest.ProjectBillingRequestStatus AS ProjectBillingRequestStatus,
  _ProjectBillingRequest.ProjBillgReqApprovalStatus AS ProjBillgReqApprovalStatus,
  _ProjBillgReqApprvlStatusText.ProjBillgReqApprovalStatusText AS ProjBillgReqApprovalStatusText,
  _ProjectBillingRequestItem.DocumentCurrency AS DocumentCurrency
FROM I_ProjectBillingRequest AS _ProjectBillingRequest
INNER JOIN I_ProjectBillingRequestItem AS _ProjectBillingRequestItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProjBillgReqApprvlStatusText AS _ProjBillgReqApprvlStatusText ON /* join condition not captured in parsed metadata */
;

Learn More