I_IncgFrmtType

DDL: I_INCGFRMTTYPE Type: view_entity BASIC
6 Fields 1 Data Sources 4 Associations

Incoming Format Type

I_IncgFrmtType is a Basic CDS View that provides data about "Incoming Format Type" in SAP S/4HANA. It reads from 1 data source (ifmefmttype) and exposes 6 fields with key field HierarchyTreeType. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ifmefmttype ifmefmttype from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_IncgFrmt _Format _Format.HierarchyTreeType = $projection.HierarchyTreeType
[0..*] I_IncgFrmtCust _CustomerFormat _CustomerFormat.HierarchyTreeType = $projection.HierarchyTreeType
[0..1] I_IncgFrmtTypeText _FormatTypeText _FormatTypeText.Language = $session.system_language and _FormatTypeText.HierarchyTreeType = $projection.HierarchyTreeType
[0..1] I_IncgFrmtTypeText _FormatTypeDefaultText _FormatTypeDefaultText.Language = 'E' and _FormatTypeDefaultText.HierarchyTreeType = $projection.HierarchyTreeType

Annotations (6)

NameValueLevelField
EndUserText.label Incoming Format Type view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY HierarchyTreeType hierarchytreetype Mapping Type ID
OutputStructureName outputstructurename Output Structure Name
_Format _Format
_CustomerFormat _CustomerFormat
_FormatTypeText _FormatTypeText
_FormatTypeDefaultText _FormatTypeDefaultText

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_IncgFrmtType.
-- 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 I_IncgFrmtType AS
SELECT
  HierarchyTreeType,
  OutputStructureName
FROM ifmefmttype
LEFT OUTER JOIN I_IncgFrmt AS _Format ON _Format.HierarchyTreeType = HierarchyTreeType  -- association [0..*]
LEFT OUTER JOIN I_IncgFrmtCust AS _CustomerFormat ON _CustomerFormat.HierarchyTreeType = HierarchyTreeType  -- association [0..*]
LEFT OUTER JOIN I_IncgFrmtTypeText AS _FormatTypeText ON _FormatTypeText.Language = $session.system_language AND _FormatTypeText.HierarchyTreeType = HierarchyTreeType  -- association [0..1]
LEFT OUTER JOIN I_IncgFrmtTypeText AS _FormatTypeDefaultText ON _FormatTypeDefaultText.Language = 'E' AND _FormatTypeDefaultText.HierarchyTreeType = HierarchyTreeType  -- association [0..1]
;

Learn More