ABAP Select data from SAP table BICS_PROV_RFC_GET_INIT_STATE_E 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 BICS_PROV_RFC_GET_INIT_STATE_E 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 BICS_PROV_RFC_GET_INIT_STATE_E. 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 BICS_PROV_RFC_GET_INIT_STATE_E 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_BICS_PROV_RFC_GET_INIT_STATE_E TYPE STANDARD TABLE OF BICS_PROV_RFC_GET_INIT_STATE_E,
      WA_BICS_PROV_RFC_GET_INIT_STATE_E TYPE BICS_PROV_RFC_GET_INIT_STATE_E,
      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: <BICS_PROV_RFC_GET_INIT_STATE_E> TYPE BICS_PROV_RFC_GET_INIT_STATE_E.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM BICS_PROV_RFC_GET_INIT_STATE_E
*  INTO TABLE @DATA(IT_BICS_PROV_RFC_GET_INIT_STATE_E2).
*--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_BICS_PROV_RFC_GET_INIT_STATE_E INDEX 1 INTO DATA(WA_BICS_PROV_RFC_GET_INIT_STATE_E2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<BICS_PROV_RFC_GET_INIT_STATE_E>-E_MAX_MESSAGE_TYPE = 1.
<BICS_PROV_RFC_GET_INIT_STATE_E>-E_DEFAULT_VIEW_DEFINITION = 1.
<BICS_PROV_RFC_GET_INIT_STATE_E>-E_S_META_QUERY_PROPERTIES = 1.
<BICS_PROV_RFC_GET_INIT_STATE_E>-COMPUID = 1.
<BICS_PROV_RFC_GET_INIT_STATE_E>-OBJVERS = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_BICS_PROV_RFC_GET_INIT_STATE_E-INFOCUBE, sy-vline,
  WA_BICS_PROV_RFC_GET_INIT_STATE_E-GENUNIID, sy-vline,
  WA_BICS_PROV_RFC_GET_INIT_STATE_E-COMPTYPE, sy-vline,
  WA_BICS_PROV_RFC_GET_INIT_STATE_E-COMPID, sy-vline,
  WA_BICS_PROV_RFC_GET_INIT_STATE_E-CURKZ, sy-vline,
  WA_BICS_PROV_RFC_GET_INIT_STATE_E-PERIV, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_BICS_PROV_RFC_GET_INIT_STATE_E 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_BICS_PROV_RFC_GET_INIT_STATE_E 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_BICS_PROV_RFC_GET_INIT_STATE_E INTO WA_BICS_PROV_RFC_GET_INIT_STATE_E.


*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 GENID, internal->external for field GENUNIID
CALL FUNCTION 'CONVERSION_EXIT_GENID_OUTPUT'
  EXPORTING
    input =                      WA_BICS_PROV_RFC_GET_INIT_STATE_E-GENUNIID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BICS_PROV_RFC_GET_INIT_STATE_E-GENUNIID.
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_BICS_PROV_RFC_GET_INIT_STATE_E_STR, 
E_MAX_MESSAGE_TYPE TYPE STRING,
E_DEFAULT_VIEW_DEFINITION TYPE STRING,
E_S_META_QUERY_PROPERTIES TYPE STRING,
COMPUID TYPE STRING,
OBJVERS TYPE STRING,
INFOCUBE TYPE STRING,
GENUNIID TYPE STRING,
COMPTYPE TYPE STRING,
COMPID TYPE STRING,
CURKZ TYPE STRING,
PERIV TYPE STRING,
DUEDATE TYPE STRING,
INPUT_MODE TYPE STRING,
INFOPROVIDER_NAME TYPE STRING,
INFOPROVIDER_TEXT TYPE STRING,
BASE_INFOPROVIDER_NAME TYPE STRING,
BASE_INFOPROVIDER_TEXT TYPE STRING,
QUERY_NAME TYPE STRING,
QUERY_TEXT TYPE STRING,
QUERY_TRANSIENT TYPE STRING,
QUERY_CREATED_BY TYPE STRING,
QUERY_CREATION_DATE TYPE STRING,
QUERY_CREATION_TIME TYPE STRING,
QUERY_CHANGED_BY TYPE STRING,
QUERY_CHANGE_DATE TYPE STRING,
QUERY_CHANGE_TIME TYPE STRING,
DATA_REFRESH_DATE TYPE STRING,
DATA_REFRESH_TIME TYPE STRING,
DATA_ROLLUP_DATE TYPE STRING,
DATA_ROLLUP_TIME TYPE STRING,
DATA_ROLLUP_DATE_MAX TYPE STRING,
DATA_ROLLUP_TIME_MAX TYPE STRING,
MDX_ENABLED TYPE STRING,
HIDE_REPEATED_KEY_VALUES TYPE STRING,
NEW_LINES_ON_ANY_LEVEL TYPE STRING,
DISAGGREGATE_WITHOUT_DATA TYPE STRING,
E_TSX_SELECTION_STATE TYPE STRING,
E_TSX_SELECTION_SPACE TYPE STRING,
E_TH_META_CHARACTERISTICS TYPE STRING,
E_S_STATE_ROWS TYPE STRING,
RESULT_ALIGNMENT TYPE STRING,
HIERARCHICAL TYPE STRING,
INITIAL_LOAD_LEVEL TYPE STRING,
ZERO_SUPPRESSION TYPE STRING,
E_S_STATE_COLUMNS TYPE STRING,
RESULT_ALIGNMENT TYPE STRING,
HIERARCHICAL TYPE STRING,
INITIAL_LOAD_LEVEL TYPE STRING,
ZERO_SUPPRESSION TYPE STRING,
E_S_STATE_FREE TYPE STRING,
RESULT_ALIGNMENT TYPE STRING,
HIERARCHICAL TYPE STRING,
INITIAL_LOAD_LEVEL TYPE STRING,
ZERO_SUPPRESSION TYPE STRING,
E_S_STATE_QUERY_PROPERTIES TYPE STRING,
SRDATE TYPE STRING,
CTART TYPE STRING,
TCUR TYPE STRING,
CTTNM TYPE STRING,
INPUT_ENABLED TYPE STRING,
DRAG_RELATE_URLS TYPE STRING,
ZERO_PRESENTATION TYPE STRING,
ZERO_PRESENTATION_CUST_STRING TYPE STRING,
SIGN_PRESENTATION TYPE STRING,
CURRENCY_UNIT_PRESENTATION TYPE STRING,
RESULT_SET_SIZE_LIMIT TYPE STRING,
READ_CHILD_KIDS TYPE STRING,
E_TX_STATE_CONDITIONS TYPE STRING,
E_TH_STATE_CHARACTERISTICS TYPE STRING,
E_T_MEMBERS TYPE STRING,
E_T_MEMBER_PRESENTATION TYPE STRING,
E_HAS_SPECIFIC_RRI_RECEIVERS TYPE STRING,
E_TX_HIERARCHIES TYPE STRING,
E_T_RRI_RECEIVERS TYPE STRING,
E_T_META_DATA_CELLS TYPE STRING,
E_T_STATE_ROWS_CHARS TYPE STRING,
E_T_STATE_COLUMNS_CHARS TYPE STRING,
E_T_STATE_FREE_CHARS TYPE STRING,
E_T_SUPPORTED_READ_MODES TYPE STRING,
E_T_READ_MODE_INDEX_CATALOG TYPE STRING,
E_RFC_EXCEPTION TYPE STRING,
E_T_DYN_KF TYPE STRING,
E_T_META_DIMENSIONS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_BICS_PROV_RFC_GET_INIT_STATE_E_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_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_MAX_MESSAGE_TYPE sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_DEFAULT_VIEW_DEFINITION sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_S_META_QUERY_PROPERTIES sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-COMPUID sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-OBJVERS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-INFOCUBE sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-GENUNIID sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-COMPTYPE sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-COMPID sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-CURKZ sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-PERIV sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-DUEDATE sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-INPUT_MODE sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-INFOPROVIDER_NAME sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-INFOPROVIDER_TEXT sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-BASE_INFOPROVIDER_NAME sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-BASE_INFOPROVIDER_TEXT sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-QUERY_NAME sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-QUERY_TEXT sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-QUERY_TRANSIENT sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-QUERY_CREATED_BY sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-QUERY_CREATION_DATE sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-QUERY_CREATION_TIME sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-QUERY_CHANGED_BY sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-QUERY_CHANGE_DATE sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-QUERY_CHANGE_TIME sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-DATA_REFRESH_DATE sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-DATA_REFRESH_TIME sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-DATA_ROLLUP_DATE sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-DATA_ROLLUP_TIME sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-DATA_ROLLUP_DATE_MAX sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-DATA_ROLLUP_TIME_MAX sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-MDX_ENABLED sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-HIDE_REPEATED_KEY_VALUES sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-NEW_LINES_ON_ANY_LEVEL sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-DISAGGREGATE_WITHOUT_DATA sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_TSX_SELECTION_STATE sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_TSX_SELECTION_SPACE sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_TH_META_CHARACTERISTICS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_S_STATE_ROWS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-RESULT_ALIGNMENT sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-HIERARCHICAL sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-INITIAL_LOAD_LEVEL sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-ZERO_SUPPRESSION sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_S_STATE_COLUMNS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-RESULT_ALIGNMENT sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-HIERARCHICAL sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-INITIAL_LOAD_LEVEL sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-ZERO_SUPPRESSION sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_S_STATE_FREE sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-RESULT_ALIGNMENT sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-HIERARCHICAL sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-INITIAL_LOAD_LEVEL sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-ZERO_SUPPRESSION sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_S_STATE_QUERY_PROPERTIES sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-SRDATE sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-CTART sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-TCUR sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-CTTNM sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-INPUT_ENABLED sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-DRAG_RELATE_URLS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-ZERO_PRESENTATION sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-ZERO_PRESENTATION_CUST_STRING sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-SIGN_PRESENTATION sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-CURRENCY_UNIT_PRESENTATION sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-RESULT_SET_SIZE_LIMIT sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-READ_CHILD_KIDS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_TX_STATE_CONDITIONS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_TH_STATE_CHARACTERISTICS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_T_MEMBERS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_T_MEMBER_PRESENTATION sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_HAS_SPECIFIC_RRI_RECEIVERS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_TX_HIERARCHIES sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_T_RRI_RECEIVERS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_T_META_DATA_CELLS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_T_STATE_ROWS_CHARS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_T_STATE_COLUMNS_CHARS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_T_STATE_FREE_CHARS sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_T_SUPPORTED_READ_MODES sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_T_READ_MODE_INDEX_CATALOG sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_RFC_EXCEPTION sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_T_DYN_KF sy-vline 
WA_BICS_PROV_RFC_GET_INIT_STATE_E_STR-E_T_META_DIMENSIONS sy-vline      INTO ld_text SEPARATED BY SPACE.

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