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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Joining AFKO and RESB tables

Former Member

‎08-11-2009 10:05 AM

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

‎08-11-2009 10:25 AM

0 Kudos

Hi

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

Cheers

Ramchander Rao.K

Former Member

‎08-11-2009 2:18 PM

> 

> 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.