dialog programming, bdc

[Former Member]

i have two tables zfm_handy and zfmkstel

the main key field is telnum.

i m maintaining fields in transaction if u given telnum and press enter we should see the all connected fields to that telnun

plz tell me how can i start this.

[Former Member]

Hi,

When you give the Telnum and press the enter, there would be a OK_CODE for that one, so based on that ok_code, write the select statment to get the fields from those tables, after getting the data just pass the data to the screen fields

Regards

Sudheer

[Former Member]

Hi ,

Based on the Input telnum select from both the tables and display data .

You can use Joins for both tables based on telnum or

select from first table and do second select based on for all entries for the first table where key field would be telnum.

select * from zfm_handy into table itab1 where telnum = input-telnum .

select * from zfmkstel into itab2 for all entries in table itab1 where telum = itab1-telnum .

Please reward if useful.

[Former Member]

YOU HAVE TO CODE IN YOUR PAI.

SCREEN FLOW LOGIC.

PROCESS AFTER INPUT.

MODULE FILL_DATA.

IN ABAP EDITOR.

MODULE FILL_DATA INPUT.

IF <YOURSCREENFIELD OF TELNUM> NE ''.

SELECT SINGLE A_{F1 B}F2 INTO (<YOURSCREENFIELD>, <YOURSCREENFIELD>) WHERE TELNUM = <YOURSCREENFIELD OF TELNUM>.

ENDIF.

ENDMODULE.

REGARDS

SHIBA DUTTA