ABAP Select data from SAP table FGLV_BCF_PRFYB20 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 FGLV_BCF_PRFYB20 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 FGLV_BCF_PRFYB20. 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 FGLV_BCF_PRFYB20 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_FGLV_BCF_PRFYB20 TYPE STANDARD TABLE OF FGLV_BCF_PRFYB20,
      WA_FGLV_BCF_PRFYB20 TYPE FGLV_BCF_PRFYB20,
      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: <FGLV_BCF_PRFYB20> TYPE FGLV_BCF_PRFYB20.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FGLV_BCF_PRFYB20
*  INTO TABLE @DATA(IT_FGLV_BCF_PRFYB202).
*--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_FGLV_BCF_PRFYB20 INDEX 1 INTO DATA(WA_FGLV_BCF_PRFYB202).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FGLV_BCF_PRFYB20 ASSIGNING <FGLV_BCF_PRFYB20>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<FGLV_BCF_PRFYB20>-MANDT = 1.
<FGLV_BCF_PRFYB20>-RYEAR = 1.
<FGLV_BCF_PRFYB20>-DRCRK = 1.
<FGLV_BCF_PRFYB20>-POPER = 1.
<FGLV_BCF_PRFYB20>-RMVCT = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FGLV_BCF_PRFYB20-XBILK, sy-vline,
WA_FGLV_BCF_PRFYB20-GLU1_ACCOUNT, sy-vline,
WA_FGLV_BCF_PRFYB20-SLALITTYPE, sy-vline,
WA_FGLV_BCF_PRFYB20-CBRUNID, sy-vline,
WA_FGLV_BCF_PRFYB20-WW0RE_PA, sy-vline,
WA_FGLV_BCF_PRFYB20-WW0SB_PA, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FGLV_BCF_PRFYB20 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_FGLV_BCF_PRFYB20 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_FGLV_BCF_PRFYB20 INTO WA_FGLV_BCF_PRFYB20. *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 GJAHR, internal->external for field RYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-RYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-RYEAR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

