ABAP Select data from SAP table J_3RBS_LINE_1430 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_1430 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_1430. 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_1430 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_1430 TYPE STANDARD TABLE OF J_3RBS_LINE_1430,
      WA_J_3RBS_LINE_1430 TYPE J_3RBS_LINE_1430,
      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_1430> TYPE J_3RBS_LINE_1430.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM J_3RBS_LINE_1430
*  INTO TABLE @DATA(IT_J_3RBS_LINE_14302).
*--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_1430 INDEX 1 INTO DATA(WA_J_3RBS_LINE_14302).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<J_3RBS_LINE_1430>-14301BEG = 1.
<J_3RBS_LINE_1430>-14301END = 1.
<J_3RBS_LINE_1430>-14301BPY = 1.
<J_3RBS_LINE_1430>-14301NAME = 1.
<J_3RBS_LINE_1430>-14302BEG = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_J_3RBS_LINE_1430-14302END, sy-vline,
  WA_J_3RBS_LINE_1430-14302BPY, sy-vline,
  WA_J_3RBS_LINE_1430-14302NAME, sy-vline,
  WA_J_3RBS_LINE_1430-14303BEG, sy-vline,
  WA_J_3RBS_LINE_1430-14303END, sy-vline,
  WA_J_3RBS_LINE_1430-14303BPY, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_J_3RBS_LINE_1430 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_1430 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_1430 INTO WA_J_3RBS_LINE_1430.


