P_ProjBillingReqDetsForWrkflw

DDL: P_PROJBILLINGREQDETSFORWRKFLW Type: view_entity CONSUMPTION Package: PROJECT_BILLINGREQUEST
23 Fields 1 Data Sources 3 Associations

Inbox Task Data For Workflow

P_ProjBillingReqDetsForWrkflw is a Consumption CDS View that provides data about "Inbox Task Data For Workflow" in SAP S/4HANA. It reads from 1 data source (R_ProjectBillingRequestTP) and exposes 23 fields with key field ProjectBillingRequestUUID. It has 3 associations to related views. Part of development package PROJECT_BILLINGREQUEST.

Data Sources (1)

SourceAliasJoin Type
R_ProjectBillingRequestTP ProjectBillingRequest from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_User _User $projection.ProjBillgReqCreatedBy = _User.UserID
[0..1] C_SoldToValueHelp _SoldToParty $projection.Customer = _SoldToParty.Customer

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Inbox Task Data For Workflow view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingRequestUUID R_ProjectBillingRequestTP ProjectBillingRequestUUID Proj Billg Req UUID
ProjectBillingRequest R_ProjectBillingRequestTP ProjectBillingRequest PBR
ProjBillgReqCreatedBy R_ProjectBillingRequestTP ProjBillgReqCreatedBy Created By
ProjBillgReqCreatedAtDteTme R_ProjectBillingRequestTP ProjBillgReqCreatedAtDteTme Created On
_ProjectBillingRequestItem R_ProjectBillingRequestTP _ProjectBillingRequestItem
Customer
Project
ProjectDescription
ToBeBilledAmtInProjCurrency _ProjBillingReqDetsForWrkflw ToBeBilledAmtInProjCurrency To Be Blld Proj Crcy
ToBeWrittenOffAmtInProjectCrcy _ProjBillingReqDetsForWrkflw ToBeWrittenOffAmtInProjectCrcy Amt ToWrtOff PrCrcy
ToBePostponedAmtInProjectCrcy _ProjBillingReqDetsForWrkflw ToBePostponedAmtInProjectCrcy Amt ToPostpn PrCrcy
GlobalCurrency _ProjBillingReqDetsForWrkflw GlobalCurrency GM Billing Element: Global Currency
DocumentCurrency _ProjBillingReqDetsForWrkflw DocumentCurrency Document Currency
ProjectCurrency _ProjBillingReqDetsForWrkflw ProjectCurrency Project Currency
ProjectInternalID R_ProjectBillingRequestTP ProjectInternalID Project Def.
SalesDocument R_ProjectBillingRequestTP SalesDocument SD Document
ProjectBillingCategory R_ProjectBillingRequestTP ProjectBillingCategory PBF Category
_Customer _Customer
_User _User
_SoldToParty _SoldToParty
_EnterpriseProject R_ProjectBillingRequestTP _EnterpriseProject
_SalesDocument R_ProjectBillingRequestTP _SalesDocument
_ProjectBillingCategory R_ProjectBillingRequestTP _ProjectBillingCategory

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_ProjBillingReqDetsForWrkflw.
-- 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_ProjBillingReqDetsForWrkflw AS
SELECT
  ProjectBillingRequest.ProjectBillingRequestUUID AS ProjectBillingRequestUUID,
  ProjectBillingRequest.ProjectBillingRequest AS ProjectBillingRequest,
  ProjectBillingRequest.ProjBillgReqCreatedBy AS ProjBillgReqCreatedBy,
  ProjectBillingRequest.ProjBillgReqCreatedAtDteTme AS ProjBillgReqCreatedAtDteTme,
  ProjectBillingRequest._ProjectBillingRequestItem AS _ProjectBillingRequestItem,
  ProjectBillingRequest._SalesOrder.SoldToParty AS Customer,
  ProjectBillingRequest._EnterpriseProject.Project AS Project,
  ProjectBillingRequest._EnterpriseProject.ProjectDescription AS ProjectDescription,
  _ProjBillingReqDetsForWrkflw.ToBeBilledAmtInProjCurrency AS ToBeBilledAmtInProjCurrency,
  _ProjBillingReqDetsForWrkflw.ToBeWrittenOffAmtInProjectCrcy AS ToBeWrittenOffAmtInProjectCrcy,
  _ProjBillingReqDetsForWrkflw.ToBePostponedAmtInProjectCrcy AS ToBePostponedAmtInProjectCrcy,
  _ProjBillingReqDetsForWrkflw.GlobalCurrency AS GlobalCurrency,
  _ProjBillingReqDetsForWrkflw.DocumentCurrency AS DocumentCurrency,
  _ProjBillingReqDetsForWrkflw.ProjectCurrency AS ProjectCurrency,
  ProjectBillingRequest.ProjectInternalID AS ProjectInternalID,
  ProjectBillingRequest.SalesDocument AS SalesDocument,
  ProjectBillingRequest.ProjectBillingCategory AS ProjectBillingCategory,
  ProjectBillingRequest._EnterpriseProject AS _EnterpriseProject,
  ProjectBillingRequest._SalesDocument AS _SalesDocument,
  ProjectBillingRequest._ProjectBillingCategory AS _ProjectBillingCategory
FROM R_ProjectBillingRequestTP AS ProjectBillingRequest
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_User AS _User ON ProjBillgReqCreatedBy = _User.UserID  -- association [0..1]
LEFT OUTER JOIN C_SoldToValueHelp AS _SoldToParty ON Customer = _SoldToParty.Customer  -- association [0..1]
;

Learn More