SAP ABAP Table J_1BNFDOC (Nota Fiscal Header)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOC-BR (Application Component) Brazil
     ⤷ J1BA (Package) Localization Brazil
Basic Data
Table Category TRANSP    Transparent table 
Transparent table J_1BNFDOC   Table Relationship Diagram
Short Description Nota Fiscal Header    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 DOCNUM J_1BDOCNUM J_1BDOCNUM NUMC 10   0   Document Number  
3 NFTYPE J_1BNFTYPE J_1BNFTYPE CHAR 2   0   Nota Fiscal Type J_1BAA
4 DOCTYP J_1BDOCTYP J_1BDOCTYP CHAR 1   0   Document type J_1BDOCTYPES
5 DIRECT J_1BDIRECT J_1BDIRECT CHAR 1   0   Direction of the movement  
6 DOCDAT J_1BDOCDAT DATUM DATS 8   0   Document date  
7 PSTDAT J_1BPSTDAT DATUM DATS 8   0   Posting date  
8 CREDAT J_1BCREDAT DATUM DATS 8   0   Create date  
9 CRETIM J_1BCRETIM UZEIT TIMS 6   0   Creation time  
10 CRENAM J_1BCRENAM USNAM CHAR 12   0   Name of the user  
11 CHADAT J_1BCHADAT DATUM DATS 8   0   Change date  
12 CHATIM J_1BCHATIM UZEIT TIMS 6   0   Change time  
13 CHANAM J_1BCHANAM USNAM CHAR 12   0   Name of the user  
14 FORM J_1BFORM J_1BFORM CHAR 4   0   Form of Nota Fiscal J_1BAQ
15 MODEL J_1BMODEL J_1BMODEL NUMC 2   0   Model of Nota Fiscal  
16 SERIES J_1BSERIES J_1BSERIES CHAR 3   0   Series  
17 SUBSER J_1BSUBSER J_1BSUBSER CHAR 2   0   Sub series  
18 NFNUM J_1BNFNUMB J_1BNFNUMB NUMC 6   0   Nota Fiscal Number  
19 ENTRAD J_1BENTRAD J_1BENTRAD CHAR 1   0   Nota Fiscal Entrada  
20 FATURA J_1BFATURA XFELD CHAR 1   0   Fatura  
21 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
22 PRINTD J_1BPRINTD XFELD CHAR 1   0   Printed  
23 MANUAL J_1BMANUAL J_1BMANUAL CHAR 1   0   Created manually  
24 FOLLOW J_1BFOLLOW XFELD CHAR 1   0   Follow up activity made  
25 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
26 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
27 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
28 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
29 BRANCH J_1BBRANC_ J_1BBRANCH CHAR 4   0   Business Place J_1BBRANCH
30 PARVW J_1BPARVW J_1BPARVW CHAR 2   0   Nota Fiscal Partner Function J_1BAD
31 PARID J_1BPARID J_1BPARID CHAR 10   0   Partner ID (Customer, Vendor, Business Place)  
32 PARXCPDK XCPDK XFELD CHAR 1   0   Indicator: Is the account a one-time account?  
33 PARTYP J_1BPARTYP J_1BPARTYP CHAR 1   0   Nota Fiscal Partner Type  
34 CANCEL J_1BCANCEL XFELD CHAR 1   0   Canceled  
35 CANDAT J_1BCANDAT DATUM DATS 8   0   Cancellation Date  
36 SUBSEQ J_1BSUBSEQ XFELD CHAR 1   0   Follow-On Document Exists  
37 DOCREF J_1BDOCREF J_1BDOCNUM NUMC 10   0   Reference to NF J_1BNFDOC
38 TRATY TRATY TRATY CHAR 4   0   Means-of-Transport Type TVTY
39 TRAID TRAID TRAID CHAR 20   0   Means-of-transport ID  
40 INCO1 INCO1 INCO1 CHAR 3   0   Incoterms (part 1) TINC
41 INCO2 INCO2 INCO2 CHAR 28   0   Incoterms (part 2)  
42 SHPUNT J_1BSHPUNT MEINS UNIT 3   0   Shipping unit (especie) T006
43 ANZPK ANZPK ANZPK NUMC 5   0   Total number of packages in delivery  
44 SHPMRK J_1BSHPMRK TEXT20 CHAR 20   0   Mark of the shipping unit  
45 SHPNUM J_1BSHPNUM TEXT20 CHAR 20   0   Number of the shipping unit  
46 BRGEW BRGEW_15 MENG15 QUAN 15   3   Gross weight  
47 NTGEW NTGEW_15 MENG15 QUAN 15   3   Net weight  
48 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit T006
49 ZFBDT DZFBDT DATUM DATS 8   0   Baseline date for due date calculation  
50 WITHA J_1BWITHAM WERT8 CURR 15   2   Total withholding amount of Nota Fiscal  
51 OBSERVAT J_1BLBOBS J_1BLBOBS CHAR 50   0   Legal Books Mod. 1 + 2: Header text for observations column  
52 VSTEL VSTEL VSTEL CHAR 4   0   Shipping Point/Receiving Point TVST
53 NFDEC J_1BNFDEC J_1BNFDEC NUMC 1   0   Decimal Places in Price Inclusive of ICMS  
54 NFTOT J_1BNFTOT WERTV8 CURR 15   2   Total value including all taxes  
55 AWSYS LOGSYSTEM LOGSYS CHAR 10   0   Logical System *
56 .INCLUDE       0   0   NF-e Header Data  
57 PREFNO J_1BPREFNO J_1BPREFNO CHAR 20   0   Service NF-e Number Provided by Prefecture  
58 CHECOD J_1BCHECOD J_1BCHECOD CHAR 20   0   Verification Code of Service NF-e  
59 NFE J_1BNFE XFELD CHAR 1   0   Electronic Fiscal Document  
60 NFENUM J_1BNFNUM9 J_1BNFNUM9 CHAR 9   0   Nine-Digit Document Number  
61 NFESRV J_1BNFESRV XFELD CHAR 1   0   Service NF/NF-e  
62 CONTING J_1BCONTINGENCY XFELD CHAR 1   0   Document Posted under Contingency  
63 AUTHCOD J_1BNFEAUTHCODE J_1BNFEAUTHCODE CHAR 15   0   Protocol Number  
64 DOCSTAT J_1BNFEDOCSTATUS J_1BNFEDOCSTATUS CHAR 1   0   Document Status  
65 XMLVERS J_1BNFEXMLVERSION J_1BNFEXMLVERSION DEC 4   2   XML Version  
66 NFENRNR NRNR CHAR2 CHAR 2   0   Number range number  
67 CODE J_1BSTATUSCODE J_1BSTATUSCODE CHAR 3   0   Official Status Code *
68 .INCLUDE       0   0   Interface: partner name and address  
69 ANRED ANRED TEXT15 CHAR 15   0   Title  
70 NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
71 NAME2 NAME2_GP NAME CHAR 35   0   Name 2  
72 NAME3 NAME3_GP NAME CHAR 35   0   Name 3  
73 NAME4 NAME4_GP NAME CHAR 35   0   Name 4  
74 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
75 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
76 ORT02 ORT02_GP TEXT35 CHAR 35   0   District  
77 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
78 LAND1 LAND1_GP LAND1 CHAR 3   0   Country Key T005
79 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
80 PFACH PFACH PFACH CHAR 10   0   PO Box  
81 PSTL2 PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
82 SORTL SORTL CHAR10 CHAR 10   0   Sort field  
83 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
84 TELF1 TLFNR TEXT30 CHAR 30   0   Addresses: telephone no.  
85 TELFX TELFX TEXT31 CHAR 31   0   Fax Number  
86 TELTX TELTX TEXT30 CHAR 30   0   Teletex number  
87 TELX1 TELX1 TEXT30 CHAR 30   0   Telex number  
88 INDUST J_1BINDUS1 J_1BINDUS1 CHAR 2   0   Customer's CFOP category  
89 STKZN STKZN STKZN CHAR 1   0   Natural Person  
90 CGC J_1BCGC J_1BCGC NUMC 14   0   CNPJ Number  
91 CPF J_1BCPF J_1BCPF NUMC 11   0   CPF number  
92 STAINS J_1BSTAINS J_1BSTAINS CHAR 18   0   State Tax Number  
93 MUNINS J_1BMUNINS J_1BMUNINS CHAR 20   0   Municipal Tax Number  
94 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
95 HAUSN HAUSN_BAS CHAR6 CHAR 6   0   House number  
96 STOCK STOCK STOCK CHAR 6   0   Floor  
97 STREET AD_STREET TEXT60 CHAR 60   0   Street  
98 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
99 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
100 AUTHDATE J_1BAUTHDATE DATUM DATS 8   0   Processing Timestamp - Date  
101 AUTHTIME J_1BAUTHTIME UZEIT TIMS 6   0   Processing Timestamp - Time  
102 BAPI_FLAG J_1BBAPI XFELD CHAR 1   0   Nota Fiscal Created via BAPI  
103 .INCLUDE       0   0   CT-e Header relevant information  
104 SERV_TP J_1BCTE_SERV_TP J_1BCTE_SERV_TP CHAR 1   0   Service Type Indicator  
105 CTE_STRT_LCT J_1BCTE_SJCD J_1BTXJCD CHAR 15   0   Jurisdiction Code of the Point of Origin J_1BTXJUR
106 CTE_END_LCT J_1BCTE_EJCD J_1BTXJCD CHAR 15   0   Jurisdiction Code of the Final Destination J_1BTXJUR
107 MAIN_PRODUCT J_1BCTE_MAIN_PROD CHAR60 CHAR 60   0   Main Product Transported  
108 RCVR_WDW J_1BCTE_RCVR_WDW XFELD CHAR 1   0   Receiver Collection Indicator  
109 PLN_DT_DLV J_1BCTE_PLN_DT_DLV DATUM DATS 8   0   Estimated Delivery Date  
110 FTL_IND J_1BCTE_FTL_IND XFELD CHAR 1   0   Full Truck Load Indicator  
111 VOL_TRANSP J_1BCTE_VOL_TRANSP   DEC 13   3   Transported Volume  
112 VOL_UNIT J_1BCTE_VOL_UNIT MEINS UNIT 3   0   Volume Measure Unit *
113 TOTAL_REF_AMT J_1BCTE_REF_TOT_VAL WERT8 CURR 15   2   Total Amount of Goods  
114 TRANSP_MODE J_1BCTE_TRANSPTN_MODE J_1BCTE_TRANSPTN_MODE CHAR 1   0   Mode of Transportation  
115 CRE_TIMESTAMP J_1BCRE_TIMESTAMP TZNTSTMPS DEC 15   0   Fiscal Document: UTC Time Stamp of Creation (Short Form)  
116 CTE_PARTNER J_1BCTE_TOMALI J_1BCTE_TOMALI CHAR 1   0   CT-e Partner in Fiscal Document  
117 CTE_SERV_TAKER J_1BCTE_SERVICE_TAKER J_1BCTE_SERVICE_TAKER CHAR 1   0   CT-e Partner as Service Taker  
118 CTE_TYPE J_1BCTTYPE J_1BCTTYPE CHAR 1   0   CT-e Type  
119 AUTOM_INCOMING J_1B_POSTED_WITH_XML_VALUES FLAG CHAR 1   0   Indicator for price elements coming from XML  
120 DOCNUM_NEXT J_1BDOCNUM_NEXT J_1BDOCNUM NUMC 10   0   New Document Number when electronic fiscal doc. is copied *
121 DOCNUM_PREV J_1BDOCNUM_PREV J_1BDOCNUM NUMC 10   0   Previous Document Number when electronic fis. doc. is copied *
122 MUNICIPAL J_1BMUNICIPAL XFELD CHAR 1   0   Municipal Fiscal Document  
123 .INCLUDE       0   0   Nota Fiscal Header Additional Fields  
124 NATOP J_1B_OP_NATURE_DESC TEXT60 CHAR 60   0   Operation Nature Description  
125 INDPAG J_1B_PAY_FORM_IND J_1B_PAY_FORM_IND CHAR 1   0   Payment Form Indicator  
126 DSAIENT J_1B_DEP_ARR_DATE DATUM DATS 8   0   Goods Departure or Arrival Date  
127 HSAIENT J_1B_DEP_ARR_TIME UZEIT TIMS 6   0   Goods Departure or Arrival Time  
128 CNPJ_BUPLA J_1B_CNPJ_BUPLA J_1BCGC NUMC 14   0   CNPJ Number of Business Place  
129 IE_BUPLA J_1B_STAINS_BUPLA J_1BSTAINS CHAR 18   0   State Tax Number (IE) of Business Place  
130 IEST_BUPLA J_1B_STAIST_BUPLA J_1BSTAINS CHAR 18   0   State Tax Number (IE) of Business Place (SubTrib)  
131 IEST_PARTNER J_1B_STAIST_PARTNER J_1BSTAINS CHAR 18   0   State Tax Number of Partner (SubTrib)  
132 IM_BUPLA J_1B_MUNINS_BUPLA J_1BMUNINS CHAR 20   0   Municipal tax code  
133 CNAE_BUPLA J_1B_CNAE_BUPLA CHAR7 CHAR 7   0   CNAE Code of Business Place  
134 CNAE_PARTNER J_1B_CNAE_PARTNER CHAR7 CHAR 7   0   CNAE Code of Partner  
135 CRT_BUPLA J_1B_CRT_BUPLA J_1BCRTN CHAR 1   0   Tax Regimen Code (CRT) of Business Place  
136 CRT_PARTNER J_1B_CRT_PARTNER J_1BCRTN CHAR 1   0   Tax Regimen Code (CRT) of Partner  
137 ISUF J_1B_SUFRAMA_CODE J_1BSUFRAMA CHAR 9   0   SUFRAMA Subscription of Partner  
138 MODFRETE J_1B_FREIGHT_MODE J_1B_FREIGHT_MODE CHAR 1   0   Freight Mode  
139 PLACA J_1B_VEHICLE_LIC_PL CHAR7 CHAR 7   0   Vehicle License Plate  
140 UF1 J_1B_VEHICLE_UF REGIO CHAR 3   0   Region of Vehicle T005S
141 RNTC J_1B_NAT_CARGO_CARRIER CHAR20 CHAR 20   0   National Cargo Carrier Registration (RNTRC)  
142 VAGAO J_1B_WAGON_ID CHAR20 CHAR 20   0   Wagon Identification  
143 BALSA J_1B_FERRYBOAD_ID CHAR20 CHAR 20   0   Ferryboat Identification  
144 NFAT J_1B_BILLING_NUMBER CHAR20 CHAR 20   0   Invoice Number  
145 VORIG J_1B_BILLING_ORG_VALUE WERT15 CURR 15   2   Invoice Original Value  
146 VDESC J_1B_DISCOUNT_VALUE WERT15 CURR 15   2   Invoice Discount Value  
147 VLIQ J_1B_BILLING_NET_VALUE WERT15 CURR 15   2   Invoice Net Value  
148 UFEMBARQ J_1B_SHIPMENT_PLACE_UF REGIO CHAR 3   0   Region of Shipment Place (Export) T005S
149 XLOCEMBARQ J_1B_SHIPMENT_PLACE CHAR60 CHAR 60   0   Shipment Place (Export)  
150 XNEMP J_1B_COMMITMENT_NOTE CHAR22 CHAR 22   0   Commitment Note  
151 SPRAS_BUPLA J_1B_SPRAS_BUPLA CHAR1 CHAR 1   0   Language of Business Place  
152 IND_EMIT J_1B_FISC_DOC_ISSUER J_1B_FISC_DOC_ISSUER CHAR 1   0   Indicator of Fiscal Document's Issuer  
153 COD_SIT J_1B_STATUS_FISC_DOC J_1B_STATUS_FISC_DOC CHAR 2   0   Status Code of Fiscal Document  
154 .INCLUDE       0   0   Nota Fiscal: Additional fields for Header (Sugar Cane)  
155 SAFRA J_1B_HARVEST_ID CHAR9 CHAR 9   0   Harvest Identification  
156 REF_MONTH_YEAR J_1B_REF_MONTH_YEAR CHAR7 CHAR 7   0   Reference Month and Year  
157 QTOTMES J_1B_SUGAR_QUAN_MONTH   DEC 21   10   Sugar Cane: Month Quantity  
158 QTOTANT J_1B_SUGAR_QUAN_PREV   DEC 21   10   Sugar Cane: Previous Quantity  
159 QTOTGER J_1B_SUGAR_QUAN_TOT   DEC 21   10   Sugar Cane: Total Quantity  
160 VFOR J_1B_SUPPLIES_VALUE WERT15 CURR 15   2   Sugar Cane: Supply Amount  
161 VTOTDED J_1B_TOTAL_DEDUCT_VALUE WERT15 CURR 15   2   Sugar Cane: Total Deduction Amount  
162 VLIQFOR J_1B_SUPPLIES_NET_VALUE WERT15 CURR 15   2   Sugar Cane: Supply Net Amount  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 J_1BNFDOC BRANCH J_1BBRANCH BRANCH KEY 1 CN
2 J_1BNFDOC BUKRS T001 BUKRS KEY 1 CN
3 J_1BNFDOC CTE_END_LCT J_1BTXJUR TAXJURCODE    
4 J_1BNFDOC CTE_STRT_LCT J_1BTXJUR TAXJURCODE REF C CN
5 J_1BNFDOC DOCREF J_1BNFDOC DOCNUM KEY 1 CN
6 J_1BNFDOC DOCTYP J_1BDOCTYPES DOCTYP KEY 1 CN
7 J_1BNFDOC FORM J_1BAQ FORM KEY 1 CN
8 J_1BNFDOC GEWEI T006 MSEHI KEY 1 CN
9 J_1BNFDOC INCO1 TINC INCO1 KEY 1 CN
10 J_1BNFDOC LAND1 T005 LAND1    
11 J_1BNFDOC MANDT T000 MANDT KEY 1 CN
12 J_1BNFDOC NFTYPE J_1BAA NFTYPE KEY 1 CN
13 J_1BNFDOC PARVW J_1BAD PARVW KEY 1 CN
14 J_1BNFDOC REGIO T005S BLAND    
15 J_1BNFDOC SHPUNT T006 MSEHI 1 CN
16 J_1BNFDOC SPRAS T002 SPRAS    
17 J_1BNFDOC TRATY TVTY TRATY 1 CN
18 J_1BNFDOC TXJCD TTXJ TXJCD REF C CN
19 J_1BNFDOC UF1 T005S BLAND    
20 J_1BNFDOC UFEMBARQ T005S BLAND    
21 J_1BNFDOC VSTEL TVST VSTEL KEY 1 CN
22 J_1BNFDOC WAERK TCURC WAERS KEY 1 CN
History
Last changed by/on SAP  20140121 
SAP Release Created in