ABAP Select data from SAP table ROIRC_CONDITION 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 ROIRC_CONDITION 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 ROIRC_CONDITION. 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 ROIRC_CONDITION 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_ROIRC_CONDITION TYPE STANDARD TABLE OF ROIRC_CONDITION,
      WA_ROIRC_CONDITION TYPE ROIRC_CONDITION,
      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: <ROIRC_CONDITION> TYPE ROIRC_CONDITION.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ROIRC_CONDITION
*  INTO TABLE @DATA(IT_ROIRC_CONDITION2).
*--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_ROIRC_CONDITION INDEX 1 INTO DATA(WA_ROIRC_CONDITION2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<ROIRC_CONDITION>-KVEWE = 1.
<ROIRC_CONDITION>-KVEWE_TEXT = 1.
<ROIRC_CONDITION>-KAPPL = 1.
<ROIRC_CONDITION>-KAPPL_TEXT = 1.
<ROIRC_CONDITION>-LIVAR = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ROIRC_CONDITION-LIVAR_TEXT, sy-vline,
  WA_ROIRC_CONDITION-KSCHL, sy-vline,
  WA_ROIRC_CONDITION-KSCHL_TEXT, sy-vline,
  WA_ROIRC_CONDITION-RF_LIVAR, sy-vline,
  WA_ROIRC_CONDITION-RF_LIVAR_TEXT, sy-vline,
  WA_ROIRC_CONDITION-RF_KSCHL, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_ROIRC_CONDITION 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_ROIRC_CONDITION 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_ROIRC_CONDITION INTO WA_ROIRC_CONDITION.


*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 KOTAB, internal->external for field KOTABNR
CALL FUNCTION 'CONVERSION_EXIT_KOTAB_OUTPUT'
  EXPORTING
    input =                      WA_ROIRC_CONDITION-KOTABNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ROIRC_CONDITION-KOTABNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit DTYPE, internal->external for field DATATYPE
CALL FUNCTION 'CONVERSION_EXIT_DTYPE_OUTPUT'
  EXPORTING
    input =                      WA_ROIRC_CONDITION-DATATYPE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ROIRC_CONDITION-DATATYPE.
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_ROIRC_CONDITION_STR, 
KVEWE TYPE STRING,
KVEWE_TEXT TYPE STRING,
KAPPL TYPE STRING,
KAPPL_TEXT TYPE STRING,
LIVAR TYPE STRING,
LIVAR_TEXT TYPE STRING,
KSCHL TYPE STRING,
KSCHL_TEXT TYPE STRING,
RF_LIVAR TYPE STRING,
RF_LIVAR_TEXT TYPE STRING,
RF_KSCHL TYPE STRING,
RF_KSCHL_TEXT TYPE STRING,
KZBZG TYPE STRING,
KZBZG_TEXT TYPE STRING,
KOZGF TYPE STRING,
KOZGF_TEXT TYPE STRING,
KOLNR TYPE STRING,
ZAEHK TYPE STRING,
KOTABNR TYPE STRING,
KOTAB_TEXT TYPE STRING,
KKMOD TYPE STRING,
COLNR TYPE STRING,
COLSZ TYPE STRING,
KSDAT TYPE STRING,
KSCKZ TYPE STRING,
ROWROUT TYPE STRING,
SCRROUT TYPE STRING,
HEADROUT TYPE STRING,
FOOTROUT TYPE STRING,
MARGINROUT TYPE STRING,
PRICECOMMSTR TYPE STRING,
PRICEPROPOSAL TYPE STRING,
PRICEPROPDOWN TYPE STRING,
CLUSTERPROP TYPE STRING,
CLUSTLIVAR TYPE STRING,
TARGET_LINE TYPE STRING,
DESCR TYPE STRING,
QUSTR TYPE STRING,
QUFNA TYPE STRING,
HEAD TYPE STRING,
LINE TYPE STRING,
COLU TYPE STRING,
FSETYP TYPE STRING,
FIELDNAME TYPE STRING,
ROLLNAME TYPE STRING,
DOMNAME TYPE STRING,
LENG TYPE STRING,
DATATYPE TYPE STRING,
DDTEXT TYPE STRING,
F_DESC TYPE STRING,
REPTEXT TYPE STRING,
SCRTEXT_S TYPE STRING,
SCRTEXT_M TYPE STRING,
SCRTEXT_L TYPE STRING,
NRCOL TYPE STRING,
H_DESC TYPE STRING,
H_TEXT TYPE STRING,
H_VALUE TYPE STRING,
F_VALUE TYPE STRING,
MARGINELEMENT1 TYPE STRING,
MARGINELEMENT2 TYPE STRING,
NAME01 TYPE STRING,
NAME02 TYPE STRING,
NAME03 TYPE STRING,
NAME04 TYPE STRING,
NAME05 TYPE STRING,
F_VALUE01 TYPE STRING,
F_VALUE02 TYPE STRING,
F_VALUE03 TYPE STRING,
F_VALUE04 TYPE STRING,
F_VALUE05 TYPE STRING,
PRLNR TYPE STRING,
MARGINTEXT1 TYPE STRING,
MARGINTEXT2 TYPE STRING,
PK_BADI TYPE STRING,
EM_BADI TYPE STRING,
HS_BADI TYPE STRING,
COMPLIST TYPE STRING,
SV_BADI TYPE STRING,
COPY_OW TYPE STRING,
DB_BADI TYPE STRING,
UPLSAVENEW TYPE STRING,END OF T_EKKO_STR.
DATA: WA_ROIRC_CONDITION_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_ROIRC_CONDITION_STR-KVEWE sy-vline 
WA_ROIRC_CONDITION_STR-KVEWE_TEXT sy-vline 
WA_ROIRC_CONDITION_STR-KAPPL sy-vline 
WA_ROIRC_CONDITION_STR-KAPPL_TEXT sy-vline 
WA_ROIRC_CONDITION_STR-LIVAR sy-vline 
WA_ROIRC_CONDITION_STR-LIVAR_TEXT sy-vline 
WA_ROIRC_CONDITION_STR-KSCHL sy-vline 
WA_ROIRC_CONDITION_STR-KSCHL_TEXT sy-vline 
WA_ROIRC_CONDITION_STR-RF_LIVAR sy-vline 
WA_ROIRC_CONDITION_STR-RF_LIVAR_TEXT sy-vline 
WA_ROIRC_CONDITION_STR-RF_KSCHL sy-vline 
WA_ROIRC_CONDITION_STR-RF_KSCHL_TEXT sy-vline 
WA_ROIRC_CONDITION_STR-KZBZG sy-vline 
WA_ROIRC_CONDITION_STR-KZBZG_TEXT sy-vline 
WA_ROIRC_CONDITION_STR-KOZGF sy-vline 
WA_ROIRC_CONDITION_STR-KOZGF_TEXT sy-vline 
WA_ROIRC_CONDITION_STR-KOLNR sy-vline 
WA_ROIRC_CONDITION_STR-ZAEHK sy-vline 
WA_ROIRC_CONDITION_STR-KOTABNR sy-vline 
WA_ROIRC_CONDITION_STR-KOTAB_TEXT sy-vline 
WA_ROIRC_CONDITION_STR-KKMOD sy-vline 
WA_ROIRC_CONDITION_STR-COLNR sy-vline 
WA_ROIRC_CONDITION_STR-COLSZ sy-vline 
WA_ROIRC_CONDITION_STR-KSDAT sy-vline 
WA_ROIRC_CONDITION_STR-KSCKZ sy-vline 
WA_ROIRC_CONDITION_STR-ROWROUT sy-vline 
WA_ROIRC_CONDITION_STR-SCRROUT sy-vline 
WA_ROIRC_CONDITION_STR-HEADROUT sy-vline 
WA_ROIRC_CONDITION_STR-FOOTROUT sy-vline 
WA_ROIRC_CONDITION_STR-MARGINROUT sy-vline 
WA_ROIRC_CONDITION_STR-PRICECOMMSTR sy-vline 
WA_ROIRC_CONDITION_STR-PRICEPROPOSAL sy-vline 
WA_ROIRC_CONDITION_STR-PRICEPROPDOWN sy-vline 
WA_ROIRC_CONDITION_STR-CLUSTERPROP sy-vline 
WA_ROIRC_CONDITION_STR-CLUSTLIVAR sy-vline 
WA_ROIRC_CONDITION_STR-TARGET_LINE sy-vline 
WA_ROIRC_CONDITION_STR-DESCR sy-vline 
WA_ROIRC_CONDITION_STR-QUSTR sy-vline 
WA_ROIRC_CONDITION_STR-QUFNA sy-vline 
WA_ROIRC_CONDITION_STR-HEAD sy-vline 
WA_ROIRC_CONDITION_STR-LINE sy-vline 
WA_ROIRC_CONDITION_STR-COLU sy-vline 
WA_ROIRC_CONDITION_STR-FSETYP sy-vline 
WA_ROIRC_CONDITION_STR-FIELDNAME sy-vline 
WA_ROIRC_CONDITION_STR-ROLLNAME sy-vline 
WA_ROIRC_CONDITION_STR-DOMNAME sy-vline 
WA_ROIRC_CONDITION_STR-LENG sy-vline 
WA_ROIRC_CONDITION_STR-DATATYPE sy-vline 
WA_ROIRC_CONDITION_STR-DDTEXT sy-vline 
WA_ROIRC_CONDITION_STR-F_DESC sy-vline 
WA_ROIRC_CONDITION_STR-REPTEXT sy-vline 
WA_ROIRC_CONDITION_STR-SCRTEXT_S sy-vline 
WA_ROIRC_CONDITION_STR-SCRTEXT_M sy-vline 
WA_ROIRC_CONDITION_STR-SCRTEXT_L sy-vline 
WA_ROIRC_CONDITION_STR-NRCOL sy-vline 
WA_ROIRC_CONDITION_STR-H_DESC sy-vline 
WA_ROIRC_CONDITION_STR-H_TEXT sy-vline 
WA_ROIRC_CONDITION_STR-H_VALUE sy-vline 
WA_ROIRC_CONDITION_STR-F_VALUE sy-vline 
WA_ROIRC_CONDITION_STR-MARGINELEMENT1 sy-vline 
WA_ROIRC_CONDITION_STR-MARGINELEMENT2 sy-vline 
WA_ROIRC_CONDITION_STR-NAME01 sy-vline 
WA_ROIRC_CONDITION_STR-NAME02 sy-vline 
WA_ROIRC_CONDITION_STR-NAME03 sy-vline 
WA_ROIRC_CONDITION_STR-NAME04 sy-vline 
WA_ROIRC_CONDITION_STR-NAME05 sy-vline 
WA_ROIRC_CONDITION_STR-F_VALUE01 sy-vline 
WA_ROIRC_CONDITION_STR-F_VALUE02 sy-vline 
WA_ROIRC_CONDITION_STR-F_VALUE03 sy-vline 
WA_ROIRC_CONDITION_STR-F_VALUE04 sy-vline 
WA_ROIRC_CONDITION_STR-F_VALUE05 sy-vline 
WA_ROIRC_CONDITION_STR-PRLNR sy-vline 
WA_ROIRC_CONDITION_STR-MARGINTEXT1 sy-vline 
WA_ROIRC_CONDITION_STR-MARGINTEXT2 sy-vline 
WA_ROIRC_CONDITION_STR-PK_BADI sy-vline 
WA_ROIRC_CONDITION_STR-EM_BADI sy-vline 
WA_ROIRC_CONDITION_STR-HS_BADI sy-vline 
WA_ROIRC_CONDITION_STR-COMPLIST sy-vline 
WA_ROIRC_CONDITION_STR-SV_BADI sy-vline 
WA_ROIRC_CONDITION_STR-COPY_OW sy-vline 
WA_ROIRC_CONDITION_STR-DB_BADI sy-vline 
WA_ROIRC_CONDITION_STR-UPLSAVENEW sy-vline      INTO ld_text SEPARATED BY SPACE.

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