SAP ECC6.0 : VEPVG and Delivery Not Created - Part 2

In my previous entry, I wrote about VEPVG table not being maintained correctly whenever an Order's line item's was change, particularly the delivery date. In a bid to find out why VEPVG was not maintained, I had ST05 switch on so I can do a trace on VEPVG and see where it is updating the table. Needless to say, locating the VEPVG was easy and not a monumental task. So, as a result, you will get below result if you do the same too.

Now back, the my own issue, VEPVG was not showing an Order's line item for Delivery creation when Delivery Date was changed. Here's what ST05 found for me:

** INSERT THE VEPVG
18:12:15.013       332 SAPLV05I   VEPVG      REEXEC 
18:12:15.013       142 SAPLV05I   VEPVG      REEXEC
18:12:15.014         24 SAPLV05I   VEPVG      DECLARE
18:12:15.014       276 SAPLV05I   VEPVG      PREPARE
18:12:15.014    2,380 SAPLV05I   VEPVG      EXECSTM
18:12:15.016       228 SAPLV05I   VEPVG      REEXEC
18:12:17.940           8 / /DBVE       VEPVG      REOPEN
18:12:17.940       584 / /DBVE       VEPVG      FETCH  
18:12:17.941           4 SAPLSETB  D020S       OPEN   
18:12:17.942           6 SAPLSVIX  TDDAT       READ SI
18:12:17.943           3 CL_ABAP   TRDIR         OPEN   

** DELETE THE VEPVG
18:18:20.772       282 SAPLV05I VEPVG     REEXEC  <<- b="b" deleted="deleted" here="here" ot="ot">
18:18:27.811         12 / /DBVE      VEPVG     REOPEN 
18:18:27.811       498 / /DBVE      VEPVG     FETCH    
18:18:27.812          6 SAPLSVIX  TDDAT      READ SI 

No wonder, I could not see my expected line in VEPVG, ST05 is telling me that SAP is inserting a record then removing it. But WHY?! ST05 only shows WHAT the program is doing. So, you need to understand the logic in order to understand WHY it is doing this. 

When I double click the DELETE statement, I notice the condition to it is "IF ARRAY_DELETE = ' '". Why would the ARRAY_DELETE be blank and resulting missing record in VEPVG? 

Well, ARRAY_DELETE is used in several SAP Index update Program. This programs manages all the indexes for Orders, Deliveries, Billing and Invoices. All of it which will be use in creating subsequent documents in the background. It is damaging if the index table especially VEPVG is not maintained correctly because you will be face a group of angry customers/users asking you why my delivery/billing not created since yesterday? The automation not working? 

Here's the list of Index Programs:

- RV_BILLING_INDEX_UPDATE
- RV_DELIVERY_INDEX_SAVE

- RV_INVOICE_LIST_INDEX_UPDATE

- RV_SALES_DOCUMENT_INDEX_UPDAT

Now, we know what is not updating and where it is not updating but do we know why?? The reason all point to how you maintain your user exit especially how you manage your X and Y tables for VBEP i.e. YVBEP and XVBEP. 

williamwilstroth... VEPVG, INDEX 

   

SAP ECC6.0 : VEPVG and Delivery Not Created - Part 1

Two more days to factory shut down and as my good boss said, "You are not going to like this". Well, all I can do is coolly brace for what's to come. He told me the VEPVG is not being updated when a sales order line's First Date gets changed for the third time. 

Oh god, the first time, the sales order gets created; a line is inserted to VEPVG. The second time, that sales order get its First Date changed; the line remains in VEPVG. The third time, the sales order get its First Date changed again; VEPVG no longer holds that line anymore. Hmmph... oh dear... now i wish the ABAP Debugger comes with a "Backward Debugging" feature. Bah! I know WHERE it gets deleted but I have no idea WHY it gets deleted...

(NOTE : i think you guys know the significance of this issue, if, VEPVG table does not get updated when you save your Sales Order (VA02))

So there goes my whole day, gone through all my changes since August until today. Looked through my tickets and checked which ones had involved user-exit modification. Heck, I did not know I had been changing so many of it. Productive year with lots of projects, I guess...

