topic Re: select from view in Application Development and Automation Discussions

select from view

Former Member — Tue, 28 Aug 2007 08:00:17 GMT

hallow

i try to do select from view and i get erorr ,what i miss?

LOOP AT zem_rec INTO wa_zem.

SELECT SINGLE ktext

FROM v_cskr_s

INTO wa_zem-ktext

WHERE resrc = g_r_resrc.

IF sy-sybrc = 0.

MODIFY zem_rec FROM wa_zem TRANSPORTING ktext.

ENDIF.

ENDLOOP.

<b>"V_CSKR_S" is not defined in the ABAP Dictionary as a table, projection

view, or database view.</b>

regards

Re: select from view

Former Member — Tue, 28 Aug 2007 08:05:16 GMT

Hi!

v_cskr_s is a database view. Just check it out in SE11 transaction. It is a join of the tables

CSKR

CSKV

CSKR MANDT = CSKV MANDT

CSKR KOKRS = CSKV KOKRS

CSKR RESRC = CSKV RESRC

CSKR DATBI = CSKV DATBI

Put your select single, outside of the loop to increase the performance, if it is not using the wa in the where conditions. It will select always the same thing so it is not needed to run within the loop.

Regards

Tamá

Re: select from view

Former Member — Tue, 28 Aug 2007 08:06:00 GMT

check whether a view with that name exists or not if not create one with that name

Re: select from view

Former Member — Tue, 28 Aug 2007 08:08:43 GMT

hi Tamás Nyisztor

u can give me example i new with this topic?

Regards

Re: select from view

Former Member — Tue, 28 Aug 2007 08:22:20 GMT

hi Premalatha G

this view is exists in database.

Thanks

Re: select from view

Former Member — Tue, 28 Aug 2007 08:37:23 GMT

have you declared the view in the top of you're abap program in the table section ?

tables: v_cskr_s.

Message was edited by:

A. de Smidt

Re: select from view

Former Member — Tue, 28 Aug 2007 08:45:51 GMT

hi A

i declare it and i have the same eroorr.

Regards

Re: select from view

Former Member — Tue, 28 Aug 2007 08:47:44 GMT

check if you can get values if you use se16n on that view otherwise use the joins instead for you're select.

Re: select from view

Former Member — Tue, 28 Aug 2007 08:49:34 GMT

hi a

u can give me example how to use join for that?

i reward

Regards

Re: select from view

Former Member — Tue, 28 Aug 2007 08:55:46 GMT

you don't need the join since all the fields are in cskv that you need

SELECT SINGLE ktext

FROM cskv

INTO wa_zem-ktext

WHERE resrc = g_r_resrc.

Message was edited by:

A. de Smidt