08-18-2004 11:53 AM
Hi. Does anybody know what the temporary order table names are for vbak, vbap before a sales order is saved? I need to query the information in a user exit before the order is written to the permanent tables.
Thanks.
08-18-2004 4:26 PM
Depends on the exit you are wanting to use (and I assume you want the internal table - memory areas- where the data is that will be written to the database). But if you are using userexit_save_document in MV45AFZZ, look at xvbap for vbap but take special notice of the update indicator - field UPDKZ. For VBAK use vbak. This would be the memory area created by the TABLES statement for VBAK. It will be holding the information that will be written to the database table VBAK.
08-18-2004 12:09 PM
I found TXW_S_VBAK, but I think is only for imported sales order...
I was looking at SAP tables and could not found nothing like you are asking for (I'm a programmer, and new to SAP, have not the knowledge of all the DB), but I guess there is nothing like you are looking for, I think the order is saved in the normal tables, with some indicator about if the order is coursed or not.
Just what I think, maybe it can be helpful while a guru could read and answer you.
Good luck,
Vicenç
08-18-2004 1:05 PM
Hi Brendan,
I do not know the answer to your question, but there's one option that you might want to try out.
When you get into debugging, there's an option called <i>"Update Debugging"</i>. When you use this option, you will be able to see all the statements that the system executes whenever there's a COMMIT WORK statement.
Try this out for the COMMITS in the sales order processing programs. Also, you have to be very careful ( and patient ) when debugging the transaction, since the actual commit might be there in some function module(s) that is invoked from the main program.
Hope this information helps you.
Regards,
Anand Mandalika.
08-18-2004 4:26 PM
Depends on the exit you are wanting to use (and I assume you want the internal table - memory areas- where the data is that will be written to the database). But if you are using userexit_save_document in MV45AFZZ, look at xvbap for vbap but take special notice of the update indicator - field UPDKZ. For VBAK use vbak. This would be the memory area created by the TABLES statement for VBAK. It will be holding the information that will be written to the database table VBAK.
08-19-2004 6:43 PM
Thank you all for your replies. As it turns out, during the user exit, function scope is preventing me from accessing the internal tables where I need to access them.
Another developer here suggested using export/import in ABAP to get around it. My options seem extremely limited in this particular case and his approach did the trick.
Thanks.
08-21-2004 3:49 AM
Hi Branden,
You are thanking a poster for his answer.
Please next time also give him points.
See: /people/mark.finnern/blog/2004/08/10/spread-the-love
This time I did it for you.
Remember: When you ask a question you also assume the responsibility to assign points.
Please check your other questions and if the answers were good.
Spread the love and give some points.
Thanks in advance, Mark.
08-20-2004 12:11 PM
Hi, and sorry my english.
Look the internal tables XVBAP and YVBAP for item data, and structure VBAK for header data. If you need the schedule data, look the internal tables XVBEP and YVBEP.
Mauricio Sewaybricker