R_PubSecSplitRuleDistrTP

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_PubSecSplitRuleDistrTP.
-- 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: SPLITRULEDISTRTP

CREATE VIEW R_PubSecSplitRuleDistrTP AS
SELECT
  PubSecSplitRuleSplitID,
  PubSecSplitRule,
  PubSecSplitAllocBlock,
  PubSecSplitSequenceNumber,
  ValidityStartDate,
  ValidityEndDate,
  PubSecSplitDistMethod,
  PubSecSplitDistrPercent,
  PubSecSplitDistrCurrency,
  PubSecSplitDistrAmount,
  PubSecSplitIsFinalSplit,
  Fund,
  GrantID,
  FunctionalArea,
  PubSecIsOvrrdeAllowedFctAr,
  PubSecIsOverrideAllowedFund,
  PubSecIsOverrideAllowedGrantID,
  CreatedByUser,
  LastChangedByUser
FROM I_PubSecSplittingRuleDistr
LEFT OUTER JOIN I_PubSecSplitRuleDistrMethTxt AS _SplitDistrMethTxt ON PubSecSplitDistMethod = _SplitDistrMethTxt.PubSecSplitDistMethod  -- association [1..*]
LEFT OUTER JOIN I_FundText AS _FundText ON FunctionalArea = _FundText.FinancialManagementArea AND Fund = _FundText.Fund  -- association [1..*]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID  -- association [1..*]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [1..*]
;