topic Re: Maintenance view in Application Development and Automation Discussions

Maintenance view

Former Member — Mon, 06 Mar 2006 04:37:20 GMT

Hi Experts,

How can we define the maintenance view (V_001_S) in program?Is it in Tables or Views? How to define? Give with example.

Thanks

Re: Maintenance view

Former Member — Mon, 06 Mar 2006 04:38:34 GMT

Hi Silviya,

I think you can't use Maintenance View in your ABAP program.

Re: Maintenance view

Former Member — Mon, 06 Mar 2006 04:39:26 GMT

Hi silvliya,

1. data : V_001_S like table of V_001_S with header line.

we can define like this.

*----

2. Sorry,

we can define like this,

but, we cannot use SELECT * from V_001_S

<b>(when we define it won't give any error,

but when we try to use select * ,

it will give error)</b>

bcos,

its a maintenance view

ie. its a collection of screens for

facilitation data entry into the table.

Its not a database view / projection view,

bcos such view actuaally

exist in the backend database.

regards,

amit m.

Message was edited by: Amit Mittal

Re: Maintenance view

Former Member — Mon, 06 Mar 2006 04:42:53 GMT

Hi Silviya,

You can either use <b>Projection view or DATAbase view</b>..

i dont think we can use Maintenace...

regards

satesh

Re: Maintenance view

hymavathi_oruganti — Mon, 06 Mar 2006 04:44:20 GMT

u can use only databse view/ projection view in ur program.

to use a view, u can use the statement TABLES only. there is no statement like VIEW

Re: Maintenance view

Former Member — Mon, 06 Mar 2006 06:23:20 GMT

Hi Silviya,

You cannot directly use a Maintenance View in your report. However, in case you want to execute it and present the user with the maintenance screen, you can call transaction SM30 after setting parameters VIEWNAME as 'V_001_S' and UPDATE as 'X'. Here you will have to skip the first screen. This can easily be achieved by defining a new T-code with these settings and then calling this T-code from inside of your program.

Foe extracting data from a view it has to be a Projection or a Database View.

Hope this helps,

Regards,

Madhur

NB: Please do reward points if found helpful.