V_TSI_CONTACT

16 Fields 1 CDS Views

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FAP_TSI_INVC_entry view left_outer

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
bname XUBNAME User
persnumber AD_PERSNUM Person Number
addrnumber AD_ADDRNUM Address Number
name1 AD_NAME1 Name
country LAND1 Country/Reg.
city1 AD_CITY1 City
street AD_STREET Street
fax_number AD_FXNMBR1 Fax
fax_extens AD_FXXTNS1 Extension
tel_number AD_TLNMBR1 Telephone
tel_extens AD_TLXTNS1 Extension
title AD_TITLE Title Key
name_first AD_NAMEFIR First Name
name_last AD_NAMELAS Last Name
smtp_addr AD_SMTPADR E-Mail Address

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 V_TSI_CONTACT (
    MANDT,       -- Client [MANDT]
    BNAME,       -- User [XUBNAME]
    PERSNUMBER,  -- Person Number [AD_PERSNUM]
    ADDRNUMBER,  -- Address Number [AD_ADDRNUM]
    NAME1,       -- Name [AD_NAME1]
    COUNTRY,     -- Country/Reg. [LAND1]
    CITY1,       -- City [AD_CITY1]
    STREET,      -- Street [AD_STREET]
    FAX_NUMBER,  -- Fax [AD_FXNMBR1]
    FAX_EXTENS,  -- Extension [AD_FXXTNS1]
    TEL_NUMBER,  -- Telephone [AD_TLNMBR1]
    TEL_EXTENS,  -- Extension [AD_TLXTNS1]
    TITLE,       -- Title Key [AD_TITLE]
    NAME_FIRST,  -- First Name [AD_NAMEFIR]
    NAME_LAST,   -- Last Name [AD_NAMELAS]
    SMTP_ADDR,   -- E-Mail Address [AD_SMTPADR]
    PRIMARY KEY (MANDT)
);

Learn More