查找 SAP 表关系？
我是 SAP 新手。我可以访问 SAP 数据库，但不能访问 SAP GUI。 我想知道表关系，即如何连接两个表。
假设，如果我想知道 VNVK 拥有的所有关系，我应该从哪里开始？我只能查看所有表的主键，而不能查看外键。我从这个论坛上阅读了一些帖子并获得了以下信息：
DD02L：SAP 表DD05S：外键字段DD09L：DD：表的技术设置- DD26S：基表和外键关系，
但 DD26S 表也不给我这些信息。
我什至尝试获取表和列的描述，然后尝试加入，但这是一个乏味的过程。
我收到了一份包含 SAP 表关系的文档，但其中没有包含所有模块。
有关于所有这些的完整文档吗？
I'm new to SAP. I have access to the SAP database, but not to the SAP GUI.
I wanna know the tables relation i.e., how to join two tables.
Suppose, if I want to know all the relations VNVK has, where should I start? I can only view the primary keys and not the foreign keys for all the tables. I read some posts from this forum and got this information:
DD02L: SAP TablesDD05S: Foreign key fieldsDD09L: DD: Technical settings of tablesDD26S: Base tables and foreign key relationships
but the DD26S table doesn't give me these information either.
I even tried to get the table and column description and then try to join, but it's a tedious process.
I got a document with SAP table relations but it doesn't have all the modules in it.
Any holistic documentation about all of them?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
如果有人希望您完成这项工作，他们必须为您提供适当的工具。您需要前端访问权限（至少是只读的）才能执行此操作。因此，拿一根尖头的棍子戳那些责任人，直到获得必要的许可。
话虽这么说，您应该查看 IDE consolut 提供的安装 - 他们提供免费（只读）访问，这对您来说可能就足够了。有关字典结构和 <有关工具的信息，请参阅 href="http://help.sap.com/saphelp_46c/helpdata/en/ea/e9a3bb4c7211d189520000e829fbbd/frameset.htm" rel="nofollow noreferrer">此。
If someone wants you to do the job, they have to give you the proper tools. You need frontend access (at least read-only) to do this. So take a pointed stick and poke whoever is responsible until you get the necessary permissions.
That being said, you should check out the IDES installation provided by consolut - they offer free (read only) access, and that might be enough for you. Read this for information about the dictionary structures and this for information on the tools.
在 STechno 上，您可以找到 SAP 表的列表： http://www.stechno.net/sap -tables.html
其中任何 SAP 表的表关系都可以通过字段引用查看。该资源提供的另一种方式是表关系的图形可视化。例如，MARA 连接看起来像这样
On STechno you can find a list of SAP tables: http://www.stechno.net/sap-tables.html
where table relations for any SAP table can be seen by via field references. Another way this resource provides is graphical visualization of the table relations. For example, MARA connections look like this
您可以从 SAP 表 DD03L 获取表字段的外键检查表。它位于 CHECKTABLE 字段中。
对于表 KNVK，您将在此处找到所有外键关系。
您还可以在一些具有相关公共文档的在线网站上看到这一点，例如来自 SAP Tables 文档（此处） 。
但是，并非所有关系都可以通过这种方式发现，因为这仅对单键外键关系有用。
查看关系的另一个好方法是检查相关数据元素的使用情况。数据元素表示字段的数据类型。例如，您可以在此处查看
The foreign key check table for a table field you can get from SAP table DD03L. It is there in field CHECKTABLE.
For table KNVK you will find all foreign key relations here.
You can also see this on some online web sites that have public documentation about it, e.g. from the SAP Tables documentation here.
However, not all relations can be discovered that way, as this is only useful for single key foreign key relations.
Another good way to see relations is to check, where a relevant data element is used. Data elements represent the data type of a field. You can e.g. see here,
我来自consolut，你也可以编程Abap，但不能在我们的IDES中。
如需编程，请尝试我们的 Mini-SAP 系统。
I'm from consolut, you can also program Abap but not in our IDES.
For programming try our Mini-SAP system.
有多家供应商提供短期或长期用作沙箱的 SAP 系统，Bettisworth 同事也是其中之一。只需谷歌一下他们
There are are several vendors out there that offer SAP systems for short or long term use as sandboxes, one of them is also Bettisworth associates. Simply google them