Linking 2 Tables

[Former Member]

Hello All,

I have got a small report to work on. And for that i need to join two tables Revenue recognition (VBREVE) and Billing Document : Item / header data ( VBRK / VBRP) the field in concern is VBELN_VF.

I tried few things  and also took help of my SD consultants ,but its not going anywhere.

I request you all, to help me in this, as soon as possible.

Thanks & Regards,

Jimmy

[Former Member]

Hello All,

I have got a small report to work on. And for that i need to join two tables Revenue recognition (VBREVE) and Billing Document : Item / header data ( VBRK / VBRP) the field in concern is VBELN_VF.

I tried few things  and also took help of my SD consultants ,but its not going anywhere.

I request you all, to help me in this, as soon as possible.

Thanks & Regards,

Jimmy

[Former Member]

This message was moderated.

[Former Member]

Hello All,

The has been solved by me , and the solution for the above is as follows, hope it will help some....

In table  VBRK-VGBEL is as LIPS_VBELN

  and now table LIPS-VGBEL is the same as table VBAK-VBELN

Now Table VBAK-VBELN is equivalent to VBREVE-VBELN....

SO, as relation can be created...

Regards,

Jimmy

[FredericGirod]

don't use VGBEL ...   for link LIPS & VBAP/VBAK

use the table VBFA

regards

Fred

[FredericGirod]

Hi Jimmy,

gives the part of the code please, it's not so clear

regards

Fred