inspection text of a material table

[Former Member]

Hi,

In MM01 ,the field called additional data in which there is a column called Inspection Text ,i want to the entry of this field is stored in which table?

plzz provide me guidlines to solve this problem.

[Former Member]

Hi,

It is stored in the STXH/STXL tables

you

need to use read_text function module as follows :

data: g_name like thead-tdname,

data: it_lines like tline occurs 0 with header line.

g_name = mara-matnr. " For parameters compatability pass material nr. to

this parameter

CALL FUNCTION 'READ_TEXT'

EXPORTING

ID = 'PRUE' " Text Id for inspection

text

LANGUAGE = sy-langu

NAME = g_name

OBJECT = 'MATERIAL'

TABLES

LINES = it_lines

EXCEPTIONS

ID = 1

LANGUAGE = 2

NAME = 3

NOT_FOUND = 4

OBJECT = 5

REFERENCE_CHECK = 6

WRONG_ACCESS_TO_ARCHIVE = 7

OTHERS = 8.

Internal table IT_LINES would contain the inspection text for the material.

regards,

safel

[Former Member]

what is the reason behing it that it is stored in these format as not in the normal database tables.

plzz provide me the reasoning behind this methodology.

Moreover, i am trying to make a small report on it ,so that i can see that these are the items which are having inspection text can be carried out.

here's d sample code for it:-

report Znew10 no standard page heading LINE-SIZE 310.

DATA:  tlines LIKE tline OCCURS 0 WITH HEADER LINE,
       wlines(60),
       tdname LIKE thead-tdname,  " VALUE '000000000000220644',
       tdheader LIKE thead,
       wa_itcpo TYPE itcpo.     " To Set Printer option and give default printer Name

PARAMETER: item like mara-matnr.

CONSTANTS: text_id  LIKE thead-tdid     VALUE 'PRUE',
           text_obj LIKE thead-tdobject VALUE 'MATERIAL'.
           wa_itcpo-tddest = 'PRN'.     " Default Printer.

**** Need to pass Material # in 18 digit and add varible in SAPScript
**** to Print this value....
  CALL FUNCTION 'READ_TEXT'
    EXPORTING
*   CLIENT                        = SY-MANDT
       id                            = text_id
      language                      = 'E'
      name                          = tdname
      object                        = text_obj
*   ARCHIVE_HANDLE                = 0
*   LOCAL_CAT                     = ' '
* IMPORTING
*   HEADER                        =
    TABLES
      lines                         = tlines
   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.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
  ENDIF.

  CLEAR: wlines.

  LOOP AT tlines.
    IF tlines-tdline NE ' '.
      CONCATENATE tlines-tdline wlines INTO wlines SEPARATED BY ','.
    ENDIF.
  ENDLOOP.

  LOOP AT tlines.

    WRITE:/ wlines.

  ENDLOOP.

Edited by: ricx .s on May 21, 2009 11:00 AM

[Former Member]

hi,

According to storage mode, the text object is stored in a text file, the text line are stored seprately in speical cluster tables.

Regards,

Kimaya

[Former Member]

Click [here|http://help.sap.com/saphelp_45b/helpdata/en/ff/515f2949d811d182b80000e829fbfe/frameset.htm] to get more information about Inspection Text of material master

We can achieve this functionality by using the Function Module u2018CREATE_TEXTu2019

[Former Member]

Hi,

The Inspection text is stored in tables STXH and STXL , you can get the values in program using function module read_text , paramters will be RELID = 'TX' , TDOBJECT = 'MATERIAL', TDNAME = Material Code and TDID = 'PRUE'.

I hope your issue is solved.

[former_member342013]

hi

SELECT SINGLE *

FROM stxh

INTO wa_stxh

WHERE tdid = 'PRUE'

AND tdobject = 'MATERIAL'

AND tdname = wa_final-matnr

AND tdspras = 'EN'.

IF sy-subrc = 0.

CALL FUNCTION 'READ_TEXT'

EXPORTING

id = 'PRUE'

language = 'E'

name = wa_stxh-tdname

object = 'MATERIAL'

TABLES

lines = lines

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.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

[Former Member]

how should i specify the item id code to it,it is possible to use the inner join for it.

plzz proivde me guidlines for it as i need some help about it.

Edited by: ricx .s on May 22, 2009 5:15 AM

Edited by: ricx .s on May 22, 2009 7:10 AM