Skip to Content
avatar image
Former Member

Auto-ID

Whats the max limit of Auto-ID.

It starts from 1. whats the max permissible end limit?

- Sandesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jun 04, 2009 at 11:34 AM

    Hi Sandesh,

    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.

    Regards,

    Jitesh Talreja

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 04, 2009 at 12:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 04, 2009 at 01:09 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 04, 2009 at 02:09 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 05, 2009 at 02:27 AM

    10 digits you have to define.

    hope this solves,

    + An

    • this is not SAP official message

    Add comment
    10|10000 characters needed characters exceeded