topic Re: Why 'CLIENT SPECIFIED' doesn't works? in Application Development and Automation Discussions

Why 'CLIENT SPECIFIED' doesn't works?

BergOff — Mon, 21 Oct 2024 18:00:12 GMT

Hi, experts.
Why client specified doesn't work.
I'm sure that i'm having roles for updating values in system and that table is not initial.
When i try to remove WHERE statement - it's just getting a values from current system.

data : lt_tab type table of mara. select * from mara CLIENT SPECIFIED into CORRESPONDING FIELDS OF TABLE lt_tab where mandt = '500'. write : '123'

Current mandt EGD - 300. I want to get values from EGP 500.
I think it's just ignores 'CLIENT SPECIFIED' for some reasons.

And sy-subrc = 4.
Here's trace

Re: Why 'CLIENT SPECIFIED' doesn't works?

Dominik_Tylczynski — Mon, 21 Oct 2024 17:48:56 GMT

Hello @BergOff

I don't think CLIENT SPECIFIED is ignored. Look at your trace. The last lines show variable value = 500, which is the client number you have specified in the query.

Best regards

Dominik Tylczynski

Re: Why 'CLIENT SPECIFIED' doesn't works?

RobertVit — Tue, 22 Oct 2024 06:42:26 GMT

Hi,

i think using client is missing

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/index.htm

Re: Why 'CLIENT SPECIFIED' doesn't works?

BergOff — Tue, 22 Oct 2024 07:01:57 GMT

I would be having same value for the variable if i remove 'client specified'. It would be trying to find records with another mandt field, as i think it does now and just ignores 'client specified'. Sy-subrc = 4.

And as i told, if not to specify mandt field - it will collect data from current mandt not from all of them.

Re: Why 'CLIENT SPECIFIED' doesn't works?

RaymondGiuseppi — Tue, 22 Oct 2024 07:21:11 GMT

Client specified will read data from current system for another client, not from another system

Don't expect to read data from system EGP client 500, but from current system EGD client 500.
To read from another system consider RFC enabled FM such as RFC_READ_TABLE

Re: Why 'CLIENT SPECIFIED' doesn't works?

Dominik_Tylczynski — Tue, 22 Oct 2024 07:51:48 GMT

That's spot on! I've not noticed that OP wants to read from another system.