SAP table OFF_NUM_ID (Settings for Official Document Numbering Indonesia)

SAP table OFF_NUM_ID has 8 primary key fields being MANDT,BUKRS,BUPLA,DOCCLASS,VALIDFROM,VALIDTO,PREFIXCODE1,PREFIXCODE2.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
BUKRS Company Code CHAR 4 0 * BUKRS
BUPLA Business Place CHAR 4 0 J_1BBRANCH BUPLA
DOCCLASS Official document class CHAR 3 0 DOCCLSS DOCCLS
VALIDFROM Date from DATS 8 0 DATE_FROM
VALIDTO Expiration Date DATS 8 0 DATE_TCURE
PREFIXCODE1 Serial Code 1 CHAR 5 0 ID_OFF_NUM_PREFIX1
PREFIXCODE2 Serial Code 2 CHAR 3 0 ID_OFF_NUM_PREFIX2
PREFIX_EXP Serial Code for Exports CHAR 4 0 ID_OFF_NUM_PREFIX_EXP
SUBOBJECT Number Group for Official Documents CHAR 6 0 J_1ANUMGR1 J_1ANUMGR_
GROUPNUMBER Number range number CHAR 2 0 NRIV NRNR
LASTDATE Date of last number assignment DATS 8 0 J_1ADATETO

OFF_NUM_ID foreign key relationships

Table Field Check Table Check Field
0 OFF_NUM_ID BUPLA J_1BBRANCH Business Place BUKRS
0 OFF_NUM_ID BUPLA J_1BBRANCH Business Place BRANCH
0 OFF_NUM_ID BUPLA J_1BBRANCH Business Place BUPLA_TYPE
1 OFF_NUM_ID DOCCLASS DOCCLSS Official document class LAND1
0 OFF_NUM_ID GROUPNUMBER NRIV Number Range Intervals CLIENT
0 OFF_NUM_ID GROUPNUMBER NRIV Number Range Intervals SUBOBJECT
0 OFF_NUM_ID GROUPNUMBER NRIV Number Range Intervals NRRANGENR
0 OFF_NUM_ID GROUPNUMBER NRIV Number Range Intervals TOYEAR
1 OFF_NUM_ID SUBOBJECT J_1ANUMGR1 Numbering group for official documents MANDT