topic Re: How Select From Local IT ! in Application Development and Automation Discussions

How Select From Local IT !

srahemi — Thu, 26 Sep 2019 09:35:45 GMT

DATA :
  IT_DATA_GRID1 TYPE TABLE OF BKPF,
  IT_DATA_GRID2 TYPE TABLE OF BKPF.

START-OF-SELECTION.
SELECT * INTO CORRESPONDING FIELDS OF TABLE IT_DATA_GRID1 FROM BKPF UP TO 10 ROWS.

How select again from IT_DATA_GRID1 ?

SELECT * INTO CORRESPONDING FIELDS OF TABLE IT_DATA_GRID2 FROM ????????? .

Re: How Select From Local IT !

former_member1716 — Thu, 26 Sep 2019 09:39:09 GMT

Hello sina rahemi,

Try this: Updated

SELECT * INTO CORRESPONDING FIELDS OF TABLE IT_DATA_GRID2 FROM @IT_DATA_GRID1 as IT_TEMP.

This Should Work.

Re: How Select From Local IT !

former_member1716 — Thu, 26 Sep 2019 09:50:28 GMT

In the Above Query it is mandatory that you need to use the Keyword AS, the name after the key word can be anything. I have given IT_TEMP as an example.

Re: How Select From Local IT !

srahemi — Thu, 26 Sep 2019 10:34:52 GMT

thanks but it doesn't work

2019-09-26-13-34-57.png

Re: How Select From Local IT !

former_member1716 — Thu, 26 Sep 2019 11:29:07 GMT

Hello sina rahemi,,

Try the Below Code, it works in my system.

If it does not work as well then Your version does not support this functionality. It is supported from version 750. what is your version?

Re: How Select From Local IT !

loyd_enochs3 — Thu, 26 Sep 2019 12:06:01 GMT

It depends on what you are trying to accomplish. If you need to populate IT_DATA_GRID2 with the same starting data as IT_GRID1, then simply move IT_DATA_GRID1 to GRID2 before you manipulate the contents of GRID1. Then you will have a "clean copy" of the original SELECT throughout the rest of the program execution.

If you are trying to manipulate GRID1 and then use those results to populate GRID2, use some variation of LOOP AT GRID1 into GRID2 WHERE..... (Remember that SELECT is only to use to retrieve data from database tables, not internal tables.)

If you are trying for something else, please provide more detail on the requirements.

Re: How Select From Local IT !

srahemi — Thu, 26 Sep 2019 13:23:12 GMT

Thanks for all your effort and time consumed
I try it but didn't work

Re: How Select From Local IT !

FredericGirod — Thu, 26 Sep 2019 13:33:02 GMT

But what is your objective ?

what is the difference between the two internal tables for your final result ?

Re: How Select From Local IT !

srahemi — Thu, 26 Sep 2019 13:33:27 GMT

Hello Loyd Enochs.

You are right.

I want select from bkpf into it1

change it1 data

select * INTO CORRESPONDING FIELDS OF TABLE IT_Grid1 FROM BKPF INNER JOIN IT1 on ...

Re: How Select From Local IT !

FredericGirod — Thu, 26 Sep 2019 13:39:25 GMT

select * into corresponding field of table it_grid1 from bkpf

select * appending corresponding field of table it_grid1 from bkpf

is it your objectif ?

Re: How Select From Local IT !

former_member1716 — Thu, 26 Sep 2019 13:41:09 GMT

Hello Sina Rahemi,

Can you give a screen shot of your current syntax?

How does your code look like now, also what is the declaration part?

Can you give the complete details?

Re: How Select From Local IT !

Sandra_Rossi — Thu, 26 Sep 2019 13:46:39 GMT

Sina Rahemi In fact, you are showing the version of the software which renders the SAP screens, which is not related to ABAP. You may obtain the ABAP version by menu System -> Status -> Components SAP_Basis/SAP_ABAP.

Re: How Select From Local IT !

former_member1716 — Fri, 27 Sep 2019 04:21:32 GMT

Sina Rahemi Kindly send the screen shot of your SAP LOGON PAD.

Re: How Select From Local IT !

srahemi — Fri, 27 Sep 2019 19:40:02 GMT

Hi Satish Kumar Balasubramanian.

You are right, my version does not support this.

Re: How Select From Local IT !

Sandra_Rossi — Sat, 28 Sep 2019 06:49:27 GMT

Why posting an image instead of code that can be copy/pasted?