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

Select from view

Former Member — Thu, 28 Jun 2007 12:42:07 GMT

Hello all,

Is it possible to write select ststement for a view. If possible Please help me in the following

I want to select BATXT,

View is - V_T161,

Where condition based on BSART.

Please help,

Rakesh.

Re: Select from view

Former Member — Thu, 28 Jun 2007 12:46:50 GMT

If it is a Database View you can write the select statement similar to a Table

But it appears that this V_T161 appears to be a maintenance View

so you can't write a select statement

better write a select statement to the table T161 and use

select single bstxt from T161 into v_text where bsart = p_bsart.

Reward points for useful Answers

Regards

Anji

Re: Select from view

former_member404244 — Thu, 28 Jun 2007 12:46:57 GMT

Hi,

U cannot make a select,becoz it is a maintainence view.

Regards,

nagaraj

Re: Select from view

alex_m — Thu, 28 Jun 2007 12:47:46 GMT

You can write select ctatement for database view.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ec5d446011d189700000e8322d00/content.htm

Re: Select from view

Former Member — Thu, 28 Jun 2007 12:50:31 GMT

Yes u can if it's a database view and u can use a SELECT statament, just as for a transparent table.

V_T161 is a maitenance view, so It can't do it a select, u need to read direclty T161 and T161T.

In your can u need T161T only:

SELECT SINGLE * FROM T161T WHERE SPRAS = SY-LANGU
                                   AND BSTYP = 'F' "< If it's a Purchase Order  
                                   AND BSART = <BSART>.
WRITE T161T-BATXT.

Max

Re: Select from view

Former Member — Thu, 28 Jun 2007 12:56:25 GMT

Hi.

V_T161 is a maitenance view, so It can't do it a select, u need to read direclty T161 and T161T.

In your can u need T161T only:

SELECT SINGLE * FROM T161T WHERE SPRAS = SY-LANGU

AND BSTYP = 'F' "< If it's a Purchase Order

AND BSART = <BSART>.

Reward all helpfull answers.

Regards.

Jay

Re: Select from view

Former Member — Thu, 28 Jun 2007 13:28:31 GMT

Hi Jay!

Are you a good firend of Rakesh?

I don't know, but you should considere we are here to try to help and not to copy the answer in order to get some points.

Max