*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_1430_STR, 
14301BEG TYPE STRING,
14301END TYPE STRING,
14301BPY TYPE STRING,
14301NAME TYPE STRING,
14302BEG TYPE STRING,
14302END TYPE STRING,
14302BPY TYPE STRING,
14302NAME TYPE STRING,
14303BEG TYPE STRING,
14303END TYPE STRING,
14303BPY TYPE STRING,
14303NAME TYPE STRING,
14304BEG TYPE STRING,
14304END TYPE STRING,
14304BPY TYPE STRING,
14304NAME TYPE STRING,
14305BEG TYPE STRING,
14305END TYPE STRING,
14305BPY TYPE STRING,
14305NAME TYPE STRING,
14306BEG TYPE STRING,
14306END TYPE STRING,
14306BPY TYPE STRING,
14306NAME TYPE STRING,
14307BEG TYPE STRING,
14307END TYPE STRING,
14307BPY TYPE STRING,
14307NAME TYPE STRING,
14308BEG TYPE STRING,
14308END TYPE STRING,
14308BPY TYPE STRING,
14308NAME TYPE STRING,
14309BEG TYPE STRING,
14309END TYPE STRING,
14309BPY TYPE STRING,
14309NAME TYPE STRING,
14310BEG TYPE STRING,
14310END TYPE STRING,
14310BPY TYPE STRING,
14310NAME TYPE STRING,
14311BEG TYPE STRING,
14311END TYPE STRING,
14311BPY TYPE STRING,
14311NAME TYPE STRING,
14312BEG TYPE STRING,
14312END TYPE STRING,
14312BPY TYPE STRING,
14312NAME TYPE STRING,
14313BEG TYPE STRING,
14313END TYPE STRING,
14313BPY TYPE STRING,
14313NAME TYPE STRING,
14314BEG TYPE STRING,
14314END TYPE STRING,
14314BPY TYPE STRING,
14314NAME TYPE STRING,
14315BEG TYPE STRING,
14315END TYPE STRING,
14315BPY TYPE STRING,
14315NAME TYPE STRING,
14316BEG TYPE STRING,
14316END TYPE STRING,
14316BPY TYPE STRING,
14316NAME TYPE STRING,
14317BEG TYPE STRING,
14317END TYPE STRING,
14317BPY TYPE STRING,
14317NAME TYPE STRING,
14318BEG TYPE STRING,
14318END TYPE STRING,
14318BPY TYPE STRING,
14318NAME TYPE STRING,
14319BEG TYPE STRING,
14319END TYPE STRING,
14319BPY TYPE STRING,
14319NAME TYPE STRING,
14320BEG TYPE STRING,
14320END TYPE STRING,
14320BPY TYPE STRING,
14320NAME TYPE STRING,
WAERS TYPE STRING,
14301EXPL TYPE STRING,
14302EXPL TYPE STRING,
14303EXPL TYPE STRING,
14304EXPL TYPE STRING,
14305EXPL TYPE STRING,
14306EXPL TYPE STRING,
14307EXPL TYPE STRING,
14308EXPL TYPE STRING,
14309EXPL TYPE STRING,
14310EXPL TYPE STRING,
14311EXPL TYPE STRING,
14312EXPL TYPE STRING,
14313EXPL TYPE STRING,
14314EXPL TYPE STRING,
14315EXPL TYPE STRING,
14316EXPL TYPE STRING,
14317EXPL TYPE STRING,
14318EXPL TYPE STRING,
14319EXPL TYPE STRING,
14320EXPL TYPE STRING,END OF T_EKKO_STR.
DATA: WA_J_3RBS_LINE_1430_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_1430_STR-14301BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14301END sy-vline 
WA_J_3RBS_LINE_1430_STR-14301BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14301NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14302BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14302END sy-vline 
WA_J_3RBS_LINE_1430_STR-14302BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14302NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14303BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14303END sy-vline 
WA_J_3RBS_LINE_1430_STR-14303BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14303NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14304BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14304END sy-vline 
WA_J_3RBS_LINE_1430_STR-14304BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14304NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14305BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14305END sy-vline 
WA_J_3RBS_LINE_1430_STR-14305BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14305NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14306BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14306END sy-vline 
WA_J_3RBS_LINE_1430_STR-14306BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14306NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14307BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14307END sy-vline 
WA_J_3RBS_LINE_1430_STR-14307BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14307NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14308BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14308END sy-vline 
WA_J_3RBS_LINE_1430_STR-14308BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14308NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14309BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14309END sy-vline 
WA_J_3RBS_LINE_1430_STR-14309BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14309NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14310BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14310END sy-vline 
WA_J_3RBS_LINE_1430_STR-14310BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14310NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14311BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14311END sy-vline 
WA_J_3RBS_LINE_1430_STR-14311BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14311NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14312BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14312END sy-vline 
WA_J_3RBS_LINE_1430_STR-14312BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14312NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14313BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14313END sy-vline 
WA_J_3RBS_LINE_1430_STR-14313BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14313NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14314BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14314END sy-vline 
WA_J_3RBS_LINE_1430_STR-14314BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14314NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14315BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14315END sy-vline 
WA_J_3RBS_LINE_1430_STR-14315BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14315NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14316BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14316END sy-vline 
WA_J_3RBS_LINE_1430_STR-14316BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14316NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14317BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14317END sy-vline 
WA_J_3RBS_LINE_1430_STR-14317BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14317NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14318BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14318END sy-vline 
WA_J_3RBS_LINE_1430_STR-14318BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14318NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14319BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14319END sy-vline 
WA_J_3RBS_LINE_1430_STR-14319BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14319NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-14320BEG sy-vline 
WA_J_3RBS_LINE_1430_STR-14320END sy-vline 
WA_J_3RBS_LINE_1430_STR-14320BPY sy-vline 
WA_J_3RBS_LINE_1430_STR-14320NAME sy-vline 
WA_J_3RBS_LINE_1430_STR-WAERS sy-vline 
WA_J_3RBS_LINE_1430_STR-14301EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14302EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14303EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14304EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14305EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14306EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14307EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14308EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14309EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14310EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14311EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14312EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14313EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14314EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14315EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14316EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14317EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14318EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14319EXPL sy-vline 
WA_J_3RBS_LINE_1430_STR-14320EXPL sy-vline      INTO ld_text SEPARATED BY SPACE.

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