Get comments texts from SAP

In many transaction, SAP stores comments in different table. For example if you want to get comments texts on Item detail of Purchasing order , belive me you will not find on table EKPO (Item table of purchasing order). So you need a function and some object or id to get the comment. You can find object by entering table STXH-TDNAME with Purchasing order number plus asterisk (because STXH-TDNAME contains PO Number plus Item number of PO). STXH-TDNAME = ‘4500002131*’ will be bring back object, name, and id as parameter on function module READ_TEXT.

The following code is a function that will return PO Item text :

data: begin of tlinetab occurs 100.
             include structure tline.
data: end of tlinetab.
data: po_no    like ekpo-ebeln,
          po_item  like ekpo-ebelp,
          thead    like thead,
          line_cnt type n,
          tdname   like thead-tdname.

select single ebeln ebelp
  into (po_no, po_item)
  from ekpo
  where ebeln = ‘4500002131′
    and ebelp = ‘10′.

concatenate po_no po_item into tdname.

call function ‘READ_TEXT’
       exporting
            id = ‘F01′
            language = sy-langu
            object = ‘EKPO’
            name = tdname
       importing
            header = thead
       tables
            lines = tlinetab
       exceptions
            id = 1
            language = 2
            name = 3
            not_found = 4
            object = 5
            reference_check = 6
            wrong_access_to_archive  = 7
            others = 8.

  if sy-subrc = 0.
    loop at tlinetab.
      write / tlinetab-tdline.
      add 1 to line_cnt.
    endloop.
  endif.

Good luck …!