I_JntOpgAgrmtProjSteppedRate

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_JntOpgAgrmtProjSteppedRate.
-- 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: IJOAPRSTEPRT

CREATE VIEW I_JntOpgAgrmtProjSteppedRate AS
SELECT
  bukrs AS CompanyCode,
  joa AS JntOpgAgrmt,
  seqnum AS JointVentureSequenceNumber,
  proj AS JointVentureWBSElementExtID,
  steptyp AS JntVntrProjLvlSteppedRateOvhd,
  xset AS JointVentureOvrrdeExclusionSet,
  ovrper AS JntVntrStepRateOvhdOvrrdePct,
  ovrrule AS JntVntrOvrrdeStepRateOvhdRule,
  xwbsflag AS JntVntrWBSElementIsExcluded
FROM t8j8d
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_JntVntrSteppedRateOvhdType AS _JntVntrSteppedRateOvhdType ON JntVntrProjLvlSteppedRateOvhd = _JntVntrSteppedRateOvhdType.JntVntrProjLvlSteppedRateOvhd  -- association [0..1]
LEFT OUTER JOIN I_JntVntrSteppedRateOvhdRule AS _JntVntrSteppedRateOvhdRule ON CompanyCode = _JntVntrSteppedRateOvhdRule.CompanyCode AND JntVntrOvrrdeStepRateOvhdRule = _JntVntrSteppedRateOvhdRule.JntVntrSteppedRateOvhdRule  -- association [0..1]
;