topic Re: Select Statement in Application Development and Automation Discussions

Select Statement

Former Member — Mon, 14 May 2007 15:29:27 GMT

Hi All,

Please let me know how i can correct this statement:

Select RMS_ID CASE_SPS_ID NOTES_SPS_ID

into (W_RMS_ID W_CASE_SPS_ID W_NOTES_SPS_ID)

from SCMGV_CTYPE_PPF

where CASE_TYPE = W_CASETYP.

The error message I am getting is:

"SCMGV_CTYPE_PPF" is not defined in the ABAP Dictionary as a table,

projection view or database view.

Thanks.

Re: Select Statement

Former Member — Mon, 14 May 2007 15:32:43 GMT

Hi,

Try this..Give commas inbetween variable in the INTO clause

Select RMS_ID CASE_SPS_ID NOTES_SPS_ID

into <b>(W_RMS_ID,W_CASE_SPS_ID,W_NOTES_SPS_ID)</b>

Thanks,

Narne

Re: Select Statement

srinivas_akiri — Mon, 14 May 2007 15:33:42 GMT

declare the table SCMGV_CTYPE_PPF in the TABLES clause as below:

tables: SCMGV_CTYPE_PPF.

if still it is not working then check wheather table SCMGV_CTYPE_PPF

is exists in DD or not in transaction SE11, if it is not exist then use native SQL statement as below:

EXEC SQL

Select RMS_ID CASE_SPS_ID NOTES_SPS_ID

Into (W_RMS_ID W_CASE_SPS_ID W_NOTES_SPS_ID)

from SCMGV_CTYPE_PPF

where CASE_TYPE = W_CASETYP.

END SQL.

Re: Select Statement

Former Member — Mon, 14 May 2007 15:34:06 GMT

Thats because SCMGV_CTYPE_PPF is Case Type Maintenance.

Thanks

Aneesh.

Re: Select Statement

Former Member — Mon, 14 May 2007 15:35:29 GMT

Still the same error message.

Re: Select Statement

Former Member — Mon, 14 May 2007 15:37:16 GMT

As it is a maintenance view may be u cant select data from that view.

Even i have tried the same code it is giving me the same error message.

Regards

Haritha.

Re: Select Statement

Former Member — Mon, 14 May 2007 15:39:49 GMT

Well, What is the solution for this.

Re: Select Statement

Former Member — Mon, 14 May 2007 15:49:18 GMT

Hi Kiret,

I have checked for SCMGV_CTYPE_PPF in transaction SE12 and it is neither a database table nor a view in my SAP R3 system. I use version 4.7. Can you explain what exactly is SCMGV_CTYPE_PPF and which system are you working with.

Re: Select Statement

Former Member — Tue, 15 May 2007 07:22:08 GMT

instead of selecting from maint view u can select from table SCMGCASETYPE



tables : SCMGCASETYPE.


Select RMS_ID CASE_SPS_ID NOTES_SPS_ID
into (W_RMS_ID W_CASE_SPS_ID W_NOTES_SPS_ID)
from  SCMGCASETYPE
where CASE_TYPE = W_CASETYP.

i think this may help u

thanks,