fac_cds_fh_hier_type

DDL: FAC_CDS_FH_HIER_TYPE SQL: FACV_FH_HRYTYPE Type: view
2 Fields 1 Data Sources

Flexible Hierarchy Type

fac_cds_fh_hier_type is a CDS View that provides data about "Flexible Hierarchy Type" in SAP S/4HANA. It reads from 1 data source (HRRPI_HIERARCHYTYPE) and exposes 2 fields with key field HierarchyType.

Data Sources (1)

SourceAliasJoin Type
HRRPI_HIERARCHYTYPE HRRPI_HIERARCHYTYPE from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FACV_FH_HRYTYPE view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Flexible Hierarchy Type view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY HierarchyType HRRPI_HIERARCHYTYPE HierarchyType Hierarchy Type
HierarchyTypeName

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 fac_cds_fh_hier_type.
-- 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: FACV_FH_HRYTYPE

CREATE VIEW fac_cds_fh_hier_type AS
SELECT
  HRRPI_HIERARCHYTYPE.HierarchyType AS HierarchyType,
  HRRPI_HIERARCHYTYPE._Text[1:Language = $session.system_language].HierarchyTypeName AS HierarchyTypeName
FROM HRRPI_HIERARCHYTYPE
;

Learn More