Qualified table issue

[Former Member]

Hi All,

In repository i have one qualified lookup table. In it i have a field A which is a multivalued lookup field. I want to import several values into this multivalued field. When i import data from R/3 i receive the same combination of the three non-qualifier fields B, C, D in two different xml segments. The import manager will then go ahead and create two different combinations for the main table record link to the qualified lookup table.

But this is not the result i want. The requirement is that both values should be written into the same Qualified table so that the field A will hold both values. You will find on the main table on the right hand side the Sales Area data. Here i want to see only one qualified table data and it should have two values for Field A.

Best Regards,

chetan

[Former Member]

Hi Chetan,

To update the Sales Area multi valued lookup in the data manager check the following:

1. Map the display fields in the SA table to the corresponding multi-valued lookup table eg: if sales org, dist channel & div are the DF map them to the multi-valued sales area lookup table

2. create the matching field as a combination of these DF

3. change the destination back to the main table

4. map all the other sales area qualifier fields to the destination fields in the main customer table

5. Right click on any of the source fields a compound field called sales data is created

6. map this source sales data field to the sales area field(type F) in destination tab

Once these settings are made, if you have multiple sales areas for a customer , you will be able to load them as separate line items in the sales area multi-valued lookup table and have only one corresponding customer record in the main table.

Thanks & Regards,

Anita

[Former Member]

Hi Anita,

I have a similar issue like chetan's. I am able to get multiple records if present for a particular customer master.

The issue is that suppose in the qualified table i have one more multivalued look up field which has

to get populated.the issues is data is coming in two different XML's.And the requirement is it should

come to the same qualified table record.Suppose different tax classification records coming from two

different sales area records of two XML tags.And suppose in the sales area record everything is same

except the tax classification. Now i want to have all these in a single sales area record and the two

tax codes should populate the multivalued lookup field.

Best Regards,

Chinmoy

[Former Member]

Hi Chinmoy,

In your case the sales area is stored in the Idoc segment knvv & but the tax data is present in the segment knvi which is a sub segment of knvv. Have not tried your scenario, however you could try the following.

Create the sales area fields & tax classification fields as display fields. However the tax classification fields can be created as qualifiers. Probably you could upload the relevant tax clssifications & codes as a lookup table, the country field has the country lookup table as already loaded.

If this does not work then you could create a multi-valued qualified table for taxes separately in MDM.

Do try & let us know if it helps !

Regards,

Anita

[Former Member]

Hi Anita,

I am trying to create a multivalued lookup field in the qualified table. And it has to be a calculated again. Then a validation for checking out multiple sales area data.

After this a workflow to execute and calling the validation. And in the workflow process only the merging of multiple tax lines and populating the lookup field.

Let us see if this thing works....any suggestions from your side.

Best regards,

Chinmoy

[Former Member]

Hi,

The scenario decribed sounds complex- for instance creating the multi-valued lookup field within a lookup table because then you will need to have a display field.

Another point is that merging of line items in the workflow is not automatic i nthe DM, so after importing records manual intervention is required for merging the tax records.

Could you give an example of the scenario with the fields involved & the corresponding action , that might help understand what is the end result & the forum could help give option to get the result.

Regards,

Anita

[Former Member]

Hi,

I am facing the same issue. In my case, the qualified table has a single Non-qualifier which is also the only display field. One of the qualifier field is a Multi-Valued Look-up Table field. On importing records, multiple records with same Non-Qualifier and different values in multi-valued field gets created instead of single record with multiple values in the multi-valued field.

Please suggest.

Regards,

Anoop