ABAP Select data from SAP table /SDF/ORATABINFO 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 /SDF/ORATABINFO 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 /SDF/ORATABINFO. 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 /SDF/ORATABINFO 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_/SDF/ORATABINFO TYPE STANDARD TABLE OF /SDF/ORATABINFO,
WA_/SDF/ORATABINFO TYPE /SDF/ORATABINFO,
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: </SDF/ORATABINFO> TYPE /SDF/ORATABINFO.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_/SDF/ORATABINFO.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM /SDF/ORATABINFO
INTO TABLE IT_/SDF/ORATABINFO.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM /SDF/ORATABINFO
* INTO TABLE @DATA(IT_/SDF/ORATABINFO2).
*--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_/SDF/ORATABINFO INDEX 1 INTO DATA(WA_/SDF/ORATABINFO2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SDF/ORATABINFO ASSIGNING </SDF/ORATABINFO>.
*To update a field value using a field symbol simply change the value via the field symbol pointer</SDF/ORATABINFO>-TABLE_OWNER = 1.
</SDF/ORATABINFO>-TABLE_NAME = 1.
</SDF/ORATABINFO>-NUM_ROWS = 1.
</SDF/ORATABINFO>-BLOCKS = 1.
</SDF/ORATABINFO>-EMPTY_BLKS = 1.
ENDLOOP. LOOP AT IT_/SDF/ORATABINFO INTO WA_/SDF/ORATABINFO. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_/SDF/ORATABINFO-AVG_SPACE, sy-vline,
WA_/SDF/ORATABINFO-CHAIN_CNT, sy-vline,
WA_/SDF/ORATABINFO-AVG_ROW_LN, sy-vline,
WA_/SDF/ORATABINFO-SAMPL_SIZE, sy-vline,
WA_/SDF/ORATABINFO-LAST_ANALY, sy-vline,
WA_/SDF/ORATABINFO-LAST_CHANG, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SDF/ORATABINFO 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_/SDF/ORATABINFO 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_/SDF/ORATABINFO INTO WA_/SDF/ORATABINFO. *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.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_/SDF/ORATABINFO_STR,
TABLE_OWNER TYPE STRING,
TABLE_NAME TYPE STRING,
NUM_ROWS TYPE STRING,
BLOCKS TYPE STRING,
EMPTY_BLKS TYPE STRING,
AVG_SPACE TYPE STRING,
CHAIN_CNT TYPE STRING,
AVG_ROW_LN TYPE STRING,
SAMPL_SIZE TYPE STRING,
LAST_ANALY TYPE STRING,
LAST_CHANG TYPE STRING,
BUFF_TYPE TYPE STRING,
TABLESPACE_NAME TYPE STRING,
IOT_NAME TYPE STRING,
STATUS TYPE STRING,
PCT_FREE TYPE STRING,
LOGGING TYPE STRING,
BACKED_UP TYPE STRING,
AVG_SP_FREL_BLK TYPE STRING,
NUM_FREL_BLCKS TYPE STRING,
DEGREE TYPE STRING,
INSTANCES TYPE STRING,
CACHE TYPE STRING,
TABLE_LOCK TYPE STRING,
PARTITIONED TYPE STRING,
IOT_TYPE TYPE STRING,
BUFFER_POOL TYPE STRING,
ROW_MOVEMENT TYPE STRING,
GLOBAL_STATS TYPE STRING,
USER_STATS TYPE STRING,
TEMPORARY TYPE STRING,
DURATION TYPE STRING,
SKIP_CORRUPT TYPE STRING,
DEPENDENCIES TYPE STRING,
COMPRESSION TYPE STRING,
COMPRESS_FOR TYPE STRING,
DROPPED TYPE STRING,
CREATED TYPE STRING,
LAST_DDL_TIME TYPE STRING,
FLASH_CACHE TYPE STRING,
CELL_F_CACHE TYPE STRING,
SEGMENT_CREATED TYPE STRING,
READ_ONLY TYPE STRING,
ACT_TRACKING TYPE STRING,
DML_TIMESTAMP TYPE STRING,
HAS_IDENTITY TYPE STRING,
CONTAINER_DATA TYPE STRING,
INMEMORY TYPE STRING,
INMEMORY_PRIO TYPE STRING,
INMEMORY_DISTR TYPE STRING,
INMEMORY_COMPR TYPE STRING,
INMEMORY_DUPL TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SDF/ORATABINFO_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_/SDF/ORATABINFO_STR-TABLE_OWNER sy-vline
WA_/SDF/ORATABINFO_STR-TABLE_NAME sy-vline
WA_/SDF/ORATABINFO_STR-NUM_ROWS sy-vline
WA_/SDF/ORATABINFO_STR-BLOCKS sy-vline
WA_/SDF/ORATABINFO_STR-EMPTY_BLKS sy-vline
WA_/SDF/ORATABINFO_STR-AVG_SPACE sy-vline
WA_/SDF/ORATABINFO_STR-CHAIN_CNT sy-vline
WA_/SDF/ORATABINFO_STR-AVG_ROW_LN sy-vline
WA_/SDF/ORATABINFO_STR-SAMPL_SIZE sy-vline
WA_/SDF/ORATABINFO_STR-LAST_ANALY sy-vline
WA_/SDF/ORATABINFO_STR-LAST_CHANG sy-vline
WA_/SDF/ORATABINFO_STR-BUFF_TYPE sy-vline
WA_/SDF/ORATABINFO_STR-TABLESPACE_NAME sy-vline
WA_/SDF/ORATABINFO_STR-IOT_NAME sy-vline
WA_/SDF/ORATABINFO_STR-STATUS sy-vline
WA_/SDF/ORATABINFO_STR-PCT_FREE sy-vline
WA_/SDF/ORATABINFO_STR-LOGGING sy-vline
WA_/SDF/ORATABINFO_STR-BACKED_UP sy-vline
WA_/SDF/ORATABINFO_STR-AVG_SP_FREL_BLK sy-vline
WA_/SDF/ORATABINFO_STR-NUM_FREL_BLCKS sy-vline
WA_/SDF/ORATABINFO_STR-DEGREE sy-vline
WA_/SDF/ORATABINFO_STR-INSTANCES sy-vline
WA_/SDF/ORATABINFO_STR-CACHE sy-vline
WA_/SDF/ORATABINFO_STR-TABLE_LOCK sy-vline
WA_/SDF/ORATABINFO_STR-PARTITIONED sy-vline
WA_/SDF/ORATABINFO_STR-IOT_TYPE sy-vline
WA_/SDF/ORATABINFO_STR-BUFFER_POOL sy-vline
WA_/SDF/ORATABINFO_STR-ROW_MOVEMENT sy-vline
WA_/SDF/ORATABINFO_STR-GLOBAL_STATS sy-vline
WA_/SDF/ORATABINFO_STR-USER_STATS sy-vline
WA_/SDF/ORATABINFO_STR-TEMPORARY sy-vline
WA_/SDF/ORATABINFO_STR-DURATION sy-vline
WA_/SDF/ORATABINFO_STR-SKIP_CORRUPT sy-vline
WA_/SDF/ORATABINFO_STR-DEPENDENCIES sy-vline
WA_/SDF/ORATABINFO_STR-COMPRESSION sy-vline
WA_/SDF/ORATABINFO_STR-COMPRESS_FOR sy-vline
WA_/SDF/ORATABINFO_STR-DROPPED sy-vline
WA_/SDF/ORATABINFO_STR-CREATED sy-vline
WA_/SDF/ORATABINFO_STR-LAST_DDL_TIME sy-vline
WA_/SDF/ORATABINFO_STR-FLASH_CACHE sy-vline
WA_/SDF/ORATABINFO_STR-CELL_F_CACHE sy-vline
WA_/SDF/ORATABINFO_STR-SEGMENT_CREATED sy-vline
WA_/SDF/ORATABINFO_STR-READ_ONLY sy-vline
WA_/SDF/ORATABINFO_STR-ACT_TRACKING sy-vline
WA_/SDF/ORATABINFO_STR-DML_TIMESTAMP sy-vline
WA_/SDF/ORATABINFO_STR-HAS_IDENTITY sy-vline
WA_/SDF/ORATABINFO_STR-CONTAINER_DATA sy-vline
WA_/SDF/ORATABINFO_STR-INMEMORY sy-vline
WA_/SDF/ORATABINFO_STR-INMEMORY_PRIO sy-vline
WA_/SDF/ORATABINFO_STR-INMEMORY_DISTR sy-vline
WA_/SDF/ORATABINFO_STR-INMEMORY_COMPR sy-vline
WA_/SDF/ORATABINFO_STR-INMEMORY_DUPL sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.