*Conversion exit MATN1, internal->external for field MATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-MATNR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ABPSP, internal->external for field MAT_PSPNR CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-MAT_PSPNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-MAT_PSPNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit MATN1, internal->external for field MATNR_COPA CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-MATNR_COPA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-MATNR_COPA.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ABPSN, internal->external for field PS_POSID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-PS_POSID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-PS_POSID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSP, internal->external for field PS_PSP_PNR CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-PS_PSP_PNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-PS_PSP_PNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSN, internal->external for field PPS_POSID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-PPS_POSID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-PPS_POSID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSN, internal->external for field PS_PSPID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-PS_PSPID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-PS_PSPID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit KONPD, internal->external for field PS_PRJ_PNR CALL FUNCTION 'CONVERSION_EXIT_KONPD_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-PS_PRJ_PNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-PS_PRJ_PNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit KONPD, internal->external for field PPS_PRJ_PNR CALL FUNCTION 'CONVERSION_EXIT_KONPD_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-PPS_PRJ_PNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-PPS_PRJ_PNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSP, internal->external for field PPS_PSP_PNR CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-PPS_PSP_PNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-PPS_PSP_PNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SWENR, internal->external for field SWENR CALL FUNCTION 'CONVERSION_EXIT_SWENR_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-SWENR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-SWENR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SGENR, internal->external for field SGENR CALL FUNCTION 'CONVERSION_EXIT_SGENR_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-SGENR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-SGENR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SGRNR, internal->external for field SGRNR CALL FUNCTION 'CONVERSION_EXIT_SGRNR_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-SGRNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-SGRNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ACRLOGSYS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FGLV_BCF_PRFYB20-ACRLOGSYS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FGLV_BCF_PRFYB20-ACRLOGSYS.
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_FGLV_BCF_PRFYB20_STR,
MANDT TYPE STRING,
RYEAR TYPE STRING,
DRCRK TYPE STRING,
POPER TYPE STRING,
RMVCT TYPE STRING,
XBILK TYPE STRING,
GLU1_ACCOUNT TYPE STRING,
SLALITTYPE TYPE STRING,
CBRUNID TYPE STRING,
WW0RE_PA TYPE STRING,
WW0SB_PA TYPE STRING,
AFABE TYPE STRING,
ANBWA TYPE STRING,
ANLGR TYPE STRING,
ANLGR2 TYPE STRING,
ANLN1 TYPE STRING,
ANLN2 TYPE STRING,
AWSYS TYPE STRING,
AWTYP TYPE STRING,
BLART TYPE STRING,
BTTYPE TYPE STRING,
BWKEY TYPE STRING,
BWTAR TYPE STRING,
CO_OSL TYPE STRING,
EPRCTR TYPE STRING,
BSL TYPE STRING,
CSL TYPE STRING,
DSL TYPE STRING,
ESL TYPE STRING,
FSL TYPE STRING,
GSL TYPE STRING,
HVKWRT TYPE STRING,
FCSL TYPE STRING,
GLACCOUNT_TYPE TYPE STRING,
HSL TYPE STRING,
KALNR TYPE STRING,
KOART TYPE STRING,
KOKRS TYPE STRING,
KSL TYPE STRING,
KTOP2 TYPE STRING,
KTOPL TYPE STRING,
KTOSL TYPE STRING,
KUNNR TYPE STRING,
KZBWS TYPE STRING,
LIFNR TYPE STRING,
LOKKT TYPE STRING,
MATNR TYPE STRING,
MAT_KDAUF TYPE STRING,
MAT_KDPOS TYPE STRING,
MAT_LIFNR TYPE STRING,
MAT_PSPNR TYPE STRING,
MOVCAT TYPE STRING,
MSL TYPE STRING,
OSL TYPE STRING,
PERIV TYPE STRING,
PFSL TYPE STRING,
PPRCTR TYPE STRING,
PRCTR TYPE STRING,
PSEGMENT TYPE STRING,
PSL TYPE STRING,
QUANT1 TYPE STRING,
QUANT2 TYPE STRING,
QUANT3 TYPE STRING,
QUNIT1 TYPE STRING,
QUNIT2 TYPE STRING,
QUNIT3 TYPE STRING,
RACCT TYPE STRING,
RASSC TYPE STRING,
RBUKRS TYPE STRING,
RBUSA TYPE STRING,
RCLNT TYPE STRING,
RCNTR TYPE STRING,
RCO_OCUR TYPE STRING,
RFAREA TYPE STRING,
RBCUR TYPE STRING,
RCCUR TYPE STRING,
RDCUR TYPE STRING,
RECUR TYPE STRING,
RFCUR TYPE STRING,
RGCUR TYPE STRING,
RFCCUR TYPE STRING,
RHCUR TYPE STRING,
RHOART TYPE STRING,
RKCUR TYPE STRING,
RLDNR TYPE STRING,
ROCUR TYPE STRING,
RRCTY TYPE STRING,
RTCUR TYPE STRING,
RUNIT TYPE STRING,
RVUNIT TYPE STRING,
RVCUR TYPE STRING,
RWCUR TYPE STRING,
SBUSA TYPE STRING,
SCNTR TYPE STRING,
SEGMENT TYPE STRING,
SFAREA TYPE STRING,
SOBKZ TYPE STRING,
TSL TYPE STRING,
VMSL TYPE STRING,
VORGN TYPE STRING,
VRGNG TYPE STRING,
VSL TYPE STRING,
WSL TYPE STRING,
XOBEW TYPE STRING,
BRSCH TYPE STRING,
BZIRK TYPE STRING,
KDGRP TYPE STRING,
KONZS TYPE STRING,
KUNRE TYPE STRING,
KUNWE TYPE STRING,
LAND1 TYPE STRING,
MATKL TYPE STRING,
MATNR_COPA TYPE STRING,
SPART TYPE STRING,
VKORG TYPE STRING,
VTWEG TYPE STRING,
RE_BUKRS TYPE STRING,
RE_ACCOUNT TYPE STRING,
FIKRS TYPE STRING,
FISTL TYPE STRING,
MEASURE TYPE STRING,
RFUND TYPE STRING,
RGRANT_NBR TYPE STRING,
RBUDGET_PD TYPE STRING,
SFUND TYPE STRING,
SGRANT_NBR TYPE STRING,
SBUDGET_PD TYPE STRING,
BDGT_ACCOUNT TYPE STRING,
BDGT_ACCOUNT_COCODE TYPE STRING,
VNAME TYPE STRING,
EGRUP TYPE STRING,
RECID TYPE STRING,
BTYPE TYPE STRING,
PRODPER TYPE STRING,
JVACTIVITY TYPE STRING,
PVNAME TYPE STRING,
PEGRUP TYPE STRING,
AUFNR TYPE STRING,
PS_POSID TYPE STRING,
PS_PSP_PNR TYPE STRING,
PPS_POSID TYPE STRING,
PS_PSPID TYPE STRING,
PS_PRJ_PNR TYPE STRING,
KDAUF TYPE STRING,
KDPOS TYPE STRING,
PKDAUF TYPE STRING,
PKDPOS TYPE STRING,
HBKID TYPE STRING,
HKTID TYPE STRING,
ANLKL TYPE STRING,
MWSKZ TYPE STRING,
WERKS TYPE STRING,
BUKRS_SENDER TYPE STRING,
RACCT_SENDER TYPE STRING,
VPTNR TYPE STRING,
PPS_PRJ_PNR TYPE STRING,
PPS_PSP_PNR TYPE STRING,
SWENR TYPE STRING,
SGENR TYPE STRING,
SGRNR TYPE STRING,
ACRLOGSYS TYPE STRING,
ACRITMTYPE TYPE STRING,
ACROBJTYPE TYPE STRING,
ACROBJ_ID TYPE STRING,
ACRSOBJ_ID TYPE STRING,
VALOBJTYPE TYPE STRING,
VALOBJ_ID TYPE STRING,
VALSOBJ_ID TYPE STRING,
RISK_CLASS TYPE STRING,END OF T_EKKO_STR. DATA: WA_FGLV_BCF_PRFYB20_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_FGLV_BCF_PRFYB20_STR-MANDT sy-vline
WA_FGLV_BCF_PRFYB20_STR-RYEAR sy-vline
WA_FGLV_BCF_PRFYB20_STR-DRCRK sy-vline
WA_FGLV_BCF_PRFYB20_STR-POPER sy-vline
WA_FGLV_BCF_PRFYB20_STR-RMVCT sy-vline
WA_FGLV_BCF_PRFYB20_STR-XBILK sy-vline
WA_FGLV_BCF_PRFYB20_STR-GLU1_ACCOUNT sy-vline
WA_FGLV_BCF_PRFYB20_STR-SLALITTYPE sy-vline
WA_FGLV_BCF_PRFYB20_STR-CBRUNID sy-vline
WA_FGLV_BCF_PRFYB20_STR-WW0RE_PA sy-vline
WA_FGLV_BCF_PRFYB20_STR-WW0SB_PA sy-vline
WA_FGLV_BCF_PRFYB20_STR-AFABE sy-vline
WA_FGLV_BCF_PRFYB20_STR-ANBWA sy-vline
WA_FGLV_BCF_PRFYB20_STR-ANLGR sy-vline
WA_FGLV_BCF_PRFYB20_STR-ANLGR2 sy-vline
WA_FGLV_BCF_PRFYB20_STR-ANLN1 sy-vline
WA_FGLV_BCF_PRFYB20_STR-ANLN2 sy-vline
WA_FGLV_BCF_PRFYB20_STR-AWSYS sy-vline
WA_FGLV_BCF_PRFYB20_STR-AWTYP sy-vline
WA_FGLV_BCF_PRFYB20_STR-BLART sy-vline
WA_FGLV_BCF_PRFYB20_STR-BTTYPE sy-vline
WA_FGLV_BCF_PRFYB20_STR-BWKEY sy-vline
WA_FGLV_BCF_PRFYB20_STR-BWTAR sy-vline
WA_FGLV_BCF_PRFYB20_STR-CO_OSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-EPRCTR sy-vline
WA_FGLV_BCF_PRFYB20_STR-BSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-CSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-DSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-ESL sy-vline
WA_FGLV_BCF_PRFYB20_STR-FSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-GSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-HVKWRT sy-vline
WA_FGLV_BCF_PRFYB20_STR-FCSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-GLACCOUNT_TYPE sy-vline
WA_FGLV_BCF_PRFYB20_STR-HSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-KALNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-KOART sy-vline
WA_FGLV_BCF_PRFYB20_STR-KOKRS sy-vline
WA_FGLV_BCF_PRFYB20_STR-KSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-KTOP2 sy-vline
WA_FGLV_BCF_PRFYB20_STR-KTOPL sy-vline
WA_FGLV_BCF_PRFYB20_STR-KTOSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-KUNNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-KZBWS sy-vline
WA_FGLV_BCF_PRFYB20_STR-LIFNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-LOKKT sy-vline
WA_FGLV_BCF_PRFYB20_STR-MATNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-MAT_KDAUF sy-vline
WA_FGLV_BCF_PRFYB20_STR-MAT_KDPOS sy-vline
WA_FGLV_BCF_PRFYB20_STR-MAT_LIFNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-MAT_PSPNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-MOVCAT sy-vline
WA_FGLV_BCF_PRFYB20_STR-MSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-OSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-PERIV sy-vline
WA_FGLV_BCF_PRFYB20_STR-PFSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-PPRCTR sy-vline
WA_FGLV_BCF_PRFYB20_STR-PRCTR sy-vline
WA_FGLV_BCF_PRFYB20_STR-PSEGMENT sy-vline
WA_FGLV_BCF_PRFYB20_STR-PSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-QUANT1 sy-vline
WA_FGLV_BCF_PRFYB20_STR-QUANT2 sy-vline
WA_FGLV_BCF_PRFYB20_STR-QUANT3 sy-vline
WA_FGLV_BCF_PRFYB20_STR-QUNIT1 sy-vline
WA_FGLV_BCF_PRFYB20_STR-QUNIT2 sy-vline
WA_FGLV_BCF_PRFYB20_STR-QUNIT3 sy-vline
WA_FGLV_BCF_PRFYB20_STR-RACCT sy-vline
WA_FGLV_BCF_PRFYB20_STR-RASSC sy-vline
WA_FGLV_BCF_PRFYB20_STR-RBUKRS sy-vline
WA_FGLV_BCF_PRFYB20_STR-RBUSA sy-vline
WA_FGLV_BCF_PRFYB20_STR-RCLNT sy-vline
WA_FGLV_BCF_PRFYB20_STR-RCNTR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RCO_OCUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RFAREA sy-vline
WA_FGLV_BCF_PRFYB20_STR-RBCUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RCCUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RDCUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RECUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RFCUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RGCUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RFCCUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RHCUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RHOART sy-vline
WA_FGLV_BCF_PRFYB20_STR-RKCUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RLDNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-ROCUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RRCTY sy-vline
WA_FGLV_BCF_PRFYB20_STR-RTCUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RUNIT sy-vline
WA_FGLV_BCF_PRFYB20_STR-RVUNIT sy-vline
WA_FGLV_BCF_PRFYB20_STR-RVCUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RWCUR sy-vline
WA_FGLV_BCF_PRFYB20_STR-SBUSA sy-vline
WA_FGLV_BCF_PRFYB20_STR-SCNTR sy-vline
WA_FGLV_BCF_PRFYB20_STR-SEGMENT sy-vline
WA_FGLV_BCF_PRFYB20_STR-SFAREA sy-vline
WA_FGLV_BCF_PRFYB20_STR-SOBKZ sy-vline
WA_FGLV_BCF_PRFYB20_STR-TSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-VMSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-VORGN sy-vline
WA_FGLV_BCF_PRFYB20_STR-VRGNG sy-vline
WA_FGLV_BCF_PRFYB20_STR-VSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-WSL sy-vline
WA_FGLV_BCF_PRFYB20_STR-XOBEW sy-vline
WA_FGLV_BCF_PRFYB20_STR-BRSCH sy-vline
WA_FGLV_BCF_PRFYB20_STR-BZIRK sy-vline
WA_FGLV_BCF_PRFYB20_STR-KDGRP sy-vline
WA_FGLV_BCF_PRFYB20_STR-KONZS sy-vline
WA_FGLV_BCF_PRFYB20_STR-KUNRE sy-vline
WA_FGLV_BCF_PRFYB20_STR-KUNWE sy-vline
WA_FGLV_BCF_PRFYB20_STR-LAND1 sy-vline
WA_FGLV_BCF_PRFYB20_STR-MATKL sy-vline
WA_FGLV_BCF_PRFYB20_STR-MATNR_COPA sy-vline
WA_FGLV_BCF_PRFYB20_STR-SPART sy-vline
WA_FGLV_BCF_PRFYB20_STR-VKORG sy-vline
WA_FGLV_BCF_PRFYB20_STR-VTWEG sy-vline
WA_FGLV_BCF_PRFYB20_STR-RE_BUKRS sy-vline
WA_FGLV_BCF_PRFYB20_STR-RE_ACCOUNT sy-vline
WA_FGLV_BCF_PRFYB20_STR-FIKRS sy-vline
WA_FGLV_BCF_PRFYB20_STR-FISTL sy-vline
WA_FGLV_BCF_PRFYB20_STR-MEASURE sy-vline
WA_FGLV_BCF_PRFYB20_STR-RFUND sy-vline
WA_FGLV_BCF_PRFYB20_STR-RGRANT_NBR sy-vline
WA_FGLV_BCF_PRFYB20_STR-RBUDGET_PD sy-vline
WA_FGLV_BCF_PRFYB20_STR-SFUND sy-vline
WA_FGLV_BCF_PRFYB20_STR-SGRANT_NBR sy-vline
WA_FGLV_BCF_PRFYB20_STR-SBUDGET_PD sy-vline
WA_FGLV_BCF_PRFYB20_STR-BDGT_ACCOUNT sy-vline
WA_FGLV_BCF_PRFYB20_STR-BDGT_ACCOUNT_COCODE sy-vline
WA_FGLV_BCF_PRFYB20_STR-VNAME sy-vline
WA_FGLV_BCF_PRFYB20_STR-EGRUP sy-vline
WA_FGLV_BCF_PRFYB20_STR-RECID sy-vline
WA_FGLV_BCF_PRFYB20_STR-BTYPE sy-vline
WA_FGLV_BCF_PRFYB20_STR-PRODPER sy-vline
WA_FGLV_BCF_PRFYB20_STR-JVACTIVITY sy-vline
WA_FGLV_BCF_PRFYB20_STR-PVNAME sy-vline
WA_FGLV_BCF_PRFYB20_STR-PEGRUP sy-vline
WA_FGLV_BCF_PRFYB20_STR-AUFNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-PS_POSID sy-vline
WA_FGLV_BCF_PRFYB20_STR-PS_PSP_PNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-PPS_POSID sy-vline
WA_FGLV_BCF_PRFYB20_STR-PS_PSPID sy-vline
WA_FGLV_BCF_PRFYB20_STR-PS_PRJ_PNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-KDAUF sy-vline
WA_FGLV_BCF_PRFYB20_STR-KDPOS sy-vline
WA_FGLV_BCF_PRFYB20_STR-PKDAUF sy-vline
WA_FGLV_BCF_PRFYB20_STR-PKDPOS sy-vline
WA_FGLV_BCF_PRFYB20_STR-HBKID sy-vline
WA_FGLV_BCF_PRFYB20_STR-HKTID sy-vline
WA_FGLV_BCF_PRFYB20_STR-ANLKL sy-vline
WA_FGLV_BCF_PRFYB20_STR-MWSKZ sy-vline
WA_FGLV_BCF_PRFYB20_STR-WERKS sy-vline
WA_FGLV_BCF_PRFYB20_STR-BUKRS_SENDER sy-vline
WA_FGLV_BCF_PRFYB20_STR-RACCT_SENDER sy-vline
WA_FGLV_BCF_PRFYB20_STR-VPTNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-PPS_PRJ_PNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-PPS_PSP_PNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-SWENR sy-vline
WA_FGLV_BCF_PRFYB20_STR-SGENR sy-vline
WA_FGLV_BCF_PRFYB20_STR-SGRNR sy-vline
WA_FGLV_BCF_PRFYB20_STR-ACRLOGSYS sy-vline
WA_FGLV_BCF_PRFYB20_STR-ACRITMTYPE sy-vline
WA_FGLV_BCF_PRFYB20_STR-ACROBJTYPE sy-vline
WA_FGLV_BCF_PRFYB20_STR-ACROBJ_ID sy-vline
WA_FGLV_BCF_PRFYB20_STR-ACRSOBJ_ID sy-vline
WA_FGLV_BCF_PRFYB20_STR-VALOBJTYPE sy-vline
WA_FGLV_BCF_PRFYB20_STR-VALOBJ_ID sy-vline
WA_FGLV_BCF_PRFYB20_STR-VALSOBJ_ID sy-vline
WA_FGLV_BCF_PRFYB20_STR-RISK_CLASS sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.