SAP Table SPRT1

Partner table

SPRT1 (Partner table) 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 SPRT1 to other SAP tables.

SPRT1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PARTNR Partner number SPARTNR CHAR 10 0
KZPTP Person type indicator (legal or natural) KZPTP CHAR 1 0
X Yes
NULL No
BEGRU Authorization Group BRGRU CHAR 4 0
CNTRY_H Country of origin CNTRY_H T005 CHAR 3 0
SPRSL Language Key SPRSL T002 LANG 1 0
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
ANRED Form-of-Address Key SANRED NUMC 2 0
XANRED Form of address text XANRED CHAR 50 0
ANRBF Salutation key SANRBF NUMC 2 0
XANRBF Translation for saluation key XANRBF CHAR 50 0
SORTL Partner ID PARTID CHAR 10 0
PHSRT Phonetic search term PHSRT CHAR 20 0
PARTID IS-IS: Partner identification VVXPARTID CHAR 15 0
NAME1_MC IS-IS: Name 1 in upper case characters for matchcode search VVXNAME1MC CHAR 16 0
FLG_ANRBF ID for alternative salutations VVSABWBA CHAR 1 0
X Yes
NULL No
FLG_MITARB IS-IS: Indicator, partner is employee VVSMITARB CHAR 1 0
X Yes
NULL No

SPRT1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SPRT1 CNTRY_H SPRT1 CNTRY_H T005 Countries LAND1
SPRT1 CNTRY_H SPRT1 MANDT T005 Countries MANDT
SPRT1 MANDT SPRT1 MANDT T000 Clients MANDT
SPRT1 SPRSL SPRT1 SPRSL T002 Language Keys (Component BC-I18) SPRAS