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.