List of Contributions

jan ketele

Contact Details

My Content

1 to 20 of 50+ total

RE: Does not contain * (asterisk)

Posted By jan ketele 09-12-2024 11:04
Found In Egroup: Automate \ view thread
In SAP, you can search in MM02 on the description field using *#**. SAP uses # as an escape so * is input as a character instead of a wildcard. Excel uses ~ for an escape so the * is input as a character instead of a wildcard; you can search using ~*. hth, jan ------------------------------ ...

RE: Business Partner data update in S4 Hana

Posted By jan ketele 07-15-2024 10:45
Found In Egroup: Automate \ view thread
Thank you very much for your extensive answers, Sigrid. Excuse me for the delay, I just got back from a couple of weeks on holidays. I'll test the lot in a day or two. kind regards, jan ------------------------------ jan ketele release expert Xeikon Manufacturing NV -------------------------- ...

RE: Business Partner data update in S4 Hana

Posted By jan ketele 06-18-2024 03:44
Found In Egroup: Automate \ view thread
hi Sigrid, This does look very promising, thank you ! I definitly would like that example you're referring to if possible: it would give me a good starting-point. kind regards, jan ------------------------------ jan ketele release expert Xeikon Manufacturing NV ------------------------------

RE: Business Partner data update in S4 Hana

Posted By jan ketele 06-17-2024 09:21
Found In Egroup: Automate \ view thread
good afternoon Sigrid, Many thanks for responding. one of our SAP servers recently upgraded to S4 Hana, so I was looking for the most effcient way to update customer details. The first that were brought to our attention were customer mail addresses. So I was hoping do find a BAPI to do so, especially ...

Business Partner data update in S4 Hana

Posted By jan ketele 06-11-2024 07:36
Found In Egroup: Automate \ view thread
Hi, I'm looking for a BAPI we can use to update BP (cfr T-code BUP2). Did anybody find such a BAPI yet ? best regards, jan ------------------------------ jan ketele release expert Xeikon Manufacturing NV ------------------------------

RE: Material Master Alt Description Creation script

Posted By jan ketele 06-10-2024 07:06
Found In Egroup: Automate \ view thread
hi Christian, Did you try the BAPI_MATERIAL_SAVEDATA , table MATERIALDESCRIPTION ? We don't have so many languages to load, but it works fine for me. ------------------------------ jan ketele release expert Xeikon Manufacturing NV ------------------------------

RE: Convert a create script to an update script

