SAP table J_1BNFDOC (Nota Fiscal Header)

SAP table J_1BNFDOC has 2 primary key fields being MANDT,DOCNUM.

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 T000 MANDT
DOCNUM Document Number NUMC 10 0 J_1BDOCNUM
NFTYPE Nota Fiscal Type CHAR 2 0 J_1BAA J_1BNFTYPE
DOCTYP Document type CHAR 1 0 J_1BDOCTYPES J_1BDOCTYP
DIRECT Direction of the movement CHAR 1 0 J_1BDIRECT
1 Incoming
2 Outgoing
3 Outgoing Returns of Stock Transfers
4 Incoming Returns of Stock Transfers
DOCDAT Document date DATS 8 0 J_1BDOCDAT
PSTDAT Posting date DATS 8 0 J_1BPSTDAT
CREDAT Create date DATS 8 0 J_1BCREDAT
CRETIM Creation time TIMS 6 0 J_1BCRETIM
CRENAM Name of the user CHAR 12 0 J_1BCRENAM
CHADAT Change date DATS 8 0 J_1BCHADAT
CHATIM Change time TIMS 6 0 J_1BCHATIM
CHANAM Name of the user CHAR 12 0 J_1BCHANAM
FORM Form of Electronic Fiscal Document CHAR 4 0 J_1BAQ J_1BFORM
MODEL Model of Nota Fiscal NUMC 2 0 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 3 0 J_1BSERIES
SUBSER Sub series CHAR 2 0 J_1BSUBSER
NFNUM Nota Fiscal Number NUMC 6 0 J_1BNFNUMB
ENTRAD Nota Fiscal Entrada CHAR 1 0 J_1BENTRAD
Saida
X Entrada
FATURA Fatura CHAR 1 0 J_1BFATURA
ZTERM Terms of payment key CHAR 4 0 DZTERM
PRINTD Printed CHAR 1 0 J_1BPRINTD
MANUAL Created manually CHAR 1 0 J_1BMANUAL
Created automatically (Interface)
X Created manually (J1B1N)
FOLLOW Follow up activity made CHAR 1 0 J_1BFOLLOW
WAERK SD Document Currency CUKY 5 0 TCURC WAERK
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUKRS Company Code CHAR 4 0 T001 BUKRS
BRANCH Business Place CHAR 4 0 PBUSINESSPLACE J_1BBRANC_
PARVW Nota Fiscal Partner Function CHAR 2 0 J_1BAD J_1BPARVW
PARID Partner ID (Customer, Vendor, Business Place) CHAR 10 0 J_1BPARID
PARXCPDK Indicator: Is the account a one-time account? CHAR 1 0 XCPDK
PARTYP Nota Fiscal Partner Type CHAR 1 0 J_1BPARTYP
B Business Place
C Customer
V Vendor
CANCEL Canceled CHAR 1 0 J_1BCANCEL
CANDAT Cancellation Date DATS 8 0 J_1BCANDAT
SUBSEQ Follow-On Document Exists CHAR 1 0 J_1BSUBSEQ
DOCREF Reference to NF NUMC 10 0 J_1BNFDOC J_1BDOCREF
TRATY Means-of-Transport Type CHAR 4 0 TVTY TRATY
TRAID Means of Transport ID CHAR 20 0 TRAID
INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
SHPUNT Shipping unit (especie) UNIT 3 0 T006 J_1BSHPUNT
ANZPK Total Number of Packages in Delivery NUMC 5 0 ANZPK
SHPMRK Mark of the shipping unit CHAR 20 0 J_1BSHPMRK
SHPNUM Number of the shipping unit CHAR 20 0 J_1BSHPNUM
BRGEW Gross weight QUAN 15 3 BRGEW_15
NTGEW Net weight QUAN 15 3 NTGEW_15
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
WITHA Total withholding amount of Nota Fiscal CURR 15 2 J_1BWITHAM
OBSERVAT Legal Books Mod. 1 + 2: Header text for observations column CHAR 50 0 J_1BLBOBS
VSTEL Shipping Point / Receiving Point CHAR 4 0 TVST VSTEL
NFDEC Decimal Places in Price Inclusive of ICMS NUMC 1 0 J_1BNFDEC
2
NFTOT Total value including all taxes CURR 15 2 J_1BNFTOT
AWSYS Logical System CHAR 10 0 LOGSYSTEM
PREFNO Service NF-e Number CHAR 20 0 J_1BPREFNO
CHECOD Verification Code of Service NF-e CHAR 20 0 J_1BCHECOD
NFE Electronic Fiscal Document CHAR 1 0 J_1BNFE
NFENUM Electronic Nota Fiscal Number CHAR 9 0 J_1BNFNUM9
NFESRV Service NF/NF-e CHAR 1 0 J_1BNFESRV
CONTING Document Posted under Contingency CHAR 1 0 J_1BCONTINGENCY
AUTHCOD Protocol Number CHAR 15 0 J_1BNFEAUTHCODE
DOCSTAT Document Status CHAR 1 0 J_1BNFEDOCSTATUS
Initial
1 Authorized
2 Rejected
3 Denied
XMLVERS XML Version DEC 4 2 J_1BNFEXMLVERSION
NFENRNR Number range number CHAR 2 0 NRNR
CODE Official Status Code CHAR 3 0 * J_1BSTATUSCODE
ANRED Title CHAR 15 0 ANRED
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
NAME3 Name 3 CHAR 35 0 NAME3_GP
NAME4 Name 4 CHAR 35 0 NAME4_GP
STRAS Street and House Number CHAR 35 0 STRAS_GP
ORT01 City CHAR 35 0 ORT01_GP
ORT02 District CHAR 35 0 ORT02_GP
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
LAND1 Country/Region Key CHAR 3 0 T005 LAND1_GP
PSTLZ Postal Code CHAR 10 0 PSTLZ
PFACH PO Box CHAR 10 0 PFACH
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
SORTL Sort field CHAR 10 0 SORTL
SPRAS Language Key LANG 1 0 T002 SPRAS
TELF1 Addresses: telephone no. CHAR 30 0 TLFNR
TELFX Fax Number CHAR 31 0 TELFX
TELTX Teletex number CHAR 30 0 TELTX
TELX1 Telex number CHAR 30 0 TELX1
INDUST Customer's CFOP category CHAR 2 0 J_1BINDUS1
00 industry (cooperative)
01 electric co.
02 communication co.
03 transport co.
04 service co.
05 consumer industry (cooperative)
06 non-contributing customer
07 agricultural customer
08 trading company
09 producer establishment
STKZN Natural Person CHAR 1 0 STKZN
Legal person
X Natural person
CGC CNPJ Number NUMC 14 0 J_1BCGC
CPF CPF number NUMC 11 0 J_1BCPF
STAINS State Tax Number CHAR 18 0 J_1BSTAINS
MUNINS Municipal Tax Number CHAR 20 0 J_1BMUNINS
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
HAUSN House number CHAR 6 0 HAUSN_BAS
STOCK Floor CHAR 6 0 STOCK
STREET Street CHAR 60 0 AD_STREET
HOUSE_NUM1 House Number CHAR 10 0 AD_HSNM1
HOUSE_NUM2 House number supplement CHAR 10 0 AD_HSNM2
IND_IEDEST NF-e State Tax Number Indicator NUMC 1 0 J_1BNFE_IEDEST
1 ICMS Contributor
2 ICMS Contributor - Exempted
9 No ICMS Contributor
FOREIGNID NF-e Partner Foreign ID CHAR 20 0 J_1BNFE_FOREIGNID
SMTP_ADDR E-Mail Address CHAR 241 0 AD_SMTPADR
AUTHDATE Processing Timestamp - Date DATS 8 0 J_1BAUTHDATE
AUTHTIME Processing Timestamp - Time TIMS 6 0 J_1BAUTHTIME
BAPI_FLAG Nota Fiscal Created via BAPI CHAR 1 0 J_1BBAPI
SERV_TP Service Type Indicator CHAR 1 0 J_1BCTE_SERV_TP
0 Normal
1 Subcontracting
2 Redispatch
3 Intermediate Redispatch
4 Service Linked To Multimodal
CTE_STRT_LCT Jurisdiction Code of the Point of Origin CHAR 15 0 J_1BTXJUR J_1BCTE_SJCD
CTE_END_LCT Jurisdiction Code of the Final Destination CHAR 15 0 J_1BTXJUR J_1BCTE_EJCD
MAIN_PRODUCT Main Product Transported CHAR 60 0 J_1BCTE_MAIN_PROD
RCVR_WDW Receiver Collection Indicator CHAR 1 0 J_1BCTE_RCVR_WDW
PLN_DT_DLV Estimated Delivery Date DATS 8 0 J_1BCTE_PLN_DT_DLV
FTL_IND Full Truck Load Indicator CHAR 1 0 J_1BCTE_FTL_IND
VOL_TRANSP Transported Volume DEC 13 3 J_1BCTE_VOL_TRANSP
VOL_UNIT Volume Measure Unit UNIT 3 0 * J_1BCTE_VOL_UNIT
TOTAL_REF_AMT Total Amount of Goods CURR 15 2 J_1BCTE_REF_TOT_VAL
TRANSP_MODE Mode of Transportation CHAR 1 0 J_1BCTE_TRANSPTN_MODE
1 Road
2 Air
3 Sea
4 Rail
5 Pipeline
6 Multimodal
CRE_TIMESTAMP Fiscal Document: UTC Time Stamp of Creation (Short Form) DEC 15 0 J_1BCRE_TIMESTAMP
CTE_PARTNER CT-e Partner in Fiscal Document CHAR 1 0 J_1BCTE_TOMALI
Not assigned
0 Goods Sender
1 Cargo Dispatcher
2 Cargo Recipient
3 CT-e Destination
CTE_SERV_TAKER CT-e Partner as Service Taker CHAR 1 0 J_1BCTE_SERVICE_TAKER
Not relevant
0 Goods Sender
1 Cargo Dispatcher
2 Cargo Recipient
3 CT-e Destination
4 Others
CTE_TYPE CT-e Type CHAR 1 0 J_1BCTTYPE
Normal / Complementary value
A Value annulment
S Substitution
AUTOM_INCOMING Indicator for price elements coming from XML CHAR 1 0 J_1B_POSTED_WITH_XML_VALUES
DOCNUM_NEXT New Document Number when electronic fiscal doc. is copied NUMC 10 0 J_1BDOCNUM_NEXT
DOCNUM_PREV Previous Document Number when electronic fis. doc. is copied NUMC 10 0 J_1BDOCNUM_PREV
MUNICIPAL Municipal Fiscal Document CHAR 1 0 J_1BMUNICIPAL
NATOP Operation Nature Description CHAR 60 0 J_1B_OP_NATURE_DESC
INDPAG [OBSOLETE] Payment Form Indicator CHAR 1 0 J_1B_PAY_FORM_IND
0 Payment in Full
1 Deferred Payment
2 others
DSAIENT Goods Departure or Arrival Date DATS 8 0 J_1B_DEP_ARR_DATE
HSAIENT Goods Departure or Arrival Time TIMS 6 0 J_1B_DEP_ARR_TIME
CNPJ_BUPLA CNPJ Number of Business Place NUMC 14 0 J_1B_CNPJ_BUPLA
IE_BUPLA State Tax Number (IE) of Business Place CHAR 18 0 J_1B_STAINS_BUPLA
IEST_BUPLA State Tax Number (IE) of Business Place (SubTrib) CHAR 18 0 J_1B_STAIST_BUPLA
IEST_PARTNER State Tax Number of Partner (SubTrib) CHAR 18 0 J_1B_STAIST_PARTNER
IM_BUPLA Municipal tax code CHAR 20 0 J_1B_MUNINS_BUPLA
CNAE_BUPLA CNAE Code of Business Place CHAR 7 0 * J_1B_CNAE_BUPLA
CNAE_PARTNER CNAE Code of Partner CHAR 7 0 * J_1B_CNAE_PARTNER
CRT_BUPLA Tax Regimen Code (CRT) of Business Place CHAR 1 0 J_1B_CRT_BUPLA
CRT_PARTNER Tax Regimen Code (CRT) of Partner CHAR 1 0 J_1B_CRT_PARTNER
ISUF SUFRAMA Subscription of Partner CHAR 9 0 J_1B_SUFRAMA_CODE
MODFRETE Freight Mode CHAR 1 0 J_1B_FREIGHT_MODE
0 Freight arranged by the sender
1 Freight arranged by the addressee
2 Freight arranged by third parties
3 Own transportation arranged by sender
4 Own transportation arranged by addressee
9 Without freight
PLACA Vehicle License Plate CHAR 7 0 J_1B_VEHICLE_LIC_PL
UF1 Region of Vehicle CHAR 3 0 T005S J_1B_VEHICLE_UF
RNTC National Cargo Carrier Registration (RNTRC) CHAR 20 0 J_1B_NAT_CARGO_CARRIER
VAGAO Wagon Identification CHAR 20 0 J_1B_WAGON_ID
BALSA Ferryboat Identification CHAR 20 0 J_1B_FERRYBOAD_ID
NFAT Invoice Number CHAR 20 0 J_1B_BILLING_NUMBER
VORIG Invoice Original Value CURR 15 2 J_1B_BILLING_ORG_VALUE
VDESC Invoice Discount Value CURR 15 2 J_1B_DISCOUNT_VALUE
VLIQ Invoice Net Value CURR 15 2 J_1B_BILLING_NET_VALUE
UFEMBARQ Region of Shipment Place (Export) CHAR 3 0 T005S J_1B_SHIPMENT_PLACE_UF
XLOCEMBARQ Shipment Place (Export) CHAR 60 0 J_1B_SHIPMENT_PLACE
XNEMP Commitment Note CHAR 22 0 J_1B_COMMITMENT_NOTE
SPRAS_BUPLA Language of Business Place CHAR 1 0 J_1B_SPRAS_BUPLA
IND_EMIT Indicator of Fiscal Document's Issuer CHAR 1 0 J_1B_FISC_DOC_ISSUER
0 Self Issued
1 Issued by Third Party
COD_SIT Status Code of Fiscal Document CHAR 2 0 J_1B_STATUS_FISC_DOC
00 Regular Document
01 Regular Document (Late Reported)
02 Cancelled Document
03 Cancelled Document (Late Reported)
04 Denied Electronic Fiscal Document
05 Voided Number of Electronic Fiscal Document
06 Complementary Fiscal Document
07 Complementary Fiscal Document (Late Reported)
08 Fiscal Document issued on special regimen/specific norm
09 Replaced Fiscal Document
IND_FINAL NF-e Final Consumer Identification CHAR 1 0 J_1BNFE_INDFINAL
0 No
1 Final Consumer
IND_PRES NF-e Customer Presence CHAR 1 0 J_1BNFE_INDPRES
0 Not Applicable
1 Face-to-face
2 Not Face-to-face - Internet
3 Not Face-to-face - Call Center
4 NFC-e With Home Delivery
5 Face-to-face - Off-site
9 Not Face-to-face - Others
XLOCDESPACHO Dispatch CHAR 60 0 J_1BNFE_DISPATCH
DCOMPET Service Delivery Date DATS 8 0 J_1BNFE_DCOMPET
CREGTRIB Special Tax Regime Code CHAR 2 0 J_1BNFE_CREGTRIB
RETTRANSP_CFOP CFOP of ICMS Withholding for Transportation CHAR 10 0 J_1BNFE_RFC_RETTRANSP_CFOP
RETTRANSP_CMUNFG City Code NUMC 7 0 J_1BNFE_RFC_CMUNFG
IND_BADI_CTRL Flag that determines if BAdI ADD_DATA was used CHAR 1 0 J_1BNFE_IND_BADI_CTRL
BAdI ADD_DATA was not used
X BAdI ADD_DATA was used
ID_DEST NF-e Identifier of Destination Place CHAR 1 0 J_1BNFE_IDDEST
1 Internal Operation
2 Interstate Operation
3 Foreign Operation
HEMI NF-e Issuing Time TIMS 6 0 J_1BNFE_HEMI
V_TROCO Change Value CURR 15 2 J_1BNFE_VTROCO
MOD Fiscal Coupon Document Model CHAR 2 0 J_1BNFE_MOD
2B Issued by cash register (non-ECF)
2C POS
2D Issued by ECF
NCOO Operation Order Counter Number NUMC 6 0 J_1BNFE_NCOO
INDINTERMED Intermediator Indicator CHAR 1 0 J_1BNFE_INDINTERMED
Not applicable
0 Transaction without Intermediator (own website or platform)
1 Transaction on third party website or platform
IDCADINTTRAN Intermediator Identification Registry CHAR 60 0 J_1BNFE_IDCADINTTRAN
CNPJINTERMED CNPJ of the Intermediator NUMC 14 0 J_1BNFE_CNPJINTERMED
SAFRA Harvest Identification CHAR 9 0 J_1B_HARVEST_ID
REF_MONTH_YEAR Reference Month and Year CHAR 7 0 J_1B_REF_MONTH_YEAR
QTOTMES Sugar Cane: Month Quantity DEC 21 10 J_1B_SUGAR_QUAN_MONTH
QTOTANT Sugar Cane: Previous Quantity DEC 21 10 J_1B_SUGAR_QUAN_PREV
QTOTGER Sugar Cane: Total Quantity DEC 21 10 J_1B_SUGAR_QUAN_TOT
VFOR Sugar Cane: Supply Amount CURR 15 2 J_1B_SUPPLIES_VALUE
VTOTDED Sugar Cane: Total Deduction Amount CURR 15 2 J_1B_TOTAL_DEDUCT_VALUE
VLIQFOR Sugar Cane: Supply Net Amount CURR 15 2 J_1B_SUPPLIES_NET_VALUE
ITMF_REPDAT TMF Reporting Date DATS 8 0 ITMF_REPDAT
ITMF_PCO_CATEGORY Tax Category CHAR 1 0 ITMF_PCO_CATEGORY
Not processed
C Credit
N Not relevant
R Revenue
PARTR ICMS Partilha Tax Rate DEC 6 2 J_1BPARTRATE
NFNUM_UTILITIES Nota Fiscal Number for Utilities NUMC 9 0 J_1BNFNUM_UTILITIES
PARTNER_ROLE NF Partner Place Type CHAR 1 0 J_1BNFE_PART_ROLE
Not assigned
0 Delivery Place
1 Withdrawal Place
COD_CTA_HEADER G/L Account Number for Revenue/Expenses CHAR 10 0 J_1BNFE_COD_CTA_HEADER
API Created by API CHAR 1 0 LOGBR_NFAPI
No
X Yes
TAX_SERVICES_CALC Tax calculation from tax service CHAR 1 0 LOGBR_TAX_SERVICES_CALC

