Joins for Report ABAP

[former_member711689]

How to join tables (AUFK, AFKO, AFPO) which already joined using aufnr with these tables RESB, AFRU, PLPO and MARA. All together 7 tables for a report!

[former_member34]

Thank you for visiting SAP Community to get answers to your questions. Since you're new in asking questions here, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen/done, make sure you've applied the appropriate tags, and use a more descriptive subject line. The more details you provide, the more likely it is that members will be able to assist you. You should also make sure you're using all the appropriate tags, so the right experts can find your question.

Should you wish, you can revise your question now by selecting Actions, then Edit.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS . By personalizing your profile with a photo of you, you encourage readers to respond.

Best regards

Jennifer

SAP Community moderator

[Pankaj_Gupta]

You should consult your Functional consultant for a better response with your context.

[former_member597044]

Can you elaborate the question ?

[vinita_kasliwal]

Hi Anvitha

Probably by doing some hit and trial would have been easy to find here are some of my findings:

1. AUFK, AFKO, AFPO can be connected with AUFNR with RESB-AUFNR and AFRU-AUFNR

2. To join with PLKO

AUFK-AUFNR = AFKO-AUFNR

AFKO-PLNTY = PLKO-PLNTY and

AFKO-PLNNR = PLKO-PLNNR

PLKO PLNNR, PLNTY = PLPO - PLNNR , PLNTY

3. AFPO- MATNR = MARA - MATNR

Better is for you to either use SQVI or do some hit and trial with expected data in the report

Hope the above helped.

Regards

Vinita

[former_member711689]

Hi, this helped me! Thanks!