C_EntProjWrkPckgDataJVATP

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 C_EntProjWrkPckgDataJVATP.
-- 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: CENTPRJWPDAJVA

CREATE VIEW C_EntProjWrkPckgDataJVATP AS
SELECT
  TaskUUID,
  ProjectUUID,
  WBSElementInternalID,
  JointVenture,
  _JointVentureText.JointVentureName AS JointVentureName,
  JointVentureCostRecoveryCode,
  _JntVntrCostRecoveryCodeText.JointVentureRecoveryCodeName AS JointVentureRecoveryCodeName,
  JointVentureEquityType,
  _JntVntrEquityTypeText.JointVentureEquityTypeName AS JointVentureEquityTypeName,
  JntVntrProjectType,
  _JntVntrProjectTypeText.JntVntrProjectTypeText AS JntVntrProjectTypeText,
  JntIntrstBillgClass,
  _JntIntrstBillgClassText.JntIntrstBillgClassText AS JntIntrstBillgClassText,
  JntIntrstBillgSubClass,
  _JntIntrstBillgSubclassText.JntIntrstBillgSubClassText AS JntIntrstBillgSubClassText,
  JointVentureType,
  _JntTypeText.JointVentureTypeText AS JointVentureTypeText,
  CompanyCode
FROM I_PPM_ProjectTaskJVATP
LEFT OUTER JOIN C_EnterpriseProjWrkPckgDataTP AS _Task ON TaskUUID = _Task.TaskUUID  -- association [1..1]
LEFT OUTER JOIN C_EnterpriseProjWrkPckgRootTP AS _Root ON ProjectUUID = _Root.ProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_JntVntrValueHelp AS _JointVentureVH ON JointVenture = _JointVentureVH.JointVenture AND CompanyCode = _JointVentureVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JointVentureDesc AS _JointVentureText ON JointVenture = _JointVentureText.JointVenture AND CompanyCode = _JointVentureText.CompanyCode AND _JointVentureText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JntVntrRecoveryIndVH AS _JntVntrCostRecoveryCodeVH ON JointVentureCostRecoveryCode = _JntVntrCostRecoveryCodeVH.JointVentureRecoveryCode AND CompanyCode = _JntVntrCostRecoveryCodeVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntVntrRecoveryIndText AS _JntVntrCostRecoveryCodeText ON JointVentureCostRecoveryCode = _JntVntrCostRecoveryCodeText.JointVentureRecoveryCode AND CompanyCode = _JntVntrCostRecoveryCodeText.CompanyCode AND _JntVntrCostRecoveryCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JntVntrEquityTypeVH AS _JntVntrEquityTypeVH ON JointVentureEquityType = _JntVntrEquityTypeVH.JointVentureEquityType AND CompanyCode = _JntVntrEquityTypeVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntVntrEquityTypeDesc AS _JntVntrEquityTypeText ON JointVentureEquityType = _JntVntrEquityTypeText.JointVentureEquityType AND CompanyCode = _JntVntrEquityTypeText.CompanyCode AND _JntVntrEquityTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JntVntrProjectTypeVH AS _JntVntrProjectTypeVH ON JntVntrProjectType = _JntVntrProjectTypeVH.JntVntrProjectType AND CompanyCode = _JntVntrProjectTypeVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntVntrProjectTypeText AS _JntVntrProjectTypeText ON JntVntrProjectType = _JntVntrProjectTypeText.JntVntrProjectType AND CompanyCode = _JntVntrProjectTypeText.CompanyCode AND _JntVntrProjectTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgClassVH AS _JntIntrstBillgClassVH ON JntIntrstBillgClass = _JntIntrstBillgClassVH.JntIntrstBillgClass AND CompanyCode = _JntIntrstBillgClassVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgClassText AS _JntIntrstBillgClassText ON JntIntrstBillgClass = _JntIntrstBillgClassText.JntIntrstBillgClass AND CompanyCode = _JntIntrstBillgClassText.CompanyCode AND _JntIntrstBillgClassText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgSubclassVH AS _JntIntrstBillgSubclassVH ON JntIntrstBillgSubClass = _JntIntrstBillgSubclassVH.JntIntrstBillgSubClass AND JntIntrstBillgClass = _JntIntrstBillgSubclassVH.JntIntrstBillgClass AND CompanyCode = _JntIntrstBillgSubclassVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgSubclassT AS _JntIntrstBillgSubclassText ON JntIntrstBillgSubClass = _JntIntrstBillgSubclassText.JntIntrstBillgSubClass AND JntIntrstBillgClass = _JntIntrstBillgSubclassText.JntIntrstBillgClass AND CompanyCode = _JntIntrstBillgSubclassText.CompanyCode AND _JntIntrstBillgSubclassText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JointVentureTypeText AS _JntTypeText ON JointVentureType = _JntTypeText.JointVentureType AND _JntTypeText.Language = $session.system_language  -- association [0..1]
;