ABAP Select data from SAP table RNPAT_VNTMN 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 RNPAT_VNTMN 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 RNPAT_VNTMN. 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 RNPAT_VNTMN 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_RNPAT_VNTMN TYPE STANDARD TABLE OF RNPAT_VNTMN,
      WA_RNPAT_VNTMN TYPE RNPAT_VNTMN,
      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: <RNPAT_VNTMN> TYPE RNPAT_VNTMN.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RNPAT_VNTMN
*  INTO TABLE @DATA(IT_RNPAT_VNTMN2).
*--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_RNPAT_VNTMN INDEX 1 INTO DATA(WA_RNPAT_VNTMN2).


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

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RNPAT_VNTMN-FZIFF, sy-vline,
WA_RNPAT_VNTMN-FALAR, sy-vline,
WA_RNPAT_VNTMN-TMNLB, sy-vline,
WA_RNPAT_VNTMN-TMNOE, sy-vline,
WA_RNPAT_VNTMN-TMNDT, sy-vline,
WA_RNPAT_VNTMN-TMNZT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_RNPAT_VNTMN 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_RNPAT_VNTMN 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_RNPAT_VNTMN INTO WA_RNPAT_VNTMN. *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 TMNID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RNPAT_VNTMN-TMNID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RNPAT_VNTMN-TMNID.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit SXIDN, internal->external for field EMAIL CALL FUNCTION 'CONVERSION_EXIT_SXIDN_OUTPUT' EXPORTING input = WA_RNPAT_VNTMN-EMAIL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RNPAT_VNTMN-EMAIL.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field ADRNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RNPAT_VNTMN-ADRNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RNPAT_VNTMN-ADRNR.
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_RNPAT_VNTMN_STR,
MANDT TYPE STRING,
TMNID TYPE STRING,
EINRI TYPE STRING,
PATNR TYPE STRING,
FALNR TYPE STRING,
FZIFF TYPE STRING,
FALAR TYPE STRING,
TMNLB TYPE STRING,
TMNOE TYPE STRING,
TMNDT TYPE STRING,
TMNZT TYPE STRING,
TMNDR TYPE STRING,
TELF1 TYPE STRING,
SOURC TYPE STRING,
TMTAG TYPE STRING,
REFID TYPE STRING,
NOTAN TYPE STRING,
KRZAN TYPE STRING,
BEKAT TYPE STRING,
CLASS TYPE STRING,
BNKZ TYPE STRING,
BNDT TYPE STRING,
BNART TYPE STRING,
EINBDT TYPE STRING,
EINBZT TYPE STRING,
EINBOE TYPE STRING,
EINBPER TYPE STRING,
EINBZIM TYPE STRING,
BWART TYPE STRING,
TPART TYPE STRING,
BWPRIO TYPE STRING,
MEDTX TYPE STRING,
TMSTG TYPE STRING,
STORN TYPE STRING,
STUSR TYPE STRING,
STDAT TYPE STRING,
VBUND TYPE STRING,
BWGR1 TYPE STRING,
BWGR2 TYPE STRING,
UARNR TYPE STRING,
TMPDT TYPE STRING,
TMPZT TYPE STRING,
GPLVN TYPE STRING,
GPLTY TYPE STRING,
EMAIL TYPE STRING,
BEWTY TYPE STRING,
CHAINID TYPE STRING,
UNITID TYPE STRING,
DISTMIN TYPE STRING,
DISTMAX TYPE STRING,
DISTUNIT TYPE STRING,
CYCLE TYPE STRING,
CYCLEUNIT TYPE STRING,
VKGID TYPE STRING,
PAPID TYPE STRING,
APCNID TYPE STRING,
ENDPL TYPE STRING,
LNRAPP TYPE STRING,
LFDNR TYPE STRING,
DSPTY TYPE STRING,
VISTY TYPE STRING,
BWIDT TYPE STRING,
BWIZT TYPE STRING,
STATU TYPE STRING,
ORGFA TYPE STRING,
ORGPF TYPE STRING,
POBNR TYPE STRING,
PERNR TYPE STRING,
ZIMMR TYPE STRING,
KZTXT TYPE STRING,
ERDAT TYPE STRING,
ERUSR TYPE STRING,
UPDAT TYPE STRING,
UPUSR TYPE STRING,
LGTXT TYPE STRING,
DAUER TYPE STRING,
FACHR TYPE STRING,
PELOC TYPE STRING,
STOID TYPE STRING,
PTINP TYPE STRING,
GSCHL TYPE STRING,
NNAME TYPE STRING,
NNAMS TYPE STRING,
VNAME TYPE STRING,
VNAMS TYPE STRING,
TITEL TYPE STRING,
NAMZU TYPE STRING,
VORSW TYPE STRING,
NAME2 TYPE STRING,
GBDAT TYPE STRING,
GBNAM TYPE STRING,
GBNAS TYPE STRING,
TODKZ TYPE STRING,
VIPKZ TYPE STRING,
RISKF TYPE STRING,
PZIFF TYPE STRING,
ADRNR TYPE STRING,
ADROB TYPE STRING,END OF T_EKKO_STR. DATA: WA_RNPAT_VNTMN_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_RNPAT_VNTMN_STR-MANDT sy-vline
WA_RNPAT_VNTMN_STR-TMNID sy-vline
WA_RNPAT_VNTMN_STR-EINRI sy-vline
WA_RNPAT_VNTMN_STR-PATNR sy-vline
WA_RNPAT_VNTMN_STR-FALNR sy-vline
WA_RNPAT_VNTMN_STR-FZIFF sy-vline
WA_RNPAT_VNTMN_STR-FALAR sy-vline
WA_RNPAT_VNTMN_STR-TMNLB sy-vline
WA_RNPAT_VNTMN_STR-TMNOE sy-vline
WA_RNPAT_VNTMN_STR-TMNDT sy-vline
WA_RNPAT_VNTMN_STR-TMNZT sy-vline
WA_RNPAT_VNTMN_STR-TMNDR sy-vline
WA_RNPAT_VNTMN_STR-TELF1 sy-vline
WA_RNPAT_VNTMN_STR-SOURC sy-vline
WA_RNPAT_VNTMN_STR-TMTAG sy-vline
WA_RNPAT_VNTMN_STR-REFID sy-vline
WA_RNPAT_VNTMN_STR-NOTAN sy-vline
WA_RNPAT_VNTMN_STR-KRZAN sy-vline
WA_RNPAT_VNTMN_STR-BEKAT sy-vline
WA_RNPAT_VNTMN_STR-CLASS sy-vline
WA_RNPAT_VNTMN_STR-BNKZ sy-vline
WA_RNPAT_VNTMN_STR-BNDT sy-vline
WA_RNPAT_VNTMN_STR-BNART sy-vline
WA_RNPAT_VNTMN_STR-EINBDT sy-vline
WA_RNPAT_VNTMN_STR-EINBZT sy-vline
WA_RNPAT_VNTMN_STR-EINBOE sy-vline
WA_RNPAT_VNTMN_STR-EINBPER sy-vline
WA_RNPAT_VNTMN_STR-EINBZIM sy-vline
WA_RNPAT_VNTMN_STR-BWART sy-vline
WA_RNPAT_VNTMN_STR-TPART sy-vline
WA_RNPAT_VNTMN_STR-BWPRIO sy-vline
WA_RNPAT_VNTMN_STR-MEDTX sy-vline
WA_RNPAT_VNTMN_STR-TMSTG sy-vline
WA_RNPAT_VNTMN_STR-STORN sy-vline
WA_RNPAT_VNTMN_STR-STUSR sy-vline
WA_RNPAT_VNTMN_STR-STDAT sy-vline
WA_RNPAT_VNTMN_STR-VBUND sy-vline
WA_RNPAT_VNTMN_STR-BWGR1 sy-vline
WA_RNPAT_VNTMN_STR-BWGR2 sy-vline
WA_RNPAT_VNTMN_STR-UARNR sy-vline
WA_RNPAT_VNTMN_STR-TMPDT sy-vline
WA_RNPAT_VNTMN_STR-TMPZT sy-vline
WA_RNPAT_VNTMN_STR-GPLVN sy-vline
WA_RNPAT_VNTMN_STR-GPLTY sy-vline
WA_RNPAT_VNTMN_STR-EMAIL sy-vline
WA_RNPAT_VNTMN_STR-BEWTY sy-vline
WA_RNPAT_VNTMN_STR-CHAINID sy-vline
WA_RNPAT_VNTMN_STR-UNITID sy-vline
WA_RNPAT_VNTMN_STR-DISTMIN sy-vline
WA_RNPAT_VNTMN_STR-DISTMAX sy-vline
WA_RNPAT_VNTMN_STR-DISTUNIT sy-vline
WA_RNPAT_VNTMN_STR-CYCLE sy-vline
WA_RNPAT_VNTMN_STR-CYCLEUNIT sy-vline
WA_RNPAT_VNTMN_STR-VKGID sy-vline
WA_RNPAT_VNTMN_STR-PAPID sy-vline
WA_RNPAT_VNTMN_STR-APCNID sy-vline
WA_RNPAT_VNTMN_STR-ENDPL sy-vline
WA_RNPAT_VNTMN_STR-LNRAPP sy-vline
WA_RNPAT_VNTMN_STR-LFDNR sy-vline
WA_RNPAT_VNTMN_STR-DSPTY sy-vline
WA_RNPAT_VNTMN_STR-VISTY sy-vline
WA_RNPAT_VNTMN_STR-BWIDT sy-vline
WA_RNPAT_VNTMN_STR-BWIZT sy-vline
WA_RNPAT_VNTMN_STR-STATU sy-vline
WA_RNPAT_VNTMN_STR-ORGFA sy-vline
WA_RNPAT_VNTMN_STR-ORGPF sy-vline
WA_RNPAT_VNTMN_STR-POBNR sy-vline
WA_RNPAT_VNTMN_STR-PERNR sy-vline
WA_RNPAT_VNTMN_STR-ZIMMR sy-vline
WA_RNPAT_VNTMN_STR-KZTXT sy-vline
WA_RNPAT_VNTMN_STR-ERDAT sy-vline
WA_RNPAT_VNTMN_STR-ERUSR sy-vline
WA_RNPAT_VNTMN_STR-UPDAT sy-vline
WA_RNPAT_VNTMN_STR-UPUSR sy-vline
WA_RNPAT_VNTMN_STR-LGTXT sy-vline
WA_RNPAT_VNTMN_STR-DAUER sy-vline
WA_RNPAT_VNTMN_STR-FACHR sy-vline
WA_RNPAT_VNTMN_STR-PELOC sy-vline
WA_RNPAT_VNTMN_STR-STOID sy-vline
WA_RNPAT_VNTMN_STR-PTINP sy-vline
WA_RNPAT_VNTMN_STR-GSCHL sy-vline
WA_RNPAT_VNTMN_STR-NNAME sy-vline
WA_RNPAT_VNTMN_STR-NNAMS sy-vline
WA_RNPAT_VNTMN_STR-VNAME sy-vline
WA_RNPAT_VNTMN_STR-VNAMS sy-vline
WA_RNPAT_VNTMN_STR-TITEL sy-vline
WA_RNPAT_VNTMN_STR-NAMZU sy-vline
WA_RNPAT_VNTMN_STR-VORSW sy-vline
WA_RNPAT_VNTMN_STR-NAME2 sy-vline
WA_RNPAT_VNTMN_STR-GBDAT sy-vline
WA_RNPAT_VNTMN_STR-GBNAM sy-vline
WA_RNPAT_VNTMN_STR-GBNAS sy-vline
WA_RNPAT_VNTMN_STR-TODKZ sy-vline
WA_RNPAT_VNTMN_STR-VIPKZ sy-vline
WA_RNPAT_VNTMN_STR-RISKF sy-vline
WA_RNPAT_VNTMN_STR-PZIFF sy-vline
WA_RNPAT_VNTMN_STR-ADRNR sy-vline
WA_RNPAT_VNTMN_STR-ADROB sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.