how can i link REGUP table with RBKP table..

[Former Member]

Hi..

I wanted to get a unique record from RBKP for each of the record found in the REGUP..

Can you please let me know if that is possible and if so what are the fields that you should be using to link both the tables...

Apprecitate your help...

Thanks,

Kanthi..

[Former Member]

Hi

I don't if there's a direct link between RBKP and REGUP, but there is the link between BKPF and RGUP.

So you can use BKPF table to create a link between RBKP and REGUP.

CONCATENATE RBKP-BELNR RBKP-GJAHR INTO AWKEY.

SELECT * FROM BKPF WHERE AWTYP = 'RMRP'

AND AWKEY = AWKEY.

ENDSELECT.

and so:

SELECT * FROM REGUP WHERE BUKRS = BKPF-BUKRS

BELNR = BKPF-BELNR

GJAHR = BKPF-GJAHR

.........

Max