R_ENTERPRISEPROJECTELEMENTJVA

CDS View

Basic view for Joint Vntr Account on WBS

R_ENTERPRISEPROJECTELEMENTJVA is a CDS View in S/4HANA. Basic view for Joint Vntr Account on WBS. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EntProjectElementJVATP_2 view_entity from TRANSACTIONAL Extension fields for JVA on Task level

Fields (2)

KeyField CDS FieldsUsed in Views
ProjectUUID ProjectUUID 1
WBSElementInternalID WBSElementInternalID 1 
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #SAP_INTERNAL_API
}

@AccessControl: {
    authorizationCheck:     #MANDATORY,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}

@ObjectModel: {
   compositionRoot: false,
   representativeKey: 'TaskUUID',
   alternativeKey: [ { id : 'WBSElementInternalID', uniqueness: #UNIQUE } ],
   usageType: {
     serviceQuality:  #B,
     dataClass:       #MIXED, 
     sizeCategory:    #L
    }
}

@EndUserText.label: 'Basic view for Joint Vntr Account on WBS'
define view entity R_EnterpriseProjectElementJVA
    as select from /s4ppm/task    as task
      inner join   prps           as prps on prps.pspnr = task.pspnr
   
   association [1..1] to R_EnterpriseProjectElement as _Element                  on $projection.TaskUUID     = _Element.ProjectElementUUID
   association [1..1] to R_EnterpriseProject        as _EnterpriseProject        on $projection.ProjectUUID  = _EnterpriseProject.ProjectUUID
   association [1..1] to I_JointVentureMasterFld    as jv                        on $projection.JointVenture = jv.JointVenture
                                                                                and task.companycode         = jv.CompanyCode
{
  key task.guid                       as TaskUUID,
      task.project_guid               as ProjectUUID,
      cast ( task.pspnr as ps_s4_pspnr preserving type ) as WBSElementInternalID,
      
      prps.vname                      as JointVenture,
      prps.recid                      as JointVentureCostRecoveryCode, 
      prps.etype                      as JointVentureEquityType, 
      prps.otype                      as JntVntrProjectType, 
      prps.jibcl                      as JntIntrstBillgClass, 
      prps.jibsa                      as JntIntrstBillgSubClass,
      jv.JointVentureType             as JointVentureType,
      
      cast ( prps.pkokr as ps_s4_kokrs preserving type ) as ControllingArea,
      prps.prctr                                         as ProfitCenter,
      
      _EnterpriseProject,
      _Element  
}

Learn More