ALM_ME_D997 SAP (User-specific settings) Table details

Dictionary Type: Table
Description: User-specific settings




ABAP Code to SELECT data from ALM_ME_D997
Related tables to ALM_ME_D997
Access table ALM_ME_D997




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

ALM_ME_D997 is a standard SAP Table which is used to store User-specific settings data and is available within R/3 SAP systems depending on the version and release level.

The ALM_ME_D997 table consists of various fields, each holding specific information or linking keys about User-specific settings data available in SAP. These include USERID (User Name in User Master Record), MYALM_SCENARIO (Mobile Asset Management Scenario), ROLE_GEN (Profile is Generated from Role), ARBPL (Main work center for maintenance tasks).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP ALM_ME_D997 table 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
MANDTClient MANDTCLNT3T000MANDT
USERIDUser Name in User Master Record XUBNAMECHAR12USR02XUBNAMEXUS
MYALM_SCENARIOMobile Asset Management Scenario ALM_ME_SCENARIO_MYALMCHAR10ALM_ME_C000ALM_ME_SCENARIO_MYALM
ROLE_GENProfile is Generated from Role ALM_ME_ROLE_BASED_GENCHAR1CHAR1
ARBPLMain work center for maintenance tasks GEWRKCHAR8ARBPLVAP
PLANTPlant associated with main work center WERGWCHAR4T001WWERKS
PLANGROUPPlanner Group for Customer Service and Plant Maintenance INGRPCHAR3T024IINGRPIHG
PLANGROUP_PLANTMaintenance Planning Plant IWERKCHAR4T001WWERKSIWK
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
PARTNER_ROLEPartner Function PARVWCHAR2TPARPARVWPARVWPAR
PARTNERPartner I_PARNRCHAR12ALPHAI_PARNR
NOTIF_ARBPLMain work center for maintenance tasks GEWRKCHAR8ARBPLVAP
NOTIF_PLANTPlant associated with main work center WERGWCHAR4Assigned to domainWERKS
NOTIF_PLAN_GROUPPlanner Group for Customer Service and Plant Maintenance INGRPCHAR3T024IINGRPIHG
NOTIF_PLAN_PLANTMaintenance Planning Plant IWERKCHAR4T001WWERKSIWK
NOTIF_PERNRPersonnel Number PERNR_DNUMC8PERNRPER
NOTIF_PAR_ROLEPartner Function PARVWCHAR2TPARPARVWPARVWPAR
NOTIF_PARTNERPartner I_PARNRCHAR12ALPHAI_PARNR
FLOC_SEL_VARIANTUser Selection Variants for Functional Locations ALM_ME_FLOC_USER_SEL_VARCHAR14RALDB_VARI
EQUI_SEL_VARIANTSelection Variant for Selection of Equipment ALM_ME_EQUI_USER_SEL_VARCHAR14RALDB_VARI
CONSI_CUSTOMERCustomer of Consignment Stock ALM_ME_CONSIGNMENT_CUSTOMERCHAR10Assigned to domainALPHAKUNNR
STGE_LOCStorage Location LGORT_DCHAR4T001LLGORTLAG
STGE_LOC_PLANTPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
FUNCLOCFunctional Location TPLNRCHAR30Assigned to domainTPLNRTPLNRIFLIFLM

Key field Non-key field



How do I retrieve data from SAP table ALM_ME_D997 using ABAP code

The following ABAP code Example will allow you to do a basic selection on ALM_ME_D997 to SELECT all data from the table
DATA: WA_ALM_ME_D997 TYPE ALM_ME_D997.

SELECT SINGLE *
FROM ALM_ME_D997
INTO CORRESPONDING FIELDS OF WA_ALM_ME_D997
WHERE...

How to access SAP table ALM_ME_D997

Within an ECC or HANA version of SAP you can also view further information about ALM_ME_D997 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!