Skip to Content
Former Member
Aug 08, 2007 at 05:37 AM

Doubt on creating joins


Hi friends,

I have two tables , ekes and eine

my requirement is if Ekes-ebtyp = 'X1'.

then Ekes-ebtyp = EKES-EINDT + Eine-j_3alitra.

the doubt is there is no primary key common between this table . actually in my whole program for purchase order i used EBELN for extracting details when two tables are involved . in this two tables no two primary keys are common to extract data there any ways please suggest..

the code i wrote is

loop at li_ekes assigning <fl_ekes>.

read table li_eine assigning <fl_eine> with table key (here i need to give some unique fields to join these two fields please guide me which field i can use.).

<fl_ekes>-ebtyp = <fl_ekes>-EINDT + <fl_eine>-j_3alitra.