ABAP Select data from SAP table FMAA_BO_CG 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 FMAA_BO_CG 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 FMAA_BO_CG. 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 FMAA_BO_CG 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_FMAA_BO_CG TYPE STANDARD TABLE OF FMAA_BO_CG,
      WA_FMAA_BO_CG TYPE FMAA_BO_CG,
      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: <FMAA_BO_CG> TYPE FMAA_BO_CG.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FMAA_BO_CG
*  INTO TABLE @DATA(IT_FMAA_BO_CG2).
*--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_FMAA_BO_CG INDEX 1 INTO DATA(WA_FMAA_BO_CG2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FMAA_BO_CG>-GJAHR = 1.
<FMAA_BO_CG>-FONDS = 1.
<FMAA_BO_CG>-FNAME = 1.
<FMAA_BO_CG>-FDSCR = 1.
<FMAA_BO_CG>-SPONSOR = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FMAA_BO_CG-NAME1_FONDS, sy-vline,
  WA_FMAA_BO_CG-FINUSE, sy-vline,
  WA_FMAA_BO_CG-UNAME, sy-vline,
  WA_FMAA_BO_CG-UDSCR, sy-vline,
  WA_FMAA_BO_CG-AUGRP_FONDS, sy-vline,
  WA_FMAA_BO_CG-FUND_TYPE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FMAA_BO_CG 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_FMAA_BO_CG 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_FMAA_BO_CG INTO WA_FMAA_BO_CG.


*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 GJAHR, internal->external for field GJAHR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_FMAA_BO_CG-GJAHR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FMAA_BO_CG-GJAHR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

*Conversion exit FMCIS, internal->external for field FIPOS
CALL FUNCTION 'CONVERSION_EXIT_FMCIS_OUTPUT'
  EXPORTING
    input =                      WA_FMAA_BO_CG-FIPOS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FMAA_BO_CG-FIPOS.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ALPHA, internal->external for field GRANT_NBR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FMAA_BO_CG-GRANT_NBR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FMAA_BO_CG-GRANT_NBR.
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_FMAA_BO_CG_STR, 
GJAHR TYPE STRING,
FONDS TYPE STRING,
FNAME TYPE STRING,
FDSCR TYPE STRING,
SPONSOR TYPE STRING,
NAME1_FONDS TYPE STRING,
FINUSE TYPE STRING,
UNAME TYPE STRING,
UDSCR TYPE STRING,
AUGRP_FONDS TYPE STRING,
FUND_TYPE TYPE STRING,
FUND_TYPET TYPE STRING,
PROFIL TYPE STRING,
KZBST TYPE STRING,
ERFNAME_FONDS TYPE STRING,
ERFDAT_FONDS TYPE STRING,
AENNAME_FONDS TYPE STRING,
AENDAT_FONDS TYPE STRING,
DATAB_FONDS TYPE STRING,
DATBIS_FONDS TYPE STRING,
PERIV TYPE STRING,
DATE_EXP TYPE STRING,
DATE_CAN TYPE STRING,
LOGSYSTEM_FONDS TYPE STRING,
FDSTR_ID TYPE STRING,
FDSUB1 TYPE STRING,
FDSUB2 TYPE STRING,
FDSUB1T_SH TYPE STRING,
FDSUB1T_LO TYPE STRING,
FDSUB2T_SH TYPE STRING,
FDSUB2T_LO TYPE STRING,
FICTR TYPE STRING,
CNAME TYPE STRING,
CDSCR TYPE STRING,
CLEVL TYPE STRING,
HIVARNT TYPE STRING,
FICTR_UP TYPE STRING,
CTR_OBJNR TYPE STRING,
DATBIS TYPE STRING,
DATAB TYPE STRING,
AUGRP_FICTR TYPE STRING,
ERFDAT_FICTR TYPE STRING,
ERFNAME_FICTR TYPE STRING,
AENDAT_FICTR TYPE STRING,
AENNAME_FICTR TYPE STRING,
WAERS TYPE STRING,
BUKRS TYPE STRING,
GSBER TYPE STRING,
LOGSYSTEM_FICTR TYPE STRING,
BOSS_CODE TYPE STRING,
BOSSOT TYPE STRING,
BOSSID TYPE STRING,
BOSSNAME TYPE STRING,
DFINCODE TYPE STRING,
FCSTR_ID TYPE STRING,
FCSUB1 TYPE STRING,
FCSUB2 TYPE STRING,
FCSUB3 TYPE STRING,
FCSUB1T_SH TYPE STRING,
FCSUB1T_LO TYPE STRING,
FCSUB2T_SH TYPE STRING,
FCSUB2T_LO TYPE STRING,
FCSUB3T_SH TYPE STRING,
FCSUB3T_LO TYPE STRING,
VARNT TYPE STRING,
FIPEX TYPE STRING,
PNAME TYPE STRING,
TEXT1 TYPE STRING,
TEXT2 TYPE STRING,
TEXT3 TYPE STRING,
PLEVL TYPE STRING,
DFICTR TYPE STRING,
VPTYP TYPE STRING,
SNTYP TYPE STRING,
SNROL TYPE STRING,
NDAKZ TYPE STRING,
AZPKZ TYPE STRING,
KRGRP TYPE STRING,
AUGRP_FIPEX TYPE STRING,
STATS TYPE STRING,
NCBUD TYPE STRING,
POSIT TYPE STRING,
STVAR TYPE STRING,
NEGBUD TYPE STRING,
LOGSYSTEM_FIPEX TYPE STRING,
BUTYP TYPE STRING,
EFICTR TYPE STRING,
EFIPEX1 TYPE STRING,
EFIPEX2 TYPE STRING,
EFIPEX3 TYPE STRING,
EFIPEX4 TYPE STRING,
EFIPEX5 TYPE STRING,
CISTR_ID TYPE STRING,
CISUB1 TYPE STRING,
CISUB2 TYPE STRING,
CISUB3 TYPE STRING,
CISUB4 TYPE STRING,
CISUB5 TYPE STRING,
CISUB1T_SH TYPE STRING,
CISUB1T_LO TYPE STRING,
CISUB2T_SH TYPE STRING,
CISUB2T_LO TYPE STRING,
CISUB3T_SH TYPE STRING,
CISUB3T_LO TYPE STRING,
CISUB4T_SH TYPE STRING,
CISUB4T_LO TYPE STRING,
CISUB5T_SH TYPE STRING,
CISUB5T_LO TYPE STRING,
KATEG TYPE STRING,
FIVOR TYPE STRING,
POTYP TYPE STRING,
KRTYP TYPE STRING,
FPART TYPE STRING,
FIPOS TYPE STRING,
FIPUP TYPE STRING,
HSART TYPE STRING,
GKFLG TYPE STRING,
DRUCK TYPE STRING,
CFFLG TYPE STRING,
CVFLG TYPE STRING,
BEZIRK TYPE STRING,
BSAMT TYPE STRING,
UBFLG TYPE STRING,
HSFLG TYPE STRING,
H_ID TYPE STRING,
POST_CARRIER TYPE STRING,
BUDGET_CARRIER TYPE STRING,
FAREA TYPE STRING,
FTEXT TYPE STRING,
FNSTR_ID TYPE STRING,
FNSUB1 TYPE STRING,
FNSUB2 TYPE STRING,
FNSUB3 TYPE STRING,
FNSUB1T_SH TYPE STRING,
FNSUB1T_LO TYPE STRING,
FNSUB2T_SH TYPE STRING,
FNSUB2T_LO TYPE STRING,
FNSUB3T_SH TYPE STRING,
FNSUB3T_LO TYPE STRING,
MEASURE TYPE STRING,
FP_CATEGORY TYPE STRING,
FP_TYPE TYPE STRING,
ME_VALID_FROM TYPE STRING,
ME_VALID_TO TYPE STRING,
ME_AUTHGRP TYPE STRING,
ME_SHORT_DESC TYPE STRING,
ME_DESCRIPTION TYPE STRING,
GRANT_NBR TYPE STRING,
GM_VALID_FROM TYPE STRING,
GM_VALID_TO TYPE STRING,
GRANT_TYPE TYPE STRING,
GM_AUTHGR TYPE STRING,
GM_SHORT_DESC TYPE STRING,
GM_DESCRIPTION TYPE STRING,
DECKRNG TYPE STRING,
DNAME TYPE STRING,
DEAKTIV TYPE STRING,
HVMTNR TYPE STRING,
REV_EXP_CVP TYPE STRING,
REV_EXP_CVPT TYPE STRING,
BUDGET_PD TYPE STRING,
BUDGET_PD_NAME TYPE STRING,
DATAB_BUDPER TYPE STRING,
DATBIS_BUDPER TYPE STRING,
AUTHGRP_BUDPER TYPE STRING,
DATE_EXP_BUDPER TYPE STRING,
DATE_CAN_BUDPER TYPE STRING,
USERDIM TYPE STRING,
CVRGRP TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FMAA_BO_CG_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_FMAA_BO_CG_STR-GJAHR sy-vline 
WA_FMAA_BO_CG_STR-FONDS sy-vline 
WA_FMAA_BO_CG_STR-FNAME sy-vline 
WA_FMAA_BO_CG_STR-FDSCR sy-vline 
WA_FMAA_BO_CG_STR-SPONSOR sy-vline 
WA_FMAA_BO_CG_STR-NAME1_FONDS sy-vline 
WA_FMAA_BO_CG_STR-FINUSE sy-vline 
WA_FMAA_BO_CG_STR-UNAME sy-vline 
WA_FMAA_BO_CG_STR-UDSCR sy-vline 
WA_FMAA_BO_CG_STR-AUGRP_FONDS sy-vline 
WA_FMAA_BO_CG_STR-FUND_TYPE sy-vline 
WA_FMAA_BO_CG_STR-FUND_TYPET sy-vline 
WA_FMAA_BO_CG_STR-PROFIL sy-vline 
WA_FMAA_BO_CG_STR-KZBST sy-vline 
WA_FMAA_BO_CG_STR-ERFNAME_FONDS sy-vline 
WA_FMAA_BO_CG_STR-ERFDAT_FONDS sy-vline 
WA_FMAA_BO_CG_STR-AENNAME_FONDS sy-vline 
WA_FMAA_BO_CG_STR-AENDAT_FONDS sy-vline 
WA_FMAA_BO_CG_STR-DATAB_FONDS sy-vline 
WA_FMAA_BO_CG_STR-DATBIS_FONDS sy-vline 
WA_FMAA_BO_CG_STR-PERIV sy-vline 
WA_FMAA_BO_CG_STR-DATE_EXP sy-vline 
WA_FMAA_BO_CG_STR-DATE_CAN sy-vline 
WA_FMAA_BO_CG_STR-LOGSYSTEM_FONDS sy-vline 
WA_FMAA_BO_CG_STR-FDSTR_ID sy-vline 
WA_FMAA_BO_CG_STR-FDSUB1 sy-vline 
WA_FMAA_BO_CG_STR-FDSUB2 sy-vline 
WA_FMAA_BO_CG_STR-FDSUB1T_SH sy-vline 
WA_FMAA_BO_CG_STR-FDSUB1T_LO sy-vline 
WA_FMAA_BO_CG_STR-FDSUB2T_SH sy-vline 
WA_FMAA_BO_CG_STR-FDSUB2T_LO sy-vline 
WA_FMAA_BO_CG_STR-FICTR sy-vline 
WA_FMAA_BO_CG_STR-CNAME sy-vline 
WA_FMAA_BO_CG_STR-CDSCR sy-vline 
WA_FMAA_BO_CG_STR-CLEVL sy-vline 
WA_FMAA_BO_CG_STR-HIVARNT sy-vline 
WA_FMAA_BO_CG_STR-FICTR_UP sy-vline 
WA_FMAA_BO_CG_STR-CTR_OBJNR sy-vline 
WA_FMAA_BO_CG_STR-DATBIS sy-vline 
WA_FMAA_BO_CG_STR-DATAB sy-vline 
WA_FMAA_BO_CG_STR-AUGRP_FICTR sy-vline 
WA_FMAA_BO_CG_STR-ERFDAT_FICTR sy-vline 
WA_FMAA_BO_CG_STR-ERFNAME_FICTR sy-vline 
WA_FMAA_BO_CG_STR-AENDAT_FICTR sy-vline 
WA_FMAA_BO_CG_STR-AENNAME_FICTR sy-vline 
WA_FMAA_BO_CG_STR-WAERS sy-vline 
WA_FMAA_BO_CG_STR-BUKRS sy-vline 
WA_FMAA_BO_CG_STR-GSBER sy-vline 
WA_FMAA_BO_CG_STR-LOGSYSTEM_FICTR sy-vline 
WA_FMAA_BO_CG_STR-BOSS_CODE sy-vline 
WA_FMAA_BO_CG_STR-BOSSOT sy-vline 
WA_FMAA_BO_CG_STR-BOSSID sy-vline 
WA_FMAA_BO_CG_STR-BOSSNAME sy-vline 
WA_FMAA_BO_CG_STR-DFINCODE sy-vline 
WA_FMAA_BO_CG_STR-FCSTR_ID sy-vline 
WA_FMAA_BO_CG_STR-FCSUB1 sy-vline 
WA_FMAA_BO_CG_STR-FCSUB2 sy-vline 
WA_FMAA_BO_CG_STR-FCSUB3 sy-vline 
WA_FMAA_BO_CG_STR-FCSUB1T_SH sy-vline 
WA_FMAA_BO_CG_STR-FCSUB1T_LO sy-vline 
WA_FMAA_BO_CG_STR-FCSUB2T_SH sy-vline 
WA_FMAA_BO_CG_STR-FCSUB2T_LO sy-vline 
WA_FMAA_BO_CG_STR-FCSUB3T_SH sy-vline 
WA_FMAA_BO_CG_STR-FCSUB3T_LO sy-vline 
WA_FMAA_BO_CG_STR-VARNT sy-vline 
WA_FMAA_BO_CG_STR-FIPEX sy-vline 
WA_FMAA_BO_CG_STR-PNAME sy-vline 
WA_FMAA_BO_CG_STR-TEXT1 sy-vline 
WA_FMAA_BO_CG_STR-TEXT2 sy-vline 
WA_FMAA_BO_CG_STR-TEXT3 sy-vline 
WA_FMAA_BO_CG_STR-PLEVL sy-vline 
WA_FMAA_BO_CG_STR-DFICTR sy-vline 
WA_FMAA_BO_CG_STR-VPTYP sy-vline 
WA_FMAA_BO_CG_STR-SNTYP sy-vline 
WA_FMAA_BO_CG_STR-SNROL sy-vline 
WA_FMAA_BO_CG_STR-NDAKZ sy-vline 
WA_FMAA_BO_CG_STR-AZPKZ sy-vline 
WA_FMAA_BO_CG_STR-KRGRP sy-vline 
WA_FMAA_BO_CG_STR-AUGRP_FIPEX sy-vline 
WA_FMAA_BO_CG_STR-STATS sy-vline 
WA_FMAA_BO_CG_STR-NCBUD sy-vline 
WA_FMAA_BO_CG_STR-POSIT sy-vline 
WA_FMAA_BO_CG_STR-STVAR sy-vline 
WA_FMAA_BO_CG_STR-NEGBUD sy-vline 
WA_FMAA_BO_CG_STR-LOGSYSTEM_FIPEX sy-vline 
WA_FMAA_BO_CG_STR-BUTYP sy-vline 
WA_FMAA_BO_CG_STR-EFICTR sy-vline 
WA_FMAA_BO_CG_STR-EFIPEX1 sy-vline 
WA_FMAA_BO_CG_STR-EFIPEX2 sy-vline 
WA_FMAA_BO_CG_STR-EFIPEX3 sy-vline 
WA_FMAA_BO_CG_STR-EFIPEX4 sy-vline 
WA_FMAA_BO_CG_STR-EFIPEX5 sy-vline 
WA_FMAA_BO_CG_STR-CISTR_ID sy-vline 
WA_FMAA_BO_CG_STR-CISUB1 sy-vline 
WA_FMAA_BO_CG_STR-CISUB2 sy-vline 
WA_FMAA_BO_CG_STR-CISUB3 sy-vline 
WA_FMAA_BO_CG_STR-CISUB4 sy-vline 
WA_FMAA_BO_CG_STR-CISUB5 sy-vline 
WA_FMAA_BO_CG_STR-CISUB1T_SH sy-vline 
WA_FMAA_BO_CG_STR-CISUB1T_LO sy-vline 
WA_FMAA_BO_CG_STR-CISUB2T_SH sy-vline 
WA_FMAA_BO_CG_STR-CISUB2T_LO sy-vline 
WA_FMAA_BO_CG_STR-CISUB3T_SH sy-vline 
WA_FMAA_BO_CG_STR-CISUB3T_LO sy-vline 
WA_FMAA_BO_CG_STR-CISUB4T_SH sy-vline 
WA_FMAA_BO_CG_STR-CISUB4T_LO sy-vline 
WA_FMAA_BO_CG_STR-CISUB5T_SH sy-vline 
WA_FMAA_BO_CG_STR-CISUB5T_LO sy-vline 
WA_FMAA_BO_CG_STR-KATEG sy-vline 
WA_FMAA_BO_CG_STR-FIVOR sy-vline 
WA_FMAA_BO_CG_STR-POTYP sy-vline 
WA_FMAA_BO_CG_STR-KRTYP sy-vline 
WA_FMAA_BO_CG_STR-FPART sy-vline 
WA_FMAA_BO_CG_STR-FIPOS sy-vline 
WA_FMAA_BO_CG_STR-FIPUP sy-vline 
WA_FMAA_BO_CG_STR-HSART sy-vline 
WA_FMAA_BO_CG_STR-GKFLG sy-vline 
WA_FMAA_BO_CG_STR-DRUCK sy-vline 
WA_FMAA_BO_CG_STR-CFFLG sy-vline 
WA_FMAA_BO_CG_STR-CVFLG sy-vline 
WA_FMAA_BO_CG_STR-BEZIRK sy-vline 
WA_FMAA_BO_CG_STR-BSAMT sy-vline 
WA_FMAA_BO_CG_STR-UBFLG sy-vline 
WA_FMAA_BO_CG_STR-HSFLG sy-vline 
WA_FMAA_BO_CG_STR-H_ID sy-vline 
WA_FMAA_BO_CG_STR-POST_CARRIER sy-vline 
WA_FMAA_BO_CG_STR-BUDGET_CARRIER sy-vline 
WA_FMAA_BO_CG_STR-FAREA sy-vline 
WA_FMAA_BO_CG_STR-FTEXT sy-vline 
WA_FMAA_BO_CG_STR-FNSTR_ID sy-vline 
WA_FMAA_BO_CG_STR-FNSUB1 sy-vline 
WA_FMAA_BO_CG_STR-FNSUB2 sy-vline 
WA_FMAA_BO_CG_STR-FNSUB3 sy-vline 
WA_FMAA_BO_CG_STR-FNSUB1T_SH sy-vline 
WA_FMAA_BO_CG_STR-FNSUB1T_LO sy-vline 
WA_FMAA_BO_CG_STR-FNSUB2T_SH sy-vline 
WA_FMAA_BO_CG_STR-FNSUB2T_LO sy-vline 
WA_FMAA_BO_CG_STR-FNSUB3T_SH sy-vline 
WA_FMAA_BO_CG_STR-FNSUB3T_LO sy-vline 
WA_FMAA_BO_CG_STR-MEASURE sy-vline 
WA_FMAA_BO_CG_STR-FP_CATEGORY sy-vline 
WA_FMAA_BO_CG_STR-FP_TYPE sy-vline 
WA_FMAA_BO_CG_STR-ME_VALID_FROM sy-vline 
WA_FMAA_BO_CG_STR-ME_VALID_TO sy-vline 
WA_FMAA_BO_CG_STR-ME_AUTHGRP sy-vline 
WA_FMAA_BO_CG_STR-ME_SHORT_DESC sy-vline 
WA_FMAA_BO_CG_STR-ME_DESCRIPTION sy-vline 
WA_FMAA_BO_CG_STR-GRANT_NBR sy-vline 
WA_FMAA_BO_CG_STR-GM_VALID_FROM sy-vline 
WA_FMAA_BO_CG_STR-GM_VALID_TO sy-vline 
WA_FMAA_BO_CG_STR-GRANT_TYPE sy-vline 
WA_FMAA_BO_CG_STR-GM_AUTHGR sy-vline 
WA_FMAA_BO_CG_STR-GM_SHORT_DESC sy-vline 
WA_FMAA_BO_CG_STR-GM_DESCRIPTION sy-vline 
WA_FMAA_BO_CG_STR-DECKRNG sy-vline 
WA_FMAA_BO_CG_STR-DNAME sy-vline 
WA_FMAA_BO_CG_STR-DEAKTIV sy-vline 
WA_FMAA_BO_CG_STR-HVMTNR sy-vline 
WA_FMAA_BO_CG_STR-REV_EXP_CVP sy-vline 
WA_FMAA_BO_CG_STR-REV_EXP_CVPT sy-vline 
WA_FMAA_BO_CG_STR-BUDGET_PD sy-vline 
WA_FMAA_BO_CG_STR-BUDGET_PD_NAME sy-vline 
WA_FMAA_BO_CG_STR-DATAB_BUDPER sy-vline 
WA_FMAA_BO_CG_STR-DATBIS_BUDPER sy-vline 
WA_FMAA_BO_CG_STR-AUTHGRP_BUDPER sy-vline 
WA_FMAA_BO_CG_STR-DATE_EXP_BUDPER sy-vline 
WA_FMAA_BO_CG_STR-DATE_CAN_BUDPER sy-vline 
WA_FMAA_BO_CG_STR-USERDIM sy-vline 
WA_FMAA_BO_CG_STR-CVRGRP sy-vline      INTO ld_text SEPARATED BY SPACE.

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