Object Type
|
SAP Database Field Lengths
|
Parts (Materials)
|
18 characters
|
Documents
|
25 characters
|
Change Notices (Change Masters)
|
12 characters
|
Process plans(Routing)
|
8 characters
|
Sequences
|
6 characters
|
Equipment
|
18 characters
|
Process Materials
|
18 characters
|
Operation labels
|
4 characters
|
|
For object types other than Operations, the applicable field in the above table is Number. For Operations however, it is Label.
|
Object Type
|
Internal Ranges
|
External Ranges
|
Parts
|
1 to 99,999,999
100,000,000 to 199,999,999
|
A to ZZZZZZZZ
|
Documents
|
10,000,000,000 to 9,999,999,999,999,999
10,000,000,000,000,000 to 99,999,999,999,999,999,999
100,000 to 999,999
|
1 to 99,999
1,000,000 to 9,999,999,999
|
CNs
|
500,000,000,000 to 999,999,999,999
|
1 to 499,999,999,999
|
Equipment
|
00000001 to 00199999
|
A to ZZZZZZZZ
|
Process Plans
|
50000000 to 99999999
|
A to ZZZZZZZZ
|
Process Materials
|
1 to 99,999,999
100,000,000 to 199,999,999
|
A to ZZZZZZZZ
|
Object Type
|
Object Number Character Limit
|
Out of the Box Number Range Configuration
|
Object Number Padding Required
|
External Range Check
|
|
Internal
|
External
|
||||
Parts
|
18
|
1 to 99,999,999
100,000,000 to 199,999,999
|
A to ZZZZZZZZ
|
Y – numeric only
|
N
|
BOMs
|
NA
|
NA
|
NA
|
NA
|
NA
|
Documents
|
25
|
10,000,000,000 to 9,999,999,999,999,999
10,000,000,000,000,000 to 99,999,999,999,999,999,999
100,000 to 999,999
|
1 to 99,999
1,000,000 to 9,999,999,999
|
Y – numeric only
|
Y – numeric only
|
CNs
|
12
|
500,000,000,000 to 999,999,999,999
|
1 to 499,999,999,999
|
N
|
Y – numeric only
|
Process Plans
|
8
|
50000000 to 99999999
|
A to ZZZZZZZZ
|
Y – numeric only
|
Y – numeric only . By default SAP does not provide numeric external ranges.You must customize to have external range set as numeric.
|
Equipment
|
18
|
00000001 to 00199999
|
A to ZZZZZZZZ
|
Y – numeric only
|
Y – numeric only . By default SAP does not provide numeric external ranges.You must customize to have external range set as numeric.
|
Process Materials
|
18
|
1 to 99,999,999
100,000,000 to 199,999,999
|
A to ZZZZZZZZ
|
Y – numeric only
|
N
|
Sequences
|
6
|
N/A
|
A to ZZZZZZZZ
|
Y – numeric only
|
N
|
Object Type
|
Object Number Character Limit
|
Out of the Box Number Range Configuration
|
Object Number Padding Required
|
External Range Check
|
|
Internal
|
External
|
||||
Parts
|
18
|
1 to 99,999,999
100,000,000 to 199,999,999
|
A to ZZZZZZZZ
|
Y – numeric only
|
N
|
BOMs
|
NA
|
NA
|
NA
|
NA
|
NA
|
Documents
|
25
|
10,000,000,000 to 9,999,999,999,999,999
10,000,000,000,000,000 to 99,999,999,999,999,999,999
100,000 to 999,999
|
1 to 99,999
1,000,000 to 9,999,999,999
|
Y – numeric only
|
Y – numeric only
|
CNs
|
12
|
500,000,000,000 to 999,999,999,999
|
1 to 499,999,999,999
|
N
|
Y – numeric only
|
Process Plans
|
8
|
50000000 to 99999999
|
A to ZZZZZZZZ
|
Y – numeric only
|
Y – numeric only . By default SAP does not provide numeric external ranges.You must customize to have external range set as numeric.
|
Equipment
|
18
|
00000001 to 00199999
|
A to ZZZZZZZZ
|
Y – numeric only
|
Y – numeric only . By default SAP does not provide numeric external ranges.You must customize to have external range set as numeric.
|
Process Materials
|
18
|
1 to 99,999,999
100,000,000 to 199,999,999
|
A to ZZZZZZZZ
|
Y – numeric only
|
N
|
Sequences
|
6
|
N/A
|
A to ZZZZZZZZ
|
Y – numeric only
|
N
|
|
If the numerical number ranges are not properly maintained SAP fails to create the control characteristic and displays the following error message:
Q0 -130: Number range interval 02 for number range object QMERKMALE not found
To avoid this error internal number ranges need to be maintained.
|
|
Number ranges for the Master Inspection Characteristics should follow the SAP format. The SAP format is as follows:
|