I_PubSecSplittingRuleDistr

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_PubSecSplittingRuleDistr.
-- 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: ISPLITRULEDIST

CREATE VIEW I_PubSecSplittingRuleDistr AS
SELECT
  psm_split_distr.split_id AS PubSecSplitRuleSplitID,
  psm_split_distr.split_rule AS PubSecSplitRule,
  psm_split_distr.alloc_block AS PubSecSplitAllocBlock,
  psm_split_distr.sequence_nbr AS PubSecSplitSequenceNumber,
  psm_split_distr.from_date AS ValidityStartDate,
  psm_split_distr.to_date AS ValidityEndDate,
  psm_split_distr.dist_method AS PubSecSplitDistMethod,
  psm_split_distr.dist_percent AS PubSecSplitDistrPercent,
  psm_split_distr.currency AS PubSecSplitDistrCurrency,
  psm_split_distr.dist_amount AS PubSecSplitDistrAmount,
  psm_split_distr.final_split AS PubSecSplitIsFinalSplit,
  psm_split_distr.fund AS Fund,
  psm_split_distr.grantnbr AS GrantID,
  psm_split_distr.functionalarea AS FunctionalArea,
  psm_split_distr.isovrrdeallowedfctar AS PubSecIsOvrrdeAllowedFctAr,
  psm_split_distr.isoverrideallowedfund AS PubSecIsOverrideAllowedFund,
  psm_split_distr.isoverrideallowedgrantid AS PubSecIsOverrideAllowedGrantID,
  psm_split_distr.created_by AS CreatedByUser,
  psm_split_distr.created_on AS CreationDate,
  psm_split_distr.modified_by AS LastChangedByUser,
  psm_split_distr.modified_on AS LastChangeDate
FROM psm_split_distr
;