What is the Table and Field of the Item Texts inside the Text tab in ME23N?

[walkerist]

Hi, I'm trying to get the text in Item Text and Info Record PO text and display it on my ALV and document. However, I'm not sure with the field and table where it came from. Any tip is appreciated.

[venkateswaran_k]

It is not stored in a table.

However, you can access it through Function module READ_TEXT

[venkateswaran_k]

Is this what you are looking for ? do you need any other info?

[venkateswaran_k]

Hi

Is your question is answered?

[Sandra_Rossi]

Answer already given, just search with your question title in SAP Web site:

What is the Table and Field of the Item Texts inside the Text tab in ME23N? site:sap.com

[venkateswaran_k · Accepted solution]

Hi

Apart from above answers

You can read the Item text using following FM. The Respective IDs are mentioned in the image.

CALL FUNCTION 'READ_TEXT'
  EXPORTING
*   CLIENT                        = SY-MANDT
    id                            = 'F01'
    language                      = SY-LANGU
    NAME                          = <your Puchase order number><Item number> "4000000012000010 
    OBJECT                        = 'EKPO'
*   ARCHIVE_HANDLE                = 0
*   LOCAL_CAT                     = ' '
* IMPORTING
*   HEADER                        =
*   OLD_LINE_COUNTER              =
  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
          .
IF sy-subrc <> 0.
* Implement suitable error handling here
ENDIF.

Regards,

Venkat

[venkateswaran_k · Accepted solution]

Hi walkerist

Is this working now?

[venkateswaran_k · Accepted solution]

Hi walkerist

Is this issue resolved? If so you can accept the answer and close the thread.

[walkerist · Accepted solution]

venkateswaran.k what should be the table type of the internal table it_lines?

Also I'm not quite sure how to use the code below. Assuming the purchase order # is 5000123 and the item number is 1044592. SHould it be concatenated like 50001231044592?

   NAME                          = <your Puchase order number><Item number> "4000000012000010 

[walkerist · Accepted solution]

venkateswaran.k Also, this CX_SY_DYN_CALL_ILLEGAL_TYPE is being caught.

[venkateswaran_k · Accepted solution]

It should be order number and Item sequence number - not the material number

4000000012 + 000010

[Sandra_Rossi · Accepted solution]

walkerist

You can get the answer by looking at the table STXH.You can get the answer about CX_SY_DYN_CALL_ILLEGAL_TYPE by searching the Web, it has been already asked.

[walkerist · Accepted solution]

venkateswaran.k Hi, it is working now. However, it doesn't work on some Purchase Orders like this one. I was trying to get the text of "INFO RECORD PO TEXT". I tried debugging it but no value is being shown. Only this purchase order is affected and the code is not working for this PO.

[venkateswaran_k · Accepted solution]

This is because of blank lines at the beginning. You need to delete the balnk rows once it_lines ( read from READ_TEXT fm)

[ankurch]

STXH - Header

STXL - Item

[raymond_giuseppi]

Those are "long texts" header table is STXH and lines table is STXL, the last one (data cluster) must be read using FM such as READ_TEXT or READ_TEXT_TABLE (or IMPORT FROM DATABASE for experts only...)

• Be aware that such 'long' texts can (and will) overflow maximal size of ALV grid cells.
• You can identify keys of the table/parameters of the FM by displaying those long texts in full screen (double-click on text area) and navigate in menu : goto, header for language, text id and object, name should usually be either PO number or PO number + Item number.
• Table TTXID or Customizing or Transaction SE75 will provide you a list of the text ids defined for objects such as EKKO and EKPO.

If you actually want to know 'where it came from', check in Customizing, some texts are input some are copied from previous document or from master data (material, vendor, PIR, etc.)

[FredericGirod]

Table TTXID / TTXIT

it is customizing