Community
Application Development and Automation 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: 
Read only

Joining AFKO and RESB tables

Former Member

‎2009 Aug 11 10:05 AM

5,217

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.

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.

Reply
2 REPLIES 2
Read only

Former Member

‎2009 Aug 11 10:25 AM

0 Likes
2,104

Hi

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

Cheers

Ramchander Rao.K

Read only

Former Member

‎2009 Aug 11 2:18 PM

2,104

> 

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