SAP table PKUSR (User Settings for Kanban Transactions)
SAP table PKUSR has 3 primary key fields being MANDT,UNAME,TCODE.
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 | |
| UNAME | User Name | CHAR | 12 | 0 | SYUNAME | ||
| TCODE | Transaction Code | CHAR | 20 | 0 | * | SYTCODE | |
| WERKS | Plant | CHAR | 4 | 0 | * | WERKS_D | |
| PRVBE | Production Supply Area | CHAR | 10 | 0 | * | PRVBE | |
| RGVER | Person responsible for one or more supply areas | CHAR | 3 | 0 | * | RGVER | |
| LGORT | Storage location | CHAR | 4 | 0 | * | LGORT_D | |
| FLAG1 | Single-Character Flag | CHAR | 1 | 0 | CHAR1 | ||
| FLAG2 | Single-Character Flag | CHAR | 1 | 0 | CHAR1 | ||
| FLAG3 | Single-Character Flag | CHAR | 1 | 0 | CHAR1 | ||
| FLAG4 | Single-Character Flag | CHAR | 1 | 0 | CHAR1 | ||
| FLAG5 | Single-Character Flag | CHAR | 1 | 0 | CHAR1 | ||
| FLAG6 | Single-Character Flag | CHAR | 1 | 0 | CHAR1 | ||
| LIFNR | Vendor's account number | CHAR | 10 | 0 | LFA1 | ELIFN | |
| PKUMW | Issuing Plant in Kanban Processing | CHAR | 4 | 0 | T001W | PKUMW | |
| FLAG7 | Single-Character Flag | CHAR | 1 | 0 | CHAR1 |
PKUSR foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 PKUSR | LIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| 0 PKUSR | LIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| 1 PKUSR | PKUMW | T001W | Plants/Branches | MANDT |
| 1 PKUSR | PKUMW | T001W | Plants/Branches | WERKS |