F-02 DBSQL_DUPLICATE_KEY_ERROR CX_SY_OPEN_SQL_DB SAPLKAUP CO-OM

遇到错误了。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 这个妖孽作怪。

https://help.sap.com/saphelp_sfin200/helpdata/en/a0/718655a1c57b43e10000000a4450e5/content.htm?no_cache=true

发现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 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修改了配置。

 

运行。成功啦。晕死了。


版权声明:本文为budaha原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。