topic Re: Insert entry in view in Application Development and Automation Discussions

Insert entry in view

Former Member — Tue, 16 Dec 2008 06:02:36 GMT

Hi Experts,

I want to insert entry in the view V_TKAZE. When you enter the transaction OKC7, you directly go in the maintenance view of this view. But i dont have change authorisation. I dont have SM30 maintenance authorisation. How do i do it.

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 06:07:20 GMT

Hi,

Hope this helps you:

http://searchsap.techtarget.com/tip/0,289483,sid21_gci1154362,00.html#.

regards,

Rahul

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 06:28:17 GMT

Could you plz send me the code. The link is not opening.

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 06:41:31 GMT

Use FM Alink_call_Transaction and enter the code. But it is not the right or recommended way to modify the configuration

Thanks

Shiva

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 06:41:44 GMT

Hi Priti,

Once you go to Display of the maintenace view, and when you click on the Display <--> Change, you are prompted that you don't have sufficient authorization to change this View, isn't it?

If you persists this problem and if you really want to enter a record, you can follow the below technique.

When you go to "Display View "Callup Points for Validation": Overview", before clicking on Display <~~> Change button, type "/h" on the command box and press enter and then click on the Display <~~> Change button. This will take you to Debugging screen.

Now, do the following:

set sy-pfkey = ESLG from EULG.

And immediately save it by clicking on Save button or Breakpoints --> Save.

This will be saved and when you come out, you can see the New Entries button on the screen which is ready for the entries to be entered.

Check the same and get back to me in case of further issues.

Regards,

-Syed.

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 06:46:42 GMT

But i cannot tell the same to the Functional Consultant. I am a technical person. But the functional consultant wont be able to do this. Can i enter the values programatically. I have written a program for the same but it gives error saying "V_TKAZE" is not defined in the ABAP Dictionary as a table, projection view, or database view.

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 06:57:29 GMT

Hi Priti,

Can you send your code?? So that I can analyze and suggest you in a proper way.

Regards,

-Syed.

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 06:59:50 GMT

Hi Priti,

Try calling FM 'VIEW_MAINTENANCE_CALL'. And check whether you are able to see the maintenance view screen.

Regards,

-Syed.

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 07:05:21 GMT

I entered action as "U' and view as V_TKAZE. But it says " Client 410 has state 'non modifiable' ".

Here client 410 is the testing client

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 07:07:54 GMT

Here T_RECORDS is an internal table. I upload the records from excel into this file and then i pass it to V_TKAZE as follows.

V_TKAZE-KOKRS = T_RECORDS-CTRL_AREA.

V_TKAZE-EVENT = T_RECORDS-EVENT.

V_TKAZE-VALID = T_RECORDS-VALID.

SELECT SINGLE * FROM GB93T

WHERE VALID = T_RECORDS-VALID

AND LANGU = 'EN'.

V_TKAZE-VALTEXT = GB93T-VALTEXT.

V_TKAZE-ACTIV = T_RECORDS-ACTIV.

INSERT V_TKAZE.

On insert command it gives me the error ""V_TKAZE" is not defined in the ABAP Dictionary as a table, projection view, or database view.".

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 07:12:07 GMT

Priti,

You can use 'S' as an option to display the View data.

But before displaying the view data, you need to prepare an internal table with the fields as on the display of V_TKAZE view.

Try to insert data into that internal table using the validations you have and then while calling the FM, you populate the same internal table values to the View and then display.

Check the same.

Regards,

-Syed.

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 07:20:01 GMT

I have written a program ,code of which i have already posted. I have the values in the internal table . But m not able to nsert the same values in the view.

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 07:42:33 GMT

Priti,

Do not directly populate the data to the View, as this is a maintenance view, can be seen only at runtime.

And also usage of INSERT statement to a view is prohibited.

Try to insert the corresponding records into the corresponding DB tables of the view V_TKAZE and then execute the FM to display the view.

Check the same and get back to me in case of further issues.

Regards,

-Syed.

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 09:32:25 GMT

Priti,

Give the similar type of join conditions as mentioned under V_TKAZE.

TKA01	MANDT	=	TKAZE	MANDT
TKA01	KOKRS	=	TKAZE	KOKRS
GB93	MANDT	=	TKAZE	MANDT
GB93	VALID	=	TKAZE	VALID
GB92	MANDT	=	TKAZE	MANDT
GB92	SUBSTID	=	TKAZE	SUBSTID
TKAZ	EVENT	=	TKAZE	EVENT
TKAZ	EVENT	=	TKAZT	EVENT
GB93	MANDT	=	GB93T	MANDT
GB93	VALID	=	GB93T	VALID
GB92	MANDT	=	GB92T	MANDT
GB92	SUBSTID	=	GB92T	SUBSID

Use the above conditions under your select statement and try updating values to the table TKAZE.

Hopefully when you try viewing the data, you can see the desired result.

Regards,

-Syed.

Re: Insert entry in view

Former Member — Tue, 16 Dec 2008 13:09:42 GMT

Hi priti,

Upto mu knowldge you can't update VIEW.

first find out what are the tables are joined with that view then update those tables its automatically updates view,

this requirement is common for us, so we are using this way if you want my coding i can provide,

Regards,

Arjun.

Re: Insert entry in view

Former Member — Wed, 17 Dec 2008 05:08:24 GMT

Thankx a lot Arjun. I have used the same method and its working. Thanks once again