topic Re: Storing field value into variable using select query in Application Development and Automation Discussions

Storing field value into variable using select query

former_member600516 — Mon, 16 Dec 2019 16:21:29 GMT

 DATA var TYPE c LENGTH 20.
 SELECT SINGLE lokkt FROM bseg INTO var WHERE hkont = value.

Hey gurus, I'm trying to store a field value from table directly into a variable using this query.. I'm guessing there is a logical error or the query itself could be wrong.. if so then please help me understand how could i achieve this or fix it?

Re: Storing field value into variable using select query

GK817 — Mon, 16 Dec 2019 16:30:04 GMT

SELECT SINGLE lokkt FROM bseg INTO  @DATA(lv_lokkt) where hkont =  @value.

Re: Storing field value into variable using select query

GK817 — Mon, 16 Dec 2019 16:30:40 GMT

Are you getting any error?

Re: Storing field value into variable using select query

former_member600516 — Mon, 16 Dec 2019 16:35:56 GMT

The program is going into infinite loop.. since this is the only change i made i'm guessing this query broke something else in the code

Re: Storing field value into variable using select query

Nawanandana — Mon, 16 Dec 2019 16:44:12 GMT

learn new way to code

SELECT, Inline Declarations

ABAP News for 7.40, SP08 – Open SQL

Re: Storing field value into variable using select query

Sandra_Rossi — Mon, 16 Dec 2019 16:44:55 GMT

Infinite loop or just very very very long? BSEG used to be a cluster table, so maybe it's your case, and HKONT is not part of the primary key, consequently, a huge number of lines will have to be read from BSEG table until one line satisfies the condition.

What did you change?

Re: Storing field value into variable using select query

GK817 — Mon, 16 Dec 2019 17:03:55 GMT

No loop there.

Please try UPTO 1 ROWS or may be 100 ROWS and see if you get the results. If yes, then may be it's the huge data as suggested by Sandra.

Re: Storing field value into variable using select query

former_member1716 — Mon, 16 Dec 2019 18:18:30 GMT

Prasad Supare,

The data type of the field used in the select Query is different from the variable, you need to correct that. You data declaration and code must be as below:

DATA var TYPE ALTKT_SKB1.
SELECT SINGLE lokkt 
FROM bseg 
INTO @var 
WHERE hkont = @value.

Or

You can use the code suggested by Gaurav Above.

Regards!

Re: Storing field value into variable using select query

Former Member — Mon, 16 Dec 2019 18:47:32 GMT

Hi Prasad,

In the old days FiDoc item table BSEG used to be a cluster table w/ only BELNR / POSNR as the primary key. The way to go was to look for a secondary index either on BKPF (FiDoc Header) or one of the secondary index tabs (BSID... etc). Check if HKONT is an index on BKPF or another table that contains the BELNR, then join w/BSEG on BELNR. That should give you acceptable performance... at least used to in ECC. S/4 HANA; no clue, but worth a try!

A remark on the other answers: IMHO they 'only' address the 'formally unclean' code, but not the performance... (except, of course, Sandra's comment...)

All the best,
Mike