subroutine for following fields

[Former Member]

Tables : zsd_fr_agence, zcs_seb_district.

using these two tables use bzirk as key filed.

i want to bring following fields into my script form.

Fields are zsd_fr_agence-address1, zsd_fr_agence-address2, zsd_fr_agence-postcode, zsd_fr_agence-city, zsd_fr_agence-tel, zsd_fr_agence-fax.

Pls suggest me the logic for above two tables for bringing above fields into my form.

pls suggest me the exact subroutine.

[Former Member · Accepted solution]

Tables : zsd_fr_agence, zcs_seb_district.

Hi,

DEFINE &VAR1& = ' '

DEFINE &VAR2& = ' '

like this declare all the output variables.

PERFORM XXXXXX IN PROGRAM ZXXXX

USING &BZIRK&

CHANGING &VAR1&

CHANGING &VAR2&

xxxxxxx etc fields list.

Then goto Program ZXXXX

Form XXXXX Tables in_it type ITCSY

out_it type ITCSY.

read in_it index 1.

**then you will get the value of BZIRK using that get the required all the

values and process them into out_it.

Endform.

Edited by: MR Venkat on May 13, 2009 2:29 PM

[Former Member]

Hi,

For getting the data from both these tables u can use 'Inner Join' function.

Thanks.