ABAP Select data from SAP table BICS_PROV_META_DATA 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_META_DATA 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_META_DATA. 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_META_DATA 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_META_DATA TYPE STANDARD TABLE OF BICS_PROV_META_DATA,
      WA_BICS_PROV_META_DATA TYPE BICS_PROV_META_DATA,
      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_META_DATA> TYPE BICS_PROV_META_DATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM BICS_PROV_META_DATA
*  INTO TABLE @DATA(IT_BICS_PROV_META_DATA2).
*--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_META_DATA INDEX 1 INTO DATA(WA_BICS_PROV_META_DATA2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<BICS_PROV_META_DATA>-CHARACTERISTICS = 1.
<BICS_PROV_META_DATA>-STRUCTURE_INFO = 1.
<BICS_PROV_META_DATA>-STRUCTURE_COUNT = 1.
<BICS_PROV_META_DATA>-NAME_1 = 1.
<BICS_PROV_META_DATA>-ID_1 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_BICS_PROV_META_DATA-NAME_2, sy-vline,
  WA_BICS_PROV_META_DATA-ID_2, sy-vline,
  WA_BICS_PROV_META_DATA-SELECTION_SPACE, sy-vline,
  WA_BICS_PROV_META_DATA-VARIABLE_VALUES, sy-vline,
  WA_BICS_PROV_META_DATA-QUERY_STATE, sy-vline,
  WA_BICS_PROV_META_DATA-CHARACTERISTICS, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_BICS_PROV_META_DATA 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_META_DATA 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_META_DATA INTO WA_BICS_PROV_META_DATA.


*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_META_DATA-GENUNIID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BICS_PROV_META_DATA-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_META_DATA_STR, 
CHARACTERISTICS TYPE STRING,
STRUCTURE_INFO TYPE STRING,
STRUCTURE_COUNT TYPE STRING,
NAME_1 TYPE STRING,
ID_1 TYPE STRING,
NAME_2 TYPE STRING,
ID_2 TYPE STRING,
SELECTION_SPACE TYPE STRING,
VARIABLE_VALUES TYPE STRING,
QUERY_STATE TYPE STRING,
CHARACTERISTICS TYPE STRING,
SELECTION_STATE TYPE STRING,
FREE_AXIS TYPE STRING,
RESULT_ALIGNMENT TYPE STRING,
HIERARCHICAL TYPE STRING,
INITIAL_LOAD_LEVEL TYPE STRING,
ZERO_SUPPRESSION TYPE STRING,
CHARACTERISTICS TYPE STRING,
ZERO_SUPPRESSION_MODE TYPE STRING,
COLUMNS_AXIS TYPE STRING,
RESULT_ALIGNMENT TYPE STRING,
HIERARCHICAL TYPE STRING,
INITIAL_LOAD_LEVEL TYPE STRING,
ZERO_SUPPRESSION TYPE STRING,
CHARACTERISTICS TYPE STRING,
ZERO_SUPPRESSION_MODE TYPE STRING,
ROWS_AXIS TYPE STRING,
RESULT_ALIGNMENT TYPE STRING,
HIERARCHICAL TYPE STRING,
INITIAL_LOAD_LEVEL TYPE STRING,
ZERO_SUPPRESSION TYPE STRING,
CHARACTERISTICS TYPE STRING,
ZERO_SUPPRESSION_MODE TYPE STRING,
CONDITIONS TYPE STRING,
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,
DATA_CELLS TYPE STRING,
CONDITIONS_CONS TYPE STRING,
EXCEPTIONS_CONS TYPE STRING,
DRILL_GROUPS TYPE STRING,
SELECTION_STATE_NON_CART TYPE STRING,
TUPLES TYPE STRING,
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,
DATA_CELLS TYPE STRING,
DEFAULT_VIEW_DEFINITION TYPE STRING,
DESIGNTIME_INFO TYPE STRING,
QUERY_NAME TYPE STRING,
SELECTION_SPACE TYPE STRING,
SELECTION_STATE TYPE STRING,
VARIABLES TYPE STRING,
VARIABLE_CHARACTERISTICS_META TYPE STRING,
VARIABLE_CHARACTERISTICS_STATE TYPE STRING,
KEY_FIGURES TYPE STRING,
NODE_TYPES TYPE STRING,
HIERARCHIES TYPE STRING,
CHARACTERISTICS TYPE STRING,
SELECTION_STATE_SORTING TYPE STRING,
DATACELL_DETAILS TYPE STRING,
DIMENSIONS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_BICS_PROV_META_DATA_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_META_DATA_STR-CHARACTERISTICS sy-vline 
WA_BICS_PROV_META_DATA_STR-STRUCTURE_INFO sy-vline 
WA_BICS_PROV_META_DATA_STR-STRUCTURE_COUNT sy-vline 
WA_BICS_PROV_META_DATA_STR-NAME_1 sy-vline 
WA_BICS_PROV_META_DATA_STR-ID_1 sy-vline 
WA_BICS_PROV_META_DATA_STR-NAME_2 sy-vline 
WA_BICS_PROV_META_DATA_STR-ID_2 sy-vline 
WA_BICS_PROV_META_DATA_STR-SELECTION_SPACE sy-vline 
WA_BICS_PROV_META_DATA_STR-VARIABLE_VALUES sy-vline 
WA_BICS_PROV_META_DATA_STR-QUERY_STATE sy-vline 
WA_BICS_PROV_META_DATA_STR-CHARACTERISTICS sy-vline 
WA_BICS_PROV_META_DATA_STR-SELECTION_STATE sy-vline 
WA_BICS_PROV_META_DATA_STR-FREE_AXIS sy-vline 
WA_BICS_PROV_META_DATA_STR-RESULT_ALIGNMENT sy-vline 
WA_BICS_PROV_META_DATA_STR-HIERARCHICAL sy-vline 
WA_BICS_PROV_META_DATA_STR-INITIAL_LOAD_LEVEL sy-vline 
WA_BICS_PROV_META_DATA_STR-ZERO_SUPPRESSION sy-vline 
WA_BICS_PROV_META_DATA_STR-CHARACTERISTICS sy-vline 
WA_BICS_PROV_META_DATA_STR-ZERO_SUPPRESSION_MODE sy-vline 
WA_BICS_PROV_META_DATA_STR-COLUMNS_AXIS sy-vline 
WA_BICS_PROV_META_DATA_STR-RESULT_ALIGNMENT sy-vline 
WA_BICS_PROV_META_DATA_STR-HIERARCHICAL sy-vline 
WA_BICS_PROV_META_DATA_STR-INITIAL_LOAD_LEVEL sy-vline 
WA_BICS_PROV_META_DATA_STR-ZERO_SUPPRESSION sy-vline 
WA_BICS_PROV_META_DATA_STR-CHARACTERISTICS sy-vline 
WA_BICS_PROV_META_DATA_STR-ZERO_SUPPRESSION_MODE sy-vline 
WA_BICS_PROV_META_DATA_STR-ROWS_AXIS sy-vline 
WA_BICS_PROV_META_DATA_STR-RESULT_ALIGNMENT sy-vline 
WA_BICS_PROV_META_DATA_STR-HIERARCHICAL sy-vline 
WA_BICS_PROV_META_DATA_STR-INITIAL_LOAD_LEVEL sy-vline 
WA_BICS_PROV_META_DATA_STR-ZERO_SUPPRESSION sy-vline 
WA_BICS_PROV_META_DATA_STR-CHARACTERISTICS sy-vline 
WA_BICS_PROV_META_DATA_STR-ZERO_SUPPRESSION_MODE sy-vline 
WA_BICS_PROV_META_DATA_STR-CONDITIONS sy-vline 
WA_BICS_PROV_META_DATA_STR-QUERY_PROPERTIES sy-vline 
WA_BICS_PROV_META_DATA_STR-SRDATE sy-vline 
WA_BICS_PROV_META_DATA_STR-CTART sy-vline 
WA_BICS_PROV_META_DATA_STR-TCUR sy-vline 
WA_BICS_PROV_META_DATA_STR-CTTNM sy-vline 
WA_BICS_PROV_META_DATA_STR-INPUT_ENABLED sy-vline 
WA_BICS_PROV_META_DATA_STR-DRAG_RELATE_URLS sy-vline 
WA_BICS_PROV_META_DATA_STR-ZERO_PRESENTATION sy-vline 
WA_BICS_PROV_META_DATA_STR-ZERO_PRESENTATION_CUST_STRING sy-vline 
WA_BICS_PROV_META_DATA_STR-SIGN_PRESENTATION sy-vline 
WA_BICS_PROV_META_DATA_STR-CURRENCY_UNIT_PRESENTATION sy-vline 
WA_BICS_PROV_META_DATA_STR-RESULT_SET_SIZE_LIMIT sy-vline 
WA_BICS_PROV_META_DATA_STR-READ_CHILD_KIDS sy-vline 
WA_BICS_PROV_META_DATA_STR-DATA_CELLS sy-vline 
WA_BICS_PROV_META_DATA_STR-CONDITIONS_CONS sy-vline 
WA_BICS_PROV_META_DATA_STR-EXCEPTIONS_CONS sy-vline 
WA_BICS_PROV_META_DATA_STR-DRILL_GROUPS sy-vline 
WA_BICS_PROV_META_DATA_STR-SELECTION_STATE_NON_CART sy-vline 
WA_BICS_PROV_META_DATA_STR-TUPLES sy-vline 
WA_BICS_PROV_META_DATA_STR-QUERY_PROPERTIES sy-vline 
WA_BICS_PROV_META_DATA_STR-COMPUID sy-vline 
WA_BICS_PROV_META_DATA_STR-OBJVERS sy-vline 
WA_BICS_PROV_META_DATA_STR-INFOCUBE sy-vline 
WA_BICS_PROV_META_DATA_STR-GENUNIID sy-vline 
WA_BICS_PROV_META_DATA_STR-COMPTYPE sy-vline 
WA_BICS_PROV_META_DATA_STR-COMPID sy-vline 
WA_BICS_PROV_META_DATA_STR-CURKZ sy-vline 
WA_BICS_PROV_META_DATA_STR-PERIV sy-vline 
WA_BICS_PROV_META_DATA_STR-DUEDATE sy-vline 
WA_BICS_PROV_META_DATA_STR-INPUT_MODE sy-vline 
WA_BICS_PROV_META_DATA_STR-INFOPROVIDER_NAME sy-vline 
WA_BICS_PROV_META_DATA_STR-INFOPROVIDER_TEXT sy-vline 
WA_BICS_PROV_META_DATA_STR-BASE_INFOPROVIDER_NAME sy-vline 
WA_BICS_PROV_META_DATA_STR-BASE_INFOPROVIDER_TEXT sy-vline 
WA_BICS_PROV_META_DATA_STR-QUERY_NAME sy-vline 
WA_BICS_PROV_META_DATA_STR-QUERY_TEXT sy-vline 
WA_BICS_PROV_META_DATA_STR-QUERY_TRANSIENT sy-vline 
WA_BICS_PROV_META_DATA_STR-QUERY_CREATED_BY sy-vline 
WA_BICS_PROV_META_DATA_STR-QUERY_CREATION_DATE sy-vline 
WA_BICS_PROV_META_DATA_STR-QUERY_CREATION_TIME sy-vline 
WA_BICS_PROV_META_DATA_STR-QUERY_CHANGED_BY sy-vline 
WA_BICS_PROV_META_DATA_STR-QUERY_CHANGE_DATE sy-vline 
WA_BICS_PROV_META_DATA_STR-QUERY_CHANGE_TIME sy-vline 
WA_BICS_PROV_META_DATA_STR-DATA_REFRESH_DATE sy-vline 
WA_BICS_PROV_META_DATA_STR-DATA_REFRESH_TIME sy-vline 
WA_BICS_PROV_META_DATA_STR-DATA_ROLLUP_DATE sy-vline 
WA_BICS_PROV_META_DATA_STR-DATA_ROLLUP_TIME sy-vline 
WA_BICS_PROV_META_DATA_STR-DATA_ROLLUP_DATE_MAX sy-vline 
WA_BICS_PROV_META_DATA_STR-DATA_ROLLUP_TIME_MAX sy-vline 
WA_BICS_PROV_META_DATA_STR-MDX_ENABLED sy-vline 
WA_BICS_PROV_META_DATA_STR-HIDE_REPEATED_KEY_VALUES sy-vline 
WA_BICS_PROV_META_DATA_STR-NEW_LINES_ON_ANY_LEVEL sy-vline 
WA_BICS_PROV_META_DATA_STR-DISAGGREGATE_WITHOUT_DATA sy-vline 
WA_BICS_PROV_META_DATA_STR-DATA_CELLS sy-vline 
WA_BICS_PROV_META_DATA_STR-DEFAULT_VIEW_DEFINITION sy-vline 
WA_BICS_PROV_META_DATA_STR-DESIGNTIME_INFO sy-vline 
WA_BICS_PROV_META_DATA_STR-QUERY_NAME sy-vline 
WA_BICS_PROV_META_DATA_STR-SELECTION_SPACE sy-vline 
WA_BICS_PROV_META_DATA_STR-SELECTION_STATE sy-vline 
WA_BICS_PROV_META_DATA_STR-VARIABLES sy-vline 
WA_BICS_PROV_META_DATA_STR-VARIABLE_CHARACTERISTICS_META sy-vline 
WA_BICS_PROV_META_DATA_STR-VARIABLE_CHARACTERISTICS_STATE sy-vline 
WA_BICS_PROV_META_DATA_STR-KEY_FIGURES sy-vline 
WA_BICS_PROV_META_DATA_STR-NODE_TYPES sy-vline 
WA_BICS_PROV_META_DATA_STR-HIERARCHIES sy-vline 
WA_BICS_PROV_META_DATA_STR-CHARACTERISTICS sy-vline 
WA_BICS_PROV_META_DATA_STR-SELECTION_STATE_SORTING sy-vline 
WA_BICS_PROV_META_DATA_STR-DATACELL_DETAILS sy-vline 
WA_BICS_PROV_META_DATA_STR-DIMENSIONS sy-vline      INTO ld_text SEPARATED BY SPACE.

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