I_NominationTypeVH

DDL: I_NOMINATIONTYPEVH SQL: INOMTYVH Type: view BASIC

Nomination Type Value Help

I_NominationTypeVH is a Basic CDS View that provides data about "Nomination Type Value Help" in SAP S/4HANA. It reads from 2 data sources (toijnomtyp, toijnomtypt) and exposes 2 fields with key field NominationType.

Data Sources (2)

SourceAliasJoin Type
toijnomtyp nomtyp inner
toijnomtypt nomtypt from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName INOMTYVH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
Search.searchable true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view
EndUserText.label Nomination Type Value Help view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY NominationType toijnomtypt nomtyp Single-Character Flag
NominationTypeDescription toijnomtypt descr WSS Profile

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 I_NominationTypeVH.
-- 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: INOMTYVH

CREATE VIEW I_NominationTypeVH AS
SELECT
  nomtypt.nomtyp AS NominationType,
  nomtypt.descr AS NominationTypeDescription
FROM toijnomtypt AS nomtypt
INNER JOIN toijnomtyp AS nomtyp ON /* join condition not captured in parsed metadata */
;