topic Re: Joining AFKO and RESB tables in Application Development and Automation Discussions

Joining AFKO and RESB tables

Former Member — Tue, 11 Aug 2009 09:05:14 GMT

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.

Re: Joining AFKO and RESB tables

Former Member — Tue, 11 Aug 2009 09:25:07 GMT

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

Cheers

Ramchander Rao.K

Re: Joining AFKO and RESB tables

Former Member — Tue, 11 Aug 2009 13:18:09 GMT


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