Use of Maintenance Views.

[former_member130219]

Hi all

I made a maintenance view for use in my programs to access data from different tables.

But facing problem while accessing data using a select query in program.

Like:-

REPORT ZVIEW.

data: it type table of zabhiview,

wa type zabhiview.

select * from zabhiview into table it.

loop at it into wa.

write:/ wa-carrid,

wa-ORT01,

wa-CHANGEUSER.

endloop.

1. zabhiview-->maintenance view.

please tell how to use views in our programs.

Thank you.

[former_member555112]

Hi,

You cannot select data from a maintainance view.

You have to create a database view for the same.

Regards,

Ankur Parab

[former_member130219]

Then can you tell me what's the use of maintenance views in ABAP.

[Peranandam]

for maintaining depending table entries with in a single view.
ex.
Let us take example three table emp_master, emp_sal and emp_rating. three tables are containing following fields
----------------------------------------------------
emp_master        emp_sal         emp_rating
-----------------------------------------------------
empno               empno             empno
department        basic               status
fname                variable           
lname                 pf     
email                  tax
---------------------------------------------------
if you are creating maintanace view for the above three table. where you can maintain(create and change) value for the three table within a single view. Created and changed value in maintanace view will be saved in to the corresponding table.
Hope it will crear your doubt.

Regards,

Peranandam

[former_member207835]

Hi

Peranandam ,

here i got some doubt, can we save record in all tables at same time?

my doubt is it is mandatory that first the record has to be saved in parent table then only we can save it in chile tables.correct me if i wrong..give me some clarification.

Regards

Eswar

[sravya_ch]

This message was moderated.

[raymond_giuseppi]

This question has often be posted here, do some seach at sdn for [VIEW_GET_DATA.|https://forums.sdn.sap.com/search.jspa?threadID=&q=VIEW_GET_DATA&objID=&dateRange=last90days&numResults=15&rankBy=10001]

Regards,

Raymond

[former_member130219]

Thanks for the suggestion Mr. Raymond ...

But for your kind info. I have searched before posting this query.

Thanks.

Regards.

Abhinandan

[raymond_giuseppi]

Which keywords did you use, try : [maintenance view select|https://forums.sdn.sap.com/search.jspa?threadID=&q=maintenanceviewselect&objID=&dateRange=last90days&numResults=15&rankBy=10001]

Regards,

Raymond

[former_member130219]

Thank You.It helped me a lot.