I_JntOpgAgrmtParentCoOvhd

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_JntOpgAgrmtParentCoOvhd.
-- 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: IJOAPARCOOVHD

CREATE VIEW I_JntOpgAgrmtParentCoOvhd AS
SELECT
  bukrs AS CompanyCode,
  joa AS JntOpgAgrmt,
  seqnum AS JointVentureSequenceNumber,
  wbsset AS JointVentureWBSElementSet,
  ccset AS JointVentureCostCenterSet,
  ordset AS JointVentureOrderSet,
  rule AS JntVntrSteppedRateOvhdRule,
  xset AS JVAExclsnAcctSetCptlOvhdCalc,
  netwset AS JointVentureNetworkSet
FROM t8j8j
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntOpgAgrmt AS _JntOpgAgrmt ON CompanyCode = _JntOpgAgrmt.CompanyCode AND JntOpgAgrmt = _JntOpgAgrmt.JntOpgAgrmt  -- association [0..1]
LEFT OUTER JOIN I_JntVntrSteppedRateOvhdRule AS _JntVntrSteppedRateOvhdRule ON CompanyCode = _JntVntrSteppedRateOvhdRule.CompanyCode AND JntVntrSteppedRateOvhdRule = _JntVntrSteppedRateOvhdRule.JntVntrSteppedRateOvhdRule  -- association [0..1]
;