Text in Salesorder, Which Table does it get saved

[Former Member]

Hi,

In a salesorder TCode VA01, at the header level, on the text tab, when I enter any text, in which table does it get saved?

Thanks and Regards,

Mick

[Former Member]

Hi,

It gets stored in stxh & stxl tables. This may be retrieved by using FM

'READ_TEXT_INLINE'

I hope this helps,

Regards

Raju Chitale

[Former Member]

Hi,

Check STXH ==> for header level data

STXL ==> for item level data

But you need to know object id, object name parameters.

Object name would essentially be your sales order no.

Object id would be the text id of the text.

Regards,

Siddhesh S.Tawate

[Former Member]

Hey fren,

There is no Text tab in Tcode VA01......

Generally the text is saved in the respective field defined for the same at header level.

In this case it is stored in the header table --> VBAK -- KTEXT.

and for new Tcodes......like VL01N.......sort of...

it is stored in table STXH and STXL....in raw format....

<REMOVED BY MODERATOR>

Warm Regards,

Abhi

Edited by: Alvaro Tejada Galindo on Apr 7, 2008 12:46 PM

[Former Member]

They are stored in the tables

STXH Header

STXL Item

We need to use FM READ_TEXT to read the texts from these tables

[Former Member]

There is something related I found in SDN wiki..

Where are the long texts of a document stored and how to access the same?

The long texts of a document are stored in a encrypted format in the STXH and STXL tables, where STXH stores the header information of the

long text like TDOBJECT, which indicates which text object the long text belongs to, TDID which indicates the Text ID and TDNAME which is

the actual name of the long text.

As these texts are stored in a encrypted format, the text cannot be read using a SELECT statement. You will have to use the function READ_TEXT. The easiest way of getting to know the parameter values is to go to a document, open the long text in a full screen mode. For example, when you wan to see the long text for a Purchase order, go to transaction ME23n. Assume, you want to see the parameters for the Header Text. In the first Tab Strip Control, click on the Texts tab and select the Header Text node on the left hand side, which will display the text on the right hand side. Now, double click on the text editor on the right hand side. This will open the text in the full screen mode. In the menu Go To --> Header, you should be able to see the values for all the three parameters we discussed above. We will have to do the same thing for whichever text parameters we want to see.

CALL FUNCTION 'READ_TEXT'

EXPORTING

• CLIENT = SY-MANDT

ID =

LANGUAGE =

NAME =

OBJECT =

• ARCHIVE_HANDLE = 0

• LOCAL_CAT = ' '

• IMPORTING

• HEADER =

TABLES

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.

G@urav.

[Former Member]

Sorry for the delay.

Really appreciate the detailed explanation.

Points awarded.

Thanks to everyone who tried to help. Points awarded to the others also.

Regards,

Mick

[Former Member]

Hello,

About this topic, is there anyone that know how to catch the temporary contents of the text BEFORE saving the document?

My problem is the following one: for a particular sales order type I need to check if the user filled some mandatory sentences. I'm not able to catch the text before saving but only after saving.

Could you please help me?

Thansk in advance,

Fabio