This morning, I answered a question about the inner serial number range and skipped further sorting. I only posted chat records.
<Q> 9:09:28
I wonder if you have encountered this problem.
Is to create the material master data, sometimes the material number will jump for no reason
What is the reason?
<Q> 9:09:46
Is this related to basis?
<Answer> 9:10:49
Unrelated. Normal.
<Answer> 9:11:09
Generally, it is a jump after the server is restarted because the cache is used.
<Q> 9:11:35
Still not very familiar ~~
Our server has never been restarted.
<Answer> 9:13:17
10
<Answer> 9:13:24
Number in the buffer zone 10
<Q> 9:15:54
? There are 10 numbers in the buffer.
<Answer> 9:15:56
It is strange that materials are assigned internally.
<Answer> 9:16:06
Yes. If there is no such thing, take 10 for use.
<Answer> 9:16:11
After use.
<Intercept> 9:16:31
How can we avoid it?
<Q> 9:16:36
Yes
<Q> 9:16:43
How to avoid it?
<Answer> 9:17:18
Unavoidable
<Intercept> 9:17:26
<Answer> 9:17:33
Because these things have no absolute requirements for serial numbers.
<Q> 9:17:45
.... Does your company have this phenomenon?
<Answer> 9:18:23
A prompt is displayed when you create a serial number range. If you need a serial number, this buffer is not set.
<Answer> 9:18:33
This is what sap requires.
<Intercept> 9:20:07
Long knowledge
<Q> 9:20:15
Oh? You mean when the module consultant makes the configuration, you can set it to not use this buffer?
<Answer> 9:20:30
No. This is determined during development and cannot be configured.
<Answer> 9:20:41
You are basis. You don't need to know this.
<Answer> 9:21:25
Of course, force modification is not impossible, if the demand is very strong.
<Answer> 9:22:06
There is nothing to modify in SAP.
<Q> 9:22:11
Actually ~ I don't understand ~ Why do I skip the number when a buffer is used?
<Answer> 9:22:38
The buffer is on the application server.
<Answer> 9:23:12
If a buffer is used during reading, the next pick-up number is set to the current number + buffer quantity ..
<Answer> 9:23:44
If the buffer is cleared after restart, the database will be skipped. And then jump.
<Answer> 9:23:56
It no longer checks business data tables.
<Answer> 9:24:21
Check only the table Niv ??
<Answer> 9:24:35
If the table name is forgotten, the table has been locked several times.
<Answer> 9:25:04
Deadlock causes no PRD response.
<Answer> 9:25:21
The buffer zone is recommended only for SAP to reduce deadlocks.
<Q> 9:25:48
Oh?
<Answer> 9:25:51
Such as finance, sales, and procurement. Instead, they are not buffered and do not jump.
<Answer> 9:26:17
Of course, if the database fails to be submitted when it is saved, it will also jump.
<Q> 9:26:28
So those won't be deadlocked?
<Answer> 9:26:47
No, they are the root cause of the deadlock, but there is no way.
<Answer> 9:26:59
They have higher connection numbers than materials.
<Answer> 9:27:15
First, ensure the business and try to optimize it technically.
<Q> 9:27:46
Hmm ~
<Answer> 9:28:28
Nriv
<Answer> 9:28:33
You can check this table.
<Q> 9:28:47
Okay! Let's see
<Answer> 9:28:51
The data volume is not large.
<Answer> 9:28:58
However, it is frequently used.
<Q> 9:34:36
Not fully understood yet ~ But I understand it a bit.
Only ~ We did not restart the server, but only restarted SAP applications and databases.
<Q> 9:34:44
Is this also related?
<Answer> 9:35:31
The buffer is in the memory of the application server.
<Answer> 9:35:39
Memory.
<Answer> 9:35:45
Restart is gone.
<Answer> 9:36:38
Normally, when reading the next Program Instead of looking for a database, you can read it directly from the memory. The database value has been updated to the last number + 1 in the memory.
<Answer> 9:36:46
The database is persistent
<Answer> 9:37:01
So after the restart, the memory number is gone, and the database is skipped.
<Q> 9:38:29
Oh ~ It seems a bit clear!
<Q> 9:38:52
Master Hua ~ You have a deep understanding of sap!
<Answer> 9:39:10
This number range is frequently used.
<Q> 9:42:20
Is this number range the range of all numbers? Including materials, financial sales, and purchasing ??
<Answer> 9:43:50
Yes, basically all numbers used as primary keys are included.
<Answer> 9:44:04
Suppliers, customers ......