ABAP Select data from SAP table CCSS 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 CCSS 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 CCSS. 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 CCSS 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_CCSS TYPE STANDARD TABLE OF CCSS, WA_CCSS TYPE CCSS, 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: <CCSS> TYPE CCSS. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_CCSS. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM CCSS INTO TABLE IT_CCSS. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM CCSS * INTO TABLE @DATA(IT_CCSS2). *--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_CCSS INDEX 1 INTO DATA(WA_CCSS2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_CCSS ASSIGNING <CCSS>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<CCSS>-MANDT = 1.
<CCSS>-LEDNR = 1.
<CCSS>-OBJNR = 1.
<CCSS>-GJAHR = 1.
<CCSS>-WRTTP = 1.
ENDLOOP. LOOP AT IT_CCSS INTO WA_CCSS. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_CCSS-VERSN, sy-vline,
WA_CCSS-KSTAR, sy-vline,
WA_CCSS-HRKFT, sy-vline,
WA_CCSS-VRGNG, sy-vline,
WA_CCSS-LSTAR, sy-vline,
WA_CCSS-STAGR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_CCSS 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_CCSS 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_CCSS INTO WA_CCSS. *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 LEDNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-LEDNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-LEDNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit OBJNR, internal->external for field OBJNR CALL FUNCTION 'CONVERSION_EXIT_OBJNR_OUTPUT' EXPORTING input = WA_CCSS-OBJNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-OBJNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit GJAHR, internal->external for field GJAHR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_CCSS-GJAHR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-GJAHR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field WRTTP CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-WRTTP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-WRTTP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field VERSN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-VERSN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-VERSN.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field KSTAR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-KSTAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-KSTAR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field VBUND CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-VBUND IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-VBUND.
WRITE:/ 'New Value:', ld_input.
*Conversion exit BEKNZ, internal->external for field BEKNZ CALL FUNCTION 'CONVERSION_EXIT_BEKNZ_OUTPUT' EXPORTING input = WA_CCSS-BEKNZ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-BEKNZ.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field KOSTL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-KOSTL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-KOSTL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field AUFNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-AUFNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-AUFNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ABPSN, internal->external for field PSPID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_CCSS-PSPID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-PSPID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ABPSN, internal->external for field POSID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_CCSS-POSID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-POSID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SKOST CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-SKOST IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SKOST.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MEINH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_CCSS-MEINH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-MEINH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field AUSEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_CCSS-AUSEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-AUSEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field VKSTA CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-VKSTA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-VKSTA.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field BELNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-BELNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-BELNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field VNAME CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-VNAME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-VNAME.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field RECID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-RECID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-RECID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field ETYPE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-ETYPE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-ETYPE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PRCTR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-PRCTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-PRCTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MEINB CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_CCSS-MEINB IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-MEINB.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ABPSP, internal->external for field ZPSPNR CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_CCSS-ZPSPNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-ZPSPNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field S_VNAME CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-S_VNAME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-S_VNAME.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field S_RECID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-S_RECID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-S_RECID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field S_ETYPE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-S_ETYPE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-S_ETYPE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field S_PRCTR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-S_PRCTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-S_PRCTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AOTYP, internal->external for field AOTYP CALL FUNCTION 'CONVERSION_EXIT_AOTYP_OUTPUT' EXPORTING input = WA_CCSS-AOTYP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-AOTYP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ABPSP, internal->external for field PSPNR CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_CCSS-PSPNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-PSPNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field UKOST CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-UKOST IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-UKOST.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field KATYP CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-KATYP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-KATYP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PRZNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-PRZNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-PRZNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ABKAT, internal->external for field ABKAT CALL FUNCTION 'CONVERSION_EXIT_ABKAT_OUTPUT' EXPORTING input = WA_CCSS-ABKAT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-ABKAT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field DRVTP CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-DRVTP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-DRVTP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field CBAT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-CBAT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-CBAT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit SCOPE, internal->external for field SCOPE CALL FUNCTION 'CONVERSION_EXIT_SCOPE_OUTPUT' EXPORTING input = WA_CCSS-SCOPE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SCOPE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field LEINH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_CCSS-LEINH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-LEINH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field TARKZ CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-TARKZ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-TARKZ.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field TARKZ_I CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-TARKZ_I IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-TARKZ_I.
WRITE:/ 'New Value:', ld_input.
*Conversion exit SWENR, internal->external for field SWENR CALL FUNCTION 'CONVERSION_EXIT_SWENR_OUTPUT' EXPORTING input = WA_CCSS-SWENR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SWENR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit SGENR, internal->external for field SGENR CALL FUNCTION 'CONVERSION_EXIT_SGENR_OUTPUT' EXPORTING input = WA_CCSS-SGENR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SGENR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit SGRNR, internal->external for field SGRNR CALL FUNCTION 'CONVERSION_EXIT_SGRNR_OUTPUT' EXPORTING input = WA_CCSS-SGRNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SGRNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit SMENR, internal->external for field SMENR CALL FUNCTION 'CONVERSION_EXIT_SMENR_OUTPUT' EXPORTING input = WA_CCSS-SMENR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SMENR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SMIVE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-SMIVE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SMIVE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SNKSL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-SNKSL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SNKSL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SEMPSL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-SEMPSL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SEMPSL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SVWNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-SVWNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SVWNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit OBART, internal->external for field KONTY CALL FUNCTION 'CONVERSION_EXIT_OBART_OUTPUT' EXPORTING input = WA_CCSS-KONTY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-KONTY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field RECNNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-RECNNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-RECNNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit NUMCV, internal->external for field VORNR CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_CCSS-VORNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-VORNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field AUFNR_NW CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-AUFNR_NW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-AUFNR_NW.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field LOGSYSTEM CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-LOGSYSTEM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-LOGSYSTEM.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field VPDIO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-VPDIO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-VPDIO.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SEPRZ CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-SEPRZ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SEPRZ.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field AUFKOSTL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-AUFKOSTL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-AUFKOSTL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field RECIND CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-RECIND IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-RECIND.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field S_RECIND CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-S_RECIND IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-S_RECIND.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field RECIDOBJ CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-RECIDOBJ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-RECIDOBJ.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field REINH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_CCSS-REINH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-REINH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field RKSTA CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-RKSTA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-RKSTA.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field RESRC CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-RESRC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-RESRC.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field MATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_CCSS-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-MATNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field EXTNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-EXTNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-EXTNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PSPKOSTL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-PSPKOSTL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-PSPKOSTL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field GRANT_NBR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-GRANT_NBR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-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_CCSS-PGRANT_NBR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-PGRANT_NBR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SGRANT_NBR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-SGRANT_NBR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SGRANT_NBR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SEGMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-SEGMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SEGMENT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PSEGMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-PSEGMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-PSEGMENT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SSEGMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CCSS-SSEGMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CCSS-SSEGMENT.
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_CCSS_STR,
MANDT 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,
LSTAR TYPE STRING,
STAGR TYPE STRING,
VBUND TYPE STRING,
PARGB TYPE STRING,
PAROB TYPE STRING,
USPOB TYPE STRING,
BEKNZ TYPE STRING,
TWAER TYPE STRING,
BUPER TYPE STRING,
KOKRS TYPE STRING,
KOSTL TYPE STRING,
AUFNR TYPE STRING,
PSPID TYPE STRING,
POSID TYPE STRING,
SKOST TYPE STRING,
SLSTA TYPE STRING,
SWAER TYPE STRING,
OWAER TYPE STRING,
KWAER 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,
MEINH TYPE STRING,
AUSEH TYPE STRING,
OMGEFL TYPE STRING,
MGEFL TYPE STRING,
KOSAR TYPE STRING,
EIGEN TYPE STRING,
VKSTA TYPE STRING,
AUSFK TYPE STRING,
LATYP TYPE STRING,
KSTTY TYPE STRING,
BUKRS TYPE STRING,
GSBER TYPE STRING,
KTOPL TYPE STRING,
LMONA TYPE STRING,
INUMKR TYPE STRING,
KOSZSCHL TYPE STRING,
KAPPL TYPE STRING,
KALSM TYPE STRING,
PLGKZ TYPE STRING,
BELNR TYPE STRING,
BUZEI TYPE STRING,
SETKIND TYPE STRING,
STAKZ TYPE STRING,
TXJCD TYPE STRING,
VNAME TYPE STRING,
RECID TYPE STRING,
ETYPE TYPE STRING,
PRCTR TYPE STRING,
AUTYP TYPE STRING,
KURST TYPE STRING,
PLDAT TYPE STRING,
MEINB TYPE STRING,
GRTYP TYPE STRING,
COPAR TYPE STRING,
ZPSPNR TYPE STRING,
S_BUKRS TYPE STRING,
S_GSBER TYPE STRING,
S_VNAME TYPE STRING,
S_RECID TYPE STRING,
S_ETYPE TYPE STRING,
S_PRCTR TYPE STRING,
AOTYP TYPE STRING,
KSTRG TYPE STRING,
PSPNR TYPE STRING,
UKOST TYPE STRING,
ULSTA TYPE STRING,
BUEKZ TYPE STRING,
KATYP TYPE STRING,
PRZNR TYPE STRING,
FGNAM TYPE STRING,
ABKAT TYPE STRING,
ATTRI TYPE STRING,
ATTRI_S TYPE STRING,
KOSTS TYPE STRING,
AUFTR TYPE STRING,
PRJKT TYPE STRING,
MATST TYPE STRING,
COABC TYPE STRING,
ALLEW TYPE STRING,
HKGRP TYPE STRING,
CBRKE TYPE STRING,
CBRKI TYPE STRING,
CBART TYPE STRING,
DRVTP TYPE STRING,
CBAT TYPE STRING,
PLINT TYPE STRING,
SCOPE TYPE STRING,
LEINH TYPE STRING,
EPSKZ TYPE STRING,
PLICC TYPE STRING,
RWINKZ TYPE STRING,
FIXVO TYPE STRING,
TARKZ TYPE STRING,
YRATE TYPE STRING,
TARKZ_I TYPE STRING,
SWENR TYPE STRING,
SGENR TYPE STRING,
SGRNR TYPE STRING,
SMENR TYPE STRING,
SMIVE TYPE STRING,
SNUNR TYPE STRING,
SMVART TYPE STRING,
SNKSL TYPE STRING,
SEMPSL TYPE STRING,
DABRZ TYPE STRING,
SVWNR TYPE STRING,
KONTY TYPE STRING,
RECNNR TYPE STRING,
VORNR TYPE STRING,
AUFNR_NW TYPE STRING,
LOGSYSTEM TYPE STRING,
LATYPI TYPE STRING,
RATMP TYPE STRING,
ELEHK TYPE STRING,
PKZKP TYPE STRING,
PKZKS TYPE STRING,
PKZER TYPE STRING,
TRGKZ TYPE STRING,
VSPKZ TYPE STRING,
VPDIO TYPE STRING,
CAUCE TYPE STRING,
CAUCC TYPE STRING,
AUART TYPE STRING,
ASTNR TYPE STRING,
SEPRZ TYPE STRING,
MANIST TYPE STRING,
AUFKOSTL TYPE STRING,
MRULE TYPE STRING,
RECIND TYPE STRING,
S_RECIND TYPE STRING,
RECIDOBJ TYPE STRING,
FAKKZ TYPE STRING,
REINH TYPE STRING,
RKSTA TYPE STRING,
RESRC TYPE STRING,
WERKS TYPE STRING,
MATNR TYPE STRING,
EXTNR TYPE STRING,
BEMOT TYPE STRING,
PSPKOSTL TYPE STRING,
OBJNR_IW TYPE STRING,
OBJNR_IG TYPE STRING,
OBJNR_IB TYPE STRING,
OBJNR_IM TYPE STRING,
OBJNR_IV TYPE STRING,
OBJNR_IC TYPE STRING,
OBJNR_IA TYPE STRING,
OBJNR_IS TYPE STRING,
OBJNR_IO TYPE STRING,
MANPLAN TYPE STRING,
FIKRS TYPE STRING,
FKBER TYPE STRING,
PFKBER TYPE STRING,
GEBER TYPE STRING,
PGEBER TYPE STRING,
GRANT_NBR TYPE STRING,
PGRANT_NBR TYPE STRING,
SGEBER TYPE STRING,
SFKBER TYPE STRING,
SGRANT_NBR TYPE STRING,
SBUDGET_PD TYPE STRING,
SEGMENT TYPE STRING,
PSEGMENT TYPE STRING,
SSEGMENT TYPE STRING,
BUDGET_PD TYPE STRING,
PBUDGET_PD TYPE STRING,
PRODPER TYPE STRING,END OF T_EKKO_STR. DATA: WA_CCSS_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_CCSS_STR-MANDT sy-vline
WA_CCSS_STR-LEDNR sy-vline
WA_CCSS_STR-OBJNR sy-vline
WA_CCSS_STR-GJAHR sy-vline
WA_CCSS_STR-WRTTP sy-vline
WA_CCSS_STR-VERSN sy-vline
WA_CCSS_STR-KSTAR sy-vline
WA_CCSS_STR-HRKFT sy-vline
WA_CCSS_STR-VRGNG sy-vline
WA_CCSS_STR-LSTAR sy-vline
WA_CCSS_STR-STAGR sy-vline
WA_CCSS_STR-VBUND sy-vline
WA_CCSS_STR-PARGB sy-vline
WA_CCSS_STR-PAROB sy-vline
WA_CCSS_STR-USPOB sy-vline
WA_CCSS_STR-BEKNZ sy-vline
WA_CCSS_STR-TWAER sy-vline
WA_CCSS_STR-BUPER sy-vline
WA_CCSS_STR-KOKRS sy-vline
WA_CCSS_STR-KOSTL sy-vline
WA_CCSS_STR-AUFNR sy-vline
WA_CCSS_STR-PSPID sy-vline
WA_CCSS_STR-POSID sy-vline
WA_CCSS_STR-SKOST sy-vline
WA_CCSS_STR-SLSTA sy-vline
WA_CCSS_STR-SWAER sy-vline
WA_CCSS_STR-OWAER sy-vline
WA_CCSS_STR-KWAER sy-vline
WA_CCSS_STR-AWAER sy-vline
WA_CCSS_STR-VWAER sy-vline
WA_CCSS_STR-BWAER sy-vline
WA_CCSS_STR-CWAER sy-vline
WA_CCSS_STR-DWAER sy-vline
WA_CCSS_STR-EWAER sy-vline
WA_CCSS_STR-FWAER sy-vline
WA_CCSS_STR-GWAER sy-vline
WA_CCSS_STR-MEINH sy-vline
WA_CCSS_STR-AUSEH sy-vline
WA_CCSS_STR-OMGEFL sy-vline
WA_CCSS_STR-MGEFL sy-vline
WA_CCSS_STR-KOSAR sy-vline
WA_CCSS_STR-EIGEN sy-vline
WA_CCSS_STR-VKSTA sy-vline
WA_CCSS_STR-AUSFK sy-vline
WA_CCSS_STR-LATYP sy-vline
WA_CCSS_STR-KSTTY sy-vline
WA_CCSS_STR-BUKRS sy-vline
WA_CCSS_STR-GSBER sy-vline
WA_CCSS_STR-KTOPL sy-vline
WA_CCSS_STR-LMONA sy-vline
WA_CCSS_STR-INUMKR sy-vline
WA_CCSS_STR-KOSZSCHL sy-vline
WA_CCSS_STR-KAPPL sy-vline
WA_CCSS_STR-KALSM sy-vline
WA_CCSS_STR-PLGKZ sy-vline
WA_CCSS_STR-BELNR sy-vline
WA_CCSS_STR-BUZEI sy-vline
WA_CCSS_STR-SETKIND sy-vline
WA_CCSS_STR-STAKZ sy-vline
WA_CCSS_STR-TXJCD sy-vline
WA_CCSS_STR-VNAME sy-vline
WA_CCSS_STR-RECID sy-vline
WA_CCSS_STR-ETYPE sy-vline
WA_CCSS_STR-PRCTR sy-vline
WA_CCSS_STR-AUTYP sy-vline
WA_CCSS_STR-KURST sy-vline
WA_CCSS_STR-PLDAT sy-vline
WA_CCSS_STR-MEINB sy-vline
WA_CCSS_STR-GRTYP sy-vline
WA_CCSS_STR-COPAR sy-vline
WA_CCSS_STR-ZPSPNR sy-vline
WA_CCSS_STR-S_BUKRS sy-vline
WA_CCSS_STR-S_GSBER sy-vline
WA_CCSS_STR-S_VNAME sy-vline
WA_CCSS_STR-S_RECID sy-vline
WA_CCSS_STR-S_ETYPE sy-vline
WA_CCSS_STR-S_PRCTR sy-vline
WA_CCSS_STR-AOTYP sy-vline
WA_CCSS_STR-KSTRG sy-vline
WA_CCSS_STR-PSPNR sy-vline
WA_CCSS_STR-UKOST sy-vline
WA_CCSS_STR-ULSTA sy-vline
WA_CCSS_STR-BUEKZ sy-vline
WA_CCSS_STR-KATYP sy-vline
WA_CCSS_STR-PRZNR sy-vline
WA_CCSS_STR-FGNAM sy-vline
WA_CCSS_STR-ABKAT sy-vline
WA_CCSS_STR-ATTRI sy-vline
WA_CCSS_STR-ATTRI_S sy-vline
WA_CCSS_STR-KOSTS sy-vline
WA_CCSS_STR-AUFTR sy-vline
WA_CCSS_STR-PRJKT sy-vline
WA_CCSS_STR-MATST sy-vline
WA_CCSS_STR-COABC sy-vline
WA_CCSS_STR-ALLEW sy-vline
WA_CCSS_STR-HKGRP sy-vline
WA_CCSS_STR-CBRKE sy-vline
WA_CCSS_STR-CBRKI sy-vline
WA_CCSS_STR-CBART sy-vline
WA_CCSS_STR-DRVTP sy-vline
WA_CCSS_STR-CBAT sy-vline
WA_CCSS_STR-PLINT sy-vline
WA_CCSS_STR-SCOPE sy-vline
WA_CCSS_STR-LEINH sy-vline
WA_CCSS_STR-EPSKZ sy-vline
WA_CCSS_STR-PLICC sy-vline
WA_CCSS_STR-RWINKZ sy-vline
WA_CCSS_STR-FIXVO sy-vline
WA_CCSS_STR-TARKZ sy-vline
WA_CCSS_STR-YRATE sy-vline
WA_CCSS_STR-TARKZ_I sy-vline
WA_CCSS_STR-SWENR sy-vline
WA_CCSS_STR-SGENR sy-vline
WA_CCSS_STR-SGRNR sy-vline
WA_CCSS_STR-SMENR sy-vline
WA_CCSS_STR-SMIVE sy-vline
WA_CCSS_STR-SNUNR sy-vline
WA_CCSS_STR-SMVART sy-vline
WA_CCSS_STR-SNKSL sy-vline
WA_CCSS_STR-SEMPSL sy-vline
WA_CCSS_STR-DABRZ sy-vline
WA_CCSS_STR-SVWNR sy-vline
WA_CCSS_STR-KONTY sy-vline
WA_CCSS_STR-RECNNR sy-vline
WA_CCSS_STR-VORNR sy-vline
WA_CCSS_STR-AUFNR_NW sy-vline
WA_CCSS_STR-LOGSYSTEM sy-vline
WA_CCSS_STR-LATYPI sy-vline
WA_CCSS_STR-RATMP sy-vline
WA_CCSS_STR-ELEHK sy-vline
WA_CCSS_STR-PKZKP sy-vline
WA_CCSS_STR-PKZKS sy-vline
WA_CCSS_STR-PKZER sy-vline
WA_CCSS_STR-TRGKZ sy-vline
WA_CCSS_STR-VSPKZ sy-vline
WA_CCSS_STR-VPDIO sy-vline
WA_CCSS_STR-CAUCE sy-vline
WA_CCSS_STR-CAUCC sy-vline
WA_CCSS_STR-AUART sy-vline
WA_CCSS_STR-ASTNR sy-vline
WA_CCSS_STR-SEPRZ sy-vline
WA_CCSS_STR-MANIST sy-vline
WA_CCSS_STR-AUFKOSTL sy-vline
WA_CCSS_STR-MRULE sy-vline
WA_CCSS_STR-RECIND sy-vline
WA_CCSS_STR-S_RECIND sy-vline
WA_CCSS_STR-RECIDOBJ sy-vline
WA_CCSS_STR-FAKKZ sy-vline
WA_CCSS_STR-REINH sy-vline
WA_CCSS_STR-RKSTA sy-vline
WA_CCSS_STR-RESRC sy-vline
WA_CCSS_STR-WERKS sy-vline
WA_CCSS_STR-MATNR sy-vline
WA_CCSS_STR-EXTNR sy-vline
WA_CCSS_STR-BEMOT sy-vline
WA_CCSS_STR-PSPKOSTL sy-vline
WA_CCSS_STR-OBJNR_IW sy-vline
WA_CCSS_STR-OBJNR_IG sy-vline
WA_CCSS_STR-OBJNR_IB sy-vline
WA_CCSS_STR-OBJNR_IM sy-vline
WA_CCSS_STR-OBJNR_IV sy-vline
WA_CCSS_STR-OBJNR_IC sy-vline
WA_CCSS_STR-OBJNR_IA sy-vline
WA_CCSS_STR-OBJNR_IS sy-vline
WA_CCSS_STR-OBJNR_IO sy-vline
WA_CCSS_STR-MANPLAN sy-vline
WA_CCSS_STR-FIKRS sy-vline
WA_CCSS_STR-FKBER sy-vline
WA_CCSS_STR-PFKBER sy-vline
WA_CCSS_STR-GEBER sy-vline
WA_CCSS_STR-PGEBER sy-vline
WA_CCSS_STR-GRANT_NBR sy-vline
WA_CCSS_STR-PGRANT_NBR sy-vline
WA_CCSS_STR-SGEBER sy-vline
WA_CCSS_STR-SFKBER sy-vline
WA_CCSS_STR-SGRANT_NBR sy-vline
WA_CCSS_STR-SBUDGET_PD sy-vline
WA_CCSS_STR-SEGMENT sy-vline
WA_CCSS_STR-PSEGMENT sy-vline
WA_CCSS_STR-SSEGMENT sy-vline
WA_CCSS_STR-BUDGET_PD sy-vline
WA_CCSS_STR-PBUDGET_PD sy-vline
WA_CCSS_STR-PRODPER sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.