P_MyProjectBillingRequests

DDL: P_MYPROJECTBILLINGREQUESTS Type: view_entity COMPOSITE Package: VDM_PROJECTBILLINGREQUEST

Project Billing Requests by UserID

P_MyProjectBillingRequests is a Composite CDS View that provides data about "Project Billing Requests by UserID" in SAP S/4HANA. It reads from 2 data sources (I_SDDocumentCompletePartners, I_WorkForcePersonMappings) and exposes 2 fields with key fields ProjectBillingRequestUUID, UserID. Part of development package VDM_PROJECTBILLINGREQUEST.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_SDDocumentCompletePartners _Partners inner
I_WorkForcePersonMappings _WorkForcePerson inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Project Billing Requests by UserID view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingRequestUUID pbr ProjectBillingRequestUUID
KEY UserID I_WorkForcePersonMappings UserID 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Project Billing Requests by UserID'
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.usageType: {
    sizeCategory: #XL,
    dataClass: #MIXED,
    serviceQuality: #C
}

define view entity P_MyProjectBillingRequests
  as select distinct from I_ProjectBillingRequest      as pbr
    inner join            I_SDDocumentCompletePartners as _Partners        on  pbr.SalesDocument        = _Partners.SDDocument
                                                                           and _Partners.Personnel      is not initial
                                                                           and _Partners.SDDocumentItem is initial
    inner join            I_WorkForcePersonMappings    as _WorkForcePerson on  _Partners.Personnel     = _WorkForcePerson.WorkforceAssignment
                                                                           and _WorkForcePerson.UserID = $session.user
{
  key pbr.ProjectBillingRequestUUID,
  key _WorkForcePerson.UserID
}



//  as select distinct from I_SDDocumentCompletePartners as Partners

//    inner join            I_WorkForcePersonMappings    as _WorkForcePerson on  Partners.Personnel      = _WorkForcePerson.WorkforceAssignment

//                                                                           and _WorkForcePerson.UserID = $session.user

//{

//  key Partners.SDDocument as SalesOrder,

//  key _WorkForcePerson.UserID

//}

//where

//      Partners.Personnel      is not initial

//  and Partners.SDDocumentItem is initial

Learn More