C_PubSecSplittingRuleDistrTP

DDL: C_PUBSECSPLITTINGRULEDISTRTP Type: view_entity CONSUMPTION
23 Fields 1 Data Sources

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 23 fields with key field PubSecSplitRuleSplitID.

Data Sources (1)

SourceAliasJoin Type
R_PubSecSplitRuleDistrTP R_PubSecSplitRuleDistrTP projection

Annotations (7)

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

Fields (23)

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
PubSecIsOverrideAllowedFund PubSecIsOverrideAllowedFund
PubSecIsOverrideAllowedGrantID PubSecIsOverrideAllowedGrantID
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User 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,
  LastChangedByUser
FROM R_PubSecSplitRuleDistrTP
;

Learn More