Follow us on LinkedIn for your next SAP project

SAP Table TP14

Business Partner: Address ID

TP14 (Business Partner: Address ID) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TP14 to other SAP tables.

TP14 table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT T000
CLNT
3 0
ADR_REF
Address ID
BP_ADR_REF_OLD
CHAR
10 0
ADR_KIND
Address Type
BU_ADRKIND TB009
CHAR
10 0
DEFAULT_FLAG
Business Partner: Default Flag for Standard Address
BP_DEFAULT_FLAG
CHAR
1 0

TP14 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TP14 ADR_KIND TP14 MANDT TB009
BP address types
CLIENT
TP14 ADR_KIND TP14 ADR_KIND TB009
BP address types
ADR_KIND
TP14 MANDT TP14 MANDT T000
Clients
MANDT