I_PPM_ProjectTaskJVATP

DDL: I_PPM_PROJECTTASKJVATP SQL: IPPMPRJTASKJVATP Type: view COMPOSITE
19 Fields 1 Data Sources 2 Associations

Extension fields for Joint Venture Accounting on Task level

I_PPM_ProjectTaskJVATP 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 1 data source (I_PPM_ProjectTaskJVA) and exposes 19 fields with key field TaskUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PPM_ProjectTaskJVA task from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PPM_ProjectTaskTP _ProjectTask _ProjectTask.TaskUUID = $projection.TaskUUID
[1..1] I_PPM_ProjectTP _Root $projection.ProjectUUID = _Root.ProjectUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IPPMPRJTASKJVATP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.writeDraftPersistence PPM_PRO_TSKJVA_D view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL 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 (19)

KeyFieldSource TableSource FieldDescription
KEY TaskUUID TaskUUID
WBSElementInternalID WBSElementInternalID WBS Internal ID
ProjectUUID ProjectUUID Project UUID
ControllingArea ControllingArea Controlling Area
ProfitCenter ProfitCenter Profit Center
CompanyCode _ProjectTask CompanyCode Receiver Company Code
JointVenture JointVenture Joint venture
JointVentureCostRecoveryCode JointVentureCostRecoveryCode Recovery Ind.
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
JntVntrProjectType JntVntrProjectType JV Object Type
JntIntrstBillgClass JntIntrstBillgClass JIB/JIBE Class
JntIntrstBillgSubClass JntIntrstBillgSubClass JIB/JIBE SbClsA
JointVentureType JointVentureType Venture Type
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup
_ProjectTask _ProjectTask
_Root _Root

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PPM_ProjectTaskJVATP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPPMPRJTASKJVATP

CREATE VIEW I_PPM_ProjectTaskJVATP AS
SELECT
  TaskUUID,
  WBSElementInternalID,
  ProjectUUID,
  ControllingArea,
  ProfitCenter,
  _ProjectTask.CompanyCode AS CompanyCode,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityType,
  JntVntrProjectType,
  JntIntrstBillgClass,
  JntIntrstBillgSubClass,
  JointVentureType
FROM I_PPM_ProjectTaskJVA AS task
LEFT OUTER JOIN I_PPM_ProjectTaskTP AS _ProjectTask ON _ProjectTask.TaskUUID = TaskUUID  -- association [1..1]
LEFT OUTER JOIN I_PPM_ProjectTP AS _Root ON ProjectUUID = _Root.ProjectUUID  -- association [1..1]
;

Learn More