J_1BNFDOC foreign key relationships

Table Field Check Table Check Field
0 J_1BNFDOC BRANCH PBUSINESSPLACE Generated Table for View BUKRS
0 J_1BNFDOC BRANCH PBUSINESSPLACE Generated Table for View BRANCH
1 J_1BNFDOC BUKRS T001 Company Codes BUKRS
0 J_1BNFDOC CTE_END_LCT J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation CLIENT
0 J_1BNFDOC CTE_END_LCT J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation COUNTRY
0 J_1BNFDOC CTE_END_LCT J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation TAXJURCODE
1 J_1BNFDOC CTE_STRT_LCT J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation CLIENT
1 J_1BNFDOC CTE_STRT_LCT J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation COUNTRY
1 J_1BNFDOC CTE_STRT_LCT J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation TAXJURCODE
0 J_1BNFDOC DOCREF J_1BNFDOC Nota Fiscal Header MANDT
0 J_1BNFDOC DOCREF J_1BNFDOC Nota Fiscal Header DOCNUM
1 J_1BNFDOC DOCTYP J_1BDOCTYPES Nota Fiscal Document Types MANDT
1 J_1BNFDOC DOCTYP J_1BDOCTYPES Nota Fiscal Document Types DOCTYP
0 J_1BNFDOC FORM J_1BAQ Form MANDT
0 J_1BNFDOC FORM J_1BAQ Form FORM
1 J_1BNFDOC GEWEI T006 Units of Measurement MANDT
1 J_1BNFDOC GEWEI T006 Units of Measurement MSEHI
0 J_1BNFDOC INCO1 TINC Customers: Incoterms INCO1
1 J_1BNFDOC LAND1 T005 Countries MANDT
1 J_1BNFDOC LAND1 T005 Countries LAND1
0 J_1BNFDOC MANDT T000 Clients MANDT
1 J_1BNFDOC NFTYPE J_1BAA Nota Fiscal type NFTYPE
0 J_1BNFDOC PARVW J_1BAD Partner function ID MANDT
0 J_1BNFDOC PARVW J_1BAD Partner function ID PARVW
1 J_1BNFDOC REGIO T005S Taxes: Region (Province) Key LAND1
0 J_1BNFDOC SHPUNT T006 Units of Measurement MANDT
1 J_1BNFDOC TRATY TVTY Packaging Material Types MANDT
1 J_1BNFDOC TRATY TVTY Packaging Material Types TRATY
0 J_1BNFDOC TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 J_1BNFDOC TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
1 J_1BNFDOC UF1 T005S Taxes: Region (Province) Key LAND1
0 J_1BNFDOC UFEMBARQ T005S Taxes: Region (Province) Key LAND1
1 J_1BNFDOC VSTEL TVST Organizational Unit: Shipping Points MANDT
1 J_1BNFDOC VSTEL TVST Organizational Unit: Shipping Points VSTEL
0 J_1BNFDOC WAERK TCURC Currency Codes MANDT
0 J_1BNFDOC WAERK TCURC Currency Codes WAERS