TSAD3

Transparent Table Customizing Table
8 Fields 12 CDS Views

Forms of Address (Key) (Business Address Services)

TSAD3 is an SAP database table in S/4HANA. Forms of Address (Key) (Business Address Services). It contains 8 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_BPUSRFormOfAddressVH view from CONSUMPTION Value Help view for Form of Address
C_FormOfAddressVHTemp view from CONSUMPTION
C_FormOfAddrOrgVHTemp view from CONSUMPTION
C_FormOfAddrPersnVHTemp view from CONSUMPTION
CUAN_Freetext_Mapping view_entity union View for freetext mapping
Fclm_Bm_Contacts view left_outer Contact person for bank
I_BusinessPartnerFormOfAddress view from COMPOSITE Business Partner Form Of Address
I_FormOfAddress view_entity from BASIC Form of Address
I_MKT_ContactTitle view_entity from BASIC Marketing: Contact Title
I_MKT_IcTitle view_entity from BASIC Marketing: Title
I_PersonFormOfAddress view from BASIC Form of Address
I_PPS_PurgDocAddressTitleVH view_entity from BASIC Address title

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY title AD_TITLE Title Key
generate AD_GENERAT (not used)
person AD_XPERS Person title
organizatn AD_XORGA Organization
xgroup AD_XGROUP Group
sex AD_SEXP Proposed Gender
excl_gender AD_SEXE Excluded Gender

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.

-- Forms of Address (Key) (Business Address Services)
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TSAD3 (
    CLIENT,       -- Client [MANDT]
    TITLE,        -- Title Key [AD_TITLE]
    GENERATE,     -- (not used) [AD_GENERAT]
    PERSON,       -- Person title [AD_XPERS]
    ORGANIZATN,   -- Organization [AD_XORGA]
    XGROUP,       -- Group [AD_XGROUP]
    SEX,          -- Proposed Gender [AD_SEXP]
    EXCL_GENDER,  -- Excluded Gender [AD_SEXE]
    PRIMARY KEY (CLIENT, TITLE)
);

Learn More