topic AL11 - table behind in Application Development and Automation Discussions

AL11 - table behind

rainer_hbenthal — Tue, 02 Mar 2010 11:02:35 GMT

Hi,

which table is behind AL11? Table user_dir contains only some entries from AL11.

Re: AL11 - table behind

former_member194669 — Tue, 02 Mar 2010 11:10:57 GMT

If you look at program RSWATCH0 (AL11)


  CALL 'C_SAPGPARAM' ID 'NAME'  FIELD 'DIR_ATRA'
                     ID 'VALUE' FIELD searchpoints-dirname.

  MOVE: 'DIR_ATRA'           TO gs_outtab-sap_dir,
        searchpoints-dirname TO gs_outtab-dirname.
  APPEND gs_outtab TO gt_outtab.

a®

Re: AL11 - table behind

GauthamV — Tue, 02 Mar 2010 11:13:19 GMT

Check program RSWATCH0.


* get name of directory with the error files
  CALL 'C_SAPGPARAM' ID 'NAME'  FIELD 'DIR_HOME'
                     ID 'VALUE' FIELD searchpoints-dirname.

  MOVE: 'DIR_HOME'           TO gs_outtab-sap_dir,
        searchpoints-dirname TO gs_outtab-dirname.
  APPEND gs_outtab TO gt_outtab.
  CLEAR gs_outtab.

All directories are hard coded directly in different paths.

Table USER_DIR will store the directories only which we have created.

Re: AL11 - table behind

SuhaSaha — Tue, 02 Mar 2010 11:13:43 GMT

Hey Rainer,

I had debugged the program RSWATCH0 which is behind AL11 tcode.

You will be surprised except the entries in USER_DIR all the other directories viz. DIR_DATA, DIR_DBMS, DIR_EXECUTABLE etc. are hardcoded by SAP

The kernel call is used like this to get the directory details:

CALL 'C_SAPGPARAM' ID 'NAME'  FIELD 'DIR_TEMP'
                    ID 'VALUE' FIELD searchpoints-dirname.

For the user defined directories the code is like this :

* get the name and aliases of ALL userdefined directories
    SELECT * FROM user_dir INTO isearchpoints
      WHERE svrname = my_name.
      APPEND isearchpoints.
    ENDSELECT.
    SELECT * FROM user_dir INTO isearchpoints
      WHERE svrname = 'all'.
      APPEND isearchpoints.
    ENDSELECT.

Hope this helps.

BR,

Suhas

PS: Not a good coding practice by SAP to hard code the app server directories. I am sure there might be some for this though

Edited by: Suhas Saha on Mar 2, 2010 4:45 PM