5 pts.
 Finding subsequent sales doc from invoice
SAP
Hi, I new to SAP and am trying to create a report which will give me the sales document for the invoices which were created within a specific timeframe. In my company, we create one invoice per day, for all of the items which are delivered for a single customer (there can be multiple deliveries in a single day per customer, but only one invoice for all of those deliveries). I cannot find a direct link between tables VBRK-VBELN and VBAK-VBELN so I have tried to use table VBFA, but have not had any luck... I get no results. My preference would be to stay at the header level instead of the item level, since when I use VBRP to link to the sales document, I get multiple results - one for each line item on the invoice. I only want a single sales document number for that invoice. Is there any easy way to accomplish these desired results?

Software/Hardware used:
ASKED: October 5, 2007  9:04 PM
UPDATED: October 6, 2007  12:39 AM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _