Table T003 field LTEXT

[Former Member]

Hello gurus:

I'm trying to get field LTEXT from T003, but my workbench says

Unknown column name "LTEXT". not determined until runtime. You cannot specify a field list

This is my code:

FUNCTION Z_SAP_GET_MOVEMENTS_TYPE.

*"----

---

""Interfase local

*" IMPORTING

*" VALUE(MOV_CODE) TYPE RFPOSXEXT-BLART OPTIONAL

*" EXPORTING

*" VALUE(MOV_TEXT) TYPE CHAR40

*"----

---

DATA: BUFFER_TABLE TYPE T003.

call function 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = MOV_CODE

IMPORTING

OUTPUT = MOV_CODE.

SELECT SINGLE LTEXT

FROM T003

INTO CORRESPONDING FIELDS OF BUFFER_TABLE

WHERE BLART = MOV_CODE.

ENDFUNCTION.

I'm watching T003-LTEXT using se16 right now, why doesn't the workbench see it?

Thanks

Alejandro

[Former Member]

Hello gurus:

I'm trying to get field LTEXT from T003, but my workbench says

Unknown column name "LTEXT". not determined until runtime. You cannot specify a field list

This is my code:

FUNCTION Z_SAP_GET_MOVEMENTS_TYPE.

*"----

---

""Interfase local

*" IMPORTING

*" VALUE(MOV_CODE) TYPE RFPOSXEXT-BLART OPTIONAL

*" EXPORTING

*" VALUE(MOV_TEXT) TYPE CHAR40

*"----

---

DATA: BUFFER_TABLE TYPE T003.

call function 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = MOV_CODE

IMPORTING

OUTPUT = MOV_CODE.

SELECT SINGLE LTEXT

FROM T003

INTO CORRESPONDING FIELDS OF BUFFER_TABLE

WHERE BLART = MOV_CODE.

ENDFUNCTION.

I'm watching T003-LTEXT using se16 right now, why doesn't the workbench see it?

Thanks

Alejandro

[Former Member]

Check with table T003T. It contains Document Type Texts.

[RichHeilman]

You will need to hit the text table. T003T The reason that you see this via SE16 under table T003 is because the text table is linked to the primary table. SAP is handling the rest for you automatically. Programmically, you will needt to access the text table.

SELECT SINGLE LTEXT
<b>FROM T003T</b>
INTO CORRESPONDING FIELDS OF BUFFER_TABLE
<b>WHERE  SPRAS = sy-langu
  and  BLART = MOV_CODE.</b>

Please be sure to also check the lauguage key in your WHERE clause.

Regards,

Rich Heilman

[Former Member]

Thanks a lot... just wanted to add I won't use FROM CORRESPONDING FIELDS, just posted this like that because mybe I wasn't selecting the data correctly

Thanks Rich, Ashish and Phani.

Alejandro

[Former Member]

Hi,

You have to use T003T table for extracting the text.

Make sure to use the SPRAS field as input.you can use sy-langu.

Message was edited by: Phani Kiran Nudurupati