ABAP Select data from SAP table DPR_TS_APPROVAL_DAT 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 DPR_TS_APPROVAL_DAT 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 DPR_TS_APPROVAL_DAT. 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 DPR_TS_APPROVAL_DAT 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_DPR_TS_APPROVAL_DAT TYPE STANDARD TABLE OF DPR_TS_APPROVAL_DAT,
      WA_DPR_TS_APPROVAL_DAT TYPE DPR_TS_APPROVAL_DAT,
      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: <DPR_TS_APPROVAL_DAT> TYPE DPR_TS_APPROVAL_DAT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM DPR_TS_APPROVAL_DAT
*  INTO TABLE @DATA(IT_DPR_TS_APPROVAL_DAT2).
*--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_DPR_TS_APPROVAL_DAT INDEX 1 INTO DATA(WA_DPR_TS_APPROVAL_DAT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<DPR_TS_APPROVAL_DAT>-IS_TEMPLATE = 1.
<DPR_TS_APPROVAL_DAT>-DESCRIPTION = 1.
<DPR_TS_APPROVAL_DAT>-EXTENDED_ATTRIBUTES = 1.
<DPR_TS_APPROVAL_DAT>-EA_DUMMY = 1.
<DPR_TS_APPROVAL_DAT>-DOC_SIGN = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_DPR_TS_APPROVAL_DAT-DOC_TYPE_SIGN, sy-vline,
  WA_DPR_TS_APPROVAL_DAT-DOC_SIZE_SIGN, sy-vline,
  WA_DPR_TS_APPROVAL_DAT-FNGR_PRNT_SIGN, sy-vline,
  WA_DPR_TS_APPROVAL_DAT-GUID, sy-vline,
  WA_DPR_TS_APPROVAL_DAT-EXTERNAL_ID, sy-vline,
  WA_DPR_TS_APPROVAL_DAT-VERSION_NUMBER, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_DPR_TS_APPROVAL_DAT 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_DPR_TS_APPROVAL_DAT 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_DPR_TS_APPROVAL_DAT INTO WA_DPR_TS_APPROVAL_DAT.


*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 ISOLA, internal->external for field SPRAS
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-SPRAS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-SPRAS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CGPLP, internal->external for field PROJECT_GUIDINT
CALL FUNCTION 'CONVERSION_EXIT_CGPLP_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-PROJECT_GUIDINT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-PROJECT_GUIDINT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field ACTUALSTARTINT
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-ACTUALSTARTINT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-ACTUALSTARTINT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field ACTUALFINISHINT
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-ACTUALFINISHINT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-ACTUALFINISHINT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field PLANSTARTINT
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-PLANSTARTINT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-PLANSTARTINT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field PLANFINISHINT
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-PLANFINISHINT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-PLANFINISHINT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field CONSTRAINT_TIMEINT
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-CONSTRAINT_TIMEINT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-CONSTRAINT_TIMEINT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field LATEST_STARTINT
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-LATEST_STARTINT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-LATEST_STARTINT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field LATEST_FINISHINT
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-LATEST_FINISHINT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-LATEST_FINISHINT.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit TSTPS, internal->external for field CONSTR_TIME_FININT
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-CONSTR_TIME_FININT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-CONSTR_TIME_FININT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field FORECAST_STARTINT
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-FORECAST_STARTINT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-FORECAST_STARTINT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field FORECAST_FINISHINT
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-FORECAST_FINISHINT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-FORECAST_FINISHINT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field DECIDED_ONINT
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-DECIDED_ONINT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-DECIDED_ONINT.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit CGPLP, internal->external for field PROJECT_GUIDPEX
CALL FUNCTION 'CONVERSION_EXIT_CGPLP_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-PROJECT_GUIDPEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-PROJECT_GUIDPEX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field ACTUALSTARTPEX
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-ACTUALSTARTPEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-ACTUALSTARTPEX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field ACTUALFINISHPEX
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-ACTUALFINISHPEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-ACTUALFINISHPEX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field PLANSTARTPEX
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-PLANSTARTPEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-PLANSTARTPEX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field PLANFINISHPEX
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-PLANFINISHPEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-PLANFINISHPEX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field CONSTRAINT_TIMEPEX
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-CONSTRAINT_TIMEPEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-CONSTRAINT_TIMEPEX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field LATEST_STARTPEX
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-LATEST_STARTPEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-LATEST_STARTPEX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field LATEST_FINISHPEX
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-LATEST_FINISHPEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-LATEST_FINISHPEX.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit TSTPS, internal->external for field CONSTR_TIME_FINPEX
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-CONSTR_TIME_FINPEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-CONSTR_TIME_FINPEX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field FORECAST_STARTPEX
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-FORECAST_STARTPEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-FORECAST_STARTPEX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field FORECAST_FINISHPEX
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-FORECAST_FINISHPEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-FORECAST_FINISHPEX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field RELEASED_ONPEX
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_DPR_TS_APPROVAL_DAT-RELEASED_ONPEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_DPR_TS_APPROVAL_DAT-RELEASED_ONPEX.
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_DPR_TS_APPROVAL_DAT_STR, 
IS_TEMPLATE TYPE STRING,
DESCRIPTION TYPE STRING,
EXTENDED_ATTRIBUTES TYPE STRING,
EA_DUMMY TYPE STRING,
DOC_SIGN TYPE STRING,
DOC_TYPE_SIGN TYPE STRING,
DOC_SIZE_SIGN TYPE STRING,
FNGR_PRNT_SIGN TYPE STRING,
GUID TYPE STRING,
EXTERNAL_ID TYPE STRING,
VERSION_NUMBER TYPE STRING,
CREATED_BY TYPE STRING,
CREATED_BY_NAME TYPE STRING,
CREATED_ON TYPE STRING,
CHANGED_BY TYPE STRING,
CHANGED_BY_NAME TYPE STRING,
CHANGED_ON TYPE STRING,
VERSION TYPE STRING,
ACTIVE_VERSION TYPE STRING,
DECISION TYPE STRING,
DECISION_TEXT TYPE STRING,
DECIDED_BY TYPE STRING,
DECIDED_BY_NAME TYPE STRING,
DECIDED_ON_DATE TYPE STRING,
DECIDED_AT_TIME TYPE STRING,
SIGNATURE_TYPE TYPE STRING,
SIGNATURE_METHOD TYPE STRING,
DOCUMENT TYPE STRING,
DOCUMENT_TYPE TYPE STRING,
DOCUMENT_SIZE TYPE STRING,
FINGER_PRINT TYPE STRING,
OBJNR TYPE STRING,
ISTAT TYPE STRING,
ESTAT TYPE STRING,
STSMA TYPE STRING,
SPRAS TYPE STRING,
TXT04 TYPE STRING,
TXT30 TYPE STRING,
STATTXT TYPE STRING,
GUID_CHAR TYPE STRING,
GUIDINT TYPE STRING,
EXTERNAL_IDINT TYPE STRING,
PROJECT_GUIDINT TYPE STRING,
OBJECT_TYPEINT TYPE STRING,
PRIORITYINT TYPE STRING,
ACTUALSTARTINT TYPE STRING,
ACTUALFINISHINT TYPE STRING,
PLANSTARTINT TYPE STRING,
PLANFINISHINT TYPE STRING,
COMPLETIONINT TYPE STRING,
MILESTONEINT TYPE STRING,
CONSTRAINT_TYPEINT TYPE STRING,
CONSTRAINT_TIMEINT TYPE STRING,
CREATED_BYINT TYPE STRING,
CREATED_ONINT TYPE STRING,
CREATED_IN_BWINT TYPE STRING,
CHANGED_BYINT TYPE STRING,
CHANGED_ONINT TYPE STRING,
UPDATED_IN_BWINT TYPE STRING,
BWIDENTIFIERINT TYPE STRING,
PLANGROUPINT TYPE STRING,
LATEST_STARTINT TYPE STRING,
LATEST_FINISHINT TYPE STRING,
TOTAL_FLOATINT TYPE STRING,
DURATIONINT TYPE STRING,
DURATION_UNITINT TYPE STRING,
CALENDAR_IDINT TYPE STRING,
CONSTR_TYPE_FININT TYPE STRING,
CONSTR_TIME_FININT TYPE STRING,
APPLICATIONINT TYPE STRING,
FORECAST_STARTINT TYPE STRING,
FORECAST_FINISHINT TYPE STRING,
PROC_STATUS_OWNINT TYPE STRING,
PROC_STATUS_SUPINT TYPE STRING,
DOCUMENTINT TYPE STRING,
DOCUMENT_TYPEINT TYPE STRING,
DOCUMENT_SIZEINT TYPE STRING,
FINGER_PRINTINT TYPE STRING,
DOC_SIGNINT TYPE STRING,
DOC_TYPE_SIGNINT TYPE STRING,
DOC_SIZE_SIGNINT TYPE STRING,
FNGR_PRNT_SIGNINT TYPE STRING,
VERSION_NUMBERINT TYPE STRING,
DECISIONINT TYPE STRING,
DECIDED_BYINT TYPE STRING,
DECIDED_ONINT TYPE STRING,
ACTIVE_VERSIONINT TYPE STRING,
VERSIONINT TYPE STRING,
SIGNATURE_TYPEINT TYPE STRING,
SIGNATURE_METHODINT TYPE STRING,
EA_DUMMYINT TYPE STRING,
STATUS TYPE STRING,
TEXTS TYPE STRING,
INDIVIDUAL_APPROVALS TYPE STRING,
DOCUMENTS TYPE STRING,
PRIORITYPIN TYPE STRING,
DURATIONPIN TYPE STRING,
CALENDAR_IDPIN TYPE STRING,
PHASE_IDPIN TYPE STRING,
PHA_TYPEPIN TYPE STRING,
GROUPINGPIN TYPE STRING,
SEARCH_FIELDPIN TYPE STRING,
DESCRIPTIONPIN TYPE STRING,
CONSTRAINT_TYPEPIN TYPE STRING,
START_DATE_FIXPIN TYPE STRING,
CONSTR_TYPE_FINPIN TYPE STRING,
FINISH_DATE_FIXPIN TYPE STRING,
STAT_PROFILE_PHAPIN TYPE STRING,
PREDEC_PHASE_NUMBERPIN TYPE STRING,
FORECASTED_STARTPIN TYPE STRING,
FORECASTED_FINISHPIN TYPE STRING,
EXTENDED_ATTRIBUTESPIN TYPE STRING,
EA_DUMMYPIN TYPE STRING,
GUIDPIN TYPE STRING,
VERSION_NUMBERPIN TYPE STRING,
SCHEDULED_STARTPIN TYPE STRING,
SCHEDULED_FINISHPIN TYPE STRING,
CREATED_BYPIN TYPE STRING,
CREATED_BY_NAMEPIN TYPE STRING,
CREATED_ONPIN TYPE STRING,
CHANGED_BYPIN TYPE STRING,
CHANGED_BY_NAMEPIN TYPE STRING,
CHANGED_ONPIN TYPE STRING,
SCHEDULED_START_LATEPIN TYPE STRING,
SCHEDULED_FINISH_LATEPIN TYPE STRING,
TOTAL_FLOATPIN TYPE STRING,
DURATION_UNITPIN TYPE STRING,
RESCHEDULEPIN TYPE STRING,
GUID_CHARPIN TYPE STRING,
OBJNRPIN TYPE STRING,
ISTATPIN TYPE STRING,
ESTATPIN TYPE STRING,
STSMAPIN TYPE STRING,
SPRASPIN TYPE STRING,
TXT04PIN TYPE STRING,
TXT30PIN TYPE STRING,
STATTXTPIN TYPE STRING,
PHA_TYPE_TEXTPIN TYPE STRING,
RELEASE_DATEPIN TYPE STRING,
CALENDER_TEXTPIN TYPE STRING,
THRESHOLD_TEXTPIN TYPE STRING,
SEVERITY_TEXTPIN TYPE STRING,
DURATION_UNIT_TEXTPIN TYPE STRING,
GUIDPEX TYPE STRING,
EXTERNAL_IDPEX TYPE STRING,
PROJECT_GUIDPEX TYPE STRING,
OBJECT_TYPEPEX TYPE STRING,
PRIORITYPEX TYPE STRING,
ACTUALSTARTPEX TYPE STRING,
ACTUALFINISHPEX TYPE STRING,
PLANSTARTPEX TYPE STRING,
PLANFINISHPEX TYPE STRING,
COMPLETIONPEX TYPE STRING,
MILESTONEPEX TYPE STRING,
CONSTRAINT_TYPEPEX TYPE STRING,
CONSTRAINT_TIMEPEX TYPE STRING,
CREATED_BYPEX TYPE STRING,
CREATED_ONPEX TYPE STRING,
CREATED_IN_BWPEX TYPE STRING,
CHANGED_BYPEX TYPE STRING,
CHANGED_ONPEX TYPE STRING,
UPDATED_IN_BWPEX TYPE STRING,
BWIDENTIFIERPEX TYPE STRING,
PLANGROUPPEX TYPE STRING,
LATEST_STARTPEX TYPE STRING,
LATEST_FINISHPEX TYPE STRING,
TOTAL_FLOATPEX TYPE STRING,
DURATIONPEX TYPE STRING,
DURATION_UNITPEX TYPE STRING,
CALENDAR_IDPEX TYPE STRING,
CONSTR_TYPE_FINPEX TYPE STRING,
CONSTR_TIME_FINPEX TYPE STRING,
APPLICATIONPEX TYPE STRING,
FORECAST_STARTPEX TYPE STRING,
FORECAST_FINISHPEX TYPE STRING,
PROC_STATUS_OWNPEX TYPE STRING,
PROC_STATUS_SUPPEX TYPE STRING,
PHASE_IDPEX TYPE STRING,
VERSION_NUMBERPEX TYPE STRING,
PHA_TYPEPEX TYPE STRING,
GROUPINGPEX TYPE STRING,
SEARCH_FIELDPEX TYPE STRING,
RELEASED_ONPEX TYPE STRING,
RESCHEDULEPEX TYPE STRING,
STAT_PROFILE_PHAPEX TYPE STRING,
SCHEDULE_INDPEX TYPE STRING,
SCHED_BEHAVIOURPEX TYPE STRING,
EA_DUMMYPEX TYPE STRING,
APP_RELEVANT_CHECKLIST_ITEMS TYPE STRING,
APP_RELEVANT_TASKS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_DPR_TS_APPROVAL_DAT_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_DPR_TS_APPROVAL_DAT_STR-IS_TEMPLATE sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DESCRIPTION sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-EXTENDED_ATTRIBUTES sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-EA_DUMMY sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DOC_SIGN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DOC_TYPE_SIGN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DOC_SIZE_SIGN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-FNGR_PRNT_SIGN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-GUID sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-EXTERNAL_ID sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-VERSION_NUMBER sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CREATED_BY sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CREATED_BY_NAME sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CREATED_ON sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CHANGED_BY sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CHANGED_BY_NAME sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CHANGED_ON sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-VERSION sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-ACTIVE_VERSION sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DECISION sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DECISION_TEXT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DECIDED_BY sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DECIDED_BY_NAME sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DECIDED_ON_DATE sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DECIDED_AT_TIME sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SIGNATURE_TYPE sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SIGNATURE_METHOD sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DOCUMENT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DOCUMENT_TYPE sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DOCUMENT_SIZE sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-FINGER_PRINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-OBJNR sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-ISTAT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-ESTAT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-STSMA sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SPRAS sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-TXT04 sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-TXT30 sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-STATTXT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-GUID_CHAR sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-GUIDINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-EXTERNAL_IDINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PROJECT_GUIDINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-OBJECT_TYPEINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PRIORITYINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-ACTUALSTARTINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-ACTUALFINISHINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PLANSTARTINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PLANFINISHINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-COMPLETIONINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-MILESTONEINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CONSTRAINT_TYPEINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CONSTRAINT_TIMEINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CREATED_BYINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CREATED_ONINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CREATED_IN_BWINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CHANGED_BYINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CHANGED_ONINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-UPDATED_IN_BWINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-BWIDENTIFIERINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PLANGROUPINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-LATEST_STARTINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-LATEST_FINISHINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-TOTAL_FLOATINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DURATIONINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DURATION_UNITINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CALENDAR_IDINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CONSTR_TYPE_FININT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CONSTR_TIME_FININT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-APPLICATIONINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-FORECAST_STARTINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-FORECAST_FINISHINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PROC_STATUS_OWNINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PROC_STATUS_SUPINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DOCUMENTINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DOCUMENT_TYPEINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DOCUMENT_SIZEINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-FINGER_PRINTINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DOC_SIGNINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DOC_TYPE_SIGNINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DOC_SIZE_SIGNINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-FNGR_PRNT_SIGNINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-VERSION_NUMBERINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DECISIONINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DECIDED_BYINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DECIDED_ONINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-ACTIVE_VERSIONINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-VERSIONINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SIGNATURE_TYPEINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SIGNATURE_METHODINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-EA_DUMMYINT sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-STATUS sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-TEXTS sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-INDIVIDUAL_APPROVALS sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DOCUMENTS sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PRIORITYPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DURATIONPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CALENDAR_IDPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PHASE_IDPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PHA_TYPEPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-GROUPINGPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SEARCH_FIELDPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DESCRIPTIONPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CONSTRAINT_TYPEPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-START_DATE_FIXPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CONSTR_TYPE_FINPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-FINISH_DATE_FIXPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-STAT_PROFILE_PHAPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PREDEC_PHASE_NUMBERPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-FORECASTED_STARTPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-FORECASTED_FINISHPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-EXTENDED_ATTRIBUTESPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-EA_DUMMYPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-GUIDPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-VERSION_NUMBERPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SCHEDULED_STARTPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SCHEDULED_FINISHPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CREATED_BYPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CREATED_BY_NAMEPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CREATED_ONPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CHANGED_BYPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CHANGED_BY_NAMEPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CHANGED_ONPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SCHEDULED_START_LATEPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SCHEDULED_FINISH_LATEPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-TOTAL_FLOATPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DURATION_UNITPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-RESCHEDULEPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-GUID_CHARPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-OBJNRPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-ISTATPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-ESTATPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-STSMAPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SPRASPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-TXT04PIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-TXT30PIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-STATTXTPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PHA_TYPE_TEXTPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-RELEASE_DATEPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CALENDER_TEXTPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-THRESHOLD_TEXTPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SEVERITY_TEXTPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DURATION_UNIT_TEXTPIN sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-GUIDPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-EXTERNAL_IDPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PROJECT_GUIDPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-OBJECT_TYPEPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PRIORITYPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-ACTUALSTARTPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-ACTUALFINISHPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PLANSTARTPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PLANFINISHPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-COMPLETIONPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-MILESTONEPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CONSTRAINT_TYPEPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CONSTRAINT_TIMEPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CREATED_BYPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CREATED_ONPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CREATED_IN_BWPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CHANGED_BYPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CHANGED_ONPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-UPDATED_IN_BWPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-BWIDENTIFIERPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PLANGROUPPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-LATEST_STARTPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-LATEST_FINISHPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-TOTAL_FLOATPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DURATIONPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-DURATION_UNITPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CALENDAR_IDPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CONSTR_TYPE_FINPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-CONSTR_TIME_FINPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-APPLICATIONPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-FORECAST_STARTPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-FORECAST_FINISHPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PROC_STATUS_OWNPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PROC_STATUS_SUPPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PHASE_IDPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-VERSION_NUMBERPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-PHA_TYPEPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-GROUPINGPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SEARCH_FIELDPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-RELEASED_ONPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-RESCHEDULEPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-STAT_PROFILE_PHAPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SCHEDULE_INDPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-SCHED_BEHAVIOURPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-EA_DUMMYPEX sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-APP_RELEVANT_CHECKLIST_ITEMS sy-vline 
WA_DPR_TS_APPROVAL_DAT_STR-APP_RELEVANT_TASKS sy-vline      INTO ld_text SEPARATED BY SPACE.

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