04-30-2012 5:26 PM
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
04-30-2012 6:13 PM
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.
04-30-2012 6:13 PM
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.