on 06-04-2009 12:18 PM
Whats the max limit of Auto-ID.
It starts from 1. whats the max permissible end limit?
- Sandesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
10 digits you have to define.
hope this solves,
+ An
this is not SAP official message
Hi Sandesh,
If Auto Id field is 4 bytes then
1 Byte = 8 Bits
4 Bytes = 32 Bits
It can store upto 2^31 - 1 i.e. 2,147,483,647.
Regards,
Jitesh Talreja
i also have all guides and its not mentioned anywhere.
Guides also say 4 byte integer which i dont understand because i m not technical consultant.
so my question is simple, can it handle 1M, 10 M , 1B, 10B or 10 digit or 15 digit
- Sand
Hi Sandesh
AutoID format field depend for DBMS type.
It's field have type - 4-byte integer field.
In different DBMS AutoID can have type:
Ms sql - Int
Oracle - Number
DB2 - Int
Max DB - Fixed (10)
Beast regards
As such there is no limit for Auto-Id field and as per my knowledge it is not mentioned anywhere. It will give the desired result as long as your system can handle the records.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.