FAC_CDS_UH_REUSE_FH_CD

DDL: FAC_CDS_UH_REUSE_FH_CD SQL: FACV_UHRUFHCDH Type: view
7 Fields 1 Data Sources

Flexible Cost Center Hierarchy

FAC_CDS_UH_REUSE_FH_CD is a CDS View that provides data about "Flexible Cost Center Hierarchy" in SAP S/4HANA. It reads from 1 data source (fac_cds_fh) and exposes 7 fields with key field FlexibleHierarchy.

Data Sources (1)

SourceAliasJoin Type
fac_cds_fh fh from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FACV_UHRUFHCDH view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Flexible Cost Center Hierarchy view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FlexibleHierarchy fac_cds_fh FlexibleHierarchy Hierarchy ID
HierarchyShortID fac_cds_fh HierarchyShortID Hierarchy ID
FlexibleHierarchyName fac_cds_fh FlexibleHierarchyName
ValidityStartDate fac_cds_fh ValidityStartDate Validity Start Date
ValidityEndDate fac_cds_fh ValidityEndDate ValidTo
HierarchyType fac_cds_fh HierarchyType Hierarchy Type
HierarchyTypeText fac_cds_fh HierarchyTypeText User Group

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_UH_REUSE_FH_CD.
-- 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_UHRUFHCDH

CREATE VIEW FAC_CDS_UH_REUSE_FH_CD AS
SELECT
  fh.FlexibleHierarchy AS FlexibleHierarchy,
  fh.HierarchyShortID AS HierarchyShortID,
  fh.FlexibleHierarchyName AS FlexibleHierarchyName,
  fh.ValidityStartDate AS ValidityStartDate,
  fh.ValidityEndDate AS ValidityEndDate,
  fh.HierarchyType AS HierarchyType,
  fh.HierarchyTypeText AS HierarchyTypeText
FROM fac_cds_fh AS fh
;

Learn More