E_EquipMatlSerialNumber

DDL: E_EQUIPMATLSERIALNUMBER SQL: EEQMATERIALSERNR Type: view_entity EXTENSION Package: VDM_EAM_EQUIPMENT
2 Fields 1 Data Sources

Material Serial Numbers - Extension

E_EquipMatlSerialNumber is a Extension CDS View that provides data about "Material Serial Numbers - Extension" in SAP S/4HANA. It reads from 1 data source (equi) and exposes 2 fields with key fields Material, SerialNumber. Part of development package VDM_EAM_EQUIPMENT.

Data Sources (1)

SourceAliasJoin Type
equi Persistence from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Material Serial Numbers - Extension view
VDM.viewType #EXTENSION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Material equi matnr Vehicle Model
KEY SerialNumber equi sernr Serial Number

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 E_EquipMatlSerialNumber.
-- 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: EEQMATERIALSERNR

CREATE VIEW E_EquipMatlSerialNumber AS
SELECT
  Persistence.matnr AS Material,
  Persistence.sernr AS SerialNumber
FROM equi AS Persistence
;

Learn More