‎2022 Aug 27 7:14 AM
Hi, please let me know what is wrong in below query? i have tried with specific fields and with * but when debudding, there is no data in itab ilips eventhough it has been defined correctly and was working fine few days back. Now the table data is blank for all fields.
Select * FROM LIPS INTO CORRESPONDING FIELDS OF TABLE ILIPS FOR ALL ENTRIES IN IVBFA WHERE <br>VBELN = IVBFA-VBELV AND POSNR = IVBFA-POSNV.
‎2022 Aug 27 9:02 AM
Please always review your post after posting, SAP Community software has many bugs. Better formatting:
SELECT * FROM LIPS
INTO CORRESPONDING FIELDS OF TABLE ILIPS
FOR ALL ENTRIES IN IVBFA
WHERE VBELN = IVBFA-VBELV
AND POSNR = IVBFA-POSNV.
‎2022 Aug 27 9:03 AM
As you said, it used to work, so there's no issue with your ABAP statement, technically speaking.
Check what values are in the internal table IVBFA and then check the contents of table LIPS with the Data Browser (SE16) or any other suitable tool.
‎2022 Aug 27 3:21 PM
Hi Sandra, thanks for replying...i checked all the tables and used the same test data which I used earlier but I have no idea why it is not working hence finally I posted here in order to get any different perspective
‎2022 Aug 27 4:55 PM
I can't say. Post the evidence you have found so that people can tell you what can be wrong.