ABAP Select data from SAP table FMBW_S_SCREEN 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 FMBW_S_SCREEN 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 FMBW_S_SCREEN. 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 FMBW_S_SCREEN 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_FMBW_S_SCREEN TYPE STANDARD TABLE OF FMBW_S_SCREEN,
      WA_FMBW_S_SCREEN TYPE FMBW_S_SCREEN,
      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: <FMBW_S_SCREEN> TYPE FMBW_S_SCREEN.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FMBW_S_SCREEN
*  INTO TABLE @DATA(IT_FMBW_S_SCREEN2).
*--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_FMBW_S_SCREEN INDEX 1 INTO DATA(WA_FMBW_S_SCREEN2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FMBW_S_SCREEN>-CLIENT = 1.
<FMBW_S_SCREEN>-TECHORG = 1.
<FMBW_S_SCREEN>-VALTYPE = 1.
<FMBW_S_SCREEN>-VALTYPE_TEXT = 1.
<FMBW_S_SCREEN>-DOCTYPE = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FMBW_S_SCREEN-BUDCAT, sy-vline,
  WA_FMBW_S_SCREEN-BUDCATT, sy-vline,
  WA_FMBW_S_SCREEN-PROCESS_UI, sy-vline,
  WA_FMBW_S_SCREEN-PROCESS_UIT, sy-vline,
  WA_FMBW_S_SCREEN-TRANSFERT, sy-vline,
  WA_FMBW_S_SCREEN-SBUDTYPE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FMBW_S_SCREEN 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_FMBW_S_SCREEN 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_FMBW_S_SCREEN INTO WA_FMBW_S_SCREEN.


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

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

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

*Conversion exit FMCIL, internal->external for field SCMMTITEM
CALL FUNCTION 'CONVERSION_EXIT_FMCIL_OUTPUT'
  EXPORTING
    input =                      WA_FMBW_S_SCREEN-SCMMTITEM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FMBW_S_SCREEN-SCMMTITEM.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit FMCIL, internal->external for field RCMMTITEM
CALL FUNCTION 'CONVERSION_EXIT_FMCIL_OUTPUT'
  EXPORTING
    input =                      WA_FMBW_S_SCREEN-RCMMTITEM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FMBW_S_SCREEN-RCMMTITEM.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit FMCIL, internal->external for field ICMMTITEM
CALL FUNCTION 'CONVERSION_EXIT_FMCIL_OUTPUT'
  EXPORTING
    input =                      WA_FMBW_S_SCREEN-ICMMTITEM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FMBW_S_SCREEN-ICMMTITEM.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field RCOMP
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FMBW_S_SCREEN-RCOMP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FMBW_S_SCREEN-RCOMP.
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_FMBW_S_SCREEN_STR, 
CLIENT TYPE STRING,
TECHORG TYPE STRING,
VALTYPE TYPE STRING,
VALTYPE_TEXT TYPE STRING,
DOCTYPE TYPE STRING,
BUDCAT TYPE STRING,
BUDCATT TYPE STRING,
PROCESS_UI TYPE STRING,
PROCESS_UIT TYPE STRING,
TRANSFERT TYPE STRING,
SBUDTYPE TYPE STRING,
SBUDTYPE_TEXT TYPE STRING,
RBUDTYPE TYPE STRING,
RBUDTYPE_TEXT TYPE STRING,
FM_AREA TYPE STRING,
FM_AREA_TEXT TYPE STRING,
DOCYEAR TYPE STRING,
COHORT TYPE STRING,
PUBLAW TYPE STRING,
LEGIS TYPE STRING,
SFISCYEAR TYPE STRING,
SFUNDSCTR TYPE STRING,
SFUNDSCTR_TEXT TYPE STRING,
SFUND TYPE STRING,
SFUND_TEXT TYPE STRING,
SCMMTITEM TYPE STRING,
SCMMTITEM_TEXT TYPE STRING,
SFUNCAREA TYPE STRING,
SFUNCAREA_TEXT TYPE STRING,
SMEASURE TYPE STRING,
SMEASURE_TEXT TYPE STRING,
SGRANT_NBR TYPE STRING,
SGRANT_NBR_TEXT TYPE STRING,
SUSERDIM TYPE STRING,
SUSERDIM_TEXT TYPE STRING,
SCEFFYEAR TYPE STRING,
SPERIOD TYPE STRING,
RFISCYEAR TYPE STRING,
RFUNDSCTR TYPE STRING,
RFUNDSCTR_TEXT TYPE STRING,
RFUND TYPE STRING,
RFUND_TEXT TYPE STRING,
RCMMTITEM TYPE STRING,
RCMMTITEM_TEXT TYPE STRING,
RFUNCAREA TYPE STRING,
RFUNCAREA_TEXT TYPE STRING,
RMEASURE TYPE STRING,
RMEASURE_TEXT TYPE STRING,
RGRANT_NBR TYPE STRING,
RGRANT_NBR_TEXT TYPE STRING,
RUSERDIM TYPE STRING,
RUSERDIM_TEXT TYPE STRING,
RCEFFYEAR TYPE STRING,
RPERIOD TYPE STRING,
PFISCYEAR TYPE STRING,
PPERIOD TYPE STRING,
PTVALUE TYPE STRING,
PDISTKEY TYPE STRING,
IFUNDSCTR TYPE STRING,
IFUNDSCTR_TEXT TYPE STRING,
IFUND TYPE STRING,
IFUND_TEXT TYPE STRING,
ICMMTITEM TYPE STRING,
ICMMTITEM_TEXT TYPE STRING,
IFUNCAREA TYPE STRING,
IFUNCAREA_TEXT TYPE STRING,
IMEASURE TYPE STRING,
IMEASURE_TEXT TYPE STRING,
IGRANT_NBR TYPE STRING,
IGRANT_NBR_TEXT TYPE STRING,
IUSERDIM TYPE STRING,
IUSERDIM_TEXT TYPE STRING,
IBUDTYPE TYPE STRING,
IBUDTYPE_TEXT TYPE STRING,
ICEFFYEAR TYPE STRING,
LAYOUTVAR TYPE STRING,
DOCSTATETXT TYPE STRING,
DOCDATE TYPE STRING,
POSTDATE TYPE STRING,
REASON_REV TYPE STRING,
REASON_REV_TEXT TYPE STRING,
VERSION TYPE STRING,
TCURR TYPE STRING,
TEXT50 TYPE STRING,
TEXTNAME TYPE STRING,
RESPPERS TYPE STRING,
LTXT_IND TYPE STRING,
DECIMAL_POS TYPE STRING,
LN_TEXT50 TYPE STRING,
S_TEXT50 TYPE STRING,
S_TEXTNAME TYPE STRING,
S_LTXT_IND TYPE STRING,
REV_REFNR TYPE STRING,
REVSTATETXT TYPE STRING,
DOCNR TYPE STRING,
EXT_DOCNR TYPE STRING,
DOCSTATE TYPE STRING,
REVSTATE TYPE STRING,
DOCFAM TYPE STRING,
AWORG TYPE STRING,
AWREF TYPE STRING,
AWSYS TYPE STRING,
AWTYP TYPE STRING,
TEMPI_USERNAME TYPE STRING,
TEMPI TYPE STRING,
HEADING_KF01 TYPE STRING,
HEADING_KF02 TYPE STRING,
HEADING_KF03 TYPE STRING,
HEADING_KF04 TYPE STRING,
HEADING_KF05 TYPE STRING,
FIND_DOCNR TYPE STRING,
FIND_DOCYEAR TYPE STRING,
FIND_FM_AREA TYPE STRING,
FIND_TEMPI TYPE STRING,
FIND_USERNAME TYPE STRING,
CRTUSER TYPE STRING,
CRTDATE TYPE STRING,
CRTTIME TYPE STRING,
CHGUSER TYPE STRING,
CHGDATE TYPE STRING,
CHGTIME TYPE STRING,
FIND_EFFECTIVE TYPE STRING,
FIND_HELD TYPE STRING,
SVALUE TYPE STRING,
RVALUE TYPE STRING,
SVALUE_TEXT TYPE STRING,
RVALUE_TEXT TYPE STRING,
KFCREATE_ON TYPE STRING,
KFCREATE_OFF TYPE STRING,
KFCHANGE_ON TYPE STRING,
KFCHANGE_OFF TYPE STRING,
KFREVERSE_ON TYPE STRING,
KFREVERSE_OFF TYPE STRING,
KFDISPLAY_ON TYPE STRING,
KFDISPLAY_OFF TYPE STRING,
KFSIMULATE_ON TYPE STRING,
BOX1 TYPE STRING,
BOX2 TYPE STRING,
DOCNR_FB TYPE STRING,
TRANSFER_AGENCY TYPE STRING,
TRANSFER_ACCOUNT TYPE STRING,
RCOMP TYPE STRING,
SBUDGET_PD TYPE STRING,
SBUDGET_PD_TEXT TYPE STRING,
RBUDGET_PD TYPE STRING,
RBUDGET_PD_TEXT TYPE STRING,
IBUDGET_PD TYPE STRING,
IBUDGET_PD_TEXT TYPE STRING,
SVALUE_TAB1 TYPE STRING,
RVALUE_TAB1 TYPE STRING,
FRAME_TEXT_TAB1 TYPE STRING,
SVALUE_TEXT_TAB1 TYPE STRING,
RVALUE_TEXT_TAB1 TYPE STRING,
FRAME_TEXT_TAB2 TYPE STRING,
SVALUE_TAB2 TYPE STRING,
RVALUE_TAB2 TYPE STRING,
SVALUE_TEXT_TAB2 TYPE STRING,
RVALUE_TEXT_TAB2 TYPE STRING,
SVALUE_TAB3 TYPE STRING,
RVALUE_TAB3 TYPE STRING,
FRAME_TEXT_TAB3 TYPE STRING,
SVALUE_TEXT_TAB3 TYPE STRING,
RVALUE_TEXT_TAB3 TYPE STRING,
DUMMY_EXT TYPE STRING,
BGTSRC TYPE STRING,
BGTDTL TYPE STRING,
PAYTYP TYPE STRING,
PAYKID TYPE STRING,
PROCNO TYPE STRING,
FUNCTIONALAREASUBDIVISIONID TYPE STRING,
FUNCTIONALAREA1SUBDIVISION TYPE STRING,
FUNCTIONALAREA2SUBDIVISION TYPE STRING,
FUNCTIONALAREA3SUBDIVISION TYPE STRING,
COMMITMENTITEMSUBDIVISIONID TYPE STRING,
COMMITMENTITEM1SUBDIVISION TYPE STRING,
COMMITMENTITEM2SUBDIVISION TYPE STRING,
COMMITMENTITEM3SUBDIVISION TYPE STRING,
COMMITMENTITEM4SUBDIVISION TYPE STRING,
COMMITMENTITEM5SUBDIVISION TYPE STRING,
FUNDSCENTERSUBDIVISIONID TYPE STRING,
FUNDSCENTER1SUBDIVISION TYPE STRING,
FUNDSCENTER2SUBDIVISION TYPE STRING,
FUNDSCENTER3SUBDIVISION TYPE STRING,
FUNDSSUBDIVISIONID TYPE STRING,
FUNDS1SUBDIVISION TYPE STRING,
FUNDS2SUBDIVISION TYPE STRING,
DUMMY_DISP TYPE STRING,
FUND_TEXT TYPE STRING,
BUDGET_PD_TEXT TYPE STRING,
FUNDSCTR_TEXT TYPE STRING,
CMMTITEM_TEXT TYPE STRING,
FUNCAREA_TEXT TYPE STRING,
GRANT_NBR_TEXT TYPE STRING,
MEASURE_TEXT TYPE STRING,
USERDIM_TEXT TYPE STRING,
BUDTYPE_TEXT TYPE STRING,
BUDTEXT_INDICATOR TYPE STRING,
BGTDEP TYPE STRING,
BGTDEP_TEXT TYPE STRING,
BGTSRC_TEXT TYPE STRING,
BGTDTL_TEXT TYPE STRING,
SENDTO TYPE STRING,
PAYTYP_TEXT TYPE STRING,
PAYKID_TEXT TYPE STRING,
FUNCTIONALAREA1SUBDIVISIONTEXT TYPE STRING,
FUNCTIONALAREA2SUBDIVISIONTEXT TYPE STRING,
FUNCTIONALAREA3SUBDIVISIONTEXT TYPE STRING,
COMMITMENTITEM1SUBDIVISIONTEXT TYPE STRING,
COMMITMENTITEM2SUBDIVISIONTEXT TYPE STRING,
COMMITMENTITEM3SUBDIVISIONTEXT TYPE STRING,
COMMITMENTITEM4SUBDIVISIONTEXT TYPE STRING,
COMMITMENTITEM5SUBDIVISIONTEXT TYPE STRING,
FUNDSCENTER1SUBDIVISIONTEXT TYPE STRING,
FUNDSCENTER2SUBDIVISIONTEXT TYPE STRING,
FUNDSCENTER3SUBDIVISIONTEXT TYPE STRING,
FUNDS1SUBDIVISIONTEXT TYPE STRING,
FUNDS2SUBDIVISIONTEXT TYPE STRING,
FMFGUS_KEY TYPE STRING,
DUMMY_BCS_DOC_EXT TYPE STRING,
PFM_FOA TYPE STRING,
PFM_SPEC TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FMBW_S_SCREEN_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_FMBW_S_SCREEN_STR-CLIENT sy-vline 
WA_FMBW_S_SCREEN_STR-TECHORG sy-vline 
WA_FMBW_S_SCREEN_STR-VALTYPE sy-vline 
WA_FMBW_S_SCREEN_STR-VALTYPE_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-DOCTYPE sy-vline 
WA_FMBW_S_SCREEN_STR-BUDCAT sy-vline 
WA_FMBW_S_SCREEN_STR-BUDCATT sy-vline 
WA_FMBW_S_SCREEN_STR-PROCESS_UI sy-vline 
WA_FMBW_S_SCREEN_STR-PROCESS_UIT sy-vline 
WA_FMBW_S_SCREEN_STR-TRANSFERT sy-vline 
WA_FMBW_S_SCREEN_STR-SBUDTYPE sy-vline 
WA_FMBW_S_SCREEN_STR-SBUDTYPE_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-RBUDTYPE sy-vline 
WA_FMBW_S_SCREEN_STR-RBUDTYPE_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-FM_AREA sy-vline 
WA_FMBW_S_SCREEN_STR-FM_AREA_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-DOCYEAR sy-vline 
WA_FMBW_S_SCREEN_STR-COHORT sy-vline 
WA_FMBW_S_SCREEN_STR-PUBLAW sy-vline 
WA_FMBW_S_SCREEN_STR-LEGIS sy-vline 
WA_FMBW_S_SCREEN_STR-SFISCYEAR sy-vline 
WA_FMBW_S_SCREEN_STR-SFUNDSCTR sy-vline 
WA_FMBW_S_SCREEN_STR-SFUNDSCTR_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-SFUND sy-vline 
WA_FMBW_S_SCREEN_STR-SFUND_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-SCMMTITEM sy-vline 
WA_FMBW_S_SCREEN_STR-SCMMTITEM_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-SFUNCAREA sy-vline 
WA_FMBW_S_SCREEN_STR-SFUNCAREA_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-SMEASURE sy-vline 
WA_FMBW_S_SCREEN_STR-SMEASURE_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-SGRANT_NBR sy-vline 
WA_FMBW_S_SCREEN_STR-SGRANT_NBR_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-SUSERDIM sy-vline 
WA_FMBW_S_SCREEN_STR-SUSERDIM_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-SCEFFYEAR sy-vline 
WA_FMBW_S_SCREEN_STR-SPERIOD sy-vline 
WA_FMBW_S_SCREEN_STR-RFISCYEAR sy-vline 
WA_FMBW_S_SCREEN_STR-RFUNDSCTR sy-vline 
WA_FMBW_S_SCREEN_STR-RFUNDSCTR_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-RFUND sy-vline 
WA_FMBW_S_SCREEN_STR-RFUND_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-RCMMTITEM sy-vline 
WA_FMBW_S_SCREEN_STR-RCMMTITEM_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-RFUNCAREA sy-vline 
WA_FMBW_S_SCREEN_STR-RFUNCAREA_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-RMEASURE sy-vline 
WA_FMBW_S_SCREEN_STR-RMEASURE_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-RGRANT_NBR sy-vline 
WA_FMBW_S_SCREEN_STR-RGRANT_NBR_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-RUSERDIM sy-vline 
WA_FMBW_S_SCREEN_STR-RUSERDIM_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-RCEFFYEAR sy-vline 
WA_FMBW_S_SCREEN_STR-RPERIOD sy-vline 
WA_FMBW_S_SCREEN_STR-PFISCYEAR sy-vline 
WA_FMBW_S_SCREEN_STR-PPERIOD sy-vline 
WA_FMBW_S_SCREEN_STR-PTVALUE sy-vline 
WA_FMBW_S_SCREEN_STR-PDISTKEY sy-vline 
WA_FMBW_S_SCREEN_STR-IFUNDSCTR sy-vline 
WA_FMBW_S_SCREEN_STR-IFUNDSCTR_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-IFUND sy-vline 
WA_FMBW_S_SCREEN_STR-IFUND_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-ICMMTITEM sy-vline 
WA_FMBW_S_SCREEN_STR-ICMMTITEM_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-IFUNCAREA sy-vline 
WA_FMBW_S_SCREEN_STR-IFUNCAREA_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-IMEASURE sy-vline 
WA_FMBW_S_SCREEN_STR-IMEASURE_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-IGRANT_NBR sy-vline 
WA_FMBW_S_SCREEN_STR-IGRANT_NBR_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-IUSERDIM sy-vline 
WA_FMBW_S_SCREEN_STR-IUSERDIM_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-IBUDTYPE sy-vline 
WA_FMBW_S_SCREEN_STR-IBUDTYPE_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-ICEFFYEAR sy-vline 
WA_FMBW_S_SCREEN_STR-LAYOUTVAR sy-vline 
WA_FMBW_S_SCREEN_STR-DOCSTATETXT sy-vline 
WA_FMBW_S_SCREEN_STR-DOCDATE sy-vline 
WA_FMBW_S_SCREEN_STR-POSTDATE sy-vline 
WA_FMBW_S_SCREEN_STR-REASON_REV sy-vline 
WA_FMBW_S_SCREEN_STR-REASON_REV_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-VERSION sy-vline 
WA_FMBW_S_SCREEN_STR-TCURR sy-vline 
WA_FMBW_S_SCREEN_STR-TEXT50 sy-vline 
WA_FMBW_S_SCREEN_STR-TEXTNAME sy-vline 
WA_FMBW_S_SCREEN_STR-RESPPERS sy-vline 
WA_FMBW_S_SCREEN_STR-LTXT_IND sy-vline 
WA_FMBW_S_SCREEN_STR-DECIMAL_POS sy-vline 
WA_FMBW_S_SCREEN_STR-LN_TEXT50 sy-vline 
WA_FMBW_S_SCREEN_STR-S_TEXT50 sy-vline 
WA_FMBW_S_SCREEN_STR-S_TEXTNAME sy-vline 
WA_FMBW_S_SCREEN_STR-S_LTXT_IND sy-vline 
WA_FMBW_S_SCREEN_STR-REV_REFNR sy-vline 
WA_FMBW_S_SCREEN_STR-REVSTATETXT sy-vline 
WA_FMBW_S_SCREEN_STR-DOCNR sy-vline 
WA_FMBW_S_SCREEN_STR-EXT_DOCNR sy-vline 
WA_FMBW_S_SCREEN_STR-DOCSTATE sy-vline 
WA_FMBW_S_SCREEN_STR-REVSTATE sy-vline 
WA_FMBW_S_SCREEN_STR-DOCFAM sy-vline 
WA_FMBW_S_SCREEN_STR-AWORG sy-vline 
WA_FMBW_S_SCREEN_STR-AWREF sy-vline 
WA_FMBW_S_SCREEN_STR-AWSYS sy-vline 
WA_FMBW_S_SCREEN_STR-AWTYP sy-vline 
WA_FMBW_S_SCREEN_STR-TEMPI_USERNAME sy-vline 
WA_FMBW_S_SCREEN_STR-TEMPI sy-vline 
WA_FMBW_S_SCREEN_STR-HEADING_KF01 sy-vline 
WA_FMBW_S_SCREEN_STR-HEADING_KF02 sy-vline 
WA_FMBW_S_SCREEN_STR-HEADING_KF03 sy-vline 
WA_FMBW_S_SCREEN_STR-HEADING_KF04 sy-vline 
WA_FMBW_S_SCREEN_STR-HEADING_KF05 sy-vline 
WA_FMBW_S_SCREEN_STR-FIND_DOCNR sy-vline 
WA_FMBW_S_SCREEN_STR-FIND_DOCYEAR sy-vline 
WA_FMBW_S_SCREEN_STR-FIND_FM_AREA sy-vline 
WA_FMBW_S_SCREEN_STR-FIND_TEMPI sy-vline 
WA_FMBW_S_SCREEN_STR-FIND_USERNAME sy-vline 
WA_FMBW_S_SCREEN_STR-CRTUSER sy-vline 
WA_FMBW_S_SCREEN_STR-CRTDATE sy-vline 
WA_FMBW_S_SCREEN_STR-CRTTIME sy-vline 
WA_FMBW_S_SCREEN_STR-CHGUSER sy-vline 
WA_FMBW_S_SCREEN_STR-CHGDATE sy-vline 
WA_FMBW_S_SCREEN_STR-CHGTIME sy-vline 
WA_FMBW_S_SCREEN_STR-FIND_EFFECTIVE sy-vline 
WA_FMBW_S_SCREEN_STR-FIND_HELD sy-vline 
WA_FMBW_S_SCREEN_STR-SVALUE sy-vline 
WA_FMBW_S_SCREEN_STR-RVALUE sy-vline 
WA_FMBW_S_SCREEN_STR-SVALUE_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-RVALUE_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-KFCREATE_ON sy-vline 
WA_FMBW_S_SCREEN_STR-KFCREATE_OFF sy-vline 
WA_FMBW_S_SCREEN_STR-KFCHANGE_ON sy-vline 
WA_FMBW_S_SCREEN_STR-KFCHANGE_OFF sy-vline 
WA_FMBW_S_SCREEN_STR-KFREVERSE_ON sy-vline 
WA_FMBW_S_SCREEN_STR-KFREVERSE_OFF sy-vline 
WA_FMBW_S_SCREEN_STR-KFDISPLAY_ON sy-vline 
WA_FMBW_S_SCREEN_STR-KFDISPLAY_OFF sy-vline 
WA_FMBW_S_SCREEN_STR-KFSIMULATE_ON sy-vline 
WA_FMBW_S_SCREEN_STR-BOX1 sy-vline 
WA_FMBW_S_SCREEN_STR-BOX2 sy-vline 
WA_FMBW_S_SCREEN_STR-DOCNR_FB sy-vline 
WA_FMBW_S_SCREEN_STR-TRANSFER_AGENCY sy-vline 
WA_FMBW_S_SCREEN_STR-TRANSFER_ACCOUNT sy-vline 
WA_FMBW_S_SCREEN_STR-RCOMP sy-vline 
WA_FMBW_S_SCREEN_STR-SBUDGET_PD sy-vline 
WA_FMBW_S_SCREEN_STR-SBUDGET_PD_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-RBUDGET_PD sy-vline 
WA_FMBW_S_SCREEN_STR-RBUDGET_PD_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-IBUDGET_PD sy-vline 
WA_FMBW_S_SCREEN_STR-IBUDGET_PD_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-SVALUE_TAB1 sy-vline 
WA_FMBW_S_SCREEN_STR-RVALUE_TAB1 sy-vline 
WA_FMBW_S_SCREEN_STR-FRAME_TEXT_TAB1 sy-vline 
WA_FMBW_S_SCREEN_STR-SVALUE_TEXT_TAB1 sy-vline 
WA_FMBW_S_SCREEN_STR-RVALUE_TEXT_TAB1 sy-vline 
WA_FMBW_S_SCREEN_STR-FRAME_TEXT_TAB2 sy-vline 
WA_FMBW_S_SCREEN_STR-SVALUE_TAB2 sy-vline 
WA_FMBW_S_SCREEN_STR-RVALUE_TAB2 sy-vline 
WA_FMBW_S_SCREEN_STR-SVALUE_TEXT_TAB2 sy-vline 
WA_FMBW_S_SCREEN_STR-RVALUE_TEXT_TAB2 sy-vline 
WA_FMBW_S_SCREEN_STR-SVALUE_TAB3 sy-vline 
WA_FMBW_S_SCREEN_STR-RVALUE_TAB3 sy-vline 
WA_FMBW_S_SCREEN_STR-FRAME_TEXT_TAB3 sy-vline 
WA_FMBW_S_SCREEN_STR-SVALUE_TEXT_TAB3 sy-vline 
WA_FMBW_S_SCREEN_STR-RVALUE_TEXT_TAB3 sy-vline 
WA_FMBW_S_SCREEN_STR-DUMMY_EXT sy-vline 
WA_FMBW_S_SCREEN_STR-BGTSRC sy-vline 
WA_FMBW_S_SCREEN_STR-BGTDTL sy-vline 
WA_FMBW_S_SCREEN_STR-PAYTYP sy-vline 
WA_FMBW_S_SCREEN_STR-PAYKID sy-vline 
WA_FMBW_S_SCREEN_STR-PROCNO sy-vline 
WA_FMBW_S_SCREEN_STR-FUNCTIONALAREASUBDIVISIONID sy-vline 
WA_FMBW_S_SCREEN_STR-FUNCTIONALAREA1SUBDIVISION sy-vline 
WA_FMBW_S_SCREEN_STR-FUNCTIONALAREA2SUBDIVISION sy-vline 
WA_FMBW_S_SCREEN_STR-FUNCTIONALAREA3SUBDIVISION sy-vline 
WA_FMBW_S_SCREEN_STR-COMMITMENTITEMSUBDIVISIONID sy-vline 
WA_FMBW_S_SCREEN_STR-COMMITMENTITEM1SUBDIVISION sy-vline 
WA_FMBW_S_SCREEN_STR-COMMITMENTITEM2SUBDIVISION sy-vline 
WA_FMBW_S_SCREEN_STR-COMMITMENTITEM3SUBDIVISION sy-vline 
WA_FMBW_S_SCREEN_STR-COMMITMENTITEM4SUBDIVISION sy-vline 
WA_FMBW_S_SCREEN_STR-COMMITMENTITEM5SUBDIVISION sy-vline 
WA_FMBW_S_SCREEN_STR-FUNDSCENTERSUBDIVISIONID sy-vline 
WA_FMBW_S_SCREEN_STR-FUNDSCENTER1SUBDIVISION sy-vline 
WA_FMBW_S_SCREEN_STR-FUNDSCENTER2SUBDIVISION sy-vline 
WA_FMBW_S_SCREEN_STR-FUNDSCENTER3SUBDIVISION sy-vline 
WA_FMBW_S_SCREEN_STR-FUNDSSUBDIVISIONID sy-vline 
WA_FMBW_S_SCREEN_STR-FUNDS1SUBDIVISION sy-vline 
WA_FMBW_S_SCREEN_STR-FUNDS2SUBDIVISION sy-vline 
WA_FMBW_S_SCREEN_STR-DUMMY_DISP sy-vline 
WA_FMBW_S_SCREEN_STR-FUND_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-BUDGET_PD_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-FUNDSCTR_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-CMMTITEM_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-FUNCAREA_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-GRANT_NBR_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-MEASURE_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-USERDIM_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-BUDTYPE_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-BUDTEXT_INDICATOR sy-vline 
WA_FMBW_S_SCREEN_STR-BGTDEP sy-vline 
WA_FMBW_S_SCREEN_STR-BGTDEP_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-BGTSRC_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-BGTDTL_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-SENDTO sy-vline 
WA_FMBW_S_SCREEN_STR-PAYTYP_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-PAYKID_TEXT sy-vline 
WA_FMBW_S_SCREEN_STR-FUNCTIONALAREA1SUBDIVISIONTEXT sy-vline 
WA_FMBW_S_SCREEN_STR-FUNCTIONALAREA2SUBDIVISIONTEXT sy-vline 
WA_FMBW_S_SCREEN_STR-FUNCTIONALAREA3SUBDIVISIONTEXT sy-vline 
WA_FMBW_S_SCREEN_STR-COMMITMENTITEM1SUBDIVISIONTEXT sy-vline 
WA_FMBW_S_SCREEN_STR-COMMITMENTITEM2SUBDIVISIONTEXT sy-vline 
WA_FMBW_S_SCREEN_STR-COMMITMENTITEM3SUBDIVISIONTEXT sy-vline 
WA_FMBW_S_SCREEN_STR-COMMITMENTITEM4SUBDIVISIONTEXT sy-vline 
WA_FMBW_S_SCREEN_STR-COMMITMENTITEM5SUBDIVISIONTEXT sy-vline 
WA_FMBW_S_SCREEN_STR-FUNDSCENTER1SUBDIVISIONTEXT sy-vline 
WA_FMBW_S_SCREEN_STR-FUNDSCENTER2SUBDIVISIONTEXT sy-vline 
WA_FMBW_S_SCREEN_STR-FUNDSCENTER3SUBDIVISIONTEXT sy-vline 
WA_FMBW_S_SCREEN_STR-FUNDS1SUBDIVISIONTEXT sy-vline 
WA_FMBW_S_SCREEN_STR-FUNDS2SUBDIVISIONTEXT sy-vline 
WA_FMBW_S_SCREEN_STR-FMFGUS_KEY sy-vline 
WA_FMBW_S_SCREEN_STR-DUMMY_BCS_DOC_EXT sy-vline 
WA_FMBW_S_SCREEN_STR-PFM_FOA sy-vline 
WA_FMBW_S_SCREEN_STR-PFM_SPEC sy-vline      INTO ld_text SEPARATED BY SPACE.

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