topic Re: Using Select Statements in Application Development and Automation Discussions

Using Select Statements

Former Member — Tue, 22 Apr 2008 16:15:49 GMT

Hi,

I got error message when execution of my program..it says..

error 23 when accessing table vttk.

and the program got terminated at statrt of selection point itself.

here is the select statement I have used..can someone help me out in fixing this.

do u need to declare seperate internal table for zmmda.

Start-of-selection.

select t001_{bukrs t001}butxt

vttk_{dtabf vttk}tknum

vttk_{route likp}vbeln

likp_{inco1 likp}lfdat

vttk_{text3 vttk}text1

vttk~add04

zmmda~docnum

into corresponding fields of table int_vttk

from ( ( ( ( ( vttk

inner join ttds

on ttds_{tplst eq vttk}tplst )

inner join t001

on t001_{bukrs eq ttds}bukrs )

inner join vtfa

on vtfa_{vbelv eq vttk}tknum )

inner join likp

on likp_{vbeln eq vtfa}vbeln )

left outer join zconshpmnt

on zmmdat_{docnum eq vttk}tknum )

where vttk~dtabf in s_dtabf

and vttk~shtyp in s_shtyp

and vttk~tdlnr in s_tdlnr

and vttk~route in s_route

and ttds~bukrs in s_bukrs

and vtfa~vbtyp_v eq '8'

and vtfa~vbtyp_n eq 'J'.

Stal.

Re: Using Select Statements

Jelena_Perfiljeva — Thu, 24 Apr 2008 20:29:06 GMT

First of all, you have zmmda in one place and zmmdat in another. Second, I don't even see either table joined in the SELECT statement. Instead, you have a join in some table ZCONSHPMNT, which doesn't have corresponding ON.

I'm not sure how it even got past the syntax check.

Re: Using Select Statements

Sm1tje — Thu, 24 Apr 2008 20:36:28 GMT

I have no SAP system to check, but problem could be this:

left outer join zconshpmnt

on zmmdat_{docnum eq vttk}tknum )

zmmdat -> shouldn't this be zconshpmnt?