cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Importing data into a Qualified Table

Go to solution
Former Member

on ‎03-16-2008 12:57 PM

0 Kudos

Hello -

i am looking for a document that explains how to import data into a qualified table,

Is such a document available??

If so - please let me know where I can find it.

Thanks!

Nadine

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Answers (4)

Answers (4)

Former Member
‎03-17-2008 7:49 AM
0 Kudos

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/abe914fa-0301-0010-7bb1-d25c2a4b...

See this Blog.

Regards,

Alok

Show replies
Show replies
Former Member
‎03-17-2008 7:10 AM
0 Kudos

Hi Nadine,

First of all before importing you main table records you must import all your lookup tables even qualified tables.

If you do not populate you qualified table values before importing the main records there are three ways to do this:

Adding the Values manually:

When importing the main records if any qualified values are left out ,you can manually add them in your value mapping and then import the main records.

Creating a Compound fields:

For doing this you first need to map all the main table fields then,you need to create a compound field in your source side and map it to the look up qualifier field.

Set qualifier update:

This procedure is already explained above by others.

Note: You need to note that without Non Qualifier ther is no meaning using a qualifier table as this will have no added advantage but will only increase the complication .Besides only the non qualifier fields are visible,the non qualifier fields will not be seen while mapping that is why you are facing a problemin mapping.

Below is some documents to make ur understanding more clear.

/people/community.user/blog/2006/12/20/so-is-that-the-qualifier-or-the-non-qualifier

/people/avi.rokach/blog/2006/11/14/using-mdm-55-for-data-quality-analysis

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/9030396d-0e84-2910-d8ac-f92388f8...

Please Reward Points if helpful.

Thanks & Regards

Neethu Joy.

Show replies
Show replies
Former Member
‎03-17-2008 4:42 AM
0 Kudos

Hi,

Basically Qualifiers is used to store multivalues.

Suppose you have two non qualifiers say field1 and field2(make them as display field in console),and field three is a qualifier field.

In Import manager select source table and destination table as qualified table.Then in Map fields Tab map the nonqualifier fields (field 1 and 2)and import the data .

Then select source table and destination table as main table.

Then In Map Fields Tab Map other fields along with nonqualifiers.Then select the qualifier field on source side(field3) right click say Create Compound field(This allows u to create a compound field which is a combination of Nonqualifiers).This field gets automapped.

then In Match Records tab select a field(as per the uniqueness of this field records are imported) and do the import.

Note : u cant have jst a single non qualifier,it wont allow u to create a compound field.

Reward points if helpful

Regards

Nisha

Show replies
Show replies
Former Member
‎03-17-2008 5:27 AM
0 Kudos

Hi,

qualified tables are used to store complex relations.

follow the link where u can some information about the qualifid table operations.

[http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0615f82b40a2ee10000000a11466f/frameset.htm]

Hope this ll help u.

Reward with points if found useful.

Rewards,

Sravan.

Former Member
‎03-16-2008 10:48 PM
0 Kudos

Hi Nadine,

Please go throught the following link:

[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3417] [original link is broken] [original link is broken] [original link is broken];

[;

I hope I am able to help you:

Regards

Dilmit Chadha

Show replies
Show replies
Ask a Question