on 10-17-2011 3:42 PM
Hello dear MDM gurus!
Can anybody answer how to resolve following:
I want to import data into lookup Flat table, and also I want that impotrted item will be linked with corresponded main table item.
(Not all Lookup table fields has display field attribute)
Hi Dmitry,
I do not see a challenge here,you can create a field of type lookup flat and in its details of this field mention the Lookup table name.
You can load the data using MDMGX,excel or other sources.
When you create a main table record,clicking on this particular field value will give you option of the records you have imported in the Lookup Table table.
Please get back in case of any queries.
Thanks,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for reply. But this problem is a little bit complicated.
I want that system creates new record in lookup table and link it with corresponded record of main table (simultaneously during an import process). Or (if similar record already exist in Lookup table - just link it with the corr. main table record )
Fore example: I have main table of Business Partners
and also I have lookup table (Contracts)
And I want by means of import add new Contract record with linkage to BP
Hi Dmitry,
Let me summarise my understanding-
You want to add contract data to already existing main table data of BP,and your concern is how will the linking between 2 happen.
I assume you are using PI to transfer data from SAP system.
You can try using BLAORD03/BLAORD02/BLAREL
Get Idoc documentation using WE60 and using this you can prepare maps for import and syndication of data.
The documentation will also help you to get a Primary key to link Main table data to contract data.
Create xsd for this idoc,create maps,maintain partner profile and Interface related config.
For further details please go through these links:
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CABFAISMM/CABFAISMM.pdf
http://help.sap.com/saphelp_fica471/helpdata/en/04/2f45b1c6d3904791a4d18199dd7f65/content.htm
http://help.sap.com/saphelp_sm32/helpdata/en/d6/714e38406a8f4de10000009b38f8cf/content.htm
Thanks,
Ravi
Hi Dmitry,
Is it possible to import the record that should be used as lookup value in the same import run that imports the main table record (witch should contain this lookup value)?
You should have imported lookup table data before main table import.
So when you start Main table import the lookup field will hold a value which is already present in lookup table.
This way data standardization is ensured.
If a record containing a value which is not present in Lookup table comes, is send to Value Exception.
e.g If have a material record coming in for creation on import ,and say it carries Material Group value,which is a Lookup field.
Then Material Groups should already be present in MDM and incoming record only chooses its entry,which gets value mapped on import.
Thanks,
Ravi
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.