TEXT into the Cluster Tables.

[Former Member]

A material (eg mat05) is maintained in a material master.

A purchase order text is maintained for that particular,in <b>STXH</b> table.The Text ID,Text Name,Object ID,Spras are stored along with the TDNAME ( the long text ).I know these data are stored into <b>STXH,STXL</b> tables and some cluster tables.Can someone help me informing about the <b>Cluster Tables</b>( Specially on PO text ).

[Former Member]

If you want to read the text, then use FM <b>READ_TEXT</b>

Sufficient documentation is given for this FM.

Regards,

Subramanian V.

[Former Member]

Hello Rajarshi,

There was a somewhat similar query sometime back which I shall point you to.

Besides, here's the code which would get you the purchase order texts for a given material -

parameters: p_matnr type matnr.

data: temp_text type table of tline with header line,
      where_cond(20) type c.

data : begin of text_id ,
         tdobject(10) value 'MATERIAL',
         tdname(70),
         tdid(4)  ,
         tdspras      value 'E',
       end of text_id.

start-of-selection.

  concatenate '%'
              p_matnr
              '%'
         into where_cond.

  select tdname
         tdid
    from stxl
    into (text_id-tdname , text_id-tdid)
   where relid   = 'TX' and
         tdspras = 'E'  and
         tdname like where_cond.

  import tline = temp_text[]
    from database stxl(TX)
      id text_id.

   write: / sy-subrc.
   loop at temp_text.
     write : / temp_text-tdline.
   endloop.

 ENDSELECT.

Hope this is what you were looking for.

Regards,

Anand Mandalika.