Anyway, I am going murderous on this issue. I wonder why on earth does this VEPVG suddenly doesn't get updated constantly. Yes, I am still looking, investigating and thinking here and there...

Here's some NOTES for you to review, if you are having the same issue like mine : 

415716 - User Exits in Delivery Processing

128947 - Correction of SD Document Indexes With RVV05IVB

178328 - Problems due to Incorrect User Exits in SD'

williamwilstroth... vepvg, userexit_save_document_prepare, 415716, 128947, 178328

SAP ECC6.0 : It is all about learning new ways of doing things!

Recently, I read a piece of article in SCN and it make me notice that we do get stuck working comfortably in one spot because we all want a permanent job, with a good pay and less traveling. So, most of us are all there in one company and for some, had the same wish to be there too. Here's a link that you must read and it is called, "Call to Arms".

This article is written by Graham Robinson and he touches some very good aspects about why should one ABAPer learn up newer trade of tools. Just, go read the article up and I hope you will strive more for next year's goal.

Christmas coming, the end of the world like the world is watching, might or might not come but let's us all forget about it for a moment and do a wish list for 2013. What would you want to learn in 2013? 

I would love to learn two things :

1. At least, attend a course on ABAP Web Dynpro, and do an assignment on this topic.
2. At least, able to go to PDF tcode and use PDF Editor and modify one form for one assignment.
3. Do one biggest project, that encapsulate all of what I've learn!

Merry Christmas and Happy New Year! Careful for what you wish for! No Challenge, no pain and no gain!

williamwilstroth... Merry Christmas, Happy New Year, 2013

SCN RANT : My work and SCN is complicated to use!

The world's coming to an end. Serious? The Mayan calendar ended there meaning world ending on that day or their finance fiscal calendar ends on that period? :) Anyway, if SAP even existed that time, I guess they forget to maintain their factory calendar, SCAL, and let's hope we are able to celebrate 2012 Christmas. 

Working with ABAP has always been challenging since my training days (8 years ago!), no doubt about it. Early 2012, I had been focusing on modifying Sales Screens especially Shipping and line item's shipping tab. Based on shipment route (VBAP-ROUTE), to determine the Loading Date, Material Availability Date, Delivery Date, Goods Movement Date and few more dates. My solution to these fixes was modifying in program SAPMV45A at screen 4552 (PBO Module). You can do some manipulation to the screen value too. Okay, enough said and you can go along and play with it. 

On another hand, I have NOT used SDN since it, well, became SCN. I find it complicated and the original forum's topic has been moved and changed to somewhere unknown. Why did you guys, SAP, have to move it?? The original design was way much better to navigate and easier to find stuffs than the new one, duh! SCN just makes it complicated and the hopelessness hung there whenever you have to go to the guide to see where the ABAP forum has been changed to which page. The wholesome of using SDN as a forum is no longer as great as it used to be. Can the guys who are responsible for this SCN project give something better? I can neither ditch SCN nor ignore it because it is every SAP professionals life stream! Looking for ABAP resources was fun with the good old SDN until it became SCN... it is sucks, all the way...

Okay, enough ranting of SCN. Back to some of my current assignments which involve heavy modification of MV45AFZZ's routine (USEREXIT_SAVED_DOCUMENT) and IDOC outbound process (IDOC_OUTPUT_ORDRSP) was the longest enhancement of all projects. Not to say it is difficult but it requires the functional to spend hours of testing in order to get a thumbs up. The nature of the change was complex as it requires to listen to the slightest change in VA01 and VA02 screens e.g. change of order quantity, change of first date, or even change of header's info will trigger an IDOC Order Response. Of course, it is taken care now but the amount of energy and time spent in that room with two functionals to verify all the functionality is working and non original process is affected - is humungous!. Anyway, all is done and ended well. 

Now my next task is to determine why there is an error pop up when one line item gets firmed for consignment order. Talk about errors and bugs, Christmas is coming and I hope things goes well when I am not around. Merry Christmas to all readers who have come here to get some ideas and I thank you very much. Have a good Christmas and may the end of the world is just another merry day to you!

williamwilstroth... SCAL, IDOC, MV45AFZZ and end of world???