FAC_CDS_UH_GEN_MD_W_VALIDATION

DDL: FAC_CDS_UH_GEN_MD_W_VALIDATION SQL: FACV_UH_GERMDWV Type: view
5 Fields 1 Data Sources

UH Generic master data with validation

FAC_CDS_UH_GEN_MD_W_VALIDATION is a CDS View that provides data about "UH Generic master data with validation" in SAP S/4HANA. It reads from 1 data source (uhdt_bety) and exposes 5 fields.

Data Sources (1)

SourceAliasJoin Type
uhdt_bety uhdt_bety from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FACV_UH_GERMDWV view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label UH Generic master data with validation view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (5)

KeyFieldSource TableSource FieldDescription
BusinessEntity
Value
ValueText
ValidityStartDate
ValidityEndDate

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_GEN_MD_W_VALIDATION.
-- 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_GERMDWV

CREATE VIEW FAC_CDS_UH_GEN_MD_W_VALIDATION AS
SELECT
  cast( '' as bnnam ) AS BusinessEntity,
  cast( '' as gmfld ) AS Value,
  cast( '' as gmfldt ) AS ValueText,
  cast( '' as gmvldf ) AS ValidityStartDate,
  cast( '' as gmvldt ) AS ValidityEndDate
FROM uhdt_bety
;

Learn More