Sale Order Item Level Text Field which table and field

[Former Member]

Hi,

Thanks for your prompt reply and best solution.

Can you please tell me one more thing, in sale order at item level the TEXT Field maintaining by user at transaction level now they want that field in one of the report, so can you please tell what is the table and field where i will get this sale order item level text details.

[Former Member · Accepted solution]

Hello Nitin,

These Texts are not saved in some specific Table or Field. It has a different concept altogather. You can get this text using a Function Module called "READ_TEXT"

This Function Module will require below mentioned details to read and fetch the Text.

1. CLIENT

2. TEXT ID

3. LANGUAGE

4. TEXT NAME

5. TEXT OBJECT

Hope it helps.

Thanks & Regards,

HP

[Former Member · Accepted solution]

Hi,

is this going to work for item level text as well.

can you tell how to proceed with this functional module or is there any other thing required.

Please elaborate to understand better way.

[sarthak_mohantysd · Accepted solution]

Hello,

is this going to work for item level text as well.
can you tell how to proceed with this functional module 
or is there any other thing required.Please elaborate to 
understand better way.

You can check out two table in respect to Sales TEXT i.e. STXH (STXD SAPscript text file header) and STXL(SAPscript text file lines).

The best approach of tracing out the Text in respect to Sales Order would be to use the Function module READ_TEXT and put this FM in SE37 and execute with the following parameter.

1. Client

2. Text ID of text to be read

3. Language of text to be read

4. Name of text to be read

5. Object of text to be read

6. Archive handle

7. Text catalog local

When you are essentially looking to read item level Text with respect to Sales Order then your Text OBject would be VBBP.

Regards,

Sarthak

[Former Member · Accepted solution]

I wil try and let you know,

Point rewarded.

[Former Member]

Thanks for valuable information,

I will revert on same till the time, marking as answer.

[former_member183879]

Hi,

READ_TEXT is the FM to be used in any case to fetch the text field.

The parameters are as follows.

Client : Self explanatory

ID : This refers to the text ID say Z001

Language : The language in which the text is entered in the sales order

NAME : This is the concatenation of the sales order and the line item number. ex 0098765410 where 00987654 is the order and 10 is the line item number

OBJECT : This is the object under which the text id is created, say KNVV or VBBK etc. This can be foudn out in VOTXN for the text id

Archive handle : 0 (I think it is capital o, try both o, small form o or with zero)

Local_cat : - This is optional and can be left out.

If this is provided as import parameters, the output will give the text available in the sales order for the text id.

Hope this helps