Retrieve Qualified value

[Former Member]

Experts,

We would like to retrieve 1 Function Code (based on simple rule) from the qualified table to display it on the main table field named - Function Code.

For 1 record in the main table we can have several Function codes in the qualified table.

Main table : Function code (Calculated field)

Qualified Table --> Field:Function Type (Non Qualifier)

--> Field:Function Code (Qualifier)

Rules : If Function Type A, B and C Take the code value of A=123

If Function Type A and B Take the code value of A=123

If Function Type B and C Take the code value of B=456

And If Function Type A and C Take the code value of A=123

Example:

Record 0001 can have Function Type A, Function Code 123

Function Type B, Function Code 456

Function Type C, Function Code 789

Record 0001 can have Function Type A, Function Code 123

Function Type B, Function Code 456

Record 0001 can have Function Type A, Function Code 123

Function Type C, Function Code 789

Record 0001 can have Function Type A, Function Code 123

It looks simple but not easy to realize.

Best Regards,

John

[nitin_mahajan2 · Accepted solution]

Ain't it fine if you get all the records from the qualified table and then do your processing/rules mapping/ whatever required on portal?

using if-else???

[Former Member · Accepted solution]

Hallo Nitin,

We use Enterprise Portal but how to retrieve the data from qualified table? We need probably to use Java API.

But we want to use calculation fields or Assignment with workflow.

Regards,

John

[Former Member]

Hi Nugge,

I understood your problem.

if you want to use Qualifier table then your source should be such as:

Source Table:

ID--

---

Function_Type--

---

Function_Code

0001--

---

A--

---

123

0001--

---

B--

---

456

0001--

---

C--

---

789

Then only if you import using qualifier table structure ,u will get following in MDM data manager:

ID----

---

Function_Type

0001----

---

A;B;C

If you see in record detail pane u can find function codes also when u place the cursor in function_Type.

For importing Qualified table you can refer to this link:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/00a15239-684e-2b10-b8ae-b936b7d1...

Regards,

Neethu Joy

[Former Member]

Thanks Joy, but my question is not how to import the qualified and non qualified data.

We have 3 Functional code in our Qualified table and we would like to display on of it on the main table by using Calculated field. But the calculated field works fine when we have only 1 functional code but for more than 1 it is very complicated to retrieve the functional code.

Functional Code Type (Non Qualifier) text type

Functional Code (Qualifier) text type

3 Functional code type A, B and C with functional code 123, 456 and 789

The rule is If A,B and C take the Functional Code 123

If A and B take also 123

If A and C take also 123

If only A take 123

If B and C take 456

If only B take 456

If only C take 789

We hope you have the solution.

[Former Member]

Experts,

I need your help, How to retrieve values from qualified table? Please find below the problem in detail.

Best regards,

John