First I create table ZCAR2 with two fields BRAND and MODEL. Data elements and domains for the two fields are ZBRAND and ZMODEL. I'm planing to create table ZEMPCAR1 and create a table maintenance for it which can select the MODEL from ZCAR2. For that I create MODEL as a key field.
Then insert few data to ZCAR2 table.
Then Create table ZEMPCAR1 with two fields EID and EMODEL. Data elements and domains for EID and EMODEL are ZEID and ZMODEL.
Now go to SE11 and display ZEMPCAR1. Then select EMODEL and then select Foreign key icon.
In the dialog below, insert ZCAR2 as the check table.
Then go to Utilities -> Table maintenance generator. Then provide related details and save.
Now go to sm30 , enter table name ZEMPCAR1 and maintain.
Then select New entries. Now the MODEL field in the maintenance view has a drop down menu. From that drop down menu I can select a car model from ZCAR2 table.
Now I can only add car models in ZCAR2 only for the MODEL firld of ZEMPCAR1 table :)
But in your explanation there is no drop down it is only f4 we can see
ReplyDeletecan u explain how to display dropdown
ReplyDelete