fac_cds_uh_bety

DDL: FAC_CDS_UH_BETY SQL: FACV_UH_BETY Type: view
6 Fields 2 Data Sources

Universal Hierarchy Business Entity

fac_cds_uh_bety is a CDS View that provides data about "Universal Hierarchy Business Entity" in SAP S/4HANA. It reads from 2 data sources (uhdt_bety, uhdt_betyt) and exposes 6 fields with key field BusinessEntityName.

Data Sources (2)

SourceAliasJoin Type
uhdt_bety bety from
uhdt_betyt betyt left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FACV_UH_BETY view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Universal Hierarchy Business Entity view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BusinessEntityName uhdt_bety bety_name Business Entity
SearchHelpName uhdt_bety shlp_name Search Help Name
SearchHelpExportField uhdt_bety shlp_exp SearchHelpParam
SearchHelpExportTextField uhdt_bety shlp_txtexp SearchHelpParam
BusinessEntityText uhdt_betyt bety_text Business Entity Desc
to_clfd to_clfd

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_bety.
-- 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_BETY

CREATE VIEW fac_cds_uh_bety AS
SELECT
  bety.bety_name AS BusinessEntityName,
  bety.shlp_name AS SearchHelpName,
  bety.shlp_exp AS SearchHelpExportField,
  bety.shlp_txtexp AS SearchHelpExportTextField,
  betyt.bety_text AS BusinessEntityText,
  to_clfd
FROM uhdt_bety AS bety
LEFT OUTER JOIN uhdt_betyt AS betyt ON /* join condition not captured in parsed metadata */
;

Learn More