SAP table J_1BAGN (CFOP with Version Number)

SAP table J_1BAGN has 3 primary key fields being MANDT,VERSION,CFOP.

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

T000

MANDT

VERSION

CFOP Version Number

NUMC

J_1BCFOPVER

J_1BCFOP_VER

CFOP

CFOP Code and Extension

CHAR

J_1BCFOP

ICMS_EXEMPT_REAS

Reason for ICMS Exemption

CHAR

J_1BNFE_ICMS_EXEMPTION_REASON

1	Taxi
10	Physically disabled person with driving license
11	Physically disabled person without driving license
12	Dep for Agricultural and Livestock Promotion and Development
16	Rio 2016 Olympics
2	Disabled person
3	Agricultural producer
4	Car fleet/rental
5	Diplomatic/consular
6	Utility vehicles/motorcycl. from west.Amazon/free trade area
7	SUFRAMA (Supervision of the Zona Franca of Manaus)
8	Sales to public agencies
9	Other
90	Requested by Tax Authority

FINNFE

NF-e Issuing Function

CHAR

J_1BNFE_FINNFE

1	Normal NF-e
2	Complementary NF-e
3	Correction NF-e
4	Return NF-e

J_1BAGN foreign key relationships

Table	Field	Check Table		Check Field
0 J_1BAGN	MANDT	T000	Clients	MANDT
1 J_1BAGN	VERSION	J_1BCFOPVER	CFOP Version Numbers	MANDT
1 J_1BAGN	VERSION	J_1BCFOPVER	CFOP Version Numbers	VERSION