gl account description??

[shahid]

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?

[Former Member]

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

[gopi_narendra]

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

Regards

Gopi

[Former Member]

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.