ABAP Select data from SAP table RJPBMMH1 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 RJPBMMH1 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 RJPBMMH1. 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 RJPBMMH1 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_RJPBMMH1 TYPE STANDARD TABLE OF RJPBMMH1,
      WA_RJPBMMH1 TYPE RJPBMMH1,
      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: <RJPBMMH1> TYPE RJPBMMH1.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RJPBMMH1
*  INTO TABLE @DATA(IT_RJPBMMH12).
*--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_RJPBMMH1 INDEX 1 INTO DATA(WA_RJPBMMH12).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<RJPBMMH1>-ISMHIERARCHLEVL = 1.
<RJPBMMH1>-ISMISPCNROB = 1.
<RJPBMMH1>-ISMISPCNRTO = 1.
<RJPBMMH1>-ISMARTIST = 1.
<RJPBMMH1>-ISMTITLE = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RJPBMMH1-ISMSUBTITLE1, sy-vline,
  WA_RJPBMMH1-ISMSUBTITLE2, sy-vline,
  WA_RJPBMMH1-ISMSUBTITLE3, sy-vline,
  WA_RJPBMMH1-ISMDESCRMSD, sy-vline,
  WA_RJPBMMH1-ISMSTATISTICGRP, sy-vline,
  WA_RJPBMMH1-ISMREPORTGRP1, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_RJPBMMH1 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_RJPBMMH1 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_RJPBMMH1 INTO WA_RJPBMMH1.


*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.

