ABAP Select data from SAP table KABS_KANBANBOARD_ALV 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 KABS_KANBANBOARD_ALV 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 KABS_KANBANBOARD_ALV. 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 KABS_KANBANBOARD_ALV 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_KABS_KANBANBOARD_ALV TYPE STANDARD TABLE OF KABS_KANBANBOARD_ALV,
      WA_KABS_KANBANBOARD_ALV TYPE KABS_KANBANBOARD_ALV,
      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: <KABS_KANBANBOARD_ALV> TYPE KABS_KANBANBOARD_ALV.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM KABS_KANBANBOARD_ALV
*  INTO TABLE @DATA(IT_KABS_KANBANBOARD_ALV2).
*--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_KABS_KANBANBOARD_ALV INDEX 1 INTO DATA(WA_KABS_KANBANBOARD_ALV2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<KABS_KANBANBOARD_ALV>-MANDTHD = 1.
<KABS_KANBANBOARD_ALV>-PKNUMHD = 1.
<KABS_KANBANBOARD_ALV>-MATNRHD = 1.
<KABS_KANBANBOARD_ALV>-WERKSHD = 1.
<KABS_KANBANBOARD_ALV>-PRVBEHD = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_KABS_KANBANBOARD_ALV-BEHAZHD, sy-vline,
  WA_KABS_KANBANBOARD_ALV-BEHMGHD, sy-vline,
  WA_KABS_KANBANBOARD_ALV-VERIDHD, sy-vline,
  WA_KABS_KANBANBOARD_ALV-SIGAZHD, sy-vline,
  WA_KABS_KANBANBOARD_ALV-RGVERHD, sy-vline,
  WA_KABS_KANBANBOARD_ALV-PKOSAHD, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_KABS_KANBANBOARD_ALV 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_KABS_KANBANBOARD_ALV 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_KABS_KANBANBOARD_ALV INTO WA_KABS_KANBANBOARD_ALV.


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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field MEINSHD
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-MEINSHD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-MEINSHD.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit SPDEV, internal->external for field VBPRNHD
CALL FUNCTION 'CONVERSION_EXIT_SPDEV_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-VBPRNHD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-VBPRNHD.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit TSTRN, internal->external for field KWBZMHD
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-KWBZMHD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-KWBZMHD.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit NUMCV, internal->external for field ZPUNKTHD
CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-ZPUNKTHD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-ZPUNKTHD.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit TSTRN, internal->external for field OFFSET_FROM_START_OF_PRODNHD
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-OFFSET_FROM_START_OF_PRODNHD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-OFFSET_FROM_START_OF_PRODNHD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field PINTVMHD
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-PINTVMHD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-PINTVMHD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field KNFZMHD
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-KNFZMHD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-KNFZMHD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field KWTZMHD
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-KWTZMHD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-KWTZMHD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field KITZMHD
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-KITZMHD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-KITZMHD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field PLNG_HORIZONHD
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-PLNG_HORIZONHD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-PLNG_HORIZONHD.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

*Conversion exit NUMCV, internal->external for field ZPUNKTPS
CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-ZPUNKTPS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-ZPUNKTPS.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ALPH0, internal->external for field EWM_TANUMPS
CALL FUNCTION 'CONVERSION_EXIT_ALPH0_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-EWM_TANUMPS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-EWM_TANUMPS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPH0, internal->external for field EWM_GM_DOCPS
CALL FUNCTION 'CONVERSION_EXIT_ALPH0_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-EWM_GM_DOCPS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-EWM_GM_DOCPS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPH0, internal->external for field EWM_GM_DOC_ITEMPS
CALL FUNCTION 'CONVERSION_EXIT_ALPH0_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-EWM_GM_DOC_ITEMPS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-EWM_GM_DOC_ITEMPS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PKNUMBZ
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_KABS_KANBANBOARD_ALV-PKNUMBZ
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KABS_KANBANBOARD_ALV-PKNUMBZ.
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_KABS_KANBANBOARD_ALV_STR, 
MANDTHD TYPE STRING,
PKNUMHD TYPE STRING,
MATNRHD TYPE STRING,
WERKSHD TYPE STRING,
PRVBEHD TYPE STRING,
BEHAZHD TYPE STRING,
BEHMGHD TYPE STRING,
VERIDHD TYPE STRING,
SIGAZHD TYPE STRING,
RGVERHD TYPE STRING,
PKOSAHD TYPE STRING,
PKSTEHD TYPE STRING,
BERKZHD TYPE STRING,
LGNUMHD TYPE STRING,
LGTYPHD TYPE STRING,
LGPLAHD TYPE STRING,
NKDYNHD TYPE STRING,
PKSTFHD TYPE STRING,
PKSTUHD TYPE STRING,
LIFNRHD TYPE STRING,
EKORGHD TYPE STRING,
EBELNHD TYPE STRING,
EBELPHD TYPE STRING,
ANSWBHD TYPE STRING,
PKBHTHD TYPE STRING,
QUFKTHD TYPE STRING,
UMLGOHD TYPE STRING,
MEINSHD TYPE STRING,
RKSTAHD TYPE STRING,
KOSTLHD TYPE STRING,
VBPRNHD TYPE STRING,
VBQUEHD TYPE STRING,
CC_PRINT_QUEUEHD TYPE STRING,
PKDRSHD TYPE STRING,
PKUMWHD TYPE STRING,
PKADRHD TYPE STRING,
PKSFGHD TYPE STRING,
PKLOGHD TYPE STRING,
ALSMGHD TYPE STRING,
ABLADHD TYPE STRING,
KCARTHD TYPE STRING,
KCSAFHD TYPE STRING,
KCCONHD TYPE STRING,
PKRMGHD TYPE STRING,
PKFMGHD TYPE STRING,
KCPRFHD TYPE STRING,
KWBZDHD TYPE STRING,
KWBZMHD TYPE STRING,
VBELNHD TYPE STRING,
VBELPHD TYPE STRING,
QUPVBHD TYPE STRING,
PABPRFHD TYPE STRING,
PACKVHD TYPE STRING,
ANZLTHD TYPE STRING,
RKFORMHD TYPE STRING,
KBFORMHD TYPE STRING,
CC_PRINT_FORMHD TYPE STRING,
ZPUNKTHD TYPE STRING,
LCM_STATUSHD TYPE STRING,
CRE_DATEHD TYPE STRING,
RLS_DATEHD TYPE STRING,
RELEASE_TIMEHD TYPE STRING,
OBS_DATEHD TYPE STRING,
LOCK_TIMEHD TYPE STRING,
LASTCHANGE_DATETIMEHD TYPE STRING,
LASTCHANGE_USERHD TYPE STRING,
PINTVDHD TYPE STRING,
JIT_ACTION_CONTROLHD TYPE STRING,
PARTIAL_GR_ALLOWED_INDHD TYPE STRING,
MAX_NUMBER_OPEN_CALLSHD TYPE STRING,
REPL_QTY_LOWER_TOLERANCE_LVLHD TYPE STRING,
SUPL_QTY_UPPER_TOLERANCE_LVLHD TYPE STRING,
SUPL_QTY_LOWER_TOLERANCE_LVLHD TYPE STRING,
JIT_STCK_TRANSFER_REPL_STRATHD TYPE STRING,
JIT_EXT_PROC_REPL_STRATHD TYPE STRING,
COMMUNICATION_GROUPHD TYPE STRING,
OFFSET_FROM_START_OF_PRODNHD TYPE STRING,
DUMMY_NJIT_CCYC_INCL_EEW_PS TYPE STRING,
DUMMY_KANBAN_CCYC_INCL_EEW_PS TYPE STRING,
PINTVMHD TYPE STRING,
KNFZDHD TYPE STRING,
KNFZMHD TYPE STRING,
KWTZDHD TYPE STRING,
KWTZMHD TYPE STRING,
KITZDHD TYPE STRING,
KITZMHD TYPE STRING,
KDMBUFHD TYPE STRING,
KSPBUFHD TYPE STRING,
NTRELHD TYPE STRING,
TRIGAZHD TYPE STRING,
TRIGGRHD TYPE STRING,
CAPA_WRKCTHD TYPE STRING,
NLPLAHD TYPE STRING,
VLPLAHD TYPE STRING,
PRCTYHD TYPE STRING,
FAZUSHD TYPE STRING,
SAFETY_TIME_IN_DAYSHD TYPE STRING,
SAFETY_TIME_IN_MINUTESHD TYPE STRING,
PLNG_PROCEDUREHD TYPE STRING,
SUMRST2HD TYPE STRING,
SUMRST3HD TYPE STRING,
PLNG_HORIZONHD TYPE STRING,
MIN_STOCKHD TYPE STRING,
LOT_SIZING_PROCHD TYPE STRING,
SCHEDULING_TYPEHD TYPE STRING,
SEQRST2HD TYPE STRING,
JITSCPRFHD TYPE STRING,
JITOTOLHD TYPE STRING,
MANDTPS TYPE STRING,
PKKEYPS TYPE STRING,
PKNUMPS TYPE STRING,
PKPOSPS TYPE STRING,
PKBSTPS TYPE STRING,
PKIMGPS TYPE STRING,
SAEDTPS TYPE STRING,
SAEUZPS TYPE STRING,
SADT2PS TYPE STRING,
SAUZ2PS TYPE STRING,
LASTCHANGE_DATETIMEPS TYPE STRING,
PLNUMPS TYPE STRING,
AUFNRPS TYPE STRING,
POSNRPS TYPE STRING,
BSTYPPS TYPE STRING,
EBELNPS TYPE STRING,
EBELPPS TYPE STRING,
ETENRPS TYPE STRING,
DUMMY_KANBAN_CTN_INCL_EEW_PS TYPE STRING,
RSNUMPS TYPE STRING,
RSPOSPS TYPE STRING,
TBNUMPS TYPE STRING,
TBPOSPS TYPE STRING,
SPKKZPS TYPE STRING,
MBLNRPS TYPE STRING,
MJAHRPS TYPE STRING,
MBLPOPS TYPE STRING,
PKLKZPS TYPE STRING,
PKBMGPS TYPE STRING,
PKBSAPS TYPE STRING,
PABNUMPS TYPE STRING,
PABPOSPS TYPE STRING,
PKGPZGPS TYPE STRING,
HDFLGPS TYPE STRING,
ETENSPS TYPE STRING,
ZPUNKTPS TYPE STRING,
PRTNRPS TYPE STRING,
VBELNPS TYPE STRING,
VBELPPS TYPE STRING,
EWM_LGNUMPS TYPE STRING,
EWM_TANUMPS TYPE STRING,
EWM_GM_DOCPS TYPE STRING,
EWM_GM_DOC_ITEMPS TYPE STRING,
PKNUMBZ TYPE STRING,
PKURG1BZ TYPE STRING,
PKURG2BZ TYPE STRING,
PKUSER1BZ TYPE STRING,
PKUSER2BZ TYPE STRING,
PKRESTBZ TYPE STRING,
PKRESTTBZ TYPE STRING,
PKICONBZ TYPE STRING,
ARBPLBZ TYPE STRING,
BHSKT TYPE STRING,
SPKKT TYPE STRING,
PKLKT TYPE STRING,
UESIG TYPE STRING,
SGR_ICON TYPE STRING,
MAKTX TYPE STRING,
PVBTX TYPE STRING,END OF T_EKKO_STR.
DATA: WA_KABS_KANBANBOARD_ALV_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_KABS_KANBANBOARD_ALV_STR-MANDTHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKNUMHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-MATNRHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-WERKSHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PRVBEHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-BEHAZHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-BEHMGHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-VERIDHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SIGAZHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-RGVERHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKOSAHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKSTEHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-BERKZHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-LGNUMHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-LGTYPHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-LGPLAHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-NKDYNHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKSTFHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKSTUHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-LIFNRHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-EKORGHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-EBELNHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-EBELPHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-ANSWBHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKBHTHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-QUFKTHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-UMLGOHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-MEINSHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-RKSTAHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KOSTLHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-VBPRNHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-VBQUEHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-CC_PRINT_QUEUEHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKDRSHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKUMWHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKADRHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKSFGHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKLOGHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-ALSMGHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-ABLADHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KCARTHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KCSAFHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KCCONHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKRMGHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKFMGHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KCPRFHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KWBZDHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KWBZMHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-VBELNHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-VBELPHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-QUPVBHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PABPRFHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PACKVHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-ANZLTHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-RKFORMHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KBFORMHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-CC_PRINT_FORMHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-ZPUNKTHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-LCM_STATUSHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-CRE_DATEHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-RLS_DATEHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-RELEASE_TIMEHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-OBS_DATEHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-LOCK_TIMEHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-LASTCHANGE_DATETIMEHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-LASTCHANGE_USERHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PINTVDHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-JIT_ACTION_CONTROLHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PARTIAL_GR_ALLOWED_INDHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-MAX_NUMBER_OPEN_CALLSHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-REPL_QTY_LOWER_TOLERANCE_LVLHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SUPL_QTY_UPPER_TOLERANCE_LVLHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SUPL_QTY_LOWER_TOLERANCE_LVLHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-JIT_STCK_TRANSFER_REPL_STRATHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-JIT_EXT_PROC_REPL_STRATHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-COMMUNICATION_GROUPHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-OFFSET_FROM_START_OF_PRODNHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-DUMMY_NJIT_CCYC_INCL_EEW_PS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-DUMMY_KANBAN_CCYC_INCL_EEW_PS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PINTVMHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KNFZDHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KNFZMHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KWTZDHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KWTZMHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KITZDHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KITZMHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KDMBUFHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-KSPBUFHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-NTRELHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-TRIGAZHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-TRIGGRHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-CAPA_WRKCTHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-NLPLAHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-VLPLAHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PRCTYHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-FAZUSHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SAFETY_TIME_IN_DAYSHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SAFETY_TIME_IN_MINUTESHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PLNG_PROCEDUREHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SUMRST2HD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SUMRST3HD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PLNG_HORIZONHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-MIN_STOCKHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-LOT_SIZING_PROCHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SCHEDULING_TYPEHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SEQRST2HD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-JITSCPRFHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-JITOTOLHD sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-MANDTPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKKEYPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKNUMPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKPOSPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKBSTPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKIMGPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SAEDTPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SAEUZPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SADT2PS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SAUZ2PS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-LASTCHANGE_DATETIMEPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PLNUMPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-AUFNRPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-POSNRPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-BSTYPPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-EBELNPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-EBELPPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-ETENRPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-DUMMY_KANBAN_CTN_INCL_EEW_PS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-RSNUMPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-RSPOSPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-TBNUMPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-TBPOSPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SPKKZPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-MBLNRPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-MJAHRPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-MBLPOPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKLKZPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKBMGPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKBSAPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PABNUMPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PABPOSPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKGPZGPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-HDFLGPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-ETENSPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-ZPUNKTPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PRTNRPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-VBELNPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-VBELPPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-EWM_LGNUMPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-EWM_TANUMPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-EWM_GM_DOCPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-EWM_GM_DOC_ITEMPS sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKNUMBZ sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKURG1BZ sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKURG2BZ sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKUSER1BZ sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKUSER2BZ sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKRESTBZ sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKRESTTBZ sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKICONBZ sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-ARBPLBZ sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-BHSKT sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SPKKT sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PKLKT sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-UESIG sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-SGR_ICON sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-MAKTX sy-vline 
WA_KABS_KANBANBOARD_ALV_STR-PVBTX sy-vline      INTO ld_text SEPARATED BY SPACE.

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