ABAP Select data from SAP table SI_AUTHA 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 SI_AUTHA 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 SI_AUTHA. 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 SI_AUTHA 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_SI_AUTHA TYPE STANDARD TABLE OF SI_AUTHA,
      WA_SI_AUTHA TYPE SI_AUTHA,
      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: <SI_AUTHA> TYPE SI_AUTHA.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM SI_AUTHA
  INTO TABLE IT_SI_AUTHA.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM SI_AUTHA
*  INTO TABLE @DATA(IT_SI_AUTHA2).
*--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_SI_AUTHA INDEX 1 INTO DATA(WA_SI_AUTHA2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_SI_AUTHA ASSIGNING <SI_AUTHA>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<SI_AUTHA>-DIMEN = 1.
<SI_AUTHA>-RVERS = 1.
<SI_AUTHA>-ITCLG = 1.
<SI_AUTHA>-BUNIT = 1.
<SI_AUTHA>-CONGR = 1.

ENDLOOP.

LOOP AT IT_SI_AUTHA INTO WA_SI_AUTHA.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_SI_AUTHA-DEFRM, sy-vline,
  WA_SI_AUTHA-JEFRM, sy-vline,
  WA_SI_AUTHA-CACTT, sy-vline,
  WA_SI_AUTHA-CACTI, sy-vline,
  WA_SI_AUTHA-PERMO, sy-vline,
  WA_SI_AUTHA-FCFIELD, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_SI_AUTHA 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_SI_AUTHA 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_SI_AUTHA INTO WA_SI_AUTHA.


*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 RVERS
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-RVERS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-RVERS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AFIMC, internal->external for field BUNIT
CALL FUNCTION 'CONVERSION_EXIT_AFIMC_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-BUNIT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-BUNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AFIMC, internal->external for field CONGR
CALL FUNCTION 'CONVERSION_EXIT_AFIMC_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-CONGR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-CONGR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SWENR, internal->external for field SWENR
CALL FUNCTION 'CONVERSION_EXIT_SWENR_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-SWENR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-SWENR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PARTNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-PARTNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-PARTNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ANLKL
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-ANLKL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-ANLKL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field ARTNR
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-ARTNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-ARTNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AUART, internal->external for field AUART
CALL FUNCTION 'CONVERSION_EXIT_AUART_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-AUART
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-AUART.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PERI7, internal->external for field CEALTPERIO
CALL FUNCTION 'CONVERSION_EXIT_PERI7_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-CEALTPERIO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-CEALTPERIO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CEKNDNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-CEKNDNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-CEKNDNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit LEDBO, internal->external for field CEPALEDGER
CALL FUNCTION 'CONVERSION_EXIT_LEDBO_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-CEPALEDGER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-CEPALEDGER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PERI7, internal->external for field CEPERIO
CALL FUNCTION 'CONVERSION_EXIT_PERI7_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-CEPERIO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-CEPERIO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CEVERSI
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-CEVERSI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-CEVERSI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CEVERSN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-CEVERSN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-CEVERSN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PERI7, internal->external for field CFPERI
CALL FUNCTION 'CONVERSION_EXIT_PERI7_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-CFPERI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-CFPERI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CFVERSION
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-CFVERSION
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-CFVERSION.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field CFYEARB
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-CFYEARB
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-CFYEARB.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field FM_VERSN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-FM_VERSN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-FM_VERSN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field GLRLDNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-GLRLDNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-GLRLDNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field GLRVERS
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-GLRVERS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-GLRVERS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field IM_IVART
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-IM_IVART
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-IM_IVART.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field INSET
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-INSET
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-INSET.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KAUFN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-KAUFN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-KAUFN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit KOTAB, internal->external for field KOTABNR
CALL FUNCTION 'CONVERSION_EXIT_KOTAB_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-KOTABNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-KOTABNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KTOGR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-KTOGR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-KTOGR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PS_FKSTL
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-PS_FKSTL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-PS_FKSTL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SAMMG
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-SAMMG
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-SAMMG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field STAFO
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SI_AUTHA-STAFO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SI_AUTHA-STAFO.
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_SI_AUTHA_STR, 
DIMEN TYPE STRING,
RVERS TYPE STRING,
ITCLG TYPE STRING,
BUNIT TYPE STRING,
CONGR TYPE STRING,
DEFRM TYPE STRING,
JEFRM TYPE STRING,
CACTT TYPE STRING,
CACTI TYPE STRING,
PERMO TYPE STRING,
FCFIELD TYPE STRING,
FCVALUE TYPE STRING,
GSART TYPE STRING,
SANLF TYPE STRING,
SSTATI TYPE STRING,
SWENR TYPE STRING,
SROLEXT TYPE STRING,
SECU TYPE STRING,
SZEART TYPE STRING,
RPORTB TYPE STRING,
RLDEPO TYPE STRING,
SFHAART TYPE STRING,
TRFCT TYPE STRING,
DEP_FCT TYPE STRING,
TRGAT TYPE STRING,
KMART TYPE STRING,
TB_SFGZUTY TYPE STRING,
BP_TYP TYPE STRING,
TBEGRU TYPE STRING,
RDEALER TYPE STRING,
PARTNR TYPE STRING,
ACTION TYPE STRING,
ACTIVITY TYPE STRING,
ADRES TYPE STRING,
AEFUN TYPE STRING,
AENST TYPE STRING,
AFAPL TYPE STRING,
AKART TYPE STRING,
AKKRT TYPE STRING,
AKKTP TYPE STRING,
AKTHE TYPE STRING,
AKTPR TYPE STRING,
AKTTYP TYPE STRING,
AM_ACT_PER TYPE STRING,
ANLKL TYPE STRING,
APPKZ TYPE STRING,
AP_ART TYPE STRING,
ARTNR TYPE STRING,
ASTNR TYPE STRING,
ASTYP TYPE STRING,
ATAUTH TYPE STRING,
AUART TYPE STRING,
AUFAR TYPE STRING,
AUFART TYPE STRING,
AUSGB TYPE STRING,
AUTHAREA TYPE STRING,
AUTHPHASE TYPE STRING,
BASSL TYPE STRING,
BEGRM TYPE STRING,
BEGRP TYPE STRING,
BERGRP TYPE STRING,
BERSL TYPE STRING,
BETRVORG TYPE STRING,
BGRKL TYPE STRING,
BGRKP TYPE STRING,
BGRSE TYPE STRING,
BLTYP TYPE STRING,
BOART TYPE STRING,
BONUS TYPE STRING,
BSART TYPE STRING,
BWASL TYPE STRING,
BWLVS TYPE STRING,
BZIRK TYPE STRING,
CEALTPERIO TYPE STRING,
CEBKENNZ TYPE STRING,
CEERKRS TYPE STRING,
CEFORM TYPE STRING,
CEKNDNR TYPE STRING,
CEPALEDGER TYPE STRING,
CEPERDE TYPE STRING,
CEPERIO TYPE STRING,
CEPLIKZ TYPE STRING,
CEREPID TYPE STRING,
CETKENNZ TYPE STRING,
CEVERSI TYPE STRING,
CEVERSN TYPE STRING,
CFASPET TYPE STRING,
CFHIEID TYPE STRING,
CFHVERS TYPE STRING,
CFJDEST TYPE STRING,
CFKKENNZ TYPE STRING,
CFKYRSP TYPE STRING,
CFLFDID TYPE STRING,
CFOKCOD TYPE STRING,
CFPERDE TYPE STRING,
CFPERI TYPE STRING,
CFPLACT TYPE STRING,
CFRECTY TYPE STRING,
CFREPID TYPE STRING,
CFVALTY TYPE STRING,
CFVERSION TYPE STRING,
CFVERSO TYPE STRING,
CFYEARB TYPE STRING,
CO_ACTION TYPE STRING,
CO_KAINT TYPE STRING,
CO_VRGNG TYPE STRING,
CSR_AUTGR TYPE STRING,
CTLPC TYPE STRING,
DATART TYPE STRING,
DEF_AUTGR TYPE STRING,
DG_OBJECT TYPE STRING,
DOKAR TYPE STRING,
DOKST TYPE STRING,
DUMMY TYPE STRING,
ENTSL TYPE STRING,
ESEAUTHGRP TYPE STRING,
ESECATPIN TYPE STRING,
ESEESTCAT TYPE STRING,
ESEPHRGRP TYPE STRING,
ESEREPTYPE TYPE STRING,
ESERVLID TYPE STRING,
ESEVACLID TYPE STRING,
FAKSK TYPE STRING,
FBTCH TYPE STRING,
FKARTT TYPE STRING,
FK_AUS TYPE STRING,
FK_ERH TYPE STRING,
FMREASON TYPE STRING,
FMRE_AUTH TYPE STRING,
FMRE_BLART TYPE STRING,
FMRE_BLTYP TYPE STRING,
FM_AUTHACT TYPE STRING,
FM_AUTHDAY TYPE STRING,
FM_VERSN TYPE STRING,
FRGCD TYPE STRING,
FRGCO TYPE STRING,
GEART TYPE STRING,
GEGRU TYPE STRING,
GLACTIVITY TYPE STRING,
GLCENTACTY TYPE STRING,
GLCLUSTER TYPE STRING,
GLCYCLE TYPE STRING,
GLDEFNAME TYPE STRING,
GLFIELDGRP TYPE STRING,
GLGLOBAL TYPE STRING,
GLLIB TYPE STRING,
GLRGJNR TYPE STRING,
GLRLDNR TYPE STRING,
GLRNAME TYPE STRING,
GLROLLUP TYPE STRING,
GLRPLAN TYPE STRING,
GLRRCTY TYPE STRING,
GLRVERS TYPE STRING,
GLSETNR TYPE STRING,
GSTRU TYPE STRING,
HNAME TYPE STRING,
IDENT TYPE STRING,
IM_ACTSY TYPE STRING,
IM_ACTVT TYPE STRING,
IM_APPST TYPE STRING,
IM_IVART TYPE STRING,
INGRP TYPE STRING,
INSET TYPE STRING,
IWERK TYPE STRING,
KAPPL TYPE STRING,
KAUFN TYPE STRING,
KBLART TYPE STRING,
KDGRP TYPE STRING,
KDPOS TYPE STRING,
KFPBLA TYPE STRING,
KKBER TYPE STRING,
KLPRZ TYPE STRING,
KLVAR TYPE STRING,
KNBEO TYPE STRING,
KOTABNR TYPE STRING,
KSCHL TYPE STRING,
KTAAR TYPE STRING,
KTOGR TYPE STRING,
KTRAT TYPE STRING,
KUSRGR TYPE STRING,
LBACTVT TYPE STRING,
LBBEGRU TYPE STRING,
LBNUM TYPE STRING,
LB_USE_KZ TYPE STRING,
LFART TYPE STRING,
LGNUM TYPE STRING,
LGTOR TYPE STRING,
LGTYP TYPE STRING,
L_SFUNC TYPE STRING,
MAABC TYPE STRING,
MASSOBJTYP TYPE STRING,
MATKL TYPE STRING,
MCAPP TYPE STRING,
MCGEN TYPE STRING,
MCINF TYPE STRING,
MCKEN TYPE STRING,
MDAKT TYPE STRING,
MDATL TYPE STRING,
MDATY TYPE STRING,
MODEL TYPE STRING,
MPTYP TYPE STRING,
NOHIS TYPE STRING,
OBTYP TYPE STRING,
OSBEGRU TYPE STRING,
OWNER TYPE STRING,
PAATY TYPE STRING,
PB_REO_AKT TYPE STRING,
PCACTVT TYPE STRING,
PCBEGRU TYPE STRING,
PHASE TYPE STRING,
PKATY TYPE STRING,
PLNAR TYPE STRING,
PLNTY TYPE STRING,
PLSCN TYPE STRING,
PLTYP TYPE STRING,
PMSOG TYPE STRING,
PRART TYPE STRING,
PROC_CHAR TYPE STRING,
PRODH TYPE STRING,
PRVBE TYPE STRING,
PSARG TYPE STRING,
PS_ACTVT TYPE STRING,
PS_FKOKR TYPE STRING,
PS_FKSTL TYPE STRING,
PS_PRART TYPE STRING,
PS_VERNR TYPE STRING,
PS_VGTYP TYPE STRING,
QAUSWAHLMG TYPE STRING,
QBESTBUBER TYPE STRING,
QCODEGRP TYPE STRING,
QCTYP TYPE STRING,
QESTATNEW TYPE STRING,
QESTATOLD TYPE STRING,
QINSMK TYPE STRING,
QKATART TYPE STRING,
QMART TYPE STRING,
QMASTAUTH TYPE STRING,
QMASTMOD TYPE STRING,
QMATAUTH TYPE STRING,
QMATMODUS TYPE STRING,
QPLNFEAT TYPE STRING,
QPRUEFART TYPE STRING,
QSPCKRIT TYPE STRING,
QSTATAWMG TYPE STRING,
QSTATCGRP TYPE STRING,
QSTATMERK TYPE STRING,
QSTATMETH TYPE STRING,
QVAUSWHLMG TYPE STRING,
QVCODE TYPE STRING,
QVCODEGRP TYPE STRING,
QVEART TYPE STRING,
RESPAREA TYPE STRING,
RLKEY TYPE STRING,
RSUBD TYPE STRING,
SAMMG TYPE STRING,
SANPNR TYPE STRING,
SAVE_MAT TYPE STRING,
SAVE_TERM TYPE STRING,
SBEWART TYPE STRING,
SBGRP TYPE STRING,
SCTYP TYPE STRING,
SELVS TYPE STRING,
SETNR TYPE STRING,
SHTYP TYPE STRING,
SICHT TYPE STRING,
SIGNAUTH TYPE STRING,
SIZEC TYPE STRING,
SKOART TYPE STRING,
SLCAT TYPE STRING,
SMART TYPE STRING,
SOPOB TYPE STRING,
SPEGR TYPE STRING,
SSOUR TYPE STRING,
STAFO TYPE STRING,
STATM TYPE STRING,
STATU TYPE STRING,
STLAN TYPE STRING,
STLST TYPE STRING,
STLTY TYPE STRING,
STSMA TYPE STRING,
SVORG TYPE STRING,
SWERK TYPE STRING,
TPLST TYPE STRING,
TRSTACT TYPE STRING,
TV_ACTVT TYPE STRING,
TV_BUKRS TYPE STRING,
TV_CREAT TYPE STRING,
TXTAR TYPE STRING,
USR10_1 TYPE STRING,
USR10_2 TYPE STRING,
USR20_1 TYPE STRING,
USR20_2 TYPE STRING,
USRFLAG_1 TYPE STRING,
USRFLAG_2 TYPE STRING,
VAGRP TYPE STRING,
VALUTYP TYPE STRING,
VEREH TYPE STRING,
VERNR TYPE STRING,
VERSN TYPE STRING,
VERWE TYPE STRING,
VFAUT TYPE STRING,
VIEW TYPE STRING,
VORGANG TYPE STRING,
VRGAR TYPE STRING,
VRSIO TYPE STRING,
VSTEL TYPE STRING,
VTAUT_CONT TYPE STRING,
VTAUT_STRU TYPE STRING,
VZWRK TYPE STRING,
ZEITP TYPE STRING,
ZUSSL TYPE STRING,END OF T_EKKO_STR.
DATA: WA_SI_AUTHA_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_SI_AUTHA_STR-DIMEN sy-vline 
WA_SI_AUTHA_STR-RVERS sy-vline 
WA_SI_AUTHA_STR-ITCLG sy-vline 
WA_SI_AUTHA_STR-BUNIT sy-vline 
WA_SI_AUTHA_STR-CONGR sy-vline 
WA_SI_AUTHA_STR-DEFRM sy-vline 
WA_SI_AUTHA_STR-JEFRM sy-vline 
WA_SI_AUTHA_STR-CACTT sy-vline 
WA_SI_AUTHA_STR-CACTI sy-vline 
WA_SI_AUTHA_STR-PERMO sy-vline 
WA_SI_AUTHA_STR-FCFIELD sy-vline 
WA_SI_AUTHA_STR-FCVALUE sy-vline 
WA_SI_AUTHA_STR-GSART sy-vline 
WA_SI_AUTHA_STR-SANLF sy-vline 
WA_SI_AUTHA_STR-SSTATI sy-vline 
WA_SI_AUTHA_STR-SWENR sy-vline 
WA_SI_AUTHA_STR-SROLEXT sy-vline 
WA_SI_AUTHA_STR-SECU sy-vline 
WA_SI_AUTHA_STR-SZEART sy-vline 
WA_SI_AUTHA_STR-RPORTB sy-vline 
WA_SI_AUTHA_STR-RLDEPO sy-vline 
WA_SI_AUTHA_STR-SFHAART sy-vline 
WA_SI_AUTHA_STR-TRFCT sy-vline 
WA_SI_AUTHA_STR-DEP_FCT sy-vline 
WA_SI_AUTHA_STR-TRGAT sy-vline 
WA_SI_AUTHA_STR-KMART sy-vline 
WA_SI_AUTHA_STR-TB_SFGZUTY sy-vline 
WA_SI_AUTHA_STR-BP_TYP sy-vline 
WA_SI_AUTHA_STR-TBEGRU sy-vline 
WA_SI_AUTHA_STR-RDEALER sy-vline 
WA_SI_AUTHA_STR-PARTNR sy-vline 
WA_SI_AUTHA_STR-ACTION sy-vline 
WA_SI_AUTHA_STR-ACTIVITY sy-vline 
WA_SI_AUTHA_STR-ADRES sy-vline 
WA_SI_AUTHA_STR-AEFUN sy-vline 
WA_SI_AUTHA_STR-AENST sy-vline 
WA_SI_AUTHA_STR-AFAPL sy-vline 
WA_SI_AUTHA_STR-AKART sy-vline 
WA_SI_AUTHA_STR-AKKRT sy-vline 
WA_SI_AUTHA_STR-AKKTP sy-vline 
WA_SI_AUTHA_STR-AKTHE sy-vline 
WA_SI_AUTHA_STR-AKTPR sy-vline 
WA_SI_AUTHA_STR-AKTTYP sy-vline 
WA_SI_AUTHA_STR-AM_ACT_PER sy-vline 
WA_SI_AUTHA_STR-ANLKL sy-vline 
WA_SI_AUTHA_STR-APPKZ sy-vline 
WA_SI_AUTHA_STR-AP_ART sy-vline 
WA_SI_AUTHA_STR-ARTNR sy-vline 
WA_SI_AUTHA_STR-ASTNR sy-vline 
WA_SI_AUTHA_STR-ASTYP sy-vline 
WA_SI_AUTHA_STR-ATAUTH sy-vline 
WA_SI_AUTHA_STR-AUART sy-vline 
WA_SI_AUTHA_STR-AUFAR sy-vline 
WA_SI_AUTHA_STR-AUFART sy-vline 
WA_SI_AUTHA_STR-AUSGB sy-vline 
WA_SI_AUTHA_STR-AUTHAREA sy-vline 
WA_SI_AUTHA_STR-AUTHPHASE sy-vline 
WA_SI_AUTHA_STR-BASSL sy-vline 
WA_SI_AUTHA_STR-BEGRM sy-vline 
WA_SI_AUTHA_STR-BEGRP sy-vline 
WA_SI_AUTHA_STR-BERGRP sy-vline 
WA_SI_AUTHA_STR-BERSL sy-vline 
WA_SI_AUTHA_STR-BETRVORG sy-vline 
WA_SI_AUTHA_STR-BGRKL sy-vline 
WA_SI_AUTHA_STR-BGRKP sy-vline 
WA_SI_AUTHA_STR-BGRSE sy-vline 
WA_SI_AUTHA_STR-BLTYP sy-vline 
WA_SI_AUTHA_STR-BOART sy-vline 
WA_SI_AUTHA_STR-BONUS sy-vline 
WA_SI_AUTHA_STR-BSART sy-vline 
WA_SI_AUTHA_STR-BWASL sy-vline 
WA_SI_AUTHA_STR-BWLVS sy-vline 
WA_SI_AUTHA_STR-BZIRK sy-vline 
WA_SI_AUTHA_STR-CEALTPERIO sy-vline 
WA_SI_AUTHA_STR-CEBKENNZ sy-vline 
WA_SI_AUTHA_STR-CEERKRS sy-vline 
WA_SI_AUTHA_STR-CEFORM sy-vline 
WA_SI_AUTHA_STR-CEKNDNR sy-vline 
WA_SI_AUTHA_STR-CEPALEDGER sy-vline 
WA_SI_AUTHA_STR-CEPERDE sy-vline 
WA_SI_AUTHA_STR-CEPERIO sy-vline 
WA_SI_AUTHA_STR-CEPLIKZ sy-vline 
WA_SI_AUTHA_STR-CEREPID sy-vline 
WA_SI_AUTHA_STR-CETKENNZ sy-vline 
WA_SI_AUTHA_STR-CEVERSI sy-vline 
WA_SI_AUTHA_STR-CEVERSN sy-vline 
WA_SI_AUTHA_STR-CFASPET sy-vline 
WA_SI_AUTHA_STR-CFHIEID sy-vline 
WA_SI_AUTHA_STR-CFHVERS sy-vline 
WA_SI_AUTHA_STR-CFJDEST sy-vline 
WA_SI_AUTHA_STR-CFKKENNZ sy-vline 
WA_SI_AUTHA_STR-CFKYRSP sy-vline 
WA_SI_AUTHA_STR-CFLFDID sy-vline 
WA_SI_AUTHA_STR-CFOKCOD sy-vline 
WA_SI_AUTHA_STR-CFPERDE sy-vline 
WA_SI_AUTHA_STR-CFPERI sy-vline 
WA_SI_AUTHA_STR-CFPLACT sy-vline 
WA_SI_AUTHA_STR-CFRECTY sy-vline 
WA_SI_AUTHA_STR-CFREPID sy-vline 
WA_SI_AUTHA_STR-CFVALTY sy-vline 
WA_SI_AUTHA_STR-CFVERSION sy-vline 
WA_SI_AUTHA_STR-CFVERSO sy-vline 
WA_SI_AUTHA_STR-CFYEARB sy-vline 
WA_SI_AUTHA_STR-CO_ACTION sy-vline 
WA_SI_AUTHA_STR-CO_KAINT sy-vline 
WA_SI_AUTHA_STR-CO_VRGNG sy-vline 
WA_SI_AUTHA_STR-CSR_AUTGR sy-vline 
WA_SI_AUTHA_STR-CTLPC sy-vline 
WA_SI_AUTHA_STR-DATART sy-vline 
WA_SI_AUTHA_STR-DEF_AUTGR sy-vline 
WA_SI_AUTHA_STR-DG_OBJECT sy-vline 
WA_SI_AUTHA_STR-DOKAR sy-vline 
WA_SI_AUTHA_STR-DOKST sy-vline 
WA_SI_AUTHA_STR-DUMMY sy-vline 
WA_SI_AUTHA_STR-ENTSL sy-vline 
WA_SI_AUTHA_STR-ESEAUTHGRP sy-vline 
WA_SI_AUTHA_STR-ESECATPIN sy-vline 
WA_SI_AUTHA_STR-ESEESTCAT sy-vline 
WA_SI_AUTHA_STR-ESEPHRGRP sy-vline 
WA_SI_AUTHA_STR-ESEREPTYPE sy-vline 
WA_SI_AUTHA_STR-ESERVLID sy-vline 
WA_SI_AUTHA_STR-ESEVACLID sy-vline 
WA_SI_AUTHA_STR-FAKSK sy-vline 
WA_SI_AUTHA_STR-FBTCH sy-vline 
WA_SI_AUTHA_STR-FKARTT sy-vline 
WA_SI_AUTHA_STR-FK_AUS sy-vline 
WA_SI_AUTHA_STR-FK_ERH sy-vline 
WA_SI_AUTHA_STR-FMREASON sy-vline 
WA_SI_AUTHA_STR-FMRE_AUTH sy-vline 
WA_SI_AUTHA_STR-FMRE_BLART sy-vline 
WA_SI_AUTHA_STR-FMRE_BLTYP sy-vline 
WA_SI_AUTHA_STR-FM_AUTHACT sy-vline 
WA_SI_AUTHA_STR-FM_AUTHDAY sy-vline 
WA_SI_AUTHA_STR-FM_VERSN sy-vline 
WA_SI_AUTHA_STR-FRGCD sy-vline 
WA_SI_AUTHA_STR-FRGCO sy-vline 
WA_SI_AUTHA_STR-GEART sy-vline 
WA_SI_AUTHA_STR-GEGRU sy-vline 
WA_SI_AUTHA_STR-GLACTIVITY sy-vline 
WA_SI_AUTHA_STR-GLCENTACTY sy-vline 
WA_SI_AUTHA_STR-GLCLUSTER sy-vline 
WA_SI_AUTHA_STR-GLCYCLE sy-vline 
WA_SI_AUTHA_STR-GLDEFNAME sy-vline 
WA_SI_AUTHA_STR-GLFIELDGRP sy-vline 
WA_SI_AUTHA_STR-GLGLOBAL sy-vline 
WA_SI_AUTHA_STR-GLLIB sy-vline 
WA_SI_AUTHA_STR-GLRGJNR sy-vline 
WA_SI_AUTHA_STR-GLRLDNR sy-vline 
WA_SI_AUTHA_STR-GLRNAME sy-vline 
WA_SI_AUTHA_STR-GLROLLUP sy-vline 
WA_SI_AUTHA_STR-GLRPLAN sy-vline 
WA_SI_AUTHA_STR-GLRRCTY sy-vline 
WA_SI_AUTHA_STR-GLRVERS sy-vline 
WA_SI_AUTHA_STR-GLSETNR sy-vline 
WA_SI_AUTHA_STR-GSTRU sy-vline 
WA_SI_AUTHA_STR-HNAME sy-vline 
WA_SI_AUTHA_STR-IDENT sy-vline 
WA_SI_AUTHA_STR-IM_ACTSY sy-vline 
WA_SI_AUTHA_STR-IM_ACTVT sy-vline 
WA_SI_AUTHA_STR-IM_APPST sy-vline 
WA_SI_AUTHA_STR-IM_IVART sy-vline 
WA_SI_AUTHA_STR-INGRP sy-vline 
WA_SI_AUTHA_STR-INSET sy-vline 
WA_SI_AUTHA_STR-IWERK sy-vline 
WA_SI_AUTHA_STR-KAPPL sy-vline 
WA_SI_AUTHA_STR-KAUFN sy-vline 
WA_SI_AUTHA_STR-KBLART sy-vline 
WA_SI_AUTHA_STR-KDGRP sy-vline 
WA_SI_AUTHA_STR-KDPOS sy-vline 
WA_SI_AUTHA_STR-KFPBLA sy-vline 
WA_SI_AUTHA_STR-KKBER sy-vline 
WA_SI_AUTHA_STR-KLPRZ sy-vline 
WA_SI_AUTHA_STR-KLVAR sy-vline 
WA_SI_AUTHA_STR-KNBEO sy-vline 
WA_SI_AUTHA_STR-KOTABNR sy-vline 
WA_SI_AUTHA_STR-KSCHL sy-vline 
WA_SI_AUTHA_STR-KTAAR sy-vline 
WA_SI_AUTHA_STR-KTOGR sy-vline 
WA_SI_AUTHA_STR-KTRAT sy-vline 
WA_SI_AUTHA_STR-KUSRGR sy-vline 
WA_SI_AUTHA_STR-LBACTVT sy-vline 
WA_SI_AUTHA_STR-LBBEGRU sy-vline 
WA_SI_AUTHA_STR-LBNUM sy-vline 
WA_SI_AUTHA_STR-LB_USE_KZ sy-vline 
WA_SI_AUTHA_STR-LFART sy-vline 
WA_SI_AUTHA_STR-LGNUM sy-vline 
WA_SI_AUTHA_STR-LGTOR sy-vline 
WA_SI_AUTHA_STR-LGTYP sy-vline 
WA_SI_AUTHA_STR-L_SFUNC sy-vline 
WA_SI_AUTHA_STR-MAABC sy-vline 
WA_SI_AUTHA_STR-MASSOBJTYP sy-vline 
WA_SI_AUTHA_STR-MATKL sy-vline 
WA_SI_AUTHA_STR-MCAPP sy-vline 
WA_SI_AUTHA_STR-MCGEN sy-vline 
WA_SI_AUTHA_STR-MCINF sy-vline 
WA_SI_AUTHA_STR-MCKEN sy-vline 
WA_SI_AUTHA_STR-MDAKT sy-vline 
WA_SI_AUTHA_STR-MDATL sy-vline 
WA_SI_AUTHA_STR-MDATY sy-vline 
WA_SI_AUTHA_STR-MODEL sy-vline 
WA_SI_AUTHA_STR-MPTYP sy-vline 
WA_SI_AUTHA_STR-NOHIS sy-vline 
WA_SI_AUTHA_STR-OBTYP sy-vline 
WA_SI_AUTHA_STR-OSBEGRU sy-vline 
WA_SI_AUTHA_STR-OWNER sy-vline 
WA_SI_AUTHA_STR-PAATY sy-vline 
WA_SI_AUTHA_STR-PB_REO_AKT sy-vline 
WA_SI_AUTHA_STR-PCACTVT sy-vline 
WA_SI_AUTHA_STR-PCBEGRU sy-vline 
WA_SI_AUTHA_STR-PHASE sy-vline 
WA_SI_AUTHA_STR-PKATY sy-vline 
WA_SI_AUTHA_STR-PLNAR sy-vline 
WA_SI_AUTHA_STR-PLNTY sy-vline 
WA_SI_AUTHA_STR-PLSCN sy-vline 
WA_SI_AUTHA_STR-PLTYP sy-vline 
WA_SI_AUTHA_STR-PMSOG sy-vline 
WA_SI_AUTHA_STR-PRART sy-vline 
WA_SI_AUTHA_STR-PROC_CHAR sy-vline 
WA_SI_AUTHA_STR-PRODH sy-vline 
WA_SI_AUTHA_STR-PRVBE sy-vline 
WA_SI_AUTHA_STR-PSARG sy-vline 
WA_SI_AUTHA_STR-PS_ACTVT sy-vline 
WA_SI_AUTHA_STR-PS_FKOKR sy-vline 
WA_SI_AUTHA_STR-PS_FKSTL sy-vline 
WA_SI_AUTHA_STR-PS_PRART sy-vline 
WA_SI_AUTHA_STR-PS_VERNR sy-vline 
WA_SI_AUTHA_STR-PS_VGTYP sy-vline 
WA_SI_AUTHA_STR-QAUSWAHLMG sy-vline 
WA_SI_AUTHA_STR-QBESTBUBER sy-vline 
WA_SI_AUTHA_STR-QCODEGRP sy-vline 
WA_SI_AUTHA_STR-QCTYP sy-vline 
WA_SI_AUTHA_STR-QESTATNEW sy-vline 
WA_SI_AUTHA_STR-QESTATOLD sy-vline 
WA_SI_AUTHA_STR-QINSMK sy-vline 
WA_SI_AUTHA_STR-QKATART sy-vline 
WA_SI_AUTHA_STR-QMART sy-vline 
WA_SI_AUTHA_STR-QMASTAUTH sy-vline 
WA_SI_AUTHA_STR-QMASTMOD sy-vline 
WA_SI_AUTHA_STR-QMATAUTH sy-vline 
WA_SI_AUTHA_STR-QMATMODUS sy-vline 
WA_SI_AUTHA_STR-QPLNFEAT sy-vline 
WA_SI_AUTHA_STR-QPRUEFART sy-vline 
WA_SI_AUTHA_STR-QSPCKRIT sy-vline 
WA_SI_AUTHA_STR-QSTATAWMG sy-vline 
WA_SI_AUTHA_STR-QSTATCGRP sy-vline 
WA_SI_AUTHA_STR-QSTATMERK sy-vline 
WA_SI_AUTHA_STR-QSTATMETH sy-vline 
WA_SI_AUTHA_STR-QVAUSWHLMG sy-vline 
WA_SI_AUTHA_STR-QVCODE sy-vline 
WA_SI_AUTHA_STR-QVCODEGRP sy-vline 
WA_SI_AUTHA_STR-QVEART sy-vline 
WA_SI_AUTHA_STR-RESPAREA sy-vline 
WA_SI_AUTHA_STR-RLKEY sy-vline 
WA_SI_AUTHA_STR-RSUBD sy-vline 
WA_SI_AUTHA_STR-SAMMG sy-vline 
WA_SI_AUTHA_STR-SANPNR sy-vline 
WA_SI_AUTHA_STR-SAVE_MAT sy-vline 
WA_SI_AUTHA_STR-SAVE_TERM sy-vline 
WA_SI_AUTHA_STR-SBEWART sy-vline 
WA_SI_AUTHA_STR-SBGRP sy-vline 
WA_SI_AUTHA_STR-SCTYP sy-vline 
WA_SI_AUTHA_STR-SELVS sy-vline 
WA_SI_AUTHA_STR-SETNR sy-vline 
WA_SI_AUTHA_STR-SHTYP sy-vline 
WA_SI_AUTHA_STR-SICHT sy-vline 
WA_SI_AUTHA_STR-SIGNAUTH sy-vline 
WA_SI_AUTHA_STR-SIZEC sy-vline 
WA_SI_AUTHA_STR-SKOART sy-vline 
WA_SI_AUTHA_STR-SLCAT sy-vline 
WA_SI_AUTHA_STR-SMART sy-vline 
WA_SI_AUTHA_STR-SOPOB sy-vline 
WA_SI_AUTHA_STR-SPEGR sy-vline 
WA_SI_AUTHA_STR-SSOUR sy-vline 
WA_SI_AUTHA_STR-STAFO sy-vline 
WA_SI_AUTHA_STR-STATM sy-vline 
WA_SI_AUTHA_STR-STATU sy-vline 
WA_SI_AUTHA_STR-STLAN sy-vline 
WA_SI_AUTHA_STR-STLST sy-vline 
WA_SI_AUTHA_STR-STLTY sy-vline 
WA_SI_AUTHA_STR-STSMA sy-vline 
WA_SI_AUTHA_STR-SVORG sy-vline 
WA_SI_AUTHA_STR-SWERK sy-vline 
WA_SI_AUTHA_STR-TPLST sy-vline 
WA_SI_AUTHA_STR-TRSTACT sy-vline 
WA_SI_AUTHA_STR-TV_ACTVT sy-vline 
WA_SI_AUTHA_STR-TV_BUKRS sy-vline 
WA_SI_AUTHA_STR-TV_CREAT sy-vline 
WA_SI_AUTHA_STR-TXTAR sy-vline 
WA_SI_AUTHA_STR-USR10_1 sy-vline 
WA_SI_AUTHA_STR-USR10_2 sy-vline 
WA_SI_AUTHA_STR-USR20_1 sy-vline 
WA_SI_AUTHA_STR-USR20_2 sy-vline 
WA_SI_AUTHA_STR-USRFLAG_1 sy-vline 
WA_SI_AUTHA_STR-USRFLAG_2 sy-vline 
WA_SI_AUTHA_STR-VAGRP sy-vline 
WA_SI_AUTHA_STR-VALUTYP sy-vline 
WA_SI_AUTHA_STR-VEREH sy-vline 
WA_SI_AUTHA_STR-VERNR sy-vline 
WA_SI_AUTHA_STR-VERSN sy-vline 
WA_SI_AUTHA_STR-VERWE sy-vline 
WA_SI_AUTHA_STR-VFAUT sy-vline 
WA_SI_AUTHA_STR-VIEW sy-vline 
WA_SI_AUTHA_STR-VORGANG sy-vline 
WA_SI_AUTHA_STR-VRGAR sy-vline 
WA_SI_AUTHA_STR-VRSIO sy-vline 
WA_SI_AUTHA_STR-VSTEL sy-vline 
WA_SI_AUTHA_STR-VTAUT_CONT sy-vline 
WA_SI_AUTHA_STR-VTAUT_STRU sy-vline 
WA_SI_AUTHA_STR-VZWRK sy-vline 
WA_SI_AUTHA_STR-ZEITP sy-vline 
WA_SI_AUTHA_STR-ZUSSL sy-vline      INTO ld_text SEPARATED BY SPACE.

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