问题解决之图标表最大长度限制

最新推荐文章于 2024-04-12 16:55:00 发布

syjf1976_ABAP

最新推荐文章于 2024-04-12 16:55:00 发布

阅读量1k

点赞数

文章标签： css css3 数据库 weex 办公软件

本文链接：https://blog.csdn.net/syjf1976/article/details/119013563

版权

点击蓝字 关注我们

一

前言

无意中发现有人在一个群里提问:怎么突破表的最大限制. 有人答复拆分成多个表.这个看似可行的方案讲给后续的开发带来一些麻烦. 看来这个小问题还是困扰了一些开发.希望本文能够解决你的这个疑问.

二

问题发现

当自定义表时,或者通过增强的方式给标准表添加自定义字段时,如果所有字段的长度总计超过了4030,系统会报错阻止表的创建或调整报错消息 D0 519.

当然,如果是增强单据抬头或明细表字段, 因为BAPI传递的长度最大960(局限于结构BAPIPAREX. 如果增强字段总长度超过了960,通过BAPI传递会有部分字段丢失. 此时就需要调整BAPI传递字段的方式了. 因为与本文主题无关,就不赘诉了.

三

问题的查找

通过消息号查询NOTE ,可以找到SAP给出的原因及解决办法

四

NOTES原文如下

During the activation of a transparent table, activation error D0 519 occurs because the width of the table exceeds 4030 "bytes".

Other Terms

D0519, D0 519

Reason and Prerequisites

Because SAP supports various database platforms, you must make sure that tables are defined in the ABAP Dictionary so that they can be created on all platforms. In each case, the minimum required database platforms for an R/3 release are taken into account for this.Before SAP Basis 6.20 Support Package 25, the limit was 1962. When the limit was increased to 4030, the restriction of 1962 in lower releases became invalid. It can be increased to 4030 there, too.

In the display, the unit "byte" is used for the table width. This essentially corresponds to the work area width for a non-Unicode configuration. For other system configurations, the value should be seen rather as a virtual unit and a distinction should be made from the width in real bytes.

Solution

To increase each limit above 4030 (1962), the value of the constant TABLEN in the program RADTBCON must be changed accordingly. This is a modification of the SAP standard system. It must then be retained in the modification adjustment of upgrades, too.The following paragraph applies only to Basis releases below 610:If you have changed the constant in RADTBCON, this change must also be made for RESULT_WA in the include LSDFCTOP. Otherwise, "SAPSQL_SELECT_WA_TOO_SMALL" terminations would occur if a table beyond the formerly valid limit were used as a check table in a foreign key relationship.

五

问题的解决

SAP为了兼容各种数据库,限制了表的最大长度. 目前时4030个字符.超过长度就会报错. 如果确保你的数据库系统支持超过4030个字符(目前的主流数据库都没有这个限制了). 可以通过修改程序RADTBCON中的变量 TABLEN VIEWLEN

版本差异

SPRING

NOTE中提到的必须跟着修改INCLUDE 程序LSDFCTOP 中的变量长度RESULT_WA .这个根据版本不同,有点差别. HANA 1709版本已经不需要这个长度限制了 .