Skip to Content

gl account description??

in ska1 table when we pass the gl account number we can see the gl account description...but its not possible to write a select statement as it is not one of the field in ska1 table.

can anyone tell me where can i get this gl account description?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 03:22 AM

    Please use table SKAT which stores G/L Account description.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 28, 2007 at 03:22 AM

    Check the table SKAT - G/L Account Master Record (Chart of Accounts:Description)

    Regards

    Gopi

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 03:47 AM

    Hi shahid,

    what are the other tables u r using to get the GL discription. this GL discription we can get from SKAT table.

    suppose if u take BSEG table, then we define like this,

    TYPES: BEGIN OF t_skat,

    mandt TYPE mandt,

    saknr TYPE saknr,

    txt50 TYPE txt50,

    END OF t_skat.

    DATA: it_skat TYPE STANDARD TABLE OF t_skat WITH HEADER LINE.

    SELECT mandt

    saknr

    txt50

    FROM skat INTO TABLE it_skat

    FOR ALL ENTRIES IN it_bseg

    WHERE saknr EQ it_bseg-hkont.

    LOOP AT it_bseg.

    READ TABLE it_skat WITH KEY saknr = it_bseg-hkont.

    IF sy-subrc EQ 0.

    it_items-txt50 = it_skat-txt50.

    ENDIF.

    APPEND it_items.

    ENDLOOP.

    here it_items table is final out put table.

    by,

    sudharsan.

    Add comment
    10|10000 characters needed characters exceeded