Select from view

[Former Member]

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.

[Former Member]

Hi

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

[former_member404244]

Hi,

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

Regards,

nagaraj

[alex_m]

You can write select ctatement for database view.

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

[Former Member]

Hi

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

[Former Member]

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

[Former Member]

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