topic Re: reading data from maintainance view in Application Development and Automation Discussions

reading data from maintainance view

Former Member — Fri, 06 Jan 2006 10:18:14 GMT

hi ,

Can we read the data from maintainance view through select statement.

Re: reading data from maintainance view

Former Member — Fri, 06 Jan 2006 10:21:00 GMT

Hi rajkumar,

1. Absolutely.

2. Select * from V_T001

into table xyz.

regards,

amit m.

Re: reading data from maintainance view

Former Member — Fri, 06 Jan 2006 10:25:55 GMT

like normal select.

select *
       from zview
       into table itab
      where field = 'ssd'.

vijay

Re: reading data from maintainance view

Former Member — Fri, 06 Jan 2006 10:26:13 GMT

it is giving syntax error

V_001K_K is not defined in dictionary as table or projection view or database view

Re: reading data from maintainance view

Former Member — Fri, 06 Jan 2006 10:30:37 GMT

first check is there any view exists or not in SE11.

if it there try this...

tables: v_001K_K.

select * from 
         v_001k_k
         into table itab.

Vijay

Re: reading data from maintainance view

Former Member — Fri, 06 Jan 2006 10:37:24 GMT

Hi again,

1. V_001K_K

Since this view comprises

more than 1 table

T001K

T001

It gives this error.

2. Maintenacnee views comprising only 1 table

can be used in Select.

For eg. V_T001

V_T003 = Not allowed

PS:

3. The reason for this is :

Any R/3 view having only one table,

for such view, a physical view is created

in the database.

The records in it can be modified, inserted,deleted.

(conditions apply)

But for view having 2 or more tables,

no physical view is there in the database.

regards,

amit m.

Message was edited by: Amit Mittal

Re: reading data from maintainance view

Former Member — Fri, 06 Jan 2006 10:41:31 GMT

Hi rajkumar,

1. To finally use the data,

make a select using

T001K

T001

joined by BUKRS

regards,

amit m.

Re: reading data from maintainance view

Former Member — Fri, 06 Jan 2006 10:50:55 GMT

hi amit,

If the view (v_t001) is having only one table also we cant use select stat. to read.

May be using join is the only way.

thanks.

Re: reading data from maintainance view

Former Member — Fri, 06 Jan 2006 10:54:53 GMT

Hi again,

1. i did not fully understnd ur last staement.

2. If a join has only 1 table,

we can use

VIEW

TABLE

in our select.

3. Now if the view has only few columns,

then it would make a difference

between selecting from TABLE,selecting from VIEW.

regards,

amit m.

Re: reading data from maintainance view

Former Member — Fri, 06 Jan 2006 10:55:58 GMT

The join is used to create the View, in your abap code the View is like a normal transparent tables.

The fields you need for the select can belong to all tables used for join, but they have to exist in the view too.

Max

Re: reading data from maintainance view

Former Member — Fri, 06 Jan 2006 11:03:38 GMT

hi amit ,

I mean to say it is not possible to read the maintainace view through select stat.( although it is having one table in it)

Re: reading data from maintainance view

suresh_datti — Fri, 06 Jan 2006 11:07:10 GMT

Hi Raj,

You are RIGHT, I don't think we can use SELECT statements on maintenance views.

Regards,

Suresh Datti

Re: reading data from maintainance view

Former Member — Fri, 06 Jan 2006 11:08:03 GMT

Hi,

We have use two tables and created the view .

and i am able to select from that view.

one table also you can select.

regards

vijay

Re: reading data from maintainance view

Former Member — Fri, 06 Jan 2006 11:14:46 GMT

Hi rajkumar,

1. Lots of confusion!

If a maintenace view comprises of ONLY 1 table,

we CAN USE in select.

eg: View = V_T001

(has table T001 only)

If a maintenace view comprises of MORE THAN 1 table,

we CANNOT USE in select.

eg: View = V_001K_K

(has two tables T001K, T001)

eg: View = V_T003

(has two table T003, T003T)

regards,

amit m.

Re: reading data from maintainance view

suresh_datti — Fri, 06 Jan 2006 11:19:15 GMT

Hi all,

I think we have to focus on the subject of the thread ie 'maintenance view'. I am almost positive that the use of both ABAP Open SQL and ABAP Native SQL to access views from ABAP programs, is only permitted for Database & Projection Views and cannot be used for Maintenance Views. Per SAP,s definition the Maintenance views provide you with a business view of the data.

Regards,

Suresh Datti

Re: reading data from maintainance view

Former Member — Sun, 15 Jan 2006 20:12:19 GMT

Hello guys,

SAP not allow you to read the maintenance view using Select Statement. Because its act like a screen. SO you cant write using select query using this view. Only possible DATA BASE view and Projection View.

But there is possible while using one function model, here with out using select query we use functional module to read the data from m - View. I am sorry I forgot the functional module name. Please find any document. Other wise i will send u next time.

Thanking you

Mohankumar

Re: reading data from maintainance view

Former Member — Wed, 05 Nov 2008 21:24:40 GMT

Hi Moham Kumar,

Could you recall the function module or any hint of FM name to read maintenance view ?

I'd highly appreciate your response.

Thank you very much.

Re: reading data from maintainance view

Former Member — Wed, 05 Nov 2008 21:47:13 GMT

Durai is not using SDN(That time) since almost last 2 years.so there is very less possibility to hear Durai again

Friend,

Its not possible even from any of Function module.

maintainance views are only to view enterprise data.

if any body find any FM please post here it would be great new learning for me.