Skip to Content
0
Former Member
Apr 19, 2005 at 03:04 PM

assigning many Member id's to One Member-id.?

29 Views

Dear Friendz

I have a doubt Can I relate DIFFERENT MemberID Fields from different Tables to ONE MEMBER-ID Field in a Structure.. for example..

In EURX table their is a field Eur_id

IN REPO table their is a field rep_id

In EUS table their is a field Eus_id

in my Function module i have declared some Constants followed by a case statement ..

data: lt_member type table of zmember_s_universal with header line,

ls_member type zmember_s_universal,

lv_table(30).

constants: lc_xtra_market type zdgp_market value '01',

lc_fwb_market type zdgp_market value '02',

lc_eurx_market type zdgp_market value '03',

lc_repo_market type zdgp_market value '04',

case iv_market.

when lc_eurx_market.

lv_table = 'ZTGP_MEMBER_EUR'.

select * from ztgp_member_eur

appending corresponding fields of table et_member_data

where eur_id = iv_member_id and

status = iv_status and

beg_dat le iv_date_effective and

end_dat ge iv_date_effective.

when lc_eus_market.

lv_table = 'ZTGP_MEMBER_EUS'.

select * from ztgp_member_eus

appending corresponding fields of table et_member_data

where eus_id = iv_member_id and

status = iv_status and

beg_dat le iv_date_effective and

end_dat ge iv_date_effective.

Currently I am using another field called MEMBER_ID which I have in a Universal structure with similar data elements for the USER ID's ...But this MEMBER_ID is not related to the fields of the respective fields of the table

SO now in my OUTPUT list if I enter 01 market then under the Member id I want the member id of that particular Market..