ABAP Select data from SAP table /SAPAPO/RET_RP_DAY 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 /SAPAPO/RET_RP_DAY 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 /SAPAPO/RET_RP_DAY. 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 /SAPAPO/RET_RP_DAY 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_/SAPAPO/RET_RP_DAY TYPE STANDARD TABLE OF /SAPAPO/RET_RP_DAY,
      WA_/SAPAPO/RET_RP_DAY TYPE /SAPAPO/RET_RP_DAY,
      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: </SAPAPO/RET_RP_DAY> TYPE /SAPAPO/RET_RP_DAY.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /SAPAPO/RET_RP_DAY
  INTO TABLE IT_/SAPAPO/RET_RP_DAY.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /SAPAPO/RET_RP_DAY
*  INTO TABLE @DATA(IT_/SAPAPO/RET_RP_DAY2).
*--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_/SAPAPO/RET_RP_DAY INDEX 1 INTO DATA(WA_/SAPAPO/RET_RP_DAY2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SAPAPO/RET_RP_DAY ASSIGNING </SAPAPO/RET_RP_DAY>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
</SAPAPO/RET_RP_DAY>-RETID = 1.
</SAPAPO/RET_RP_DAY>-RETNAME = 1.
</SAPAPO/RET_RP_DAY>-LIMIT = 1.
</SAPAPO/RET_RP_DAY>-CELLTAB = 1.
</SAPAPO/RET_RP_DAY>-PERIOD001 = 1.
ENDLOOP.

LOOP AT IT_/SAPAPO/RET_RP_DAY INTO WA_/SAPAPO/RET_RP_DAY.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SAPAPO/RET_RP_DAY-PERIOD002, sy-vline,
WA_/SAPAPO/RET_RP_DAY-PERIOD003, sy-vline,
WA_/SAPAPO/RET_RP_DAY-PERIOD004, sy-vline,
WA_/SAPAPO/RET_RP_DAY-PERIOD005, sy-vline,
WA_/SAPAPO/RET_RP_DAY-PERIOD006, sy-vline,
WA_/SAPAPO/RET_RP_DAY-PERIOD007, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SAPAPO/RET_RP_DAY 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_/SAPAPO/RET_RP_DAY 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_/SAPAPO/RET_RP_DAY INTO WA_/SAPAPO/RET_RP_DAY. *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_/SAPAPO/RET_RP_DAY_STR,
RETID TYPE STRING,
RETNAME TYPE STRING,
LIMIT TYPE STRING,
CELLTAB TYPE STRING,
PERIOD001 TYPE STRING,
PERIOD002 TYPE STRING,
PERIOD003 TYPE STRING,
PERIOD004 TYPE STRING,
PERIOD005 TYPE STRING,
PERIOD006 TYPE STRING,
PERIOD007 TYPE STRING,
PERIOD008 TYPE STRING,
PERIOD009 TYPE STRING,
PERIOD010 TYPE STRING,
PERIOD011 TYPE STRING,
PERIOD012 TYPE STRING,
PERIOD013 TYPE STRING,
PERIOD014 TYPE STRING,
PERIOD015 TYPE STRING,
PERIOD016 TYPE STRING,
PERIOD017 TYPE STRING,
PERIOD018 TYPE STRING,
PERIOD019 TYPE STRING,
PERIOD020 TYPE STRING,
PERIOD021 TYPE STRING,
PERIOD022 TYPE STRING,
PERIOD023 TYPE STRING,
PERIOD024 TYPE STRING,
PERIOD025 TYPE STRING,
PERIOD026 TYPE STRING,
PERIOD027 TYPE STRING,
PERIOD028 TYPE STRING,
PERIOD029 TYPE STRING,
PERIOD030 TYPE STRING,
PERIOD031 TYPE STRING,
PERIOD032 TYPE STRING,
PERIOD033 TYPE STRING,
PERIOD034 TYPE STRING,
PERIOD035 TYPE STRING,
PERIOD036 TYPE STRING,
PERIOD037 TYPE STRING,
PERIOD038 TYPE STRING,
PERIOD039 TYPE STRING,
PERIOD040 TYPE STRING,
PERIOD041 TYPE STRING,
PERIOD042 TYPE STRING,
PERIOD043 TYPE STRING,
PERIOD044 TYPE STRING,
PERIOD045 TYPE STRING,
PERIOD046 TYPE STRING,
PERIOD047 TYPE STRING,
PERIOD048 TYPE STRING,
PERIOD049 TYPE STRING,
PERIOD050 TYPE STRING,
PERIOD051 TYPE STRING,
PERIOD052 TYPE STRING,
PERIOD053 TYPE STRING,
PERIOD054 TYPE STRING,
PERIOD055 TYPE STRING,
PERIOD056 TYPE STRING,
PERIOD057 TYPE STRING,
PERIOD058 TYPE STRING,
PERIOD059 TYPE STRING,
PERIOD060 TYPE STRING,
PERIOD061 TYPE STRING,
PERIOD062 TYPE STRING,
PERIOD063 TYPE STRING,
PERIOD064 TYPE STRING,
PERIOD065 TYPE STRING,
PERIOD066 TYPE STRING,
PERIOD067 TYPE STRING,
PERIOD068 TYPE STRING,
PERIOD069 TYPE STRING,
PERIOD070 TYPE STRING,
PERIOD071 TYPE STRING,
PERIOD072 TYPE STRING,
PERIOD073 TYPE STRING,
PERIOD074 TYPE STRING,
PERIOD075 TYPE STRING,
PERIOD076 TYPE STRING,
PERIOD077 TYPE STRING,
PERIOD078 TYPE STRING,
PERIOD079 TYPE STRING,
PERIOD080 TYPE STRING,
PERIOD081 TYPE STRING,
PERIOD082 TYPE STRING,
PERIOD083 TYPE STRING,
PERIOD084 TYPE STRING,
PERIOD085 TYPE STRING,
PERIOD086 TYPE STRING,
PERIOD087 TYPE STRING,
PERIOD088 TYPE STRING,
PERIOD089 TYPE STRING,
PERIOD090 TYPE STRING,
PERIOD091 TYPE STRING,
PERIOD092 TYPE STRING,
PERIOD093 TYPE STRING,
PERIOD094 TYPE STRING,
PERIOD095 TYPE STRING,
PERIOD096 TYPE STRING,
PERIOD097 TYPE STRING,
PERIOD098 TYPE STRING,
PERIOD099 TYPE STRING,
PERIOD100 TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SAPAPO/RET_RP_DAY_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_/SAPAPO/RET_RP_DAY_STR-RETID sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-RETNAME sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-LIMIT sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-CELLTAB sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD001 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD002 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD003 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD004 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD005 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD006 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD007 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD008 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD009 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD010 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD011 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD012 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD013 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD014 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD015 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD016 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD017 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD018 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD019 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD020 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD021 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD022 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD023 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD024 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD025 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD026 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD027 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD028 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD029 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD030 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD031 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD032 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD033 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD034 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD035 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD036 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD037 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD038 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD039 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD040 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD041 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD042 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD043 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD044 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD045 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD046 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD047 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD048 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD049 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD050 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD051 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD052 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD053 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD054 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD055 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD056 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD057 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD058 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD059 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD060 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD061 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD062 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD063 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD064 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD065 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD066 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD067 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD068 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD069 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD070 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD071 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD072 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD073 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD074 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD075 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD076 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD077 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD078 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD079 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD080 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD081 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD082 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD083 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD084 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD085 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD086 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD087 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD088 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD089 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD090 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD091 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD092 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD093 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD094 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD095 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD096 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD097 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD098 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD099 sy-vline
WA_/SAPAPO/RET_RP_DAY_STR-PERIOD100 sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.