Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Linking 2 Tables

Former Member
0 Kudos
97

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

4 REPLIES 4

Former Member
0 Kudos
48

This message was moderated.

Former Member
0 Kudos
48

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

0 Kudos
48

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

use the table VBFA

regards

Fred

FredericGirod
Active Contributor
0 Kudos
48

Hi Jimmy,

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

regards

Fred