topic Linking 2 Tables in Application Development and Automation Discussions

Linking 2 Tables

Former Member — Thu, 01 Aug 2013 07:22:28 GMT

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

Re: Linking 2 Tables

Former Member — Fri, 02 Aug 2013 06:53:07 GMT

This message was moderated.

Re: Linking 2 Tables

Former Member — Fri, 02 Aug 2013 06:53:08 GMT

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

Re: Linking 2 Tables

FredericGirod — Fri, 02 Aug 2013 06:54:13 GMT

Hi Jimmy,

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

regards

Fred

Re: Linking 2 Tables

FredericGirod — Fri, 02 Aug 2013 07:00:20 GMT

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

use the table VBFA

regards

Fred