Select Statement

[Former Member]

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.

[Former Member]

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

[srinivas_akiri]

Hi

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.

[Former Member]

Thats because SCMGV_CTYPE_PPF is Case Type Maintenance.

Thanks

Aneesh.

[Former Member]

Still the same error message.

[Former Member]

Hi

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.

[Former Member]

Well, What is the solution for this.

[Former Member]

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.

[Former Member]

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,