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