I have a requirement where i have to pick a file and send to SAP CRM system, but the catch is i need to check whether the customer number (coming in the file) exist in ECC and if it doesnt then i have to cerate the same first in ECC and then send the file to SAP CRM system.
Points to be noted: 1) One file can have multiple records may be thousands records but only few records are having customer number which doeS not exist. So i have to create the customer details in ECC for those records only.
2) The file needs to be send to CRM once the customer is sucesfully integrated in ECC system.
Kindly suggest me a good approach to develop this scenario (i dont want to use BPM for this).