cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

eduardo_hinojosa
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

In VBRP there exist 3 line items for an invoice:

VBRP-POSNR = 000001 with NETWR = 14,000

VBRP-POSNR = 000002 with NETWR = 14,000

VBRP-POSNR = 000003 with NETWR = 14,000

In BSEG (for same invoice) there exist multiple line items:

BSEG-BUZEI = 005 with WRBTR = 14,000 and HKONT = 12104

BSEG-BUZEI = 006 with WRBTR = 14,000 and HKONT = 12104

BSEG-BUZEI = 007 with WRBTR = 12,393.45 and HKONT = 12104

BSEG-BUZEI = 008 with WRBTR = 1,606.55 and HKONT = 25500

Summation of BSEG-BUZEI 007 (12,393.45) + 008 (1,606.55) = 14,000

I want to be able to link the following:

VBRP-POSNR = 000001 to BSEG-BUZEI = 005

VBRP-POSNR = 000002 to BSEG-BUZEI = 006

VBRP-POSNR = 000003 to BSEG-BUZEI = 007

VBRP-POSNR = 000003 to BSEG-BUZEI = 008

Is there a way to update BSEG in a user exit w/in the SD-FI interface (when the SD billing document is released to accounting to create the FI accounting document) to link the VBRP-POSNR to the corresponding BSEG-BUZEI ?

former_member565100
Active Participant
0 Kudos

Hi Ryan,

Did you get any solution for this.

regards