database view

[Former Member]

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]

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]

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]

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]

Hi Dev,

I would suggest to go through the link once,

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21ed06446011d189700000e8322d00/content.htm

Regards,

Azaz Ali.

[Former Member]

Thank you all for the help.