Skip to Content
0
Jul 20, 2016 at 04:30 PM

Link between VBAP (Sales docs) and VBRK (Billing)

1758 Views

Hi, I need to get the VBRK data that corresponds to a particular VBAP record. The logical path would be accessing vbrk.vbeln using the VBRP table (vbrp.aubel = vbap.vbeln , vbrp.aupos = vbrp.posnr).

My problem is that, at least in our system, we don’t have an index with AUBEL/AUPOS, so a search as the above described results in a full table scan…

An additional issue is that I can have several vbrk.vbeln documents (cancelled or not) for a particular vbap.vbeln/vbap.posnr record, so the VBFA table is (I think) of not help here.

Any ideas?

Thanks in advance,

Luis