Assignment of lookup values

[Former Member]

Hi Gurus,

Is it possible to use lookup values for assignment expressions.

For eg:

There are 3 Plants X,Y,Z & also 5 vendors A,B,C,D,E.

Plant & Vendors are lookup flat tables.

Now i want an expression such that if i choose vendor A or B then automatically plant field should be filled by X.

Thanks in advance.

Pramod

[Former Member · Accepted solution]

Hi Pramod,

Yes you can use lookup values for assignment expressions.

For this you would need two fields in your main table looking up two these flat tables(VENDOR and PLANT), as assignments are table specific.

1] Assignment Expression :

IF(VENDOR = "A",X,Y). where in VENDOR is a main table field and X / Y are lookup values from PLANT table.

2] Assignment Field:

Plant field in main table.

Regards,

Amol.

[Former Member]

Hi Pramod,

As far as I know, assigments can work both on main table and look ups.

So you can give the expression by selecting the desired flat tables and the fields.

Thanks,

Minaz

[Former Member]

Hi Minaz,

As u said assignments can be done on Main Table as well as lookup table

But what if I am running an assignment on main table and I want to update a lookup table field value.

The assignment on main table never gives lookup table fields,

it will only give main table fields.

Please elaborate on ur statement that assignments work on both main table as well as lookup table.

I guess assigments work individually on the specified table.

Please help I need to run assignment on main table and update a lookup table field.

Please tell me if dis is possible.

Regards Tejas..........

[Former Member]

Hi pramod ,

Yes Pramod it is possible .

Select Assignment table as product table and field as plant.

Then in assignment expression

select if then else statement and write the statment u want .

Like if (VENDOR[A],PLANT[X],PLANT)

Hope it help u.

Regards,

Neethu