topic Re: which table does sales text store? in Application Development and Automation Discussions

which table does sales text store?

Former Member — Tue, 13 Jan 2009 08:07:09 GMT

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

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

Thanks great.

Re: which table does sales text store?

Former Member — Tue, 13 Jan 2009 08:14:49 GMT

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

language

name

not_found

object

reference_check

wrong_access_to_archive.

thanks,

anupama.

Re: which table does sales text store?

Former Member — Tue, 13 Jan 2009 08:35:04 GMT

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.

Re: which table does sales text store?

Former Member — Tue, 13 Jan 2009 08:42:02 GMT

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

Re: which table does sales text store?

Former Member — Tue, 13 Jan 2009 08:48:48 GMT

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

Re: which table does sales text store?

Former Member — Tue, 13 Jan 2009 08:52:46 GMT

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

Re: which table does sales text store?

Former Member — Wed, 21 Jan 2009 11:09:56 GMT

Use READ_TEXT.

Re: which table does sales text store?

sudhir_uppalapati — Wed, 21 Jan 2009 12:13:40 GMT

Hi,

Use FM READ_TEXT.

double click on the text~~>Goto~~>Header.

Here u can find the text id & text object.

Re: which table does sales text store?

Former Member — Thu, 22 Jan 2009 04:42:29 GMT

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

Re: which table does sales text store?

Former Member — Thu, 22 Jan 2009 07:19:09 GMT

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