Insert entry in view

[Former Member]

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.

[Former Member]

Hi,

Hope this helps you:

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

regards,

Rahul

[Former Member]

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

[Former Member]

Hi

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

Thanks

Shiva

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi Priti,

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

Regards,

-Syed.

[Former Member]

Hi Priti,

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

Regards,

-Syed.

[Former Member]

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

[Former Member]

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.".

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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