ABAP Select data from SAP table E3MARCM 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 E3MARCM 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 E3MARCM. 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 E3MARCM 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_E3MARCM TYPE STANDARD TABLE OF E3MARCM,
      WA_E3MARCM TYPE E3MARCM,
      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: <E3MARCM> TYPE E3MARCM.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM E3MARCM
*  INTO TABLE @DATA(IT_E3MARCM2).
*--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_E3MARCM INDEX 1 INTO DATA(WA_E3MARCM2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_E3MARCM ASSIGNING <E3MARCM>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<E3MARCM>-MSGFN = 1.
<E3MARCM>-WERKS = 1.
<E3MARCM>-PSTAT = 1.
<E3MARCM>-LVORM = 1.
<E3MARCM>-BWTTY = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_E3MARCM-MAABC, sy-vline,
WA_E3MARCM-KZKRI, sy-vline,
WA_E3MARCM-EKGRP, sy-vline,
WA_E3MARCM-AUSME, sy-vline,
WA_E3MARCM-DISPR, sy-vline,
WA_E3MARCM-DISMM, sy-vline.
ENDLOOP. *Add any further fields from structure WA_E3MARCM 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_E3MARCM 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_E3MARCM INTO WA_E3MARCM. *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 CUNIT, internal->external for field AUSME CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_E3MARCM-AUSME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_E3MARCM-AUSME.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field INDUS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_E3MARCM-INDUS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_E3MARCM-INDUS.
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_E3MARCM_STR,
MSGFN TYPE STRING,
WERKS TYPE STRING,
PSTAT TYPE STRING,
LVORM TYPE STRING,
BWTTY TYPE STRING,
MAABC TYPE STRING,
KZKRI TYPE STRING,
EKGRP TYPE STRING,
AUSME TYPE STRING,
DISPR TYPE STRING,
DISMM TYPE STRING,
DISPO TYPE STRING,
PLIFZ TYPE STRING,
WEBAZ TYPE STRING,
PERKZ TYPE STRING,
AUSSS TYPE STRING,
DISLS TYPE STRING,
BESKZ TYPE STRING,
SOBSL TYPE STRING,
MINBE TYPE STRING,
EISBE TYPE STRING,
BSTMI TYPE STRING,
BSTMA TYPE STRING,
BSTFE TYPE STRING,
BSTRF TYPE STRING,
MABST TYPE STRING,
LOSFX TYPE STRING,
SBDKZ TYPE STRING,
LAGPR TYPE STRING,
ALTSL TYPE STRING,
KZAUS TYPE STRING,
AUSDT TYPE STRING,
NFMAT TYPE STRING,
KZBED TYPE STRING,
MISKZ TYPE STRING,
FHORI TYPE STRING,
PFREI TYPE STRING,
FFREI TYPE STRING,
RGEKZ TYPE STRING,
FEVOR TYPE STRING,
BEARZ TYPE STRING,
RUEZT TYPE STRING,
TRANZ TYPE STRING,
BASMG TYPE STRING,
DZEIT TYPE STRING,
MAXLZ TYPE STRING,
LZEIH TYPE STRING,
KZPRO TYPE STRING,
GPMKZ TYPE STRING,
UEETO TYPE STRING,
UEETK TYPE STRING,
UNETO TYPE STRING,
WZEIT TYPE STRING,
ATPKZ TYPE STRING,
VZUSL TYPE STRING,
HERBL TYPE STRING,
INSMK TYPE STRING,
SSQSS TYPE STRING,
KZDKZ TYPE STRING,
UMLMC TYPE STRING,
LADGR TYPE STRING,
XCHPF TYPE STRING,
USEQU TYPE STRING,
LGRAD TYPE STRING,
AUFTL TYPE STRING,
PLVAR TYPE STRING,
OTYPE TYPE STRING,
OBJID TYPE STRING,
MTVFP TYPE STRING,
PERIV TYPE STRING,
KZKFK TYPE STRING,
VRVEZ TYPE STRING,
VBAMG TYPE STRING,
VBEAZ TYPE STRING,
LIZYK TYPE STRING,
BWSCL TYPE STRING,
KAUTB TYPE STRING,
KORDB TYPE STRING,
STAWN TYPE STRING,
HERKL TYPE STRING,
HERKR TYPE STRING,
EXPME TYPE STRING,
MTVER TYPE STRING,
PRCTR TYPE STRING,
TRAME TYPE STRING,
MRPPP TYPE STRING,
SAUFT TYPE STRING,
FXHOR TYPE STRING,
VRMOD TYPE STRING,
VINT1 TYPE STRING,
VINT2 TYPE STRING,
STLAL TYPE STRING,
STLAN TYPE STRING,
PLNNR TYPE STRING,
APLAL TYPE STRING,
LOSGR TYPE STRING,
SOBSK TYPE STRING,
FRTME TYPE STRING,
LGPRO TYPE STRING,
DISGR TYPE STRING,
KAUSF TYPE STRING,
QZGTP TYPE STRING,
TAKZT TYPE STRING,
RWPRO TYPE STRING,
COPAM TYPE STRING,
ABCIN TYPE STRING,
AWSLS TYPE STRING,
SERNP TYPE STRING,
STDPD TYPE STRING,
SFEPR TYPE STRING,
XMCNG TYPE STRING,
QSSYS TYPE STRING,
LFRHY TYPE STRING,
RDPRF TYPE STRING,
VRBMT TYPE STRING,
VRBWK TYPE STRING,
VRBDT TYPE STRING,
VRBFK TYPE STRING,
AUTRU TYPE STRING,
PREFE TYPE STRING,
PRENC TYPE STRING,
PRENO TYPE STRING,
PREND TYPE STRING,
PRENE TYPE STRING,
PRENG TYPE STRING,
ITARK TYPE STRING,
PRFRQ TYPE STRING,
KZKUP TYPE STRING,
STRGR TYPE STRING,
LGFSB TYPE STRING,
SCHGT TYPE STRING,
CCFIX TYPE STRING,
EPRIO TYPE STRING,
QMATA TYPE STRING,
PLNTY TYPE STRING,
MMSTA TYPE STRING,
SFCPF TYPE STRING,
SHFLG TYPE STRING,
SHZET TYPE STRING,
MDACH TYPE STRING,
KZECH TYPE STRING,
MMSTD TYPE STRING,
MFRGR TYPE STRING,
FVIDK TYPE STRING,
INDUS TYPE STRING,
MOWNR TYPE STRING,
MOGRU TYPE STRING,
CASNR TYPE STRING,
GPNUM TYPE STRING,
STEUC TYPE STRING,
FABKZ TYPE STRING,
MATGR TYPE STRING,
LOGGR TYPE STRING,
VSPVB TYPE STRING,
DPLFS TYPE STRING,
DPLPU TYPE STRING,
DPLHO TYPE STRING,
MINLS TYPE STRING,
MAXLS TYPE STRING,
FIXLS TYPE STRING,
LTINC TYPE STRING,
COMPL TYPE STRING,
CONVT TYPE STRING,
FPRFM TYPE STRING,
SHPRO TYPE STRING,
FXPRU TYPE STRING,
KZPSP TYPE STRING,
OCMPF TYPE STRING,
APOKZ TYPE STRING,
AHDIS TYPE STRING,
DIBER TYPE STRING,END OF T_EKKO_STR. DATA: WA_E3MARCM_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_E3MARCM_STR-MSGFN sy-vline
WA_E3MARCM_STR-WERKS sy-vline
WA_E3MARCM_STR-PSTAT sy-vline
WA_E3MARCM_STR-LVORM sy-vline
WA_E3MARCM_STR-BWTTY sy-vline
WA_E3MARCM_STR-MAABC sy-vline
WA_E3MARCM_STR-KZKRI sy-vline
WA_E3MARCM_STR-EKGRP sy-vline
WA_E3MARCM_STR-AUSME sy-vline
WA_E3MARCM_STR-DISPR sy-vline
WA_E3MARCM_STR-DISMM sy-vline
WA_E3MARCM_STR-DISPO sy-vline
WA_E3MARCM_STR-PLIFZ sy-vline
WA_E3MARCM_STR-WEBAZ sy-vline
WA_E3MARCM_STR-PERKZ sy-vline
WA_E3MARCM_STR-AUSSS sy-vline
WA_E3MARCM_STR-DISLS sy-vline
WA_E3MARCM_STR-BESKZ sy-vline
WA_E3MARCM_STR-SOBSL sy-vline
WA_E3MARCM_STR-MINBE sy-vline
WA_E3MARCM_STR-EISBE sy-vline
WA_E3MARCM_STR-BSTMI sy-vline
WA_E3MARCM_STR-BSTMA sy-vline
WA_E3MARCM_STR-BSTFE sy-vline
WA_E3MARCM_STR-BSTRF sy-vline
WA_E3MARCM_STR-MABST sy-vline
WA_E3MARCM_STR-LOSFX sy-vline
WA_E3MARCM_STR-SBDKZ sy-vline
WA_E3MARCM_STR-LAGPR sy-vline
WA_E3MARCM_STR-ALTSL sy-vline
WA_E3MARCM_STR-KZAUS sy-vline
WA_E3MARCM_STR-AUSDT sy-vline
WA_E3MARCM_STR-NFMAT sy-vline
WA_E3MARCM_STR-KZBED sy-vline
WA_E3MARCM_STR-MISKZ sy-vline
WA_E3MARCM_STR-FHORI sy-vline
WA_E3MARCM_STR-PFREI sy-vline
WA_E3MARCM_STR-FFREI sy-vline
WA_E3MARCM_STR-RGEKZ sy-vline
WA_E3MARCM_STR-FEVOR sy-vline
WA_E3MARCM_STR-BEARZ sy-vline
WA_E3MARCM_STR-RUEZT sy-vline
WA_E3MARCM_STR-TRANZ sy-vline
WA_E3MARCM_STR-BASMG sy-vline
WA_E3MARCM_STR-DZEIT sy-vline
WA_E3MARCM_STR-MAXLZ sy-vline
WA_E3MARCM_STR-LZEIH sy-vline
WA_E3MARCM_STR-KZPRO sy-vline
WA_E3MARCM_STR-GPMKZ sy-vline
WA_E3MARCM_STR-UEETO sy-vline
WA_E3MARCM_STR-UEETK sy-vline
WA_E3MARCM_STR-UNETO sy-vline
WA_E3MARCM_STR-WZEIT sy-vline
WA_E3MARCM_STR-ATPKZ sy-vline
WA_E3MARCM_STR-VZUSL sy-vline
WA_E3MARCM_STR-HERBL sy-vline
WA_E3MARCM_STR-INSMK sy-vline
WA_E3MARCM_STR-SSQSS sy-vline
WA_E3MARCM_STR-KZDKZ sy-vline
WA_E3MARCM_STR-UMLMC sy-vline
WA_E3MARCM_STR-LADGR sy-vline
WA_E3MARCM_STR-XCHPF sy-vline
WA_E3MARCM_STR-USEQU sy-vline
WA_E3MARCM_STR-LGRAD sy-vline
WA_E3MARCM_STR-AUFTL sy-vline
WA_E3MARCM_STR-PLVAR sy-vline
WA_E3MARCM_STR-OTYPE sy-vline
WA_E3MARCM_STR-OBJID sy-vline
WA_E3MARCM_STR-MTVFP sy-vline
WA_E3MARCM_STR-PERIV sy-vline
WA_E3MARCM_STR-KZKFK sy-vline
WA_E3MARCM_STR-VRVEZ sy-vline
WA_E3MARCM_STR-VBAMG sy-vline
WA_E3MARCM_STR-VBEAZ sy-vline
WA_E3MARCM_STR-LIZYK sy-vline
WA_E3MARCM_STR-BWSCL sy-vline
WA_E3MARCM_STR-KAUTB sy-vline
WA_E3MARCM_STR-KORDB sy-vline
WA_E3MARCM_STR-STAWN sy-vline
WA_E3MARCM_STR-HERKL sy-vline
WA_E3MARCM_STR-HERKR sy-vline
WA_E3MARCM_STR-EXPME sy-vline
WA_E3MARCM_STR-MTVER sy-vline
WA_E3MARCM_STR-PRCTR sy-vline
WA_E3MARCM_STR-TRAME sy-vline
WA_E3MARCM_STR-MRPPP sy-vline
WA_E3MARCM_STR-SAUFT sy-vline
WA_E3MARCM_STR-FXHOR sy-vline
WA_E3MARCM_STR-VRMOD sy-vline
WA_E3MARCM_STR-VINT1 sy-vline
WA_E3MARCM_STR-VINT2 sy-vline
WA_E3MARCM_STR-STLAL sy-vline
WA_E3MARCM_STR-STLAN sy-vline
WA_E3MARCM_STR-PLNNR sy-vline
WA_E3MARCM_STR-APLAL sy-vline
WA_E3MARCM_STR-LOSGR sy-vline
WA_E3MARCM_STR-SOBSK sy-vline
WA_E3MARCM_STR-FRTME sy-vline
WA_E3MARCM_STR-LGPRO sy-vline
WA_E3MARCM_STR-DISGR sy-vline
WA_E3MARCM_STR-KAUSF sy-vline
WA_E3MARCM_STR-QZGTP sy-vline
WA_E3MARCM_STR-TAKZT sy-vline
WA_E3MARCM_STR-RWPRO sy-vline
WA_E3MARCM_STR-COPAM sy-vline
WA_E3MARCM_STR-ABCIN sy-vline
WA_E3MARCM_STR-AWSLS sy-vline
WA_E3MARCM_STR-SERNP sy-vline
WA_E3MARCM_STR-STDPD sy-vline
WA_E3MARCM_STR-SFEPR sy-vline
WA_E3MARCM_STR-XMCNG sy-vline
WA_E3MARCM_STR-QSSYS sy-vline
WA_E3MARCM_STR-LFRHY sy-vline
WA_E3MARCM_STR-RDPRF sy-vline
WA_E3MARCM_STR-VRBMT sy-vline
WA_E3MARCM_STR-VRBWK sy-vline
WA_E3MARCM_STR-VRBDT sy-vline
WA_E3MARCM_STR-VRBFK sy-vline
WA_E3MARCM_STR-AUTRU sy-vline
WA_E3MARCM_STR-PREFE sy-vline
WA_E3MARCM_STR-PRENC sy-vline
WA_E3MARCM_STR-PRENO sy-vline
WA_E3MARCM_STR-PREND sy-vline
WA_E3MARCM_STR-PRENE sy-vline
WA_E3MARCM_STR-PRENG sy-vline
WA_E3MARCM_STR-ITARK sy-vline
WA_E3MARCM_STR-PRFRQ sy-vline
WA_E3MARCM_STR-KZKUP sy-vline
WA_E3MARCM_STR-STRGR sy-vline
WA_E3MARCM_STR-LGFSB sy-vline
WA_E3MARCM_STR-SCHGT sy-vline
WA_E3MARCM_STR-CCFIX sy-vline
WA_E3MARCM_STR-EPRIO sy-vline
WA_E3MARCM_STR-QMATA sy-vline
WA_E3MARCM_STR-PLNTY sy-vline
WA_E3MARCM_STR-MMSTA sy-vline
WA_E3MARCM_STR-SFCPF sy-vline
WA_E3MARCM_STR-SHFLG sy-vline
WA_E3MARCM_STR-SHZET sy-vline
WA_E3MARCM_STR-MDACH sy-vline
WA_E3MARCM_STR-KZECH sy-vline
WA_E3MARCM_STR-MMSTD sy-vline
WA_E3MARCM_STR-MFRGR sy-vline
WA_E3MARCM_STR-FVIDK sy-vline
WA_E3MARCM_STR-INDUS sy-vline
WA_E3MARCM_STR-MOWNR sy-vline
WA_E3MARCM_STR-MOGRU sy-vline
WA_E3MARCM_STR-CASNR sy-vline
WA_E3MARCM_STR-GPNUM sy-vline
WA_E3MARCM_STR-STEUC sy-vline
WA_E3MARCM_STR-FABKZ sy-vline
WA_E3MARCM_STR-MATGR sy-vline
WA_E3MARCM_STR-LOGGR sy-vline
WA_E3MARCM_STR-VSPVB sy-vline
WA_E3MARCM_STR-DPLFS sy-vline
WA_E3MARCM_STR-DPLPU sy-vline
WA_E3MARCM_STR-DPLHO sy-vline
WA_E3MARCM_STR-MINLS sy-vline
WA_E3MARCM_STR-MAXLS sy-vline
WA_E3MARCM_STR-FIXLS sy-vline
WA_E3MARCM_STR-LTINC sy-vline
WA_E3MARCM_STR-COMPL sy-vline
WA_E3MARCM_STR-CONVT sy-vline
WA_E3MARCM_STR-FPRFM sy-vline
WA_E3MARCM_STR-SHPRO sy-vline
WA_E3MARCM_STR-FXPRU sy-vline
WA_E3MARCM_STR-KZPSP sy-vline
WA_E3MARCM_STR-OCMPF sy-vline
WA_E3MARCM_STR-APOKZ sy-vline
WA_E3MARCM_STR-AHDIS sy-vline
WA_E3MARCM_STR-DIBER sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.