Qualified Table (Bank Details) Import Question

[Former Member]

I am using MDM 5.5 SP6

I am using the Standard SAP delivered Vendor Master Repository and trying to load the Qualified Bank Details table. Bank Details qualified table we have 9 non-qualified fields and 6 qualified fields.

Do we need to load the non-qualified fields in the bank detail table first?

Anyone help me with details about how to load this table including linking this to the main table?. If anyone has any document explain the steps in detail then could you send it?

Thanks in Advance

Steve

[michael_theis]

Hi Steve,

as you're using the standard content, there is an import map for Bank Details that initializes the non-qualifiers first. You can create an XML file carrying the related values by executing transaction MDMGX in you ERP (R/3) system. The initialization will create entries for the banks (a bank, some address info of the bank, and so on). Later in the process when you import your Vendor records with the CREMDM IDoc, this import will actually create the bank details, meaning the bank account of the specific vendor at a bank.

General information about the Vendor repository is available in [SAP Note 1252883|https://service.sap.com/sap/support/notes/1252883].

Best regards

Michael

[Former Member]

Hi,

A good doc on QT:

Another good read;

Regards

Manish

[Former Member]

Hi Steve,

Check the below steps

1. Import data into the lookup tables for all the fields of table Bank Details i.e. Country (table Countries) and Collection Authorization(table Yes/No Indicator)

2. Map all the relevant source fields with the qualifiers (except Bank Account Number) marked as Q in Destination Grid

3. Map the fields Street, City, Swift Code, Bank Group, Bank Number and Bank Branch. All these fields are of type Flat

4. Map the fields Country, Bank Key, Bank Name and Bank Account Number. All these fields will be marked as D i.e. Display Fields, now select the source fields mapped with these display fields, right click and select Create Compound Field -> Bank Details. This will automatically create one field and map it with the field Bank Details.

5. Perform the value Mapping

6. Map all the required main table fields and import the data

Regards,

Jitesh Talreja

[Former Member]

First thanks to all who contributed.

I am able to load the qualified table but these non- qualified fields (Street, City, Swift Code, Bank Group, Bank number and Bank branch), I am not able to map it so after loading it was blank.

Out of the 9 non-qualified fields in the Bank Details Qualified table, Country, Bank Key and Bank name are DISPLAY fields and I am able to map and load these fields.

Other non-qualified fields such as Street, City, Swift Code, Bank Group, Bank number and Bank branch are NOT DISPLAY fields. While using the import manager and doing field mapping, for these 6 fields there is NO destination fields displayed. So I couldnu2019t map it.

When I made the above 6 non-qualified fields as DISPLAY fields, then try to map it, I am able to see these fields in the destination side and did the mapping. After import still those 6 fields are blank.

What I am missing here?. Is there any limit that only 3 non-qualified fields we can map it?

Steve.

[Former Member]

Could anyone clarify my question please

Steve.