ABAP Select data from SAP table J_3RBS_LINE_2350 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 J_3RBS_LINE_2350 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 J_3RBS_LINE_2350. 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 J_3RBS_LINE_2350 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_J_3RBS_LINE_2350 TYPE STANDARD TABLE OF J_3RBS_LINE_2350,
      WA_J_3RBS_LINE_2350 TYPE J_3RBS_LINE_2350,
      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: <J_3RBS_LINE_2350> TYPE J_3RBS_LINE_2350.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM J_3RBS_LINE_2350
*  INTO TABLE @DATA(IT_J_3RBS_LINE_23502).
*--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_J_3RBS_LINE_2350 INDEX 1 INTO DATA(WA_J_3RBS_LINE_23502).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<J_3RBS_LINE_2350>-23501CURR = 1.
<J_3RBS_LINE_2350>-23501PREV = 1.
<J_3RBS_LINE_2350>-23501NAME = 1.
<J_3RBS_LINE_2350>-23502CURR = 1.
<J_3RBS_LINE_2350>-23502PREV = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_J_3RBS_LINE_2350-23502NAME, sy-vline,
  WA_J_3RBS_LINE_2350-23503CURR, sy-vline,
  WA_J_3RBS_LINE_2350-23503PREV, sy-vline,
  WA_J_3RBS_LINE_2350-23503NAME, sy-vline,
  WA_J_3RBS_LINE_2350-23504CURR, sy-vline,
  WA_J_3RBS_LINE_2350-23504PREV, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_J_3RBS_LINE_2350 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_J_3RBS_LINE_2350 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_J_3RBS_LINE_2350 INTO WA_J_3RBS_LINE_2350.


*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_J_3RBS_LINE_2350_STR, 
23501CURR TYPE STRING,
23501PREV TYPE STRING,
23501NAME TYPE STRING,
23502CURR TYPE STRING,
23502PREV TYPE STRING,
23502NAME TYPE STRING,
23503CURR TYPE STRING,
23503PREV TYPE STRING,
23503NAME TYPE STRING,
23504CURR TYPE STRING,
23504PREV TYPE STRING,
23504NAME TYPE STRING,
23505CURR TYPE STRING,
23505PREV TYPE STRING,
23505NAME TYPE STRING,
23506CURR TYPE STRING,
23506PREV TYPE STRING,
23506NAME TYPE STRING,
23507CURR TYPE STRING,
23507PREV TYPE STRING,
23507NAME TYPE STRING,
23508CURR TYPE STRING,
23508PREV TYPE STRING,
23508NAME TYPE STRING,
23509CURR TYPE STRING,
23509PREV TYPE STRING,
23509NAME TYPE STRING,
23510CURR TYPE STRING,
23510PREV TYPE STRING,
23510NAME TYPE STRING,
23511CURR TYPE STRING,
23511PREV TYPE STRING,
23511NAME TYPE STRING,
23512CURR TYPE STRING,
23512PREV TYPE STRING,
23512NAME TYPE STRING,
23513CURR TYPE STRING,
23513PREV TYPE STRING,
23513NAME TYPE STRING,
23514CURR TYPE STRING,
23514PREV TYPE STRING,
23514NAME TYPE STRING,
23515CURR TYPE STRING,
23515PREV TYPE STRING,
23515NAME TYPE STRING,
23516CURR TYPE STRING,
23516PREV TYPE STRING,
23516NAME TYPE STRING,
23517CURR TYPE STRING,
23517PREV TYPE STRING,
23517NAME TYPE STRING,
23518CURR TYPE STRING,
23518PREV TYPE STRING,
23518NAME TYPE STRING,
23519CURR TYPE STRING,
23519PREV TYPE STRING,
23519NAME TYPE STRING,
23520CURR TYPE STRING,
23520PREV TYPE STRING,
23520NAME TYPE STRING,
23501EXPL TYPE STRING,
23502EXPL TYPE STRING,
23503EXPL TYPE STRING,
23504EXPL TYPE STRING,
23505EXPL TYPE STRING,
23506EXPL TYPE STRING,
23507EXPL TYPE STRING,
23508EXPL TYPE STRING,
23509EXPL TYPE STRING,
23510EXPL TYPE STRING,
23511EXPL TYPE STRING,
23512EXPL TYPE STRING,
23513EXPL TYPE STRING,
23514EXPL TYPE STRING,
23515EXPL TYPE STRING,
23516EXPL TYPE STRING,
23517EXPL TYPE STRING,
23518EXPL TYPE STRING,
23519EXPL TYPE STRING,
23520EXPL TYPE STRING,END OF T_EKKO_STR.
DATA: WA_J_3RBS_LINE_2350_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_J_3RBS_LINE_2350_STR-23501CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23501PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23501NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23502CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23502PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23502NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23503CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23503PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23503NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23504CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23504PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23504NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23505CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23505PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23505NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23506CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23506PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23506NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23507CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23507PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23507NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23508CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23508PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23508NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23509CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23509PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23509NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23510CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23510PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23510NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23511CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23511PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23511NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23512CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23512PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23512NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23513CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23513PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23513NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23514CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23514PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23514NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23515CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23515PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23515NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23516CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23516PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23516NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23517CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23517PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23517NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23518CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23518PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23518NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23519CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23519PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23519NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23520CURR sy-vline 
WA_J_3RBS_LINE_2350_STR-23520PREV sy-vline 
WA_J_3RBS_LINE_2350_STR-23520NAME sy-vline 
WA_J_3RBS_LINE_2350_STR-23501EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23502EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23503EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23504EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23505EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23506EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23507EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23508EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23509EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23510EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23511EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23512EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23513EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23514EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23515EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23516EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23517EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23518EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23519EXPL sy-vline 
WA_J_3RBS_LINE_2350_STR-23520EXPL sy-vline      INTO ld_text SEPARATED BY SPACE.

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