Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Texts tab in Item Data of VA03 screen

Former Member
0 Kudos

Hi Experts,

Wish you all a very happy new year.

I work in the BW system but today I need to know the field and table details of a field in VA03 screen. I need the details so that I can extract the data to BW system for a report. As I need only the table and field details I'm posting this question in this forum.

In VA03 screen when you double click on an item you are taken to the "Item Data" screen. There you have a tab called "Texts". I need to know from where the system gets the data to that screen.

I tried the SQL trace and tried debugging also. I could see that the system is using STXH, STXL and TAXITABS tables. But the STXH table has something like

FF060101020280003431303200000000F3090000121F9D027FCC7C0C0C0C8C3C40828195011B0861F061F064F063705D0B51B90A2CCA02A61839D64104F741CD

or

FF06010102028000343130320000000063010000121F9D021D331F030303230F90606065C00642187C183C19FC185CD74254AE028BB28029468E7510C17D5033

or

FF060101020280003431303200000000DF540000121F9D02D2BED9B5460D4461F82D56F042FC0DF1CA0FB06C92FD6A1141EC420BB6BDB0205EAEB5BB6D5DAD6C

If this is how sap stores it then how do I decode it to use it in BW report? Can anyone help with the code to decode.

If the system stores them in a different manner and in a different table then please post a reply with the details.

I will not forget to say thanks the SDN way.

Cheers,

Sujit.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Sujit,

The texts which are entered as free texts are not saved directly as fields...

We need to use the function module READ_TEXT to retrieve them....

There will be some fields that need to be passed to the function module..that needs to be understood

The easy way to undetstand how to get the function module data to be passed to retrieve the fields is to go to VA02..enter some text -> put a break point for abap command..call funtion 'SAVE_TEXT'...

When it stops there..pick all the values passed and pass the same to read_text in se37 to get all the data saved as text....

For BI Extraction..this data needs to be read using the function module as above and saved as maybe a character field(character field needs to be created in the extract structure/source)....

Hope it helps

Regards

Byju

8 REPLIES 8

Former Member
0 Kudos

VA03 - Sales Orders ., the following is hig level ;

VBAK - Sales Order Header Data .

VBAP - Item data .

Item text are maintied table - STXH based on the sales order number + item number ....

For detail : go to - http://www.cfin.ru/forum/messages/2868/saptables-39438.pdf

and look for SD tables ..

Thanks,

Adi

Former Member
0 Kudos

Hi Sujit,

The texts which are entered as free texts are not saved directly as fields...

We need to use the function module READ_TEXT to retrieve them....

There will be some fields that need to be passed to the function module..that needs to be understood

The easy way to undetstand how to get the function module data to be passed to retrieve the fields is to go to VA02..enter some text -> put a break point for abap command..call funtion 'SAVE_TEXT'...

When it stops there..pick all the values passed and pass the same to read_text in se37 to get all the data saved as text....

For BI Extraction..this data needs to be read using the function module as above and saved as maybe a character field(character field needs to be created in the extract structure/source)....

Hope it helps

Regards

Byju

Former Member
0 Kudos

Hi

Texts are stored as RAW data type in STXH and STXl..

You will have to make use of READ_TEXT FM in order to get texts...

you could write a program not quite big to retrieve the same for all orders at a go and pass to BI.

Revert if u need anything more..

Former Member
0 Kudos

Hi Byju and Ankesh,

Thanks for the replies.

I did go through the FM READ_TEXT. But it is quite big as Ankesh said. Can you provide me a small piece of code which can decode LRAW type field of STXH table or the program details that needs to be created?

If I use the function module for extracting data then how do I get the input parameters needed? It needs around 6 input parameters.

Sujit.

0 Kudos

Hi Sujit,

Please open any text and do GOTO -> Header

Here you will get 3 properties

Text ID

Text Name and Text Object

CLIENT = sy-mandt

ID = Header - text id

LANGUAGE = sy-mandt

NAME = usually for orders it is VBELN + POSNR..item wise texts so concat these 2 values

OBJECT = header text object..

Only variable will be your variable name... you could select say the order number and its items..(posnr)

concat and get the data from FM for each VBELN+POSNR..

Any SD or ABAP consultant will be able to guide you very quickly..

Edited by: Ankesh on Jan 8, 2009 10:23 PM

0 Kudos

Hi Ankesh,

Thanks for the information you gave. The fields that we get from header thing are present in STXH table.

So the conclusion is the raw field from STXL table can be read using READ_TEXT function module with the help of input parameters from STXH table.

Points assigned.

Regards,

Sujit.

Former Member
0 Kudos

The conclusion is the raw field from STXL table can be read using READ_TEXT function module with the help of input parameters from STXH table.

Former Member
0 Kudos

The solution is in this web-site the post is in spanish but doesn't matter. All is explained step by step.

Obtener Textos Cabecera, Funct. 'READ_TEXT' - Tutoriales - Ayuda SAP

Regards.