SAP table J_1BNFENUMCHECK (NF-e Number Range - Last checked Number)

SAP table J_1BNFENUMCHECK has 8 primary key fields being MANDT,BUKRS,BRANCH,FORM,OBJECT,SUBOBJ,NRRANGENR,TOYEAR.

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 T001 BUKRS
BRANCH Business Place CHAR 4 0 J_1BBRANCH J_1BBRANC_
FORM Form of Electronic Fiscal Document CHAR 4 0 J_1BAQ J_1BFORM
OBJECT Number Range Object CHAR 10 0 * NROBJ
SUBOBJ Number range object subobject value CHAR 6 0 NRIV NRSOBJ
NRRANGENR Number range number CHAR 2 0 NRIV NRNR
TOYEAR To fiscal year NUMC 4 0 NRYEAR
LCNUMBER To number CHAR 20 0 NRTO

J_1BNFENUMCHECK foreign key relationships

Table Field Check Table Check Field
0 J_1BNFENUMCHECK BRANCH J_1BBRANCH Business Place BUKRS
0 J_1BNFENUMCHECK BRANCH J_1BBRANCH Business Place BRANCH
0 J_1BNFENUMCHECK BRANCH J_1BBRANCH Business Place BUPLA_TYPE
1 J_1BNFENUMCHECK BUKRS T001 Company Codes BUKRS
0 J_1BNFENUMCHECK FORM J_1BAQ Form MANDT
0 J_1BNFENUMCHECK FORM J_1BAQ Form FORM
1 J_1BNFENUMCHECK NRRANGENR NRIV Number Range Intervals CLIENT
1 J_1BNFENUMCHECK NRRANGENR NRIV Number Range Intervals SUBOBJECT
1 J_1BNFENUMCHECK NRRANGENR NRIV Number Range Intervals NRRANGENR
1 J_1BNFENUMCHECK NRRANGENR NRIV Number Range Intervals TOYEAR
0 J_1BNFENUMCHECK SUBOBJ NRIV Number Range Intervals CLIENT
0 J_1BNFENUMCHECK SUBOBJ NRIV Number Range Intervals SUBOBJECT
0 J_1BNFENUMCHECK SUBOBJ NRIV Number Range Intervals NRRANGENR
0 J_1BNFENUMCHECK SUBOBJ NRIV Number Range Intervals TOYEAR