My requirement is upload vendor bank information from XL file FK02 transaction.
I have an excel file having vendor bank details like Vendor number, country key, bank account number, IBAN value and partner bank.
While uploading i am facing the problem. For a single vendor there may have 2 or 3 line items and for the first line item is having IBAN number and the rest of the two line items, they dont have IBAN. From the file we are getting only the vendors not having IBAN.
So in this case the record comming from the file is overwriting the first record.