I_PPM_ProjectTaskJVA

DDL: I_PPM_PROJECTTASKJVA SQL: IPPMPROJTASKJVA Type: view COMPOSITE Package: PPM_OBJECTS_DEPRECATED

Extension fields for Joint Venture Accounting on Task level

I_PPM_ProjectTaskJVA is a Composite CDS View that provides data about "Extension fields for Joint Venture Accounting on Task level" in SAP S/4HANA. It reads from 2 data sources (I_PPM_Task, I_WBSElementBasicData) and exposes 22 fields with key field TaskUUID. It has 3 associations to related views. Part of development package PPM_OBJECTS_DEPRECATED.

Data Sources (2)

SourceAliasJoin Type
I_PPM_Task task from
I_WBSElementBasicData wbs inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_PPM_ProjectTask _ProjectTask _ProjectTask.TaskUUID = $projection.TaskUUID
[1..1] I_PPM_Project _Root _Root.ProjectUUID = $projection.ProjectUUID
[1..1] I_JointVentureMasterFld jv wbs.CompanyCode = jv.CompanyCode and wbs.JointVenture = jv.JointVenture

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IPPMPROJTASKJVA view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor R_EnterpriseProjectElementJVA view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey TaskUUID view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Extension fields for Joint Venture Accounting on Task level view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY TaskUUID I_PPM_Task TaskUUID
WBSElementInternalID I_PPM_Task WBSElementInternalID
ProjectUUID I_PPM_Task ProjectUUID
IsProjectMilestone I_PPM_Task IsProjectMilestone
ProjectInternalID I_PPM_Task ProjectInternalID
ControllingArea I_WBSElementBasicData ControllingArea
ProfitCenter I_WBSElementBasicData ProfitCenter
JointVenture I_WBSElementBasicData JointVenture
JointVentureCostRecoveryCode I_WBSElementBasicData JointVentureCostRecoveryCode
JointVentureEquityType I_WBSElementBasicData JointVentureEquityType
JntVntrProjectType I_WBSElementBasicData JntVntrProjectType
JntIntrstBillgClass I_WBSElementBasicData JntIntrstBillgClass
JntIntrstBillgSubClass I_WBSElementBasicData JntIntrstBillgSubClass
JointVentureType jv JointVentureType
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup
_ProjectTask _ProjectTask
_Root _Root
_ProjObj I_PPM_Task _ProjObj
_I_Project I_PPM_Task _I_Project
@AbapCatalog.sqlViewName: 'IPPMPROJTASKJVA'
@VDM.lifecycle:
       { status:    #DEPRECATED,
         successor: 'R_EnterpriseProjectElementJVA' }
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:
{
  serviceQuality: #C,
  dataClass: #TRANSACTIONAL,
  sizeCategory: #L
}
@ObjectModel.representativeKey: 'TaskUUID'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API 
@EndUserText.label: 'Extension fields for Joint Venture Accounting on Task level'
define view I_PPM_ProjectTaskJVA as select from I_PPM_Task as task
    inner join I_WBSElementBasicData as wbs
        on wbs.WBSElementInternalID = task.WBSElementInternalID
    association [1..1] to I_PPM_ProjectTask as _ProjectTask
        on _ProjectTask.TaskUUID = $projection.TaskUUID   
    association [1..1] to I_PPM_Project as _Root
        on _Root.ProjectUUID = $projection.ProjectUUID
//S4H 2002 Joint venture type field        

    association [1..1] to I_JointVentureMasterFld as jv on wbs.CompanyCode = jv.CompanyCode and            
                                                           wbs.JointVenture = jv.JointVenture    
{ 
key task.TaskUUID,
    task.WBSElementInternalID,
    task.ProjectUUID,
    task.IsProjectMilestone,
    task.ProjectInternalID,
    wbs.ControllingArea,
    wbs.ProfitCenter,
    wbs.JointVenture, 
    wbs.JointVentureCostRecoveryCode, 
    wbs.JointVentureEquityType, 
    wbs.JntVntrProjectType, 
    wbs.JntIntrstBillgClass, 
    wbs.JntIntrstBillgSubClass, 
//S4H 2002 Joint venture type field     

    jv.JointVentureType,
    @Consumption.hidden: true
    _AuthUser,
    @Consumption.hidden: true
    _AuthSubst,
    @Consumption.hidden: true
    _AuthRole,
    @Consumption.hidden: true
    _AuthGroup,
    
    _ProjectTask,    
    _Root,
    task._ProjObj,
    task._I_Project
    
}