on 03-31-2014 8:34 PM
Hello,
as i do not have any documentation yet, i ask this SAP TAO Question to the community:
Can anybody explain, how i make Getter and Setter from/to Excel Files in SAP TAO?
These are my 2 use cases, i want to do with TAO.
Any help will be appreciated.
Regards,
Sebastian
Hi Sebastien,
You can use the following default business components from sap tao which is available in SAP front end / R3.
From SAP to Excel ( you have to pass on the correct parameters in accordance to the physical/logical properties of that object)
1.Get Text
2.Get Cell Value
3.Get Status bar content
4.Get Message Parameters
For checking from Excel:
1.Compare Values
2.Set Condition
3.Report Message
Also you can use standard tokens like %random% in excel for P.O Numbers which automatically fetch six digit unique values...No need to change everytime...
Hope this helps .
Thanks,
Venkat.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Aakash,
One should know about some SAP testing concepts and little vb scripting knowledge for understanding this SAP TAO landscape.whatever the number(P.O /Sales Order number) created in statusbar can be captured to an excel sheet.however PFB the details.Hope this helps.
Storing the Sales Order Number in the Data Table Excel Sheet
1. Drag and drop the getMessageParameter component in the suitable location of the test case. Generally, it would be dragged and dropped before the automatically added GetMessageParameters component.
2. Provide the same URI of getMessageParamters component to the getMessageParameter component. Use the suitable index for storing the value. You find this index by using QTP object spy. The index in the case of standard VA01 transaction is 1.TargetField is the DT_XXX which is a column name in the data table Excel sheet.
Adding Manual Validation on the Status Bar
1. While recording the PFA use the CheckPicker functionality to inject the CheckProperty component for status bar validation.
2. After the PFA upload, the check property component is introduced after the GetMessageParameters component.
3. Modify the data table Excel sheet to capture suitable string for validation.
Thanks,
Venkatesan M
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.