topic Re: Client-Specified in Application Development and Automation Discussions

Client-Specified

Former Member — Wed, 30 May 2007 12:42:19 GMT

I am executing the following SQL statment in client 10.

data anlz_table type table of anlz.

SELECT bukrs anln1 kostl FROM anlz INTO TABLE anlz_table.

The result set includes records from client 10, as expected.

However, the result set also includes records from other

clients as well.

Why are records of clients other than 10 included?

Former Member — Wed, 30 May 2007 12:45:25 GMT

hmmm sry not a real clue, it should work the way you do it, i just found one minor bug.

instead of:

SELECT bukrs anln1 kostl FROM anlz INTO TABLE anlz_table

better write:

SELECT bukrs anln1 kostl FROM anlz INTO corresponding fields of TABLE anlz_table

BTW not sure if this is the way to go, but why dont you just specify your client?

Message was edited by:

Florian Kemmer

Former Member — Wed, 30 May 2007 12:49:11 GMT

HI,

if the table is client independent (i.e, first field in the table is not clnt data type) it will fetch data from other clients also.

may in ur case the table is client independent.

rgds,

bharat.

dev_parbutteea — Wed, 30 May 2007 12:53:49 GMT

HI,

add client (MANDT) to select statement.

Former Member — Wed, 30 May 2007 12:53:54 GMT

hi,

I think table anlz is client independent.

incude client (MANDT)

If the table is client dependent.it will fetch data only from that table.

Reward with points if helpful.

Message was edited by:

Vinutha YV