ABAP Select data from SAP table P07_ROEWEB_53 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 P07_ROEWEB_53 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 P07_ROEWEB_53. 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 P07_ROEWEB_53 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_P07_ROEWEB_53 TYPE STANDARD TABLE OF P07_ROEWEB_53,
      WA_P07_ROEWEB_53 TYPE P07_ROEWEB_53,
      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: <P07_ROEWEB_53> TYPE P07_ROEWEB_53.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM P07_ROEWEB_53
*  INTO TABLE @DATA(IT_P07_ROEWEB_532).
*--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_P07_ROEWEB_53 INDEX 1 INTO DATA(WA_P07_ROEWEB_532).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<P07_ROEWEB_53>-PERNR = 1.
<P07_ROEWEB_53>-BUSNM = 1.
<P07_ROEWEB_53>-PPTYP = 1.
<P07_ROEWEB_53>-PERID = 1.
<P07_ROEWEB_53>-EEVORNA = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_P07_ROEWEB_53-EEINITS, sy-vline,
  WA_P07_ROEWEB_53-EENACHN, sy-vline,
  WA_P07_ROEWEB_53-EEADD01, sy-vline,
  WA_P07_ROEWEB_53-EEADD02, sy-vline,
  WA_P07_ROEWEB_53-EEADD03, sy-vline,
  WA_P07_ROEWEB_53-EEPSTLZ, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_P07_ROEWEB_53 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_P07_ROEWEB_53 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_P07_ROEWEB_53 INTO WA_P07_ROEWEB_53.


