Question:
Hello
I am a newbie.
I have a view V_T012K_W which has content I need in a program. How could I create a table from that view(e.g table ZT012K_W)
Thank you very very much in advance
Answer:
Views are built on tables, why would you want to go back one step??
You can select data directly from V_T012K_W if you want to use it in your program...
or provide more details.
Regards.
Answer:
i would like to execute statement
SELECT SINGLE * FROM t012k WHERE bankl = t_raw_data+72(5)
AND bankn = rac.
BUT t012k does not contain field bankl(whereas V_T012K_W contains bankl , bukrs and bankn) but I cna not execute above statement with view
Thank you in advance
Answer:
I cna not execute above statement with view
Why? If you get an error message, what is it? Is it a syntax error or a runtime error?
Some views are readable. Some are not. If the one you want to use isn't, then maybe a join is what you need.
P.S. R will have a fit when he sees t_raw_data+72(5).
_________________
First he pinches my sig, Now he's cribbing my posts too!
Answer:
Yup.. did'nt check this earlier, this is a maintenance view, and you cannot select data directly from this view, thanks hognoxious for pointing it out.
guestmr, go to Join Condition tab for view V_T012K_W, and use the tables and fields from there to build your own join in the program.
Regards
Sudhir/Mohit
Answer:
from the views u can find out the table the data is coming from and can use that table. put the views name in se11 and use where use button at the top.