Skip to Content
avatar image
Former Member

link SD item billing (VBRP) to FI item accounting (BSEG) tables

We have an issue: we're trying to create a link b/w the item number in the SD billing document (VBRP) table and the item number in the FI accounting document (BSEG) table. This is our problem:

invoice 9100922958 contains 3 items each with a net value of $14K

VBRP item 1 - amount 14K

VBRP item 2 - amount 14K

VBRP item 3 - amount 14K

These 3 items all have same reference (contract 41002892 - item 10) b/c they are settlement periods in a billing plan due for billing. However, they post differently due to revenue recognition.

When posting to accounting (we're using standard revenue recognition), in BSEG there are multiple entries:

BSEG item 5 - amount 14K - G/L account Unbilled

BSEG item 6 - amount 14K - G/L account Unbilled

BSEG item 7 - amount 12,393.45 - G/L account Unbilled

BSEG item 8 - amount 1,606.55 - G/L account Deferred

We want to be able to link the following:

VBRP item 1 = BSEG item 5

VBRP item 2 = BSEG item 6

VBRP item 3 = BSEG items 7 and 8 (summation of items 7 & 8 equal value of VBRP item 3)

Is there a user exit in BSEG to create this link? Is there a way to update the BSEG table with the corresponding VBRP item number?

Thanks-

MLK

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 16, 2008 at 04:57 AM

    Hi Ryan,

    You can get the link between VBRP and BSEG.

    First take the billing document number in VBRP and VBRK -VBELN and get the header details with that take the Document Condition number (VBRK-KNUMV ) and put it in (BSEG-BELNR ) you will get the document numbers with that you can link between VBRP and BSEG with what ever you choose the GL's .

    if you give me brief i can help you out more.

    Thank you.

    Regards

    Ram

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 23, 2010 at 07:59 AM

    Hi,

    First of all. Check if you are doing the summarization in FI for invoices. Check SAP Note 545137 - FAQ Interface - summarization and note 36353 AC interface: Summarizing FI documents.

    Useful userexits the in the interface FI-SD is related in Note 301077 - User exits for the interface to accounting. Perhaps you can analize what field to use to create the link if you are doing the summarization.

    I hope this helps you

    REgards

    Eduardo

    Add comment
    10|10000 characters needed characters exceeded