topic how to feach data from database table to internal table in Application Development and Automation Discussions

how to feach data from database table to internal table

1190_5939_439 — Tue, 13 Apr 2021 03:08:28 GMT

Hi Experts

The code is following. There are some data in the item2. But I hope feach lgort from mseg to item2.

But the result is not right .Can you help me ?

Thanks in advance.

SELECT  MSEG~LGORT
    INTO CORRESPONDING FIELDS OF TABLE ITEM2
    FROM MSEG
     FOR ALL ENTRIES IN ITEM2
    WHERE  MBLNR = ITEM2-BELNR AND matnr = ITEM2-matnr .

Re: how to feach data from database table to internal table

tom_wan — Tue, 13 Apr 2021 03:38:42 GMT

没有图啊，不确定什么问题。估计跟列名有关系。你试试别名。

起的别名要跟ITEM2里你想存LGORT的列同名

SELECT MSEG~LGORT as <XXXXX>

INTO CORRESPONDING FIELDS OF TABLE ITEM2

FROM MSEG

FOR ALL ENTRIES IN ITEM2

WHERE MBLNR = ITEM2-BELNR AND matnr = ITEM2-matnr .

然后这里怎么ITEM2又在FAE里又在INTO里，感觉怪怪的(是不是不太好 😞 )

Re: how to feach data from database table to internal table

Sandra_Rossi — Tue, 13 Apr 2021 08:33:25 GMT

Better answer in English if the question is asked in English, so that future visitors can understand the answer if they have the same question 😉

Re: how to feach data from database table to internal table

tom_wan — Wed, 14 Apr 2021 00:06:51 GMT

Thanks for your advice.

I think the cause is the "MSEG~LGORT" doesn't exist in ITEM2.

I suggest use alias:

SELECT MSEG~LGORT as <XXXXX>

INTO CORRESPONDING FIELDS OF TABLE ITEM2

FROM MSEG

FOR ALL ENTRIES IN ITEM2

WHERE MBLNR = ITEM2-BELNR AND matnr = ITEM2-matnr .

<XXXXX> must equals to the column name of LGORT in ITEM2