Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Import maps for qualified table

Hi,

I have multiple vendor records in excel file for same vendor.

during process of importing i want to import only one vendor for all duplicates but all values of qualified fields of duplicate records to be imported.

ex: V1 Qualified field A1

V1 Qualified field A2

V1 Qualified field A3

import map should import the records as V1 A1

A2

A3

Where V1 is the main table and A1, A2, A3 are Qualified table values.

Sonali

Tags:
replied

Hi Sonali,

Please check the below steps:

1. Open the excel file in Import Manager

2. Map the Vendor field with the main table field

3. Map the non-qualifier field with the Qualified field present in the main table

4. Map the Qualifiers.

When you perform Record Matching it will show create 3 records but after importing when you check it will create only one record and 3 qualified records.

Regards,

Jitesh Talreja

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question