*Conversion exit MATN1, internal->external for field ISMREFMDPRFAM
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMREFMDPRFAM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMREFMDPRFAM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field ISMREFMDPROD
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMREFMDPROD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMREFMDPROD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit JPPPT, internal->external for field ISMPUBLPERTYP
CALL FUNCTION 'CONVERSION_EXIT_JPPPT_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMPUBLPERTYP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMPUBLPERTYP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit JPICT, internal->external for field ISMORIDCDTYPE
CALL FUNCTION 'CONVERSION_EXIT_JPICT_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMORIDCDTYPE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMORIDCDTYPE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit JPPPT, internal->external for field ISMFRSTPBPERTYP
CALL FUNCTION 'CONVERSION_EXIT_JPPPT_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMFRSTPBPERTYP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMFRSTPBPERTYP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ISMAUDITRETTYPE
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMAUDITRETTYPE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMAUDITRETTYPE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ISMPERRULE
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMPERRULE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMPERRULE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ISMNRINYEAR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMNRINYEAR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMNRINYEAR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field ISMEXTENTUNIT
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMEXTENTUNIT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMEXTENTUNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field ISMNUMUNIT1
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMNUMUNIT1
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMNUMUNIT1.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field ISMNUMUNIT2
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMNUMUNIT2
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMNUMUNIT2.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field ISMPAPWTHUNIT
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMPAPWTHUNIT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMPAPWTHUNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ISMADINSERTNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMADINSERTNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMADINSERTNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ISMADINSERTIDNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMADINSERTIDNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMADINSERTIDNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ISMMPGNGRP
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMMPGNGRP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMMPGNGRP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit JPICT, internal->external for field ISMIDCODETYPE
CALL FUNCTION 'CONVERSION_EXIT_JPICT_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMIDCODETYPE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMIDCODETYPE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field ISMTITLEMASTER
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_RJPBMMH1-ISMTITLEMASTER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RJPBMMH1-ISMTITLEMASTER.
WRITE:/ 'New Value:', ld_input.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_RJPBMMH1_STR, 
ISMHIERARCHLEVL TYPE STRING,
ISMISPCNROB TYPE STRING,
ISMISPCNRTO TYPE STRING,
ISMARTIST TYPE STRING,
ISMTITLE TYPE STRING,
ISMSUBTITLE1 TYPE STRING,
ISMSUBTITLE2 TYPE STRING,
ISMSUBTITLE3 TYPE STRING,
ISMDESCRMSD TYPE STRING,
ISMSTATISTICGRP TYPE STRING,
ISMREPORTGRP1 TYPE STRING,
ISMREPORTGRP2 TYPE STRING,
ISMREFMDPRFAM TYPE STRING,
ISMREFMDPROD TYPE STRING,
ISMPUBLTYPE TYPE STRING,
ISMMEDIATYPE TYPE STRING,
ISMCONTTYPE TYPE STRING,
ISMPUBLDATE TYPE STRING,
ISMORGKEY TYPE STRING,
ISMIMPRINT TYPE STRING,
ISMRESPPLANER TYPE STRING,
ISMRESPPROD TYPE STRING,
ISMLANGUAGES TYPE STRING,
ISMPUBLPERIOD TYPE STRING,
ISMPUBLPERTYP TYPE STRING,
ISMEDITIONNUM TYPE STRING,
ISMEDITIONTYPE TYPE STRING,
ISMREPRINTNUM TYPE STRING,
ISMREPRINTTYPE TYPE STRING,
ISMRELEASE TYPE STRING,
ISMORPUBLISHER TYPE STRING,
ISMORIGTITLE TYPE STRING,
ISMORIDCODE TYPE STRING,
ISMORIDCDTYPE TYPE STRING,
ISMORIGLANG TYPE STRING,
ISMFRSTPUBLPER TYPE STRING,
ISMFRSTPBPERTYP TYPE STRING,
ISMFRSTPUBLDATE TYPE STRING,
ISMGROSSPRINTRUN TYPE STRING,
ISMAUDITRETNR TYPE STRING,
ISMAUDITRETTYPE TYPE STRING,
ISMXIGNAUDITSTAT TYPE STRING,
ISMCPREXCEP TYPE STRING,
ISMPERRULE TYPE STRING,
ISMNRINYEAR TYPE STRING,
ISMCOPYNR TYPE STRING,
ISMYEARNR TYPE STRING,
ISMISSUETYPEST TYPE STRING,
ISMISSUETYPEAC TYPE STRING,
ISMINITSHIPDATE TYPE STRING,
ISMDELIVTYPE TYPE STRING,
ISMXSUPPLYCOMM TYPE STRING,
ISMDESIGN TYPE STRING,
ISMEXTENT TYPE STRING,
ISMEXTENTUNIT TYPE STRING,
ISMFORMAT TYPE STRING,
ISMNUMBER1 TYPE STRING,
ISMNUMUNIT1 TYPE STRING,
ISMNUMBER2 TYPE STRING,
ISMNUMUNIT2 TYPE STRING,
ISMPAPWEIGHT TYPE STRING,
ISMPAPWTCOV TYPE STRING,
ISMPAPWTHUNIT TYPE STRING,
ISMNUMTYP1 TYPE STRING,
ISMNUMTYP2 TYPE STRING,
ISMADINSERTNR TYPE STRING,
ISMADINSERTTYPE TYPE STRING,
ISMWASTEDISPREQU TYPE STRING,
ISMTIEINAD TYPE STRING,
ISMADINSERTIDNR TYPE STRING,
ISMXINDIVSPEC TYPE STRING,
ISMPOSTALFORMAT TYPE STRING,
ISMBASICYEAR TYPE STRING,
ISMFKALID TYPE STRING,
ISMMPGNGRP TYPE STRING,
ISMAVAILDATE TYPE STRING,
ISMAVAILTIME TYPE STRING,
ISMARRIVALDATEPL TYPE STRING,
ISMARRIVALTIMEPL TYPE STRING,
ISMARRIVALDATEAC TYPE STRING,
ISMARRIVALTIMEAC TYPE STRING,
ISMSTORAGE TYPE STRING,
ISMXAVAILORDER TYPE STRING,
ISMMATRETURN TYPE STRING,
ISMRETURNBEGIN TYPE STRING,
ISMRETURNEND TYPE STRING,
ISMIDCODETYPE TYPE STRING,
ISMIDENTCODE TYPE STRING,
ISMTITLEMASTER TYPE STRING,
ISMINTERRUPTDATE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_RJPBMMH1_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_RJPBMMH1_STR-ISMHIERARCHLEVL sy-vline 
WA_RJPBMMH1_STR-ISMISPCNROB sy-vline 
WA_RJPBMMH1_STR-ISMISPCNRTO sy-vline 
WA_RJPBMMH1_STR-ISMARTIST sy-vline 
WA_RJPBMMH1_STR-ISMTITLE sy-vline 
WA_RJPBMMH1_STR-ISMSUBTITLE1 sy-vline 
WA_RJPBMMH1_STR-ISMSUBTITLE2 sy-vline 
WA_RJPBMMH1_STR-ISMSUBTITLE3 sy-vline 
WA_RJPBMMH1_STR-ISMDESCRMSD sy-vline 
WA_RJPBMMH1_STR-ISMSTATISTICGRP sy-vline 
WA_RJPBMMH1_STR-ISMREPORTGRP1 sy-vline 
WA_RJPBMMH1_STR-ISMREPORTGRP2 sy-vline 
WA_RJPBMMH1_STR-ISMREFMDPRFAM sy-vline 
WA_RJPBMMH1_STR-ISMREFMDPROD sy-vline 
WA_RJPBMMH1_STR-ISMPUBLTYPE sy-vline 
WA_RJPBMMH1_STR-ISMMEDIATYPE sy-vline 
WA_RJPBMMH1_STR-ISMCONTTYPE sy-vline 
WA_RJPBMMH1_STR-ISMPUBLDATE sy-vline 
WA_RJPBMMH1_STR-ISMORGKEY sy-vline 
WA_RJPBMMH1_STR-ISMIMPRINT sy-vline 
WA_RJPBMMH1_STR-ISMRESPPLANER sy-vline 
WA_RJPBMMH1_STR-ISMRESPPROD sy-vline 
WA_RJPBMMH1_STR-ISMLANGUAGES sy-vline 
WA_RJPBMMH1_STR-ISMPUBLPERIOD sy-vline 
WA_RJPBMMH1_STR-ISMPUBLPERTYP sy-vline 
WA_RJPBMMH1_STR-ISMEDITIONNUM sy-vline 
WA_RJPBMMH1_STR-ISMEDITIONTYPE sy-vline 
WA_RJPBMMH1_STR-ISMREPRINTNUM sy-vline 
WA_RJPBMMH1_STR-ISMREPRINTTYPE sy-vline 
WA_RJPBMMH1_STR-ISMRELEASE sy-vline 
WA_RJPBMMH1_STR-ISMORPUBLISHER sy-vline 
WA_RJPBMMH1_STR-ISMORIGTITLE sy-vline 
WA_RJPBMMH1_STR-ISMORIDCODE sy-vline 
WA_RJPBMMH1_STR-ISMORIDCDTYPE sy-vline 
WA_RJPBMMH1_STR-ISMORIGLANG sy-vline 
WA_RJPBMMH1_STR-ISMFRSTPUBLPER sy-vline 
WA_RJPBMMH1_STR-ISMFRSTPBPERTYP sy-vline 
WA_RJPBMMH1_STR-ISMFRSTPUBLDATE sy-vline 
WA_RJPBMMH1_STR-ISMGROSSPRINTRUN sy-vline 
WA_RJPBMMH1_STR-ISMAUDITRETNR sy-vline 
WA_RJPBMMH1_STR-ISMAUDITRETTYPE sy-vline 
WA_RJPBMMH1_STR-ISMXIGNAUDITSTAT sy-vline 
WA_RJPBMMH1_STR-ISMCPREXCEP sy-vline 
WA_RJPBMMH1_STR-ISMPERRULE sy-vline 
WA_RJPBMMH1_STR-ISMNRINYEAR sy-vline 
WA_RJPBMMH1_STR-ISMCOPYNR sy-vline 
WA_RJPBMMH1_STR-ISMYEARNR sy-vline 
WA_RJPBMMH1_STR-ISMISSUETYPEST sy-vline 
WA_RJPBMMH1_STR-ISMISSUETYPEAC sy-vline 
WA_RJPBMMH1_STR-ISMINITSHIPDATE sy-vline 
WA_RJPBMMH1_STR-ISMDELIVTYPE sy-vline 
WA_RJPBMMH1_STR-ISMXSUPPLYCOMM sy-vline 
WA_RJPBMMH1_STR-ISMDESIGN sy-vline 
WA_RJPBMMH1_STR-ISMEXTENT sy-vline 
WA_RJPBMMH1_STR-ISMEXTENTUNIT sy-vline 
WA_RJPBMMH1_STR-ISMFORMAT sy-vline 
WA_RJPBMMH1_STR-ISMNUMBER1 sy-vline 
WA_RJPBMMH1_STR-ISMNUMUNIT1 sy-vline 
WA_RJPBMMH1_STR-ISMNUMBER2 sy-vline 
WA_RJPBMMH1_STR-ISMNUMUNIT2 sy-vline 
WA_RJPBMMH1_STR-ISMPAPWEIGHT sy-vline 
WA_RJPBMMH1_STR-ISMPAPWTCOV sy-vline 
WA_RJPBMMH1_STR-ISMPAPWTHUNIT sy-vline 
WA_RJPBMMH1_STR-ISMNUMTYP1 sy-vline 
WA_RJPBMMH1_STR-ISMNUMTYP2 sy-vline 
WA_RJPBMMH1_STR-ISMADINSERTNR sy-vline 
WA_RJPBMMH1_STR-ISMADINSERTTYPE sy-vline 
WA_RJPBMMH1_STR-ISMWASTEDISPREQU sy-vline 
WA_RJPBMMH1_STR-ISMTIEINAD sy-vline 
WA_RJPBMMH1_STR-ISMADINSERTIDNR sy-vline 
WA_RJPBMMH1_STR-ISMXINDIVSPEC sy-vline 
WA_RJPBMMH1_STR-ISMPOSTALFORMAT sy-vline 
WA_RJPBMMH1_STR-ISMBASICYEAR sy-vline 
WA_RJPBMMH1_STR-ISMFKALID sy-vline 
WA_RJPBMMH1_STR-ISMMPGNGRP sy-vline 
WA_RJPBMMH1_STR-ISMAVAILDATE sy-vline 
WA_RJPBMMH1_STR-ISMAVAILTIME sy-vline 
WA_RJPBMMH1_STR-ISMARRIVALDATEPL sy-vline 
WA_RJPBMMH1_STR-ISMARRIVALTIMEPL sy-vline 
WA_RJPBMMH1_STR-ISMARRIVALDATEAC sy-vline 
WA_RJPBMMH1_STR-ISMARRIVALTIMEAC sy-vline 
WA_RJPBMMH1_STR-ISMSTORAGE sy-vline 
WA_RJPBMMH1_STR-ISMXAVAILORDER sy-vline 
WA_RJPBMMH1_STR-ISMMATRETURN sy-vline 
WA_RJPBMMH1_STR-ISMRETURNBEGIN sy-vline 
WA_RJPBMMH1_STR-ISMRETURNEND sy-vline 
WA_RJPBMMH1_STR-ISMIDCODETYPE sy-vline 
WA_RJPBMMH1_STR-ISMIDENTCODE sy-vline 
WA_RJPBMMH1_STR-ISMTITLEMASTER sy-vline 
WA_RJPBMMH1_STR-ISMINTERRUPTDATE sy-vline      INTO ld_text SEPARATED BY SPACE.

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