C_JVACostAnalysisObjectPage

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_JVACostAnalysisObjectPage.
-- 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: CJVACOSTANLYSOPG

CREATE VIEW C_JVACostAnalysisObjectPage AS
SELECT
  CompanyCode,
  JointVenture,
  JntOpgAgrmtEquityGrp,
  FiscalYear,
  FiscalPeriod,
  JntOpgAgrmtEquityGrpText,
  JointVentureEquityGroupIsActv,
  JntVntrEquityGrpIsSuspended,
  JntVntrOperatedShare,
  JntVntrNonOperatedShare,
  JointVentureType
FROM I_JVAFiscalYrPerdForEquityGrp
LEFT OUTER JOIN C_JVAEquityGrpPartOwnrShrObjPg AS _PartnerShares ON _PartnerShares.CompanyCode = CompanyCode AND _PartnerShares.JointVenture = JointVenture AND _PartnerShares.JointVentureEquityGroup = JntOpgAgrmtEquityGrp  -- association [0..*]
LEFT OUTER JOIN C_JVAOperatorCostObjPg AS _OperatorCost ON _OperatorCost.CompanyCode = CompanyCode AND _OperatorCost.JointVenture = JointVenture AND _OperatorCost.JointVentureEquityGroup = JntOpgAgrmtEquityGrp AND _OperatorCost.FiscalPeriod = FiscalPeriod AND _OperatorCost.LedgerFiscalYear = FiscalYear AND ( _OperatorCost.JointVentureType = '1' OR _OperatorCost.JointVentureType = '3' OR _OperatorCost.JointVentureType = '4' )  -- association [0..*]
LEFT OUTER JOIN C_JVANonOperatorCostObjPg AS _NonOpCost ON _NonOpCost.CompanyCode = CompanyCode AND _NonOpCost.JointVenture = JointVenture AND _NonOpCost.JointVentureEquityGroup = JntOpgAgrmtEquityGrp AND _NonOpCost.FiscalPeriod = FiscalPeriod AND _NonOpCost.LedgerFiscalYear = FiscalYear AND _NonOpCost.JointVentureType = JointVentureType AND ( _NonOpCost.JointVentureType = '2' OR _NonOpCost.JointVentureType = '3' )  -- association [0..*]
LEFT OUTER JOIN C_JVANonOperatorCostObjPg AS _CorporateCost ON _CorporateCost.CompanyCode = CompanyCode AND _CorporateCost.JointVenture = JointVenture AND _CorporateCost.JointVentureEquityGroup = JntOpgAgrmtEquityGrp AND _CorporateCost.FiscalPeriod = FiscalPeriod AND _CorporateCost.LedgerFiscalYear = FiscalYear AND _CorporateCost.JointVentureType = JointVentureType AND _CorporateCost.JointVentureType = '5'  -- association [0..*]
LEFT OUTER JOIN C_JointVentureCompanyCodeVH AS _CompanyCodeVH ON _CompanyCodeVH.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_JointVentureValueHelp_2 AS _VentureVH ON _VentureVH.CompanyCode = CompanyCode AND _VentureVH.JointVenture = JointVenture  -- association [0..1]
LEFT OUTER JOIN I_JointVentureStatusText AS _StatusText ON _StatusText.JointVentureStatus = JointVentureEquityGroupIsActv  -- association [0..*]
;