09-25-2008 3:04 PM
Dear all,
We're trying to link VBRP records to BSEG records. Only link we've found is the VBELN and nothing abouth line items. VBRP has line items indexed with POSNR like 10,20,30 ... etc. BSEG has lines indexed with BUZEI 001,002,003 ...etc. So we could not match wich VBRP line linked to the wich BSEG line. I've looked the past incidents in forum but none of them answered. Is there another table which keeps link between those tables ? Any help greatly apprecited !
Thx.
09-25-2008 3:07 PM
Hi,
There is no link from VBRP to BSEG directly.
This is because the data in BSEG is posted to various accounts and the VBRP is usually for a Sales Order or Delivery.
However there is a link from BKPF to VBRK and VBRK is linked to VBRP.
BKPF-AWKEY has the the Invoice number VBRK-VBELN
Hope this helps.
regards,
Advait
09-25-2008 3:07 PM
Hi ,
I guess No. but if u r using the max fields from these table try to create the one database view. it will help u out.
Regards,
bharani
09-25-2008 3:07 PM
Hi,
There is no link from VBRP to BSEG directly.
This is because the data in BSEG is posted to various accounts and the VBRP is usually for a Sales Order or Delivery.
However there is a link from BKPF to VBRK and VBRK is linked to VBRP.
BKPF-AWKEY has the the Invoice number VBRK-VBELN
Hope this helps.
regards,
Advait
09-25-2008 3:20 PM
Thanks for your comments folks. However as you know these are not solution. I think we've crashed to the wall of SAP limits. Honestly it is difficult to beleive to cannot establish a line item level relation between invoice and financial records in such a complete ERP software.
Thx.
09-25-2008 3:25 PM
09-26-2008 7:52 AM
Thanks for your attention. However I could not see anything abouth how to link BSEG and VBRP tables at line item level in that document.
09-26-2008 2:01 PM
Well, it doesn't spell it out for you, but look at the portion on sales documents.
Rob