topic Re: Getting data from work area data in Application Development and Automation Discussions

Getting data from work area data

ratana_pouy — Fri, 21 Jul 2023 03:43:34 GMT

Hi,

i am trying to get data from standard table based on data in work area or internal table.

   DATA: s_aufnr  TYPE aufm-aufnr,
          tmp_aufm TYPE aufm-aufnr.
    SELECT DISTINCT aufnr FROM @ct_ioopcomp AS zct_ioopcomp INTO @tmp_aufm.
      SELECT * FROM aufm INTO TABLE @DATA(zaufm) WHERE aufnr IN @ct_ioopcomp-aufnr.
    ENDSELECT.

Distintct a field from internal table "ct_ioopcomp" into "tmp_aufm" then using these data to grab from standard table "AUFM". but it doesn't work.

Please kindly advise.

Thanks,

RTN

Re: Getting data from work area data

xiaosanyu — Fri, 21 Jul 2023 04:41:57 GMT

SELECT DISTINCT aufnr FROM @ct_ioopcomp AS zct_ioopcomp INTO TABLE @DATA(LT_AUFNR).
SELECT A~* FROM aufm AS A JOIN  @LT_AUFNR AS B ON A~AUFNR = B~AUFNR INTO TABLE @DATA(LT_AUFM).

Re: Getting data from work area data

Sandra_Rossi — Fri, 21 Jul 2023 08:18:03 GMT

Valid only from ABAP 7.52 with HANA.

Re: Getting data from work area data

Sandra_Rossi — Fri, 21 Jul 2023 08:20:35 GMT

It's generally wrong to ask a question just saying that "it doesn't work" without giving further details. Instead you should say that you have a syntax error with given message at given line, etc.

Re: Getting data from work area data

matt — Fri, 21 Jul 2023 11:30:33 GMT

ct_ioopcomp isn't a range, so you can't use IN with it.

Do an INNER join with ONE select statement.