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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||
|
FLG_MITARB
IS-IS: Indicator, partner is employee
|
VVSMITARB |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||