which table does sales text store?

[Former Member]

Hi, does any guy know, which table does sales text store?

(The sales text path is : xd02 -> sales area data -> Extra -> Texts.)

Thanks great.

[Former Member]

hi,

to get the text from a t-code (XD02 in your case) you have to use the FM READ_TEXT as follwos:

call function 'READ_TEXT'

exporting

client = sy-mandt

id = c_id

language = c_lang

name = v_text "is the order no

object = c_obj " is the field

tables

lines = h_lines

exceptions

id

language

name

not_found

object

reference_check

wrong_access_to_archive.

thanks,

anupama.

[Former Member]

I think STXL table and the TDOBJECT as KNA1 .The text are stored in LRAW form and to read the same you can use READ_TEXT Function module.

[Former Member]

Hi,

Sales text is stored in encrypted form in the database table. You cannot directly read it from database table. but you can use the function modue READ_TEXT to do so. The related table is STXH

check the below link for your reference

http://sap.ittoolbox.com/groups/technical-functional/sap-abap/va03-sales-order-text-field-2084723

http://www.sap-img.com/abap/use-fm--read-text-to-read-the-various-text.htm

regards,

John

[Former Member]

Hi,

Sales text is stored in encrypted form in the database table. You cannot directly read it from database table. but you can use the function modue READ_TEXT to do so. The related table is STXH and STXL

check the below link for your reference

http://sap.ittoolbox.com/groups/technical-functional/sap-abap/va03-sales-order-text-field-2084723

http://www.sap-img.com/abap/use-fm--read-text-to-read-the-various-text.htm

regards,

John

[Former Member]

Hi Yimeng ,

Generally you cannot access the text directly form table , you will have to use the fm READ_TEXT to read the text . Please debugg your application putting a break point in the above said FM and check the parametrs being passed to the FM.

Regards

Arun

[Former Member]

Use READ_TEXT.

[sudhir_uppalapati]

Hi,

Use FM READ_TEXT.

double click on the text>Goto>Header.

Here u can find the text id & text object.

[Former Member]

Hi,

VBAK Sales Document: Header Data

VBAP Sales Document: Item Data

VBBE Sales Requirements: Individual Records

VBEP Sales Document: Schedule Line Data

VBFA Sales Document Flow

VBLB Sales document: Release order data

VBLK SD Document: Delivery Note Header

VBPA Sales Document: Partner

VBUK Sales Document: Header Status and Administrative Data

VBUP Sales Document: Item Status

Regards:

Alok

[Former Member]

Hi,

You directly will not be able to read the texts.

You can access them through READ_TEXT FM.

Hope this helps u.

Thanks & Regards