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
Showing results for 
Search instead for 
Did you mean: 

Item Level partner Details??

Former Member
0 Kudos
929

Hi All,

I do have invoice number and i can view the invoice using VF03.

I want to know which Table store Item Level Partner Details?

Thanks in advance.

5 REPLIES 5

Vinod_Chandran
Active Contributor
0 Kudos
286

Use the table VBPA and for the selection use VBELN and POSNR.

0 Kudos
286

Thanks for your reply !!!

from VBRP table below are the records

VBELN POSNR

0090000123 000010

0090000123 000020

0090000123 000030

0090000123 000031

0090000123 000032

And from VBPA

VBELN POSNR PARVW KUNNR

0090000123 000000 AG UW1000

0090000123 000000 RE UW1000

0090000123 000000 RG UW1000

0090000123 000010 WE 0000010001

0090000123 000031 WE 0000010026

Where in VF03, i can see partner at each line item. Partner for line item 20, 31 and 32 are not appearing.

Let me know if you know some other table or way to get Partner deatils.

0 Kudos
286

This is the only place (VBPA) where you can find the partner details. If you see in the VF03 then it must be in VBPA. Check for some other invoices.

Former Member
0 Kudos
286

Hi,

If you do not find an entry in table VBPA for your line number, you should use the records from item "000000". SAP will only store partner information on item level if it is different from the header (000000).

This will reduce the number of entries in VBPA if the information is the same for mutiple items or the entire document (data-redunancy).

regrads,

Arjan

0 Kudos
286

Thanks all for your reply.

got a Solution.

VBRP-POSPA = VBPA-POSNR.