SAP Tabel J_1BAQ (Form)

SAP table J_1BAQ has 2 primary key fields being MANDT,FORM.

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

FORM

Form of Electronic Fiscal Document

CHAR

J_1BFORM

MODEL

Model of Nota Fiscal

NUMC

J_1BMODEL

01	Nota Fiscal - Model 1/1A
02	Nota Fiscal - Consumption
03	Nota Fiscal - Entrada
04	Nota Fiscal - Production
06	Nota Fiscal - Electrical Energy
07	Nota Fiscal - Transportation Service
08	Conhecimento - Road
09	Conhecimento - Inland Waterways
10	Conhecimento - Air
11	Conhecimento - Train
21	Nota Fiscal - Communication Service
22	Nota Fiscal - Telecommunication Service
55	Nota Fiscal - Model 55
57	Conhecimento de Transporte Eletrônico (CT-e) Model 57
66	Electronic Nota Fiscal for Energy
67	Conhecimento de Transporte Eletrônico (CT-e OS) Model 67

SERIES

Series

CHAR

J_1BSERIES

J_1BAQ foreign key relationships

Table	Field	Check Table		Check Field
0 J_1BAQ	MANDT	T000	Clients	MANDT