topic Re: database view in Application Development and Automation Discussions

database view

Former Member — Mon, 11 Sep 2006 21:53:30 GMT

Hi All,

Can you please tell me, If i want to use a DATABASE VIEW (VBAP-VAPMA) in a program, Do I have to declare in 'TABLES:' work area?

Thanks in advance.

sridhar_k1 — Mon, 11 Sep 2006 21:57:35 GMT

If you use the work area VBAP_VAPMA, or use the fields in select options, you need to declare TABLES VBAP_VAPMA, else you don't need to declare.

REgards

Sridhar

Former Member — Mon, 11 Sep 2006 22:08:55 GMT

Sridhar,

Thanks for the response.

The piece of code in which i'm using this view is:

<b> select bstnk

vbeln

kunnr

into table i_cust

from vbap_vapma

where vbap_vapma~matnr = p_matnr

and vbap_vapma~charg = p_charg.</b>

plz let me know I hve to declare for this.

Thnx.

sridhar_k1 — Mon, 11 Sep 2006 22:14:05 GMT

you don't need to declate TABLES statement, and you can change the where condion like this:

where matnr = p_matnr

and charg = p_charg.

Regards

Sridhar

Former Member — Mon, 11 Sep 2006 22:17:19 GMT

Hi Dev,

I would suggest to go through the link once,

Regards,

Azaz Ali.

Former Member — Mon, 11 Sep 2006 22:35:53 GMT

Thank you all for the help.