J1B_NF_XML_HEADER SAP (Nota Fiscal Eletronica / NF-e Data - HEADER (1:1)) Structure details
Description: Nota Fiscal Eletronica / NF-e Data - HEADER (1:1)
Related tables to J1B_NF_XML_HEADER
Access table J1B_NF_XML_HEADER
Structure field list including key, data, relationships and ABAP select examples
J1B_NF_XML_HEADER is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Nota Fiscal Eletronica / NF-e Data - HEADER (1:1)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_J1B_NF_XML_HEADER TYPE J1B_NF_XML_HEADER.
The J1B_NF_XML_HEADER table consists of various fields, each holding specific information or linking keys about Nota Fiscal Eletronica / NF-e Data - HEADER (1:1) data available in SAP. These include LOGSYS (Logical System), WAERS (Currency Key), VERSION (Layot Version), ID (Access key).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP J1B_NF_XML_HEADER structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
DOCNUM | Document Number | J_1BDOCNUM | NUMC | 10 | Assigned to domain | J_1BDOCNUM | JEF | ||
LOGSYS | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
VERSION | Layot Version | 0 | |||||||
ID | Access key | 0 | |||||||
CUF | Region of the issuer | 0 | |||||||
CNF | Random code (internal Nota Fiscal numbner) | 0 | |||||||
NATOP | CFOP description | 0 | |||||||
INDPAG | Payment Indicator | 0 | |||||||
MOD | Model of Nota Fiscal | J_1BMODEL | NUMC | 2 | J_1BMODEL | ||||
SERIE | Series | J_1BSERIES | CHAR | 3 | J_1BSERIES | ||||
NNF | 9 digit Nota Fiscal number | 0 | |||||||
DEMI | Document date | J_1BDOCDAT | DATS | 8 | DATUM | ||||
DSAIENT | Outgoing date | 0 | |||||||
TPNF | Direction of the movement | J_1BDIRECT | CHAR | 1 | J_1BDIRECT | ||||
CMUNFG | City code of the Branch | 0 | |||||||
TPIMP | Printing format 1-Portrate/ 2-Landscape | 0 | |||||||
TPEMIS | Issuing Type | J_1BNFE_TPEMIS | CHAR | 1 | J_1BNFE_TPEMIS | ||||
CDV | Check digit Modulo 11 | 0 | |||||||
TPAMB | Type of Environment (Test or Production) | J_1BNFETPAMB | CHAR | 1 | J_1BNFETPAMB | ||||
FINNFE | NF-e Issuing Reason | 0 | |||||||
PROCEMI | Issuing Process Identifier | J_1BNFEPROCEMI | CHAR | 1 | J_1BNFEPROCEMI | ||||
VERPROC | Application Version | J_1BNFEVERPROC | CHAR | 20 | J_1BNFEVERPROC | ||||
ALTER_REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
C_CNPJ | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
C_XNOME | Name | 0 | |||||||
C_XFANT | Name 2 | NAME2 | CHAR | 30 | TEXT30 | ||||
C1_XLGR | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
C1_NRO | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
C1_XCPL | Complemento (Appartment) | 0 | |||||||
C1_XBAIRRO | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
C1_CMUN | City code (2nd part of jurisdiction) | 0 | |||||||
C1_XMUN | Name of municipio / City from Jurisdiction code | 0 | |||||||
C1_UF | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
C1_CEP | Postal code | PSTLZ_BAS | CHAR | 10 | PSTLZ | ||||
C1_CPAIS | 0 | ||||||||
C1_XPAIS | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
C1_FONE | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | CHAR30 | ||||
C1_IE | State Tax Number | J_1BSTAINS | CHAR | 18 | J_1BSTAINS | ||||
C1_IEST | State Tax Number for Substituição Tributária | J_1BSTAIST | CHAR | 18 | J_1BSTAINS | ||||
C1_IM | Municipal Tax Number | J_1BMUNINS | CHAR | 20 | J_1BMUNINS | ||||
C1_CNAE | National of Economic Activity Code | 0 | |||||||
AVULSA | avulsa | 0 | |||||||
D_CNPJ | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
D_XORGAO | Ãrgão emitente | 0 | |||||||
D_MATR | MatrÃcula do agente | 0 | |||||||
D_XAGENTE | Nome do agente | 0 | |||||||
D_FONE | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | CHAR30 | ||||
D_UF | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
D_NDAR | Número do Documento de Arrecadação de Receita | 0 | |||||||
D_DEMI | Data de emissão do DAR | 0 | |||||||
D_VDAR | Valor Total constante no Documento de arrecadação de Receita | 0 | |||||||
D_REPEMI | Repartição Fiscal emitente | 0 | |||||||
D_PAG | Payment document date YYYY-MM-DD | 0 | |||||||
E_CNPJ | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
E_CPF | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
E_XNOME | Name | 0 | |||||||
E1_XLGR | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
E1_NRO | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
E1_XCPL | Complemento (Appartment) | 0 | |||||||
E1_XBAIRRO | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
E1_CMUN | City code (2nd part of jurisdiction) | 0 | |||||||
E1_XMUN | Name of municipio / City from Jurisdiction code | 0 | |||||||
E1_UF | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
E1_CEP | Postal code | PSTLZ_BAS | CHAR | 10 | PSTLZ | ||||
E1_CPAIS | BACEN Country key | 0 | |||||||
E1_XPAIS | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
E1_FONE | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | CHAR30 | ||||
E1_IE | State Tax Number | J_1BSTAINS | CHAR | 18 | J_1BSTAINS | ||||
E1_ISUF | Suframa - Operation with Zona franca de Manaus | 0 | |||||||
F_RETIRADA | Identification of the location where goods leave from | 0 | |||||||
F_CNPJ | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
F_XLGR | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
F_NRO | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
F_XCPL | Complemento (Appartment) | 0 | |||||||
F_XBAIRRO | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
F_CMUN | City code (2nd part of jurisdiction) | 0 | |||||||
F_XMUN | Name of municipio / City from Jurisdiction code | 0 | |||||||
F_UF | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
ENTREGA | Entrege | 0 | |||||||
G_CNPJ | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
G_XLGR | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
G_NRO | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
G_XCPL | Complemento (Appartment) | 0 | |||||||
G_XBAIRRO | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
G_CMUN | City code (2nd part of jurisdiction) | 0 | |||||||
G_XMUN | Name of municipio / City from Jurisdiction code | 0 | |||||||
G_UF | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
S1_VBC | Calculation base ISS | 0 | |||||||
S1_VICMS | Total value ICMS | 0 | |||||||
S1_VBCST | Calculation Base SubTrib | 0 | |||||||
S1_VST | Total value SubTrib | 0 | |||||||
S1_VPROD | Total value service products | 0 | |||||||
S1_VFRETE | Total value freight | 0 | |||||||
S1_VSEG | Total value insurance | 0 | |||||||
S1_VDESC | Total value discount | 0 | |||||||
S1_VII | Total value import | 0 | |||||||
S1_VIPI | Total value IPI | 0 | |||||||
S1_VPIS | PIS value over ISS service | 0 | |||||||
S1_VCOFINS | Total value COFINS | 0 | |||||||
S1_VOUTRO | Total value other expenses | 0 | |||||||
S1_VNF | Total value NF-e | 0 | |||||||
S2_VSERV | Total value of non ICMS service (ISS) | 0 | |||||||
S2_VBC | Calculation base ISS | 0 | |||||||
S2_VISS | Total value ISS | 0 | |||||||
S2_VPISISS | PIS value over ISS service | 0 | |||||||
S2_VCOFINSISS | COFINS value over ISS service | 0 | |||||||
S3_VRETPIS | Tax value | J_1BTAXVAL | CURR | 15(2) | J_1BTAXVAL | ||||
S3_VRETCOFINS | Tax value | J_1BTAXVAL | CURR | 15(2) | J_1BTAXVAL | ||||
S3_VRETCSLL | Tax value | J_1BTAXVAL | CURR | 15(2) | J_1BTAXVAL | ||||
S3_VBCIRRF | Base amount | J_1BBASE | CURR | 15(2) | J_1BBASE | ||||
S3_VIRRF | Tax value | J_1BTAXVAL | CURR | 15(2) | J_1BTAXVAL | ||||
S3_VBCRETPREV | Base amount | J_1BBASE | CURR | 15(2) | J_1BBASE | ||||
S3_VRETPREV | Tax value | J_1BTAXVAL | CURR | 15(2) | J_1BTAXVAL | ||||
T_MODFRETE | Freight paid from: 0-vendor ; 1-customer | 0 | |||||||
T1_CNPJ | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
T1_CPF | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
T1_XNOME | Name | 0 | |||||||
T1_IE | State Tax Number | J_1BSTAINS | CHAR | 18 | J_1BSTAINS | ||||
T1_XEND | Endereço Completo | 0 | |||||||
T1_XMUN | Name of municipio / City from Jurisdiction code | 0 | |||||||
T1_UF | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
T5_VSERV | Total value including all taxes | J_1BNFTOT | CURR | 15(2) | WERTV8 | ||||
T5_VBCRET | Base amount | J_1BBASE | CURR | 15(2) | J_1BBASE | ||||
T5_PICMSRET | Tax Rate | J_1BTXRATE | DEC | 6(2) | J_1BTXRATE | ||||
T5_VICMSRET | Tax value | J_1BTAXVAL | CURR | 15(2) | J_1BTAXVAL | ||||
T5_CFOP | CFOP Code and Extension | J_1BCFOP | CHAR | 10 | Assigned to domain | CFOBR | J_1BCFOP | ||
T5_CMUNFG | Municipio | 0 | |||||||
T2_PLACA | Licence plate | 0 | |||||||
T2_UF1 | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
T2_RNTC | National register of carrirer (ANTT) | 0 | |||||||
T3_PLACA | Licence plate | 0 | |||||||
T3_UF1 | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
T3_RNTC | National register of carrirer (ANTT) | 0 | |||||||
T4_QVOL | Volume units | 0 | |||||||
T4_ESP | Type of Shipped Volumes | 0 | |||||||
T4_MARCA | Brand of Shipped Volumes | 0 | |||||||
T4_NVOL | Numbering of Shipped Volumes | 0 | |||||||
T4_PESOL | Net weight in KG | 0 | |||||||
T4_PESOB | Gross weight in KG | 0 | |||||||
T4_NLACRE | Number of specifig box | 0 | |||||||
COBR | Cobr | 0 | |||||||
NFAT | Fatura Number | 0 | |||||||
VORIG | Original Fatura Value | 0 | |||||||
VDESC | Discount value | 0 | |||||||
VLIQ | Valor LÃquido da Fatura | 0 | |||||||
NDUP | Duplicata Number | 0 | |||||||
DVENC | Duplicata date | 0 | |||||||
VDUP | Duplicata value | 0 | |||||||
NDUP_NEW | Duplicata Number New | 0 | |||||||
INFADFISCO | Fatura Number | 0 | |||||||
INFCOMP | Original Fatura Value | 0 | |||||||
COMEX | Comex | 0 | |||||||
UFEMBARQ | Region of arrival | 0 | |||||||
XLOCEMBARQ | Local onde ocorrerá o Embarque dos produtos | 0 | |||||||
XPED | Purchase order numbers | 0 | |||||||
XCONT | Contract numbers | 0 | |||||||
C_XCAMPO | Fieldname of c_xtexto | 0 | |||||||
C_XTEXTO | Text field for additional information | 0 | |||||||
F_XCAMPO | Fieldname of f_xtexto | 0 | |||||||
F_XTEXTO | Text field for additional information | 0 | |||||||
NPROC | Process identification | 0 | |||||||
INDPROC | Identifier of the origin of the process | 0 | |||||||
XNEMP | Binding Document Number | 0 | |||||||
AUTHCOD | Protocol Number | J_1BNFEAUTHCODE | CHAR | 15 | J_1BNFEAUTHCODE | ||||
DOCSTAT | Document Status | J_1BNFEDOCSTATUS | CHAR | 1 | J_1BNFEDOCSTATUS | ||||
SCSSTAT | System Communication Status | J_1BNFESCSSTATUS | CHAR | 1 | J_1BNFESCSSTATUS | ||||
STATCODE | Official Status Code | J_1BSTATUSCODE | CHAR | 3 | Assigned to domain | ALPHA | J_1BSTATUSCODE | ||
CONTING | Document Posted under Contingency | J_1BCONTINGENCY | CHAR | 1 | XFELD | ||||
HSAIENT | Time | UZEIT | TIMS | 6 | UZEIT | ||||
DHCONT | Contingency Activation Date and Time | 0 | |||||||
XJUST | Contingency Activation Reason | 0 | |||||||
CRT | Taxation Code | J_1BCRT | NUMC | 1 | J_1BCRT | ||||
E-mail address | 0 | ||||||||
F_CPF | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
G_CPF | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
T3_VAGAO | Wagon identification | 0 | |||||||
T3_BALSA | Ferryboat identification | 0 | |||||||
INFADFISCO_V2 | Additional Information concerning to the Authorities | 0 | |||||||
SAFRA | Harvest Identification | 0 | |||||||
REF | Reference Month and Year | 0 | |||||||
QTOTMES | Month total quantity | 0 | |||||||
QTOTANT | Previous total quantity | 0 | |||||||
QTOTGER | General total quantity | 0 | |||||||
VFOR | Supplies value | 0 | |||||||
VTOTDED | Total deduction value | 0 | |||||||
VLIQFOR | Supplies Net Value | 0 | |||||||
XNEMP_LONG | Binding Document Number (extended) | 0 | |||||||
VTOTTRIB | Total Tax Value | J_1BNFE_VTOTTRIB | DEC | 15(2) |
Key field | Non-key field |
How do I retrieve data from SAP structure J1B_NF_XML_HEADER using ABAP code?
As J1B_NF_XML_HEADER is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on J1B_NF_XML_HEADER as there is no data to select.How to access SAP table J1B_NF_XML_HEADER
Within an ECC or HANA version of SAP you can also view further information about J1B_NF_XML_HEADER and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects