ABAP Select data from SAP table FMCA_RETURN_SEARCH_WD 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 FMCA_RETURN_SEARCH_WD 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 FMCA_RETURN_SEARCH_WD. 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 FMCA_RETURN_SEARCH_WD 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_FMCA_RETURN_SEARCH_WD TYPE STANDARD TABLE OF FMCA_RETURN_SEARCH_WD,
      WA_FMCA_RETURN_SEARCH_WD TYPE FMCA_RETURN_SEARCH_WD,
      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: <FMCA_RETURN_SEARCH_WD> TYPE FMCA_RETURN_SEARCH_WD.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FMCA_RETURN_SEARCH_WD
*  INTO TABLE @DATA(IT_FMCA_RETURN_SEARCH_WD2).
*--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_FMCA_RETURN_SEARCH_WD INDEX 1 INTO DATA(WA_FMCA_RETURN_SEARCH_WD2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FMCA_RETURN_SEARCH_WD>-RETURN_ID = 1.
<FMCA_RETURN_SEARCH_WD>-FBNUM = 1.
<FMCA_RETURN_SEARCH_WD>-REVENUE_TYPE = 1.
<FMCA_RETURN_SEARCH_WD>-TAXPAYER = 1.
<FMCA_RETURN_SEARCH_WD>-JOINT_FILER = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FMCA_RETURN_SEARCH_WD-BU_ID_TYPE, sy-vline,
  WA_FMCA_RETURN_SEARCH_WD-TAXPAYER_ID, sy-vline,
  WA_FMCA_RETURN_SEARCH_WD-JOINT_ID_TYPE, sy-vline,
  WA_FMCA_RETURN_SEARCH_WD-JOINT_FILER_ID, sy-vline,
  WA_FMCA_RETURN_SEARCH_WD-ACCOUNT, sy-vline,
  WA_FMCA_RETURN_SEARCH_WD-REG_ID, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FMCA_RETURN_SEARCH_WD 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_FMCA_RETURN_SEARCH_WD 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_FMCA_RETURN_SEARCH_WD INTO WA_FMCA_RETURN_SEARCH_WD.


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

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

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

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

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

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

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

*Conversion exit TZNTS, internal->external for field ERTSP
CALL FUNCTION 'CONVERSION_EXIT_TZNTS_OUTPUT'
  EXPORTING
    input =                      WA_FMCA_RETURN_SEARCH_WD-ERTSP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FMCA_RETURN_SEARCH_WD-ERTSP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TZNTS, internal->external for field AETSP
CALL FUNCTION 'CONVERSION_EXIT_TZNTS_OUTPUT'
  EXPORTING
    input =                      WA_FMCA_RETURN_SEARCH_WD-AETSP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FMCA_RETURN_SEARCH_WD-AETSP.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field REMOTE_SYS
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FMCA_RETURN_SEARCH_WD-REMOTE_SYS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FMCA_RETURN_SEARCH_WD-REMOTE_SYS.
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_FMCA_RETURN_SEARCH_WD_STR, 
RETURN_ID TYPE STRING,
FBNUM TYPE STRING,
REVENUE_TYPE TYPE STRING,
TAXPAYER TYPE STRING,
JOINT_FILER TYPE STRING,
BU_ID_TYPE TYPE STRING,
TAXPAYER_ID TYPE STRING,
JOINT_ID_TYPE TYPE STRING,
JOINT_FILER_ID TYPE STRING,
ACCOUNT TYPE STRING,
REG_ID TYPE STRING,
REG_TYPE TYPE STRING,
JOINT_ACCOUNT TYPE STRING,
JOINT_REG_ID TYPE STRING,
JOINT_REG_TYPE TYPE STRING,
APPLY_FROM TYPE STRING,
APPLY_TO TYPE STRING,
PERIOD_KEY TYPE STRING,
BEGRU TYPE STRING,
CONSOLIDATED_BY TYPE STRING,
DUPLICATE_TO TYPE STRING,
FORMPROC TYPE STRING,
X_CONS TYPE STRING,
X_ESTIMATED TYPE STRING,
FBTYP TYPE STRING,
BETRW TYPE STRING,
WAERS TYPE STRING,
ERNAM TYPE STRING,
ERTSP TYPE STRING,
AENAM TYPE STRING,
AETSP TYPE STRING,
KEYDT TYPE STRING,
FBSTA TYPE STRING,
FBSTB TYPE STRING,
FBUST TYPE STRING,
FBSTZ TYPE STRING,
VALIDATION TYPE STRING,
POSTMARK TYPE STRING,
RECEIPT TYPE STRING,
DUE_DATE TYPE STRING,
DEFERRAL_DATE TYPE STRING,
REFUND_COMPLETE TYPE STRING,
POSTMARK_EXT TYPE STRING,
RECONCILIATION TYPE STRING,
LAST_FILING TYPE STRING,
AS_FILED_EXT TYPE STRING,
DATE_SOL TYPE STRING,
BATCH_ID TYPE STRING,
LOCATOR_NUMBER TYPE STRING,
TRANSACTION_TYPE TYPE STRING,
IN_CHANNEL TYPE STRING,
TAX_PREPARER TYPE STRING,
INDPR TYPE STRING,
KEYPP TYPE STRING,
CURRENT_VERSION TYPE STRING,
X_CHANGED TYPE STRING,
FORM_ID TYPE STRING,
CONTAINER_NUM TYPE STRING,
CONTAINER_GUID TYPE STRING,
DOCUMENT_ID TYPE STRING,
TIMESTAMP_CONT TYPE STRING,
TFD_FILLED TYPE STRING,
DUMMY_PSFORMBUNDLE_EEW_PS TYPE STRING,
ADDRNUMBER TYPE STRING,
ADDRESS TYPE STRING,
REVENUE_TYPET TYPE STRING,
ID_TYPE TYPE STRING,
TAXPAYER_NAME TYPE STRING,
ADDRNUMBER_JOINT TYPE STRING,
ADDRESS_JOINT TYPE STRING,
JOINT_FILER_NAME TYPE STRING,
PERSL_TEXT TYPE STRING,
VKBEZ TYPE STRING,
VKBEZ_JOINT TYPE STRING,
TRANTYPE_TEXT TYPE STRING,
INPCH_TEXT TYPE STRING,
T_PREPARER_NAME TYPE STRING,
REG_ID_TEXT TYPE STRING,
JF_REG_ID_TEXT TYPE STRING,
JOINT_ID_TYPET TYPE STRING,
STATUS_TEXT TYPE STRING,
FBT_TEXT TYPE STRING,
OTHER_PERSL_TEXT TYPE STRING,
CLIENT TYPE STRING,
WI_ID TYPE STRING,
WI_TYPE TYPE STRING,
WI_CREATOR TYPE STRING,
WI_LANG TYPE STRING,
WI_TEXT TYPE STRING,
WI_RHTEXT TYPE STRING,
WI_STAT TYPE STRING,
WI_CD TYPE STRING,
WI_CT TYPE STRING,
WI_AED TYPE STRING,
WI_AAGENT TYPE STRING,
WI_AADDR TYPE STRING,
WI_CRUSER TYPE STRING,
WI_CRADDR TYPE STRING,
WI_CHCKWI TYPE STRING,
WI_CBFB TYPE STRING,
WI_RH_TASK TYPE STRING,
WI_PRIO TYPE STRING,
WI_CONFIRM TYPE STRING,
WI_COMP_EV TYPE STRING,
WI_FORW_BY TYPE STRING,
WI_DISABLE TYPE STRING,
WI_REJECT TYPE STRING,
TCLASS TYPE STRING,
NOTE_EXIST TYPE STRING,
NOTIFY TYPE STRING,
RETRY_CNT TYPE STRING,
MAX_RETRY TYPE STRING,
RC_MODELED TYPE STRING,
CB_DONE TYPE STRING,
HANDLE TYPE STRING,
SYNCCHAIN TYPE STRING,
NO_DEADL TYPE STRING,
WI_DH_STAT TYPE STRING,
WI_RELEASE TYPE STRING,
WLC_DISPL TYPE STRING,
WI_RESTLOG TYPE STRING,
REMOTE_ID TYPE STRING,
REMOTE_SYS TYPE STRING,
STATUS_EVT TYPE STRING,
TIMEOUT TYPE STRING,
WF_TYPE TYPE STRING,
WLC_FLAGS TYPE STRING,
XMLPROT TYPE STRING,
WAIT4CB TYPE STRING,
TOP_WI_ID TYPE STRING,
DEF_GUID TYPE STRING,
EXEC_TIME TYPE STRING,
NOTE_COUNT TYPE STRING,
PRS_PROFIL TYPE STRING,
CREA_TMP TYPE STRING,
CHECK_STAT TYPE STRING,
BLOCKTYPE TYPE STRING,
PARENT_WI TYPE STRING,
RNDNUMBER TYPE STRING,
WFD_ID TYPE STRING,
WFD_VERSION TYPE STRING,
WFD_EXETYP TYPE STRING,
PROCCAT TYPE STRING,
TOP_TASK TYPE STRING,
AGING_STATE TYPE STRING,
AGING_TEMPERATURE TYPE STRING,
WLC_FLAGS_EXT TYPE STRING,
WI_AED_TIMESTAMP TYPE STRING,
REFERENCE_NODEID TYPE STRING,
STEP_ID TYPE STRING,
AGENT_RULE_ID TYPE STRING,
WI_TEXT_ID TYPE STRING,
CPWF_HANDLE TYPE STRING,
WI_MOD_TIMESTAMP TYPE STRING,
WI_MOD_BY TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FMCA_RETURN_SEARCH_WD_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_FMCA_RETURN_SEARCH_WD_STR-RETURN_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-FBNUM sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-REVENUE_TYPE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-TAXPAYER sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-JOINT_FILER sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-BU_ID_TYPE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-TAXPAYER_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-JOINT_ID_TYPE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-JOINT_FILER_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-ACCOUNT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-REG_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-REG_TYPE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-JOINT_ACCOUNT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-JOINT_REG_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-JOINT_REG_TYPE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-APPLY_FROM sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-APPLY_TO sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-PERIOD_KEY sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-BEGRU sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-CONSOLIDATED_BY sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-DUPLICATE_TO sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-FORMPROC sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-X_CONS sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-X_ESTIMATED sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-FBTYP sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-BETRW sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WAERS sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-ERNAM sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-ERTSP sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-AENAM sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-AETSP sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-KEYDT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-FBSTA sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-FBSTB sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-FBUST sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-FBSTZ sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-VALIDATION sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-POSTMARK sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-RECEIPT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-DUE_DATE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-DEFERRAL_DATE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-REFUND_COMPLETE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-POSTMARK_EXT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-RECONCILIATION sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-LAST_FILING sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-AS_FILED_EXT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-DATE_SOL sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-BATCH_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-LOCATOR_NUMBER sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-TRANSACTION_TYPE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-IN_CHANNEL sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-TAX_PREPARER sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-INDPR sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-KEYPP sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-CURRENT_VERSION sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-X_CHANGED sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-FORM_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-CONTAINER_NUM sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-CONTAINER_GUID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-DOCUMENT_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-TIMESTAMP_CONT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-TFD_FILLED sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-DUMMY_PSFORMBUNDLE_EEW_PS sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-ADDRNUMBER sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-ADDRESS sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-REVENUE_TYPET sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-ID_TYPE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-TAXPAYER_NAME sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-ADDRNUMBER_JOINT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-ADDRESS_JOINT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-JOINT_FILER_NAME sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-PERSL_TEXT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-VKBEZ sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-VKBEZ_JOINT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-TRANTYPE_TEXT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-INPCH_TEXT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-T_PREPARER_NAME sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-REG_ID_TEXT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-JF_REG_ID_TEXT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-JOINT_ID_TYPET sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-STATUS_TEXT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-FBT_TEXT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-OTHER_PERSL_TEXT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-CLIENT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_TYPE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_CREATOR sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_LANG sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_TEXT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_RHTEXT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_STAT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_CD sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_CT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_AED sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_AAGENT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_AADDR sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_CRUSER sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_CRADDR sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_CHCKWI sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_CBFB sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_RH_TASK sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_PRIO sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_CONFIRM sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_COMP_EV sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_FORW_BY sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_DISABLE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_REJECT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-TCLASS sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-NOTE_EXIST sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-NOTIFY sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-RETRY_CNT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-MAX_RETRY sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-RC_MODELED sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-CB_DONE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-HANDLE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-SYNCCHAIN sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-NO_DEADL sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_DH_STAT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_RELEASE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WLC_DISPL sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_RESTLOG sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-REMOTE_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-REMOTE_SYS sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-STATUS_EVT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-TIMEOUT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WF_TYPE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WLC_FLAGS sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-XMLPROT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WAIT4CB sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-TOP_WI_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-DEF_GUID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-EXEC_TIME sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-NOTE_COUNT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-PRS_PROFIL sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-CREA_TMP sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-CHECK_STAT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-BLOCKTYPE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-PARENT_WI sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-RNDNUMBER sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WFD_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WFD_VERSION sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WFD_EXETYP sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-PROCCAT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-TOP_TASK sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-AGING_STATE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-AGING_TEMPERATURE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WLC_FLAGS_EXT sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_AED_TIMESTAMP sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-REFERENCE_NODEID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-STEP_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-AGENT_RULE_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_TEXT_ID sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-CPWF_HANDLE sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_MOD_TIMESTAMP sy-vline 
WA_FMCA_RETURN_SEARCH_WD_STR-WI_MOD_BY sy-vline      INTO ld_text SEPARATED BY SPACE.

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