ABAPblog.com - ESDUS, ESRUO - MM settings table

Tags: ES_READ_USER_OBJECTS , ES_APPEND_USER_OBJECTS , ES_READ_USER_SETTINGS , ES_APPEND_USER_SETTINGS , ES_DELETE_USER_OBJECTS , ES_SAVE_USER_OBJECTS , ES_SAVE_USER_SETTINGS , ES_DELETE_USER_SETTINGS , ESDUS , ESRUO

View Comments

As we got a short description of ESDUS and ESRUO and connected FMs in previous parts, then now it's time for examples. Let's start with scenarios which I described in first part

1. When you open one of the MM t-codes like ME22N, ME51N or MIGO you see that always you got on the screen one of the latest open document there. Sometimes not last but one of the lasts and you want to make it always last.

To be sure you get last document you have to select data from ESRUO table directly, sort it by timestamp and get last object. Then update setting of default document for transaction, in my example for ME52N/53N/54N.

data: fs_esruo type esruo.
data: ft_esruo type standard table of esruo.
data: f_active type esdus-active.
data: ft_esduscom type standard table of esduscom.

select * into corresponding fields of table ft_esruo
  from esruo
  where uname eq sy-uname
  and   object_typ eq 'BUS2105'.

  sort ft_esruo by timestamp descending.
  read table ft_esruo index 1 into fs_esruo.
  concatenate fs_esruo-object_id 'A' into f_active.

call function 'ES_READ_USER_SETTINGS'
  exporting
    iaction       = 'MEPO'
*   IUNAME        = IUNAME
*   IDB           = IDB
*   ILIKE         = ILIKE
  tables
    iesdus        = ft_esduscom
   .

call function 'ES_DELETE_USER_SETTINGS'
exporting
  iaction        = 'MEPO'
  ielement       = 'Application         Req_Process'
*  iactive        =
*  IUNAME          = IUNAME
*  isave           = 'X'
* TABLES
*   IESDUS          = IESDUS
exceptions
   not_found       = 1
   others          = 2
          .
if sy-subrc eq 0.

endif.

call function 'ES_APPEND_USER_SETTINGS'
exporting
  iaction        = 'MEPO'
  ielement       = 'Application         Req_Process'
  iactive        = f_active
*   IUNAME         = IUNAME
  isave          = 'X'
* TABLES
*   IESDUS         = IESDUS
  .

