I_PROJECTBILLINGREQUEST

CDS View

Project Billing Request

I_PROJECTBILLINGREQUEST is a CDS View in S/4HANA. Project Billing Request. It contains 12 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 12 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_ProjectBillingRequestTP view_entity from TRANSACTIONAL Details of Project Billing Request
P_BillgDocProcFlowPrjBlgReq view_entity from BASIC Project billing request in process flow
P_PrjBlgElmBillingReqRevnAmt view inner COMPOSITE Billing Requested Amt for Billing Elmnt
P_PrjBlgElmntEntrMnlSeldToBill view_entity from COMPOSITE PrjBlgElmntEntr manually sel. for Billg
P_ProjBillgReqDetails view_entity from TRANSACTIONAL P view for Proj Billing Request details
P_ProjBillingInProcessDetails view_entity inner TRANSACTIONAL P view for Billing in Process details
P_SlsOrdProcFlowPrjBlgReq view_entity from CONSUMPTION
R_ProjectBillingRequestTP view_entity from TRANSACTIONAL Details of Project Billing Request

Fields (12)

KeyField CDS FieldsUsed in Views
KEY ProjectBillingRequest ProjectBillingRequest 4
KEY ProjectBillingRequestUUID ProjectBillingRequestUUID 3
_ProjectBillingRequestItem _ProjectBillingRequestItem 2
ProjBillgReqApprovalStatus ProjBillgReqApprovalStatus 3
ProjBillgReqCreatedAtDteTme ProjBillgReqCreatedAtDteTme 2
ProjBillgReqCreatedBy ProjBillgReqCreatedBy 2
ProjBillgReqLastChgdAtDteTme ProjBillgReqLastChgdAtDteTme 2
ProjBillgReqLastChgdBy ProjBillgReqLastChgdBy 2
ProjectBillingCategory ProjectBillingCategory 1
ProjectBillingRequestStatus ProjectBillingRequestStatus 3
ProjectBillingRequestType ProjectBillingRequestType 2
SalesDocument SalesDocument 2 
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@EndUserText.label: 'Project Billing Request'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@Analytics.dataExtraction.enabled: true
@Analytics.dataExtraction.delta.changeDataCapture.automatic: true
@ObjectModel: {
    modelingPattern: #ANALYTICAL_DIMENSION,
    supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE ],
    usageType: {
        sizeCategory: #L,
        dataClass:  #TRANSACTIONAL,
        serviceQuality: #A
    },
    representativeKey: 'ProjectBillingRequestUUID'
}
@Metadata.ignorePropagatedAnnotations: true

define view entity I_ProjectBillingRequest
  as select from projbillgreq
  association [0..*] to I_ProjectBillingRequestItem   as _ProjectBillingRequestItem   on $projection.ProjectBillingRequestUUID = _ProjectBillingRequestItem.ProjectBillingRequestUUID
  association [0..1] to I_ProjectBillingRequestStatus as _ProjectBillingRequestStatus on $projection.ProjectBillingRequestStatus = _ProjectBillingRequestStatus.ProjectBillingRequestStatus
  association [0..1] to I_ProjBillgReqApprovalStatus  as _ProjBillgReqApprovalStatus  on $projection.ProjBillgReqApprovalStatus = _ProjBillgReqApprovalStatus.ProjBillgReqApprovalStatus
  association [0..1] to I_ProjectBillingCategory      as _ProjectBillingCategory      on $projection.ProjectBillingCategory = _ProjectBillingCategory.ProjectBillingCategory

  association [0..1] to I_SalesDocument               as _SalesDocument               on $projection.SalesDocument = _SalesDocument.SalesDocument
  association [1..1] to I_EnterpriseProject           as _EnterpriseProject           on $projection.ProjectInternalID = _EnterpriseProject.ProjectInternalID  
{
  key projectbillingrequestuuid    as ProjectBillingRequestUUID,
      projectbillingrequest        as ProjectBillingRequest,
      @ObjectModel.foreignKey.association: '_ProjectBillingRequestStatus'
      projectbillingrequeststatus  as ProjectBillingRequestStatus,
      @ObjectModel.foreignKey.association: '_ProjBillgReqApprovalStatus'
      projbillgreqapprovalstatus   as ProjBillgReqApprovalStatus,
      projectbillingrequesttype    as ProjectBillingRequestType,
      @ObjectModel.foreignKey.association: '_SalesDocument'
      salesdocument                as SalesDocument,
//      salesdocumenttype            as SalesDocumentType,

      @ObjectModel.foreignKey.association: '_ProjectBillingCategory'
      projectbillingcategory       as ProjectBillingCategory,
      @Semantics.user.lastChangedBy: true
      projbillgreqlastchgdby       as ProjBillgReqLastChgdBy,
      @Semantics.systemDateTime.lastChangedAt: true
      projbillgreqlastchgdatdtetme as ProjBillgReqLastChgdAtDteTme,
      @Semantics.user.createdBy: true
      projbillgreqcreatedby        as ProjBillgReqCreatedBy,
      @Semantics.systemDateTime.createdAt: true
      projbillgreqcreatedatdtetme  as ProjBillgReqCreatedAtDteTme,
      projectinternalid            as ProjectInternalID,

      _ProjectBillingRequestItem,
      _ProjectBillingRequestStatus,
      _ProjBillgReqApprovalStatus,
      _ProjectBillingCategory,

      _SalesDocument,
      _EnterpriseProject
}

Learn More