SAP table PSPPT_INDX (System table INDX)
SAP table PSPPT_INDX has 4 primary key fields being MANDT,RELID,SRTFD,SRTF2.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | * | MANDT | |
| RELID | Region in IMPORT/EXPORT Data Table | CHAR | 2 | 0 | INDX_RELID | ||
| SRTFD | User-defined key in table INDX | CHAR | 22 | 0 | INDX_SRTFD | ||
| SRTF2 | Next record counter in EXPORT/IMPORT data tables | INT4 | 10 | 0 | INDX_SRTF2 | ||
| LOEKZ | CHAR01 data element for SYST | CHAR | 1 | 0 | SYCHAR01 | ||
| SPERR | CHAR01 data element for SYST | CHAR | 1 | 0 | SYCHAR01 | ||
| AEDAT | (8-character) Date for SYST | DATS | 8 | 0 | SYDATS | ||
| USERA | User Name | CHAR | 12 | 0 | USERNAME | ||
| PGMID | ABAP Program Name | CHAR | 40 | 0 | PROGNAME | ||
| BEGDT | (8-character) Date for SYST | DATS | 8 | 0 | SYDATS | ||
| ENDDT | (8-character) Date for SYST | DATS | 8 | 0 | SYDATS | ||
| CLUSTR | Length field for user data in EXPORT/IMPORT tables | INT2 | 5 | 0 | INDX_CLSTR | ||
| CLUSTD | Data field for IMPORT/EXPORT database tables | LRAW | 2886 | 0 | INDX_CLUST |