06-27-2009 1:15 PM
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.
zabhiview-->maintenance view.
please tell how to use views in our programs.
Thank you.
06-27-2009 1:25 PM
Hi,
You cannot select data from a maintainance view.
You have to create a database view for the same.
Regards,
Ankur Parab
06-27-2009 1:52 PM
Then can you tell me what's the use of maintenance views in ABAP.
06-27-2009 3:57 PM
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
04-09-2012 11:44 AM
Hi
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
06-29-2009 7:30 AM
06-29-2009 7:59 AM
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
06-29-2009 8:08 AM
Thanks for the suggestion Mr. Raymond ...
But for your kind info. I have searched before posting this query.
Thanks.
Regards.
Abhinandan
06-29-2009 8:23 AM
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
08-29-2009 1:52 PM