ABAP Select data from SAP table FPMGB_S_GUIBB_USER_FIELDCAT 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 FPMGB_S_GUIBB_USER_FIELDCAT 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 FPMGB_S_GUIBB_USER_FIELDCAT. 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 FPMGB_S_GUIBB_USER_FIELDCAT 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_FPMGB_S_GUIBB_USER_FIELDCAT TYPE STANDARD TABLE OF FPMGB_S_GUIBB_USER_FIELDCAT,
      WA_FPMGB_S_GUIBB_USER_FIELDCAT TYPE FPMGB_S_GUIBB_USER_FIELDCAT,
      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: <FPMGB_S_GUIBB_USER_FIELDCAT> TYPE FPMGB_S_GUIBB_USER_FIELDCAT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FPMGB_S_GUIBB_USER_FIELDCAT
*  INTO TABLE @DATA(IT_FPMGB_S_GUIBB_USER_FIELDCAT2).
*--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_FPMGB_S_GUIBB_USER_FIELDCAT INDEX 1 INTO DATA(WA_FPMGB_S_GUIBB_USER_FIELDCAT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FPMGB_S_GUIBB_USER_FIELDCAT>-UNAME = 1.
<FPMGB_S_GUIBB_USER_FIELDCAT>-GLTGV = 1.
<FPMGB_S_GUIBB_USER_FIELDCAT>-GLTGB = 1.
<FPMGB_S_GUIBB_USER_FIELDCAT>-USTYP = 1.
<FPMGB_S_GUIBB_USER_FIELDCAT>-CLASS = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FPMGB_S_GUIBB_USER_FIELDCAT-ACCNT, sy-vline,
  WA_FPMGB_S_GUIBB_USER_FIELDCAT-TZONE, sy-vline,
  WA_FPMGB_S_GUIBB_USER_FIELDCAT-LTIME, sy-vline,
  WA_FPMGB_S_GUIBB_USER_FIELDCAT-BCODE, sy-vline,
  WA_FPMGB_S_GUIBB_USER_FIELDCAT-CODVN, sy-vline,
  WA_FPMGB_S_GUIBB_USER_FIELDCAT-PASSCODE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FPMGB_S_GUIBB_USER_FIELDCAT 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_FPMGB_S_GUIBB_USER_FIELDCAT 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_FPMGB_S_GUIBB_USER_FIELDCAT INTO WA_FPMGB_S_GUIBB_USER_FIELDCAT.


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

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

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

*Conversion exit ISOLA, internal->external for field LANGU_P
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_FPMGB_S_GUIBB_USER_FIELDCAT-LANGU_P
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FPMGB_S_GUIBB_USER_FIELDCAT-LANGU_P.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit ISOLA, internal->external for field LANGU
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_FPMGB_S_GUIBB_USER_FIELDCAT-LANGU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FPMGB_S_GUIBB_USER_FIELDCAT-LANGU.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SXIDN, internal->external for field E_MAIL
CALL FUNCTION 'CONVERSION_EXIT_SXIDN_OUTPUT'
  EXPORTING
    input =                      WA_FPMGB_S_GUIBB_USER_FIELDCAT-E_MAIL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FPMGB_S_GUIBB_USER_FIELDCAT-E_MAIL.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ISOLA, internal->external for field LANGU_CR_P
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_FPMGB_S_GUIBB_USER_FIELDCAT-LANGU_CR_P
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FPMGB_S_GUIBB_USER_FIELDCAT-LANGU_CR_P.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit SPDEV, internal->external for field SPLD
CALL FUNCTION 'CONVERSION_EXIT_SPDEV_OUTPUT'
  EXPORTING
    input =                      WA_FPMGB_S_GUIBB_USER_FIELDCAT-SPLD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FPMGB_S_GUIBB_USER_FIELDCAT-SPLD.
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_FPMGB_S_GUIBB_USER_FIELDCAT_STR, 
UNAME TYPE STRING,
GLTGV TYPE STRING,
GLTGB TYPE STRING,
USTYP TYPE STRING,
CLASS TYPE STRING,
ACCNT TYPE STRING,
TZONE TYPE STRING,
LTIME TYPE STRING,
BCODE TYPE STRING,
CODVN TYPE STRING,
PASSCODE TYPE STRING,
CODVC TYPE STRING,
PWDSALTEDHASH TYPE STRING,
CODVS TYPE STRING,
SECURITY_POLICY TYPE STRING,
PERS_NO TYPE STRING,
ADDR_NO TYPE STRING,
TITLE_P TYPE STRING,
FIRSTNAME TYPE STRING,
LASTNAME TYPE STRING,
BIRTH_NAME TYPE STRING,
MIDDLENAME TYPE STRING,
SECONDNAME TYPE STRING,
FULLNAME TYPE STRING,
FULLNAME_X TYPE STRING,
TITLE_ACA1 TYPE STRING,
TITLE_ACA2 TYPE STRING,
PREFIX1 TYPE STRING,
PREFIX2 TYPE STRING,
TITLE_SPPL TYPE STRING,
NICKNAME TYPE STRING,
INITIALS TYPE STRING,
NAMEFORMAT TYPE STRING,
NAMCOUNTRY TYPE STRING,
LANGU_P TYPE STRING,
LANGUP_ISO TYPE STRING,
SORT1_P TYPE STRING,
SORT2_P TYPE STRING,
DEPARTMENT TYPE STRING,
FUNCTION TYPE STRING,
BUILDING_P TYPE STRING,
FLOOR_P TYPE STRING,
ROOM_NO_P TYPE STRING,
INITS_SIG TYPE STRING,
INHOUSE_ML TYPE STRING,
COMM_TYPE TYPE STRING,
TITLE TYPE STRING,
NAME TYPE STRING,
NAME_2 TYPE STRING,
NAME_3 TYPE STRING,
NAME_4 TYPE STRING,
C_O_NAME TYPE STRING,
CITY TYPE STRING,
DISTRICT TYPE STRING,
CITY_NO TYPE STRING,
DISTRCT_NO TYPE STRING,
CHCKSTATUS TYPE STRING,
POSTL_COD1 TYPE STRING,
POSTL_COD2 TYPE STRING,
POSTL_COD3 TYPE STRING,
PO_BOX TYPE STRING,
PO_BOX_CIT TYPE STRING,
PBOXCIT_NO TYPE STRING,
DELIV_DIS TYPE STRING,
TRANSPZONE TYPE STRING,
STREET TYPE STRING,
STREET_NO TYPE STRING,
STR_ABBR TYPE STRING,
HOUSE_NO TYPE STRING,
HOUSE_NO2 TYPE STRING,
STR_SUPPL1 TYPE STRING,
STR_SUPPL2 TYPE STRING,
STR_SUPPL3 TYPE STRING,
LOCATION TYPE STRING,
BUILDING TYPE STRING,
FLOOR TYPE STRING,
ROOM_NO TYPE STRING,
COUNTRY TYPE STRING,
COUNTRYISO TYPE STRING,
LANGU TYPE STRING,
LANGU_ISO TYPE STRING,
REGION TYPE STRING,
SORT1 TYPE STRING,
SORT2 TYPE STRING,
TIME_ZONE TYPE STRING,
TAXJURCODE TYPE STRING,
ADR_NOTES TYPE STRING,
TEL1_NUMBR TYPE STRING,
TEL1_EXT TYPE STRING,
FAX_NUMBER TYPE STRING,
FAX_EXTENS TYPE STRING,
E_MAIL TYPE STRING,
BUILD_LONG TYPE STRING,
REGIOGROUP TYPE STRING,
HOME_CITY TYPE STRING,
HOMECITYNO TYPE STRING,
PCODE1_EXT TYPE STRING,
PCODE2_EXT TYPE STRING,
PCODE3_EXT TYPE STRING,
PO_W_O_NO TYPE STRING,
PO_BOX_REG TYPE STRING,
POBOX_CTRY TYPE STRING,
PO_CTRYISO TYPE STRING,
DONT_USE_S TYPE STRING,
DONT_USE_P TYPE STRING,
HOUSE_NO3 TYPE STRING,
LANGU_CR_P TYPE STRING,
LANGUCPISO TYPE STRING,
PO_BOX_LOBBY TYPE STRING,
DELI_SERV_TYPE TYPE STRING,
DELI_SERV_NUMBER TYPE STRING,
COUNTY_CODE TYPE STRING,
COUNTY TYPE STRING,
TOWNSHIP_CODE TYPE STRING,
TOWNSHIP TYPE STRING,
XPCPT TYPE STRING,
COMPANY TYPE STRING,
TEMPLATE_ORGTYPE TYPE STRING,
STCOD TYPE STRING,
SPLD TYPE STRING,
SPLG TYPE STRING,
SPDB TYPE STRING,
SPDA TYPE STRING,
DATFM TYPE STRING,
DCPFM TYPE STRING,
CATTKENNZ TYPE STRING,
KOSTL TYPE STRING,
START_MENU TYPE STRING,
TIMEFM TYPE STRING,
MODDATE TYPE STRING,
MODTIME TYPE STRING,
MODIFIER TYPE STRING,
XSTRING TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FPMGB_S_GUIBB_USER_FIELDCAT_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_FPMGB_S_GUIBB_USER_FIELDCAT_STR-UNAME sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-GLTGV sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-GLTGB sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-USTYP sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-CLASS sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-ACCNT sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TZONE sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-LTIME sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-BCODE sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-CODVN sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PASSCODE sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-CODVC sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PWDSALTEDHASH sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-CODVS sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-SECURITY_POLICY sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PERS_NO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-ADDR_NO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TITLE_P sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-FIRSTNAME sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-LASTNAME sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-BIRTH_NAME sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-MIDDLENAME sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-SECONDNAME sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-FULLNAME sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-FULLNAME_X sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TITLE_ACA1 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TITLE_ACA2 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PREFIX1 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PREFIX2 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TITLE_SPPL sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-NICKNAME sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-INITIALS sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-NAMEFORMAT sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-NAMCOUNTRY sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-LANGU_P sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-LANGUP_ISO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-SORT1_P sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-SORT2_P sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-DEPARTMENT sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-FUNCTION sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-BUILDING_P sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-FLOOR_P sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-ROOM_NO_P sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-INITS_SIG sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-INHOUSE_ML sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-COMM_TYPE sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TITLE sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-NAME sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-NAME_2 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-NAME_3 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-NAME_4 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-C_O_NAME sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-CITY sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-DISTRICT sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-CITY_NO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-DISTRCT_NO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-CHCKSTATUS sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-POSTL_COD1 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-POSTL_COD2 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-POSTL_COD3 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PO_BOX sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PO_BOX_CIT sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PBOXCIT_NO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-DELIV_DIS sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TRANSPZONE sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-STREET sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-STREET_NO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-STR_ABBR sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-HOUSE_NO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-HOUSE_NO2 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-STR_SUPPL1 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-STR_SUPPL2 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-STR_SUPPL3 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-LOCATION sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-BUILDING sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-FLOOR sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-ROOM_NO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-COUNTRY sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-COUNTRYISO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-LANGU sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-LANGU_ISO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-REGION sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-SORT1 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-SORT2 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TIME_ZONE sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TAXJURCODE sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-ADR_NOTES sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TEL1_NUMBR sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TEL1_EXT sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-FAX_NUMBER sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-FAX_EXTENS sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-E_MAIL sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-BUILD_LONG sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-REGIOGROUP sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-HOME_CITY sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-HOMECITYNO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PCODE1_EXT sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PCODE2_EXT sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PCODE3_EXT sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PO_W_O_NO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PO_BOX_REG sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-POBOX_CTRY sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PO_CTRYISO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-DONT_USE_S sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-DONT_USE_P sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-HOUSE_NO3 sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-LANGU_CR_P sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-LANGUCPISO sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-PO_BOX_LOBBY sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-DELI_SERV_TYPE sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-DELI_SERV_NUMBER sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-COUNTY_CODE sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-COUNTY sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TOWNSHIP_CODE sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TOWNSHIP sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-XPCPT sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-COMPANY sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TEMPLATE_ORGTYPE sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-STCOD sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-SPLD sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-SPLG sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-SPDB sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-SPDA sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-DATFM sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-DCPFM sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-CATTKENNZ sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-KOSTL sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-START_MENU sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-TIMEFM sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-MODDATE sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-MODTIME sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-MODIFIER sy-vline 
WA_FPMGB_S_GUIBB_USER_FIELDCAT_STR-XSTRING sy-vline      INTO ld_text SEPARATED BY SPACE.

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