Skip to Content
0
Mar 26, 2009 at 03:27 PM

native sql number of entries for column key?

408 Views

Dear experts,

I have a serious problem with the following issue.

In some strange way there are duplicate records for a certain key.

I cannot find them in SAP, as in SE11 the presentation layer does not show those entries at all.

so I try to do a native sql search from my abap program to try and find those duplicate enries.

after creating a test DB table in the dev system , i do:

exec sql.

select count(*) from zrox1 where z1 = '8'

endexec.

where I know that there are 2 entries.

But this statement fails, sap says there is a syntax error,

Program ZROX_SM30 22 @0A\QError@ -> INTO is missing.

Can anyone help?

Do you think of any other way of addressing my problem?

Thank you in advance.

Roxani