SAP /VIRSA/VALIDUSERDATA_HR User HR Data Table data and field list

/VIRSA/VALIDUSERDATA_HR is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "User HR Data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_/VIRSA/VALIDUSERDATA_HR TYPE /VIRSA/VALIDUSERDATA_HR.

The /VIRSA/VALIDUSERDATA_HR table consists of various fields, each holding specific information or linking keys about User HR Data data available in SAP. These include PERNR (Eight-digit numeric value), NAME_FIRST (User field for cluster PC (national)), NAME_LAST (User field for cluster PC (national)), EMAIL (E-Mail Address)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

/VIRSA/VALIDUSERDATA_HR structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP /VIRSA/VALIDUSERDATA_HR structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the /VIRSA/VALIDUSERDATA_HR table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
BNAME	User Name in User Master Record	XUBNAME	CHAR	12	Assigned to domain		XUBNAME	XUS
PERNR	Eight-digit numeric value	NUM8	NUMC	8			NUM8
NAME_FIRST	User field for cluster PC (national)	CHAR25	CHAR	25			CHAR25
NAME_LAST	User field for cluster PC (national)	CHAR25	CHAR	25			CHAR25
EMAIL	E-Mail Address	AD_SMTPADR	CHAR	241		SXIDN	AD_SMTPADR
NATIONALITY	3-Byte field	CHAR3	CHAR	3			CHAR3
PERS_AREA	Personnel Area	PERSA	CHAR	4	Assigned to domain		PERSA	PBR
STELEPHONE	Communication Identification/Number	SYSID	CHAR	30			CHAR30
TELEPHONE	Communication Identification/Number	SYSID	CHAR	30			CHAR30
FAX	Communication Identification/Number	SYSID	CHAR	30			CHAR30
VALID_FROM	Start Date	BEGDA	DATS	8			DATUM
VALID_TO	End Date	ENDDA	DATS	8			DATUM
COST_CENTER	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
ORG_UNIT	Eight-digit numeric value	NUM8	NUMC	8			NUM8
ORG_DESC	Object Name	STEXT	CHAR	40			TEXT40
POSITION	Eight-digit numeric value	NUM8	NUMC	8			NUM8
JOB	Eight-digit numeric value	NUM8	NUMC	8			NUM8
EMP_GROUP	Single-Character Indicator	CHAR1	CHAR	1			CHAR1
BUS_AREA	Not More Closely Defined Area, Possibly Used for Patchlevels	CHAR4	CHAR	4			CHAR4
COMP_CODE	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
PERS_AREA_DESC	Personnel Area Text	PBTXT	CHAR	30			TEXT30
MPERNR	Eight-digit numeric value	NUM8	NUMC	8			NUM8
MBNAME	User Name in User Master Record	XUBNAME	CHAR	12	Assigned to domain		XUBNAME	XUS
MFNAME	First name	AD_NAMEFIR	CHAR	40			TEXT40
MLNAME	Last name	AD_NAMELAS	CHAR	40			TEXT40
MEMAIL	E-Mail Address	AD_SMTPADR	CHAR	241		SXIDN	AD_SMTPADR
MSTELEPHONE	Communication Identification/Number	SYSID	CHAR	30			CHAR30
MTELEPHONE	Communication Identification/Number	SYSID	CHAR	30			CHAR30
SPRAS	2-Character SAP Language Code	LAISO	CHAR	2			LAISO

Key field

Non-key field

< /VIRSA/VALIDUSERDATA - Valid User Data /VIRSA/VALUE_FROM - Value From >

How do I retrieve data from SAP structure /VIRSA/VALIDUSERDATA_HR using ABAP code?

As /VIRSA/VALIDUSERDATA_HR is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /VIRSA/VALIDUSERDATA_HR as there is no data to select.

How to access SAP table /VIRSA/VALIDUSERDATA_HR

Within an ECC or HANA version of SAP you can also view further information about /VIRSA/VALIDUSERDATA_HR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).