ABAP Select data from SAP table /ISDFPS/151PM_EQUI 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 /ISDFPS/151PM_EQUI 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 /ISDFPS/151PM_EQUI. 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 /ISDFPS/151PM_EQUI 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_/ISDFPS/151PM_EQUI TYPE STANDARD TABLE OF /ISDFPS/151PM_EQUI,
      WA_/ISDFPS/151PM_EQUI TYPE /ISDFPS/151PM_EQUI,
      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: </ISDFPS/151PM_EQUI> TYPE /ISDFPS/151PM_EQUI.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_/ISDFPS/151PM_EQUI.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /ISDFPS/151PM_EQUI
  INTO TABLE IT_/ISDFPS/151PM_EQUI.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /ISDFPS/151PM_EQUI
*  INTO TABLE @DATA(IT_/ISDFPS/151PM_EQUI2).
*--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_/ISDFPS/151PM_EQUI INDEX 1 INTO DATA(WA_/ISDFPS/151PM_EQUI2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/ISDFPS/151PM_EQUI ASSIGNING </ISDFPS/151PM_EQUI>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
</ISDFPS/151PM_EQUI>-EQUNR = 1.
</ISDFPS/151PM_EQUI>-BEGRU = 1.
</ISDFPS/151PM_EQUI>-EQTYP = 1.
</ISDFPS/151PM_EQUI>-EQART = 1.
</ISDFPS/151PM_EQUI>-GWLEN = 1.
ENDLOOP.

LOOP AT IT_/ISDFPS/151PM_EQUI INTO WA_/ISDFPS/151PM_EQUI.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/ISDFPS/151PM_EQUI-GWLEN_TZ, sy-vline,
WA_/ISDFPS/151PM_EQUI-GWLEN_UTC, sy-vline,
WA_/ISDFPS/151PM_EQUI-GWLDT, sy-vline,
WA_/ISDFPS/151PM_EQUI-GWLDT_TZ, sy-vline,
WA_/ISDFPS/151PM_EQUI-GWLDT_UTC, sy-vline,
WA_/ISDFPS/151PM_EQUI-SERGE, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/ISDFPS/151PM_EQUI 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_/ISDFPS/151PM_EQUI 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_/ISDFPS/151PM_EQUI INTO WA_/ISDFPS/151PM_EQUI. *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 EQUNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/ISDFPS/151PM_EQUI-EQUNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/ISDFPS/151PM_EQUI-EQUNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GERNR, internal->external for field GERNR CALL FUNCTION 'CONVERSION_EXIT_GERNR_OUTPUT' EXPORTING input = WA_/ISDFPS/151PM_EQUI-GERNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/ISDFPS/151PM_EQUI-GERNR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit GERNR, internal->external for field SERNR CALL FUNCTION 'CONVERSION_EXIT_GERNR_OUTPUT' EXPORTING input = WA_/ISDFPS/151PM_EQUI-SERNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/ISDFPS/151PM_EQUI-SERNR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit NUMCV, internal->external for field REVLV CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_/ISDFPS/151PM_EQUI-REVLV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/ISDFPS/151PM_EQUI-REVLV.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TPLNR, internal->external for field TPLNR CALL FUNCTION 'CONVERSION_EXIT_TPLNR_OUTPUT' EXPORTING input = WA_/ISDFPS/151PM_EQUI-TPLNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/ISDFPS/151PM_EQUI-TPLNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

*Conversion exit TPLNR, internal->external for field TPLNR_TOP CALL FUNCTION 'CONVERSION_EXIT_TPLNR_OUTPUT' EXPORTING input = WA_/ISDFPS/151PM_EQUI-TPLNR_TOP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/ISDFPS/151PM_EQUI-TPLNR_TOP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field GEWEI CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/ISDFPS/151PM_EQUI-GEWEI IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/ISDFPS/151PM_EQUI-GEWEI.
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_/ISDFPS/151PM_EQUI_STR,
EQUNR TYPE STRING,
BEGRU TYPE STRING,
EQTYP TYPE STRING,
EQART TYPE STRING,
GWLEN TYPE STRING,
GWLEN_TZ TYPE STRING,
GWLEN_UTC TYPE STRING,
GWLDT TYPE STRING,
GWLDT_TZ TYPE STRING,
GWLDT_UTC TYPE STRING,
SERGE TYPE STRING,
GERNR TYPE STRING,
UII_GERNR TYPE STRING,
OBJNR TYPE STRING,
CUOBJ TYPE STRING,
KRFKZ TYPE STRING,
KMATN TYPE STRING,
MATNR TYPE STRING,
SERNR TYPE STRING,
UII_SERNR TYPE STRING,
WERK TYPE STRING,
LAGER TYPE STRING,
CHARGE TYPE STRING,
WARPL TYPE STRING,
IMRC_POINT TYPE STRING,
REVLV TYPE STRING,
S_EQUI TYPE STRING,
S_SERIAL TYPE STRING,
S_KONFI TYPE STRING,
SPRAS TYPE STRING,
EQKTX TYPE STRING,
EQKTU TYPE STRING,
TPLNR TYPE STRING,
PLTXT TYPE STRING,
PLTXU TYPE STRING,
STORT TYPE STRING,
KOKRS TYPE STRING,
KOSTL TYPE STRING,
BUKRS TYPE STRING,
DAUFN TYPE STRING,
AUFNR TYPE STRING,
EMATN TYPE STRING,
SWERK TYPE STRING,
GEWRK TYPE STRING,
EINZL TYPE STRING,
STTXT TYPE STRING,
IWERK TYPE STRING,
ANLNR TYPE STRING,
GSBER TYPE STRING,
TIDNR TYPE STRING,
HEQUI TYPE STRING,
HEQNR TYPE STRING,
MAPAR TYPE STRING,
INGRP TYPE STRING,
ARBPL TYPE STRING,
DATBI TYPE STRING,
DATBI_TZ TYPE STRING,
DATBI_UTC TYPE STRING,
EQLFN TYPE STRING,
B_CHARGE TYPE STRING,
MAKTX TYPE STRING,
KZLTX TYPE STRING,
SUBMT TYPE STRING,
RBNR TYPE STRING,
RBNR_I TYPE STRING,
ISDFPS_MEQUI TYPE STRING,
STSMA TYPE STRING,
ISCHANGEABLE TYPE STRING,
USR00 TYPE STRING,
USR01 TYPE STRING,
USR02 TYPE STRING,
USR03 TYPE STRING,
USR04 TYPE STRING,
USR05 TYPE STRING,
USR06 TYPE STRING,
USR07 TYPE STRING,
USR08 TYPE STRING,
LOADOBJ TYPE STRING,
STORBIN TYPE STRING,
EQEXT_ACTIVE TYPE STRING,
UII TYPE STRING,
IUID_TYPE TYPE STRING,
UII_PLANT TYPE STRING,
TPLNR_TOP TYPE STRING,
SKIP_VAL_SERVICE TYPE STRING,
IS_CLNT_RESOLVED TYPE STRING,
FUNCID TYPE STRING,
FRCFIT TYPE STRING,
FRCRMV TYPE STRING,
GROES TYPE STRING,
BRGEW TYPE STRING,
GEWEI TYPE STRING,END OF T_EKKO_STR. DATA: WA_/ISDFPS/151PM_EQUI_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_/ISDFPS/151PM_EQUI_STR-EQUNR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-BEGRU sy-vline
WA_/ISDFPS/151PM_EQUI_STR-EQTYP sy-vline
WA_/ISDFPS/151PM_EQUI_STR-EQART sy-vline
WA_/ISDFPS/151PM_EQUI_STR-GWLEN sy-vline
WA_/ISDFPS/151PM_EQUI_STR-GWLEN_TZ sy-vline
WA_/ISDFPS/151PM_EQUI_STR-GWLEN_UTC sy-vline
WA_/ISDFPS/151PM_EQUI_STR-GWLDT sy-vline
WA_/ISDFPS/151PM_EQUI_STR-GWLDT_TZ sy-vline
WA_/ISDFPS/151PM_EQUI_STR-GWLDT_UTC sy-vline
WA_/ISDFPS/151PM_EQUI_STR-SERGE sy-vline
WA_/ISDFPS/151PM_EQUI_STR-GERNR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-UII_GERNR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-OBJNR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-CUOBJ sy-vline
WA_/ISDFPS/151PM_EQUI_STR-KRFKZ sy-vline
WA_/ISDFPS/151PM_EQUI_STR-KMATN sy-vline
WA_/ISDFPS/151PM_EQUI_STR-MATNR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-SERNR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-UII_SERNR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-WERK sy-vline
WA_/ISDFPS/151PM_EQUI_STR-LAGER sy-vline
WA_/ISDFPS/151PM_EQUI_STR-CHARGE sy-vline
WA_/ISDFPS/151PM_EQUI_STR-WARPL sy-vline
WA_/ISDFPS/151PM_EQUI_STR-IMRC_POINT sy-vline
WA_/ISDFPS/151PM_EQUI_STR-REVLV sy-vline
WA_/ISDFPS/151PM_EQUI_STR-S_EQUI sy-vline
WA_/ISDFPS/151PM_EQUI_STR-S_SERIAL sy-vline
WA_/ISDFPS/151PM_EQUI_STR-S_KONFI sy-vline
WA_/ISDFPS/151PM_EQUI_STR-SPRAS sy-vline
WA_/ISDFPS/151PM_EQUI_STR-EQKTX sy-vline
WA_/ISDFPS/151PM_EQUI_STR-EQKTU sy-vline
WA_/ISDFPS/151PM_EQUI_STR-TPLNR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-PLTXT sy-vline
WA_/ISDFPS/151PM_EQUI_STR-PLTXU sy-vline
WA_/ISDFPS/151PM_EQUI_STR-STORT sy-vline
WA_/ISDFPS/151PM_EQUI_STR-KOKRS sy-vline
WA_/ISDFPS/151PM_EQUI_STR-KOSTL sy-vline
WA_/ISDFPS/151PM_EQUI_STR-BUKRS sy-vline
WA_/ISDFPS/151PM_EQUI_STR-DAUFN sy-vline
WA_/ISDFPS/151PM_EQUI_STR-AUFNR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-EMATN sy-vline
WA_/ISDFPS/151PM_EQUI_STR-SWERK sy-vline
WA_/ISDFPS/151PM_EQUI_STR-GEWRK sy-vline
WA_/ISDFPS/151PM_EQUI_STR-EINZL sy-vline
WA_/ISDFPS/151PM_EQUI_STR-STTXT sy-vline
WA_/ISDFPS/151PM_EQUI_STR-IWERK sy-vline
WA_/ISDFPS/151PM_EQUI_STR-ANLNR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-GSBER sy-vline
WA_/ISDFPS/151PM_EQUI_STR-TIDNR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-HEQUI sy-vline
WA_/ISDFPS/151PM_EQUI_STR-HEQNR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-MAPAR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-INGRP sy-vline
WA_/ISDFPS/151PM_EQUI_STR-ARBPL sy-vline
WA_/ISDFPS/151PM_EQUI_STR-DATBI sy-vline
WA_/ISDFPS/151PM_EQUI_STR-DATBI_TZ sy-vline
WA_/ISDFPS/151PM_EQUI_STR-DATBI_UTC sy-vline
WA_/ISDFPS/151PM_EQUI_STR-EQLFN sy-vline
WA_/ISDFPS/151PM_EQUI_STR-B_CHARGE sy-vline
WA_/ISDFPS/151PM_EQUI_STR-MAKTX sy-vline
WA_/ISDFPS/151PM_EQUI_STR-KZLTX sy-vline
WA_/ISDFPS/151PM_EQUI_STR-SUBMT sy-vline
WA_/ISDFPS/151PM_EQUI_STR-RBNR sy-vline
WA_/ISDFPS/151PM_EQUI_STR-RBNR_I sy-vline
WA_/ISDFPS/151PM_EQUI_STR-ISDFPS_MEQUI sy-vline
WA_/ISDFPS/151PM_EQUI_STR-STSMA sy-vline
WA_/ISDFPS/151PM_EQUI_STR-ISCHANGEABLE sy-vline
WA_/ISDFPS/151PM_EQUI_STR-USR00 sy-vline
WA_/ISDFPS/151PM_EQUI_STR-USR01 sy-vline
WA_/ISDFPS/151PM_EQUI_STR-USR02 sy-vline
WA_/ISDFPS/151PM_EQUI_STR-USR03 sy-vline
WA_/ISDFPS/151PM_EQUI_STR-USR04 sy-vline
WA_/ISDFPS/151PM_EQUI_STR-USR05 sy-vline
WA_/ISDFPS/151PM_EQUI_STR-USR06 sy-vline
WA_/ISDFPS/151PM_EQUI_STR-USR07 sy-vline
WA_/ISDFPS/151PM_EQUI_STR-USR08 sy-vline
WA_/ISDFPS/151PM_EQUI_STR-LOADOBJ sy-vline
WA_/ISDFPS/151PM_EQUI_STR-STORBIN sy-vline
WA_/ISDFPS/151PM_EQUI_STR-EQEXT_ACTIVE sy-vline
WA_/ISDFPS/151PM_EQUI_STR-UII sy-vline
WA_/ISDFPS/151PM_EQUI_STR-IUID_TYPE sy-vline
WA_/ISDFPS/151PM_EQUI_STR-UII_PLANT sy-vline
WA_/ISDFPS/151PM_EQUI_STR-TPLNR_TOP sy-vline
WA_/ISDFPS/151PM_EQUI_STR-SKIP_VAL_SERVICE sy-vline
WA_/ISDFPS/151PM_EQUI_STR-IS_CLNT_RESOLVED sy-vline
WA_/ISDFPS/151PM_EQUI_STR-FUNCID sy-vline
WA_/ISDFPS/151PM_EQUI_STR-FRCFIT sy-vline
WA_/ISDFPS/151PM_EQUI_STR-FRCRMV sy-vline
WA_/ISDFPS/151PM_EQUI_STR-GROES sy-vline
WA_/ISDFPS/151PM_EQUI_STR-BRGEW sy-vline
WA_/ISDFPS/151PM_EQUI_STR-GEWEI sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.