_VENDOR

_VENDOR is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
adrnr adrnr 2
anred anred 2
ktokk ktokk 2
kunnr kunnr 2
land1 land1 2
name1 own_nm 2
name2 name2 2
ort01 ort01 2
pstlz pstlz 2
regio regio 2
stras stras 2
telf1 telf1 2
telf2 telf2 2
telfx telfx 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _VENDOR (
    COMPANYCODE,
    ADRNR,
    ANRED,
    KTOKK,
    KUNNR,
    LAND1,
    NAME1,
    NAME2,
    ORT01,
    PSTLZ,
    REGIO,
    STRAS,
    TELF1,
    TELF2,
    TELFX,
    PRIMARY KEY (COMPANYCODE)
);