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: 

Joining AFKO and RESB tables

Former Member
3,474

Hi Folks,

I want to join the AFKO and RESB. I have used RSNUM column in both tables to join but I am not getting the expected result.

So what could be the join condition, i.e. which columns should I use?

Thanks in advance.

2 REPLIES 2

former_member1245113
Active Contributor
0 Kudos
361

Hi

YOu can use the PLNBEZ from AFKO and MATNR from RESB tables

Cheers

Ramchander Rao.K

Former Member
361

>

> Hi Folks,

> I want to join the AFKO and RESB. I have used RSNUM column in both tables to join but I am not getting the expected result.

>

> So what could be the join condition, i.e. which columns should I use?

> Thanks in advance.

why not? this is perfect. AFKO-RSNUM is the key for RESB. of course, you can have > 1 hit in RESB with that number(because there might be more than one item to a reservation). if you have more than one requirement-type you can also evaluate BDART (but coming from a production or service order this should usually be AR). RSART would tell you about the kind of reservation, but again: coming from a production or service order this field should be blank.