Skip to Content
author's profile photo Former Member
Former Member

TEXT into the Cluster Tables.

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 ).

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 29, 2004 at 10:17 AM

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

    Sufficient documentation is given for this FM.

    Regards,

    Subramanian V.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 29, 2004 at 10:56 AM

    Hello Rajarshi,

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

    basictext-for-a-material

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.