Char. values from table

[Former Member]

Hi,

We have created one table in SAP which has various field maintained. For example

Project name	Department	3rd party vendor	code
PN111	Design	ABC	00
PN123	Manufacturing	BCA	01
PN111	Manufacturing	BCA	01

We have created all the fields as Char. like Project name, Department,.................

We want to fetch values for these char. from above table with dependency................

My user will select Project name= PN111

Based on this selection I should get Department= Design or Manufacturing (If I select Design)

Then for 3rd party vendor, I should get only one option= ABC

And code will come automatically based on 3rd party vendor for example here it is = 00

How to achieve this ?

BR,

Sandeep

[former_member662213]

hi,

For this, you can use object dependencies in the characteristics to achieve desired results.

Regards,