quotations table

[Former Member]

hi

this is my problem: I have to retrieve a long text about a quotation, but I can't find which is the quotation table in db and where the text is saved.

Can anybody please tell me the name of the table in sap where quotations are saved?

thanks

Gabriele

[Former Member]

Quotations are stored in the EKKO table with Doc.Cat = A and Doc.type = AN.

Regards,

Omkaram.

[Former Member]

Hi,

Goto se11 and give * text * in table u can find lot of test oriented tables

[Former Member]

Hi,

Create your quotation, add the text and then save. Then goto SE16 table STXH add date created TDFDATE set to today and add your username - it will then show the text keys that you have created. You can then use that key in your program to read the texts...

use that key in READ_TEXT FM

Regards

Stu

[Former Member]

this could be helpful, but my complete problem is this:

I'm enhancing VA01 to alert the user, when creating an order from a quotation, if there are note present in the quotation. So I don't know nothing about the quotation, I have only its quotation id

[Former Member]

HI,

Sorry, I have given table for Request for Quotations....in the previous thread...

For quotations go to VBAK table...Doc.Category = B.

Edited by: Omkaram Yanamala on Oct 7, 2008 3:32 PM

[Former Member]

more detail added

[Former Member]

Hi,

The quotation ID is probably all you need.....

From my above post you can derive the text key...

TDOBJECT and TDID will be constant

TDNAME will be the quotation number (if the text is at header level)

you should be able to form the key and read STXH to see if there is a text associated with the quotation - then if you need you can ten read that text using READ_TEXT

Regards

Stu.

[Former Member]

thank you very much, I am a step far from the solution:

I have TDOBJECT (VBBP)

TDNAME is the id of my quotation .. but is there a way to retrieve the TDID? I see as you show me the entry of today about quotations, and I see all quotation created, but I also saw that each entry has its own trdid, so ... how do I fill that field in READ_TEXT if I don't know that field?

thank you very very much for your help

[Former Member]

Hi,

The TDID is the configured text id - it will always be the same for the same type of text - for example in sales orders on the header texts each different type of text type will have a different TDID. For a particular type - shipping instructions for example - will have the same TDID on all texts for sales order shipping instructions for all orders. Check the STXH table you will see lots of values with the same TDOBJECT and TDID for different TDNAME

If you want a specific ID populate ID and it will retrieve. If you check the 'Display Log' on the header texts you will see all the relevant TDID values.

If you need them all add them all to your code and read for each one. You will be able to derive the relevant values from the relevant config table...

Regards

Stu.

[Former Member]

Hi,

Have a look at transaction VOTXN to see the relevant TDID for Sales Quotations

Table TTXID for object VBBP

Regards

Stu

Edited by: Stu Murray on Oct 7, 2008 1:05 PM

[Former Member]

T H A N K Y O U V E R Y M U C H I S O L V E D I T