hi all,
anybody knows what table stores the production order text ?
Thanks.

u should be able to change / delete the same in GTM in tisfc001 with choice H (textmanager) . U dont need to search where exactly it is stored.

TTTXT010 contains all text information. Textnumber and language in the related tables (in your case production orders, tisfc001) is the key to this table.

Martin

dear Gurus,
if i want to make a link between production order and sales order by using production order text (will contain only 1 line = 9 characters), can the field ctxt (Text Number) in table ttxt010 be used as the key to get the job done? :cool:

Thanks.

best regards,
Richard Citra.

Best way to get it done is to use production ordertext to store the salesordernumber, in your report use the function text.to.buf to store the textline of the production ordertext in a string. After that, function val(string) can be used to make it a number which can be used in a select statement on table tdsls040.

text.to.buf()
Syntax

long text.to.buf( string text_field(17), string lang, long nr_lines, ref string buf(,) [, long rtf.text] )
Description

This stores the text of a specified text field in a two-dimensional string array.
Arguments

text_field

The name of the text field that must be retrieved. See Text fields: overview.

lang

This specifies the relevant language.

nr_lines

This specifies the maximum number of lines that can be stored in the buffer.

buf

This specifies the buffer in which the text must be stored.

rtf.text

Set this argument to true if you want the text to be stored in RTF format instead of ASCII format. This is possible only when using a text group that supports RTF data.
Return values

>0 number of stored lines
0 error
-1 no permission to store the text

Context

3GL library function.

This function stores the text of a buffer in the specified multiline text formfield. This is only relevant for multiline text formfields in a non-maintable session. An additional 'display' of this field is needed to see the changes on the form.

Good luck.

Regards,
Klaas