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
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
X TRUE
NULL FALSE

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