SAP MAM_20_USER_DATA User Data MAM 2.0 Interface Table data and field list

MAM_20_USER_DATA 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 Data MAM 2.0 Interface" 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_MAM_20_USER_DATA TYPE MAM_20_USER_DATA.

The MAM_20_USER_DATA table consists of various fields, each holding specific information or linking keys about User Data MAM 2.0 Interface data available in SAP. These include MYALM_SCENARIO (Mobile Asset Management Scenario), ROLE_GEN (Profile is Generated from Role), PROFILE_RESOURCE (Order Assignment), PLANT (Plant)... 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. .

MAM_20_USER_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP MAM_20_USER_DATA 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 MAM_20_USER_DATA 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
USERIDUser Name UNAMECHAR12UNAME
MYALM_SCENARIOMobile Asset Management Scenario ALM_ME_SCENARIO_MYALMCHAR10Assigned to domainALM_ME_SCENARIO_MYALM
ROLE_GENProfile is Generated from Role ALM_ME_ROLE_BASED_GENCHAR1CHAR1
PROFILE_RESOURCEOrder Assignment ALM_ME_PROFILE_RESOURCECHAR1ALM_ME_PROFILE_RESOURCE
PLANTPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
WORK_CNTRWork center ARBPLCHAR8ARBPLAGR
PLANGROUPPlanner Group for Customer Service and Plant Maintenance INGRPCHAR3Assigned to domainINGRPIHG
STGE_LOCStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
PARTNERPartner I_PARNRCHAR12ALPHAI_PARNR
FUNCLOC_INTFunctional Location TPLNRCHAR30Assigned to domainTPLNRTPLNRIFLIFLM
FUNCLOCFunctional Location Label ILOM_STRNOCHAR40ILOM_STRNO
COMP_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
EMPLOYEENOPersonnel Number PERNR_DNUMC8PERNRPER
CUSTOMERAccount Number of Customer EKUNNCHAR10Assigned to domainALPHAKUNNRKUN
DEVICEIDDevice ID BWAFDEPIDCHAR12
NAMEFormatted Name of Employee or Applicant EMNAMCHAR40TEXT40
FIRSTNAMEFirst Name PAD_VORNACHAR40PAD_VORNM
LASTNAMELast Name PAD_NACHNCHAR40PAD_NACHN
WORK_CNTR_GROUPWork center ARBPLCHAR8ARBPLAGR

Key field Non-key field



How do I retrieve data from SAP structure MAM_20_USER_DATA using ABAP code?

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

How to access SAP table MAM_20_USER_DATA

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

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