extract the item texts from invoice

[was_wasssu]

HI,

I want to make a query and to extract the item texts (only one particular text) from an invoice (VF03).

The item text are in the STXL table? What is easiest way to extract the texts? Is any function to call? And what are the parameters for STXL access?

Thak you.

Edited by: Was Wasssu on Jul 8, 2009 9:53 AM

[Former Member · Accepted solution]

Hello

Please check here:

<a href="http://searchsap.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid21_gci854323_mem1,00.html">http://searchsap.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid21_gci854323_mem1,00.html</a>

It contains the answer to your question. You can use function module 'READ_TEXT' to get data

STXH and STXL contain the information you need.

For invoices TDOBJECT should be VBRK

Regards

Rafal

[was_wasssu · Accepted solution]

i don't have access to that site.

[Former Member · Accepted solution]

Hi

You can register. Its free.

But you don't find more info that what I said.

You can use mentioned function module

regards

Rafal

[was_wasssu · Accepted solution]

I don't have access. The access to that site is blocked.

I don't know how to access the STXL table, what values to insert for the fields:

RELID

TDOBJECT

TDNAME

TDID

TDSPRAS

SRTF2

CLUSTR

in order to find the text for a specific invoice number and position.

Thank you.

Edited by: Was Wasssu on Jul 8, 2009 10:35 AM

[Former Member · Accepted solution]

This message was moderated.

[was_wasssu · Accepted solution]

First of all, i have to use STXH and VBRK for the posìitions of the invoices? Or STXL and VBRP?

[Former Member · Accepted solution]

you use only the function module I mentioned (table only via SE16 to check possible entries)

It will provide a data for you as I described above.

You only use OBJECT = VBRK in that function module and system will read all required data

VBRK is for texts in header

I you need texts on item level you use OBJECT = VBRP

I hope that now its clear

regards

Rafal

Edited by: Rafal Drezek on Jul 8, 2009 1:55 PM

[was_wasssu · Accepted solution]

Clear.

But now i think the problem is the ID because with 0001, 0002, etc. it shows nothing.

[Former Member · Accepted solution]

Please test this with new invoice

Add texts and check if entries in STXH STXL tables will be created (in SE16 you can simply check "Nr of entries"

Use the same invoice in function module test

regards

Rafal

[Former Member · Accepted solution]

ok. I quickly checked

for item its different then for header test

NAME = doc.number only for header

for item is like this

NAME = doc.number + item nr

example

2233413286000010

where 2233413286 is doc. nr and 000010 is pos nr

I hope now its clear

You can always check created entries in STXH

regards

Rafal

Edited by: Rafal Drezek on Jul 8, 2009 2:45 PM

[was_wasssu · Accepted solution]

I've made the test, interting the text on the position: one record added in the STXH and one in the STXL.

I've run read_text with id 0001 but... nothing :(. How can i see what records added, the tables have millions of records?

Thank you

[Former Member · Accepted solution]

"How can i see what records added, the tables have millions of records"

Quite easy.

Use TDFUSER in the selection criteria for STXH

TFDDATE and TFDTIME can be used as well

Please check description of fields via ST12

regards

Rafal

Edited by: Rafal Drezek on Jul 8, 2009 2:56 PM

[was_wasssu · Accepted solution]

I did it. Thank you for your help.

The NAME was the invoice number and the position and the OBJECT was VBBP. The ID was 0001.

Thank you!

[Former Member]

Hi ,

you can use function module 'READ_TEXT' and pass the values that you define in Text copy controls.

Please let me know if you still need any more help.

Thanks and regards.

Rajeshwar.

[Former Member]

sorry Rajeshwar, but is NEW in the answer you posted ???

Have you read whole conversation ?

regards

Rafal