Skip to Content
0
Jun 07, 2022 at 10:49 AM

Using Specific Data In Excel To Search In SAP C4C

283 Views Last edit Dec 29, 2022 at 03:27 PM 2 rev

I am automating a process in SAP C4C, which uses items of data from an Excel worksheet, for account/customer validation.
The Excel worksheet contains rows of data, each one relating to a customer, premise and an account.

The process is required to take the Premise number, retrieve the related Premise in C4C and then validate that the customer name and account number in C4C, match with the related information in the Excel Worksheet.

If validated correctly, the process will complete a number of steps in C4C, update the excel and then take the data from the next row to repeat the process.

Any guidance on the best method for completing the steps in taking the data from excel, using it to validate in C4C and then looping back to repeat the steps, would be most welcome.