List of Contributions

Dave Leon

Contact Details

My Content

1 to 9 of 9 total
Posted By Dave Leon 07-30-2022 15:25
Found In Egroup: Automate
\ view thread
Henry - your transform =concatenate(b2;c2;d2) uses semicolons rather than comma's. I get an error in the transformation when I use semicolons. Have you checked the accuracy of the sorted data in your column E to insure it is being sorted correctly? Thanks ------------------------------ Dave ...
Posted By Dave Leon 07-27-2022 10:38
Found In Egroup: Automate
\ view thread
Henri - could you please provide a copy of you query where you were able to sort the concatenated field values? ------------------------------ Dave Leon KIS Technologies ------------------------------
Posted By Dave Leon 07-25-2022 14:12
Found In Library: Automate
Posted By Dave Leon 07-25-2022 14:12
Found In Egroup: Automate
\ view thread
I am attempting to create a query using Customer Sold-To, Ship-To data and associated freight rates.  The output will become a "Look Up" sheet in an Excel workbook.  The purpose of this sheet is to function as the source of a VLookup from a separate sheet in the workbook.  So, it is important that the ...
Posted By Dave Leon 01-05-2022 14:07
Found In Egroup: Automate
\ view thread
I'm scratching my head as to why such a minor change can solve such a pesty problem, but it has! The pop-up screen is now functioning the way it is suppose to. Thank you for your suggestion Maria. ------------------------------ Dave Leon | SAP Winshuttle Consultant KIS Technologies Inc. | (713) ...
Posted By Dave Leon 01-05-2022 11:31
Found In Egroup: Automate
\ view thread
VK11 does look like a viable alternative . . . I'll give it a try. ------------------------------ Dave Leon | SAP Winshuttle Consultant KIS Technologies Inc. | (713) 201-0041 ------------------------------
Posted By Dave Leon 01-04-2022 16:45
Found In Egroup: Automate
\ view thread
I did eliminate the final screen where I was using =BACK to return to the initial screen. Having done this the script then ended exactly like your VK11. But afterwards I started getting "No batch input data for dynpro (SAPMV13A 0040 Entry via Tree) for every record. The bigger problem here remains ...
Posted By Dave Leon 01-03-2022 18:45
Found In Egroup: Automate
\ view thread
Using VK34, attempting to create a Transaction script to update Customer Item pricing. If the new price being created overlaps an existing price condition based on Validity Dates, then a pop-up screen is to appears to confirm the new price. Problem is the pop-up screen is a bit erratic and causing error ...
Posted By Dave Leon 12-17-2021 18:57
Found In Egroup: Automate
\ view thread
I am attempting to create a Customer query that produces the effective material item price for a given time period.  I'm using condition tables KONP and A305 to determine the pricing.  Problem is these tables include records for multiple validation "to-from" periods.   However, I'm only interested in ...