I_TMPPROJECTBILLINGREQUEST

CDS View

Temporary Project Billing Request

I_TMPPROJECTBILLINGREQUEST is a CDS View in S/4HANA. Temporary Project Billing Request. It contains 4 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 4 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PrjBlgReqManualItmWBSVH view_entity from CONSUMPTION Manual WBS Element Search Help
I_WrittenOffPrjBlgElmEntrDets view from COMPOSITE Details for Written off items

Fields (4)

KeyField CDS FieldsUsed in Views
KEY ProjectBillingElementUUID ProjectBillingElementUUID 1
KEY ProjectBillingRequestUUID ProjectBillingRequestUUID 2
ProjectInternalID ProjectInternalID 1
SalesDocument SalesDocument 1 
@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: #CHECK
@ObjectModel.usageType: {
    sizeCategory: #XL,
    dataClass:  #TRANSACTIONAL,
    serviceQuality: #A
}
@EndUserText.label: 'Temporary Project Billing Request'
//define view I_TmpProjectBillingRequest as select distinct from I_ProjectBillingElement as ProjectBillingElement

//association [1..*] to I_ProjectBillingRequestItem as _ProjectBillingRequestItem on $projection.ProjectBillingElementUUID = _ProjectBillingRequestItem.ProjectBillingElementUUID

/*define view I_TmpProjectBillingRequest as select distinct from I_ProjectBillingRequest as ProjectBillingRequest
association [0..*] to I_ProjectBillingRequestItem as _ProjectBillingRequestItem on $projection.ProjectBillingRequestUUID = _ProjectBillingRequestItem.ProjectBillingRequestUUID

//and _ProjectBillingRequest.ProjectBillingRequest like 'S%'

{

  key _ProjectBillingRequestItem.ProjectBillingElementUUID,
  key ProjectBillingRequest,
  ProjectBillingRequestUUID

}where ProjectBillingRequestStatus = 'C'
*/

define view I_TmpProjectBillingRequest
  as
  /* This part of UNION is deleted by C5222381 (Yury) to measure performance impact
  //removed distinct from seclection to check the filter push down in CCW - done by Amritha

  select from I_ProjectBillingRequest as ProjectBillingRequest
  --association [1..1] to I_ProjectBillingRequest as  _ProjectBillingRequest on $projection.ProjectBillingRequestUUID = _ProjectBillingRequest.ProjectBillingRequestUUID
  inner join I_ProjectBillingRequestItem as ProjectBillingRequestItem on ProjectBillingRequest.ProjectBillingRequestUUID = ProjectBillingRequestItem.ProjectBillingRequestUUID
  {
    key ProjectBillingRequestItem.ProjectBillingElementUUID,
    key ProjectBillingRequestItem.ProjectBillingRequestUUID,

    ProjectBillingRequestItem.ProjectBillingRequest,
    ProjectBillingRequest.ProjectBillingRequestStatus
  }
  where ProjectBillingRequest.ProjectBillingRequestStatus = 'C'

  union
  */
  select distinct from I_ProjectBillingRequest  as ProjectBillingRequest
  --association [1..1] to I_ProjectBillingRequest as  _ProjectBillingRequest on $projection.ProjectBillingRequestUUID = _ProjectBillingRequest.ProjectBillingRequestUUID
    inner join         I_ProjBillgReqObjectLink as ProjBillgReqObjectLink on ProjectBillingRequest.ProjectBillingRequestUUID = ProjBillgReqObjectLink.ProjectBillingRequestUUID
    //association [1..1] to I_SalesOrder       as _SalesOrder       on  $projection.SalesDocument = _SalesOrder.SalesOrder

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

      ProjectBillingRequest.ProjectBillingRequest,
      ProjectBillingRequest.ProjectBillingRequestStatus,
      ProjectBillingRequest.SalesDocument,
      ProjectBillingRequest.ProjectInternalID
//      _SalesOrder.DistributionChannel,

//      _SalesOrder.SalesOrganization,

//      _SalesOrder.SoldToParty

}
where
  ProjectBillingRequest.ProjectBillingRequestStatus = 'C'

Learn More