I_RECndnCalculationRuleExt

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_RECndnCalculationRuleExt.
-- 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: IRECALCRULEEXT

CREATE VIEW I_RECndnCalculationRuleExt AS
SELECT
  calcruleext AS RECalculationRule,
  calcruleint AS REInternalCalculationRule,
  calcrulepara1 AS RECalculationRuleParam1,
  calcrulepamocu1 AS RERuleFieldModifSttg1,
  calcrulepamoap1 AS RERuleFieldModifAppl1,
  calcrulepara2 AS RECalculationRuleParam2,
  calcrulepamocu2 AS RERuleFieldModifSttg2,
  calcrulepamoap2 AS RERuleFieldModifAppl2,
  calcrulenodist AS REDistributionIsIndependent,
  distruleext AS REDistributionRule,
  calcrulemod AS RECalculationRuleIsModifiable,
  roundtype AS REUnitPriceRoundingType,
  rounddecimal AS REUnitPriceNmbrOfDcmlsToRound,
  roundunit AS REUnitPriceRoundingThreshold,
  caroundtype AS RECndnAmountRoundingType,
  carounddecimal AS RECndnAmountNmbrOfDcmlsToRound,
  caroundunit AS RECndnAmountRoundingThreshold,
  caroundgrne AS REGrossOrNetRounding,
  distcomplete AS REFullDistributionRule
FROM tivcdcalcext
LEFT OUTER JOIN I_RECndnCalcRuleExtText AS _Text ON RECalculationRule = _Text.RECalculationRule  -- association [0..*]
LEFT OUTER JOIN I_RECndnCalculationRuleInt AS _RECndnCalculationRuleInt ON REInternalCalculationRule = _RECndnCalculationRuleInt.REInternalCalculationRule  -- association [0..1]
LEFT OUTER JOIN I_RERuleFieldModifSttg1 AS _RERuleFieldModifSttg1 ON RERuleFieldModifSttg1 = _RERuleFieldModifSttg1.RERuleFieldModifSttg1  -- association [0..1]
LEFT OUTER JOIN I_RERuleFieldModifSttg2 AS _RERuleFieldModifSttg2 ON RERuleFieldModifSttg2 = _RERuleFieldModifSttg2.RERuleFieldModifSttg2  -- association [0..1]
LEFT OUTER JOIN I_RERuleFieldModifAppl1 AS _RERuleFieldModifAppl1 ON RERuleFieldModifAppl1 = _RERuleFieldModifAppl1.RERuleFieldModifAppl1  -- association [0..1]
LEFT OUTER JOIN I_RERuleFieldModifAppl2 AS _RERuleFieldModifAppl2 ON RERuleFieldModifAppl2 = _RERuleFieldModifAppl2.RERuleFieldModifAppl2  -- association [0..1]
LEFT OUTER JOIN I_RECndnDistributionRuleExt AS _RECndnDistributionRuleExt ON REDistributionRule = _RECndnDistributionRuleExt.REDistributionRule  -- association [0..1]
LEFT OUTER JOIN I_RERoundingTypeForUnitPrc AS _RERoundingTypeForUnitPrc ON REUnitPriceRoundingType = _RERoundingTypeForUnitPrc.REUnitPriceRoundingType  -- association [0..1]
LEFT OUTER JOIN I_RERoundingTypeForCndnAmt AS _RERoundingTypeForCndnAmt ON RECndnAmountRoundingType = _RERoundingTypeForCndnAmt.RECndnAmountRoundingType  -- association [0..1]
LEFT OUTER JOIN I_REGrossOrNetRounding AS _REGrossOrNetRounding ON REGrossOrNetRounding = _REGrossOrNetRounding.REGrossOrNetRounding  -- association [0..1]
LEFT OUTER JOIN I_REFullDistributionRule AS _REFullDistributionRule ON REFullDistributionRule = _REFullDistributionRule.REFullDistributionRule  -- association [0..1]
;