SAP ABAP Table J1B_NF_XML_HEADER (Nota Fiscal Eletronica / NF-e Data - HEADER (1:1))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-LOC-BR (Application Component) Brazil
⤷ J1BA (Package) Localization Brazil
⤷ CRM-LOC-BR (Application Component) Brazil
⤷ J1BA (Package) Localization Brazil
Basic Data
Table Category | INTTAB | Structure |
Structure | J1B_NF_XML_HEADER | Table Relationship Diagram |
Short Description | Nota Fiscal Eletronica / NF-e Data - HEADER (1:1) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | DOCNUM | J_1BDOCNUM | J_1BDOCNUM | NUMC | 10 | 0 | Document Number | * | |
2 | LOGSYS | LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
3 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
4 | .INCLUDE | 0 | 0 | NF-e Block A / Layout (Tag intNFe) | |||||
5 | VERSION | DEC | 4 | 2 | |||||
6 | ID | CHAR | 44 | 0 | |||||
7 | .INCLUDE | 0 | 0 | NF-e Block B / Identification (Tag: Ide) | |||||
8 | CUF | CHAR | 2 | 0 | |||||
9 | CNF | NUMC | 9 | 0 | |||||
10 | NATOP | CHAR | 60 | 0 | |||||
11 | INDPAG | NUMC | 1 | 0 | |||||
12 | MOD | J_1BMODEL | J_1BMODEL | NUMC | 2 | 0 | Model of Nota Fiscal | ||
13 | SERIE | J_1BSERIES | J_1BSERIES | CHAR | 3 | 0 | Series | ||
14 | NNF | NUMC | 9 | 0 | |||||
15 | DEMI | J_1BDOCDAT | DATUM | DATS | 8 | 0 | Document date | ||
16 | DSAIENT | DATS | 8 | 0 | |||||
17 | TPNF | J_1BDIRECT | J_1BDIRECT | CHAR | 1 | 0 | Direction of the movement | ||
18 | CMUNFG | CHAR | 7 | 0 | |||||
19 | TPIMP | CHAR | 1 | 0 | |||||
20 | TPEMIS | J_1BNFE_TPEMIS | J_1BNFE_TPEMIS | CHAR | 1 | 0 | Issuing Type | ||
21 | CDV | CHAR | 1 | 0 | |||||
22 | TPAMB | J_1BNFETPAMB | J_1BNFETPAMB | CHAR | 1 | 0 | Type of Environment (Test or Production) | ||
23 | FINNFE | CHAR | 1 | 0 | |||||
24 | PROCEMI | J_1BNFEPROCEMI | J_1BNFEPROCEMI | CHAR | 1 | 0 | Issuing Process Identifier | ||
25 | VERPROC | J_1BNFEVERPROC | J_1BNFEVERPROC | CHAR | 20 | 0 | Application Version | ||
26 | ALTER_REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
27 | .INCLUDE | 0 | 0 | NF-e Block C / Issuer identification / Tag: emit | |||||
28 | C_CNPJ | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
29 | C_XNOME | CHAR | 60 | 0 | |||||
30 | C_XFANT | NAME2 | TEXT30 | CHAR | 30 | 0 | Name 2 | ||
31 | .INCLUDE | 0 | 0 | NF-e Block C1 / Issuer identification / Tag: enderEmit | |||||
32 | C1_XLGR | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
33 | C1_NRO | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
34 | C1_XCPL | CHAR | 60 | 0 | |||||
35 | C1_XBAIRRO | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
36 | C1_CMUN | CHAR | 7 | 0 | |||||
37 | C1_XMUN | CHAR | 60 | 0 | |||||
38 | C1_UF | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
39 | C1_CEP | PSTLZ_BAS | PSTLZ | CHAR | 10 | 0 | Postal code | ||
40 | C1_CPAIS | CHAR | 4 | 0 | |||||
41 | C1_XPAIS | LANDX | TEXT15 | CHAR | 15 | 0 | Country Name | ||
42 | C1_FONE | AD_TLNMBR1 | CHAR30 | CHAR | 30 | 0 | First telephone no.: dialling code+number | ||
43 | C1_IE | J_1BSTAINS | J_1BSTAINS | CHAR | 18 | 0 | State Tax Number | ||
44 | C1_IEST | J_1BSTAIST | J_1BSTAINS | CHAR | 18 | 0 | State Tax Number for Substituição Tributária | ||
45 | C1_IM | J_1BMUNINS | J_1BMUNINS | CHAR | 20 | 0 | Municipal Tax Number | ||
46 | C1_CNAE | CHAR | 7 | 0 | |||||
47 | .INCLUDE | 0 | 0 | NF-e Block D / Authorities data (blank from ERP) Tag avulsa | |||||
48 | AVULSA | CHAR | 1 | 0 | |||||
49 | D_CNPJ | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
50 | D_XORGAO | CHAR | 60 | 0 | |||||
51 | D_MATR | CHAR | 60 | 0 | |||||
52 | D_XAGENTE | CHAR | 60 | 0 | |||||
53 | D_FONE | AD_TLNMBR1 | CHAR30 | CHAR | 30 | 0 | First telephone no.: dialling code+number | ||
54 | D_UF | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
55 | D_NDAR | CHAR | 60 | 0 | |||||
56 | D_DEMI | DATS | 8 | 0 | |||||
57 | D_VDAR | DEC | 13 | 0 | |||||
58 | D_REPEMI | CHAR | 60 | 0 | |||||
59 | D_PAG | CHAR | 10 | 0 | |||||
60 | .INCLUDE | 0 | 0 | NF-e Block E / Ident.ship-from / ship-to / Tag: dest | |||||
61 | E_CNPJ | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
62 | E_CPF | STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
63 | E_XNOME | CHAR | 60 | 0 | |||||
64 | .INCLUDE | 0 | 0 | NF-e Block E1 / Ident.ship-from / ship-to / Tag: enderDest | |||||
65 | E1_XLGR | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
66 | E1_NRO | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
67 | E1_XCPL | CHAR | 60 | 0 | |||||
68 | E1_XBAIRRO | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
69 | E1_CMUN | CHAR | 7 | 0 | |||||
70 | E1_XMUN | CHAR | 60 | 0 | |||||
71 | E1_UF | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
72 | E1_CEP | PSTLZ_BAS | PSTLZ | CHAR | 10 | 0 | Postal code | ||
73 | E1_CPAIS | CHAR | 4 | 0 | |||||
74 | E1_XPAIS | LANDX | TEXT15 | CHAR | 15 | 0 | Country Name | ||
75 | E1_FONE | AD_TLNMBR1 | CHAR30 | CHAR | 30 | 0 | First telephone no.: dialling code+number | ||
76 | E1_IE | J_1BSTAINS | J_1BSTAINS | CHAR | 18 | 0 | State Tax Number | ||
77 | E1_ISUF | CHAR | 9 | 0 | |||||
78 | .INCLUDE | 0 | 0 | NF-e Block F / Ident.different ship from / Tag: retirada | |||||
79 | F_RETIRADA | CHAR | 60 | 0 | |||||
80 | F_CNPJ | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
81 | F_XLGR | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
82 | F_NRO | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
83 | F_XCPL | CHAR | 60 | 0 | |||||
84 | F_XBAIRRO | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
85 | F_CMUN | CHAR | 7 | 0 | |||||
86 | F_XMUN | CHAR | 60 | 0 | |||||
87 | F_UF | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
88 | .INCLUDE | 0 | 0 | NF-e Block G / Different ship to location / Tag entrega | |||||
89 | ENTREGA | CHAR | 1 | 0 | |||||
90 | G_CNPJ | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
91 | G_XLGR | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
92 | G_NRO | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
93 | G_XCPL | CHAR | 60 | 0 | |||||
94 | G_XBAIRRO | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
95 | G_CMUN | CHAR | 7 | 0 | |||||
96 | G_XMUN | CHAR | 60 | 0 | |||||
97 | G_UF | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
98 | .INCLUDE | 0 | 0 | NF-e Block S / Total values / Tag: Total | |||||
99 | .INCLUDE | 0 | 0 | NF-e Block S1 /Total val taxes excluding ISS / Tag: ICMSTot | |||||
100 | S1_VBC | DEC | 15 | 2 | |||||
101 | S1_VICMS | DEC | 15 | 2 | |||||
102 | S1_VBCST | DEC | 15 | 2 | |||||
103 | S1_VST | DEC | 15 | 2 | |||||
104 | S1_VPROD | DEC | 15 | 2 | |||||
105 | S1_VFRETE | DEC | 15 | 2 | |||||
106 | S1_VSEG | DEC | 15 | 2 | |||||
107 | S1_VDESC | DEC | 15 | 2 | |||||
108 | S1_VII | DEC | 15 | 2 | |||||
109 | S1_VIPI | DEC | 15 | 2 | |||||
110 | S1_VPIS | DEC | 15 | 2 | |||||
111 | S1_VCOFINS | DEC | 15 | 2 | |||||
112 | S1_VOUTRO | DEC | 15 | 2 | |||||
113 | S1_VNF | DEC | 15 | 2 | |||||
114 | .INCLUDE | 0 | 0 | NF-e Block S2 / Total values ISS / Tag: ISSQNTot | |||||
115 | S2_VSERV | DEC | 15 | 2 | |||||
116 | S2_VBC | DEC | 15 | 2 | |||||
117 | S2_VISS | DEC | 15 | 2 | |||||
118 | S2_VPISISS | DEC | 15 | 2 | |||||
119 | S2_VCOFINSISS | DEC | 15 | 2 | |||||
120 | .INCLUDE | 0 | 0 | NF-e Block S3 / Total values WHT / Tag: retTrib | |||||
121 | S3_VRETPIS | J_1BTAXVAL | J_1BTAXVAL | CURR | 15 | 2 | Tax value | ||
122 | S3_VRETCOFINS | J_1BTAXVAL | J_1BTAXVAL | CURR | 15 | 2 | Tax value | ||
123 | S3_VRETCSLL | J_1BTAXVAL | J_1BTAXVAL | CURR | 15 | 2 | Tax value | ||
124 | S3_VBCIRRF | J_1BBASE | J_1BBASE | CURR | 15 | 2 | Base amount | ||
125 | S3_VIRRF | J_1BTAXVAL | J_1BTAXVAL | CURR | 15 | 2 | Tax value | ||
126 | S3_VBCRETPREV | J_1BBASE | J_1BBASE | CURR | 15 | 2 | Base amount | ||
127 | S3_VRETPREV | J_1BTAXVAL | J_1BTAXVAL | CURR | 15 | 2 | Tax value | ||
128 | .INCLUDE | 0 | 0 | NF-e Block T / Transport / Tag: Transp | |||||
129 | T_MODFRETE | CHAR | 1 | 0 | |||||
130 | .INCLUDE | 0 | 0 | NF-e Block T1 / Transport Carrier / Tag: Transporta | |||||
131 | T1_CNPJ | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
132 | T1_CPF | STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
133 | T1_XNOME | CHAR | 60 | 0 | |||||
134 | T1_IE | J_1BSTAINS | J_1BSTAINS | CHAR | 18 | 0 | State Tax Number | ||
135 | T1_XEND | CHAR | 60 | 0 | |||||
136 | T1_XMUN | CHAR | 60 | 0 | |||||
137 | T1_UF | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
138 | .INCLUDE | 0 | 0 | NF-e Block T5 / Transport Carrier / Tag: retTransp | |||||
139 | T5_VSERV | J_1BNFTOT | WERTV8 | CURR | 15 | 2 | Total value including all taxes | ||
140 | T5_VBCRET | J_1BBASE | J_1BBASE | CURR | 15 | 2 | Base amount | ||
141 | T5_PICMSRET | J_1BTXRATE | J_1BTXRATE | DEC | 6 | 2 | Tax Rate | ||
142 | T5_VICMSRET | J_1BTAXVAL | J_1BTAXVAL | CURR | 15 | 2 | Tax value | ||
143 | T5_CFOP | J_1BCFOP | J_1BCFOP | CHAR | 10 | 0 | CFOP code and extension | * | |
144 | T5_CMUNFG | CHAR | 7 | 0 | |||||
145 | .INCLUDE | 0 | 0 | NF-e Block T2 / Transport Carrier Vehicle /Tag: veicTransp | |||||
146 | T2_PLACA | CHAR | 8 | 0 | |||||
147 | T2_UF1 | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
148 | T2_RNTC | CHAR | 20 | 0 | |||||
149 | .INCLUDE | 0 | 0 | NF-e Block T3 / Transport Carrier Trailer / Tag: Reboque | |||||
150 | T3_PLACA | CHAR | 8 | 0 | |||||
151 | T3_UF1 | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
152 | T3_RNTC | CHAR | 20 | 0 | |||||
153 | .INCLUDE | 0 | 0 | NF-e Block T4/ Transport Carrier Volumes (VOL))/Tag: vol | |||||
154 | T4_QVOL | DEC | 15 | 0 | |||||
155 | T4_ESP | CHAR | 60 | 0 | |||||
156 | T4_MARCA | CHAR | 60 | 0 | |||||
157 | T4_NVOL | CHAR | 60 | 0 | |||||
158 | T4_PESOL | DEC | 15 | 3 | |||||
159 | T4_PESOB | DEC | 15 | 3 | |||||
160 | T4_NLACRE | CHAR | 60 | 0 | |||||
161 | .INCLUDE | 0 | 0 | NF-e Block U / Cobrança / Tag: cobr | |||||
162 | COBR | CHAR | 1 | 0 | |||||
163 | .INCLUDE | 0 | 0 | NF-e Block U1 / Cobrança fatura / Tag: fat | |||||
164 | NFAT | NUMC | 10 | 0 | |||||
165 | VORIG | DEC | 15 | 2 | |||||
166 | VDESC | DEC | 15 | 2 | |||||
167 | VLIQ | DEC | 15 | 2 | |||||
168 | .INCLUDE | 0 | 0 | NF-e Block U2 / Cobrança duplicata / Tag:dup | |||||
169 | NDUP | NUMC | 10 | 0 | |||||
170 | DVENC | DATS | 8 | 0 | |||||
171 | VDUP | DEC | 15 | 2 | |||||
172 | NDUP_NEW | CHAR | 60 | 0 | |||||
173 | .INCLUDE | 0 | 0 | NF-e Block V / Additional Information / Tag: infAdic | |||||
174 | INFADFISCO | CHAR | 256 | 0 | |||||
175 | INFCOMP | STRG | 0 | 0 | |||||
176 | .INCLUDE | 0 | 0 | NF-e Block W / Impor t / Export / Tag: COMEX | |||||
177 | COMEX | CHAR | 1 | 0 | |||||
178 | .INCLUDE | 0 | 0 | NF-e Block W / Export / Tag: Exporta | |||||
179 | UFEMBARQ | CHAR | 2 | 0 | |||||
180 | XLOCEMBARQ | CHAR | 60 | 0 | |||||
181 | .INCLUDE | 0 | 0 | NF-e Block Z /Additional Data - Document numbers from ERP | |||||
182 | XPED | CHAR | 60 | 0 | |||||
183 | XCONT | CHAR | 60 | 0 | |||||
184 | C_XCAMPO | CHAR | 20 | 0 | |||||
185 | C_XTEXTO | CHAR | 60 | 0 | |||||
186 | F_XCAMPO | CHAR | 20 | 0 | |||||
187 | F_XTEXTO | CHAR | 60 | 0 | |||||
188 | NPROC | CHAR | 60 | 0 | |||||
189 | INDPROC | CHAR | 60 | 0 | |||||
190 | XNEMP | CHAR | 17 | 0 | |||||
191 | .INCLUDE | 0 | 0 | Return Information from XI | |||||
192 | AUTHCOD | J_1BNFEAUTHCODE | J_1BNFEAUTHCODE | CHAR | 15 | 0 | Protocol Number | ||
193 | DOCSTAT | J_1BNFEDOCSTATUS | J_1BNFEDOCSTATUS | CHAR | 1 | 0 | Document Status | ||
194 | SCSSTAT | J_1BNFESCSSTATUS | J_1BNFESCSSTATUS | CHAR | 1 | 0 | System Communication Status | ||
195 | STATCODE | J_1BSTATUSCODE | J_1BSTATUSCODE | CHAR | 3 | 0 | Official Status Code | * | |
196 | CONTING | J_1BCONTINGENCY | XFELD | CHAR | 1 | 0 | Document Posted under Contingency | ||
197 | .INCLUDE | 0 | 0 | Nota Fiscal Eletronica / NF-e Data - HEADER (1:1), Vers. 2 | |||||
198 | HSAIENT | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
199 | DHCONT | CHAR | 21 | 0 | |||||
200 | XJUST | CHAR | 256 | 0 | |||||
201 | CRT | J_1BCRT | J_1BCRT | NUMC | 1 | 0 | Taxation Code | ||
202 | CHAR | 60 | 0 | ||||||
203 | F_CPF | STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
204 | G_CPF | STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
205 | T3_VAGAO | CHAR | 20 | 0 | |||||
206 | T3_BALSA | CHAR | 20 | 0 | |||||
207 | INFADFISCO_V2 | STRG | 0 | 0 | |||||
208 | .INCLUDE | 0 | 0 | NF-e Data - HEADER - Version 2 - Sugar Cane | |||||
209 | SAFRA | CHAR | 9 | 0 | |||||
210 | REF | CHAR | 6 | 0 | |||||
211 | QTOTMES | DEC | 21 | 10 | |||||
212 | QTOTANT | DEC | 21 | 10 | |||||
213 | QTOTGER | DEC | 21 | 10 | |||||
214 | VFOR | DEC | 15 | 2 | |||||
215 | VTOTDED | DEC | 15 | 2 | |||||
216 | VLIQFOR | DEC | 15 | 2 | |||||
217 | XNEMP_LONG | CHAR | 40 | 0 | |||||
218 | VTOTTRIB | J_1BNFE_VTOTTRIB | DEC | 15 | 2 | Total Tax Value |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in | 604 |