ABAP Select data from SAP table J1B_NF_XML_HEADER into internal table
Get Example source ABAP code based on a different SAP table
Below is a number of ABAP code snippets to demonstrate how to select data from SAP J1B_NF_XML_HEADER table and store it within an internal table, including using the newer @DATA inline declaration methods. It also shows you various ways to process this data using ABAP work area, inline declaration or field symbols including executing all the relevant CONVERSION_EXIT routines specific to J1B_NF_XML_HEADER. See here for more generic Select statement tips.
Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. These input/output conversation FM routines are what translates the data between the two formats.
There is also a full declaration of the J1B_NF_XML_HEADER table where each field has a char/string type for you to simply copy and paste. This allows you to use processing that is only available to these field types such as the CONCATENATE statement.
DATA: IT_J1B_NF_XML_HEADER TYPE STANDARD TABLE OF J1B_NF_XML_HEADER, WA_J1B_NF_XML_HEADER TYPE J1B_NF_XML_HEADER, GD_STR TYPE STRING. DATA: lo_typedescr type REF TO cl_abap_typedescr. DATA: lv_fieldname type fieldname. FIELD-SYMBOLS: <FIELD> TYPE any. FIELD-SYMBOLS: <J1B_NF_XML_HEADER> TYPE J1B_NF_XML_HEADER. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_J1B_NF_XML_HEADER. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM J1B_NF_XML_HEADER INTO TABLE IT_J1B_NF_XML_HEADER. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM J1B_NF_XML_HEADER * INTO TABLE @DATA(IT_J1B_NF_XML_HEADER2). *--Further methods of using ABAP code to select data from SAP database tables *You can also declare the header/work area using the in-line DATA declaration method READ TABLE IT_J1B_NF_XML_HEADER INDEX 1 INTO DATA(WA_J1B_NF_XML_HEADER2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_J1B_NF_XML_HEADER ASSIGNING <J1B_NF_XML_HEADER>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<J1B_NF_XML_HEADER>-DOCNUM = 1.
<J1B_NF_XML_HEADER>-LOGSYS = 1.
<J1B_NF_XML_HEADER>-WAERS = 1.
<J1B_NF_XML_HEADER>-VERSION = 1.
<J1B_NF_XML_HEADER>-ID = 1.
ENDLOOP. LOOP AT IT_J1B_NF_XML_HEADER INTO WA_J1B_NF_XML_HEADER. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_J1B_NF_XML_HEADER-CUF, sy-vline,
WA_J1B_NF_XML_HEADER-CNF, sy-vline,
WA_J1B_NF_XML_HEADER-NATOP, sy-vline,
WA_J1B_NF_XML_HEADER-INDPAG, sy-vline,
WA_J1B_NF_XML_HEADER-MOD, sy-vline,
WA_J1B_NF_XML_HEADER-SERIE, sy-vline.
ENDLOOP. *Add any further fields from structure WA_J1B_NF_XML_HEADER you want to display... WRITE:/ sy-uline. * Aternatively use generic code to Write field values (and NAME) to screen report DO. ASSIGN COMPONENT sy-index OF STRUCTURE wa_J1B_NF_XML_HEADER TO <field>. IF sy-subrc <> 0. EXIT. ENDIF. WRITE:/ 'Field Value', <field>, sy-vline. gd_str = <field> . lo_typedescr ?= CL_ABAP_DATADESCR=>DESCRIBE_BY_DATA( <field> ). lv_fieldname = lo_typedescr->GET_RELATIVE_NAME( ). WRITE:/ 'Field Name', lv_fieldname. ENDDO. *Redo loop but convert all fields from internal to out value LOOP AT IT_J1B_NF_XML_HEADER INTO WA_J1B_NF_XML_HEADER. *Write horizonal line to screen report. WRITE:/ sy-uline. *Convert all fields to display/output versions using conversion routines PERFORM convert_all_field_values CHANGING wa_EKKO. ENDLOOP. *&---------------------------------------------------------------------* *& Form convert_all_field_values *&---------------------------------------------------------------------* FORM convert_all_field_values CHANGING p_EKKO LIKE wa_EKKO. DATA: ld_input(1000) TYPE c, ld_output(1000) TYPE C.
*Conversion exit ALPHA, internal->external for field LOGSYS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_J1B_NF_XML_HEADER-LOGSYS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J1B_NF_XML_HEADER-LOGSYS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CFOBR, internal->external for field T5_CFOP CALL FUNCTION 'CONVERSION_EXIT_CFOBR_OUTPUT' EXPORTING input = WA_J1B_NF_XML_HEADER-T5_CFOP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J1B_NF_XML_HEADER-T5_CFOP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field STATCODE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_J1B_NF_XML_HEADER-STATCODE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J1B_NF_XML_HEADER-STATCODE.
WRITE:/ 'New Value:', ld_input.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_J1B_NF_XML_HEADER_STR,
DOCNUM TYPE STRING,
LOGSYS TYPE STRING,
WAERS TYPE STRING,
VERSION TYPE STRING,
ID TYPE STRING,
CUF TYPE STRING,
CNF TYPE STRING,
NATOP TYPE STRING,
INDPAG TYPE STRING,
MOD TYPE STRING,
SERIE TYPE STRING,
NNF TYPE STRING,
DEMI TYPE STRING,
DSAIENT TYPE STRING,
TPNF TYPE STRING,
CMUNFG TYPE STRING,
TPIMP TYPE STRING,
TPEMIS TYPE STRING,
CDV TYPE STRING,
TPAMB TYPE STRING,
FINNFE TYPE STRING,
PROCEMI TYPE STRING,
VERPROC TYPE STRING,
ALTER_REGIO TYPE STRING,
C_CNPJ TYPE STRING,
C_XNOME TYPE STRING,
C_XFANT TYPE STRING,
C1_XLGR TYPE STRING,
C1_NRO TYPE STRING,
C1_XCPL TYPE STRING,
C1_XBAIRRO TYPE STRING,
C1_CMUN TYPE STRING,
C1_XMUN TYPE STRING,
C1_UF TYPE STRING,
C1_CEP TYPE STRING,
C1_CPAIS TYPE STRING,
C1_XPAIS TYPE STRING,
C1_FONE TYPE STRING,
C1_IE TYPE STRING,
C1_IEST TYPE STRING,
C1_IM TYPE STRING,
C1_CNAE TYPE STRING,
AVULSA TYPE STRING,
D_CNPJ TYPE STRING,
D_XORGAO TYPE STRING,
D_MATR TYPE STRING,
D_XAGENTE TYPE STRING,
D_FONE TYPE STRING,
D_UF TYPE STRING,
D_NDAR TYPE STRING,
D_DEMI TYPE STRING,
D_VDAR TYPE STRING,
D_REPEMI TYPE STRING,
D_PAG TYPE STRING,
E_CNPJ TYPE STRING,
E_CPF TYPE STRING,
E_XNOME TYPE STRING,
E1_XLGR TYPE STRING,
E1_NRO TYPE STRING,
E1_XCPL TYPE STRING,
E1_XBAIRRO TYPE STRING,
E1_CMUN TYPE STRING,
E1_XMUN TYPE STRING,
E1_UF TYPE STRING,
E1_CEP TYPE STRING,
E1_CPAIS TYPE STRING,
E1_XPAIS TYPE STRING,
E1_FONE TYPE STRING,
E1_IE TYPE STRING,
E1_ISUF TYPE STRING,
E1_EMAIL TYPE STRING,
F_RETIRADA TYPE STRING,
F_CNPJ TYPE STRING,
F_XLGR TYPE STRING,
F_NRO TYPE STRING,
F_XCPL TYPE STRING,
F_XBAIRRO TYPE STRING,
F_CMUN TYPE STRING,
F_XMUN TYPE STRING,
F_UF TYPE STRING,
F_XNOME TYPE STRING,
F_CEP TYPE STRING,
F_CPAIS TYPE STRING,
F_XPAIS TYPE STRING,
F_FONE TYPE STRING,
F_IE TYPE STRING,
F_EMAIL TYPE STRING,
ENTREGA TYPE STRING,
G_CNPJ TYPE STRING,
G_XLGR TYPE STRING,
G_NRO TYPE STRING,
G_XCPL TYPE STRING,
G_XBAIRRO TYPE STRING,
G_CMUN TYPE STRING,
G_XMUN TYPE STRING,
G_UF TYPE STRING,
G_XNOME TYPE STRING,
G_CEP TYPE STRING,
G_CPAIS TYPE STRING,
G_XPAIS TYPE STRING,
G_FONE TYPE STRING,
G_IE TYPE STRING,
G_EMAIL TYPE STRING,
S1_VBC TYPE STRING,
S1_VICMS TYPE STRING,
S1_VBCST TYPE STRING,
S1_VST TYPE STRING,
S1_VPROD TYPE STRING,
S1_VFRETE TYPE STRING,
S1_VSEG TYPE STRING,
S1_VDESC TYPE STRING,
S1_VII TYPE STRING,
S1_VIPI TYPE STRING,
S1_VPIS TYPE STRING,
S1_VCOFINS TYPE STRING,
S1_VOUTRO TYPE STRING,
S1_VNF TYPE STRING,
S1_VFCP TYPE STRING,
S1_VFCPST TYPE STRING,
S1_VFCPSTRET TYPE STRING,
S2_VSERV TYPE STRING,
S2_VBC TYPE STRING,
S2_VISS TYPE STRING,
S2_VPISISS TYPE STRING,
S2_VCOFINSISS TYPE STRING,
S3_VRETPIS TYPE STRING,
S3_VRETCOFINS TYPE STRING,
S3_VRETCSLL TYPE STRING,
S3_VBCIRRF TYPE STRING,
S3_VIRRF TYPE STRING,
S3_VBCRETPREV TYPE STRING,
S3_VRETPREV TYPE STRING,
T_MODFRETE TYPE STRING,
T1_CNPJ TYPE STRING,
T1_CPF TYPE STRING,
T1_XNOME TYPE STRING,
T1_IE TYPE STRING,
T1_XEND TYPE STRING,
T1_XMUN TYPE STRING,
T1_UF TYPE STRING,
T5_VSERV TYPE STRING,
T5_VBCRET TYPE STRING,
T5_PICMSRET TYPE STRING,
T5_VICMSRET TYPE STRING,
T5_CFOP TYPE STRING,
T5_CMUNFG TYPE STRING,
T2_PLACA TYPE STRING,
T2_UF1 TYPE STRING,
T2_RNTC TYPE STRING,
T3_PLACA TYPE STRING,
T3_UF1 TYPE STRING,
T3_RNTC TYPE STRING,
T4_QVOL TYPE STRING,
T4_ESP TYPE STRING,
T4_MARCA TYPE STRING,
T4_NVOL TYPE STRING,
T4_PESOL TYPE STRING,
T4_PESOB TYPE STRING,
T4_NLACRE TYPE STRING,
COBR TYPE STRING,
NFAT TYPE STRING,
VORIG TYPE STRING,
VDESC TYPE STRING,
VLIQ TYPE STRING,
NDUP TYPE STRING,
DVENC TYPE STRING,
VDUP TYPE STRING,
NDUP_NEW TYPE STRING,
INFADFISCO TYPE STRING,
INFCOMP TYPE STRING,
COMEX TYPE STRING,
UFEMBARQ TYPE STRING,
XLOCEMBARQ TYPE STRING,
XPED TYPE STRING,
XCONT TYPE STRING,
C_XCAMPO TYPE STRING,
C_XTEXTO TYPE STRING,
F_XCAMPO TYPE STRING,
F_XTEXTO TYPE STRING,
NPROC TYPE STRING,
INDPROC TYPE STRING,
XNEMP TYPE STRING,
AUTHCOD TYPE STRING,
DOCSTAT TYPE STRING,
SCSSTAT TYPE STRING,
STATCODE TYPE STRING,
CONTING TYPE STRING,
HSAIENT TYPE STRING,
DHCONT TYPE STRING,
XJUST TYPE STRING,
CRT TYPE STRING,
EMAIL TYPE STRING,
F_CPF TYPE STRING,
G_CPF TYPE STRING,
T3_VAGAO TYPE STRING,
T3_BALSA TYPE STRING,
INFADFISCO_V2 TYPE STRING,
SAFRA TYPE STRING,
REF TYPE STRING,
QTOTMES TYPE STRING,
QTOTANT TYPE STRING,
QTOTGER TYPE STRING,
VFOR TYPE STRING,
VTOTDED TYPE STRING,
VLIQFOR TYPE STRING,
XNEMP_LONG TYPE STRING,
VTOTTRIB TYPE STRING,
VTROCO TYPE STRING,END OF T_EKKO_STR. DATA: WA_J1B_NF_XML_HEADER_STR type T_EKKO_STR. DATA: ld_text TYPE string. LOOP AT IT_EKKO INTO WA_EKKO. MOVE-CORRESPONDING wa_EKKO TO WA_EKKO_STR. CONCATENATE: sy-vline
WA_J1B_NF_XML_HEADER_STR-DOCNUM sy-vline
WA_J1B_NF_XML_HEADER_STR-LOGSYS sy-vline
WA_J1B_NF_XML_HEADER_STR-WAERS sy-vline
WA_J1B_NF_XML_HEADER_STR-VERSION sy-vline
WA_J1B_NF_XML_HEADER_STR-ID sy-vline
WA_J1B_NF_XML_HEADER_STR-CUF sy-vline
WA_J1B_NF_XML_HEADER_STR-CNF sy-vline
WA_J1B_NF_XML_HEADER_STR-NATOP sy-vline
WA_J1B_NF_XML_HEADER_STR-INDPAG sy-vline
WA_J1B_NF_XML_HEADER_STR-MOD sy-vline
WA_J1B_NF_XML_HEADER_STR-SERIE sy-vline
WA_J1B_NF_XML_HEADER_STR-NNF sy-vline
WA_J1B_NF_XML_HEADER_STR-DEMI sy-vline
WA_J1B_NF_XML_HEADER_STR-DSAIENT sy-vline
WA_J1B_NF_XML_HEADER_STR-TPNF sy-vline
WA_J1B_NF_XML_HEADER_STR-CMUNFG sy-vline
WA_J1B_NF_XML_HEADER_STR-TPIMP sy-vline
WA_J1B_NF_XML_HEADER_STR-TPEMIS sy-vline
WA_J1B_NF_XML_HEADER_STR-CDV sy-vline
WA_J1B_NF_XML_HEADER_STR-TPAMB sy-vline
WA_J1B_NF_XML_HEADER_STR-FINNFE sy-vline
WA_J1B_NF_XML_HEADER_STR-PROCEMI sy-vline
WA_J1B_NF_XML_HEADER_STR-VERPROC sy-vline
WA_J1B_NF_XML_HEADER_STR-ALTER_REGIO sy-vline
WA_J1B_NF_XML_HEADER_STR-C_CNPJ sy-vline
WA_J1B_NF_XML_HEADER_STR-C_XNOME sy-vline
WA_J1B_NF_XML_HEADER_STR-C_XFANT sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_XLGR sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_NRO sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_XCPL sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_XBAIRRO sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_CMUN sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_XMUN sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_UF sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_CEP sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_CPAIS sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_XPAIS sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_FONE sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_IE sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_IEST sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_IM sy-vline
WA_J1B_NF_XML_HEADER_STR-C1_CNAE sy-vline
WA_J1B_NF_XML_HEADER_STR-AVULSA sy-vline
WA_J1B_NF_XML_HEADER_STR-D_CNPJ sy-vline
WA_J1B_NF_XML_HEADER_STR-D_XORGAO sy-vline
WA_J1B_NF_XML_HEADER_STR-D_MATR sy-vline
WA_J1B_NF_XML_HEADER_STR-D_XAGENTE sy-vline
WA_J1B_NF_XML_HEADER_STR-D_FONE sy-vline
WA_J1B_NF_XML_HEADER_STR-D_UF sy-vline
WA_J1B_NF_XML_HEADER_STR-D_NDAR sy-vline
WA_J1B_NF_XML_HEADER_STR-D_DEMI sy-vline
WA_J1B_NF_XML_HEADER_STR-D_VDAR sy-vline
WA_J1B_NF_XML_HEADER_STR-D_REPEMI sy-vline
WA_J1B_NF_XML_HEADER_STR-D_PAG sy-vline
WA_J1B_NF_XML_HEADER_STR-E_CNPJ sy-vline
WA_J1B_NF_XML_HEADER_STR-E_CPF sy-vline
WA_J1B_NF_XML_HEADER_STR-E_XNOME sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_XLGR sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_NRO sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_XCPL sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_XBAIRRO sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_CMUN sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_XMUN sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_UF sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_CEP sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_CPAIS sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_XPAIS sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_FONE sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_IE sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_ISUF sy-vline
WA_J1B_NF_XML_HEADER_STR-E1_EMAIL sy-vline
WA_J1B_NF_XML_HEADER_STR-F_RETIRADA sy-vline
WA_J1B_NF_XML_HEADER_STR-F_CNPJ sy-vline
WA_J1B_NF_XML_HEADER_STR-F_XLGR sy-vline
WA_J1B_NF_XML_HEADER_STR-F_NRO sy-vline
WA_J1B_NF_XML_HEADER_STR-F_XCPL sy-vline
WA_J1B_NF_XML_HEADER_STR-F_XBAIRRO sy-vline
WA_J1B_NF_XML_HEADER_STR-F_CMUN sy-vline
WA_J1B_NF_XML_HEADER_STR-F_XMUN sy-vline
WA_J1B_NF_XML_HEADER_STR-F_UF sy-vline
WA_J1B_NF_XML_HEADER_STR-F_XNOME sy-vline
WA_J1B_NF_XML_HEADER_STR-F_CEP sy-vline
WA_J1B_NF_XML_HEADER_STR-F_CPAIS sy-vline
WA_J1B_NF_XML_HEADER_STR-F_XPAIS sy-vline
WA_J1B_NF_XML_HEADER_STR-F_FONE sy-vline
WA_J1B_NF_XML_HEADER_STR-F_IE sy-vline
WA_J1B_NF_XML_HEADER_STR-F_EMAIL sy-vline
WA_J1B_NF_XML_HEADER_STR-ENTREGA sy-vline
WA_J1B_NF_XML_HEADER_STR-G_CNPJ sy-vline
WA_J1B_NF_XML_HEADER_STR-G_XLGR sy-vline
WA_J1B_NF_XML_HEADER_STR-G_NRO sy-vline
WA_J1B_NF_XML_HEADER_STR-G_XCPL sy-vline
WA_J1B_NF_XML_HEADER_STR-G_XBAIRRO sy-vline
WA_J1B_NF_XML_HEADER_STR-G_CMUN sy-vline
WA_J1B_NF_XML_HEADER_STR-G_XMUN sy-vline
WA_J1B_NF_XML_HEADER_STR-G_UF sy-vline
WA_J1B_NF_XML_HEADER_STR-G_XNOME sy-vline
WA_J1B_NF_XML_HEADER_STR-G_CEP sy-vline
WA_J1B_NF_XML_HEADER_STR-G_CPAIS sy-vline
WA_J1B_NF_XML_HEADER_STR-G_XPAIS sy-vline
WA_J1B_NF_XML_HEADER_STR-G_FONE sy-vline
WA_J1B_NF_XML_HEADER_STR-G_IE sy-vline
WA_J1B_NF_XML_HEADER_STR-G_EMAIL sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VBC sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VICMS sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VBCST sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VST sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VPROD sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VFRETE sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VSEG sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VDESC sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VII sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VIPI sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VPIS sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VCOFINS sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VOUTRO sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VNF sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VFCP sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VFCPST sy-vline
WA_J1B_NF_XML_HEADER_STR-S1_VFCPSTRET sy-vline
WA_J1B_NF_XML_HEADER_STR-S2_VSERV sy-vline
WA_J1B_NF_XML_HEADER_STR-S2_VBC sy-vline
WA_J1B_NF_XML_HEADER_STR-S2_VISS sy-vline
WA_J1B_NF_XML_HEADER_STR-S2_VPISISS sy-vline
WA_J1B_NF_XML_HEADER_STR-S2_VCOFINSISS sy-vline
WA_J1B_NF_XML_HEADER_STR-S3_VRETPIS sy-vline
WA_J1B_NF_XML_HEADER_STR-S3_VRETCOFINS sy-vline
WA_J1B_NF_XML_HEADER_STR-S3_VRETCSLL sy-vline
WA_J1B_NF_XML_HEADER_STR-S3_VBCIRRF sy-vline
WA_J1B_NF_XML_HEADER_STR-S3_VIRRF sy-vline
WA_J1B_NF_XML_HEADER_STR-S3_VBCRETPREV sy-vline
WA_J1B_NF_XML_HEADER_STR-S3_VRETPREV sy-vline
WA_J1B_NF_XML_HEADER_STR-T_MODFRETE sy-vline
WA_J1B_NF_XML_HEADER_STR-T1_CNPJ sy-vline
WA_J1B_NF_XML_HEADER_STR-T1_CPF sy-vline
WA_J1B_NF_XML_HEADER_STR-T1_XNOME sy-vline
WA_J1B_NF_XML_HEADER_STR-T1_IE sy-vline
WA_J1B_NF_XML_HEADER_STR-T1_XEND sy-vline
WA_J1B_NF_XML_HEADER_STR-T1_XMUN sy-vline
WA_J1B_NF_XML_HEADER_STR-T1_UF sy-vline
WA_J1B_NF_XML_HEADER_STR-T5_VSERV sy-vline
WA_J1B_NF_XML_HEADER_STR-T5_VBCRET sy-vline
WA_J1B_NF_XML_HEADER_STR-T5_PICMSRET sy-vline
WA_J1B_NF_XML_HEADER_STR-T5_VICMSRET sy-vline
WA_J1B_NF_XML_HEADER_STR-T5_CFOP sy-vline
WA_J1B_NF_XML_HEADER_STR-T5_CMUNFG sy-vline
WA_J1B_NF_XML_HEADER_STR-T2_PLACA sy-vline
WA_J1B_NF_XML_HEADER_STR-T2_UF1 sy-vline
WA_J1B_NF_XML_HEADER_STR-T2_RNTC sy-vline
WA_J1B_NF_XML_HEADER_STR-T3_PLACA sy-vline
WA_J1B_NF_XML_HEADER_STR-T3_UF1 sy-vline
WA_J1B_NF_XML_HEADER_STR-T3_RNTC sy-vline
WA_J1B_NF_XML_HEADER_STR-T4_QVOL sy-vline
WA_J1B_NF_XML_HEADER_STR-T4_ESP sy-vline
WA_J1B_NF_XML_HEADER_STR-T4_MARCA sy-vline
WA_J1B_NF_XML_HEADER_STR-T4_NVOL sy-vline
WA_J1B_NF_XML_HEADER_STR-T4_PESOL sy-vline
WA_J1B_NF_XML_HEADER_STR-T4_PESOB sy-vline
WA_J1B_NF_XML_HEADER_STR-T4_NLACRE sy-vline
WA_J1B_NF_XML_HEADER_STR-COBR sy-vline
WA_J1B_NF_XML_HEADER_STR-NFAT sy-vline
WA_J1B_NF_XML_HEADER_STR-VORIG sy-vline
WA_J1B_NF_XML_HEADER_STR-VDESC sy-vline
WA_J1B_NF_XML_HEADER_STR-VLIQ sy-vline
WA_J1B_NF_XML_HEADER_STR-NDUP sy-vline
WA_J1B_NF_XML_HEADER_STR-DVENC sy-vline
WA_J1B_NF_XML_HEADER_STR-VDUP sy-vline
WA_J1B_NF_XML_HEADER_STR-NDUP_NEW sy-vline
WA_J1B_NF_XML_HEADER_STR-INFADFISCO sy-vline
WA_J1B_NF_XML_HEADER_STR-INFCOMP sy-vline
WA_J1B_NF_XML_HEADER_STR-COMEX sy-vline
WA_J1B_NF_XML_HEADER_STR-UFEMBARQ sy-vline
WA_J1B_NF_XML_HEADER_STR-XLOCEMBARQ sy-vline
WA_J1B_NF_XML_HEADER_STR-XPED sy-vline
WA_J1B_NF_XML_HEADER_STR-XCONT sy-vline
WA_J1B_NF_XML_HEADER_STR-C_XCAMPO sy-vline
WA_J1B_NF_XML_HEADER_STR-C_XTEXTO sy-vline
WA_J1B_NF_XML_HEADER_STR-F_XCAMPO sy-vline
WA_J1B_NF_XML_HEADER_STR-F_XTEXTO sy-vline
WA_J1B_NF_XML_HEADER_STR-NPROC sy-vline
WA_J1B_NF_XML_HEADER_STR-INDPROC sy-vline
WA_J1B_NF_XML_HEADER_STR-XNEMP sy-vline
WA_J1B_NF_XML_HEADER_STR-AUTHCOD sy-vline
WA_J1B_NF_XML_HEADER_STR-DOCSTAT sy-vline
WA_J1B_NF_XML_HEADER_STR-SCSSTAT sy-vline
WA_J1B_NF_XML_HEADER_STR-STATCODE sy-vline
WA_J1B_NF_XML_HEADER_STR-CONTING sy-vline
WA_J1B_NF_XML_HEADER_STR-HSAIENT sy-vline
WA_J1B_NF_XML_HEADER_STR-DHCONT sy-vline
WA_J1B_NF_XML_HEADER_STR-XJUST sy-vline
WA_J1B_NF_XML_HEADER_STR-CRT sy-vline
WA_J1B_NF_XML_HEADER_STR-EMAIL sy-vline
WA_J1B_NF_XML_HEADER_STR-F_CPF sy-vline
WA_J1B_NF_XML_HEADER_STR-G_CPF sy-vline
WA_J1B_NF_XML_HEADER_STR-T3_VAGAO sy-vline
WA_J1B_NF_XML_HEADER_STR-T3_BALSA sy-vline
WA_J1B_NF_XML_HEADER_STR-INFADFISCO_V2 sy-vline
WA_J1B_NF_XML_HEADER_STR-SAFRA sy-vline
WA_J1B_NF_XML_HEADER_STR-REF sy-vline
WA_J1B_NF_XML_HEADER_STR-QTOTMES sy-vline
WA_J1B_NF_XML_HEADER_STR-QTOTANT sy-vline
WA_J1B_NF_XML_HEADER_STR-QTOTGER sy-vline
WA_J1B_NF_XML_HEADER_STR-VFOR sy-vline
WA_J1B_NF_XML_HEADER_STR-VTOTDED sy-vline
WA_J1B_NF_XML_HEADER_STR-VLIQFOR sy-vline
WA_J1B_NF_XML_HEADER_STR-XNEMP_LONG sy-vline
WA_J1B_NF_XML_HEADER_STR-VTOTTRIB sy-vline
WA_J1B_NF_XML_HEADER_STR-VTROCO sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.