CUSTOMERCOCOD_VH

9 Fields 1 CDS Views

Generated Table for View

CUSTOMERCOCOD_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_CUSTOMERCOCOD_VH view from

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kunnr KUNNR Customer
KEY bukrs BUKRS Company Code
land1 LAND1_GP Country/Region Key
pstlz PSTLZ Postal Code
sortl SORTL Search term
mcod1 MCDD1 Name
mcod3 MCDD3 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 CUSTOMERCOCOD_VH (
    MANDT,  -- Client [MANDT]
    KUNNR,  -- Customer [KUNNR]
    BUKRS,  -- Company Code [BUKRS]
    LAND1,  -- Country/Region Key [LAND1_GP]
    PSTLZ,  -- Postal Code [PSTLZ]
    SORTL,  -- Search term [SORTL]
    MCOD1,  -- Name [MCDD1]
    MCOD3,  -- City [MCDD3]
    BEGRU,  -- Authorization [BRGRU]
    PRIMARY KEY (MANDT, KUNNR, BUKRS)
);

Learn More