/SAPSRM/S_EMP_MASS SAP (Mass Employee and User upload/download) Structure details

Dictionary Type: Structure
Description: Mass Employee and User upload/download




ABAP Code to SELECT data from /SAPSRM/S_EMP_MASS
Related tables to /SAPSRM/S_EMP_MASS
Access table /SAPSRM/S_EMP_MASS




Structure field list including key, data, relationships and ABAP select examples

/SAPSRM/S_EMP_MASS 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 "Mass Employee and User upload/download" 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_/SAPSRM/S_EMP_MASS TYPE /SAPSRM/S_EMP_MASS.

The /SAPSRM/S_EMP_MASS table consists of various fields, each holding specific information or linking keys about Mass Employee and User upload/download data available in SAP. These include USERNAME (User Name in User Master Record), TITLE_P (Title text), FIRSTNAME (First name), LASTNAME (Last name).. 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. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP /SAPSRM/S_EMP_MASS structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
PARTNER_IDBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
USERNAMEUser Name in User Master Record XUBNAMECHAR12Assigned to domainXUBNAMEXUS
TITLE_PTitle text AD_TITLETXCHAR30TEXT30
FIRSTNAMEFirst name AD_NAMEFIRCHAR40TEXT40
LASTNAMELast name AD_NAMELASCHAR40TEXT40
TITLE_ACA1Academic Title: Written Form AD_TITLE1TCHAR20TEXT20
ORGUNIT_IDObject ID HROBJIDNUMC8Assigned to domainHROBJIDPON
POSITION_TEXTObject Abbreviation SHORT_DCHAR12TEXT12
MGR_ORGUNIT_IDObject ID HROBJIDNUMC8Assigned to domainHROBJIDPON
PUR_ORGUNIT_IDObject ID HROBJIDNUMC8Assigned to domainHROBJIDPON
BUILDING_PBuilding (number or code) AD_BLDNG_PCHAR10TEXT10
FLOOR_PFloor in building AD_FLOORCHAR10TEXT10
ROOM_NO_PRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
INHOUSE_MLInt. mail postal code AD_IH_MAILCHAR10TEXT10
COMM_TYPECommunication Method (Key) (Business Address Services) AD_COMMCHAR3Assigned to domainAD_COMM
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
TEL1_NUMBRFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL1_EXTFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
FAX_NUMBERFirst fax no.: dialling code+number AD_FXNMBR1CHAR30CHAR30
FAX_EXTENSFirst fax no.: extension AD_FXXTNS1CHAR10CHAR10
E_MAILE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
E_MAIL_COME-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
LANGULogon Language XULANGULANG1ISOLALANGSPR
DEC_FORMDecimal Format XUDCPFMCHAR1XUDCPFM
DATE_FORMDate format XUDATFMCHAR1XUDATFM
VALID_FROMUser valid from XUGLTGVDATS8DATUM
VALID_TOUser valid to XUGLTGBDATS8DATUM
TIME_ZONESystem Time Zone TZNZONESYSCHAR6Assigned to domainTZNZONE
CLASSUser group in user master maintenance XUCLASSCHAR12Assigned to domainXUCLASSXUG
REF_USERUser Name in User Master Record XUBNAMECHAR12Assigned to domainXUBNAMEXUS
ROLES 0

Key field Non-key field



How do I retrieve data from SAP structure /SAPSRM/S_EMP_MASS using ABAP code?

As /SAPSRM/S_EMP_MASS 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 /SAPSRM/S_EMP_MASS as there is no data to select.

How to access SAP table /SAPSRM/S_EMP_MASS

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!