Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

relation between RESB and AUFM tables

Former Member
0 Kudos

can any one tell me how to build the relation between the above two tables

first i am getting the data from resb

now i need to get the data from aufm

but there are no common key fields

while selecting the data from aufm i want to put the where conditon on key fields only

1 ACCEPTED SOLUTION

Former Member
0 Kudos

If u want to check the relationship between 2 tables then use SQVI transaction and follow these steps

Enter name -> create -> description -> data source = table join -> continue -> edit menu -> insert table 1st -> again edit menu -> insert table 2nd

it will show the related fields in both table

Reward points helpfull if usefull......

7 REPLIES 7

VB09104
Active Participant
0 Kudos

Hi,

there is no relation between the key fields of these tables but you can compare RSNUM, RSPOS and RSART from these tables.

later on if you do not want the duplicates records then after select statement you can use Delete adjacent Duplicates from i_Itab.

Regards,

Vikas.

plz reward if helpful..

Former Member
0 Kudos

here i am looking for the quantity no two records have the same quantity

Former Member
0 Kudos

Hi,

The common fields of both tables are:

RSNUM, RSPOIS, RSART

Regards,

Bhaskar

dev_parbutteea
Active Contributor
0 Kudos

HI ,

You can link RESB and AUFM as follows:

RESB-RSNUM =AUFM-RSNUM

RESB-RSPOS = AUFM-RSPOS

RES-RSART = AUFM-RSART

Thanks and Regards,

Sooness

Former Member
0 Kudos

If u want to check the relationship between 2 tables then use SQVI transaction and follow these steps

Enter name -> create -> description -> data source = table join -> continue -> edit menu -> insert table 1st -> again edit menu -> insert table 2nd

it will show the related fields in both table

Reward points helpfull if usefull......

Former Member
0 Kudos

Hi ,

See RESB table contains data about components of Process Orders .It is Reservation table based on Reservation Number ( RSNUM ) which is present in AUFM .

So the Key field for selection from AUFM is RSNUM ,MATNR ,WERKS and CHARG .

Please reward if useful .

Former Member
0 Kudos

hi

good

use this process to know the details.

Go to SQVI transaction... Create a qucik view.. ztest.. give desc..etc

Select data source as table join.... enter

now one screen will come with blank data (blue scrren)

in that application toolbar second button .. click that.. enter VBAK..

click that again.. enter VBAP.. now an image will come with links b/w vbak and vbap.. you can use any no. of tables there....

thanks

mrutyun^