I_NominationMeterNoVH

DDL: I_NOMINATIONMETERNOVH SQL: ITKTMETERVH Type: view BASIC

Meter Number Value Help

I_NominationMeterNoVH is a Basic CDS View that provides data about "Meter Number Value Help" in SAP S/4HANA. It reads from 1 data source (oirbmatmet) and exposes 4 fields with key fields LocationId, BusinessType, GeneralMeterNumber, TransportSystem.

Data Sources (1)

SourceAliasJoin Type
oirbmatmet oirbmatmet from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ITKTMETERVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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
EndUserText.label Meter Number Value Help view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY LocationId pblnr Location ID
KEY BusinessType rnbt Business type
KEY GeneralMeterNumber seqnr Tank ID
KEY TransportSystem

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_NominationMeterNoVH.
-- 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: ITKTMETERVH

CREATE VIEW I_NominationMeterNoVH AS
SELECT
  pblnr AS LocationId,
  rnbt AS BusinessType,
  seqnr AS GeneralMeterNumber,
  cast('' as oij_tsyst) AS TransportSystem
FROM oirbmatmet
;