I_JVAFiscalYrPerdForEquityGrp

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_JVAFiscalYrPerdForEquityGrp.
-- 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: IFSCLYRPERD

CREATE VIEW I_JVAFiscalYrPerdForEquityGrp AS
SELECT
  _JntVntrEquityGrp.CompanyCode AS CompanyCode,
  _JntVntrEquityGrp.JointVenture AS JointVenture,
  _JntVntrEquityGrp.JntOpgAgrmtEquityGrp AS JntOpgAgrmtEquityGrp,
  _FiscalYrPerd.FiscalYear AS FiscalYear,
  _FiscalYrPerd.FiscalPeriod AS FiscalPeriod,
  _JntVntrValidEquityGroupFld.JointVentureEquityType AS JointVentureEquityType,
  JntOpgAgrmtEquityGrpText,
  JointVentureType,
  JntVntrEquityGrpIsSuspended,
  cast( _JntVntrValidEquityGroupFld.JointVentureEquityGroupIsActv as jv_process_cds preserving type ) AS JointVentureEquityGroupIsActv,
  JntVntrOperatedShare,
  JntVntrNonOperatedShare,
  _JntVntrEquityGrp._CompanyCode AS _CompanyCode,
  _JntVntrEquityGrp._JointVentureMasterFld AS _JointVentureMasterFld
FROM I_JointVentureMasterFld AS _JVMaster
INNER JOIN I_JntVntrEquityGrp AS _JntVntrEquityGrp ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalYrPerd ON /* join condition not captured in parsed metadata */
INNER JOIN I_JntVntrValidEquityGroupFld AS _JntVntrValidEquityGroupFld ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JointVentureStatusText AS _JointVentureStatusText ON JointVentureEquityGroupIsActv = _JointVentureStatusText.JointVentureStatus  -- association [0..*]
;