fac_cds_uh_clfd_value

DDL: FAC_CDS_UH_CLFD_VALUE SQL: FACV_UH_CLFD_VAL Type: view Package: UH_CORE
5 Fields 1 Data Sources 15 OData Services

Universal Hierarchy Class Field Value

fac_cds_uh_clfd_value is a CDS View that provides data about "Universal Hierarchy Class Field Value" in SAP S/4HANA. It reads from 1 data source (uhdt_clfd_val) and exposes 5 fields with key fields ObjectId, FieldName. It is exposed through 15 OData services (ASQL_F2918, ASQL_F4359, ASQL_F4966, ...). Part of development package UH_CORE.

Data Sources (1)

SourceAliasJoin Type
uhdt_clfd_val uhdt_clfd_val from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FACV_UH_CLFD_VAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Universal Hierarchy Class Field Value view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

OData Services (15)

ServiceBindingVersionContractRelease
ASQL_F2918 ASQL_F2918 C2 NOT_RELEASED
ASQL_F4359 ASQL_F4359 C2 NOT_RELEASED
ASQL_F4966 ASQL_F4966 C2 NOT_RELEASED
ASQL_F4973 ASQL_F4973 C2 NOT_RELEASED
ASQL_F5794 ASQL_F5794 C2 NOT_RELEASED
ASQL_F6386 ASQL_F6386 C2 NOT_RELEASED
ASQL_F6748 ASQL_F6748 C2 NOT_RELEASED
ASQL_F7781 ASQL_F7781 C2 NOT_RELEASED
ASQL_F7782 ASQL_F7782 C2 NOT_RELEASED
ASQL_F7783 ASQL_F7783 C2 NOT_RELEASED
ASQL_F7898 ASQL_F7898 C2 NOT_RELEASED
ASQL_F7995 ASQL_F7995 C2 NOT_RELEASED
ASQL_F8001 ASQL_F8001 C2 NOT_RELEASED
ASQL_F8219 ASQL_F8219 C2 NOT_RELEASED
ASQL_F8220 ASQL_F8220 C2 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ObjectId obj_id Result ID
KEY FieldName fld_name Field Path
ValueSign val_sign Input Type
LowValue val_low Low Value
HighValue val_high High Value

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_clfd_value.
-- 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_UH_CLFD_VAL

CREATE VIEW fac_cds_uh_clfd_value AS
SELECT
  obj_id AS ObjectId,
  fld_name AS FieldName,
  val_sign AS ValueSign,
  val_low AS LowValue,
  val_high AS HighValue
FROM uhdt_clfd_val
;

Learn More