back to top

SAP TSAD3 Table – Forms of Address (Key) (Business Address Services)

TSAD3 table in SAP ERP or S/4HANA stores Forms of Address (Key) (Business Address Services) data. There are total 8 fields in TSAD3 table. The Forms of Address (Key) (Business Address Services) table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of TSAD3 table. It is in SAP Technology – Business Services: Address Management (SZAD) ABAP package and is part of the Address Management/Business Address (BC-SRV-ADR) module.

SAP TSAD3 Table Fields

Following is the list of fields that are available in SAP TSAD3 table. The primary key fields of Forms of Address (Key) (Business Address Services) table in SAP are CLIENT (Client), TITLE (Form-of-Address Key).

Field Description Data Element Check Table Data Type
CLIENT Client MANDT T000 CLNT(3)
TITLE Form-of-Address Key AD_TITLE CHAR(4)
GENERATE (not used) AD_GENERAT CHAR(1)
PERSON Flag: Title for natural personen AD_XPERS CHAR(1)
ORGANIZATN Flag: Organization/Company title AD_XORGA CHAR(1)
XGROUP Indicator: Form of Address for Group AD_XGROUP CHAR(1)
SEX Proposed Gender Key for Title AD_SEXP TSAD15_COPY CHAR(1)
EXCL_GENDER Excluded Gender key for Title AD_SEXE TSAD15_COPY CHAR(1)