F-02 DBSQL_DUPLICATE_KEY_ERROR CX_SY_OPEN_SQL_DB SAPLKAUP CO-OM

最新推荐文章于 2023-06-02 11:25:56 发布

budaha

最新推荐文章于 2023-06-02 11:25:56 发布

阅读量3.7k

点赞数 2

分类专栏： SAP

本文链接：https://blog.csdn.net/budaha/article/details/85008853

版权

3 篇文章 0 订阅

订阅专栏

遇到错误了。HANA SFIN。

F-02 DBSQL_DUPLICATE_KEY_ERROR CX_SY_OPEN_SQL_DB SAPLKAUP CO-OM

出错位置：

【INSERT COBK FROM TABLE COBK_INS.】

ABAP 编程错误：
DBSQL_DUPLICATE_KEY_ERROR
CX_SY_OPEN_SQL_DB
SAPLKAUP
CO-OM

想想应该是NUMBER RANGE 这个妖孽作怪。

发现Document Numbers in Controlling没有配置number range，是通过算法配置的？

Business transaction	CO document number
CO business transactions except COIN	Taken from the number range for the business transaction as defined in the Customizing activity Maintain Number Ranges for Controlling Documents Example: 4000000001
Business transaction COIN (CO through-posting from Financial Accounting)	Automatically generated alphanumeric number Example: A00001XP00 Note This number is not taken from any number range. It is generated automatically based on an algorithm.

Business transaction

CO document number

CO business transactions except COIN

Taken from the number range for the business transaction as defined in the Customizing activity Maintain Number Ranges for Controlling Documents

Example: 4000000001

Business transaction COIN (CO through-posting from Financial Accounting)

Automatically generated alphanumeric number

Example: A00001XP00

Note Note

This number is not taken from any number range. It is generated automatically based on an algorithm.

无果。想找找什么算法。瞄一眼。看到了这个算法代码。

CL_FINS_ACDOC_AUXILIARY_DOCNO=》GET_AUXILIARY_DOCNO

TRANSFORM_NUM12_TO_CHAR08

在它之前会去掉用number range 对象ACDOCA_AUX进行取数传入数据，传出一个A开头的CO凭证。

于是SNRO修改了配置。

运行。成功啦。晕死了。

关注