ABAP Select data from SAP table /TMF/HDSNTRAB into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP /TMF/HDSNTRAB 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 /TMF/HDSNTRAB. 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 /TMF/HDSNTRAB 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_/TMF/HDSNTRAB TYPE STANDARD TABLE OF /TMF/HDSNTRAB,
      WA_/TMF/HDSNTRAB TYPE /TMF/HDSNTRAB,
      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: </TMF/HDSNTRAB> TYPE /TMF/HDSNTRAB.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_/TMF/HDSNTRAB.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /TMF/HDSNTRAB
  INTO TABLE IT_/TMF/HDSNTRAB.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /TMF/HDSNTRAB
*  INTO TABLE @DATA(IT_/TMF/HDSNTRAB2).
*--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_/TMF/HDSNTRAB INDEX 1 INTO DATA(WA_/TMF/HDSNTRAB2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/TMF/HDSNTRAB ASSIGNING </TMF/HDSNTRAB>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
</TMF/HDSNTRAB>-MANDT = 1.
</TMF/HDSNTRAB>-ID_EVENTO = 1.
</TMF/HDSNTRAB>-RECORD_ID = 1.
</TMF/HDSNTRAB>-NM_TRAB = 1.
</TMF/HDSNTRAB>-SEXO = 1.

ENDLOOP.

LOOP AT IT_/TMF/HDSNTRAB INTO WA_/TMF/HDSNTRAB.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/TMF/HDSNTRAB-RACA_COR, sy-vline,
  WA_/TMF/HDSNTRAB-EST_CIV, sy-vline,
  WA_/TMF/HDSNTRAB-GRAU_INSTR, sy-vline,
  WA_/TMF/HDSNTRAB-NM_SOC, sy-vline,
  WA_/TMF/HDSNTRAB-IND_PRI_EMPR, sy-vline,
  WA_/TMF/HDSNTRAB-DT_NASCTO, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/TMF/HDSNTRAB 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_/TMF/HDSNTRAB 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_/TMF/HDSNTRAB INTO WA_/TMF/HDSNTRAB.


*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.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_/TMF/HDSNTRAB_STR, 
MANDT TYPE STRING,
ID_EVENTO TYPE STRING,
RECORD_ID TYPE STRING,
NM_TRAB TYPE STRING,
SEXO TYPE STRING,
RACA_COR TYPE STRING,
EST_CIV TYPE STRING,
GRAU_INSTR TYPE STRING,
NM_SOC TYPE STRING,
IND_PRI_EMPR TYPE STRING,
DT_NASCTO TYPE STRING,
COD_MUNIC_NASCTO TYPE STRING,
UF_NASCTO TYPE STRING,
PAIS_NASCTO TYPE STRING,
PAIS_NAC TYPE STRING,
NM_MAE TYPE STRING,
NM_PAI TYPE STRING,
NR_CTPS TYPE STRING,
SERIE_CTPS TYPE STRING,
UF_CTPS TYPE STRING,
NR_RIC TYPE STRING,
ORGAO_EMISSOR_RIC TYPE STRING,
DT_EXPED_RIC TYPE STRING,
NR_RG TYPE STRING,
ORGAO_EMISSOR_RG TYPE STRING,
DT_EXPED_RG TYPE STRING,
NR_RNE TYPE STRING,
ORGAO_EMISSOR_RNE TYPE STRING,
DT_EXPED_RNE TYPE STRING,
NR_OC TYPE STRING,
ORGAO_EMISSOR_OC TYPE STRING,
DT_EXPED_OC TYPE STRING,
DT_VALID_OC TYPE STRING,
NR_REG_CNH TYPE STRING,
DT_EXPED_CNH TYPE STRING,
UF_CNH TYPE STRING,
DT_VALID_CNH TYPE STRING,
DT_PRI_HAB TYPE STRING,
CATEGORIA_CNH TYPE STRING,
TP_LOGRAD TYPE STRING,
DSC_LOGRAD TYPE STRING,
NR_LOGRAD TYPE STRING,
COMPLEMENTO TYPE STRING,
BAIRRO TYPE STRING,
CEP TYPE STRING,
COD_MUNIC TYPE STRING,
UF TYPE STRING,
PAIS_RESID TYPE STRING,
NM_CID TYPE STRING,
COD_POSTAL TYPE STRING,
DT_CHEGADA TYPE STRING,
CLASS_TRAB_ESTRANG TYPE STRING,
CASADO_BR TYPE STRING,
FILHOS_BR TYPE STRING,
DEF_FISICA TYPE STRING,
DEF_VISUAL TYPE STRING,
DEF_AUDITIVA TYPE STRING,
DEF_MENTAL TYPE STRING,
DEF_INTELECTUAL TYPE STRING,
REAB_READAP TYPE STRING,
INFO_COTA TYPE STRING,
OBS_DEFICIENCIA TYPE STRING,
TRAB_APOSENT TYPE STRING,
FONE_PRINC TYPE STRING,
FONE_ALTERNAT TYPE STRING,
EMAIL_PRINC TYPE STRING,
EMAIL_ALTERNAT TYPE STRING,
MATRICULA TYPE STRING,
TP_REG_TRAB TYPE STRING,
TP_REG_PREV TYPE STRING,
NR_REC_INF_PRELIM TYPE STRING,
DT_ADM TYPE STRING,
TP_ADMISSAO TYPE STRING,
IND_ADMISSAO TYPE STRING,
TP_REG_JOR TYPE STRING,
NAT_ATIVIDADE TYPE STRING,
DT_BASE TYPE STRING,
CNPJ_SIND_CATEG_PROF TYPE STRING,
OPC_FGTS TYPE STRING,
DT_OPC_FGTS TYPE STRING,
MTV_CONTRAT TYPE STRING,
HIP_LEG TYPE STRING,
JUST_CONTR TYPE STRING,
TP_INCL_CONTR TYPE STRING,
TP_INSC_TOMADOR TYPE STRING,
NR_INSC_TOMADOR TYPE STRING,
TP_INSC_ESTAB_VINC TYPE STRING,
NR_INSC_ESTAB_VINC TYPE STRING,
TP_INSC_APREN TYPE STRING,
NR_INSC_APREN TYPE STRING,
CPF_TRAB_SUBST TYPE STRING,
MATRIC_TRAB_SUBST TYPE STRING,
IND_PROVIM TYPE STRING,
TP_PROV TYPE STRING,
DT_NOMEACAO TYPE STRING,
DT_POSSE TYPE STRING,
DT_EXERCICIO TYPE STRING,
TP_PLAN_RP TYPE STRING,
NR_PROC_JUD_EST TYPE STRING,
COD_CARGO TYPE STRING,
COD_FUNCAO TYPE STRING,
COD_CATEG TYPE STRING,
COD_CARREIRA TYPE STRING,
DT_INGR_CARR TYPE STRING,
VR_SAL_FX TYPE STRING,
UND_SAL_FIXO TYPE STRING,
DSC_SAL_VAR TYPE STRING,
TP_CONTR TYPE STRING,
DT_TERM TYPE STRING,
TP_INSC_TRAB TYPE STRING,
NR_INSC_TRAB TYPE STRING,
DESC_COMP TYPE STRING,
TP_LOGRAD_TRAB TYPE STRING,
DSC_LOGRAD_TRAB TYPE STRING,
NR_LOGRAD_TRAB TYPE STRING,
COMPLEMENTO_TRAB TYPE STRING,
BAIRRO_TRAB TYPE STRING,
CEP_TRAB TYPE STRING,
COD_MUNIC_TRAB TYPE STRING,
UF_TRAB TYPE STRING,
QTD_HRS_SEM TYPE STRING,
TP_JORNADA TYPE STRING,
DSC_TP_JORN TYPE STRING,
TMP_PARC TYPE STRING,
CNPJ_SIND_TRAB TYPE STRING,
NR_PROC_JUD TYPE STRING,
CNPJ_EMPREG_ANT TYPE STRING,
MATRIC_ANT TYPE STRING,
DT_INI_VINCULO TYPE STRING,
OBS_SUCESSAO_VINC TYPE STRING,
DT_ALTERACAO TYPE STRING,
DT_ASO_ADM TYPE STRING,
NR_CRM TYPE STRING,
UF_CRM TYPE STRING,
DT_INI_AFAST TYPE STRING,
DT_DESLIG TYPE STRING,
COD_MOT_AFAST TYPE STRING,
DT_EF TYPE STRING,
DSC_ALT TYPE STRING,
MTV_ALTER TYPE STRING,
JUST_PRORR TYPE STRING,
CAD_INI TYPE STRING,
CLAU_ASSEG TYPE STRING,
TP_INSC_APREND TYPE STRING,
NR_INSC_APREND TYPE STRING,
DT_TRANSF TYPE STRING,
CPF_SUBSTITUIDO_TD TYPE STRING,
MATRIC_ANT_TD TYPE STRING,
DT_TRANSF_TD TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/TMF/HDSNTRAB_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_/TMF/HDSNTRAB_STR-MANDT sy-vline 
WA_/TMF/HDSNTRAB_STR-ID_EVENTO sy-vline 
WA_/TMF/HDSNTRAB_STR-RECORD_ID sy-vline 
WA_/TMF/HDSNTRAB_STR-NM_TRAB sy-vline 
WA_/TMF/HDSNTRAB_STR-SEXO sy-vline 
WA_/TMF/HDSNTRAB_STR-RACA_COR sy-vline 
WA_/TMF/HDSNTRAB_STR-EST_CIV sy-vline 
WA_/TMF/HDSNTRAB_STR-GRAU_INSTR sy-vline 
WA_/TMF/HDSNTRAB_STR-NM_SOC sy-vline 
WA_/TMF/HDSNTRAB_STR-IND_PRI_EMPR sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_NASCTO sy-vline 
WA_/TMF/HDSNTRAB_STR-COD_MUNIC_NASCTO sy-vline 
WA_/TMF/HDSNTRAB_STR-UF_NASCTO sy-vline 
WA_/TMF/HDSNTRAB_STR-PAIS_NASCTO sy-vline 
WA_/TMF/HDSNTRAB_STR-PAIS_NAC sy-vline 
WA_/TMF/HDSNTRAB_STR-NM_MAE sy-vline 
WA_/TMF/HDSNTRAB_STR-NM_PAI sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_CTPS sy-vline 
WA_/TMF/HDSNTRAB_STR-SERIE_CTPS sy-vline 
WA_/TMF/HDSNTRAB_STR-UF_CTPS sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_RIC sy-vline 
WA_/TMF/HDSNTRAB_STR-ORGAO_EMISSOR_RIC sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_EXPED_RIC sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_RG sy-vline 
WA_/TMF/HDSNTRAB_STR-ORGAO_EMISSOR_RG sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_EXPED_RG sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_RNE sy-vline 
WA_/TMF/HDSNTRAB_STR-ORGAO_EMISSOR_RNE sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_EXPED_RNE sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_OC sy-vline 
WA_/TMF/HDSNTRAB_STR-ORGAO_EMISSOR_OC sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_EXPED_OC sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_VALID_OC sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_REG_CNH sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_EXPED_CNH sy-vline 
WA_/TMF/HDSNTRAB_STR-UF_CNH sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_VALID_CNH sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_PRI_HAB sy-vline 
WA_/TMF/HDSNTRAB_STR-CATEGORIA_CNH sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_LOGRAD sy-vline 
WA_/TMF/HDSNTRAB_STR-DSC_LOGRAD sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_LOGRAD sy-vline 
WA_/TMF/HDSNTRAB_STR-COMPLEMENTO sy-vline 
WA_/TMF/HDSNTRAB_STR-BAIRRO sy-vline 
WA_/TMF/HDSNTRAB_STR-CEP sy-vline 
WA_/TMF/HDSNTRAB_STR-COD_MUNIC sy-vline 
WA_/TMF/HDSNTRAB_STR-UF sy-vline 
WA_/TMF/HDSNTRAB_STR-PAIS_RESID sy-vline 
WA_/TMF/HDSNTRAB_STR-NM_CID sy-vline 
WA_/TMF/HDSNTRAB_STR-COD_POSTAL sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_CHEGADA sy-vline 
WA_/TMF/HDSNTRAB_STR-CLASS_TRAB_ESTRANG sy-vline 
WA_/TMF/HDSNTRAB_STR-CASADO_BR sy-vline 
WA_/TMF/HDSNTRAB_STR-FILHOS_BR sy-vline 
WA_/TMF/HDSNTRAB_STR-DEF_FISICA sy-vline 
WA_/TMF/HDSNTRAB_STR-DEF_VISUAL sy-vline 
WA_/TMF/HDSNTRAB_STR-DEF_AUDITIVA sy-vline 
WA_/TMF/HDSNTRAB_STR-DEF_MENTAL sy-vline 
WA_/TMF/HDSNTRAB_STR-DEF_INTELECTUAL sy-vline 
WA_/TMF/HDSNTRAB_STR-REAB_READAP sy-vline 
WA_/TMF/HDSNTRAB_STR-INFO_COTA sy-vline 
WA_/TMF/HDSNTRAB_STR-OBS_DEFICIENCIA sy-vline 
WA_/TMF/HDSNTRAB_STR-TRAB_APOSENT sy-vline 
WA_/TMF/HDSNTRAB_STR-FONE_PRINC sy-vline 
WA_/TMF/HDSNTRAB_STR-FONE_ALTERNAT sy-vline 
WA_/TMF/HDSNTRAB_STR-EMAIL_PRINC sy-vline 
WA_/TMF/HDSNTRAB_STR-EMAIL_ALTERNAT sy-vline 
WA_/TMF/HDSNTRAB_STR-MATRICULA sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_REG_TRAB sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_REG_PREV sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_REC_INF_PRELIM sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_ADM sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_ADMISSAO sy-vline 
WA_/TMF/HDSNTRAB_STR-IND_ADMISSAO sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_REG_JOR sy-vline 
WA_/TMF/HDSNTRAB_STR-NAT_ATIVIDADE sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_BASE sy-vline 
WA_/TMF/HDSNTRAB_STR-CNPJ_SIND_CATEG_PROF sy-vline 
WA_/TMF/HDSNTRAB_STR-OPC_FGTS sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_OPC_FGTS sy-vline 
WA_/TMF/HDSNTRAB_STR-MTV_CONTRAT sy-vline 
WA_/TMF/HDSNTRAB_STR-HIP_LEG sy-vline 
WA_/TMF/HDSNTRAB_STR-JUST_CONTR sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_INCL_CONTR sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_INSC_TOMADOR sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_INSC_TOMADOR sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_INSC_ESTAB_VINC sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_INSC_ESTAB_VINC sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_INSC_APREN sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_INSC_APREN sy-vline 
WA_/TMF/HDSNTRAB_STR-CPF_TRAB_SUBST sy-vline 
WA_/TMF/HDSNTRAB_STR-MATRIC_TRAB_SUBST sy-vline 
WA_/TMF/HDSNTRAB_STR-IND_PROVIM sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_PROV sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_NOMEACAO sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_POSSE sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_EXERCICIO sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_PLAN_RP sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_PROC_JUD_EST sy-vline 
WA_/TMF/HDSNTRAB_STR-COD_CARGO sy-vline 
WA_/TMF/HDSNTRAB_STR-COD_FUNCAO sy-vline 
WA_/TMF/HDSNTRAB_STR-COD_CATEG sy-vline 
WA_/TMF/HDSNTRAB_STR-COD_CARREIRA sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_INGR_CARR sy-vline 
WA_/TMF/HDSNTRAB_STR-VR_SAL_FX sy-vline 
WA_/TMF/HDSNTRAB_STR-UND_SAL_FIXO sy-vline 
WA_/TMF/HDSNTRAB_STR-DSC_SAL_VAR sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_CONTR sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_TERM sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_INSC_TRAB sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_INSC_TRAB sy-vline 
WA_/TMF/HDSNTRAB_STR-DESC_COMP sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_LOGRAD_TRAB sy-vline 
WA_/TMF/HDSNTRAB_STR-DSC_LOGRAD_TRAB sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_LOGRAD_TRAB sy-vline 
WA_/TMF/HDSNTRAB_STR-COMPLEMENTO_TRAB sy-vline 
WA_/TMF/HDSNTRAB_STR-BAIRRO_TRAB sy-vline 
WA_/TMF/HDSNTRAB_STR-CEP_TRAB sy-vline 
WA_/TMF/HDSNTRAB_STR-COD_MUNIC_TRAB sy-vline 
WA_/TMF/HDSNTRAB_STR-UF_TRAB sy-vline 
WA_/TMF/HDSNTRAB_STR-QTD_HRS_SEM sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_JORNADA sy-vline 
WA_/TMF/HDSNTRAB_STR-DSC_TP_JORN sy-vline 
WA_/TMF/HDSNTRAB_STR-TMP_PARC sy-vline 
WA_/TMF/HDSNTRAB_STR-CNPJ_SIND_TRAB sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_PROC_JUD sy-vline 
WA_/TMF/HDSNTRAB_STR-CNPJ_EMPREG_ANT sy-vline 
WA_/TMF/HDSNTRAB_STR-MATRIC_ANT sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_INI_VINCULO sy-vline 
WA_/TMF/HDSNTRAB_STR-OBS_SUCESSAO_VINC sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_ALTERACAO sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_ASO_ADM sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_CRM sy-vline 
WA_/TMF/HDSNTRAB_STR-UF_CRM sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_INI_AFAST sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_DESLIG sy-vline 
WA_/TMF/HDSNTRAB_STR-COD_MOT_AFAST sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_EF sy-vline 
WA_/TMF/HDSNTRAB_STR-DSC_ALT sy-vline 
WA_/TMF/HDSNTRAB_STR-MTV_ALTER sy-vline 
WA_/TMF/HDSNTRAB_STR-JUST_PRORR sy-vline 
WA_/TMF/HDSNTRAB_STR-CAD_INI sy-vline 
WA_/TMF/HDSNTRAB_STR-CLAU_ASSEG sy-vline 
WA_/TMF/HDSNTRAB_STR-TP_INSC_APREND sy-vline 
WA_/TMF/HDSNTRAB_STR-NR_INSC_APREND sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_TRANSF sy-vline 
WA_/TMF/HDSNTRAB_STR-CPF_SUBSTITUIDO_TD sy-vline 
WA_/TMF/HDSNTRAB_STR-MATRIC_ANT_TD sy-vline 
WA_/TMF/HDSNTRAB_STR-DT_TRANSF_TD sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.