cancel
Showing results for 
Search instead for 
Did you mean: 

DBIF_RSQL_INVALID_RSQL with exception CX_SY_OPEN_SQL_DB .

Former Member
0 Kudos

hello,

the error is coming because of this sql stmt.

select VBAKAUART VBAKAUGRU VBAKFAKSK VBAKSUBMI VBAKVBELN VBAKVKORG

VEDAVBELN VEDAVENDDAT VEDAVENDREG VEDAVKUEGRU FPLA~AUTTE FPLA

FPLAFPLNR FPLAHORIZ FPLAPERAF FPLAPERIO

into (VBAK-AUART , VBAK-AUGRU , VBAK-FAKSK , VBAK-SUBMI , VBAK-VBELN , V

, VBKD-VBELN , VEDA-VBEGDAT , VEDA-VBELN , VEDA-VENDDAT , VEDA-VEND

, FPLA-ENDAR , FPLA-ENDAT , FPLA-FPART , FPLA-FPLNR , FPLA-HORIZ ,

from ( VBAK

inner join VBKD

on VBKDVBELN = VBAKVBELN

inner join VEDA

on VEDAVBELN = VBKDVBELN

inner join FPLA

on FPLAFPLNR = VBKDFPLNR )

where VBAK~AUART in SP$00006

and VBAK~AUGRU in SP$00005

and VBAK~FAKSK in SP$00003

and VBAK~SUBMI in SP$00004

and VBAK~VBELN in SP$00007

and VBAK~VKORG in SP$00002

and VBAK~ZZXCTYP in SP$00001

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi,

this is not the forum for your problem !!

you should first use TRY .... CATCH .... ENDTRY for catching any exception in your programme and second for avoiding that a short dump occurs. Third, you should not concatenate so many tables in your SELECT instruction. You better read table VBAK first and then use SELECT SINGLE.

Answers (1)

Answers (1)

Former Member
0 Kudos

resolved