SPRT1
Partner tableBekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel SPRT1.
SAP-tabel SPRT1 heeft 2 primaire sleutelvelden: MANDT,PARTNR.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
SPRT1 velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |
|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Sleutel 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 |