SPRT1
Partner tableExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table SPRT1.
SAP table SPRT1 has 2 primary key fields: MANDT,PARTNR.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
SPRT1 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key PARTNR | Partner number | CHAR | 10 | 0 | SPARTNR | ||
| KZPTP | Person type indicator (legal or natural) | CHAR | 1 | 0 | KZPTP | ||
| BEGRU | Authorization Group | CHAR | 4 | 0 | * | BRGRU | |
| CNTRY_H | Country/Region of Origin | CHAR | 3 | 0 | T005 | CNTRY_H | |
| SPRSL | Language Key | LANG | 1 | 0 | T002 | SPRSL | |
| NAME1 | Name 1 | CHAR | 35 | 0 | NAME1_GP | ||
| NAME2 | Name 2 | CHAR | 35 | 0 | NAME2_GP | ||
| ANRED | Form-of-Address Key | NUMC | 2 | 0 | * | SANRED | |
| XANRED | Form of address text | CHAR | 50 | 0 | XANRED | ||
| ANRBF | Salutation key | NUMC | 2 | 0 | * | SANRBF | |
| XANRBF | Translation for saluation key | CHAR | 50 | 0 | XANRBF | ||
| SORTL | Partner ID | CHAR | 10 | 0 | PARTID | ||
| PHSRT | Phonetic search term | CHAR | 20 | 0 | PHSRT | ||
| PARTID | IS-IS: Partner identification | CHAR | 15 | 0 | VVXPARTID | ||
| NAME1_MC | IS-IS: Name 1 in upper case characters for matchcode search | CHAR | 16 | 0 | VVXNAME1MC | ||
| FLG_ANRBF | ID for alternative salutations | CHAR | 1 | 0 | VVSABWBA | ||
| FLG_MITARB | IS-IS: Indicator, partner is employee | CHAR | 1 | 0 | VVSMITARB |