ERPTable 列被截断
我生成了一些代理 ERPTables 来查询 SAP 表。这些列生成为字符串类型。由于 ERPConnect Linq 似乎不支持连接，或者基本上不支持 where 子句中的任何查询，这些查询比相等比较更复杂，因此我必须将连接拆分为多个单独的查询，并在 C# 中执行连接。问题是某些 GUID 键列被截断为 16 个字符。
我一直在尝试调查这个问题，但 ERPTable 似乎没有任何可调整的参数。我高度怀疑 SAP 方面存在一些问题，但我不知道要进行哪些检查才能限制问题的根源。
有人在使用 ERPConnect 时遇到过这个问题吗？
I've generated some proxy ERPTables to query SAP tables. The columns are generated as type string. Since ERPConnect Linq doesn't seem to support join, like or basically any query in the where clause more complex than equality comparisons, I had to split the join in several individual queries and do the joins in C#. The problem is that some of the GUID key columns are coming truncated to 16 characters.
I've been trying to investigate this but the ERPTable doesn't seem to have any adjustable parameter for this. I highly suspect that is some shanenigan in the SAP side but I don't know what checks to do in order to constrain the source of the problem.
Has anyone experienced this problem with ERPConnect?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您需要使用自定义函数“Z_XTRACT_IS_TABLE”，如下半部分的帮助中所述（表访问限制）：
http://help.theobald-software.com/ERPConnect-EN/default.aspx?pageid=reading-sap-tables-directly-with-readtable
如果您使用的是 Linq，您可以在这里找到它：
http://help.theobald-software.com/ERPConnect-EN/default.aspx?pageid=linq-to-sap-table-access-restrictions
这是 SAP 限制，并且使用默认功能模块时，仅发送前 16 个字符。
最好的问候，
阿里
you need to use the custom function "Z_XTRACT_IS_TABLE" like described in the Help in the lower part (Table Access Restrictions):
http://help.theobald-software.com/ERPConnect-EN/default.aspx?pageid=reading-sap-tables-directly-with-readtable
If you are using Linq you can find it here:
http://help.theobald-software.com/ERPConnect-EN/default.aspx?pageid=linq-to-sap-table-access-restrictions
This is an SAP Restriction, and when using the default function module, only the first 16 chars are sent.
Best Regards,
Ali