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: 
SAP Community Downtime Scheduled for This Weekend

Invoice partner roles

Former Member
0 Kudos
773

Dear all,

A single invoice can be send to multiple delivery adresses. In which data table can I have access to these multiple delivery addresses? I have acces to VBRK, VBRP and VBPA. Does anyone have an idea?

Thx in advance

Best regards,

Alexander Suckow

1 ACCEPTED SOLUTION

Former Member
0 Kudos
79

If I understand this, Alexander, you want the multiple deliveries that were associated with a single invoice.  Is that what you're asking?  If so, the prior documents for the delivery (and the sales) order are in the prior document and item fields in VBRP.  And, likewise, the prior document and item for the delivery is in the prior document fields in LIPS. 

From VBRP (invoice items), I would get the prior delivery documents for all invoice items (VBRP-POSNR).  Then, I would read VBPA looking for the partner codes I wanted, bill-to, ship-to, sold-to, payer, etc., by reading for the list of delivery documents obtained from VBRP prior document/item fields and the partner type (PARVW) values that I needed to obtain, remembering that the database code is different for each than the display code.

I would guess that your configuration allows multiple deliveries from a single sales order and item, and combining of multiple deliveries into a single invoice?  And, I hope this is actually helpful, since I'm not really sure what you're trying to get to.

If you are new to SD/LE reporting please read SAP Note 185530 on how to do reporting properly, and discuss how your SD configuration affects delivery and invoice split and combine with your SD specialist.

1 REPLY 1

Former Member
0 Kudos
80

If I understand this, Alexander, you want the multiple deliveries that were associated with a single invoice.  Is that what you're asking?  If so, the prior documents for the delivery (and the sales) order are in the prior document and item fields in VBRP.  And, likewise, the prior document and item for the delivery is in the prior document fields in LIPS. 

From VBRP (invoice items), I would get the prior delivery documents for all invoice items (VBRP-POSNR).  Then, I would read VBPA looking for the partner codes I wanted, bill-to, ship-to, sold-to, payer, etc., by reading for the list of delivery documents obtained from VBRP prior document/item fields and the partner type (PARVW) values that I needed to obtain, remembering that the database code is different for each than the display code.

I would guess that your configuration allows multiple deliveries from a single sales order and item, and combining of multiple deliveries into a single invoice?  And, I hope this is actually helpful, since I'm not really sure what you're trying to get to.

If you are new to SD/LE reporting please read SAP Note 185530 on how to do reporting properly, and discuss how your SD configuration affects delivery and invoice split and combine with your SD specialist.