R_PubSecSplittingRuleTP

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 R_PubSecSplittingRuleTP.
-- 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.

CREATE VIEW R_PubSecSplittingRuleTP AS
SELECT
  PubSecSplitRule,
  PubSecSplitRuleGroupID,
  PubSecSplitRuleStatus,
  _StatusText[1:Language =$session.system_language].PubSecSplitRuleStatusText AS PubSecSplitRuleStatusText,
  _SplittingGroup.PubSecSplitRuleGroupAuthznGrp AS PubSecSplitRuleGroupAuthznGrp,
  PubSecSplitRuleFieldProfID,
  PubSecSplitRuleActionProfID,
  PubSecSplitRuleType,
  PubSecSplitBindingType,
  PubSecSplitRuleRemainderType,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate
FROM I_PubSecSplittingRule AS iSplitRule
LEFT OUTER JOIN I_PubSecSplittingGroup AS _SplittingGroup ON PubSecSplitRuleGroupID = _SplittingGroup.PubSecSplitRuleGroupID  -- association [1..1]
LEFT OUTER JOIN I_PubSecSplitRuleActnPrflTxt AS _ActionProfileText ON PubSecSplitRuleActionProfID = _ActionProfileText.PubSecSplitRuleActionProfID  -- association [1..*]
LEFT OUTER JOIN I_PubSecSplitRuleFldProfileTxt AS _FieldProfileText ON PubSecSplitRuleFieldProfID = _FieldProfileText.PubSecSplitRuleFieldProfID  -- association [1..*]
LEFT OUTER JOIN I_PubSecSplitRuleBindgTypeTxt AS _RuleBindingTypeText ON PubSecSplitBindingType = _RuleBindingTypeText.PubSecSplitBindingType  -- association [1..*]
LEFT OUTER JOIN I_PubSecSplitRuleRmndrTypeText AS _RemainderTypeText ON PubSecSplitRuleRemainderType = _RemainderTypeText.PubSecSplitRuleRemainderType  -- association [1..*]
LEFT OUTER JOIN I_PubSecSplitRuleStatusText AS _StatusText ON PubSecSplitRuleStatus = _StatusText.PubSecSplitRuleStatus  -- association [1..*]
LEFT OUTER JOIN I_PubSecSplitRuleTypeTxt AS _SplitRuleTypeText ON PubSecSplitRuleType = _SplitRuleTypeText.PubSecSplitRuleType  -- association [1..*]
LEFT OUTER JOIN I_PubSecSplitRuleRmndrTypeText AS _RemainderText ON PubSecSplitRuleRemainderType = _RemainderText.PubSecSplitRuleRemainderType  -- association [1..*]
LEFT OUTER JOIN I_PubSecSplittingGroupText AS _GroupText ON PubSecSplitRuleGroupID = _GroupText.PubSecSplitRuleGroupID  -- association [1..*]
LEFT OUTER JOIN R_PubSecSplitRuleDistrTP AS _SplittingRuleDistribution ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_PubSecSplittingRuleT AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
;