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: 

How to link invoice line items VBRP to BSEG lines

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

6 REPLIES 6

P561888
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

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.

0 Kudos

Please see:

[ Quickly Retrieving FI document Data from BSEG|]

Rob

0 Kudos

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.

0 Kudos

Well, it doesn't spell it out for you, but look at the portion on sales documents.

Rob