Automate

Hello
I want to accomplish the following data validation:
Download data from SAP material master and check if the materials is Make to Stock and so the Target days supply has to be >0.

I am thinking about using IF condition to say if the value in "material type"  is MTS and the Target day's field is >=0.

I am able to setup a winshuttle script to download the data from SAP but the data validation always gives message as "success" instead of something more specific.

has any one tried this and any links to knowledge articles are appreciated.

------------------------------
krishna podila
------------------------------

I have had good results writing IF statements out side of Winshuttle in excel in unused fields. After proving it out in excel with data. I then will check if there is a way to move it into Winshuttle but have had mixed results.

------------------------------
Benjamin Kielas | SAP Master Data Team Lead
Generac Power Systems, Inc. | (262) 544-4811
------------------------------

Original Message:
Sent: 07-17-2019 12:40
From: krishna podila
Subject: Using IF condition in data validation

Hello
I want to accomplish the following data validation:
Download data from SAP material master and check if the materials is Make to Stock and so the Target days supply has to be >0.

I am thinking about using IF condition to say if the value in "material type"  is MTS and the Target day's field is >=0.

I am able to setup a winshuttle script to download the data from SAP but the data validation always gives message as "success" instead of something more specific.

has any one tried this and any links to knowledge articles are appreciated.

------------------------------
krishna podila
------------------------------