如何在快速查看器中获取不同的记录?
我想在快速查看器中获得不同的记录值。有什么办法可以做到这一点吗?
I would like to get distinct record values as a result in the quickviewer. Is there any way to do that?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
不幸的是你不能。由于任何 Quickviewer SQVI 查询都可以转换为 SE11 查询,并且即使其中不允许 DISTINCT 选择,因此 Quickviewer 也不允许这样做。
在纯 ABAP 中,您可以执行 SELECT DISTINCT (OpenSQL),但不幸的是,不能在 QuickViewer 中执行。
Unfortunatelly you cant. Since any Quickviewer SQVI Query can be converted into an SE11 Query and even therein no DISTINCT selects are allowed, Quickviewer is not allowed to neither.
In pure ABAP you can do a SELECT DISTINCT (OpenSQL), but unfortunatelly not in QuickViewer.
这不是答案(我会发表评论,但目前还不能)。
您的意思是来自单个数据库表的不同记录吗?
由于查询查询的是数据库表,该表可能具有唯一的键,因此唯一要做的就是强制将所有必需的键作为查询的输入。
或者您的意思是不同记录的字段具有不同(不同)值?我还没有尝试过,但是如何从事务 SQ02 中注入一些额外的代码,并根据您的条件删除/收集行,从而确保记录中存在不同的非关键字段。
This is not an answer (I would comment, but i can't, yet).
Do you mean distinct records from a single db table?
Since queries query a db table, which presumably has unique keys, the only thing to do is enforcing as input to the query all the required keys.
Or do you mean fields of different records having different (distinct) values? I haven't tried that, but what about injecting some extra code, from transaction SQ02, and deleting/collecting rows based on your criteria, thus ensuring distinct non-key fields in your records.