cancel
Showing results for 
Search instead for 
Did you mean: 

Missing data when using the WEB Browser in MDM

Former Member
0 Kudos

Hi All,

I am currently implementing MDM Catalog. The requirement of the Business is to be able to search materials by Plant. Different Plants may have different Prices for the same item.

For Example:

Material Plant Price

A A $20

A B $25

I have based my solution on the existing "Pricing Information" What I have set up is the following;

As a field in the Main Table I created "Plant Price"(lookup Q Flat)

The Qualified Lookup table used is called "Plant Price"(Sub Table)

"Plant Price" cosists of the following tables:

Plant(Lookup Flat) - Non Qualifier

Currency(Lookup Flat) - Qulifier

Amount (Currency) - Qualifier

I have loaded Data which can be seen and displayed in the Data Manager(Client).

My Problem however is that When the data is selected and displayed through the WEB Browser(MDM UI) then the field "Plant Price" is displayed but no data/content that was created is displayed in other words the amount and currency is not displayed.

I would appreciate any help or suggestions

Chris

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Chris,

Enter the data in all lookup tables first. and Use all fields as a display field in qualified table.

Then you will see those in data manager.

Hope it will help you.

BR,

Alok

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks Alok and Saurabh,

All tables have been populated with data.

The assignments was made in the OCI as suggested.

Unfortunately my problem still remains, Any other suggestions?

Appreciated

Thanks.

Chris

siowfong_chen
Contributor
0 Kudos

Hi Chris,

Can you please share your solution to this problem? I am wanting to do something similar but at the moment I have tried to use purchasing organisation which is part of the standard in the price information table and it didn't even work so I have not even tried to introduce the plant field yet.

Can you tell me how the system would pass the plant data from SRM to MDM in the first place to know which price to take?

Cheers!

SF

Former Member
0 Kudos

Hi Chris,

just check with the OCI mapping. Check weather the OCI field is mapped with the MDM field as mentioned below:

NEW_ITEM_PRICE: Price information-Amount

NEW_ITEM_CURRENCY:Price information-Currency

NEW_ITEM_PRICEUNIT:Price information-Price base Quantity.

Hope this will help you.

TNR,

Saurabh...