C_PubSecSplittingRuleDistrTP

DDL: C_PUBSECSPLITTINGRULEDISTRTP Type: view_entity CONSUMPTION Package: ODATA_PSM_S4C_AA_SPLIT

Distribution Rule

C_PubSecSplittingRuleDistrTP is a Consumption CDS View that provides data about "Distribution Rule" in SAP S/4HANA. It reads from 1 data source (R_PubSecSplitRuleDistrTP) and exposes 25 fields with key field PubSecSplitRuleSplitID. It is exposed through 2 OData services (ASQL_F5600, UI_SPLITTINGRULE_MANAGE). It is used in 1 Fiori application: Manage Automatic Account Distribution Rule. Part of development package ODATA_PSM_S4C_AA_SPLIT.

Data Sources (1)

SourceAliasJoin Type
R_PubSecSplitRuleDistrTP R_PubSecSplitRuleDistrTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Distribution Rule view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F5600 ASQL_F5600 C2 NOT_RELEASED
UI_SPLITTINGRULE_MANAGE UI_SPLITTINGRULE_MANAGE V4 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5600 Manage Automatic Account Distribution Rule Transactional Manage automatic account assignment distribution rule

Manage Automatic Account Distribution Rule

Business Role: Budget Specialist - Funds Management

With this app, you can create rules how budget consumption is distributed into multiple lines with different account assignments for multi-funded projects. The distribution rules are automatically performed when a purchase requisition is created for a project. Note The automatic account assignment distribution for Asset Accounting is not performed. Distribution rules are applicable for Public Sector Budget Management and Grantee Management using the business roles Budget Specialist (SAP_BR_BUDGET_SPECIALIST) and Grant Specialist (SAP_BR_GRANT_SPECIALIST).

Key Features: Creation, deletion and activation of distribution rules. Determination of rules for the usage in PSM Budget Management or cost sharing in Grantee Management. Selection of affected fund and grant account assignments and their validity period Definition of the distribution method Definition of binding rules and remainder handling

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY PubSecSplitRuleSplitID PubSecSplitRuleSplitID
virtualFundIsHiddenabap_boolean
virtualGrantIsHiddenabap_boolean
PubSecSplitRule PubSecSplitRule
PubSecSplitAllocBlock PubSecSplitAllocBlock
PubSecSplitSequenceNumber PubSecSplitSequenceNumber
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
PubSecSplitDistMethod PubSecSplitDistMethod
PubSecSplitDistrPercent PubSecSplitDistrPercent
PubSecSplitDistrCurrency PubSecSplitDistrCurrency
PubSecSplitDistrAmount PubSecSplitDistrAmount
PubSecSplitIsFinalSplit PubSecSplitIsFinalSplit
Fund Fund Sender Fund
GrantID GrantID Sender Grant
FunctionalArea FunctionalArea Sendr Fctl Area
FundNameasFundNamelocalized
GrantNameasGrantNamelocalized
PubSecIsOvrrdeAllowedFctAr PubSecIsOvrrdeAllowedFctAr Override Functional Area
PubSecIsOverrideAllowedFund PubSecIsOverrideAllowedFund
PubSecIsOverrideAllowedGrantID PubSecIsOverrideAllowedGrantID
CreatedByUser CreatedByUser User Name
CreatedByUserName _CreatedByUser UserDescription Full Name
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName _LastChangedByUser UserDescription Full Name

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 C_PubSecSplittingRuleDistrTP.
-- 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 C_PubSecSplittingRuleDistrTP AS
SELECT
  PubSecSplitRuleSplitID,
  virtual FundIsHidden : abap_boolean AS virtualFundIsHiddenabap_boolean,
  virtual GrantIsHidden : abap_boolean AS virtualGrantIsHiddenabap_boolean,
  PubSecSplitRule,
  PubSecSplitAllocBlock,
  PubSecSplitSequenceNumber,
  ValidityStartDate,
  ValidityEndDate,
  PubSecSplitDistMethod,
  PubSecSplitDistrPercent,
  PubSecSplitDistrCurrency,
  PubSecSplitDistrAmount,
  PubSecSplitIsFinalSplit,
  Fund,
  GrantID,
  FunctionalArea,
  _FundText.FundName as FundName : localized AS FundNameasFundNamelocalized,
  _GrantText.GrantName as GrantName : localized AS GrantNameasGrantNamelocalized,
  PubSecIsOvrrdeAllowedFctAr,
  PubSecIsOverrideAllowedFund,
  PubSecIsOverrideAllowedGrantID,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS LastChangedByUserName
FROM R_PubSecSplitRuleDistrTP
;