SAP PSI Compare customer old and new orders
T-code PMVA
'MTA Segments Filter”interface
Icon”Export Overview” obtain a spread Excel sheet
VBA program
In the main interface,enter T-code PMVA,then enter,switch to “MTA Segments Filter”interface;
No fields to be filled in,just enter,into “MTA Segments Overview”interface;Ctrl+A,to select all rows;
Click the icon”Export Overview”,a spread Excel sheet could be obtained as following;besides that,we get a updated customer order like this;
Copy and paste the old and new order sheets into a unique work book;create another sheet named as “Comparison”;we're going to make VBA program and realize the automatic comparison;
VBA program 1st paragraph could be shown as following;
Moreover VBA program 2nd paragraph;
The readers who're interested could test the program and find any indications.Here we would just run the program and check the result.We could get the result as down below.Therefore 5 rows of orders had been revised so that we could take measures how to adjust corresponding plan.