I_MATERIALSERIALNUMBERVH

CDS View
9 Fields 3 CDS Views

Material Serial Number

I_MATERIALSERIALNUMBERVH is a CDS View in S/4HANA. Material Serial Number. It contains 9 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_MaterialSerialNumberVH view_entity from CONSUMPTION List of Material Serial Numbers
SHSM_SERMAT view from CDS View replacing M_EQUIO in search help
SHSM_SERMATKEY view from CDS View for search help

Fields (9)

KeyField CDS FieldsUsed in Views
KEY Equipment equnr 2
_Customer _Customer 2
_Supplier _Supplier 2
AuthorizationGroup AuthorizationGroup 2
Customer Customer 2
Material matnr 2
SerialNumber sernr 2
Supplier Supplier 2
UniqueItemIdentifier uii 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Material Serial Number
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALSERIALNUMBERVH (
    EQUIPMENT,
    _CUSTOMER,
    _SUPPLIER,
    AUTHORIZATIONGROUP,
    CUSTOMER,
    MATERIAL,
    SERIALNUMBER,
    SUPPLIER,
    UNIQUEITEMIDENTIFIER,
    PRIMARY KEY (EQUIPMENT)
);

Learn More