Hi,
There is a table (YKXRDAWERKS) with 2 fields (YWERKS_LOGICAL & YWERKS_LANDLORD). Two new fields should be added to hold the description for the two fields. i.e. YLOGICAL_NAME & YLANDLORD_NAME . The value for this field should be pulled from another table (T001W-NAME1).
The 2 new fields YLOGICAL_NAME & YLANDLORD_NAME need to bring automatically T001W-NAME1 into the table. Users will only enter Landlord plant and Logical Plant into the table and the plant descriptions should automatically populated with the T001W-NAME1 Description.
Please let me the know the Logic & Steps involved in it to implement the logic
Thanks
Suresh Kumar