ABAP Select data from SAP table RN2OPCD 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 RN2OPCD 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 RN2OPCD. 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 RN2OPCD 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_RN2OPCD TYPE STANDARD TABLE OF RN2OPCD,
      WA_RN2OPCD TYPE RN2OPCD,
      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: <RN2OPCD> TYPE RN2OPCD.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RN2OPCD
*  INTO TABLE @DATA(IT_RN2OPCD2).
*--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_RN2OPCD INDEX 1 INTO DATA(WA_RN2OPCD2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_RN2OPCD ASSIGNING <RN2OPCD>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<RN2OPCD>-MANDT = 1.
<RN2OPCD>-EINRI = 1.
<RN2OPCD>-FALNR = 1.
<RN2OPCD>-FALAR = 1.
<RN2OPCD>-PNAME = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RN2OPCD-GBDAT, sy-vline,
WA_RN2OPCD-ALTERP, sy-vline,
WA_RN2OPCD-ALTEINH, sy-vline,
WA_RN2OPCD-GSCHLE, sy-vline,
WA_RN2OPCD-OPDAT, sy-vline,
WA_RN2OPCD-OPNR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_RN2OPCD 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_RN2OPCD 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_RN2OPCD INTO WA_RN2OPCD. *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 ALPHA, internal->external for field EINRI CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RN2OPCD-EINRI IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RN2OPCD-EINRI.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field PR_ENTGA CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RN2OPCD-PR_ENTGA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RN2OPCD-PR_ENTGA.
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_RN2OPCD_STR,
MANDT TYPE STRING,
EINRI TYPE STRING,
FALNR TYPE STRING,
FALAR TYPE STRING,
PNAME TYPE STRING,
GBDAT TYPE STRING,
ALTERP TYPE STRING,
ALTEINH TYPE STRING,
GSCHLE TYPE STRING,
OPDAT TYPE STRING,
OPNR TYPE STRING,
ANFOE TYPE STRING,
ANPOE TYPE STRING,
ERBOE TYPE STRING,
ERBOE1 TYPE STRING,
OPINFO1 TYPE STRING,
OPINFO2 TYPE STRING,
DKAT TYPE STRING,
DKEY TYPE STRING,
DKAT1 TYPE STRING,
DKEY1 TYPE STRING,
HDIA TYPE STRING,
DITXT TYPE STRING,
DITXT1 TYPE STRING,
DILTX TYPE STRING,
DILTX1 TYPE STRING,
DIALO TYPE STRING,
DIALO1 TYPE STRING,
DIAGW TYPE STRING,
DIAGW1 TYPE STRING,
DIAZS TYPE STRING,
DIAZS1 TYPE STRING,
DTYP TYPE STRING,
DTYP1 TYPE STRING,
DLGTX TYPE STRING,
ZUOPR TYPE STRING,
DLGTX1 TYPE STRING,
DIA_DRG_SEQNO TYPE STRING,
DIA_DRG_SEQNO1 TYPE STRING,
DIA_DRG_CAT TYPE STRING,
DIA_DRG_CAT1 TYPE STRING,
DIA_DRG_CC TYPE STRING,
DIA_DRG_CC1 TYPE STRING,
DIA_DRG_REL TYPE STRING,
DIA_DRG_REL1 TYPE STRING,
DIA_CCL TYPE STRING,
DIA_CCL1 TYPE STRING,
ICD10_INFO TYPE STRING,
DIA_ANZOP TYPE STRING,
ICPML TYPE STRING,
IDENT TYPE STRING,
LSLOK TYPE STRING,
LSLOK1 TYPE STRING,
ICPMK TYPE STRING,
ICPMK1 TYPE STRING,
ICPML1 TYPE STRING,
HAUST TYPE STRING,
LEIST TYPE STRING,
LEIST1 TYPE STRING,
LEITX TYPE STRING,
LEITX1 TYPE STRING,
PRTXT TYPE STRING,
PRTXT1 TYPE STRING,
PRLTX TYPE STRING,
PRLTX1 TYPE STRING,
PLGTX TYPE STRING,
PLGTX1 TYPE STRING,
LSSTAE TYPE STRING,
LSSTAE1 TYPE STRING,
ICPHC TYPE STRING,
ANZOP TYPE STRING,
PR_DRG_SEQNO TYPE STRING,
PR_DRG_SEQNO1 TYPE STRING,
PR_DRG_CAT TYPE STRING,
PR_DRG_CAT1 TYPE STRING,
PR_DRG_REL TYPE STRING,
PR_DRG_REL1 TYPE STRING,
ZUODIA TYPE STRING,
ZUOFPSE TYPE STRING,
GPART TYPE STRING,
NAME TYPE STRING,
VORNAME TYPE STRING,
GESNAME TYPE STRING,
TLGTX TYPE STRING,
AUFGABE TYPE STRING,
TEXT TYPE STRING,
BEGDT TYPE STRING,
ENDDT TYPE STRING,
BEGZT TYPE STRING,
ENDZT TYPE STRING,
ZUOOPL TYPE STRING,
AVBNA TYPE STRING,
AVBS TYPE STRING,
AVBZP TYPE STRING,
AVBTEXT TYPE STRING,
AVBD TYPE STRING,
AVBU TYPE STRING,
ICDKY TYPE STRING,
MARK1 TYPE STRING,
MARK2 TYPE STRING,
MARK3 TYPE STRING,
PR_ICPML_REF TYPE STRING,
PR_ENTGA TYPE STRING,
PR_OPLEBSPEN TYPE STRING,END OF T_EKKO_STR. DATA: WA_RN2OPCD_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_RN2OPCD_STR-MANDT sy-vline
WA_RN2OPCD_STR-EINRI sy-vline
WA_RN2OPCD_STR-FALNR sy-vline
WA_RN2OPCD_STR-FALAR sy-vline
WA_RN2OPCD_STR-PNAME sy-vline
WA_RN2OPCD_STR-GBDAT sy-vline
WA_RN2OPCD_STR-ALTERP sy-vline
WA_RN2OPCD_STR-ALTEINH sy-vline
WA_RN2OPCD_STR-GSCHLE sy-vline
WA_RN2OPCD_STR-OPDAT sy-vline
WA_RN2OPCD_STR-OPNR sy-vline
WA_RN2OPCD_STR-ANFOE sy-vline
WA_RN2OPCD_STR-ANPOE sy-vline
WA_RN2OPCD_STR-ERBOE sy-vline
WA_RN2OPCD_STR-ERBOE1 sy-vline
WA_RN2OPCD_STR-OPINFO1 sy-vline
WA_RN2OPCD_STR-OPINFO2 sy-vline
WA_RN2OPCD_STR-DKAT sy-vline
WA_RN2OPCD_STR-DKEY sy-vline
WA_RN2OPCD_STR-DKAT1 sy-vline
WA_RN2OPCD_STR-DKEY1 sy-vline
WA_RN2OPCD_STR-HDIA sy-vline
WA_RN2OPCD_STR-DITXT sy-vline
WA_RN2OPCD_STR-DITXT1 sy-vline
WA_RN2OPCD_STR-DILTX sy-vline
WA_RN2OPCD_STR-DILTX1 sy-vline
WA_RN2OPCD_STR-DIALO sy-vline
WA_RN2OPCD_STR-DIALO1 sy-vline
WA_RN2OPCD_STR-DIAGW sy-vline
WA_RN2OPCD_STR-DIAGW1 sy-vline
WA_RN2OPCD_STR-DIAZS sy-vline
WA_RN2OPCD_STR-DIAZS1 sy-vline
WA_RN2OPCD_STR-DTYP sy-vline
WA_RN2OPCD_STR-DTYP1 sy-vline
WA_RN2OPCD_STR-DLGTX sy-vline
WA_RN2OPCD_STR-ZUOPR sy-vline
WA_RN2OPCD_STR-DLGTX1 sy-vline
WA_RN2OPCD_STR-DIA_DRG_SEQNO sy-vline
WA_RN2OPCD_STR-DIA_DRG_SEQNO1 sy-vline
WA_RN2OPCD_STR-DIA_DRG_CAT sy-vline
WA_RN2OPCD_STR-DIA_DRG_CAT1 sy-vline
WA_RN2OPCD_STR-DIA_DRG_CC sy-vline
WA_RN2OPCD_STR-DIA_DRG_CC1 sy-vline
WA_RN2OPCD_STR-DIA_DRG_REL sy-vline
WA_RN2OPCD_STR-DIA_DRG_REL1 sy-vline
WA_RN2OPCD_STR-DIA_CCL sy-vline
WA_RN2OPCD_STR-DIA_CCL1 sy-vline
WA_RN2OPCD_STR-ICD10_INFO sy-vline
WA_RN2OPCD_STR-DIA_ANZOP sy-vline
WA_RN2OPCD_STR-ICPML sy-vline
WA_RN2OPCD_STR-IDENT sy-vline
WA_RN2OPCD_STR-LSLOK sy-vline
WA_RN2OPCD_STR-LSLOK1 sy-vline
WA_RN2OPCD_STR-ICPMK sy-vline
WA_RN2OPCD_STR-ICPMK1 sy-vline
WA_RN2OPCD_STR-ICPML1 sy-vline
WA_RN2OPCD_STR-HAUST sy-vline
WA_RN2OPCD_STR-LEIST sy-vline
WA_RN2OPCD_STR-LEIST1 sy-vline
WA_RN2OPCD_STR-LEITX sy-vline
WA_RN2OPCD_STR-LEITX1 sy-vline
WA_RN2OPCD_STR-PRTXT sy-vline
WA_RN2OPCD_STR-PRTXT1 sy-vline
WA_RN2OPCD_STR-PRLTX sy-vline
WA_RN2OPCD_STR-PRLTX1 sy-vline
WA_RN2OPCD_STR-PLGTX sy-vline
WA_RN2OPCD_STR-PLGTX1 sy-vline
WA_RN2OPCD_STR-LSSTAE sy-vline
WA_RN2OPCD_STR-LSSTAE1 sy-vline
WA_RN2OPCD_STR-ICPHC sy-vline
WA_RN2OPCD_STR-ANZOP sy-vline
WA_RN2OPCD_STR-PR_DRG_SEQNO sy-vline
WA_RN2OPCD_STR-PR_DRG_SEQNO1 sy-vline
WA_RN2OPCD_STR-PR_DRG_CAT sy-vline
WA_RN2OPCD_STR-PR_DRG_CAT1 sy-vline
WA_RN2OPCD_STR-PR_DRG_REL sy-vline
WA_RN2OPCD_STR-PR_DRG_REL1 sy-vline
WA_RN2OPCD_STR-ZUODIA sy-vline
WA_RN2OPCD_STR-ZUOFPSE sy-vline
WA_RN2OPCD_STR-GPART sy-vline
WA_RN2OPCD_STR-NAME sy-vline
WA_RN2OPCD_STR-VORNAME sy-vline
WA_RN2OPCD_STR-GESNAME sy-vline
WA_RN2OPCD_STR-TLGTX sy-vline
WA_RN2OPCD_STR-AUFGABE sy-vline
WA_RN2OPCD_STR-TEXT sy-vline
WA_RN2OPCD_STR-BEGDT sy-vline
WA_RN2OPCD_STR-ENDDT sy-vline
WA_RN2OPCD_STR-BEGZT sy-vline
WA_RN2OPCD_STR-ENDZT sy-vline
WA_RN2OPCD_STR-ZUOOPL sy-vline
WA_RN2OPCD_STR-AVBNA sy-vline
WA_RN2OPCD_STR-AVBS sy-vline
WA_RN2OPCD_STR-AVBZP sy-vline
WA_RN2OPCD_STR-AVBTEXT sy-vline
WA_RN2OPCD_STR-AVBD sy-vline
WA_RN2OPCD_STR-AVBU sy-vline
WA_RN2OPCD_STR-ICDKY sy-vline
WA_RN2OPCD_STR-MARK1 sy-vline
WA_RN2OPCD_STR-MARK2 sy-vline
WA_RN2OPCD_STR-MARK3 sy-vline
WA_RN2OPCD_STR-PR_ICPML_REF sy-vline
WA_RN2OPCD_STR-PR_ENTGA sy-vline
WA_RN2OPCD_STR-PR_OPLEBSPEN sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.