SAP Table SOUB
SAPoffice: Inverse user (SAPoffice user)
SOUB (SAPoffice: Inverse user (SAPoffice user)) 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 SOUB to other SAP tables.
SOUB table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| USRNAM | SAPoffice user name | SO_USR_NAM | CHAR | 12 | 0 | |||||||
| USRTP | User type from ID | SO_USR_TP | TSOTD | CHAR | 3 | 0 | ||||||
| USRYR | User year from the ID | SO_USR_YR | CHAR | 2 | 0 | |||||||
| USRNO | User number from the ID | SO_USR_NO | SOUD | CHAR | 12 | 0 | ||||||
| SAPNAM | SAP name of a SAPoffice user | SO_SAP_NAM | CHAR | 12 | 0 | |||||||
| DELETED | SAPoffice: Office user was deleted | SO_USR_DEL | CHAR | 1 | 0 |
Possible values
|
||||||
SOUB foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| SOUB | MANDT | SOUB | MANDT | T000 | Clients | MANDT |
| SOUB | USRNO | SOUB | USRYR | SOUD | SAPoffice: user definition | USRYR |
| SOUB | USRNO | SOUB | USRNO | SOUD | SAPoffice: user definition | USRNO |
| SOUB | USRNO | SOUB | MANDT | SOUD | SAPoffice: user definition | MANDT |
| SOUB | USRNO | SOUB | USRTP | SOUD | SAPoffice: user definition | USRTP |
| SOUB | USRTP | SOUB | USRTP | TSOTD | Valid Object Types | OBJTP |
