ABAP Select data from SAP table MARAV 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 MARAV 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 MARAV. 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 MARAV 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_MARAV TYPE STANDARD TABLE OF MARAV,
      WA_MARAV TYPE MARAV,
      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: <MARAV> TYPE MARAV.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MARAV
*  INTO TABLE @DATA(IT_MARAV2).
*--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_MARAV INDEX 1 INTO DATA(WA_MARAV2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_MARAV ASSIGNING <MARAV>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<MARAV>-MANDT = 1.
<MARAV>-MATNR = 1.
<MARAV>-SPRAS = 1.
<MARAV>-ERSDA = 1.
<MARAV>-ERNAM = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MARAV-LAEDA, sy-vline,
WA_MARAV-AENAM, sy-vline,
WA_MARAV-VPSTA, sy-vline,
WA_MARAV-PSTAT, sy-vline,
WA_MARAV-LVORM, sy-vline,
WA_MARAV-MTART, sy-vline.
ENDLOOP. *Add any further fields from structure WA_MARAV 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_MARAV 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_MARAV INTO WA_MARAV. *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 MATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_MARAV-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MARAV-MATNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ISOLA, internal->external for field SPRAS CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT' EXPORTING input = WA_MARAV-SPRAS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MARAV-SPRAS.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit MATN3, internal->external for field STOFF CALL FUNCTION 'CONVERSION_EXIT_MATN3_OUTPUT' EXPORTING input = WA_MARAV-STOFF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MARAV-STOFF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EAN11, internal->external for field EAN11 CALL FUNCTION 'CONVERSION_EXIT_EAN11_OUTPUT' EXPORTING input = WA_MARAV-EAN11 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MARAV-EAN11.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit GJAHR, internal->external for field SAISJ CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_MARAV-SAISJ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MARAV-SAISJ.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit PERKZ, internal->external for field IPRKZ CALL FUNCTION 'CONVERSION_EXIT_PERKZ_OUTPUT' EXPORTING input = WA_MARAV-IPRKZ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MARAV-IPRKZ.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit CUNIT, internal->external for field /CWM/VALUM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_MARAV-/CWM/VALUM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MARAV-/CWM/VALUM.
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_MARAV_STR,
MANDT TYPE STRING,
MATNR TYPE STRING,
SPRAS TYPE STRING,
ERSDA TYPE STRING,
ERNAM TYPE STRING,
LAEDA TYPE STRING,
AENAM TYPE STRING,
VPSTA TYPE STRING,
PSTAT TYPE STRING,
LVORM TYPE STRING,
MTART TYPE STRING,
MBRSH TYPE STRING,
MATKL TYPE STRING,
BISMT TYPE STRING,
MEINS TYPE STRING,
BSTME TYPE STRING,
ZEINR TYPE STRING,
ZEIAR TYPE STRING,
ZEIVR TYPE STRING,
ZEIFO TYPE STRING,
AESZN TYPE STRING,
BLATT TYPE STRING,
BLANZ TYPE STRING,
FERTH TYPE STRING,
FORMT TYPE STRING,
GROES TYPE STRING,
WRKST TYPE STRING,
NORMT TYPE STRING,
LABOR TYPE STRING,
EKWSL TYPE STRING,
BRGEW TYPE STRING,
NTGEW TYPE STRING,
GEWEI TYPE STRING,
VOLUM TYPE STRING,
VOLEH TYPE STRING,
BEHVO TYPE STRING,
RAUBE TYPE STRING,
TEMPB TYPE STRING,
DISST TYPE STRING,
TRAGR TYPE STRING,
STOFF TYPE STRING,
SPART TYPE STRING,
EAN11 TYPE STRING,
NUMTP TYPE STRING,
LAENG TYPE STRING,
BREIT TYPE STRING,
HOEHE TYPE STRING,
MEABM TYPE STRING,
PRDHA TYPE STRING,
KUNNR TYPE STRING,
AEKLK TYPE STRING,
CADKZ TYPE STRING,
QMPUR TYPE STRING,
ETIFO TYPE STRING,
ETIAR TYPE STRING,
ERGEW TYPE STRING,
ERGEI TYPE STRING,
ERVOL TYPE STRING,
ERVOE TYPE STRING,
GEWTO TYPE STRING,
VOLTO TYPE STRING,
VABME TYPE STRING,
MAKTX TYPE STRING,
MAKTG TYPE STRING,
KZREV TYPE STRING,
KZKFG TYPE STRING,
XCHPF TYPE STRING,
VHART TYPE STRING,
FUELG TYPE STRING,
STFAK TYPE STRING,
MAGRV TYPE STRING,
BEGRU TYPE STRING,
MLGUT TYPE STRING,
KZKUP TYPE STRING,
KZNFM TYPE STRING,
TAKLV TYPE STRING,
RBNRM TYPE STRING,
MHDRZ TYPE STRING,
MHDHB TYPE STRING,
MHDLP TYPE STRING,
DATAB TYPE STRING,
LIQDT TYPE STRING,
SAISJ TYPE STRING,
PLGTP TYPE STRING,
EXTWG TYPE STRING,
SATNR TYPE STRING,
ATTYP TYPE STRING,
PMATA TYPE STRING,
MSTAE TYPE STRING,
MSTAV TYPE STRING,
MSTDE TYPE STRING,
MSTDV TYPE STRING,
INHME TYPE STRING,
INHAL TYPE STRING,
VPREH TYPE STRING,
ETIAG TYPE STRING,
INHBR TYPE STRING,
BWSCL TYPE STRING,
KZUMW TYPE STRING,
KOSCH TYPE STRING,
CUOBF TYPE STRING,
SPROF TYPE STRING,
NRFHG TYPE STRING,
MFRPN TYPE STRING,
MFRNR TYPE STRING,
BMATN TYPE STRING,
MPROF TYPE STRING,
KZWSM TYPE STRING,
SAITY TYPE STRING,
PROFL TYPE STRING,
IHIVI TYPE STRING,
ILOOS TYPE STRING,
SERLV TYPE STRING,
KZGVH TYPE STRING,
XGCHP TYPE STRING,
KZEFF TYPE STRING,
COMPL TYPE STRING,
IPRKZ TYPE STRING,
RDMHD TYPE STRING,
PRZUS TYPE STRING,
MTPOS_MARA TYPE STRING,
BFLME TYPE STRING,
MATFI TYPE STRING,
CMREL TYPE STRING,
SLED_BBD TYPE STRING,
GTIN_VARIANT TYPE STRING,
GENNR TYPE STRING,
RMATP TYPE STRING,
GDS_RELEVANT TYPE STRING,
MCOND TYPE STRING,
RETDELC TYPE STRING,
LOGLEV_RETO TYPE STRING,
NSNID TYPE STRING,
WEORA TYPE STRING,
IPMIPPRODUCT TYPE STRING,
MEDIUM TYPE STRING,
COMMODITY TYPE STRING,
SGT_CSGR TYPE STRING,
SGT_COVSA TYPE STRING,
SGT_REL TYPE STRING,
/CWM/XCWMAT TYPE STRING,
/CWM/VALUM TYPE STRING,
/CWM/TOLGR TYPE STRING,END OF T_EKKO_STR. DATA: WA_MARAV_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_MARAV_STR-MANDT sy-vline
WA_MARAV_STR-MATNR sy-vline
WA_MARAV_STR-SPRAS sy-vline
WA_MARAV_STR-ERSDA sy-vline
WA_MARAV_STR-ERNAM sy-vline
WA_MARAV_STR-LAEDA sy-vline
WA_MARAV_STR-AENAM sy-vline
WA_MARAV_STR-VPSTA sy-vline
WA_MARAV_STR-PSTAT sy-vline
WA_MARAV_STR-LVORM sy-vline
WA_MARAV_STR-MTART sy-vline
WA_MARAV_STR-MBRSH sy-vline
WA_MARAV_STR-MATKL sy-vline
WA_MARAV_STR-BISMT sy-vline
WA_MARAV_STR-MEINS sy-vline
WA_MARAV_STR-BSTME sy-vline
WA_MARAV_STR-ZEINR sy-vline
WA_MARAV_STR-ZEIAR sy-vline
WA_MARAV_STR-ZEIVR sy-vline
WA_MARAV_STR-ZEIFO sy-vline
WA_MARAV_STR-AESZN sy-vline
WA_MARAV_STR-BLATT sy-vline
WA_MARAV_STR-BLANZ sy-vline
WA_MARAV_STR-FERTH sy-vline
WA_MARAV_STR-FORMT sy-vline
WA_MARAV_STR-GROES sy-vline
WA_MARAV_STR-WRKST sy-vline
WA_MARAV_STR-NORMT sy-vline
WA_MARAV_STR-LABOR sy-vline
WA_MARAV_STR-EKWSL sy-vline
WA_MARAV_STR-BRGEW sy-vline
WA_MARAV_STR-NTGEW sy-vline
WA_MARAV_STR-GEWEI sy-vline
WA_MARAV_STR-VOLUM sy-vline
WA_MARAV_STR-VOLEH sy-vline
WA_MARAV_STR-BEHVO sy-vline
WA_MARAV_STR-RAUBE sy-vline
WA_MARAV_STR-TEMPB sy-vline
WA_MARAV_STR-DISST sy-vline
WA_MARAV_STR-TRAGR sy-vline
WA_MARAV_STR-STOFF sy-vline
WA_MARAV_STR-SPART sy-vline
WA_MARAV_STR-EAN11 sy-vline
WA_MARAV_STR-NUMTP sy-vline
WA_MARAV_STR-LAENG sy-vline
WA_MARAV_STR-BREIT sy-vline
WA_MARAV_STR-HOEHE sy-vline
WA_MARAV_STR-MEABM sy-vline
WA_MARAV_STR-PRDHA sy-vline
WA_MARAV_STR-KUNNR sy-vline
WA_MARAV_STR-AEKLK sy-vline
WA_MARAV_STR-CADKZ sy-vline
WA_MARAV_STR-QMPUR sy-vline
WA_MARAV_STR-ETIFO sy-vline
WA_MARAV_STR-ETIAR sy-vline
WA_MARAV_STR-ERGEW sy-vline
WA_MARAV_STR-ERGEI sy-vline
WA_MARAV_STR-ERVOL sy-vline
WA_MARAV_STR-ERVOE sy-vline
WA_MARAV_STR-GEWTO sy-vline
WA_MARAV_STR-VOLTO sy-vline
WA_MARAV_STR-VABME sy-vline
WA_MARAV_STR-MAKTX sy-vline
WA_MARAV_STR-MAKTG sy-vline
WA_MARAV_STR-KZREV sy-vline
WA_MARAV_STR-KZKFG sy-vline
WA_MARAV_STR-XCHPF sy-vline
WA_MARAV_STR-VHART sy-vline
WA_MARAV_STR-FUELG sy-vline
WA_MARAV_STR-STFAK sy-vline
WA_MARAV_STR-MAGRV sy-vline
WA_MARAV_STR-BEGRU sy-vline
WA_MARAV_STR-MLGUT sy-vline
WA_MARAV_STR-KZKUP sy-vline
WA_MARAV_STR-KZNFM sy-vline
WA_MARAV_STR-TAKLV sy-vline
WA_MARAV_STR-RBNRM sy-vline
WA_MARAV_STR-MHDRZ sy-vline
WA_MARAV_STR-MHDHB sy-vline
WA_MARAV_STR-MHDLP sy-vline
WA_MARAV_STR-DATAB sy-vline
WA_MARAV_STR-LIQDT sy-vline
WA_MARAV_STR-SAISJ sy-vline
WA_MARAV_STR-PLGTP sy-vline
WA_MARAV_STR-EXTWG sy-vline
WA_MARAV_STR-SATNR sy-vline
WA_MARAV_STR-ATTYP sy-vline
WA_MARAV_STR-PMATA sy-vline
WA_MARAV_STR-MSTAE sy-vline
WA_MARAV_STR-MSTAV sy-vline
WA_MARAV_STR-MSTDE sy-vline
WA_MARAV_STR-MSTDV sy-vline
WA_MARAV_STR-INHME sy-vline
WA_MARAV_STR-INHAL sy-vline
WA_MARAV_STR-VPREH sy-vline
WA_MARAV_STR-ETIAG sy-vline
WA_MARAV_STR-INHBR sy-vline
WA_MARAV_STR-BWSCL sy-vline
WA_MARAV_STR-KZUMW sy-vline
WA_MARAV_STR-KOSCH sy-vline
WA_MARAV_STR-CUOBF sy-vline
WA_MARAV_STR-SPROF sy-vline
WA_MARAV_STR-NRFHG sy-vline
WA_MARAV_STR-MFRPN sy-vline
WA_MARAV_STR-MFRNR sy-vline
WA_MARAV_STR-BMATN sy-vline
WA_MARAV_STR-MPROF sy-vline
WA_MARAV_STR-KZWSM sy-vline
WA_MARAV_STR-SAITY sy-vline
WA_MARAV_STR-PROFL sy-vline
WA_MARAV_STR-IHIVI sy-vline
WA_MARAV_STR-ILOOS sy-vline
WA_MARAV_STR-SERLV sy-vline
WA_MARAV_STR-KZGVH sy-vline
WA_MARAV_STR-XGCHP sy-vline
WA_MARAV_STR-KZEFF sy-vline
WA_MARAV_STR-COMPL sy-vline
WA_MARAV_STR-IPRKZ sy-vline
WA_MARAV_STR-RDMHD sy-vline
WA_MARAV_STR-PRZUS sy-vline
WA_MARAV_STR-MTPOS_MARA sy-vline
WA_MARAV_STR-BFLME sy-vline
WA_MARAV_STR-MATFI sy-vline
WA_MARAV_STR-CMREL sy-vline
WA_MARAV_STR-SLED_BBD sy-vline
WA_MARAV_STR-GTIN_VARIANT sy-vline
WA_MARAV_STR-GENNR sy-vline
WA_MARAV_STR-RMATP sy-vline
WA_MARAV_STR-GDS_RELEVANT sy-vline
WA_MARAV_STR-MCOND sy-vline
WA_MARAV_STR-RETDELC sy-vline
WA_MARAV_STR-LOGLEV_RETO sy-vline
WA_MARAV_STR-NSNID sy-vline
WA_MARAV_STR-WEORA sy-vline
WA_MARAV_STR-IPMIPPRODUCT sy-vline
WA_MARAV_STR-MEDIUM sy-vline
WA_MARAV_STR-COMMODITY sy-vline
WA_MARAV_STR-SGT_CSGR sy-vline
WA_MARAV_STR-SGT_COVSA sy-vline
WA_MARAV_STR-SGT_REL sy-vline
WA_MARAV_STR-/CWM/XCWMAT sy-vline
WA_MARAV_STR-/CWM/VALUM sy-vline
WA_MARAV_STR-/CWM/TOLGR sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.