SAP Table VUSREXTID
Generated Table for View
VUSREXTID (Generated Table for View) 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 VUSREXTID to other SAP tables.
VUSREXTID table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| TYPE | External ID type | EXTID_TYPE | USREXTIDT | CHAR | 2 | 0 | ||||||
| EXTID | External ID (plain text or hash value) | EXTID | CHAR | 112 | 0 | |||||||
| SEQNO | Numc3, internal use | NUMC3 | NUMC | 3 | 0 | |||||||
| BNAME | User Name in User Master Record | XUBNAME | USR02 | CHAR | 12 | 0 | ||||||
| DATEMIN | Min. date permitted for the validity of certificate | DATEMIN | DATS | 8 | 0 | |||||||
| STATUS | Status of entry for external ID | EXTIDSTAT | CHAR | 1 | 0 |
Possible values
|
||||||
| ISSUERH | Hash value for external ID | EXTID_HASH | CHAR | 32 | 0 | |||||||
| HASHEXTID | Switch: External ID exists as a hash value | HASHEXTID | CHAR | 1 | 0 |
Possible values
|
||||||
| EXTIDH | Hash value for external ID | EXTID_HASH | USREXTIDH | CHAR | 32 | 0 | ||||||
| CNAME | User Name in User Master Record | XUBNAME | CHAR | 12 | 0 | |||||||
| CDATE | Modification date | XUMODDATE | DATS | 8 | 0 | |||||||
| CTIME | Modification time | XUMODTIME | TIMS | 6 | 0 | |||||||
| MNAME | Last Changed By | XUMODIFIER | CHAR | 12 | 0 | |||||||
| MDATE | Modification date | XUMODDATE | DATS | 8 | 0 | |||||||
| MTIME | Modification time | XUMODTIME | TIMS | 6 | 0 | |||||||
| VALITYINFO | RAW | 16 | 0 | |||||||||
| VERSION | INT1 | 3 | 0 | |||||||||
| CNAMEH | User Name in User Master Record | XUBNAME | CHAR | 12 | 0 | |||||||
| CDATEH | Modification date | XUMODDATE | DATS | 8 | 0 | |||||||
| CTIMEH | Modification time | XUMODTIME | TIMS | 6 | 0 | |||||||
| MNAMEH | Last Changed By | XUMODIFIER | CHAR | 12 | 0 | |||||||
| MDATEH | Modification date | XUMODDATE | DATS | 8 | 0 | |||||||
| MTIMEH | Modification time | XUMODTIME | TIMS | 6 | 0 | |||||||
| VALITYINFOH | RAW | 16 | 0 | |||||||||
| VERSIONH | INT1 | 3 | 0 | |||||||||
| EXTIDLEN | Length of an LCHR or LRAW field in the database | LONG_LEN | INT2 | 5 | 0 | |||||||
| EXTID_DATA | External ID data | EXTID_DATA | LRAW | 4096 | 0 | |||||||
VUSREXTID foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| VUSREXTID | BNAME | VUSREXTID | MANDT | USR02 | Logon Data (Kernel-Side Use) | MANDT |
| VUSREXTID | BNAME | VUSREXTID | BNAME | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| VUSREXTID | EXTIDH | VUSREXTID | EXTIDH | USREXTIDH | External ID (Access Using Hash Value) | EXTIDH |
| VUSREXTID | EXTIDH | VUSREXTID | MANDT | USREXTIDH | External ID (Access Using Hash Value) | MANDT |
| VUSREXTID | EXTIDH | VUSREXTID | TYPE | USREXTIDH | External ID (Access Using Hash Value) | TYPE |
| VUSREXTID | MANDT | VUSREXTID | MANDT | T000 | Clients | MANDT |
| VUSREXTID | TYPE | VUSREXTID | TYPE | USREXTIDT | Values Table for External ID Type | EXTID_TYPE |
