Skip to Content
avatar image
Former Member

How to link invoice line items VBRP to BSEG lines

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 25, 2008 at 02: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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 25, 2008 at 02: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

    Add comment
    10|10000 characters needed characters exceeded