ABAP Select data from SAP table CCRCS_VM_OUT_MFLE 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 CCRCS_VM_OUT_MFLE 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 CCRCS_VM_OUT_MFLE. 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 CCRCS_VM_OUT_MFLE 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_CCRCS_VM_OUT_MFLE TYPE STANDARD TABLE OF CCRCS_VM_OUT_MFLE,
      WA_CCRCS_VM_OUT_MFLE TYPE CCRCS_VM_OUT_MFLE,
      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: <CCRCS_VM_OUT_MFLE> TYPE CCRCS_VM_OUT_MFLE.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CCRCS_VM_OUT_MFLE
*  INTO TABLE @DATA(IT_CCRCS_VM_OUT_MFLE2).
*--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_CCRCS_VM_OUT_MFLE INDEX 1 INTO DATA(WA_CCRCS_VM_OUT_MFLE2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CCRCS_VM_OUT_MFLE>-ERROR = 1.
<CCRCS_VM_OUT_MFLE>-STATUS = 1.
<CCRCS_VM_OUT_MFLE>-SCEN = 1.
<CCRCS_VM_OUT_MFLE>-DOCTYPE = 1.
<CCRCS_VM_OUT_MFLE>-FLG_PLAN = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CCRCS_VM_OUT_MFLE-FLG_HIST, sy-vline,
  WA_CCRCS_VM_OUT_MFLE-FLG_POLYIND, sy-vline,
  WA_CCRCS_VM_OUT_MFLE-SUBSEC, sy-vline,
  WA_CCRCS_VM_OUT_MFLE-REG, sy-vline,
  WA_CCRCS_VM_OUT_MFLE-TYEAR, sy-vline,
  WA_CCRCS_VM_OUT_MFLE-PLANT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CCRCS_VM_OUT_MFLE 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_CCRCS_VM_OUT_MFLE 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_CCRCS_VM_OUT_MFLE INTO WA_CCRCS_VM_OUT_MFLE.


*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 MATN5, internal->external for field MATNR
CALL FUNCTION 'CONVERSION_EXIT_MATN5_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_VM_OUT_MFLE-MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_VM_OUT_MFLE-MATNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SPEC1, internal->external for field SUBID
CALL FUNCTION 'CONVERSION_EXIT_SPEC1_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_VM_OUT_MFLE-SUBID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_VM_OUT_MFLE-SUBID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SPEC1, internal->external for field TRACK_SUBST
CALL FUNCTION 'CONVERSION_EXIT_SPEC1_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_VM_OUT_MFLE-TRACK_SUBST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_VM_OUT_MFLE-TRACK_SUBST.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

*Conversion exit MATN1, internal->external for field MATNR_LONG
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_VM_OUT_MFLE-MATNR_LONG
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_VM_OUT_MFLE-MATNR_LONG.
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_CCRCS_VM_OUT_MFLE_STR, 
ERROR TYPE STRING,
STATUS TYPE STRING,
SCEN TYPE STRING,
DOCTYPE TYPE STRING,
FLG_PLAN TYPE STRING,
FLG_HIST TYPE STRING,
FLG_POLYIND TYPE STRING,
SUBSEC TYPE STRING,
REG TYPE STRING,
TYEAR TYPE STRING,
PLANT TYPE STRING,
MATNR TYPE STRING,
SUBID TYPE STRING,
TRACK_SUBST TYPE STRING,
CRDAT TYPE STRING,
PERIOD TYPE STRING,
OR_INT TYPE STRING,
OR_INT_DESCR TYPE STRING,
OR_EXT TYPE STRING,
OR_ADDR_CAT TYPE STRING,
OR_EXT_DESCR TYPE STRING,
OBJECT TYPE STRING,
ATTRIB TYPE STRING,
VALUE TYPE STRING,
AMOUNT TYPE STRING,
UOM TYPE STRING,
COMPAVG TYPE STRING,
COMPUOM TYPE STRING,
BUKRS TYPE STRING,
STATUSG TYPE STRING,
AMOUNT_F TYPE STRING,
AMOUNT_LIMIT TYPE STRING,
AMOUNT_LIMIT_L TYPE STRING,
UOM_LIMIT TYPE STRING,
SUM_OUT TYPE STRING,
LIMITB TYPE STRING,
LIMITB_L TYPE STRING,
CNTRY_O TYPE STRING,
CNTRY_R TYPE STRING,
REG_DATE TYPE STRING,
REG_FREQUENT TYPE STRING,
EINDT TYPE STRING,
VDATU TYPE STRING,
VBELN TYPE STRING,
VBELN_VL TYPE STRING,
POSNR_VA TYPE STRING,
EBANF TYPE STRING,
EBELN TYPE STRING,
EBELP TYPE STRING,
AUFNR TYPE STRING,
CO_POSNR TYPE STRING,
FLG_DISP TYPE STRING,
FLG_MAIL TYPE STRING,
FLG_BLOCK TYPE STRING,
ADD_INFO1 TYPE STRING,
ADD_INFO2 TYPE STRING,
ADD_INFO3 TYPE STRING,
ADD_INFO4 TYPE STRING,
ADD_INFO5 TYPE STRING,
ADD_INFO6 TYPE STRING,
ADD_INFO7 TYPE STRING,
ADD_INFO8 TYPE STRING,
ADD_INFO9 TYPE STRING,
ADD_INFO10 TYPE STRING,
ADD_INFO11 TYPE STRING,
ADD_INFO12 TYPE STRING,
ADD_INFO13 TYPE STRING,
ADD_INFO14 TYPE STRING,
ADD_INFO15 TYPE STRING,
ADD_INFO16 TYPE STRING,
ADD_INFO17 TYPE STRING,
ADD_INFO18 TYPE STRING,
ADD_INFO19 TYPE STRING,
ADD_INFO20 TYPE STRING,
ADD_INFO21 TYPE STRING,
ADD_INFO22 TYPE STRING,
ADD_INFO23 TYPE STRING,
ADD_INFO24 TYPE STRING,
ADD_INFO25 TYPE STRING,
STATUSA TYPE STRING,
AVG_PERIOD TYPE STRING,
SUM_AVG TYPE STRING,
UOM_AVG TYPE STRING,
REG_DATEE TYPE STRING,
REG_TYPE TYPE STRING,
REG_TYPE_DESC TYPE STRING,
RECN TYPE STRING,
MATNR_LONG TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CCRCS_VM_OUT_MFLE_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_CCRCS_VM_OUT_MFLE_STR-ERROR sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-STATUS sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-SCEN sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-DOCTYPE sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-FLG_PLAN sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-FLG_HIST sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-FLG_POLYIND sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-SUBSEC sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-REG sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-TYEAR sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-PLANT sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-MATNR sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-SUBID sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-TRACK_SUBST sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-CRDAT sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-PERIOD sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-OR_INT sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-OR_INT_DESCR sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-OR_EXT sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-OR_ADDR_CAT sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-OR_EXT_DESCR sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-OBJECT sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ATTRIB sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-VALUE sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-AMOUNT sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-UOM sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-COMPAVG sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-COMPUOM sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-BUKRS sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-STATUSG sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-AMOUNT_F sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-AMOUNT_LIMIT sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-AMOUNT_LIMIT_L sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-UOM_LIMIT sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-SUM_OUT sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-LIMITB sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-LIMITB_L sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-CNTRY_O sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-CNTRY_R sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-REG_DATE sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-REG_FREQUENT sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-EINDT sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-VDATU sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-VBELN sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-VBELN_VL sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-POSNR_VA sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-EBANF sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-EBELN sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-EBELP sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-AUFNR sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-CO_POSNR sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-FLG_DISP sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-FLG_MAIL sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-FLG_BLOCK sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO1 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO2 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO3 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO4 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO5 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO6 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO7 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO8 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO9 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO10 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO11 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO12 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO13 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO14 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO15 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO16 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO17 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO18 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO19 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO20 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO21 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO22 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO23 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO24 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-ADD_INFO25 sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-STATUSA sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-AVG_PERIOD sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-SUM_AVG sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-UOM_AVG sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-REG_DATEE sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-REG_TYPE sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-REG_TYPE_DESC sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-RECN sy-vline 
WA_CCRCS_VM_OUT_MFLE_STR-MATNR_LONG sy-vline      INTO ld_text SEPARATED BY SPACE.

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