ABAP Select data from SAP table HRPAYCO_S_PILA_RECORD_02 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 HRPAYCO_S_PILA_RECORD_02 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 HRPAYCO_S_PILA_RECORD_02. 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 HRPAYCO_S_PILA_RECORD_02 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_HRPAYCO_S_PILA_RECORD_02 TYPE STANDARD TABLE OF HRPAYCO_S_PILA_RECORD_02,
      WA_HRPAYCO_S_PILA_RECORD_02 TYPE HRPAYCO_S_PILA_RECORD_02,
      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: <HRPAYCO_S_PILA_RECORD_02> TYPE HRPAYCO_S_PILA_RECORD_02.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM HRPAYCO_S_PILA_RECORD_02
*  INTO TABLE @DATA(IT_HRPAYCO_S_PILA_RECORD_022).
*--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_HRPAYCO_S_PILA_RECORD_02 INDEX 1 INTO DATA(WA_HRPAYCO_S_PILA_RECORD_022).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<HRPAYCO_S_PILA_RECORD_02>-RECORD_ID = 1.
<HRPAYCO_S_PILA_RECORD_02>-SEQNR = 1.
<HRPAYCO_S_PILA_RECORD_02>-DOCUMENT_TYPE = 1.
<HRPAYCO_S_PILA_RECORD_02>-ICNUM = 1.
<HRPAYCO_S_PILA_RECORD_02>-CONTRIBUTOR_TYPE = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_HRPAYCO_S_PILA_RECORD_02-CONTRIBUTOR_SUBTYPE, sy-vline,
  WA_HRPAYCO_S_PILA_RECORD_02-FOREIGNER_NO_PENSIONS, sy-vline,
  WA_HRPAYCO_S_PILA_RECORD_02-COLOMBIAN_ABROAD, sy-vline,
  WA_HRPAYCO_S_PILA_RECORD_02-WORK_DEPARTMENT, sy-vline,
  WA_HRPAYCO_S_PILA_RECORD_02-CITY_ID, sy-vline,
  WA_HRPAYCO_S_PILA_RECORD_02-LAST_NAME, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_HRPAYCO_S_PILA_RECORD_02 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_HRPAYCO_S_PILA_RECORD_02 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_HRPAYCO_S_PILA_RECORD_02 INTO WA_HRPAYCO_S_PILA_RECORD_02.


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

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

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

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

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

