codition

[Former Member]

how to create using a table using condition like if we have gender deatils to create then we have to give here m,f .so in this how to create table?

[Former Member]

hi check this.....example for using the tables

PARAMETERS: p_carr TYPE sflight-carrid,

p_conn TYPE sflight-connid.

DATA sflight_tab TYPE STANDARD TABLE OF sflight.

PERFORM select_sflight TABLES sflight_tab

USING p_carr p_conn.

FORM select_sflight TABLES flight_tab LIKE sflight_tab

USING f_carr TYPE sflight-carrid

f_conn TYPE sflight-connid.

SELECT *

FROM sflight

INTO TABLE flight_tab

WHERE carrid = f_carr AND

connid = f_conn.

ENDFORM.

[former_member156446]

that field need to be a primary key.. so when user try to enter some thing new.. it will raise an error.. he will just select it from the F4 help...

if you donnot want to make it primary key.. in table maintenance generator you have to give the validations.. saying if not male or female raise error..