ABAP Select data from SAP table /MRSS/T_SGU_COMM_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 /MRSS/T_SGU_COMM_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 /MRSS/T_SGU_COMM_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 /MRSS/T_SGU_COMM_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_/MRSS/T_SGU_COMM_ALV TYPE STANDARD TABLE OF /MRSS/T_SGU_COMM_ALV,
      WA_/MRSS/T_SGU_COMM_ALV TYPE /MRSS/T_SGU_COMM_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: </MRSS/T_SGU_COMM_ALV> TYPE /MRSS/T_SGU_COMM_ALV.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /MRSS/T_SGU_COMM_ALV
  INTO TABLE IT_/MRSS/T_SGU_COMM_ALV.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /MRSS/T_SGU_COMM_ALV
*  INTO TABLE @DATA(IT_/MRSS/T_SGU_COMM_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_/MRSS/T_SGU_COMM_ALV INDEX 1 INTO DATA(WA_/MRSS/T_SGU_COMM_ALV2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/MRSS/T_SGU_COMM_ALV ASSIGNING </MRSS/T_SGU_COMM_ALV>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
</MRSS/T_SGU_COMM_ALV>-TYPE = 1.
</MRSS/T_SGU_COMM_ALV>-OPERATION = 1.
</MRSS/T_SGU_COMM_ALV>-TIMESPEC_ID = 1.
</MRSS/T_SGU_COMM_ALV>-ASSIGNMENT_KEY = 1.
</MRSS/T_SGU_COMM_ALV>-PARENT_GUID = 1.

ENDLOOP.

LOOP AT IT_/MRSS/T_SGU_COMM_ALV INTO WA_/MRSS/T_SGU_COMM_ALV.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/MRSS/T_SGU_COMM_ALV-LINK_ID, sy-vline,
  WA_/MRSS/T_SGU_COMM_ALV-WORKITEM_ID, sy-vline,
  WA_/MRSS/T_SGU_COMM_ALV-WORKITEM_NAME, sy-vline,
  WA_/MRSS/T_SGU_COMM_ALV-DEM_TYPE, sy-vline,
  WA_/MRSS/T_SGU_COMM_ALV-ORIG_ITEM_TYPE, sy-vline,
  WA_/MRSS/T_SGU_COMM_ALV-DEMAND_LOGSYS, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/MRSS/T_SGU_COMM_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_/MRSS/T_SGU_COMM_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_/MRSS/T_SGU_COMM_ALV INTO WA_/MRSS/T_SGU_COMM_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 DEMAND_LOGSYS
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_/MRSS/T_SGU_COMM_ALV-DEMAND_LOGSYS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MRSS/T_SGU_COMM_ALV-DEMAND_LOGSYS.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

*Conversion exit SXIDN, internal->external for field E_MAIL
CALL FUNCTION 'CONVERSION_EXIT_SXIDN_OUTPUT'
  EXPORTING
    input =                      WA_/MRSS/T_SGU_COMM_ALV-E_MAIL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MRSS/T_SGU_COMM_ALV-E_MAIL.
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_/MRSS/T_SGU_COMM_ALV_STR, 
TYPE TYPE STRING,
OPERATION TYPE STRING,
TIMESPEC_ID TYPE STRING,
ASSIGNMENT_KEY TYPE STRING,
PARENT_GUID TYPE STRING,
LINK_ID TYPE STRING,
WORKITEM_ID TYPE STRING,
WORKITEM_NAME TYPE STRING,
DEM_TYPE TYPE STRING,
ORIG_ITEM_TYPE TYPE STRING,
DEMAND_LOGSYS TYPE STRING,
RESOURCE_ID TYPE STRING,
RESOURCE_NAME TYPE STRING,
RESOURCE_TYPE TYPE STRING,
RESOURCE_REL TYPE STRING,
RESOURCE2_ID TYPE STRING,
RESOURCE2_NAME TYPE STRING,
RESOURCE2_TYPE TYPE STRING,
RESOURCE2_REL TYPE STRING,
TEAM_ID TYPE STRING,
DESCRIPTION TYPE STRING,
BEGDA TYPE STRING,
BEG_UZEIT TYPE STRING,
ENDDA TYPE STRING,
END_UZEIT TYPE STRING,
DURATION TYPE STRING,
DURATION_UNIT TYPE STRING,
DURATION_VAL TYPE STRING,
DURATION_ORIGINAL_VAL TYPE STRING,
TOTAL_WORK TYPE STRING,
TOTAL_WORK_UNIT TYPE STRING,
MULT_RES TYPE STRING,
UTIL TYPE STRING,
STATUS TYPE STRING,
TIME_RULE_ID TYPE STRING,
IS_CHILD TYPE STRING,
ASSGN_SCREEN TYPE STRING,
SPLITS TYPE STRING,
SPLIT_DATA TYPE STRING,
SCHED_START_DATE TYPE STRING,
SCHED_START_TIME TYPE STRING,
SCHED_END_DATE TYPE STRING,
SCHED_END_TIME TYPE STRING,
SCHED_TYPE TYPE STRING,
RESTR_START_TYPE TYPE STRING,
RESTR_END_TYPE TYPE STRING,
DEM1_DEM_TYPE TYPE STRING,
DEM1_SERV_GROUP TYPE STRING,
DEM1_ORG_UNIT TYPE STRING,
DEM1_GUID TYPE STRING,
DEM1_BEGDA TYPE STRING,
DEM1_BEG_UZEIT TYPE STRING,
DEM1_ENDDA TYPE STRING,
DEM1_END_UZEIT TYPE STRING,
DEM1_PLVAR TYPE STRING,
DEM1_OTYPE TYPE STRING,
DEM1_OBJID TYPE STRING,
DEM1_STAT_COMPL TYPE STRING,
DEM1_WORKCENTER_GUID TYPE STRING,
DEM1_WORKCENTER_ID TYPE STRING,
DEM1_WORKCENTER_TYPE TYPE STRING,
DEM1_WORKCENTER_PLANT TYPE STRING,
DEM1_SUPERVISOR TYPE STRING,
DEM1_SUPERVISOR_NO TYPE STRING,
DEM1_DURATION_UNIT TYPE STRING,
DEM1_TOTAL_WORK_UNIT TYPE STRING,
DEM1_MULT_RES TYPE STRING,
DEM1_TOTAL_WORK TYPE STRING,
DEM1_DURATION_VAL TYPE STRING,
DEM2_SERV_GROUP TYPE STRING,
DEM2_ORG_UNIT TYPE STRING,
DEM2_GUID TYPE STRING,
DEM2_BEGDA TYPE STRING,
DEM2_BEG_UZEIT TYPE STRING,
DEM2_ENDDA TYPE STRING,
DEM2_END_UZEIT TYPE STRING,
DEM2_PLVAR TYPE STRING,
DEM2_OTYPE TYPE STRING,
DEM2_OBJID TYPE STRING,
DEM2_STAT_COMPL TYPE STRING,
DEM2_WORKCENTER_GUID TYPE STRING,
DEM2_WORKCENTER_ID TYPE STRING,
DEM2_WORKCENTER_TYPE TYPE STRING,
DEM2_WORKCENTER_PLANT TYPE STRING,
DEM2_SUPERVISOR TYPE STRING,
DEM2_SUPERVISOR_NO TYPE STRING,
DEM2_DURATION_UNIT TYPE STRING,
DEM2_TOTAL_WORK TYPE STRING,
DEM2_TOTAL_WORK_UNIT TYPE STRING,
DEM2_MULT_RES TYPE STRING,
DEM2_DURATION_VAL TYPE STRING,
DEM_COVERED_RES TYPE STRING,
DEM_COVERED_SUP TYPE STRING,
DEM_COVERED_DUR TYPE STRING,
DEM_COVERED_DUR_UNIT TYPE STRING,
DEM_OPEN_RES TYPE STRING,
DEM_OPEN_SUP TYPE STRING,
DEM_OPEN_DUR TYPE STRING,
DEM_OPEN_DUR_UNIT TYPE STRING,
TIMESPEC_TYPE TYPE STRING,
TEAM_MEMBERS TYPE STRING,
CAP_PLAN TYPE STRING,
INT_RESOURCE TYPE STRING,
SERV_GROUP TYPE STRING,
WORKCENTER_GUID TYPE STRING,
WORKCENTER_ID TYPE STRING,
WORKCENTER_TYPE TYPE STRING,
WORKCENTER_PLANT TYPE STRING,
CLOCK_STATUS_TEXT TYPE STRING,
QUALIFICATIONS TYPE STRING,
QUALF_RESOURCES TYPE STRING,
QUALF_DEMANDS TYPE STRING,
QUALF_RESULT_STRUC TYPE STRING,
STRUCTURE_NAME TYPE STRING,
TABLE_TYPE TYPE STRING,
KEY_FIELD TYPE STRING,
QUALF_SELECT_ONLY TYPE STRING,
QUALF_NODES_ONLY TYPE STRING,
QUALF_ALL TYPE STRING,
QUALF_PLAN_NODES TYPE STRING,
QUALF_SEL_RES TYPE STRING,
QUALF_SEL_DEM TYPE STRING,
QUALF_DIM1_UP TYPE STRING,
QUALF_DIM1_DOWN TYPE STRING,
QUALF_DIM1_SAME TYPE STRING,
QUALF_DIM2_UP TYPE STRING,
QUALF_DIM2_DOWN TYPE STRING,
QUALF_DIM2_SAME TYPE STRING,
QUALF_ONCA_SEARCHTYPE TYPE STRING,
QUALF_CAPA_FLAG TYPE STRING,
QUALF_DEM_PROFILE TYPE STRING,
PLANNING_RELEV TYPE STRING,
PRED_GUID TYPE STRING,
PRED_TYPE TYPE STRING,
SUCC_GUID TYPE STRING,
SUCC_TYPE TYPE STRING,
REL_TYPE TYPE STRING,
LINE_OFFSET TYPE STRING,
LINE_OFFSET_UNIT TYPE STRING,
LEVEL TYPE STRING,
RESOURCE_DETAIL TYPE STRING,
ORG_UNIT TYPE STRING,
DEM_STATUS TYPE STRING,
ASSGN_STATUS TYPE STRING,
ASSGN_STATUS_TAB TYPE STRING,
STATUS_TAB TYPE STRING,
ASSIGNMENT_TYPE TYPE STRING,
ASS_PROB TYPE STRING,
SUPERVISOR_FLAG TYPE STRING,
SUPERVISOR_NO TYPE STRING,
FRAME_TEXT TYPE STRING,
ONCALL_TYPE TYPE STRING,
NO_TRAVEL_COST TYPE STRING,
MOBILE_INDICATOR TYPE STRING,
CUT_ASS_TYPE TYPE STRING,
MOBILE_STATUS TYPE STRING,
QUALF_CG_TYPE TYPE STRING,
QUALF_CG_TEXT TYPE STRING,
TIME_CALC_CAPA TYPE STRING,
TRV_TO_BEGIN_DATE TYPE STRING,
TRV_TO_BEGIN_TIME TYPE STRING,
TRV_TO_END_DATE TYPE STRING,
TRV_TO_END_TIME TYPE STRING,
TRV_TO_DURATION TYPE STRING,
TRV_TO_DURATION_UNIT TYPE STRING,
TRV_TO_DISTANCE TYPE STRING,
TRV_TO_DIS_UNIT TYPE STRING,
TRV_TO_LOCATION TYPE STRING,
TRV_TO_AUTOMATIC_SET TYPE STRING,
TRV_TO_PROFILE TYPE STRING,
TRV_FROM_BEGIN_DATE TYPE STRING,
TRV_FROM_BEGIN_TIME TYPE STRING,
TRV_FROM_END_DATE TYPE STRING,
TRV_FROM_END_TIME TYPE STRING,
TRV_FROM_DURATION TYPE STRING,
TRV_FROM_DURATION_UNIT TYPE STRING,
TRV_FROM_DISTANCE TYPE STRING,
TRV_FROM_DIS_UNIT TYPE STRING,
TRV_FROM_LOCATION TYPE STRING,
TRV_FROM_AUTOMATIC_SET TYPE STRING,
TRV_FROM_PROFILE TYPE STRING,
TRAVEL_TIME_MODE TYPE STRING,
TRV_DISPLAY_TO TYPE STRING,
TRV_DISPLAY_FROM TYPE STRING,
HR_BEG_DATE TYPE STRING,
HR_END_DATE TYPE STRING,
HR_BEG_TIME TYPE STRING,
HR_END_TIME TYPE STRING,
HR_INFO_TYPE TYPE STRING,
HR_INFO_TYPE_TEXT TYPE STRING,
HR_SUB_TYPE TYPE STRING,
HR_SUB_TYPE_TEXT TYPE STRING,
CONCRETIZE_STR_ASG TYPE STRING,
CONCRETIZE_STR_OPTION TYPE STRING,
PART_CONC_A TYPE STRING,
PART_CONC_B TYPE STRING,
HR_SUBTY TYPE STRING,
TPROG TYPE STRING,
TPTXT TYPE STRING,
VARIA TYPE STRING,
SUBSTITUTION_ALL TYPE STRING,
LS_SUBSTITUTION TYPE STRING,
RESOURCE_NAME TYPE STRING,
PERNR TYPE STRING,
SUBTY TYPE STRING,
OBJPS TYPE STRING,
SPRPS TYPE STRING,
ENDDA TYPE STRING,
BEGDA TYPE STRING,
SEQNR TYPE STRING,
RESOURCE_KEY TYPE STRING,
HR_SUBTY TYPE STRING,
VTEXT TYPE STRING,
BEG_DATE TYPE STRING,
END_DATE TYPE STRING,
TPROG TYPE STRING,
TPTXT TYPE STRING,
CUT_PLANNING_HORIZON TYPE STRING,
IS_DEL_REL TYPE STRING,
VARIA TYPE STRING,
STATUS TYPE STRING,
STATUS_DEL_REL TYPE STRING,
HR_ALL_DAY_FLAG TYPE STRING,
IS_RES_FIXED TYPE STRING,
IS_DATE_FIXED TYPE STRING,
ASG_FOLLOWS_DEMAND TYPE STRING,
OPT_LEAD_TIME TYPE STRING,
OPT_SCENARIO_KEY TYPE STRING,
OPT_LOG_PROFILE_KEY TYPE STRING,
OPT_PROFILE TYPE STRING,
OPT_GEO_PROFILE TYPE STRING,
OPT_MAX_RUNTIME TYPE STRING,
OPT_MAX_TRAVEL_BREAK TYPE STRING,
CUST_ATTR_FNAME TYPE STRING,
CUST_ATTR_VALUE TYPE STRING,
CUSTOMER_ADDRESS TYPE STRING,
ADDRESS_GUID TYPE STRING,
ADDRESS_KEY TYPE STRING,
STREET TYPE STRING,
HOUSE_NUM TYPE STRING,
CITY TYPE STRING,
CITY_DISTRICT TYPE STRING,
POST_CODE TYPE STRING,
COUNTRY TYPE STRING,
REGION TYPE STRING,
SEC_ADDRESS TYPE STRING,
ACTIVE TYPE STRING,
LONGITUDE TYPE STRING,
LATITUDE TYPE STRING,
ALTITUDE TYPE STRING,
PRECISID TYPE STRING,
SOURCE_ID TYPE STRING,
SOURCE_TSTMP TYPE STRING,
ADDRESS_TYPE TYPE STRING,
VALID_FROM TYPE STRING,
VALID_TO TYPE STRING,
CHANGED_ON TYPE STRING,
ADDRESS_SOURCE TYPE STRING,
LOCATION TYPE STRING,
BUILDING TYPE STRING,
FLOOR TYPE STRING,
ROOMNUMBER TYPE STRING,
TRV_FROM_ADDRESS TYPE STRING,
ADDRESS_GUID TYPE STRING,
ADDRESS_KEY TYPE STRING,
STREET TYPE STRING,
HOUSE_NUM TYPE STRING,
CITY TYPE STRING,
CITY_DISTRICT TYPE STRING,
POST_CODE TYPE STRING,
COUNTRY TYPE STRING,
REGION TYPE STRING,
SEC_ADDRESS TYPE STRING,
ACTIVE TYPE STRING,
LONGITUDE TYPE STRING,
LATITUDE TYPE STRING,
ALTITUDE TYPE STRING,
PRECISID TYPE STRING,
SOURCE_ID TYPE STRING,
SOURCE_TSTMP TYPE STRING,
ADDRESS_TYPE TYPE STRING,
VALID_FROM TYPE STRING,
VALID_TO TYPE STRING,
CHANGED_ON TYPE STRING,
ADDRESS_SOURCE TYPE STRING,
LOCATION TYPE STRING,
BUILDING TYPE STRING,
FLOOR TYPE STRING,
ROOMNUMBER TYPE STRING,
TRV_TO_ADDRESS TYPE STRING,
ADDRESS_GUID TYPE STRING,
ADDRESS_KEY TYPE STRING,
STREET TYPE STRING,
HOUSE_NUM TYPE STRING,
CITY TYPE STRING,
CITY_DISTRICT TYPE STRING,
POST_CODE TYPE STRING,
COUNTRY TYPE STRING,
REGION TYPE STRING,
SEC_ADDRESS TYPE STRING,
ACTIVE TYPE STRING,
LONGITUDE TYPE STRING,
LATITUDE TYPE STRING,
ALTITUDE TYPE STRING,
PRECISID TYPE STRING,
SOURCE_ID TYPE STRING,
SOURCE_TSTMP TYPE STRING,
ADDRESS_TYPE TYPE STRING,
VALID_FROM TYPE STRING,
VALID_TO TYPE STRING,
CHANGED_ON TYPE STRING,
ADDRESS_SOURCE TYPE STRING,
LOCATION TYPE STRING,
BUILDING TYPE STRING,
FLOOR TYPE STRING,
ROOMNUMBER TYPE STRING,
DEM_NOTES TYPE STRING,
GUID TYPE STRING,
LOGSYS TYPE STRING,
KEY_EXT TYPE STRING,
SPRAS TYPE STRING,
NOTE_TYPE TYPE STRING,
NOTE_TEXT TYPE STRING,
DEMAND_PRIORITY TYPE STRING,
DEM1_MULT_SLOTS TYPE STRING,
REASON TYPE STRING,
RESOURCES TYPE STRING,
QUAL_ASGN_CUT TYPE STRING,
CONCRETIZE_ASG TYPE STRING,
ASG_CONCR_TYPE TYPE STRING,
C_MONDAY TYPE STRING,
C_TUESDAY TYPE STRING,
C_WEDNESDAY TYPE STRING,
C_THURSDAY TYPE STRING,
C_FRIDAY TYPE STRING,
C_SATURDAY TYPE STRING,
C_SUNDAY TYPE STRING,
C_BEGDA TYPE STRING,
C_BEG_UZEIT TYPE STRING,
C_DURATION TYPE STRING,
C_DURATION_UNIT TYPE STRING,
C_ENDDA TYPE STRING,
C_END_UZEIT TYPE STRING,
DUMMY TYPE STRING,
OPTIMIZE_AFTER TYPE STRING,
DEMAND_DESCRIPTION TYPE STRING,
TYPE_ICON TYPE STRING,
STATUS_ICON TYPE STRING,
OLD TYPE STRING,
NOTE TYPE STRING,
DEPARTMENT TYPE STRING,
TEL1_NUMBR TYPE STRING,
FAX_NUMBER TYPE STRING,
E_MAIL TYPE STRING,
DEL_FLAG TYPE STRING,
EDIT_MODE TYPE STRING,
EDIT_MODE_ICON TYPE STRING,
CELLTAB TYPE STRING,
FIELD1 TYPE STRING,
FIELD2 TYPE STRING,
FIELD3 TYPE STRING,
FIELD4 TYPE STRING,
FIELD5 TYPE STRING,
FIELD6 TYPE STRING,
FIELD7 TYPE STRING,
FIELD8 TYPE STRING,
FIELD9 TYPE STRING,
FIELD10 TYPE STRING,
FIELD11 TYPE STRING,
FIELD12 TYPE STRING,
FIELD13 TYPE STRING,
FIELD14 TYPE STRING,
FIELD15 TYPE STRING,
FIELD16 TYPE STRING,
FIELD17 TYPE STRING,
FIELD18 TYPE STRING,
FIELD19 TYPE STRING,
FIELD20 TYPE STRING,
FIELD21 TYPE STRING,
FIELD22 TYPE STRING,
FIELD23 TYPE STRING,
FIELD24 TYPE STRING,
FIELD25 TYPE STRING,
FIELD26 TYPE STRING,
FIELD27 TYPE STRING,
FIELD28 TYPE STRING,
FIELD29 TYPE STRING,
FIELD30 TYPE STRING,
PERSONNEL_NO TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/MRSS/T_SGU_COMM_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_/MRSS/T_SGU_COMM_ALV_STR-TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-OPERATION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TIMESPEC_ID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ASSIGNMENT_KEY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-PARENT_GUID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LINK_ID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-WORKITEM_ID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-WORKITEM_NAME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ORIG_ITEM_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEMAND_LOGSYS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESOURCE_ID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESOURCE_NAME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESOURCE_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESOURCE_REL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESOURCE2_ID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESOURCE2_NAME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESOURCE2_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESOURCE2_REL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TEAM_ID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DESCRIPTION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-BEGDA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-BEG_UZEIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ENDDA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-END_UZEIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DURATION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DURATION_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DURATION_VAL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DURATION_ORIGINAL_VAL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TOTAL_WORK sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TOTAL_WORK_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-MULT_RES sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-UTIL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-STATUS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TIME_RULE_ID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-IS_CHILD sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ASSGN_SCREEN sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SPLITS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SPLIT_DATA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SCHED_START_DATE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SCHED_START_TIME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SCHED_END_DATE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SCHED_END_TIME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SCHED_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESTR_START_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESTR_END_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_DEM_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_SERV_GROUP sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_ORG_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_GUID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_BEGDA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_BEG_UZEIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_ENDDA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_END_UZEIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_PLVAR sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_OTYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_OBJID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_STAT_COMPL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_WORKCENTER_GUID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_WORKCENTER_ID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_WORKCENTER_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_WORKCENTER_PLANT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_SUPERVISOR sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_SUPERVISOR_NO sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_DURATION_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_TOTAL_WORK_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_MULT_RES sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_TOTAL_WORK sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_DURATION_VAL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_SERV_GROUP sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_ORG_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_GUID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_BEGDA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_BEG_UZEIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_ENDDA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_END_UZEIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_PLVAR sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_OTYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_OBJID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_STAT_COMPL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_WORKCENTER_GUID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_WORKCENTER_ID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_WORKCENTER_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_WORKCENTER_PLANT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_SUPERVISOR sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_SUPERVISOR_NO sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_DURATION_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_TOTAL_WORK sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_TOTAL_WORK_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_MULT_RES sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM2_DURATION_VAL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM_COVERED_RES sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM_COVERED_SUP sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM_COVERED_DUR sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM_COVERED_DUR_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM_OPEN_RES sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM_OPEN_SUP sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM_OPEN_DUR sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM_OPEN_DUR_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TIMESPEC_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TEAM_MEMBERS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CAP_PLAN sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-INT_RESOURCE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SERV_GROUP sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-WORKCENTER_GUID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-WORKCENTER_ID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-WORKCENTER_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-WORKCENTER_PLANT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CLOCK_STATUS_TEXT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALIFICATIONS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_RESOURCES sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_DEMANDS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_RESULT_STRUC sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-STRUCTURE_NAME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TABLE_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-KEY_FIELD sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_SELECT_ONLY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_NODES_ONLY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_ALL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_PLAN_NODES sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_SEL_RES sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_SEL_DEM sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_DIM1_UP sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_DIM1_DOWN sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_DIM1_SAME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_DIM2_UP sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_DIM2_DOWN sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_DIM2_SAME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_ONCA_SEARCHTYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_CAPA_FLAG sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_DEM_PROFILE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-PLANNING_RELEV sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-PRED_GUID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-PRED_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SUCC_GUID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SUCC_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-REL_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LINE_OFFSET sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LINE_OFFSET_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LEVEL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESOURCE_DETAIL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ORG_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM_STATUS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ASSGN_STATUS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ASSGN_STATUS_TAB sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-STATUS_TAB sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ASSIGNMENT_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ASS_PROB sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SUPERVISOR_FLAG sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SUPERVISOR_NO sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FRAME_TEXT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ONCALL_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-NO_TRAVEL_COST sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-MOBILE_INDICATOR sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CUT_ASS_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-MOBILE_STATUS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_CG_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUALF_CG_TEXT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TIME_CALC_CAPA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_TO_BEGIN_DATE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_TO_BEGIN_TIME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_TO_END_DATE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_TO_END_TIME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_TO_DURATION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_TO_DURATION_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_TO_DISTANCE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_TO_DIS_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_TO_LOCATION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_TO_AUTOMATIC_SET sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_TO_PROFILE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_FROM_BEGIN_DATE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_FROM_BEGIN_TIME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_FROM_END_DATE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_FROM_END_TIME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_FROM_DURATION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_FROM_DURATION_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_FROM_DISTANCE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_FROM_DIS_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_FROM_LOCATION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_FROM_AUTOMATIC_SET sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_FROM_PROFILE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRAVEL_TIME_MODE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_DISPLAY_TO sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_DISPLAY_FROM sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HR_BEG_DATE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HR_END_DATE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HR_BEG_TIME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HR_END_TIME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HR_INFO_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HR_INFO_TYPE_TEXT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HR_SUB_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HR_SUB_TYPE_TEXT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CONCRETIZE_STR_ASG sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CONCRETIZE_STR_OPTION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-PART_CONC_A sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-PART_CONC_B sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HR_SUBTY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TPROG sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TPTXT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-VARIA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SUBSTITUTION_ALL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LS_SUBSTITUTION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESOURCE_NAME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-PERNR sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SUBTY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-OBJPS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SPRPS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ENDDA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-BEGDA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SEQNR sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESOURCE_KEY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HR_SUBTY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-VTEXT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-BEG_DATE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-END_DATE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TPROG sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TPTXT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CUT_PLANNING_HORIZON sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-IS_DEL_REL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-VARIA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-STATUS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-STATUS_DEL_REL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HR_ALL_DAY_FLAG sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-IS_RES_FIXED sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-IS_DATE_FIXED sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ASG_FOLLOWS_DEMAND sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-OPT_LEAD_TIME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-OPT_SCENARIO_KEY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-OPT_LOG_PROFILE_KEY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-OPT_PROFILE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-OPT_GEO_PROFILE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-OPT_MAX_RUNTIME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-OPT_MAX_TRAVEL_BREAK sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CUST_ATTR_FNAME sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CUST_ATTR_VALUE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CUSTOMER_ADDRESS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ADDRESS_GUID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ADDRESS_KEY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-STREET sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HOUSE_NUM sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CITY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CITY_DISTRICT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-POST_CODE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-COUNTRY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-REGION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SEC_ADDRESS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ACTIVE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LONGITUDE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LATITUDE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ALTITUDE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-PRECISID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SOURCE_ID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SOURCE_TSTMP sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ADDRESS_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-VALID_FROM sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-VALID_TO sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CHANGED_ON sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ADDRESS_SOURCE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LOCATION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-BUILDING sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FLOOR sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ROOMNUMBER sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_FROM_ADDRESS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ADDRESS_GUID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ADDRESS_KEY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-STREET sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HOUSE_NUM sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CITY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CITY_DISTRICT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-POST_CODE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-COUNTRY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-REGION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SEC_ADDRESS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ACTIVE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LONGITUDE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LATITUDE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ALTITUDE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-PRECISID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SOURCE_ID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SOURCE_TSTMP sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ADDRESS_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-VALID_FROM sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-VALID_TO sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CHANGED_ON sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ADDRESS_SOURCE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LOCATION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-BUILDING sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FLOOR sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ROOMNUMBER sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TRV_TO_ADDRESS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ADDRESS_GUID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ADDRESS_KEY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-STREET sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-HOUSE_NUM sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CITY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CITY_DISTRICT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-POST_CODE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-COUNTRY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-REGION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SEC_ADDRESS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ACTIVE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LONGITUDE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LATITUDE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ALTITUDE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-PRECISID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SOURCE_ID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SOURCE_TSTMP sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ADDRESS_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-VALID_FROM sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-VALID_TO sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CHANGED_ON sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ADDRESS_SOURCE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LOCATION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-BUILDING sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FLOOR sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ROOMNUMBER sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM_NOTES sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-GUID sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-LOGSYS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-KEY_EXT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-SPRAS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-NOTE_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-NOTE_TEXT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEMAND_PRIORITY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEM1_MULT_SLOTS sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-REASON sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-RESOURCES sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-QUAL_ASGN_CUT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CONCRETIZE_ASG sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-ASG_CONCR_TYPE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-C_MONDAY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-C_TUESDAY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-C_WEDNESDAY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-C_THURSDAY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-C_FRIDAY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-C_SATURDAY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-C_SUNDAY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-C_BEGDA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-C_BEG_UZEIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-C_DURATION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-C_DURATION_UNIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-C_ENDDA sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-C_END_UZEIT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DUMMY sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-OPTIMIZE_AFTER sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEMAND_DESCRIPTION sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TYPE_ICON sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-STATUS_ICON sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-OLD sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-NOTE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEPARTMENT sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-TEL1_NUMBR sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FAX_NUMBER sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-E_MAIL sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-DEL_FLAG sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-EDIT_MODE sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-EDIT_MODE_ICON sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-CELLTAB sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD1 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD2 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD3 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD4 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD5 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD6 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD7 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD8 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD9 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD10 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD11 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD12 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD13 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD14 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD15 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD16 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD17 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD18 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD19 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD20 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD21 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD22 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD23 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD24 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD25 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD26 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD27 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD28 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD29 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-FIELD30 sy-vline 
WA_/MRSS/T_SGU_COMM_ALV_STR-PERSONNEL_NO sy-vline      INTO ld_text SEPARATED BY SPACE.

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