C_JntVntrEquityGrpDetailObjPg

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_JntVntrEquityGrpDetailObjPg.
-- 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: CJVEQGRPDETOBJPG

CREATE VIEW C_JntVntrEquityGrpDetailObjPg AS
SELECT
  CompanyCode,
  JointVenture,
  JntOpgAgrmtEquityGrp,
  cast( JntOpgAgrmtEquityGrpText as jv_egtxt_cds preserving type ) AS JntOpgAgrmtEquityGrpText,
  JntVntrOperatedShare,
  JntVntrNonOperatedShare,
  I_JntVntrEquityGrp.JntVntrEquityGrpIsSuspended AS JntVntrEquityGrpIsSuspended,
  JntVntrEquityGrpSuspendedPerd,
  JntVntrEquityGrpSuspendedYr,
  JntVntrEquityGrpIsNotSuspended,
  JntVntrGrpNotSuspendedPerd,
  JntVntrGrpNotSuspendedYr,
  JntVntrNetProfitIntrstGrp
FROM I_JntVntrEquityGrp
LEFT OUTER JOIN C_JntVntrPartOwnrEquityShr AS _PartOwnShare ON CompanyCode = _PartOwnShare.CompanyCode AND JointVenture = _PartOwnShare.JointVenture AND JntOpgAgrmtEquityGrp = _PartOwnShare.JntOpgAgrmtEquityGrp  -- association [0..*]
LEFT OUTER JOIN C_JointVentureIntcoVenture AS _JointVentureIntcoVenture ON CompanyCode = _JointVentureIntcoVenture.CompanyCode AND JointVenture = _JointVentureIntcoVenture.JointVenture AND JntOpgAgrmtEquityGrp = _JointVentureIntcoVenture.JointVentureEquityGroup  -- association [0..*]
LEFT OUTER JOIN C_JntVntrSubstituteCostObject AS _JntVntrSubstituteCostObject ON CompanyCode = _JntVntrSubstituteCostObject.CompanyCode AND JointVenture = _JntVntrSubstituteCostObject.JointVenture AND JntOpgAgrmtEquityGrp = _JntVntrSubstituteCostObject.JointVentureEquityGroup  -- association [0..*]
LEFT OUTER JOIN C_JntVntrFundCrcyByEquityGrp AS _JntVntrFundCrcyByEquityGrp ON CompanyCode = _JntVntrFundCrcyByEquityGrp.CompanyCode AND JointVenture = _JntVntrFundCrcyByEquityGrp.JointVenture AND JntOpgAgrmtEquityGrp = _JntVntrFundCrcyByEquityGrp.JointVentureEquityGroup  -- association [0..*]
LEFT OUTER JOIN C_JointVentureObjPg AS _JointVentureObjPg ON CompanyCode = _JointVentureObjPg.CompanyCode AND JointVenture = _JointVentureObjPg.JointVenture  -- association [1..1]
LEFT OUTER JOIN C_JVACarriedInterest AS _JVACarriedInterest ON CompanyCode = _JVACarriedInterest.CompanyCode AND JointVenture = _JVACarriedInterest.JointVenture AND JntOpgAgrmtEquityGrp = _JVACarriedInterest.JointVentureEquityGroup  -- association [0..*]
;