Inner join between VBUP, LIPS and LIKP.

[Former Member]

Hi All,

I need inner join for the following tables:

Table:VBUP Field:WBSTA

Table:LIPS Field:VBLEN,POSNR,MATNR,ARKTX

Table:LIKP Field:VSTEL LFART WADAT

based on some condition, with 1 additional requirment

Only delivery items which has WBSTA eq 'c'.

[Former Member]

HI,

Try to write inner join on your own, but for getting relation among all tables you can

take help of following process.

1. Use SQVI transaction,
2. Create a View
3. Enter title,
4. Choose the Data source as Table Join
5. Now use Insert table option.
6. And insert the tables which you want. It will propose the relation between them.

P.S. Search on SCN for inner join syntax or press F1 on INNER JOIN.

Thanks

Nitesh

[GauthamV]

hi,

use this combination and write your join on select statement.

VBUP-VBELN = LIPS-VBELV

VBUP-POSNR = LIPS-POSNV.