如何通过用户 ID 获取 SQVI 查询列表?
作为一些背景知识,我打算使用 .NET 编写一个 Excel 插件,可以从 SAP 系统执行查询。
因此,我正在寻找 SAP 的 SQVI 事务的功能模块列表。我似乎找不到太多关于他们的信息;我之前发现的几篇论坛帖子似乎已经被互联网遗忘了。
具体来说,我希望能够查找用户创建的查询,然后在 Excel 中显示结果。我可以管理Excel操作以及远程执行SAP功能模块;我根本找不到需要执行哪些 SQVI 功能模块。
更新:我确实找到了这篇文章,它引导我搜索函数AQGF 组中的模块(以 RSAQ* 开头的功能模块)
Just as some background, I intend to write an Excel add-in with .NET that can execute queries from an SAP system.
Thus, I'm looking for a list of function modules for SAP's SQVI transaction. I can't seem to find much information about them; the few forum posts I had found before seem to have gone into the internet oblivion.
Specifically, I want to be able to look up the queries created by a user and then display the results in Excel. I can manage the Excel manipulation as well as remotely executing SAP function modules; I simply can't find which SQVI function modules I need to execute.
Update: I did find this post which directed me to search for function modules in the AQGF group (function modules starting with RSAQ*)
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
尝试 RSAQ_REMOTE_QUERY_CALL_CATALOG,它似乎对我有用。
Try RSAQ_REMOTE_QUERY_CALL_CATALOG, it seems to do the trick for me.
正如 tomdemuyt 所说,您现在已经找到了获取所需数据的函数。
要浏览并获取更多数据,请转到事务 SE93,输入事务 id SQVI,转到开发类或包 SQUE,然后使用 SE80 浏览此包/查看对象的层次结构,特别是功能组。
然后你会看到很多功能组,但其中之一是AQRC,其中提到的功能模块RSAQ_REMOTE_QUERY_CALL_CATALOG所属。
As told already by tomdemuyt, you have now found the function to get the required data.
To browse around and get more further data, goto transaction SE93, enter Transaction id SQVI, go to development class or package SQUE, then browse this package with SE80 / have a look at the hierarchy of objects, function groups in special.
Then you see many function groups, but one of them is AQRC to which the mentioned function module RSAQ_REMOTE_QUERY_CALL_CATALOG belongs.
只需使用表 AQLTS 的事务 SE16N 中的以下选择即可找到按用户列出的 SQVI 查询列表。
这不是检索数据的理想方式,因为必须为 userID:reportID 解析单个字段 (AQLTS-TEXT),但它带来了所需的内容一起在一张桌子上。
A list of SQVI Queries by User can be found simply using the following selections in transaction SE16N for table AQLTS.
It is not the ideal way to retrieve the data, because a single field (AQLTS-TEXT) must be parsed for the userID:reportID, but it brings what is needed together in one table.