I’m trying to automate the creation of transactions in SAP and faced some issues. Here is some background and the issue faced:
An Excel spreadsheet is used as the data source.
Users will typically maintained certain fields in the spreadsheet for SAP import in numeric form, e.g. “1001” for, say, a certain customer grouping type, without the full description, say, “Local Customers”
While doing the automation in SAP, some fields cannot be Typed Into, and instead the entry must be selected via a drop-down (using F4).
A drop-down list would typically show the concatenation of the code (e.g., “1001”) and the description (“Local Customers”) so the scrapped text from a drop-down box may look like this after scrapping:
1001 Local Customers
1002 Overseas Customers
1003 One-Time Customers
1004 VIP Customers
The problem is, the field in the spreadsheet would be maintained as “1001”, but I won’t be able to use Click Text to select “1001”.
Does anyone here have any suggestions what can be done (elegantly, hopefully) to automate this part?
Thanks in advance!