I_SetHeader

DDL: I_SETHEADER SQL: ISETHEADER Type: view BASIC
20 Fields 1 Data Sources 3 Associations

Set Header

I_SetHeader is a Basic CDS View that provides data about "Set Header" in SAP S/4HANA. It reads from 1 data source (setheader) and exposes 20 fields with key fields SetClass, SetSubClass, SetID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
setheader setheader from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SetClass _SetClass $projection.SetClass = _SetClass.SetClass
[0..1] I_SetSubClass _SetSubClass $projection.SetSubClass = _SetSubClass.SetSubClass
[0..*] I_SetHeaderText _SetHeaderText $projection.SetClass = _SetHeaderText.SetClass and $projection.SetSubClass = _SetHeaderText.SetSubClass and $projection.SetID = _SetHeaderText.SetID

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISETHEADER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Set Header view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey SetID view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SetClass setheader setclass Set Class
KEY SetSubClass setheader subclass Subclass
KEY SetID setheader setname Set Name
SetType setheader settype Set Type
IsDynamic setheader xdynamic Dynamic Set
IsUnique setheader xuniq Specific Account?
SetRepresentativeValue setheader rvalue Repres. Value
CreatedByUser setheader creuser Sett.Doc.Creat.
CreationDate setheader credate Settlement Date
CreationTime setheader cretime Time
LastChangedByUser setheader upduser Changed By
LastChangedDate setheader upddate Current Date
LastChangeTime setheader updtime Updated At
DatabaseTable setheader tabname Table/Constant Value
DatabaseTableField setheader fieldname UI Group FieldName
SetRepresentativeDataElement setheader rollname Repr. Data Elem
MasterLanguage setheader set_olangu Original Lang.
_SetClass _SetClass
_SetSubClass _SetSubClass
_SetHeaderText _SetHeaderText

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_SetHeader.
-- 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: ISETHEADER

CREATE VIEW I_SetHeader AS
SELECT
  setheader.setclass AS SetClass,
  setheader.subclass AS SetSubClass,
  setheader.setname AS SetID,
  setheader.settype AS SetType,
  setheader.xdynamic AS IsDynamic,
  setheader.xuniq AS IsUnique,
  setheader.rvalue AS SetRepresentativeValue,
  setheader.creuser AS CreatedByUser,
  setheader.credate AS CreationDate,
  setheader.cretime AS CreationTime,
  setheader.upduser AS LastChangedByUser,
  setheader.upddate AS LastChangedDate,
  setheader.updtime AS LastChangeTime,
  setheader.tabname AS DatabaseTable,
  setheader.fieldname AS DatabaseTableField,
  setheader.rollname AS SetRepresentativeDataElement,
  setheader.set_olangu AS MasterLanguage
FROM setheader
LEFT OUTER JOIN I_SetClass AS _SetClass ON SetClass = _SetClass.SetClass  -- association [0..1]
LEFT OUTER JOIN I_SetSubClass AS _SetSubClass ON SetSubClass = _SetSubClass.SetSubClass  -- association [0..1]
LEFT OUTER JOIN I_SetHeaderText AS _SetHeaderText ON SetClass = _SetHeaderText.SetClass AND SetSubClass = _SetHeaderText.SetSubClass AND SetID = _SetHeaderText.SetID  -- association [0..*]
;

Learn More