Error message in SLG1

[Former Member]

Can anyone suggest from which table do we get the error message text for error logs in SLG1.

[Former Member]

Hi,

Tables: BALHDR is the main (header table), and BALM contains all of the detailed messages.

Check this link also.

http://abap4.tripod.com/Using_Application_Logging.html

[GauthamV]

Use these tables.

BALHDR

BALHDRP

BALM

BALMP.

[Former Member]

SELECT * FROM balhdr CLIENT SPECIFIED
             INTO TABLE e_t_log_header
             WHERE mandant      =  i_client
               AND log_handle   IN i_s_log_filter-log_handle
               AND lognumber    IN i_s_log_filter-lognumber
               AND extnumber    IN i_s_log_filter-extnumber
               AND object       IN i_s_log_filter-object
               AND subobject    IN i_s_log_filter-subobject
               AND aldate       IN i_s_log_filter-aldate
               AND altime       IN i_s_log_filter-altime
               AND alprog       IN i_s_log_filter-alprog
               AND altcode      IN i_s_log_filter-altcode
               AND aluser       IN i_s_log_filter-aluser
               AND almode       IN i_s_log_filter-almode
               AND probclass    IN i_s_log_filter-probclass
               AND
        ( aldate = l_s_dttm-date_from AND altime >= l_s_dttm-time_from
                                      AND altime <= l_s_dttm-time_to ).

SELECT * FROM baldat CLIENT SPECIFIED
                    INTO TABLE l_t_baldat
                    FOR ALL ENTRIES IN l_t_balhdr_current
                    WHERE mandant    = l_t_balhdr_current-mandant
                      AND relid      = 'AL'
                      AND log_handle = l_t_balhdr_current-log_handle.

This is where the query is occured for fetching logs...

cheers

S.Janagar

[Former Member]

Can anyone suggest exactly which field of which table holds the error message text of SLG1