on 05-23-2011 9:43 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
resolved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.