10-07-2008 10:40 AM
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
10-07-2008 11:13 AM
10-07-2008 10:53 AM
Quotations are stored in the EKKO table with Doc.Cat = A and Doc.type = AN.
Regards,
Omkaram.
10-07-2008 10:54 AM
Hi,
Goto se11 and give * text * in table u can find lot of test oriented tables
10-07-2008 11:01 AM
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
10-07-2008 11:13 AM
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
10-07-2008 11:02 AM
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
10-07-2008 11:13 AM
10-07-2008 11:30 AM
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.
10-07-2008 11:49 AM
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
10-07-2008 12:00 PM
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.
10-07-2008 12:03 PM
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
10-07-2008 1:13 PM