cancel
Showing results for 
Search instead for 
Did you mean: 

CO number range isnt updating

Former Member
0 Kudos

Hello Gurus,

recently we made client copy.

After that we are unable to create FICO documents.

If we create document only in IF it is created, but when we assign cost center or order it shows that doc.nr is created and number assigned but its not.

Also the CO number doens get updated, whereas FI counts +1 on posting.

We are getting also these errors:

"SAPSQL_ARRAY_INSERT_DUPREC" "CX_SY_OPEN_SQL_DB"

"SAPLGLIU" or "LGLIUF11"

"INS_ZSGBDGA"

Searched the whole internet

Created and assigned Logical system, then made a converted logical system names, then changed number ranges for Controlling are and FI documents but still nothing

Is there some place in CO which needs to be maintained?

Or what should i do?

best regards

Laurynas Prikockis

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Helpful answer. Found problem by my self

Former Member
0 Kudos

HI,

check your CO number ranges (T-code KANK).

The "DUPREC" in the error message means "Duplicate records" so when you try to post a CO-document the current number from the number range interval used is lower than the number of the last CO-document already posted (see table COBK). And you cannot post 2 documents in one CO-area with the same document number.

So

Make an MS Excel back up of NRIV RK_BELEG,

check for each number range the highest COBK entry,

delete the number range buffer (SM56, explanation to buffering see SAPNET note 62077)

and set your "current number" in KANK to the level of the highest COBK entry.

The next CO document you try to post should be posted with the highest COBK entry +1 and the number range buffer is "refilled".

Best regards, Christian

Former Member
0 Kudos

Hello,

ive done the same, but also found that some Consultantat back in 2005 made some changes and in the report

LGLIUF11 included some additional table ZSGBDGA which numbers are driving me crazy.

FORM INS_ZSGBDGA "#EC CALLED

TABLES P_T_TABLE

USING P_RECORD TYPE ANY

P_RENUMBER_OBJ TYPE BOOLE_D. "#EC NEEDED

DATA: T_ZSGBDGA LIKE ZSGBDGA OCCURS 0 WITH HEADER LINE.

CLEAR T_ZSGBDGA . REFRESH T_ZSGBDGA .

T_ZSGBDGA[] = P_T_TABLE[].

IF P_T_TABLE[] IS INITIAL.

APPEND P_RECORD TO T_ZSGBDGA .

ENDIF.

IF NOT P_RENUMBER_OBJ IS INITIAL.

SORT T_ZSGBDGA .

CALL FUNCTION 'G_ADJUST_RECORD'

EXPORTING

TABELLENNAME = 'ZSGBDGA '

RENUMBER_OBJ = 'X'

TABLES

TABELLE = T_ZSGBDGA .

ENDIF.

GET TIME.

T_ZSGBDGA-CPUDT = SY-DATUM.

T_ZSGBDGA-CPUTM = SY-UZEIT.

MODIFY T_ZSGBDGA TRANSPORTING CPUDT CPUTM

WHERE RCLNT = SY-MANDT OR RCLNT NE SY-MANDT.

INSERT ZSGBDGA FROM TABLE T_ZSGBDGA .

IF SY-SUBRC NE 0.

MESSAGE X201 WITH 'ZSGBDGA '.

ENDIF.

ENDFORM.

Im trying to find the place where the number range is stored.

Any idea how it can be done?

Regards

Laurynas

Former Member
0 Kudos

Hi Laurynas,

well I don't know why this code in the include LGLIUF11 is created and what's the purpose (requirement).

I just looked into SAPNET notes and found 896166 and 377053 maybe they are helpful.

Best regards, Christian.

Former Member
0 Kudos

Thank you for your help.

I found the answer:

TC -> SNRO

Object type -> GL_RECID

and the document creation started working

Best Regards

Laurynas