topic Re: Select Statement error in Application Development and Automation Discussions

Select Statement error

Former Member — Mon, 08 Sep 2008 02:38:20 GMT

Hi Experts,

I wrote my select statements as follows. But when I do code inspector check i get the following warning message. Can anyone help me with this issue.

Thanks in advance.

SELECT a_{gjahr a}perbl a_{versn b}kostl b_{kokrs a}kstar

a_{wrttp a}beknz a_{wkg001 a}wkg002 a~wkg003

a_{wkg004 a}wkg005 a_{wkg006 a}wkg007 a~wkg008

a_{wkg009 a}wkg010 a_{wkg011 a}wkg012 a~wkg013

a_{wkg014 a}wkg015 a~wkg016

INTO CORRESPONDING FIELDS OF TABLE gt_sapgl_to_cim

FROM cosp AS a INNER JOIN cskb AS b

ON a_{kstar = b}kstar

WHERE b~kostl IN s_kostl

AND a~gjahr IN s_gjahr

AND a~kstar IN s_kstar

AND b~kokrs = '1000'.

Warning displayed is:

Program ZRGAI_SAPGL_TO_CIM Include ZRGAI_SAPGL_TO_CIM Row 503 Column 35

Buffered Table CSKB in a JOIN

==> Buffered Table CSKB in a JOIN

Re: Select Statement error

Former Member — Mon, 08 Sep 2008 10:48:50 GMT

Click on the documentation button of code inspector messages.

buffers are switched on for the table CSKB in technical settings of SE11.

Re: Select Statement error

Former Member — Mon, 08 Sep 2008 10:55:51 GMT

Hi Nani,

First of all this is a warning message as you have stated in your query and i think there should be no need to worry.

Secondly if you check the 'Technical Settings' of both the tables you will see that one of the tables is buffered (CSKB) and one of the tables is not buffered (COSP). Since you are joining both these tables the system is detecting an inconsistency and displaying the following message.

If you really need to remove this message you can do the foll :

1. First select data from COSP into a certain table.

2. Select data from CSKB for all entries in COSP into another table.

This will be same as inner join but will result in no Code inspector error i hope

Regards,

Pramod

Re: Select Statement error

Former Member — Mon, 08 Sep 2008 11:00:19 GMT

This message will come from CI if you are trying to join a buffered table.

If the performance is not a factor of requirement, ignore it.

Please check the below message.

Regards,