I_RECndnDistributionRuleExt

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_RECndnDistributionRuleExt.
-- 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: IREDISTRULEEXT

CREATE VIEW I_RECndnDistributionRuleExt AS
SELECT
  distruleext AS REDistributionRule,
  distruleint AS REInternalDistributionRule,
  distrulepara1 AS REDistributionRuleParam1,
  distrulepamocu1 AS RERuleFieldModifSttg1,
  distrulepamoap1 AS RERuleFieldModifAppl1,
  distrulepara2 AS REDistributionRuleParam2,
  distrulepamocu2 AS RERuleFieldModifSttg2,
  distrulepamoap2 AS RERuleFieldModifAppl2,
  objtypedist AS REObjectTypeDistribution,
  objtypepost AS REObjectTypePosting,
  distrulemod AS REDistributionIsModifiable,
  directdist AS REDirectDistributionIsActive,
  chdicompleteness AS REDistributionIsChecked,
  distcomplete AS REFullDistributionRule
FROM tivcddistext
LEFT OUTER JOIN I_RECndnDistrRuleExtText AS _Text ON REDistributionRule = _Text.REDistributionRule  -- association [0..*]
LEFT OUTER JOIN I_RECndnDistributionRuleInt AS _RECndnDistributionRuleInt ON REInternalDistributionRule = _RECndnDistributionRuleInt.REInternalDistributionRule  -- 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_REObjectTypeDistribution AS _REObjectTypeDistribution ON REObjectTypeDistribution = _REObjectTypeDistribution.REObjectTypeDistribution  -- association [0..1]
LEFT OUTER JOIN I_REObjectTypePosting AS _REObjectTypePosting ON REObjectTypePosting = _REObjectTypePosting.REObjectTypePosting  -- association [0..1]
LEFT OUTER JOIN I_REFullDistributionRule AS _REFullDistributionRule ON REFullDistributionRule = _REFullDistributionRule.REFullDistributionRule  -- association [0..1]
;