on 02-02-2011 7:41 AM
Hi All,
1. In vendor Repository, i have created a qualified table. In that, i have made the field Company code as Non Qualifier, display and UNIQUE field. But still i am not able achieve uniqueness within the qualified table
Kindly advice how to achieve it?
2. In MDM 7.1 , how to use the Tuples? I understand we can use Tuple instead of qualified table
Kindly help with any document
Regards,
Antony
Hello Antony
1.QLUT - table were you can realized one to many relationship
for more helpfull answer cold you provide more detail information about your data and what do you want?
2.Tuples - just view but not instrument for data management
mode detail about tuples you can read here:
http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/206fed62-b48b-2b10-70b0-f12a99b9fe46
and here:
http://www.sdn.sap.com/irj/sdn/index?rid=/library/uuid/80765a21-78f3-2b10-74a2-dc2ab57a1bd2
Regards
Kanstantsin Chernichenka
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thanks for your reply..
I am trying to maintain company code data in the qualified table having Company code as Non qualifier
The system is allowing to have more than one company code of same value
Eg : Vendor A is linked to company code CC1, CC2. But system is allowing to maintain CC1,CC1,CC2 which violates the uniqueness of the non qualifier in the qualified table
Hope i tried to explain my problem
Kindly advice
Regards,
Antony
Hi Antony,
this is not possible using the standard qualified table functionality.The uniqueness refers to the company codes you can create, but not the linkage of company codes to the material.
So, if you really need to to check for duplicate selected company code data, then you may want to use a little workaround using validations (which can become quite complex if you have many company codes):
NOT(FIND(Company Code, "CCH1", FIND(Company Code, "CCH1")+3) OR
FIND(Company Code, "CCH2", FIND(Company Code, "CCH1")+3) OR
FIND(Company Code, "CCHn", FIND(Company Code, "CCH1")+3))
where "Company Code" is your non-qualifier field.
Maybe that helps.
Best regards
Christian
Thanks
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 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.