This website is not affiliated with, sponsored by, or approved by SAP AG.

Join VBPA and VBRP

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Join VBPA and VBRP

Postby pejuz1 » Tue Feb 10, 2015 6:44 am

Hello SAP experts
In my query I joined tables VBRP and VBAP. I run the query for one invoice. The result is: I see for this one invoice several records. That is clear because table VBPA contains partners.
I would like to see for one invoice only one line and partner roles I would like to see in column.
Do you have any idea how to do it?

Thank you very much
pejuz1
pejuz1
 
Posts: 164
Joined: Mon Jul 30, 2007 3:34 am

Re: Join VBPA and VBRP

Postby Gothmog » Tue Feb 10, 2015 7:16 am

You'll have to create the different roles as additional fields, code the retrieval of the partner numbers, and get rid of the join.
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67
Gothmog
 
Posts: 1941
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home


Return to ABAP

Who is online

Users browsing this forum: Google [Bot], Google Adsense [Bot] and 10 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.