1. Home
  2. Resources
  3. SAP Tables
  4. J_1BNFDOC - Nota Fiscal Header

SAP Table J_1BNFDOC

Nota Fiscal Header

J_1BNFDOC (Nota Fiscal Header) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link J_1BNFDOC to other SAP tables.

J_1BNFDOC table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
DOCNUM Document Number J_1BDOCNUM NUMC 10 0
NFTYPE Nota Fiscal Type J_1BNFTYPE J_1BAA CHAR 2 0
DOCTYP Document type J_1BDOCTYP J_1BDOCTYPES CHAR 1 0
DIRECT Direction of the movement J_1BDIRECT CHAR 1 0
1 Incoming
2 Outgoing
3 Outgoing Returns of Stock Transfers
4 Incoming Returns of Stock Transfers
DOCDAT Document date J_1BDOCDAT DATS 8 0
PSTDAT Posting date J_1BPSTDAT DATS 8 0
CREDAT Create date J_1BCREDAT DATS 8 0
CRETIM Creation time J_1BCRETIM TIMS 6 0
CRENAM Name of the user J_1BCRENAM CHAR 12 0
CHADAT Change date J_1BCHADAT DATS 8 0
CHATIM Change time J_1BCHATIM TIMS 6 0
CHANAM Name of the user J_1BCHANAM CHAR 12 0
FORM Form of Nota Fiscal J_1BFORM J_1BAQ CHAR 4 0
MODEL Model of Nota Fiscal J_1BMODEL NUMC 2 0
10 Conhecimento - Air
11 Conhecimento - Train
09 Conhecimento - Inland Waterways
08 Conhecimento - Road
01 Nota Fiscal - Model 1/1A
06 Nota Fiscal - Eletrical Energy
03 Nota Fiscal - Entrada
21 Nota Fiscal - Comunication Service
22 Nota Fiscal - Telecomunication Service
07 Nota Fiscal - Transportation Service
02 Nota Fiscal - Consumption
04 Nota Fiscal - Production
55 Nota Fiscal - Model 55
57 Conhecimento de Transporte electronico (CT-e) Model 57
SERIES Series J_1BSERIES CHAR 3 0
SUBSER Sub series J_1BSUBSER CHAR 2 0
NFNUM Nota Fiscal Number J_1BNFNUMB NUMC 6 0
ENTRAD Nota Fiscal Entrada J_1BENTRAD CHAR 1 0
NULL Saida
X Entrada
FATURA Fatura J_1BFATURA CHAR 1 0
X Yes
NULL No
ZTERM Terms of Payment Key DZTERM CHAR 4 0
PRINTD Printed J_1BPRINTD CHAR 1 0
X Yes
NULL No
MANUAL Created manually J_1BMANUAL CHAR 1 0
X Created manually (Writer)
NULL Created automatically (Interface)
FOLLOW Follow up activity made J_1BFOLLOW CHAR 1 0
X Yes
NULL No
WAERK SD Document Currency WAERK TCURC CUKY 5 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BRANCH Business Place J_1BBRANC_ J_1BBRANCH CHAR 4 0
PARVW Nota Fiscal Partner Function J_1BPARVW J_1BAD CHAR 2 0
PARID Partner ID (Customer, Vendor, Business Place) J_1BPARID CHAR 10 0
PARXCPDK Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
PARTYP Nota Fiscal Partner Type J_1BPARTYP CHAR 1 0
B Business Place
C Customer
V Vendor
CANCEL Canceled J_1BCANCEL CHAR 1 0
X Yes
NULL No
CANDAT Cancellation Date J_1BCANDAT DATS 8 0
SUBSEQ Follow-On Document Exists J_1BSUBSEQ CHAR 1 0
X Yes
NULL No
DOCREF Reference to NF J_1BDOCREF J_1BNFDOC NUMC 10 0
TRATY Means-of-Transport Type TRATY TVTY CHAR 4 0
TRAID Means of Transport ID TRAID CHAR 20 0
INCO1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
SHPUNT Shipping unit (especie) J_1BSHPUNT T006 UNIT 3 0
ANZPK Total number of packages in delivery ANZPK NUMC 5 0
SHPMRK Mark of the shipping unit J_1BSHPMRK CHAR 20 0
SHPNUM Number of the shipping unit J_1BSHPNUM CHAR 20 0
BRGEW Gross weight BRGEW_15 QUAN 15 3
NTGEW Net weight NTGEW_15 QUAN 15 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
WITHA Total withholding amount of Nota Fiscal J_1BWITHAM CURR 15 2
OBSERVAT Legal Books Mod. 1 + 2: Header text for observations column J_1BLBOBS CHAR 50 0
VSTEL Shipping Point/Receiving Point VSTEL TVST CHAR 4 0
NFDEC Decimal Places in Price Inclusive of ICMS J_1BNFDEC NUMC 1 0
2
NFTOT Total value including all taxes J_1BNFTOT CURR 15 2
AWSYS Logical System LOGSYSTEM CHAR 10 0
PREFNO Service NF-e Number Provided by Prefecture J_1BPREFNO CHAR 20 0
CHECOD Verification Code of Service NF-e J_1BCHECOD CHAR 20 0
NFE Electronic Fiscal Document J_1BNFE CHAR 1 0
X Yes
NULL No
NFENUM Nine-Digit Document Number J_1BNFNUM9 CHAR 9 0
NFESRV Service NF/NF-e J_1BNFESRV CHAR 1 0
X Yes
NULL No
CONTING Document Posted under Contingency J_1BCONTINGENCY CHAR 1 0
X Yes
NULL No
AUTHCOD Protocol Number J_1BNFEAUTHCODE CHAR 15 0
DOCSTAT Document Status J_1BNFEDOCSTATUS CHAR 1 0
NULL Initial
1 Authorized
2 Rejected
3 Denied
XMLVERS XML Version J_1BNFEXMLVERSION DEC 4 2
NFENRNR Number range number NRNR CHAR 2 0
CODE Official Status Code J_1BSTATUSCODE CHAR 3 0
ANRED Title ANRED CHAR 15 0
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
NAME3 Name 3 NAME3_GP CHAR 35 0
NAME4 Name 4 NAME4_GP CHAR 35 0
STRAS House number and street STRAS_GP CHAR 35 0
ORT01 City ORT01_GP CHAR 35 0
ORT02 District ORT02_GP CHAR 35 0
REGIO Region (State, Province, County) REGIO T005S CHAR 3 0
LAND1 Country Key LAND1_GP T005 CHAR 3 0
PSTLZ Postal Code PSTLZ CHAR 10 0
PFACH PO Box PFACH CHAR 10 0
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10 0
SORTL Sort field SORTL CHAR 10 0
SPRAS Language Key SPRAS T002 LANG 1 0
TELF1 Addresses: telephone no. TLFNR CHAR 30 0
TELFX Fax Number TELFX CHAR 31 0
TELTX Teletex number TELTX CHAR 30 0
TELX1 Telex number TELX1 CHAR 30 0
INDUST Customer's CFOP category J_1BINDUS1 CHAR 2 0
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 STKZN CHAR 1 0
X Natural person
NULL Legal person
CGC CNPJ Number J_1BCGC NUMC 14 0
CPF CPF number J_1BCPF NUMC 11 0
STAINS State Tax Number J_1BSTAINS CHAR 18 0
MUNINS Municipal Tax Number J_1BMUNINS CHAR 20 0
TXJCD Tax Jurisdiction TXJCD TTXJ CHAR 15 0
HAUSN House number HAUSN_BAS CHAR 6 0
STOCK Floor STOCK CHAR 6 0
STREET Street AD_STREET CHAR 60 0
HOUSE_NUM1 House Number AD_HSNM1 CHAR 10 0
HOUSE_NUM2 House number supplement AD_HSNM2 CHAR 10 0
AUTHDATE Processing Timestamp - Date J_1BAUTHDATE DATS 8 0
AUTHTIME Processing Timestamp - Time J_1BAUTHTIME TIMS 6 0
BAPI_FLAG Nota Fiscal Created via BAPI J_1BBAPI CHAR 1 0
X Yes
NULL No
SERV_TP Service Type Indicator J_1BCTE_SERV_TP CHAR 1 0
0 Normal
1 Subcontracting
2 Redispatch
3 Intermediate Redispatch
CTE_STRT_LCT Jurisdiction Code of the Point of Origin J_1BCTE_SJCD J_1BTXJUR CHAR 15 0
CTE_END_LCT Jurisdiction Code of the Final Destination J_1BCTE_EJCD J_1BTXJUR CHAR 15 0
MAIN_PRODUCT Main Product Transported J_1BCTE_MAIN_PROD CHAR 60 0
RCVR_WDW Receiver Collection Indicator J_1BCTE_RCVR_WDW CHAR 1 0
X Yes
NULL No
PLN_DT_DLV Estimated Delivery Date J_1BCTE_PLN_DT_DLV DATS 8 0
FTL_IND Full Truck Load Indicator J_1BCTE_FTL_IND CHAR 1 0
X Yes
NULL No
VOL_TRANSP Transported Volume J_1BCTE_VOL_TRANSP DEC 13 3
VOL_UNIT Volume Measure Unit J_1BCTE_VOL_UNIT UNIT 3 0
TOTAL_REF_AMT Total Amount of Goods J_1BCTE_REF_TOT_VAL CURR 15 2
TRANSP_MODE Mode of Transportation J_1BCTE_TRANSPTN_MODE CHAR 1 0
1 Road
2 Air
3 Sea
4 Rail
5 Pipeline
CRE_TIMESTAMP Fiscal Document: UTC Time Stamp of Creation (Short Form) J_1BCRE_TIMESTAMP DEC 15 0
CTE_PARTNER CT-e Partner in Fiscal Document J_1BCTE_TOMALI CHAR 1 0
NULL Not assigned
0 Goods Sender
1 Cargo Dispatcher
2 Cargo Recipient
3 CT-e Destination
CTE_SERV_TAKER CT-e Partner as Service Taker J_1BCTE_SERVICE_TAKER CHAR 1 0
NULL Not relevant
0 Goods Sender
1 Cargo Dispatcher
2 Cargo Recipient
3 CT-e Destination
4 Others
CTE_TYPE CT-e Type J_1BCTTYPE CHAR 1 0
NULL Normal / Complementary value
A Value annulment
S Substitution
AUTOM_INCOMING Indicator for price elements coming from XML J_1B_POSTED_WITH_XML_VALUES CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
DOCNUM_NEXT New Document Number when electronic fiscal doc. is copied J_1BDOCNUM_NEXT NUMC 10 0
DOCNUM_PREV Previous Document Number when electronic fis. doc. is copied J_1BDOCNUM_PREV NUMC 10 0
MUNICIPAL Municipal Fiscal Document J_1BMUNICIPAL CHAR 1 0
X Yes
NULL No
NATOP Operation Nature Description J_1B_OP_NATURE_DESC CHAR 60 0
INDPAG Payment Form Indicator J_1B_PAY_FORM_IND CHAR 1 0
0 Payment in Full
1 Deferred Payment
2 others
DSAIENT Goods Departure or Arrival Date J_1B_DEP_ARR_DATE DATS 8 0
HSAIENT Goods Departure or Arrival Time J_1B_DEP_ARR_TIME TIMS 6 0
CNPJ_BUPLA CNPJ Number of Business Place J_1B_CNPJ_BUPLA NUMC 14 0
IE_BUPLA State Tax Number (IE) of Business Place J_1B_STAINS_BUPLA CHAR 18 0
IEST_BUPLA State Tax Number (IE) of Business Place (SubTrib) J_1B_STAIST_BUPLA CHAR 18 0
IEST_PARTNER State Tax Number of Partner (SubTrib) J_1B_STAIST_PARTNER CHAR 18 0
IM_BUPLA Municipal tax code J_1B_MUNINS_BUPLA CHAR 20 0
CNAE_BUPLA CNAE Code of Business Place J_1B_CNAE_BUPLA CHAR 7 0
CNAE_PARTNER CNAE Code of Partner J_1B_CNAE_PARTNER CHAR 7 0
CRT_BUPLA Tax Regimen Code (CRT) of Business Place J_1B_CRT_BUPLA CHAR 1 0
1 Simples Nacional
2 Simples Nacional � excesso de sublimite da receita bruta
3 Regime Normal (n�o simples)
CRT_PARTNER Tax Regimen Code (CRT) of Partner J_1B_CRT_PARTNER CHAR 1 0
1 Simples Nacional
2 Simples Nacional � excesso de sublimite da receita bruta
3 Regime Normal (n�o simples)
ISUF SUFRAMA Subscription of Partner J_1B_SUFRAMA_CODE CHAR 9 0
MODFRETE Freight Mode J_1B_FREIGHT_MODE CHAR 1 0
0 Due to the issuer
1 Due to the receiver
2 Due to third-parties
9 Without Freight
PLACA Vehicle License Plate J_1B_VEHICLE_LIC_PL CHAR 7 0
UF1 Region of Vehicle J_1B_VEHICLE_UF T005S CHAR 3 0
RNTC National Cargo Carrier Registration (RNTRC) J_1B_NAT_CARGO_CARRIER CHAR 20 0
VAGAO Wagon Identification J_1B_WAGON_ID CHAR 20 0
BALSA Ferryboat Identification J_1B_FERRYBOAD_ID CHAR 20 0
NFAT Invoice Number J_1B_BILLING_NUMBER CHAR 20 0
VORIG Invoice Original Value J_1B_BILLING_ORG_VALUE CURR 15 2
VDESC Invoice Discount Value J_1B_DISCOUNT_VALUE CURR 15 2
VLIQ Invoice Net Value J_1B_BILLING_NET_VALUE CURR 15 2
UFEMBARQ Region of Shipment Place (Export) J_1B_SHIPMENT_PLACE_UF T005S CHAR 3 0
XLOCEMBARQ Shipment Place (Export) J_1B_SHIPMENT_PLACE CHAR 60 0
XNEMP Commitment Note J_1B_COMMITMENT_NOTE CHAR 22 0
SPRAS_BUPLA Language of Business Place J_1B_SPRAS_BUPLA CHAR 1 0
IND_EMIT Indicator of Fiscal Document's Issuer J_1B_FISC_DOC_ISSUER CHAR 1 0
0 Self Issued
1 Issued by Third Party
COD_SIT Status Code of Fiscal Document J_1B_STATUS_FISC_DOC CHAR 2 0
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
SAFRA Harvest Identification J_1B_HARVEST_ID CHAR 9 0
REF_MONTH_YEAR Reference Month and Year J_1B_REF_MONTH_YEAR CHAR 7 0
QTOTMES Sugar Cane: Month Quantity J_1B_SUGAR_QUAN_MONTH DEC 21 10
QTOTANT Sugar Cane: Previous Quantity J_1B_SUGAR_QUAN_PREV DEC 21 10
QTOTGER Sugar Cane: Total Quantity J_1B_SUGAR_QUAN_TOT DEC 21 10
VFOR Sugar Cane: Supply Amount J_1B_SUPPLIES_VALUE CURR 15 2
VTOTDED Sugar Cane: Total Deduction Amount J_1B_TOTAL_DEDUCT_VALUE CURR 15 2
VLIQFOR Sugar Cane: Supply Net Amount J_1B_SUPPLIES_NET_VALUE CURR 15 2

