Client-Specified

[Former Member]

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]

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]

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]

HI,

add client (MANDT) to select statement.

[Former Member]

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