ABAP Select data from SAP table EHHSSV_SMPL4LOC into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP EHHSSV_SMPL4LOC 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 EHHSSV_SMPL4LOC. 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 EHHSSV_SMPL4LOC 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_EHHSSV_SMPL4LOC TYPE STANDARD TABLE OF EHHSSV_SMPL4LOC,
      WA_EHHSSV_SMPL4LOC TYPE EHHSSV_SMPL4LOC,
      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: <EHHSSV_SMPL4LOC> TYPE EHHSSV_SMPL4LOC.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM EHHSSV_SMPL4LOC
*  INTO TABLE @DATA(IT_EHHSSV_SMPL4LOC2).
*--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_EHHSSV_SMPL4LOC INDEX 1 INTO DATA(WA_EHHSSV_SMPL4LOC2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_EHHSSV_SMPL4LOC ASSIGNING <EHHSSV_SMPL4LOC>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<EHHSSV_SMPL4LOC>-MANDT = 1.
<EHHSSV_SMPL4LOC>-SPLNG_SPL_KEY = 1.
<EHHSSV_SMPL4LOC>-AMOUNT_ROOT_KEY = 1.
<EHHSSV_SMPL4LOC>-SAMPLING_CAMPAIGN_KEY = 1.
<EHHSSV_SMPL4LOC>-JOB_KEY_REF = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_EHHSSV_SMPL4LOC-ABAGT_KEY_REF, sy-vline,
WA_EHHSSV_SMPL4LOC-AGENT_KEY_REF, sy-vline,
WA_EHHSSV_SMPL4LOC-CMA_KEY_REF, sy-vline,
WA_EHHSSV_SMPL4LOC-SAMPLING_METHOD_REF, sy-vline,
WA_EHHSSV_SMPL4LOC-REQUESTED_SAMPLE_COUNT, sy-vline,
WA_EHHSSV_SMPL4LOC-OP_STATUS, sy-vline.
ENDLOOP. *Add any further fields from structure WA_EHHSSV_SMPL4LOC 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_EHHSSV_SMPL4LOC 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_EHHSSV_SMPL4LOC INTO WA_EHHSSV_SMPL4LOC. *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 EHJID, internal->external for field JOB_KEY_REF CALL FUNCTION 'CONVERSION_EXIT_EHJID_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-JOB_KEY_REF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-JOB_KEY_REF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EHAAG, internal->external for field ABAGT_KEY_REF CALL FUNCTION 'CONVERSION_EXIT_EHAAG_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-ABAGT_KEY_REF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-ABAGT_KEY_REF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EHAGD, internal->external for field AGENT_KEY_REF CALL FUNCTION 'CONVERSION_EXIT_EHAGD_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-AGENT_KEY_REF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-AGENT_KEY_REF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EHCMD, internal->external for field CMA_KEY_REF CALL FUNCTION 'CONVERSION_EXIT_EHCMD_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-CMA_KEY_REF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-CMA_KEY_REF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ESMID, internal->external for field SAMPLING_METHOD_REF CALL FUNCTION 'CONVERSION_EXIT_ESMID_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-SAMPLING_METHOD_REF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-SAMPLING_METHOD_REF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EHOPS, internal->external for field OP_STATUS CALL FUNCTION 'CONVERSION_EXIT_EHOPS_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-OP_STATUS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-OP_STATUS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CHFLT, internal->external for field VALUE CALL FUNCTION 'CONVERSION_EXIT_CHFLT_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-VALUE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-VALUE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EHUNI, internal->external for field VALUEUNIT CALL FUNCTION 'CONVERSION_EXIT_EHUNI_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-VALUEUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-VALUEUNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EHVLT, internal->external for field VALUETYPE CALL FUNCTION 'CONVERSION_EXIT_EHVLT_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-VALUETYPE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-VALUETYPE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit DFVAL, internal->external for field STATUS CALL FUNCTION 'CONVERSION_EXIT_DFVAL_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-STATUS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-STATUS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EHAMC, internal->external for field AMOUNTCATEGORY CALL FUNCTION 'CONVERSION_EXIT_EHAMC_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-AMOUNTCATEGORY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-AMOUNTCATEGORY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit DFVAL, internal->external for field OUTOFPRECISENESS_OPERATOR CALL FUNCTION 'CONVERSION_EXIT_DFVAL_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-OUTOFPRECISENESS_OPERATOR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-OUTOFPRECISENESS_OPERATOR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field START_TIMESTAMP CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-START_TIMESTAMP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-START_TIMESTAMP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field END_TIMESTAMP CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-END_TIMESTAMP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-END_TIMESTAMP.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit EHQUN, internal->external for field FLOW_RATE_START CALL FUNCTION 'CONVERSION_EXIT_EHQUN_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-FLOW_RATE_START IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-FLOW_RATE_START.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EHQUN, internal->external for field FLOW_RATE_END CALL FUNCTION 'CONVERSION_EXIT_EHQUN_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-FLOW_RATE_END IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-FLOW_RATE_END.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EHUNI, internal->external for field FLOW_RATE_UNIT CALL FUNCTION 'CONVERSION_EXIT_EHUNI_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-FLOW_RATE_UNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-FLOW_RATE_UNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PARID, internal->external for field PERSON_SAMPLED CALL FUNCTION 'CONVERSION_EXIT_PARID_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-PERSON_SAMPLED IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-PERSON_SAMPLED.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EHCKR, internal->external for field PPE_WORN CALL FUNCTION 'CONVERSION_EXIT_EHCKR_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-PPE_WORN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-PPE_WORN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EHSPT, internal->external for field SHIFT_PATTERN CALL FUNCTION 'CONVERSION_EXIT_EHSPT_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-SHIFT_PATTERN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-SHIFT_PATTERN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit DFVAL, internal->external for field VALIDITY CALL FUNCTION 'CONVERSION_EXIT_DFVAL_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-VALIDITY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-VALIDITY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit LCRID, internal->external for field LOC_ROOT_KEY_REF CALL FUNCTION 'CONVERSION_EXIT_LCRID_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-LOC_ROOT_KEY_REF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-LOC_ROOT_KEY_REF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ESMID, internal->external for field METHOD_REF CALL FUNCTION 'CONVERSION_EXIT_ESMID_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-METHOD_REF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-METHOD_REF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SYUID, internal->external for field TECHNICIAN CALL FUNCTION 'CONVERSION_EXIT_SYUID_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-TECHNICIAN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-TECHNICIAN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit DFVAL, internal->external for field PROCESSING_PHASE CALL FUNCTION 'CONVERSION_EXIT_DFVAL_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-PROCESSING_PHASE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-PROCESSING_PHASE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EHUNI, internal->external for field HIGHEST_BLANK_UNIT CALL FUNCTION 'CONVERSION_EXIT_EHUNI_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-HIGHEST_BLANK_UNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-HIGHEST_BLANK_UNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit LCAUT, internal->external for field LOC_AUTH_GROUP CALL FUNCTION 'CONVERSION_EXIT_LCAUT_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-LOC_AUTH_GROUP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-LOC_AUTH_GROUP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field COST_CENTER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_EHHSSV_SMPL4LOC-COST_CENTER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_EHHSSV_SMPL4LOC-COST_CENTER.
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_EHHSSV_SMPL4LOC_STR,
MANDT TYPE STRING,
SPLNG_SPL_KEY TYPE STRING,
AMOUNT_ROOT_KEY TYPE STRING,
SAMPLING_CAMPAIGN_KEY TYPE STRING,
JOB_KEY_REF TYPE STRING,
ABAGT_KEY_REF TYPE STRING,
AGENT_KEY_REF TYPE STRING,
CMA_KEY_REF TYPE STRING,
SAMPLING_METHOD_REF TYPE STRING,
REQUESTED_SAMPLE_COUNT TYPE STRING,
OP_STATUS TYPE STRING,
SUBJECT_NAME TYPE STRING,
SUBJECT_LANGUAGE TYPE STRING,
LISTEDSUBSTANCECNDNCODE TYPE STRING,
SUBJECT_ROOT_KEY_REF TYPE STRING,
SUBJECTTYPE TYPE STRING,
VALUE TYPE STRING,
VALUEUNIT TYPE STRING,
VALUETYPE TYPE STRING,
STATUS TYPE STRING,
AMOUNTCATEGORY TYPE STRING,
OUTOFPRECISENESS_OPERATOR TYPE STRING,
BLANK_INDICATOR TYPE STRING,
BLANK_TYPE TYPE STRING,
START_TIMESTAMP TYPE STRING,
START_DATE TYPE STRING,
START_TIME TYPE STRING,
SAMPLE_DATE_YEAR TYPE STRING,
SAMPLE_DATE_MONTH TYPE STRING,
SAMPLE_DATE_DAY TYPE STRING,
END_TIMESTAMP TYPE STRING,
END_DATE TYPE STRING,
END_TIME TYPE STRING,
EQUIPMENT_ID TYPE STRING,
SAMPLE_ID TYPE STRING,
MEDIA_ID TYPE STRING,
EQUIPMENT_CALIBRATED_IND TYPE STRING,
CALIB_REPORT_KEY_REF TYPE STRING,
FIELD_SHEET_KEY_REF TYPE STRING,
FLOW_RATE_START TYPE STRING,
FLOW_RATE_END TYPE STRING,
FLOW_RATE_UNIT TYPE STRING,
PERSON_SAMPLED TYPE STRING,
PPE_WORN TYPE STRING,
SHIFT_PATTERN TYPE STRING,
SUBSTANTIATION TYPE STRING,
VALIDITY TYPE STRING,
LOC_ROOT_KEY_REF TYPE STRING,
METHOD_REF TYPE STRING,
SAMPLE_COUNT TYPE STRING,
TECHNICIAN TYPE STRING,
PROCESSING_PHASE TYPE STRING,
PLANNED_DATE TYPE STRING,
EHSM_COMPONENT TYPE STRING,
SPLNG_ROOT_KEY TYPE STRING,
HIGHEST_BLANK_VALUE TYPE STRING,
HIGHEST_BLANK_UNIT TYPE STRING,
HIGHEST_BANK_OPERATOR TYPE STRING,
JOB_NAME TYPE STRING,
LOCATION_TEXT TYPE STRING,
LOC_AUTH_GROUP TYPE STRING,
PLANT_ID TYPE STRING,
COST_CENTER TYPE STRING,
COMPANY_CODE TYPE STRING,
BUSS_AREA TYPE STRING,
COUNTRY TYPE STRING,
REGION TYPE STRING,
METHOD_TEXT TYPE STRING,
EQUIPMENT_TEXT TYPE STRING,
MEDIA_TEXT TYPE STRING,
PPE_TITLE TYPE STRING,END OF T_EKKO_STR. DATA: WA_EHHSSV_SMPL4LOC_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_EHHSSV_SMPL4LOC_STR-MANDT sy-vline
WA_EHHSSV_SMPL4LOC_STR-SPLNG_SPL_KEY sy-vline
WA_EHHSSV_SMPL4LOC_STR-AMOUNT_ROOT_KEY sy-vline
WA_EHHSSV_SMPL4LOC_STR-SAMPLING_CAMPAIGN_KEY sy-vline
WA_EHHSSV_SMPL4LOC_STR-JOB_KEY_REF sy-vline
WA_EHHSSV_SMPL4LOC_STR-ABAGT_KEY_REF sy-vline
WA_EHHSSV_SMPL4LOC_STR-AGENT_KEY_REF sy-vline
WA_EHHSSV_SMPL4LOC_STR-CMA_KEY_REF sy-vline
WA_EHHSSV_SMPL4LOC_STR-SAMPLING_METHOD_REF sy-vline
WA_EHHSSV_SMPL4LOC_STR-REQUESTED_SAMPLE_COUNT sy-vline
WA_EHHSSV_SMPL4LOC_STR-OP_STATUS sy-vline
WA_EHHSSV_SMPL4LOC_STR-SUBJECT_NAME sy-vline
WA_EHHSSV_SMPL4LOC_STR-SUBJECT_LANGUAGE sy-vline
WA_EHHSSV_SMPL4LOC_STR-LISTEDSUBSTANCECNDNCODE sy-vline
WA_EHHSSV_SMPL4LOC_STR-SUBJECT_ROOT_KEY_REF sy-vline
WA_EHHSSV_SMPL4LOC_STR-SUBJECTTYPE sy-vline
WA_EHHSSV_SMPL4LOC_STR-VALUE sy-vline
WA_EHHSSV_SMPL4LOC_STR-VALUEUNIT sy-vline
WA_EHHSSV_SMPL4LOC_STR-VALUETYPE sy-vline
WA_EHHSSV_SMPL4LOC_STR-STATUS sy-vline
WA_EHHSSV_SMPL4LOC_STR-AMOUNTCATEGORY sy-vline
WA_EHHSSV_SMPL4LOC_STR-OUTOFPRECISENESS_OPERATOR sy-vline
WA_EHHSSV_SMPL4LOC_STR-BLANK_INDICATOR sy-vline
WA_EHHSSV_SMPL4LOC_STR-BLANK_TYPE sy-vline
WA_EHHSSV_SMPL4LOC_STR-START_TIMESTAMP sy-vline
WA_EHHSSV_SMPL4LOC_STR-START_DATE sy-vline
WA_EHHSSV_SMPL4LOC_STR-START_TIME sy-vline
WA_EHHSSV_SMPL4LOC_STR-SAMPLE_DATE_YEAR sy-vline
WA_EHHSSV_SMPL4LOC_STR-SAMPLE_DATE_MONTH sy-vline
WA_EHHSSV_SMPL4LOC_STR-SAMPLE_DATE_DAY sy-vline
WA_EHHSSV_SMPL4LOC_STR-END_TIMESTAMP sy-vline
WA_EHHSSV_SMPL4LOC_STR-END_DATE sy-vline
WA_EHHSSV_SMPL4LOC_STR-END_TIME sy-vline
WA_EHHSSV_SMPL4LOC_STR-EQUIPMENT_ID sy-vline
WA_EHHSSV_SMPL4LOC_STR-SAMPLE_ID sy-vline
WA_EHHSSV_SMPL4LOC_STR-MEDIA_ID sy-vline
WA_EHHSSV_SMPL4LOC_STR-EQUIPMENT_CALIBRATED_IND sy-vline
WA_EHHSSV_SMPL4LOC_STR-CALIB_REPORT_KEY_REF sy-vline
WA_EHHSSV_SMPL4LOC_STR-FIELD_SHEET_KEY_REF sy-vline
WA_EHHSSV_SMPL4LOC_STR-FLOW_RATE_START sy-vline
WA_EHHSSV_SMPL4LOC_STR-FLOW_RATE_END sy-vline
WA_EHHSSV_SMPL4LOC_STR-FLOW_RATE_UNIT sy-vline
WA_EHHSSV_SMPL4LOC_STR-PERSON_SAMPLED sy-vline
WA_EHHSSV_SMPL4LOC_STR-PPE_WORN sy-vline
WA_EHHSSV_SMPL4LOC_STR-SHIFT_PATTERN sy-vline
WA_EHHSSV_SMPL4LOC_STR-SUBSTANTIATION sy-vline
WA_EHHSSV_SMPL4LOC_STR-VALIDITY sy-vline
WA_EHHSSV_SMPL4LOC_STR-LOC_ROOT_KEY_REF sy-vline
WA_EHHSSV_SMPL4LOC_STR-METHOD_REF sy-vline
WA_EHHSSV_SMPL4LOC_STR-SAMPLE_COUNT sy-vline
WA_EHHSSV_SMPL4LOC_STR-TECHNICIAN sy-vline
WA_EHHSSV_SMPL4LOC_STR-PROCESSING_PHASE sy-vline
WA_EHHSSV_SMPL4LOC_STR-PLANNED_DATE sy-vline
WA_EHHSSV_SMPL4LOC_STR-EHSM_COMPONENT sy-vline
WA_EHHSSV_SMPL4LOC_STR-SPLNG_ROOT_KEY sy-vline
WA_EHHSSV_SMPL4LOC_STR-HIGHEST_BLANK_VALUE sy-vline
WA_EHHSSV_SMPL4LOC_STR-HIGHEST_BLANK_UNIT sy-vline
WA_EHHSSV_SMPL4LOC_STR-HIGHEST_BANK_OPERATOR sy-vline
WA_EHHSSV_SMPL4LOC_STR-JOB_NAME sy-vline
WA_EHHSSV_SMPL4LOC_STR-LOCATION_TEXT sy-vline
WA_EHHSSV_SMPL4LOC_STR-LOC_AUTH_GROUP sy-vline
WA_EHHSSV_SMPL4LOC_STR-PLANT_ID sy-vline
WA_EHHSSV_SMPL4LOC_STR-COST_CENTER sy-vline
WA_EHHSSV_SMPL4LOC_STR-COMPANY_CODE sy-vline
WA_EHHSSV_SMPL4LOC_STR-BUSS_AREA sy-vline
WA_EHHSSV_SMPL4LOC_STR-COUNTRY sy-vline
WA_EHHSSV_SMPL4LOC_STR-REGION sy-vline
WA_EHHSSV_SMPL4LOC_STR-METHOD_TEXT sy-vline
WA_EHHSSV_SMPL4LOC_STR-EQUIPMENT_TEXT sy-vline
WA_EHHSSV_SMPL4LOC_STR-MEDIA_TEXT sy-vline
WA_EHHSSV_SMPL4LOC_STR-PPE_TITLE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.