I_TmpProjectBillingRequest

DDL: I_TMPPROJECTBILLINGREQUEST SQL: ITMPPROJBILLGREQ Type: view_entity COMPOSITE Package: VDM_PROJECTBILLINGELEMENT

Temporary Project Billing Request

I_TmpProjectBillingRequest is a Composite CDS View that provides data about "Temporary Project Billing Request" in SAP S/4HANA. It reads from 2 data sources (I_ProjBillgReqObjectLink, I_ProjectBillingRequest) and exposes 6 fields with key fields ProjectBillingElementUUID, ProjectBillingRequestUUID. Part of development package VDM_PROJECTBILLINGELEMENT.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_ProjBillgReqObjectLink ProjBillgReqObjectLink from
I_ProjectBillingRequest ProjectBillingRequest inner

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
EndUserText.label Temporary Project Billing Request view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingElementUUID I_ProjBillgReqObjectLink ReferencedObjectUUID
KEY ProjectBillingRequestUUID I_ProjectBillingRequest ProjectBillingRequestUUID
ProjectBillingRequest I_ProjectBillingRequest ProjectBillingRequest
ProjectBillingRequestStatus I_ProjectBillingRequest ProjectBillingRequestStatus
SalesDocument I_ProjectBillingRequest SalesDocument
ProjectInternalID I_ProjectBillingRequest ProjectInternalID 
//@AbapCatalog.sqlViewName: 'ITMPPROJBILLGREQ'

//@AbapCatalog.compiler.compareFilter: true

//@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {
    sizeCategory: #XL,
    dataClass:  #TRANSACTIONAL,
    serviceQuality: #A
}
@EndUserText.label: 'Temporary Project Billing Request'


define view entity I_TmpProjectBillingRequest
  //  as select from I_ProjectBillingRequest  as ProjectBillingRequest //distinct is not needed: PBR in status C has unique set of PBE

  //    inner join   I_ProjBillgReqObjectLink as ProjBillgReqObjectLink on ProjectBillingRequest.ProjectBillingRequestUUID = ProjBillgReqObjectLink.ProjectBillingRequestUUID

  as select from I_ProjBillgReqObjectLink as ProjBillgReqObjectLink
    inner join   I_ProjectBillingRequest  as ProjectBillingRequest on  ProjectBillingRequest.ProjectBillingRequestUUID   = ProjBillgReqObjectLink.ProjectBillingRequestUUID
                                                                   and ProjectBillingRequest.ProjectBillingRequestStatus = 'C'

{
  key ProjBillgReqObjectLink.ReferencedObjectUUID as ProjectBillingElementUUID,
  key ProjectBillingRequest.ProjectBillingRequestUUID,

      ProjectBillingRequest.ProjectBillingRequest,
      ProjectBillingRequest.ProjectBillingRequestStatus,
      ProjectBillingRequest.SalesDocument,
      ProjectBillingRequest.ProjectInternalID

}
//where

//  ProjectBillingRequest.ProjectBillingRequestStatus = 'C'

Learn More