SAP Table OFF_NUM_ID
Settings for Official Document Numbering Indonesia
OFF_NUM_ID (Settings for Official Document Numbering Indonesia) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link OFF_NUM_ID to other SAP tables.
OFF_NUM_ID table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | 0 | |||
| BUPLA | Business Place | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | ||
| DOCCLASS | Official document class | DOCCLS | DOCCLSS | CHAR | 3 | 0 | ||
| VALIDFROM | Date from | DATE_FROM | DATS | 8 | 0 | |||
| VALIDTO | Expiration Date | DATE_TCURE | DATS | 8 | 0 | |||
| PREFIXCODE1 | Serial Code 1 | ID_OFF_NUM_PREFIX1 | CHAR | 5 | 0 | |||
| PREFIXCODE2 | Serial Code 2 | ID_OFF_NUM_PREFIX2 | CHAR | 3 | 0 | |||
| PREFIX_EXP | Serial Code for Exports | ID_OFF_NUM_PREFIX_EXP | CHAR | 4 | 0 | |||
| SUBOBJECT | Number Group for Official Documents | J_1ANUMGR_ | J_1ANUMGR1 | CHAR | 6 | 0 | ||
| GROUPNUMBER | Number range number | NRNR | NRIV | CHAR | 2 | 0 | ||
| LASTDATE | Date of last number assignment | J_1ADATETO | DATS | 8 | 0 | |||
OFF_NUM_ID foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| OFF_NUM_ID | BUPLA | OFF_NUM_ID | MANDT | J_1BBRANCH | Business Place | MANDT |
| OFF_NUM_ID | BUPLA | OFF_NUM_ID | BUKRS | J_1BBRANCH | Business Place | BUKRS |
| OFF_NUM_ID | BUPLA | OFF_NUM_ID | BUPLA | J_1BBRANCH | Business Place | BRANCH |
| OFF_NUM_ID | DOCCLASS | OFF_NUM_ID | MANDT | DOCCLSS | Official document class | MANDT |
| OFF_NUM_ID | DOCCLASS | 'ID' | DOCCLSS | Official document class | LAND1 | |
| OFF_NUM_ID | DOCCLASS | OFF_NUM_ID | DOCCLASS | DOCCLSS | Official document class | DOCCLS |
| OFF_NUM_ID | GROUPNUMBER | OFF_NUM_ID | SUBOBJECT | NRIV | Number Range Intervals | SUBOBJECT |
| OFF_NUM_ID | GROUPNUMBER | OFF_NUM_ID | GROUPNUMBER | NRIV | Number Range Intervals | NRRANGENR |
| OFF_NUM_ID | GROUPNUMBER | '0000' | NRIV | Number Range Intervals | TOYEAR | |
| OFF_NUM_ID | GROUPNUMBER | OFF_NUM_ID | MANDT | NRIV | Number Range Intervals | CLIENT |
| OFF_NUM_ID | GROUPNUMBER | 'J_1AOFFDOC' | NRIV | Number Range Intervals | OBJECT | |
| OFF_NUM_ID | SUBOBJECT | OFF_NUM_ID | SUBOBJECT | J_1ANUMGR1 | Numbering group for official documents | J_1ANUMGR1 |
| OFF_NUM_ID | SUBOBJECT | OFF_NUM_ID | MANDT | J_1ANUMGR1 | Numbering group for official documents | MANDT |