*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_P07_ROEWEB_53_STR, 
PERNR TYPE STRING,
BUSNM TYPE STRING,
PPTYP TYPE STRING,
PERID TYPE STRING,
EEVORNA TYPE STRING,
EEINITS TYPE STRING,
EENACHN TYPE STRING,
EEADD01 TYPE STRING,
EEADD02 TYPE STRING,
EEADD03 TYPE STRING,
EEPSTLZ TYPE STRING,
FSTDT TYPE STRING,
LSTDT TYPE STRING,
FNLDT TYPE STRING,
PLSTX TYPE STRING,
RCLCD TYPE STRING,
RCLDT TYPE STRING,
TLHRS TYPE STRING,
TLAMT TYPE STRING,
EARN1 TYPE STRING,
EARN2 TYPE STRING,
EARN3 TYPE STRING,
EARN4 TYPE STRING,
EARN5 TYPE STRING,
EARN6 TYPE STRING,
EARN7 TYPE STRING,
EARN8 TYPE STRING,
EARN9 TYPE STRING,
EARN10 TYPE STRING,
EARN11 TYPE STRING,
EARN12 TYPE STRING,
EARN13 TYPE STRING,
EARN14 TYPE STRING,
EARN15 TYPE STRING,
EARN16 TYPE STRING,
EARN17 TYPE STRING,
EARN18 TYPE STRING,
EARN19 TYPE STRING,
EARN20 TYPE STRING,
EARN21 TYPE STRING,
EARN22 TYPE STRING,
EARN23 TYPE STRING,
EARN24 TYPE STRING,
EARN25 TYPE STRING,
EARN26 TYPE STRING,
EARN27 TYPE STRING,
EARN28 TYPE STRING,
EARN29 TYPE STRING,
EARN30 TYPE STRING,
EARN31 TYPE STRING,
EARN32 TYPE STRING,
EARN33 TYPE STRING,
EARN34 TYPE STRING,
EARN35 TYPE STRING,
EARN36 TYPE STRING,
EARN37 TYPE STRING,
EARN38 TYPE STRING,
EARN39 TYPE STRING,
EARN40 TYPE STRING,
EARN41 TYPE STRING,
EARN42 TYPE STRING,
EARN43 TYPE STRING,
EARN44 TYPE STRING,
EARN45 TYPE STRING,
EARN46 TYPE STRING,
EARN47 TYPE STRING,
EARN48 TYPE STRING,
EARN49 TYPE STRING,
EARN50 TYPE STRING,
EARN51 TYPE STRING,
EARN52 TYPE STRING,
EARN53 TYPE STRING,
REASN TYPE STRING,
CTVORNA TYPE STRING,
CTNACHN TYPE STRING,
CTAREA TYPE STRING,
CTPHONE TYPE STRING,
CTEXTN TYPE STRING,
VPCODE TYPE STRING,
VPAMT TYPE STRING,
SPDATE1 TYPE STRING,
SPAMT1 TYPE STRING,
SPDATE2 TYPE STRING,
SPAMT2 TYPE STRING,
SPDATE3 TYPE STRING,
SPAMT3 TYPE STRING,
OMCODE1 TYPE STRING,
OMAMT1 TYPE STRING,
OMCODE2 TYPE STRING,
OMAMT2 TYPE STRING,
OMCODE3 TYPE STRING,
OMAMT3 TYPE STRING,
COMMENTS1 TYPE STRING,
COMMENTS2 TYPE STRING,
COMMENTS3 TYPE STRING,
COMMENTS4 TYPE STRING,
SKDATE TYPE STRING,
SKAMT TYPE STRING,
SKPRD TYPE STRING,
CLANG TYPE STRING,
PLANG TYPE STRING,
ROEPM TYPE STRING,
ORGSN TYPE STRING,
SPARE TYPE STRING,
SKTYP TYPE STRING,
SPDATE4 TYPE STRING,
SPDATE5 TYPE STRING,
SPDATE6 TYPE STRING,
SPDATE7 TYPE STRING,
SPDATE8 TYPE STRING,
SPDATE9 TYPE STRING,
SPDATE10 TYPE STRING,
SPAMT4 TYPE STRING,
SPAMT5 TYPE STRING,
SPAMT6 TYPE STRING,
SPAMT7 TYPE STRING,
SPAMT8 TYPE STRING,
SPAMT9 TYPE STRING,
SPAMT10 TYPE STRING,
SPPAYCOD1 TYPE STRING,
SPPAYAMT1 TYPE STRING,
SPPAYPER1 TYPE STRING,
SPPAYSDT1 TYPE STRING,
SPPAYEDT1 TYPE STRING,
SPPAYCOD2 TYPE STRING,
SPPAYAMT2 TYPE STRING,
SPPAYPER2 TYPE STRING,
SPPAYSDT2 TYPE STRING,
SPPAYEDT2 TYPE STRING,
SPPAYCOD3 TYPE STRING,
SPPAYAMT3 TYPE STRING,
SPPAYPER3 TYPE STRING,
SPPAYSDT3 TYPE STRING,
SPPAYEDT3 TYPE STRING,
SPPAYCOD4 TYPE STRING,
SPPAYAMT4 TYPE STRING,
SPPAYPER4 TYPE STRING,
SPPAYSDT4 TYPE STRING,
SPPAYEDT4 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_P07_ROEWEB_53_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_P07_ROEWEB_53_STR-PERNR sy-vline 
WA_P07_ROEWEB_53_STR-BUSNM sy-vline 
WA_P07_ROEWEB_53_STR-PPTYP sy-vline 
WA_P07_ROEWEB_53_STR-PERID sy-vline 
WA_P07_ROEWEB_53_STR-EEVORNA sy-vline 
WA_P07_ROEWEB_53_STR-EEINITS sy-vline 
WA_P07_ROEWEB_53_STR-EENACHN sy-vline 
WA_P07_ROEWEB_53_STR-EEADD01 sy-vline 
WA_P07_ROEWEB_53_STR-EEADD02 sy-vline 
WA_P07_ROEWEB_53_STR-EEADD03 sy-vline 
WA_P07_ROEWEB_53_STR-EEPSTLZ sy-vline 
WA_P07_ROEWEB_53_STR-FSTDT sy-vline 
WA_P07_ROEWEB_53_STR-LSTDT sy-vline 
WA_P07_ROEWEB_53_STR-FNLDT sy-vline 
WA_P07_ROEWEB_53_STR-PLSTX sy-vline 
WA_P07_ROEWEB_53_STR-RCLCD sy-vline 
WA_P07_ROEWEB_53_STR-RCLDT sy-vline 
WA_P07_ROEWEB_53_STR-TLHRS sy-vline 
WA_P07_ROEWEB_53_STR-TLAMT sy-vline 
WA_P07_ROEWEB_53_STR-EARN1 sy-vline 
WA_P07_ROEWEB_53_STR-EARN2 sy-vline 
WA_P07_ROEWEB_53_STR-EARN3 sy-vline 
WA_P07_ROEWEB_53_STR-EARN4 sy-vline 
WA_P07_ROEWEB_53_STR-EARN5 sy-vline 
WA_P07_ROEWEB_53_STR-EARN6 sy-vline 
WA_P07_ROEWEB_53_STR-EARN7 sy-vline 
WA_P07_ROEWEB_53_STR-EARN8 sy-vline 
WA_P07_ROEWEB_53_STR-EARN9 sy-vline 
WA_P07_ROEWEB_53_STR-EARN10 sy-vline 
WA_P07_ROEWEB_53_STR-EARN11 sy-vline 
WA_P07_ROEWEB_53_STR-EARN12 sy-vline 
WA_P07_ROEWEB_53_STR-EARN13 sy-vline 
WA_P07_ROEWEB_53_STR-EARN14 sy-vline 
WA_P07_ROEWEB_53_STR-EARN15 sy-vline 
WA_P07_ROEWEB_53_STR-EARN16 sy-vline 
WA_P07_ROEWEB_53_STR-EARN17 sy-vline 
WA_P07_ROEWEB_53_STR-EARN18 sy-vline 
WA_P07_ROEWEB_53_STR-EARN19 sy-vline 
WA_P07_ROEWEB_53_STR-EARN20 sy-vline 
WA_P07_ROEWEB_53_STR-EARN21 sy-vline 
WA_P07_ROEWEB_53_STR-EARN22 sy-vline 
WA_P07_ROEWEB_53_STR-EARN23 sy-vline 
WA_P07_ROEWEB_53_STR-EARN24 sy-vline 
WA_P07_ROEWEB_53_STR-EARN25 sy-vline 
WA_P07_ROEWEB_53_STR-EARN26 sy-vline 
WA_P07_ROEWEB_53_STR-EARN27 sy-vline 
WA_P07_ROEWEB_53_STR-EARN28 sy-vline 
WA_P07_ROEWEB_53_STR-EARN29 sy-vline 
WA_P07_ROEWEB_53_STR-EARN30 sy-vline 
WA_P07_ROEWEB_53_STR-EARN31 sy-vline 
WA_P07_ROEWEB_53_STR-EARN32 sy-vline 
WA_P07_ROEWEB_53_STR-EARN33 sy-vline 
WA_P07_ROEWEB_53_STR-EARN34 sy-vline 
WA_P07_ROEWEB_53_STR-EARN35 sy-vline 
WA_P07_ROEWEB_53_STR-EARN36 sy-vline 
WA_P07_ROEWEB_53_STR-EARN37 sy-vline 
WA_P07_ROEWEB_53_STR-EARN38 sy-vline 
WA_P07_ROEWEB_53_STR-EARN39 sy-vline 
WA_P07_ROEWEB_53_STR-EARN40 sy-vline 
WA_P07_ROEWEB_53_STR-EARN41 sy-vline 
WA_P07_ROEWEB_53_STR-EARN42 sy-vline 
WA_P07_ROEWEB_53_STR-EARN43 sy-vline 
WA_P07_ROEWEB_53_STR-EARN44 sy-vline 
WA_P07_ROEWEB_53_STR-EARN45 sy-vline 
WA_P07_ROEWEB_53_STR-EARN46 sy-vline 
WA_P07_ROEWEB_53_STR-EARN47 sy-vline 
WA_P07_ROEWEB_53_STR-EARN48 sy-vline 
WA_P07_ROEWEB_53_STR-EARN49 sy-vline 
WA_P07_ROEWEB_53_STR-EARN50 sy-vline 
WA_P07_ROEWEB_53_STR-EARN51 sy-vline 
WA_P07_ROEWEB_53_STR-EARN52 sy-vline 
WA_P07_ROEWEB_53_STR-EARN53 sy-vline 
WA_P07_ROEWEB_53_STR-REASN sy-vline 
WA_P07_ROEWEB_53_STR-CTVORNA sy-vline 
WA_P07_ROEWEB_53_STR-CTNACHN sy-vline 
WA_P07_ROEWEB_53_STR-CTAREA sy-vline 
WA_P07_ROEWEB_53_STR-CTPHONE sy-vline 
WA_P07_ROEWEB_53_STR-CTEXTN sy-vline 
WA_P07_ROEWEB_53_STR-VPCODE sy-vline 
WA_P07_ROEWEB_53_STR-VPAMT sy-vline 
WA_P07_ROEWEB_53_STR-SPDATE1 sy-vline 
WA_P07_ROEWEB_53_STR-SPAMT1 sy-vline 
WA_P07_ROEWEB_53_STR-SPDATE2 sy-vline 
WA_P07_ROEWEB_53_STR-SPAMT2 sy-vline 
WA_P07_ROEWEB_53_STR-SPDATE3 sy-vline 
WA_P07_ROEWEB_53_STR-SPAMT3 sy-vline 
WA_P07_ROEWEB_53_STR-OMCODE1 sy-vline 
WA_P07_ROEWEB_53_STR-OMAMT1 sy-vline 
WA_P07_ROEWEB_53_STR-OMCODE2 sy-vline 
WA_P07_ROEWEB_53_STR-OMAMT2 sy-vline 
WA_P07_ROEWEB_53_STR-OMCODE3 sy-vline 
WA_P07_ROEWEB_53_STR-OMAMT3 sy-vline 
WA_P07_ROEWEB_53_STR-COMMENTS1 sy-vline 
WA_P07_ROEWEB_53_STR-COMMENTS2 sy-vline 
WA_P07_ROEWEB_53_STR-COMMENTS3 sy-vline 
WA_P07_ROEWEB_53_STR-COMMENTS4 sy-vline 
WA_P07_ROEWEB_53_STR-SKDATE sy-vline 
WA_P07_ROEWEB_53_STR-SKAMT sy-vline 
WA_P07_ROEWEB_53_STR-SKPRD sy-vline 
WA_P07_ROEWEB_53_STR-CLANG sy-vline 
WA_P07_ROEWEB_53_STR-PLANG sy-vline 
WA_P07_ROEWEB_53_STR-ROEPM sy-vline 
WA_P07_ROEWEB_53_STR-ORGSN sy-vline 
WA_P07_ROEWEB_53_STR-SPARE sy-vline 
WA_P07_ROEWEB_53_STR-SKTYP sy-vline 
WA_P07_ROEWEB_53_STR-SPDATE4 sy-vline 
WA_P07_ROEWEB_53_STR-SPDATE5 sy-vline 
WA_P07_ROEWEB_53_STR-SPDATE6 sy-vline 
WA_P07_ROEWEB_53_STR-SPDATE7 sy-vline 
WA_P07_ROEWEB_53_STR-SPDATE8 sy-vline 
WA_P07_ROEWEB_53_STR-SPDATE9 sy-vline 
WA_P07_ROEWEB_53_STR-SPDATE10 sy-vline 
WA_P07_ROEWEB_53_STR-SPAMT4 sy-vline 
WA_P07_ROEWEB_53_STR-SPAMT5 sy-vline 
WA_P07_ROEWEB_53_STR-SPAMT6 sy-vline 
WA_P07_ROEWEB_53_STR-SPAMT7 sy-vline 
WA_P07_ROEWEB_53_STR-SPAMT8 sy-vline 
WA_P07_ROEWEB_53_STR-SPAMT9 sy-vline 
WA_P07_ROEWEB_53_STR-SPAMT10 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYCOD1 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYAMT1 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYPER1 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYSDT1 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYEDT1 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYCOD2 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYAMT2 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYPER2 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYSDT2 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYEDT2 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYCOD3 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYAMT3 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYPER3 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYSDT3 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYEDT3 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYCOD4 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYAMT4 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYPER4 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYSDT4 sy-vline 
WA_P07_ROEWEB_53_STR-SPPAYEDT4 sy-vline      INTO ld_text SEPARATED BY SPACE.

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