C_ManageProjBillgRequestTP

DDL: C_MANAGEPROJBILLGREQUESTTP Type: view_entity CONSUMPTION
43 Fields 1 Data Sources 3 Associations

Manage Project Billing Request

C_ManageProjBillgRequestTP is a Consumption CDS View that provides data about "Manage Project Billing Request" in SAP S/4HANA. It reads from 1 data source (R_ProjectBillingRequestTP) and exposes 43 fields with key field ProjectBillingRequestUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ProjectBillingRequestTP R_ProjectBillingRequestTP projection

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_ProjectBillingWrkflwApprvr _ProjectBillingWrkflwApprvr $projection.ProjectBillingRequest = _ProjectBillingWrkflwApprvr.TechnicalWrkflwObject
[1..1] C_ProjBillgCustomerProjectDets _ProjBillgCustomerProjectDets $projection.Project = _ProjBillgCustomerProjectDets.Project
[1..1] C_ProjectBillingCustomerCard _CustomerContactCard $projection.Customer = _CustomerContactCard.Customer

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.representativeKey ProjectBillingRequestUUID view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
UI.headerInfo.typeName Project Billing Request view
UI.headerInfo.typeNamePlural Project Billing Requests view
UI.headerInfo.title.label Manage Project Billing Request view
EndUserText.label Manage Project Billing Request view
AccessControl.personalData.blocking #REQUIRED view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingRequestUUID ProjectBillingRequestUUID Item ID
ProjectInternalID ProjectInternalID Project ID
ProjectBillingRequestStatus ProjectBillingRequestStatus Status
ProjectBillingReqStatusTextlocalized Status
ProjBillgReqApprovalStatus ProjBillgReqApprovalStatus Approval Status
ProjBillgReqApprovalStatusTextlocalized Approval Status
ProjectBillingRequestType ProjectBillingRequestType Document Type
SalesDocument SalesDocument Sales Document
ProjBillgReqLastChgdBy ProjBillgReqLastChgdBy Changed By
ProjBillgReqLastChgdAtDteTme ProjBillgReqLastChgdAtDteTme Changed On
ProjBillgReqCreatedBy ProjBillgReqCreatedBy Created By
FullName _UserContactCard FullName Name
ProjBillgReqCreatedAtDteTme ProjBillgReqCreatedAtDteTme Created On
ProjBillgReqCreatedAtDte ProjBillgReqCreatedAtDte Created On
_ProjectBillingRequestItem _ProjectBillingRequestItem
DocumentCurrency Document Currency
DocumentCurrency DocumentCurrency Document Currency
ProjectBillingRequest ProjectBillingRequest Project Billing Request
char60 Billing Method
Project Project Project
ProjectDescription ProjectDescription Project
curr232 To Bill
curr232 To Write Off
curr232 To Postpone
Customer Customer Customer
CustomerName Customer
CustomerName
OrganizationBPName1
char300
ProjectStartDate ProjectStartDate Latest Planned Start
ProjectEndDate ProjectEndDate Ltst Planned Finish
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
_CustomerContactCard _CustomerContactCard
_ProjBillgCustomerProjectDets _ProjBillgCustomerProjectDets
_ProjectBillingRequestStatus _ProjectBillingRequestStatus
UserID UserID User Name
curr232 Amount/Cost to Postpone
curr232 Amount/Cost to Write Off
curr232 Amount/Cost to Bill
int1
_ProjectBillingWrkflwApprvr _ProjectBillingWrkflwApprvr
_EnterpriseProject _EnterpriseProject

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_ManageProjBillgRequestTP.
-- 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_ManageProjBillgRequestTP AS
SELECT
  ProjectBillingRequestUUID,
  ProjectInternalID,
  ProjectBillingRequestStatus,
  _ProjectBillingRequestStatus._ProjectBillingReqStatusText.ProjectBillingReqStatusText : localized AS ProjectBillingReqStatusTextlocalized,
  ProjBillgReqApprovalStatus,
  _ProjBillgReqApprovalStatus._ProjBillgReqApprvlStatusText.ProjBillgReqApprovalStatusText : localized AS ProjBillgReqApprovalStatusTextlocalized,
  ProjectBillingRequestType,
  SalesDocument,
  ProjBillgReqLastChgdBy,
  ProjBillgReqLastChgdAtDteTme,
  ProjBillgReqCreatedBy,
  _UserContactCard.FullName AS FullName,
  ProjBillgReqCreatedAtDteTme,
  ProjBillgReqCreatedAtDte,
  DocumentCurrency,
  ProjectBillingRequest,
  virtual BillingPlanUsageCategoryName : abap.char( 60 ) AS char60,
  Project,
  ProjectDescription,
  virtual BillableRevenueAmtInDocCrcy : abap.curr( 23 , 2 ) AS curr232,
  Customer,
  _CustomerToBusinessPartner._Customer.CustomerName AS CustomerName,
  _CustomerToBusinessPartner._Customer.OrganizationBPName1 AS OrganizationBPName1,
  virtual ProjBillingDocRequestListText : abap.char( 300 ) AS char300,
  ProjectStartDate,
  ProjectEndDate,
  ProfitCenter,
  ControllingArea,
  UserID,
  virtual UICT_ProjBillgReqStsCritlty : abap.int1 AS int1
FROM R_ProjectBillingRequestTP
LEFT OUTER JOIN C_ProjectBillingWrkflwApprvr AS _ProjectBillingWrkflwApprvr ON ProjectBillingRequest = _ProjectBillingWrkflwApprvr.TechnicalWrkflwObject  -- association [0..*]
LEFT OUTER JOIN C_ProjBillgCustomerProjectDets AS _ProjBillgCustomerProjectDets ON Project = _ProjBillgCustomerProjectDets.Project  -- association [1..1]
LEFT OUTER JOIN C_ProjectBillingCustomerCard AS _CustomerContactCard ON Customer = _CustomerContactCard.Customer  -- association [1..1]
;

Learn More