I_PubSecSplitRuleFldName

DDL: I_PUBSECSPLITRULEFLDNAME SQL: ISPLITFLDNAME Type: view BASIC Package: ODATA_PSM_S4C_AA_SPLIT
3 Fields 1 Data Sources 1 Associations

Field Names for Distribution Rule

I_PubSecSplitRuleFldName is a Basic CDS View that provides data about "Field Names for Distribution Rule" in SAP S/4HANA. It reads from 1 data source (fmsplit_fprof_f) and exposes 3 fields with key fields PubSecSplitRuleFieldProfID, PubSecSplitFieldName. It has 1 association to related views. Part of development package ODATA_PSM_S4C_AA_SPLIT.

Data Sources (1)

SourceAliasJoin Type
fmsplit_fprof_f fmsplit_fprof_f from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PubSecSplitRuleFldNameText _Text $projection.PubSecSplitFieldName = _Text.PubSecSplitFieldName and _Text.Language = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISPLITFLDNAME view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Field Names for Distribution Rule view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey PubSecSplitFieldName view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.resultSet.sizeCategory #XS view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PubSecSplitRuleFieldProfID fprof_id Field Profile
KEY PubSecSplitFieldName fieldname UI Group FieldName
_Text _Text

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_PubSecSplitRuleFldName.
-- 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: ISPLITFLDNAME

CREATE VIEW I_PubSecSplitRuleFldName AS
SELECT
  fprof_id AS PubSecSplitRuleFieldProfID,
  fieldname AS PubSecSplitFieldName
FROM fmsplit_fprof_f
LEFT OUTER JOIN I_PubSecSplitRuleFldNameText AS _Text ON PubSecSplitFieldName = _Text.PubSecSplitFieldName AND _Text.Language = $session.system_language  -- association [1..1]
;

Learn More