SAP ALM_ME_D997 User-specific settings Table
Overview
ALM_ME_D997 is a standard SAP S/4HANA table that stores User-specific settings data. There are total 24 fields in the ALM_ME_D997 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ALM_ME_D997 belongs to Maintenance Processing (PM-WOC) module and is located in the package (ALM_ME).
In addition, following links provide an overview of foreign key relationships, if any, that link ALM_ME_D997 to other SAP tables and standard CDS views available based on ALM_ME_D997 table in S/4HANA 2020.
Techincal Settings of ALM_ME_D997
Below are technical details of the table ALM_ME_D997
- Buffering switched on
- Full buffering as specified by generic key
- Storage type is Column Store
List of ALM_ME_D997 Fields
The following table gives you an overview of the fields available in ALM_ME_D997
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| USERID | User Name in User Master Record | XUBNAME | USR02 | CHAR | 12 |
| MYALM_SCENARIO | Mobile Asset Management Scenario | ALM_ME_SCENARIO_MYALM | ALM_ME_C000 | CHAR | 10 |
| ROLE_GEN | Profile is Generated from Role | ALM_ME_ROLE_BASED_GEN | CHAR | 1 | |
| ARBPL | Main work center for maintenance tasks | GEWRK | CHAR | 8 | |
| PLANT | Plant associated with main work center | WERGW | T001W | CHAR | 4 |
| PLANGROUP | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR | 3 |
| PLANGROUP_PLANT | Maintenance Planning Plant | IWERK | T001W | CHAR | 4 |
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | |
| PARTNER_ROLE | Partner Function | PARVW | TPAR | CHAR | 2 |
| PARTNER | Partner | I_PARNR | CHAR | 12 | |
| NOTIF_ARBPL | Main work center for maintenance tasks | GEWRK | CHAR | 8 | |
| NOTIF_PLANT | Plant associated with main work center | WERGW | CHAR | 4 | |
| NOTIF_PLAN_GROUP | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR | 3 |
| NOTIF_PLAN_PLANT | Maintenance Planning Plant | IWERK | T001W | CHAR | 4 |
| NOTIF_PERNR | Personnel Number | PERNR_D | NUMC | 8 | |
| NOTIF_PAR_ROLE | Partner Function | PARVW | TPAR | CHAR | 2 |
| NOTIF_PARTNER | Partner | I_PARNR | CHAR | 12 | |
| FLOC_SEL_VARIANT | User Selection Variants for Functional Locations | ALM_ME_FLOC_USER_SEL_VAR | CHAR | 14 | |
| EQUI_SEL_VARIANT | Selection Variant for Selection of Equipment | ALM_ME_EQUI_USER_SEL_VAR | CHAR | 14 | |
| CONSI_CUSTOMER | Customer of Consignment Stock | ALM_ME_CONSIGNMENT_CUSTOMER | CHAR | 10 | |
| STGE_LOC | Storage location | LGORT_D | T001L | CHAR | 4 |
| STGE_LOC_PLANT | Plant | WERKS_D | CHAR | 4 | |
| FUNCLOC | Functional Location | TPLNR | CHAR | 30 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ALM_ME_D997
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ALM_ME_D997 | MANDT | : | T000 |
| ALM_ME_D997 | MYALM_SCENARIO | : | ALM_ME_C000 |
| ALM_ME_D997 | NOTIF_PAR_ROLE | : | TPAR |
| ALM_ME_D997 | NOTIF_PLAN_GROUP | : | T024I |
| ALM_ME_D997 | NOTIF_PLAN_PLANT | : | T001W |
| ALM_ME_D997 | PARTNER_ROLE | : | TPAR |
| ALM_ME_D997 | PLANGROUP | : | T024I |
| ALM_ME_D997 | PLANGROUP_PLANT | : | T001W |
| ALM_ME_D997 | PLANT | : | T001W |
| ALM_ME_D997 | STGE_LOC | : | T001L |
| ALM_ME_D997 | USERID | : | USR02 |