ABAP hard code value into SELECT and field into another field

abap opensql
shmoolki picture shmoolki · Aug 30, 2016 · Viewed 9.1k times · Source

It is possible in ABAP to make a select and include a hard code value and to put a value in any field.

In my exemple I have to fill a range with Company code BUKRS according to VKORG so I have to do a select on TVKO like that:

DATA : lt_rtvko TYPE RANGE OF bukrs.

  SELECT    'I' as sign 'EQ' as option bukrs as low 
  INTO      CORRESPONDING FIELDS OF TABLE lt_rtvko
  FROM      tvko
  WHERE     vkorg EQ p_vkorg.

But I have a dump.

I know a longer solution to do this, To fill manually a table of TVKO and make a LOOP to fill the range, BUT I am sure that we have a solution to do that in one operation like in my example.

Thanks, Experts.

Answer

user5653854 picture user5653854 · Aug 30, 2016

It's actually pretty easy. Just get rid of INTO CORRESPONDING and AS. As long as the value order is right, you get no problem:

SELECT 'I', 'EQ', bukrs
  FROM tvko
  INTO TABLE @lt_rtvko
 WHERE vkorg = @p_vkorg.

And I think you have a typo in your range declaration. Should be:

DATA: lt_rtvko TYPE RANGE OF bukrs.

Related questions

Most efficient way to select data set conditional upon each other from multiple tables

I have an internal table like: TYPES: BEGIN OF gty_min_jobs, orgeh TYPE zgerpt_rnk_min-orgeh1, mnsty TYPE zgerpt_rnk_min-mnsty, mshort TYPE zgerpt_rnk_min-mshort, position TYPE hrp1001-sobid, job TYPE hrp1001-sobid, job_grade TYPE hrp9003-jobgr, …

Read More
SELECT FOR ALL ENTRIES vs LOOP SELECT SINGLE in ABAP

I am comparing the SELECT FOR ALL ENTRIES vs LOOP SELECT SINGLE and I am having a big difference between results. Somebody can help me with this? What is the difference? SELECT ekko~ebeln ekpo~ebelp ekko~bstyp ekko~bsart …

Read More
Multiple conditions in a SELECT statement?

First off, I have no experience with ABAP, I'm operating on guesswork here. I want to add a condition to a SELECT in an existing report. The existing code looks like this: SELECT SINGLE * FROM EKPO WHERE EBELN = GT_MSEG-EBELN …

Read More