*Conversion exit ALPHA, internal->external for field LABOR_ADMINISTRATING_ENTITY_ID
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_HRPAYCO_S_PILA_RECORD_02-LABOR_ADMINISTRATING_ENTITY_ID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_HRPAYCO_S_PILA_RECORD_02-LABOR_ADMINISTRATING_ENTITY_ID.
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_HRPAYCO_S_PILA_RECORD_02_STR, 
RECORD_ID TYPE STRING,
SEQNR TYPE STRING,
DOCUMENT_TYPE TYPE STRING,
ICNUM TYPE STRING,
CONTRIBUTOR_TYPE TYPE STRING,
CONTRIBUTOR_SUBTYPE TYPE STRING,
FOREIGNER_NO_PENSIONS TYPE STRING,
COLOMBIAN_ABROAD TYPE STRING,
WORK_DEPARTMENT TYPE STRING,
CITY_ID TYPE STRING,
LAST_NAME TYPE STRING,
LAST_NAME_2 TYPE STRING,
FIRST_NAME TYPE STRING,
SECOND_NAME TYPE STRING,
INDICATOR_HIRE TYPE STRING,
INDICATOR_FIRE TYPE STRING,
INDICATOR_FROM_EPS TYPE STRING,
INDICATOR_TO_EPS TYPE STRING,
INDICATOR_FROM_AFP TYPE STRING,
INDICATOR_TO_AFP TYPE STRING,
IND_PERMANENT_SALARY_VARIATION TYPE STRING,
CORRECTIONS TYPE STRING,
IND_TEMPORARY_SALARY_VARIATION TYPE STRING,
IND_TEMPORARY_SUSPENSION TYPE STRING,
IND_GENERAL_INCAPACITY TYPE STRING,
IND_MATERNITY_LEAVE TYPE STRING,
IND_LEAVE TYPE STRING,
IND_CONTRIBUTIONS_PENSIONS TYPE STRING,
IND_WORK_CENTER_VARIATION TYPE STRING,
DAYS_ACCIDENT TYPE STRING,
PENSION_ADMINISTRATOR_ID TYPE STRING,
NEW_PENSION_ADMINISTRATOR_ID TYPE STRING,
HEALTH_ORGANIZATION_ID TYPE STRING,
NEW_HEALTH_ORGANIZATION_ID TYPE STRING,
ENTITY_COMPENSATION_FUND_ID TYPE STRING,
PENSION_DAYS TYPE STRING,
HEALTH_DAYS TYPE STRING,
DAYS_OF_RISKS TYPE STRING,
DAYS_COMPENSATION_FUND TYPE STRING,
SALARY TYPE STRING,
FULL_SALARY TYPE STRING,
BASIC_PENSION_FOR_IBC TYPE STRING,
BASIC_HEALTH_FOR_IBC TYPE STRING,
BASIC_OCCUPATIONAL_HAZARDS_IBC TYPE STRING,
BASIC_CAJA_FOR_IBC TYPE STRING,
PERCENTAGE_PENSIONS TYPE STRING,
VALUE_PENSION_CONTRIBUTION TYPE STRING,
VOLUNTARY_EMPLOYEE TYPE STRING,
VOLUNTARY_EMPLOYER TYPE STRING,
TOTAL_CONTRIBUTION TYPE STRING,
SOLIDARITY_FUND TYPE STRING,
CONTRIBUTION_TO_SUBSISTENCE TYPE STRING,
NOT_RETAINED_VALUES TYPE STRING,
PERCENTAGE_HEALTH TYPE STRING,
HEALTH_VALUE TYPE STRING,
CAPITATION_PAYMENT_UNIT_VALUE TYPE STRING,
APPROVAL_NUMBER_IGE TYPE STRING,
DISABILITY_VALUE_IGE TYPE STRING,
MATERNITY_APPROVAL_VALUE TYPE STRING,
MATERNITY_VALUE TYPE STRING,
PERCENTAGE_PROFESSIONAL_RISKS TYPE STRING,
WORK_CENTER TYPE STRING,
OCCUPATIONAL_HAZARD_CONTRIBUT TYPE STRING,
FUND_PERCENTAGE TYPE STRING,
FAMILY_COMPENSATION_FUND TYPE STRING,
SENA_PERCENTAGE TYPE STRING,
SENA_CONTRIBUTION TYPE STRING,
ICBF_PERCENTAGE TYPE STRING,
ICBF_CONTRIBUTION TYPE STRING,
ESAP_PERCENTAGE TYPE STRING,
ESAP_CONTRIBUTION TYPE STRING,
PERCENTAGE_OF_EDUCATION TYPE STRING,
EDUCATION_CONTRIBUTION TYPE STRING,
DOCUMENT_TYPE_MAIN_CONTRIBUTOR TYPE STRING,
ID_CONTRIB TYPE STRING,
EXEMPT_CONTRIBUTOR TYPE STRING,
LABOR_ADMINISTRATING_ENTITY_ID TYPE STRING,
RISK_CLASS TYPE STRING,
INDICATOR_PENSION_SPECIAL_RATE TYPE STRING,
BEGIN_DATE_ENTRY TYPE STRING,
BEGIN_DATE_LEAVE TYPE STRING,
BEGIN_DATE_PERMAN_SALARY_VAR TYPE STRING,
BEGIN_DATE_TEMP_SUSPENSION TYPE STRING,
END_DATE_TEMP_SUSPENSION TYPE STRING,
BEGIN_DATE_GENERAL_INCAPACITY TYPE STRING,
END_DATE_GENERAL_INCAPACITY TYPE STRING,
BEGIN_DATE_MATERNITY_LEAVE TYPE STRING,
END_DATE_MATERNITY_LEAVE TYPE STRING,
BEGIN_DATE_VACATIONS TYPE STRING,
END_DATE_VACATIONS TYPE STRING,
BEGIN_DATE_WORK_CENTER_VARIAT TYPE STRING,
END_DATE_WORK_CENTER_VARIAT TYPE STRING,
BEGIN_DATE_IRL TYPE STRING,
END_DATE_IRL TYPE STRING,
IBC_NON_CCF TYPE STRING,
LABOR_HOURS TYPE STRING,
ABROAD_BEGIN_DATE TYPE STRING,
WAERS TYPE STRING,
PERNR TYPE STRING,END OF T_EKKO_STR.
DATA: WA_HRPAYCO_S_PILA_RECORD_02_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_HRPAYCO_S_PILA_RECORD_02_STR-RECORD_ID sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-SEQNR sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-DOCUMENT_TYPE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-ICNUM sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-CONTRIBUTOR_TYPE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-CONTRIBUTOR_SUBTYPE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-FOREIGNER_NO_PENSIONS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-COLOMBIAN_ABROAD sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-WORK_DEPARTMENT sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-CITY_ID sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-LAST_NAME sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-LAST_NAME_2 sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-FIRST_NAME sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-SECOND_NAME sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-INDICATOR_HIRE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-INDICATOR_FIRE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-INDICATOR_FROM_EPS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-INDICATOR_TO_EPS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-INDICATOR_FROM_AFP sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-INDICATOR_TO_AFP sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-IND_PERMANENT_SALARY_VARIATION sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-CORRECTIONS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-IND_TEMPORARY_SALARY_VARIATION sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-IND_TEMPORARY_SUSPENSION sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-IND_GENERAL_INCAPACITY sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-IND_MATERNITY_LEAVE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-IND_LEAVE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-IND_CONTRIBUTIONS_PENSIONS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-IND_WORK_CENTER_VARIATION sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-DAYS_ACCIDENT sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-PENSION_ADMINISTRATOR_ID sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-NEW_PENSION_ADMINISTRATOR_ID sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-HEALTH_ORGANIZATION_ID sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-NEW_HEALTH_ORGANIZATION_ID sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-ENTITY_COMPENSATION_FUND_ID sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-PENSION_DAYS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-HEALTH_DAYS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-DAYS_OF_RISKS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-DAYS_COMPENSATION_FUND sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-SALARY sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-FULL_SALARY sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-BASIC_PENSION_FOR_IBC sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-BASIC_HEALTH_FOR_IBC sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-BASIC_OCCUPATIONAL_HAZARDS_IBC sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-BASIC_CAJA_FOR_IBC sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-PERCENTAGE_PENSIONS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-VALUE_PENSION_CONTRIBUTION sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-VOLUNTARY_EMPLOYEE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-VOLUNTARY_EMPLOYER sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-TOTAL_CONTRIBUTION sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-SOLIDARITY_FUND sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-CONTRIBUTION_TO_SUBSISTENCE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-NOT_RETAINED_VALUES sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-PERCENTAGE_HEALTH sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-HEALTH_VALUE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-CAPITATION_PAYMENT_UNIT_VALUE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-APPROVAL_NUMBER_IGE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-DISABILITY_VALUE_IGE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-MATERNITY_APPROVAL_VALUE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-MATERNITY_VALUE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-PERCENTAGE_PROFESSIONAL_RISKS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-WORK_CENTER sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-OCCUPATIONAL_HAZARD_CONTRIBUT sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-FUND_PERCENTAGE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-FAMILY_COMPENSATION_FUND sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-SENA_PERCENTAGE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-SENA_CONTRIBUTION sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-ICBF_PERCENTAGE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-ICBF_CONTRIBUTION sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-ESAP_PERCENTAGE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-ESAP_CONTRIBUTION sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-PERCENTAGE_OF_EDUCATION sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-EDUCATION_CONTRIBUTION sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-DOCUMENT_TYPE_MAIN_CONTRIBUTOR sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-ID_CONTRIB sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-EXEMPT_CONTRIBUTOR sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-LABOR_ADMINISTRATING_ENTITY_ID sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-RISK_CLASS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-INDICATOR_PENSION_SPECIAL_RATE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-BEGIN_DATE_ENTRY sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-BEGIN_DATE_LEAVE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-BEGIN_DATE_PERMAN_SALARY_VAR sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-BEGIN_DATE_TEMP_SUSPENSION sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-END_DATE_TEMP_SUSPENSION sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-BEGIN_DATE_GENERAL_INCAPACITY sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-END_DATE_GENERAL_INCAPACITY sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-BEGIN_DATE_MATERNITY_LEAVE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-END_DATE_MATERNITY_LEAVE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-BEGIN_DATE_VACATIONS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-END_DATE_VACATIONS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-BEGIN_DATE_WORK_CENTER_VARIAT sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-END_DATE_WORK_CENTER_VARIAT sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-BEGIN_DATE_IRL sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-END_DATE_IRL sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-IBC_NON_CCF sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-LABOR_HOURS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-ABROAD_BEGIN_DATE sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-WAERS sy-vline 
WA_HRPAYCO_S_PILA_RECORD_02_STR-PERNR sy-vline      INTO ld_text SEPARATED BY SPACE.

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