Can I assign a transaction code to SE16N restricted to a certain view?

[former_member331218]

Hello,

I have a database view defined in the data dictionary (SE11) which is a join of some transparent tables. This view can be queried using SE16N. I would like to assign a transaction code to SE16N restricted to this view so that it can be shared with relevant users. Is this possible? If not, is there another easy way to achieve the same end result?

[matt]

Try reading the documentation on Transaction with Parameters.

[former_member331218]

I did try that but you can only specify the default name of the view but not the variant. For example, I want the Z transaction to execute SE16N on view WB2_V_LIKP_LIPS2 for only for plant 1234 (WB2_V_LIKP_LIPS2-WERKS_I). Is this possible?

[matt]

No. You have to write a program as Horst says.

[former_member186746]

Why not create your own view with the restriction in the selection conditions.

Kind regards, Rob Dielemans

[horst_keller]

Write a SELECT with an appropriate output ...

Example:

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abencreate_tabular...

[former_member331218]

Yes, I could develop it in ABAP, but I was looking for a shortcut

[Lakshmipathi]

One easiest way is to create a table join in SQVI and assign a transaction code to that which can then be shared with users. If you are not aware of it, please search Google with the text "transaction code for SQVI+sap", so that you will lot of inputs.

[former_member331218]

I came to the same conclusion. Now I am converting the QuickView query into to a SAP Query (SQ01) so that it can be assigned to a transaction code and transported.