‎2008 May 20 2:40 AM
Hello Experts,
I want to use SAP Code Inspector to detect common problematic ABAP codes for all developed programs.
But, I don't know how to make the check variant for detecting follwoing three patterns.
SELECT * FROM
SELECT * INTO
SELECT SINGLE * INTO
I guess I can use "Search for ABAP tokens" or "Search for ABAP statements paterns". But, It did'nt work because ' * ' represents any sequence of characters in the code inspector.
Anyone can help me?
‎2008 May 20 10:41 AM
I managed to set up the variant, however found a problem.
I used "Search ABAP Statement Patterns" under "Search Functs" and set the pattern like followings.
SELECT + INTO *
SELECT SINGLE + INTO *
However following statements were detected.
SELECT * INTO TABLE IT_DRAW FROM DRAW.
SELECT MANDT INTO TABLE IT_DRAW FROM DRAW.
SELECT SINGLE * INTO TABLE IT_DRAW FROM DRAW.
SELECT SINGLE MANDT INTO TABLE IT_DRAW FROM DRAW.
It's because + means one ABAP token in the code inspector.
Is there anyway to find only "SELECT SINGLE *" and "SELECT *" ?
‎2008 May 20 10:51 AM
Hi,
interesting problem. SCI is a great tool, but you might be able to make this particular scan by using program RPR_ABAP_SOURCE_SCAN instead.
Cheers
Thomas
‎2008 May 20 11:33 AM
Thanks..
RPR_ABAP_SOURCE_SCAN works as I expected.
By the way, "Performance Check" -> "Copy Large Data Objects" -> "Wide Structures (> 1000B)"
can also be used as a work around.