I_NominationKeyVH

DDL: I_NOMINATIONKEYVH SQL: INOMKEYVH Type: view BASIC
9 Fields 2 Data Sources

Interface View for Nomination Key VH

I_NominationKeyVH is a Basic CDS View that provides data about "Interface View for Nomination Key VH" in SAP S/4HANA. It reads from 2 data sources (oijnomi, oijnomh) and exposes 9 fields with key fields NominationDoc, NominationDocItem.

Data Sources (2)

SourceAliasJoin Type
oijnomi a inner
oijnomh oijnomh from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName INOMKEYVH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Interface View for Nomination Key VH view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY NominationDoc oijnomh nomtk Nomination Key
KEY NominationDocItem oijnomi nomit Nomination Item
NominationExtNumber nomnr Nomination Number
TSWLocationID oijnomi locid Location
NominationDocIsBlocked nmselect Flag to Select Nom
NominationType oijnomh nomtyp Single-Character Flag
TransportSystem oijnomh tsyst Trans system
NominationShipper oijnomh nmshipper Single-Character Flag
NominationCarrier oijnomh nmcarrier Single-Character Flag

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_NominationKeyVH.
-- 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: INOMKEYVH

CREATE VIEW I_NominationKeyVH AS
SELECT
  oijnomh.nomtk AS NominationDoc,
  a.nomit AS NominationDocItem,
  nomnr AS NominationExtNumber,
  a.locid AS TSWLocationID,
  nmselect AS NominationDocIsBlocked,
  oijnomh.nomtyp AS NominationType,
  oijnomh.tsyst AS TransportSystem,
  oijnomh.nmshipper AS NominationShipper,
  oijnomh.nmcarrier AS NominationCarrier
FROM oijnomh
INNER JOIN oijnomi AS a ON /* join condition not captured in parsed metadata */
;

Learn More