TSAD5

Transparent Table Customizing Table
3 Fields 2 CDS Views

Name Suffixes/Title (Key) (Business Address Services)

TSAD5 is an SAP database table in S/4HANA. Name Suffixes/Title (Key) (Business Address Services). It contains 3 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BusPartSupplementName view from BASIC View shows the Business Partner Supplement
I_NameSupplement view_entity from BASIC Name Supplement

Fields (3)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY title_key AD_TITLES Name Supplement
title_text AD_TITLEST Name Supplement

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.

-- Name Suffixes/Title (Key) (Business Address Services)
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TSAD5 (
    CLIENT,      -- Client [MANDT]
    TITLE_KEY,   -- Name Supplement [AD_TITLES]
    TITLE_TEXT,  -- Name Supplement [AD_TITLEST]
    PRIMARY KEY (CLIENT, TITLE_KEY)
);

Learn More