I_MaterialSerialNumberVH

DDL: I_MATERIALSERIALNUMBERVH SQL: IE_MSNVH Type: view COMPOSITE
11 Fields 1 Data Sources

Material Serial Number

I_MaterialSerialNumberVH is a Composite CDS View that provides data about "Material Serial Number" in SAP S/4HANA. It reads from 1 data source (I_Equipment) and exposes 11 fields with key field Equipment.

Data Sources (1)

SourceAliasJoin Type
I_Equipment I_Equipment from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IE_MSNVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view
Search.searchable true view
ObjectModel.representativeKey Equipment view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Material Serial Number view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Equipment Equipment Equipment check
Material Material Vehicle Model
SerialNumber SerialNumber Serial Number
UniqueItemIdentifier UniqueItemIdentifier UII
_EquipmentText _EquipmentText
Customer Customer Sold-to Party
Supplier Supplier Supplier
AuthorizationGroup AuthorizationGroup AuthorizGroup
HasEquipmentData HasEquipmentData Equipment data
_Customer _Customer
_Supplier _Supplier

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_MaterialSerialNumberVH.
-- 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: IE_MSNVH

CREATE VIEW I_MaterialSerialNumberVH AS
SELECT
  Equipment,
  Material,
  SerialNumber,
  UniqueItemIdentifier,
  Customer,
  Supplier,
  AuthorizationGroup,
  HasEquipmentData
FROM I_Equipment
;

Learn More