SUPPLIERCOCOD_VH

Generated Table for View

SUPPLIERCOCOD_VH is an SAP database table in S/4HANA. Generated Table for View. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SHSM_SUPPLIERCOCOD_VH view from

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY lifnr LIFNR Supplier
KEY bukrs BUKRS Company Code
land1 LAND1_GP Country/Region Key
pstlz PSTLZ Postal Code
sortl SORTL Search term
mcod1 MCDK1 Name
mcod3 MCDK3 City
begru BRGRU Authorization

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SUPPLIERCOCOD_VH (
    MANDT,  -- Client [MANDT]
    LIFNR,  -- Supplier [LIFNR]
    BUKRS,  -- Company Code [BUKRS]
    LAND1,  -- Country/Region Key [LAND1_GP]
    PSTLZ,  -- Postal Code [PSTLZ]
    SORTL,  -- Search term [SORTL]
    MCOD1,  -- Name [MCDK1]
    MCOD3,  -- City [MCDK3]
    BEGRU,  -- Authorization [BRGRU]
    PRIMARY KEY (MANDT, LIFNR, BUKRS)
);