J_1BNFDOC foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
J_1BNFDOC BRANCH J_1BNFDOC MANDT J_1BBRANCH Business Place MANDT
J_1BNFDOC BRANCH J_1BNFDOC BUKRS J_1BBRANCH Business Place BUKRS
J_1BNFDOC BRANCH J_1BNFDOC BRANCH J_1BBRANCH Business Place BRANCH
J_1BNFDOC BUKRS J_1BNFDOC MANDT T001 Company Codes MANDT
J_1BNFDOC BUKRS J_1BNFDOC BUKRS T001 Company Codes BUKRS
J_1BNFDOC CTE_END_LCT SYST MANDT J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation CLIENT
J_1BNFDOC CTE_END_LCT * J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation COUNTRY
J_1BNFDOC CTE_END_LCT J_1BNFDOC CTE_END_LCT J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation TAXJURCODE
J_1BNFDOC CTE_STRT_LCT SYST MANDT J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation CLIENT
J_1BNFDOC CTE_STRT_LCT * J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation COUNTRY
J_1BNFDOC CTE_STRT_LCT J_1BNFDOC CTE_STRT_LCT J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation TAXJURCODE
J_1BNFDOC DOCREF J_1BNFDOC MANDT J_1BNFDOC Nota Fiscal Header MANDT
J_1BNFDOC DOCREF J_1BNFDOC DOCREF J_1BNFDOC Nota Fiscal Header DOCNUM
J_1BNFDOC DOCTYP J_1BNFDOC MANDT J_1BDOCTYPES Nota Fiscal Document Types MANDT
J_1BNFDOC DOCTYP J_1BNFDOC DOCTYP J_1BDOCTYPES Nota Fiscal Document Types DOCTYP
J_1BNFDOC FORM J_1BNFDOC MANDT J_1BAQ Form MANDT
J_1BNFDOC FORM J_1BNFDOC FORM J_1BAQ Form FORM
J_1BNFDOC GEWEI J_1BNFDOC MANDT T006 Units of Measurement MANDT
J_1BNFDOC GEWEI J_1BNFDOC GEWEI T006 Units of Measurement MSEHI
J_1BNFDOC INCO1 J_1BNFDOC MANDT TINC Customers: Incoterms MANDT
J_1BNFDOC INCO1 J_1BNFDOC INCO1 TINC Customers: Incoterms INCO1
J_1BNFDOC LAND1 SYST MANDT T005 Countries MANDT
J_1BNFDOC LAND1 J_1BNFDOC LAND1 T005 Countries LAND1
J_1BNFDOC MANDT J_1BNFDOC MANDT T000 Clients MANDT
J_1BNFDOC NFTYPE J_1BNFDOC MANDT J_1BAA Nota Fiscal type MANDT
J_1BNFDOC NFTYPE J_1BNFDOC NFTYPE J_1BAA Nota Fiscal type NFTYPE
J_1BNFDOC PARVW J_1BNFDOC MANDT J_1BAD Partner function ID MANDT
J_1BNFDOC PARVW J_1BNFDOC PARVW J_1BAD Partner function ID PARVW
J_1BNFDOC REGIO J_1BNFDOC REGIO T005S Taxes: Region (Province) Key BLAND
J_1BNFDOC REGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
J_1BNFDOC REGIO J_1BNFDOC LAND1 T005S Taxes: Region (Province) Key LAND1
J_1BNFDOC SHPUNT J_1BNFDOC MANDT T006 Units of Measurement MANDT
J_1BNFDOC SHPUNT J_1BNFDOC SHPUNT T006 Units of Measurement MSEHI
J_1BNFDOC SPRAS J_1BNFDOC SPRAS T002 Language Keys (Component BC-I18) SPRAS
J_1BNFDOC TRATY J_1BNFDOC TRATY TVTY Packaging Material Types TRATY
J_1BNFDOC TRATY J_1BNFDOC MANDT TVTY Packaging Material Types MANDT
J_1BNFDOC TXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
J_1BNFDOC TXJCD J_1BNFDOC TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
J_1BNFDOC TXJCD SYST MANDT TTXJ Check Table for Tax Jurisdiction MANDT
J_1BNFDOC UF1 SYST MANDT T005S Taxes: Region (Province) Key MANDT
J_1BNFDOC UF1 'BR' T005S Taxes: Region (Province) Key LAND1
J_1BNFDOC UF1 J_1BNFDOC UF1 T005S Taxes: Region (Province) Key BLAND
J_1BNFDOC UFEMBARQ 'BR' T005S Taxes: Region (Province) Key LAND1
J_1BNFDOC UFEMBARQ J_1BNFDOC UFEMBARQ T005S Taxes: Region (Province) Key BLAND
J_1BNFDOC UFEMBARQ SYST MANDT T005S Taxes: Region (Province) Key MANDT
J_1BNFDOC VSTEL J_1BNFDOC MANDT TVST Organizational Unit: Shipping Points MANDT
J_1BNFDOC VSTEL J_1BNFDOC VSTEL TVST Organizational Unit: Shipping Points VSTEL
J_1BNFDOC WAERK J_1BNFDOC MANDT TCURC Currency Codes MANDT
J_1BNFDOC WAERK J_1BNFDOC WAERK TCURC Currency Codes WAERS