Skip to Content
0
Former Member
Sep 14, 2007 at 08:50 AM

Inner join with offset

579 Views

Hello Friends,

I want the select statment with the followint joining conditions

VEIAV-BELEGNUMR = EKBE-EBELN

VEIAV-HAUPTPOSI = EKBE-EBELP

EKBE-BELNR = BKPF-AWKEY+0(10).

EKBE-GJAHR = BKPF-AWKEY+ 11(4).

I used the following select statment

GV_BELNR = BKPF-AWKEY+0(10).

GV_GJAHR = BKPF-AWKEY+11(4).

SELECT VEIAV~DATUMJAHR

VEIAV~DATUMMONA

VEIAV~LFDNRVEIA

VEIAV~NUMMBUKRS

VEIAV~BELEGNUMR

VEIAV~HAUPTPOSI

VEIAV~STATWAREN

VEIAV~RECHNWEAK

VEIAV~GRENZWEAK

VEIAV~MATNR

INTO TABLE GT_VIEAV FROM

( ( VEIAV INNER JOIN EKBE ON VEIAVBELEGNUMR EQ EKBEEBELN

AND VEIAVHAUPTPOSI EQ EKBEEBELP )

INNER JOIN BKPF ON EKBE~BELNR EQ GV_BELNR

AND EKBE~GJAHR EQ GV_GJAHR )

WHERE VEIAV~DATUMJAHR = P_DJAHR AND

VEIAV~DATUMMONA = P_DMONA AND

VEIAV~ARRIVDEPA = P_ADEPA AND

EKBE~VGABE = P_VGABE.

But it's giving syntax error.

Could you please tell me how the above select statment with offset?

Thank you in advance,

Arvind.