on 02-08-2008 12:02 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
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.