C_ProjectBillingRequestTP

DDL: C_PROJECTBILLINGREQUESTTP Type: view_entity CONSUMPTION Package: ODATA_PROJBILLINGREQUEST_LIST
37 Fields 1 Data Sources 1 OData Services

Details of Project Billing Request

C_ProjectBillingRequestTP is a Consumption CDS View that provides data about "Details of Project Billing Request" in SAP S/4HANA. It reads from 1 data source (R_ProjectBillingRequestTP) and exposes 37 fields with key field ProjectBillingRequestUUID. It is exposed through 1 OData service (PROJECTBILLINGREQUEST_SD). Part of development package ODATA_PROJBILLINGREQUEST_LIST.

Data Sources (1)

SourceAliasJoin Type
R_ProjectBillingRequestTP R_ProjectBillingRequestTP projection

Annotations (11)

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 Requests view
EndUserText.label Details of Project Billing Request view

OData Services (1)

ServiceBindingVersionContractRelease
PROJECTBILLINGREQUEST_SD UI_PROJBILLGREQUEST_SB_V2 V2 C1 NOT_TO_BE_RELEASED_STABLE

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingRequestUUID ProjectBillingRequestUUID Item ID
ProjectInternalID ProjectInternalID Project ID
ProjectBillingRequestStatus ProjectBillingRequestStatus Billing Req Status
ProjBillgReqApprovalStatus ProjBillgReqApprovalStatus PBR Apprvl Sts
ProjectBillingRequestType ProjectBillingRequestType Document Type
SalesDocument SalesDocument Sales Document
ProjectBillingCategory ProjectBillingCategory PBF Category
ProjBillgReqLastChgdBy ProjBillgReqLastChgdBy Changed By
ProjBillgReqLastChgdAtDteTme ProjBillgReqLastChgdAtDteTme Changed On
ProjBillgReqCreatedBy ProjBillgReqCreatedBy Created By
ProjBillgReqCreatedAtDteTme ProjBillgReqCreatedAtDteTme Created On
DocumentCurrency DocumentCurrency Document Currency
ProjectBillingRequest ProjectBillingRequest Project Billing Request
CustomerProject Project Project
Customer _CustomerToBusinessPartner Customer Customer
CustomerName Customer
char30 Billing Element
char60 Billing Method
char30 Profit Center
dats8 Billing Due Date
char1
string
curr232 Billed
curr232 Estimated Actuals
curr232 To Bill
curr232 To Write Off
curr232 To Postpone
curr232 Cap
curr232 Amount/Cost to Postpone
curr232 Amount/Cost to Write Off
curr232 Amount/Cost to Bill
string Total Quantities
_ProjectBillingRequestItem _ProjectBillingRequestItem
_ProjectBillingRequestStatus _ProjectBillingRequestStatus
_EnterpriseProject _EnterpriseProject
_SalesDocument _SalesDocument
_ProjectBillingCategory _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 C_ProjectBillingRequestTP.
-- 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_ProjectBillingRequestTP AS
SELECT
  ProjectBillingRequestUUID,
  ProjectInternalID,
  ProjectBillingRequestStatus,
  ProjBillgReqApprovalStatus,
  ProjectBillingRequestType,
  SalesDocument,
  ProjectBillingCategory,
  ProjBillgReqLastChgdBy,
  ProjBillgReqLastChgdAtDteTme,
  ProjBillgReqCreatedBy,
  ProjBillgReqCreatedAtDteTme,
  DocumentCurrency,
  ProjectBillingRequest,
  Project AS CustomerProject,
  _CustomerToBusinessPartner.Customer AS Customer,
  _CustomerToBusinessPartner._Customer.CustomerName AS CustomerName,
  virtual WBSElementExternalID : abap.char( 30 ) AS char30,
  virtual BillingPlanUsageCategoryName : abap.char( 60 ) AS char60,
  virtual BillingPlanBillingDate : abap.dats( 8 ) AS dats8,
  virtual UtilitiesBillingReason : abap.char( 1 ) AS char1,
  virtual ProjectBillgRequestMessageText : abap.string AS string,
  virtual BilledRevenueAmtInDocCrcy : abap.curr( 23 , 2 ) AS curr232
FROM R_ProjectBillingRequestTP
;

Learn More