TSAD4 table in SAP ERP or S/4HANA stores Name Prefixes (Business Address Services) data. There are total 3 fields in TSAD4 table. The Name Prefixes (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 TSAD4 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 TSAD4 Table Fields
Following is the list of fields that are available in SAP TSAD4 table. The primary key fields of Name Prefixes (Business Address Services) table in SAP are CLIENT (Client), PREFIX_KEY (Name Prefix (Key)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT(3) |
| PREFIX_KEY | Name Prefix (Key) | AD_PREFIX | CHAR(4) | |
| PREFIX_TXT | Name prefix | AD_PREFIXT | CHAR(20) |