2. You create MM documents using BAPI and you want that next time you open MM t-code which is used to display/edit this document then your document appears on the screen (of course if in the meantime user haven't created anything new).

Example of setting document that will be open by default in ME52N/53N/54N

call function 'ES_READ_USER_SETTINGS'
exporting
  iaction       = 'MEPO'
*   IUNAME        = IUNAME
*   IDB           = IDB
*   ILIKE         = ILIKE
tables
  iesdus        = gt_esduscom
  .

call function 'ES_DELETE_USER_SETTINGS'
exporting
  iaction        = 'MEPO'
  ielement       = 'Application         Req_Process'
*  iactive        =
*  IUNAME          = IUNAME
*  isave           = 'X'
* TABLES
*   IESDUS          = IESDUS
exceptions
   not_found       = 1
   others          = 2
          .
if sy-subrc eq 0.

endif.

call function 'ES_APPEND_USER_SETTINGS'
exporting
  iaction        = 'MEPO'
  ielement       = 'Application         Req_Process'
  iactive        = '0019324803V' "Requisition number + mode (V - change, A - display)
*   IUNAME         = IUNAME
  isave          = 'X'
* TABLES
*   IESDUS         = IESDUS
  .

3. You have created your own transaction to handle standard process, like creation of purchase orders or purchase requisitions. This transaction is used only in some special occasion like only in case of account assignment category is equal to 'A'. In such case for all documents which are created by your Z-transaction you've set up in user-exit that when standard transaction is called, then you leave it to your Z-transaction. In this case often MM transactions remembers last opened document, which was created by Z-transaction and at each run it will leave to it, so you want to clear the info about last called document from standard t-code.

Before going to your Z-Transaction call FM ES_DELETE_USER_SETTINGS, in most cases internal table of FG are filled already so you don't need to call ES_READ_USER_SETTINGS before. Like here for Purchase order number

call function 'ES_DELETE_USER_SETTINGS'
exporting
  iaction        = 'MEPO'
  ielement       = 'Application         Po_Process'
*  iactive        =
*  IUNAME          = IUNAME
  isave           = 'X'
* TABLES
*   IESDUS          = IESDUS
exceptions
   not_found       = 1
   others          = 2
          .
if sy-subrc eq 0.

endif.

4. You want to clear some default settings for the user (or set them) for standard t-code. This could be default value for some fields or toggle status of the section (for example header always expanded, items always collapsed.

This is an example of setting header data of Purchase order expanded or collapsed in ME21N/22N/23N.

call function 'ES_READ_USER_SETTINGS'
exporting
  iaction       = 'PurchaseOrder'
*   IUNAME        = IUNAME
*   IDB           = IDB
*   ILIKE         = ILIKE
tables
  iesdus        = gt_esduscom
  .

call function 'ES_DELETE_USER_SETTINGS'
exporting
  iaction        = 'PurchaseOrder'
  ielement       = 'DYN_4000-BUTTON TOGGLE_STATE'
*  iactive        =
*  IUNAME          = IUNAME
*  isave           = 'X'
* TABLES
*   IESDUS          = IESDUS
exceptions
   not_found       = 1
   others          = 2
          .
if sy-subrc eq 0.

endif.

call function 'ES_APPEND_USER_SETTINGS'
exporting
  iaction        = 'PurchaseOrder'
  ielement       = 'DYN_4000-BUTTON TOGGLE_STATE'
  iactive        = '2' "1 = collapsed, 2 = expanded
*   IUNAME         = IUNAME
  isave          = 'X'
* TABLES
*   IESDUS         = IESDUS
  .

Other settings found in ESDUS:

Action	Element	Active	Description
MEPO	Application Po_Process	4500000001AX	ME22N/ME23N: Default document to open and it's display mode
MEPO	Application Req_Process	0019324803V	ME52N/ME53N/ME54N: Defualt document to open and it's display mode
MEPO	SAPLMEGUI/0000 Tree-On		ME22N/ME23N: Document overview X = display , empty = hidden
MEPO	SAPLMEGUI/0000 Tree-Width	374	ME22N/ME23N: Document overview width
MEPO	Tree-Control Tree-On		ME22N/ME23N: Document overview X = display , empty = hidden
MEPO	Tree-Control Tree-Width	374	ME22N/ME23N: Document overview width
MIGO_DEFAULTS	A01R01BWART	101	MIGO: default movement type for A01 (Goods Receipt) R01 (Purchase Order), by analogy to other actions and reference document types
MIGO_DEFAULTS	A01R01SOBKZ		MIGO: default special stock indication for A01 (Goods Receipt) R01 (Purchase Order), by analogy to other actions and reference document types
MIGO_DETAIL	ACTIVE_TAB	OK_GOITEM_MATERIAL	MIGO: Default active tab for details
MIGO_DETAIL_TOGGLER	VISIBILITY	X	MIGO: Colapse or expand Details section
MIGO_FIRSTLINE	A01	R01	MIGO: Default Referenced Document type for Action A01 (by analogy also for other actions)
MIGO_FIRSTLINE	ACTION	A04	MIGO: Default Action for transaction
MIGO_HEADER	ACTIVE_TAB	OK_GOHEAD_GENERAL	MIGO: Default active tab for header
MIGO_HEADER_TOGGLER	VISIBILITY	X	MIGO: Colapse or expand Header section
MIGO_TREE	DISPLAY	X	MIGO: Display Overview (X = display, empty = hidden)
MIGO_TREE	WIDTH	160	MIGO: Overview tree width
MIRO	ITEM_LIST_VERSION	7_6310	MIRO: Invoice Items Layout
MIRO	REFERENZBELEGTYP	1	MIRO: Default Reference Document Category
MIRO	TREEV_DISPLAY		MIRO: Display / Hide PO worklist
MIRO	TREE_DISPLAY	X	MIRO: Display / Hide PO structure
MIRO	VORGANG	1	MIRO: Transaction type
PurchaseOrder	DYN_4000-BUTTON TOGGLE_STATE	1	ME21N/22N/23N: Header section collapsed (1), expanded (2)
PurchaseOrder	DYN_4001-BUTTON TOGGLE_STATE	2	ME21N/22N/23N: Items section collapsed (1), expanded (2)
PurchaseOrder	DYN_4002-BUTTON TOGGLE_STATE	2	ME21N/22N/23N: Item details section collapsed (1), expanded (2)
PurchaseOrder	HEADER-TABSTRIP SUBVIEW_INDEX	1	ME21N/22N/23N: Default tab to be opened on Header section
PurchaseOrder	POHeaderProposer BSART	NB	ME21N/22N/23N: Default document type
PurchaseOrder	POHeaderProposer BUKRS		ME21N/22N/23N: Default Company Code
PurchaseOrder	POHeaderProposer EKGRP		ME21N/22N/23N: Default purchase group
PurchaseOrder	POHeaderProposer EKORG		ME21N/22N/23N: Default purchase organization
PurchaseOrder	POItemProposer AFNAM		ME21N/22N/23N: Default Requsitioner
PurchaseOrder	POItemProposer BEDNR		ME21N/22N/23N: Default Tracking Nr
PurchaseOrder	POItemProposer EEIND		ME21N/22N/23N: Default delivery Date
PurchaseOrder	POItemProposer ELPEI		ME21N/22N/23N: Default delivery Date category
PurchaseOrder	POItemProposer KNTTP		ME21N/22N/23N: Default Account Assignment Category
PurchaseOrder	POItemProposer LGORT		ME21N/22N/23N: Default Storage location
PurchaseOrder	POItemProposer WERKS		ME21N/22N/23N: Default Plant
PurchaseOrder	Shopping-Basket #1 DROP-ON	X	ME21N/22N/23N: Shopping basket on-off
PurchaseOrder	item_view SUBVIEW_INDEX	18	ME21N/22N/23N: Default Item Details tab
PurchaseRequisition	DYN_4003-BUTTON TOGGLE_STATE	2	ME51N/52N/53N/54N: Header section collapsed (1), expanded (2)
PurchaseRequisition	DYN_4004-BUTTON TOGGLE_STATE	2	ME51N/52N/53N/54N: Items section collapsed (1), expanded (2)
PurchaseRequisition	DYN_4005-BUTTON TOGGLE_STATE	2	ME51N/52N/53N/54N: Item details section collapsed (1), expanded (2)
PurchaseRequisition	REQ-HEADER-TAB SUBVIEW_INDEX	2	ME51N/52N/53N/54N: Default tab to be opened on Header section
PurchaseRequisition	ReqProposer AFNAM		ME51N/52N/53N/54N: Default Requsitioner
PurchaseRequisition	ReqProposer BEDNR		ME51N/52N/53N/54N: Default Tracking Nr
PurchaseRequisition	ReqProposer EEIND		ME51N/52N/53N/54N: Default delivery Date
PurchaseRequisition	ReqProposer ELPEI		ME51N/52N/53N/54N: Default delivery Date category
PurchaseRequisition	ReqProposer KNTTP		ME51N/52N/53N/54N: Default Account Assignment Category
PurchaseRequisition	Shopping-Basket #2 DROP-ON	X	ME51N/52N/53N/54N: Shopping basket on-off
PurchaseRequisition	req_item_view SUBVIEW_INDEX	11	ME51N/52N/53N/54N: Default Item Details tab
RM06BA00	USERVARIANT	SAP&STANDARD	ME5A: User variant
RM06BZ00	USERVARIANT	TEST	ME56/57: User variant
RM07DOCS	PA_AISTR	ARCHIVE	MB51: Default Archive Information Structure

Hope it will clear a bit how to use ESDUS and ESRUO tables!

ESDUS, ESRUO - MM settings table - Part 3/3

Eclipse Plugins for ABAP