ABAP Select data from SAP table COEP_EXT 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 COEP_EXT 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 COEP_EXT. 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 COEP_EXT 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_COEP_EXT TYPE STANDARD TABLE OF COEP_EXT,
WA_COEP_EXT TYPE COEP_EXT,
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: <COEP_EXT> TYPE COEP_EXT.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_COEP_EXT.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM COEP_EXT
INTO TABLE IT_COEP_EXT.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM COEP_EXT
* INTO TABLE @DATA(IT_COEP_EXT2).
*--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_COEP_EXT INDEX 1 INTO DATA(WA_COEP_EXT2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_COEP_EXT ASSIGNING <COEP_EXT>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<COEP_EXT>-MANDT = 1.
<COEP_EXT>-KOKRS = 1.
<COEP_EXT>-BELNR = 1.
<COEP_EXT>-BUZEI = 1.
<COEP_EXT>-PERIO = 1.
ENDLOOP. LOOP AT IT_COEP_EXT INTO WA_COEP_EXT. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_COEP_EXT-WTGBTR, sy-vline,
WA_COEP_EXT-WOGBTR, sy-vline,
WA_COEP_EXT-WKGBTR, sy-vline,
WA_COEP_EXT-WKFBTR, sy-vline,
WA_COEP_EXT-PAGBTR, sy-vline,
WA_COEP_EXT-PAFBTR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_COEP_EXT 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_COEP_EXT 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_COEP_EXT INTO WA_COEP_EXT. *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 BELNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-BELNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-BELNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WTGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WTGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WTGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WOGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WOGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WOGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WKGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WKGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WKGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WKFBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WKFBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WKFBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field PAGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-PAGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PAGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field PAFBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-PAFBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PAFBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field LEDNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-LEDNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-LEDNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit GJAHR, internal->external for field GJAHR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_COEP_EXT-GJAHR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-GJAHR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field WRTTP CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-WRTTP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WRTTP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field VERSN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-VERSN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-VERSN.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field KSTAR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-KSTAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-KSTAR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field VBUND CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-VBUND IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-VBUND.
WRITE:/ 'New Value:', ld_input.
*Conversion exit BEKNZ, internal->external for field BEKNZ CALL FUNCTION 'CONVERSION_EXIT_BEKNZ_OUTPUT' EXPORTING input = WA_COEP_EXT-BEKNZ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-BEKNZ.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MEINH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_COEP_EXT-MEINH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-MEINH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MEINB CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_COEP_EXT-MEINB IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-MEINB.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field GKONT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-GKONT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-GKONT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field MATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_COEP_EXT-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-MATNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit REFBT, internal->external for field RBEST CALL FUNCTION 'CONVERSION_EXIT_REFBT_OUTPUT' EXPORTING input = WA_COEP_EXT-RBEST IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-RBEST.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field EBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-EBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-EBELN.
WRITE:/ 'New Value:', ld_input.
*Conversion exit SCOPE, internal->external for field SCOPE CALL FUNCTION 'CONVERSION_EXIT_SCOPE_OUTPUT' EXPORTING input = WA_COEP_EXT-SCOPE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-SCOPE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field LOGSYSO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-LOGSYSO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-LOGSYSO.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PKSTAR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-PKSTAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PKSTAR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit SCOPE, internal->external for field PSCOPE CALL FUNCTION 'CONVERSION_EXIT_SCOPE_OUTPUT' EXPORTING input = WA_COEP_EXT-PSCOPE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PSCOPE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field LOGSYSP CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-LOGSYSP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-LOGSYSP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field QMNUM CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-QMNUM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-QMNUM.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field GRANT_NBR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-GRANT_NBR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-GRANT_NBR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PGRANT_NBR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-PGRANT_NBR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PGRANT_NBR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SEGMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-SEGMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-SEGMENT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PSEGMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-PSEGMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PSEGMENT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PRCTR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-PRCTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PRCTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PPRCT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-PPRCT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PPRCT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field AWSYS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-AWSYS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-AWSYS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field KOSTL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-KOSTL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-KOSTL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field AUFNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-AUFNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-AUFNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ABPSN, internal->external for field PSPNR CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_COEP_EXT-PSPNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PSPNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ABPSN, internal->external for field PSPID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_COEP_EXT-PSPID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PSPID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field VBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-VBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-VBELN.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PKOSTL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-PKOSTL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PKOSTL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PAUFNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-PAUFNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PAUFNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ABPSN, internal->external for field PPSPNR CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_COEP_EXT-PPSPNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PPSPNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ABPSN, internal->external for field PPSPID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_COEP_EXT-PPSPID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PPSPID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PVBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-PVBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-PVBELN.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field QUNIT1 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_COEP_EXT-QUNIT1 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-QUNIT1.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field QUNIT2 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_COEP_EXT-QUNIT2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-QUNIT2.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field QUNIT3 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_COEP_EXT-QUNIT3 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-QUNIT3.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WAGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WAGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WAGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WVGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WVGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WVGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WBGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WBGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WBGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WCGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WCGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WCGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WDGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WDGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WDGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WEGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WEGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WEGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WFGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WFGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WFGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WGGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WGGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WGGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WHGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WHGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WHGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field WSGBTR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COEP_EXT-WSGBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-WSGBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit NUMCV, internal->external for field VORNR CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_COEP_EXT-VORNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-VORNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit NUMCV, internal->external for field UVORN CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_COEP_EXT-UVORN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-UVORN.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field EQUNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-EQUNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-EQUNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit TPLNR, internal->external for field TPLNR CALL FUNCTION 'CONVERSION_EXIT_TPLNR_OUTPUT' EXPORTING input = WA_COEP_EXT-TPLNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-TPLNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field ISTRU CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_COEP_EXT-ISTRU IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-ISTRU.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field MAUFNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-MAUFNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-MAUFNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field VNAME CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-VNAME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-VNAME.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field EGRUP CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-EGRUP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-EGRUP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field ETYPE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COEP_EXT-ETYPE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COEP_EXT-ETYPE.
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_COEP_EXT_STR,
MANDT TYPE STRING,
KOKRS TYPE STRING,
BELNR TYPE STRING,
BUZEI TYPE STRING,
PERIO TYPE STRING,
WTGBTR TYPE STRING,
WOGBTR TYPE STRING,
WKGBTR TYPE STRING,
WKFBTR TYPE STRING,
PAGBTR TYPE STRING,
PAFBTR TYPE STRING,
MEGBTR TYPE STRING,
MEFBTR TYPE STRING,
MBGBTR TYPE STRING,
MBFBTR TYPE STRING,
LEDNR TYPE STRING,
OBJNR TYPE STRING,
GJAHR TYPE STRING,
WRTTP TYPE STRING,
VERSN TYPE STRING,
KSTAR TYPE STRING,
HRKFT TYPE STRING,
VRGNG TYPE STRING,
PAROB TYPE STRING,
PAROB1 TYPE STRING,
USPOB TYPE STRING,
VBUND TYPE STRING,
PARGB TYPE STRING,
BEKNZ TYPE STRING,
TWAER TYPE STRING,
OWAER TYPE STRING,
MEINH TYPE STRING,
MEINB TYPE STRING,
MVFLG TYPE STRING,
SGTXT TYPE STRING,
REFBZ TYPE STRING,
ZLENR TYPE STRING,
BW_REFBZ TYPE STRING,
GKONT TYPE STRING,
GKOAR TYPE STRING,
WERKS TYPE STRING,
MATNR TYPE STRING,
RBEST TYPE STRING,
EBELN TYPE STRING,
EBELP TYPE STRING,
ZEKKN TYPE STRING,
ERLKZ TYPE STRING,
PERNR TYPE STRING,
BTRKL TYPE STRING,
OBJNR_N1 TYPE STRING,
OBJNR_N2 TYPE STRING,
OBJNR_N3 TYPE STRING,
PAOBJNR TYPE STRING,
BELTP TYPE STRING,
BUKRS TYPE STRING,
GSBER TYPE STRING,
FKBER TYPE STRING,
SCOPE TYPE STRING,
LOGSYSO TYPE STRING,
PKSTAR TYPE STRING,
PBUKRS TYPE STRING,
PFKBER TYPE STRING,
PSCOPE TYPE STRING,
LOGSYSP TYPE STRING,
DABRZ TYPE STRING,
BWSTRAT TYPE STRING,
OBJNR_HK TYPE STRING,
TIMESTMP TYPE STRING,
QMNUM TYPE STRING,
GEBER TYPE STRING,
PGEBER TYPE STRING,
GRANT_NBR TYPE STRING,
PGRANT_NBR TYPE STRING,
REFBZ_FI TYPE STRING,
SEGMENT TYPE STRING,
PSEGMENT TYPE STRING,
POSNR TYPE STRING,
PRCTR TYPE STRING,
PPRCT TYPE STRING,
BUDGET_PD TYPE STRING,
PBUDGET_PD TYPE STRING,
PRODPER TYPE STRING,
AWTYP TYPE STRING,
AWKEY TYPE STRING,
AWSYS TYPE STRING,
KWAER TYPE STRING,
ACCAS TYPE STRING,
ACCASTY TYPE STRING,
KOSTL TYPE STRING,
LSTAR TYPE STRING,
AUFNR TYPE STRING,
AUTYP TYPE STRING,
PSPNR TYPE STRING,
PSPID TYPE STRING,
VBELN TYPE STRING,
VBPOSNR TYPE STRING,
CE4KEY TYPE STRING,
ERKRS TYPE STRING,
PACCAS TYPE STRING,
PACCASTY TYPE STRING,
PKOSTL TYPE STRING,
PLSTAR TYPE STRING,
PAUFNR TYPE STRING,
PAUTYP TYPE STRING,
PPSPNR TYPE STRING,
PPSPID TYPE STRING,
PVBELN TYPE STRING,
PVBPOSNR TYPE STRING,
PCE4KEY TYPE STRING,
QUANT1 TYPE STRING,
QUANT2 TYPE STRING,
QUANT3 TYPE STRING,
QUNIT1 TYPE STRING,
QUNIT2 TYPE STRING,
QUNIT3 TYPE STRING,
AWAER TYPE STRING,
VWAER TYPE STRING,
BWAER TYPE STRING,
CWAER TYPE STRING,
DWAER TYPE STRING,
EWAER TYPE STRING,
FWAER TYPE STRING,
GWAER TYPE STRING,
HWAER TYPE STRING,
SWAER TYPE STRING,
WAGBTR TYPE STRING,
WVGBTR TYPE STRING,
WBGBTR TYPE STRING,
WCGBTR TYPE STRING,
WDGBTR TYPE STRING,
WEGBTR TYPE STRING,
WFGBTR TYPE STRING,
WGGBTR TYPE STRING,
WHGBTR TYPE STRING,
WSGBTR TYPE STRING,
ACURTP TYPE STRING,
VCURTP TYPE STRING,
BCURTP TYPE STRING,
CCURTP TYPE STRING,
DCURTP TYPE STRING,
ECURTP TYPE STRING,
FCURTP TYPE STRING,
GCURTP TYPE STRING,
HCURTP TYPE STRING,
SCURTP TYPE STRING,
WORK_ITEM_ID TYPE STRING,
FBUDA TYPE STRING,
OVERTIMECAT TYPE STRING,
BUKRS_SENDER TYPE STRING,
RACCT_SENDER TYPE STRING,
ACCAS_SENDER TYPE STRING,
ACCASTY_SENDER TYPE STRING,
ARBID TYPE STRING,
VORNR TYPE STRING,
AUFPS TYPE STRING,
UVORN TYPE STRING,
EQUNR TYPE STRING,
TPLNR TYPE STRING,
ISTRU TYPE STRING,
ILART TYPE STRING,
PLKNZ TYPE STRING,
ARTPR TYPE STRING,
PRIOK TYPE STRING,
MAUFNR TYPE STRING,
MATKL_MM TYPE STRING,
PAUFPS TYPE STRING,
DUMMY_INCL_EEW_COBL TYPE STRING,
VNAME TYPE STRING,
EGRUP TYPE STRING,
ETYPE TYPE STRING,END OF T_EKKO_STR. DATA: WA_COEP_EXT_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_COEP_EXT_STR-MANDT sy-vline
WA_COEP_EXT_STR-KOKRS sy-vline
WA_COEP_EXT_STR-BELNR sy-vline
WA_COEP_EXT_STR-BUZEI sy-vline
WA_COEP_EXT_STR-PERIO sy-vline
WA_COEP_EXT_STR-WTGBTR sy-vline
WA_COEP_EXT_STR-WOGBTR sy-vline
WA_COEP_EXT_STR-WKGBTR sy-vline
WA_COEP_EXT_STR-WKFBTR sy-vline
WA_COEP_EXT_STR-PAGBTR sy-vline
WA_COEP_EXT_STR-PAFBTR sy-vline
WA_COEP_EXT_STR-MEGBTR sy-vline
WA_COEP_EXT_STR-MEFBTR sy-vline
WA_COEP_EXT_STR-MBGBTR sy-vline
WA_COEP_EXT_STR-MBFBTR sy-vline
WA_COEP_EXT_STR-LEDNR sy-vline
WA_COEP_EXT_STR-OBJNR sy-vline
WA_COEP_EXT_STR-GJAHR sy-vline
WA_COEP_EXT_STR-WRTTP sy-vline
WA_COEP_EXT_STR-VERSN sy-vline
WA_COEP_EXT_STR-KSTAR sy-vline
WA_COEP_EXT_STR-HRKFT sy-vline
WA_COEP_EXT_STR-VRGNG sy-vline
WA_COEP_EXT_STR-PAROB sy-vline
WA_COEP_EXT_STR-PAROB1 sy-vline
WA_COEP_EXT_STR-USPOB sy-vline
WA_COEP_EXT_STR-VBUND sy-vline
WA_COEP_EXT_STR-PARGB sy-vline
WA_COEP_EXT_STR-BEKNZ sy-vline
WA_COEP_EXT_STR-TWAER sy-vline
WA_COEP_EXT_STR-OWAER sy-vline
WA_COEP_EXT_STR-MEINH sy-vline
WA_COEP_EXT_STR-MEINB sy-vline
WA_COEP_EXT_STR-MVFLG sy-vline
WA_COEP_EXT_STR-SGTXT sy-vline
WA_COEP_EXT_STR-REFBZ sy-vline
WA_COEP_EXT_STR-ZLENR sy-vline
WA_COEP_EXT_STR-BW_REFBZ sy-vline
WA_COEP_EXT_STR-GKONT sy-vline
WA_COEP_EXT_STR-GKOAR sy-vline
WA_COEP_EXT_STR-WERKS sy-vline
WA_COEP_EXT_STR-MATNR sy-vline
WA_COEP_EXT_STR-RBEST sy-vline
WA_COEP_EXT_STR-EBELN sy-vline
WA_COEP_EXT_STR-EBELP sy-vline
WA_COEP_EXT_STR-ZEKKN sy-vline
WA_COEP_EXT_STR-ERLKZ sy-vline
WA_COEP_EXT_STR-PERNR sy-vline
WA_COEP_EXT_STR-BTRKL sy-vline
WA_COEP_EXT_STR-OBJNR_N1 sy-vline
WA_COEP_EXT_STR-OBJNR_N2 sy-vline
WA_COEP_EXT_STR-OBJNR_N3 sy-vline
WA_COEP_EXT_STR-PAOBJNR sy-vline
WA_COEP_EXT_STR-BELTP sy-vline
WA_COEP_EXT_STR-BUKRS sy-vline
WA_COEP_EXT_STR-GSBER sy-vline
WA_COEP_EXT_STR-FKBER sy-vline
WA_COEP_EXT_STR-SCOPE sy-vline
WA_COEP_EXT_STR-LOGSYSO sy-vline
WA_COEP_EXT_STR-PKSTAR sy-vline
WA_COEP_EXT_STR-PBUKRS sy-vline
WA_COEP_EXT_STR-PFKBER sy-vline
WA_COEP_EXT_STR-PSCOPE sy-vline
WA_COEP_EXT_STR-LOGSYSP sy-vline
WA_COEP_EXT_STR-DABRZ sy-vline
WA_COEP_EXT_STR-BWSTRAT sy-vline
WA_COEP_EXT_STR-OBJNR_HK sy-vline
WA_COEP_EXT_STR-TIMESTMP sy-vline
WA_COEP_EXT_STR-QMNUM sy-vline
WA_COEP_EXT_STR-GEBER sy-vline
WA_COEP_EXT_STR-PGEBER sy-vline
WA_COEP_EXT_STR-GRANT_NBR sy-vline
WA_COEP_EXT_STR-PGRANT_NBR sy-vline
WA_COEP_EXT_STR-REFBZ_FI sy-vline
WA_COEP_EXT_STR-SEGMENT sy-vline
WA_COEP_EXT_STR-PSEGMENT sy-vline
WA_COEP_EXT_STR-POSNR sy-vline
WA_COEP_EXT_STR-PRCTR sy-vline
WA_COEP_EXT_STR-PPRCT sy-vline
WA_COEP_EXT_STR-BUDGET_PD sy-vline
WA_COEP_EXT_STR-PBUDGET_PD sy-vline
WA_COEP_EXT_STR-PRODPER sy-vline
WA_COEP_EXT_STR-AWTYP sy-vline
WA_COEP_EXT_STR-AWKEY sy-vline
WA_COEP_EXT_STR-AWSYS sy-vline
WA_COEP_EXT_STR-KWAER sy-vline
WA_COEP_EXT_STR-ACCAS sy-vline
WA_COEP_EXT_STR-ACCASTY sy-vline
WA_COEP_EXT_STR-KOSTL sy-vline
WA_COEP_EXT_STR-LSTAR sy-vline
WA_COEP_EXT_STR-AUFNR sy-vline
WA_COEP_EXT_STR-AUTYP sy-vline
WA_COEP_EXT_STR-PSPNR sy-vline
WA_COEP_EXT_STR-PSPID sy-vline
WA_COEP_EXT_STR-VBELN sy-vline
WA_COEP_EXT_STR-VBPOSNR sy-vline
WA_COEP_EXT_STR-CE4KEY sy-vline
WA_COEP_EXT_STR-ERKRS sy-vline
WA_COEP_EXT_STR-PACCAS sy-vline
WA_COEP_EXT_STR-PACCASTY sy-vline
WA_COEP_EXT_STR-PKOSTL sy-vline
WA_COEP_EXT_STR-PLSTAR sy-vline
WA_COEP_EXT_STR-PAUFNR sy-vline
WA_COEP_EXT_STR-PAUTYP sy-vline
WA_COEP_EXT_STR-PPSPNR sy-vline
WA_COEP_EXT_STR-PPSPID sy-vline
WA_COEP_EXT_STR-PVBELN sy-vline
WA_COEP_EXT_STR-PVBPOSNR sy-vline
WA_COEP_EXT_STR-PCE4KEY sy-vline
WA_COEP_EXT_STR-QUANT1 sy-vline
WA_COEP_EXT_STR-QUANT2 sy-vline
WA_COEP_EXT_STR-QUANT3 sy-vline
WA_COEP_EXT_STR-QUNIT1 sy-vline
WA_COEP_EXT_STR-QUNIT2 sy-vline
WA_COEP_EXT_STR-QUNIT3 sy-vline
WA_COEP_EXT_STR-AWAER sy-vline
WA_COEP_EXT_STR-VWAER sy-vline
WA_COEP_EXT_STR-BWAER sy-vline
WA_COEP_EXT_STR-CWAER sy-vline
WA_COEP_EXT_STR-DWAER sy-vline
WA_COEP_EXT_STR-EWAER sy-vline
WA_COEP_EXT_STR-FWAER sy-vline
WA_COEP_EXT_STR-GWAER sy-vline
WA_COEP_EXT_STR-HWAER sy-vline
WA_COEP_EXT_STR-SWAER sy-vline
WA_COEP_EXT_STR-WAGBTR sy-vline
WA_COEP_EXT_STR-WVGBTR sy-vline
WA_COEP_EXT_STR-WBGBTR sy-vline
WA_COEP_EXT_STR-WCGBTR sy-vline
WA_COEP_EXT_STR-WDGBTR sy-vline
WA_COEP_EXT_STR-WEGBTR sy-vline
WA_COEP_EXT_STR-WFGBTR sy-vline
WA_COEP_EXT_STR-WGGBTR sy-vline
WA_COEP_EXT_STR-WHGBTR sy-vline
WA_COEP_EXT_STR-WSGBTR sy-vline
WA_COEP_EXT_STR-ACURTP sy-vline
WA_COEP_EXT_STR-VCURTP sy-vline
WA_COEP_EXT_STR-BCURTP sy-vline
WA_COEP_EXT_STR-CCURTP sy-vline
WA_COEP_EXT_STR-DCURTP sy-vline
WA_COEP_EXT_STR-ECURTP sy-vline
WA_COEP_EXT_STR-FCURTP sy-vline
WA_COEP_EXT_STR-GCURTP sy-vline
WA_COEP_EXT_STR-HCURTP sy-vline
WA_COEP_EXT_STR-SCURTP sy-vline
WA_COEP_EXT_STR-WORK_ITEM_ID sy-vline
WA_COEP_EXT_STR-FBUDA sy-vline
WA_COEP_EXT_STR-OVERTIMECAT sy-vline
WA_COEP_EXT_STR-BUKRS_SENDER sy-vline
WA_COEP_EXT_STR-RACCT_SENDER sy-vline
WA_COEP_EXT_STR-ACCAS_SENDER sy-vline
WA_COEP_EXT_STR-ACCASTY_SENDER sy-vline
WA_COEP_EXT_STR-ARBID sy-vline
WA_COEP_EXT_STR-VORNR sy-vline
WA_COEP_EXT_STR-AUFPS sy-vline
WA_COEP_EXT_STR-UVORN sy-vline
WA_COEP_EXT_STR-EQUNR sy-vline
WA_COEP_EXT_STR-TPLNR sy-vline
WA_COEP_EXT_STR-ISTRU sy-vline
WA_COEP_EXT_STR-ILART sy-vline
WA_COEP_EXT_STR-PLKNZ sy-vline
WA_COEP_EXT_STR-ARTPR sy-vline
WA_COEP_EXT_STR-PRIOK sy-vline
WA_COEP_EXT_STR-MAUFNR sy-vline
WA_COEP_EXT_STR-MATKL_MM sy-vline
WA_COEP_EXT_STR-PAUFPS sy-vline
WA_COEP_EXT_STR-DUMMY_INCL_EEW_COBL sy-vline
WA_COEP_EXT_STR-VNAME sy-vline
WA_COEP_EXT_STR-EGRUP sy-vline
WA_COEP_EXT_STR-ETYPE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