Posted By jan ketele 06-04-2024 08:25
Found In Egroup: Automate \ view thread
Hi Andrew, I think you'll need to rewrite the script with those same fields using XK02. Or you could try a Direct script, there is a Winshuttle BAPI "/WINSHTLQ/TRN_VENDOR_BANK" that seems to contain all the data you need, I haven't tried that one yet, but it should work. (Since it's a Winshuttle ...

RE: Convert a create script to an update script

Posted By jan ketele 06-04-2024 04:19
Found In Egroup: Automate \ view thread
Hi Andrew, It depends on what parameters you'd like to create/change first option, the better option in my opinion, is to create a 'direct' script using a BAPI. That will create data if it doesn't exist yet and will change data if it does. 2nd option: create a pair of transaction scripts chained ...

RE: Order Automation

Posted By jan ketele 06-03-2024 07:47
Found In Egroup: Automate \ view thread
Hi Brijesh, Good question, I'm afraid you can't: this little script is merely preparing the uploadfile. Scheduling an upload is done by Winshuttle itself, independant of the uploadfile creation. Maybe someone else has a better idea ... best regards, jan ------------------------------ jan ketele ...

RE: Order Automation

Posted By jan ketele 05-29-2024 03:23
Found In Egroup: Automate \ view thread
good morning Brijesh, This is how I do so: I work with read-only templates. On opening of a template, a little VBA-script checks if the filename is the name of the template, if so a new name is proposed which is the name of the template, extended with the date (Datum = Format(Date, "dd-mm-yyyy")) and ...

RE: Order Automation

Posted By jan ketele 05-28-2024 07:41
Found In Egroup: Automate \ view thread
hi Brijesh, Since all info is contained in the Winshuttle log, the way I create a total overview of such a full upload: in a separate sheet of an upload workbook, I insert a number of formulas looking for : number of errors number of uploaded materials eventually a date & time stamp could be possible: ...

RE: Don't Forget to Register: [Training Session] Chaining, Looping, and Long Text for Script Development and Automation

Posted By jan ketele 05-28-2024 03:31
Found In Egroup: Automate \ view thread
https://www.precisely.com/resource-center ------------------------------ jan ketele release expert Xeikon Manufacturing NV ------------------------------

RE: Order Automation

Posted By jan ketele 05-27-2024 09:00
Found In Egroup: Automate \ view thread
Hi Brijesh, I would suggest you copy all datafiles into different worksheets in one single Excel workbook. You create a script per dataset in a specific worksheet, chain all scripts together into one big chained script which you publish in the workbook. That should work ... rgds, jan ------- ...

RE: Winshuttle pour la comptabilisation de piéces par FB01

Posted By jan ketele 04-05-2024 08:02
Found In Egroup: Automate \ view thread
Bonjour Meryam, Pourque tout le monde puisse suivre, je continue en Anglais: I'm not familiar with this T-code, but I 'm convinced that you're always better off using Direct if you have the choice. So a quick look into BAPI's resulted in: BAPI_ACC_GL_POSTING_POST you may want to give that a try ...

RE: Winshuttle: Is it possible to create a script (MM02) that modify the Alternative UoM data based on Alternative UoM that is on Excel?

Posted By jan ketele 03-27-2024 09:20
Found In Egroup: Automate \ view thread
hi Nart, you may want to have a look at this : https://preciselyu.precisely.com/page/automate-studio-webinars when searching on the community website, you'll find a lot of examples too. enjoy, jan ------------------------------ jan ketele release expert Xeikon Manufacturing NV ------------ ...

RE: How to set a field value in a repeating Table based on the entry of another field per row

Posted By jan ketele 03-18-2024 12:14
Found In Egroup: Automate \ view thread
Hi Mirka, that's something I would do with an Excel formula in the availabililty check column on the uploadfile, the formula would look like =IF(NOT(ISERROR(FIND("Subst.",column-row))),"CH","YS"), where column-row would point at the description location in that row. hth, jan ------------------------------ ...

RE: How to link script which has different Sheet as a load sheet?

Posted By jan ketele 03-18-2024 06:45
Found In Egroup: Automate \ view thread
Hi Nart, first you save each separate script, referring to the sheet it's working on. Then, while linking those using 'chain scripts', you chose the option 'custom' on the run settings. then on the settings icon, chose ALC: All from first script': this will avoid you need to login for every single ...

RE: Fixed current date for upload?

Posted By jan ketele 03-05-2024 08:24
Found In Egroup: Automate \ view thread
Hi Nart, sorry, as a matter of fact "currentdate" does not work. It does work with the simple Excel formula TODAY(), ------------------------------ jan ketele release expert Xeikon Manufacturing NV ------------------------------

RE: If data column is blank, make the value the same as in SAP S4?

Posted By jan ketele 03-05-2024 07:41
Found In Egroup: Automate \ view thread
Hi Nart, no, just the backslash "\" would do, if you prefer to use another character you can define that character in the Studio RUN-tab as shown in my screenshot. ------------------------------ jan ketele release expert Xeikon Manufacturing NV ------------------------------

RE: If data column is blank, make the value the same as in SAP S4?

Posted By jan ketele 03-05-2024 01:57
Found In Egroup: Automate \ view thread
Good morning, I think you 're referring to the 'skip indicator' : to be defined in the run tab, by default it's a backslash, but one can chose another character. Works perfectly in transaction scripts but I had some issues with it when using direct. hth, Jan ------------------------------ jan ...