MDM - Join conditions

[Former Member]

Dear Gurus,

I am looking for how to access multiple tables via selection criteria like building a SELECT ... INNER JOIN ON ... WHERE ... Statement via the Data Access Layer of SAP MDM 7.1. Any idea?

Regards,

Ludovic

[Former Member]

taking ur dummy example - its simple

u should have contracts in a Qualified Lookup table with Prod cats as a qualifier and Customers as lookup flat

u should then have products in the main table - with fields referencing the contracts and customers

not sure on ur use case : but u could make it complex by adding the same prod cat at the item level

this will ease seaching

and remember searching in MDM is always search within a search !

u choose a prod cat - u get a list of items - u choose a contract - a search is done within the earlier search

why do u want to reinvent the wheel - when MDM gives u that ..get in touch with a data modeller instead

hope this helps

thanks

-Adrivit

[Former Member]

Many thanks for your answers.

I will try to rethink the solution.

Kind Regards,

Ludovic

[Former Member]

Hey,

You can not run SQL statements on MDM. if you want , you can develop Portal code and access as many tables as you want.

If you need to just view the data, you can go to MDM Data Manager and filter/sort the records as per your need but you still can't run SQL statements on it.

MDM is not meant for that.

Thanks

Aamir

[Former Member]

Thanks for your answer. Actually, I am implementing a "Portal-like" application on top of MDM I want to access via the data access layer API.

Let's assume with a dummy example that MDM contains multiple tables : customers can buy products according to a contract on product categories they have suscribed.

- Customers (4.000.000 records) : KEY, CONTRACT_NUMBER

- Products (4.0000.000 records) : KEY, PRODUCT_CATEGORY

- Contracts (1.000.000) : KEY, CONTRACT_TYPE

- Contracts_Products (1000) : CONTRACT_TYPE, PRODUCT_CATEGORY

Look-up table :

- Contract Types

- Product Categories

Question : what are the products customers having a Contract Type A can buy?

Ludovic.

[Former Member]

Hello Ludovic

I think, this tables should be related each other.

Your repository may contain multiple main tables.

Your query will be depend of this.

Look at this article "Retrieving Records" and "Retrieving Records with Search":

http://help.sap.com/saphelp_nwmdm71/helpdata/en/0e/941a04d76a42a6b0577023ab21766f/frameset.htm

Regards

Kanstantsin Chernichenka