R_PubSecSplitRuleDistrTP

DDL: R_PUBSECSPLITRULEDISTRTP SQL: SPLITRULEDISTRTP Type: view_entity TRANSACTIONAL Package: ODATA_PSM_S4C_AA_SPLIT
26 Fields 1 Data Sources 6 Associations

Distribution Rule - TP

R_PubSecSplitRuleDistrTP is a Transactional CDS View that provides data about "Distribution Rule - TP" in SAP S/4HANA. It reads from 1 data source (I_PubSecSplittingRuleDistr) and exposes 26 fields with key field PubSecSplitRuleSplitID. It has 6 associations to related views. Part of development package ODATA_PSM_S4C_AA_SPLIT.

Data Sources (1)

SourceAliasJoin Type
I_PubSecSplittingRuleDistr I_PubSecSplittingRuleDistr from

Associations (6)

CardinalityTargetAliasCondition
[1..*] I_PubSecSplitRuleDistrMethTxt _SplitDistrMethTxt $projection.PubSecSplitDistMethod = _SplitDistrMethTxt.PubSecSplitDistMethod
[1..*] I_FundText _FundText _FundText.FinancialManagementArea = 'A000' and $projection.Fund = _FundText.Fund
[1..*] I_GrantText _GrantText $projection.GrantID = _GrantText.GrantID
[1..*] I_FunctionalAreaText _FunctionalAreaText $projection.FunctionalArea = _FunctionalAreaText.FunctionalArea
[0..1] I_UserAddress _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_UserAddress _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Distribution Rule - TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name PublicSectorDistributionRule view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY PubSecSplitRuleSplitID PubSecSplitRuleSplitID WM Split Number
PubSecSplitRule PubSecSplitRule Distrib. Rule
PubSecSplitAllocBlock PubSecSplitAllocBlock Alloc. Block
PubSecSplitSequenceNumber PubSecSplitSequenceNumber Sequence No.
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
PubSecSplitDistMethod PubSecSplitDistMethod Distrib.Method
PubSecSplitDistrPercent PubSecSplitDistrPercent Percentage
PubSecSplitDistrCurrency PubSecSplitDistrCurrency Valuation Crcy
PubSecSplitDistrAmount PubSecSplitDistrAmount Amount
PubSecSplitIsFinalSplit PubSecSplitIsFinalSplit Final Dist.
Fund Fund Sender Fund
GrantID GrantID Sender Grant
FunctionalArea FunctionalArea Sendr Fctl Area
PubSecIsOvrrdeAllowedFctAr PubSecIsOvrrdeAllowedFctAr Override Farea
PubSecIsOverrideAllowedFund PubSecIsOverrideAllowedFund Override Fund
PubSecIsOverrideAllowedGrantID PubSecIsOverrideAllowedGrantID Override Grant
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
_SplitDistrMethTxt _SplitDistrMethTxt
_SplitRule _SplitRule
_FunctionalAreaText _FunctionalAreaText
_FundText _FundText
_GrantText _GrantText
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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 _FundText.FinancialManagementArea = 'A000' 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..*]
LEFT OUTER JOIN I_UserAddress AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_UserAddress AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;

Learn More