Storing field value into variable using select query

[former_member600516]

 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?

[GK817]

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

[GK817]

Are you getting any error?

[former_member600516]

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

[p244500]

learn new way to code

SELECT, Inline Declarations

ABAP News for 7.40, SP08 – Open SQL

[Sandra_Rossi]

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?

[GK817]

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.

[former_member1716]

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!

[michael_koehler2]

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