2005 Jul 14 7:43 AM
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.
2005 Jul 14 7:48 AM
Use the table VBPA and for the selection use VBELN and POSNR.
2005 Jul 14 9:35 AM
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.
2005 Jul 14 9:48 AM
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.
2005 Jul 14 10:45 AM
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
2005 Jul 14 12:51 PM
Thanks all for your reply.
got a Solution.
VBRP-POSPA = VBPA-POSNR.