ABAP Select data from SAP table FIP_S_MATERIAL_ALL_INFO 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 FIP_S_MATERIAL_ALL_INFO 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 FIP_S_MATERIAL_ALL_INFO. 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 FIP_S_MATERIAL_ALL_INFO 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_FIP_S_MATERIAL_ALL_INFO TYPE STANDARD TABLE OF FIP_S_MATERIAL_ALL_INFO,
      WA_FIP_S_MATERIAL_ALL_INFO TYPE FIP_S_MATERIAL_ALL_INFO,
      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: <FIP_S_MATERIAL_ALL_INFO> TYPE FIP_S_MATERIAL_ALL_INFO.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FIP_S_MATERIAL_ALL_INFO
*  INTO TABLE @DATA(IT_FIP_S_MATERIAL_ALL_INFO2).
*--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_FIP_S_MATERIAL_ALL_INFO INDEX 1 INTO DATA(WA_FIP_S_MATERIAL_ALL_INFO2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FIP_S_MATERIAL_ALL_INFO ASSIGNING <FIP_S_MATERIAL_ALL_INFO>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<FIP_S_MATERIAL_ALL_INFO>-MATNR = 1.
<FIP_S_MATERIAL_ALL_INFO>-MAKTX = 1.
<FIP_S_MATERIAL_ALL_INFO>-MATKL = 1.
<FIP_S_MATERIAL_ALL_INFO>-WGBEZ = 1.
<FIP_S_MATERIAL_ALL_INFO>-ATTYP = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FIP_S_MATERIAL_ALL_INFO-SATNR, sy-vline,
WA_FIP_S_MATERIAL_ALL_INFO-MHDHB, sy-vline,
WA_FIP_S_MATERIAL_ALL_INFO-MSTAE, sy-vline,
WA_FIP_S_MATERIAL_ALL_INFO-MSTDE, sy-vline,
WA_FIP_S_MATERIAL_ALL_INFO-DATAB, sy-vline,
WA_FIP_S_MATERIAL_ALL_INFO-LIQDT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FIP_S_MATERIAL_ALL_INFO 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_FIP_S_MATERIAL_ALL_INFO 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_FIP_S_MATERIAL_ALL_INFO INTO WA_FIP_S_MATERIAL_ALL_INFO. *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_FIP_S_MATERIAL_ALL_INFO-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FIP_S_MATERIAL_ALL_INFO-MATNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field LIFNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FIP_S_MATERIAL_ALL_INFO-LIFNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FIP_S_MATERIAL_ALL_INFO-LIFNR.
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_FIP_S_MATERIAL_ALL_INFO_STR,
MATNR TYPE STRING,
MAKTX TYPE STRING,
MATKL TYPE STRING,
WGBEZ TYPE STRING,
ATTYP TYPE STRING,
SATNR TYPE STRING,
MHDHB TYPE STRING,
MSTAE TYPE STRING,
MSTDE TYPE STRING,
DATAB TYPE STRING,
LIQDT TYPE STRING,
FOLUP TYPE STRING,
AKTNR TYPE STRING,
AKTKT TYPE STRING,
BRAND_ID TYPE STRING,
HERKL TYPE STRING,
LANDX TYPE STRING,
RAUBE TYPE STRING,
STORAGE_DURATION TYPE STRING,
MATERIAL_PIC TYPE STRING,
EAN11 TYPE STRING,
MEINS TYPE STRING,
BSTME TYPE STRING,
BRGEW TYPE STRING,
NTGEW TYPE STRING,
GEWEI TYPE STRING,
VOLUM TYPE STRING,
VOLEH TYPE STRING,
COMPONENTS TYPE STRING,
VARIANTS TYPE STRING,
CONVERSIONS TYPE STRING,
UOM TYPE STRING,
MTART TYPE STRING,
UNAME TYPE STRING,
LFRHY TYPE STRING,
PPTXT TYPE STRING,
MRPPP TYPE STRING,
PPTXT_D TYPE STRING,
DEFAULT_ORDER_TYPE TYPE STRING,
FPRFM TYPE STRING,
DELIV_DATE_SP_PL TYPE STRING,
HORIZON TYPE STRING,
DISTRIBUTION_STRATEGY TYPE STRING,
FAIR_SHARE_PROFILE TYPE STRING,
ROUNDING_STRATEGY TYPE STRING,
PRICE_VALID_FOR TYPE STRING,
STATISTICAL_DATA TYPE STRING,
MAIN_VENDOR TYPE STRING,
WERKS TYPE STRING,
ANGNR TYPE STRING,
IDNLF TYPE STRING,
HERKL_R TYPE STRING,
LANDX_R TYPE STRING,
LZEIT TYPE STRING,
PURCHASE_PRICES TYPE STRING,
UOM_SPECIFIC TYPE STRING,
MEINH TYPE STRING,
MSEHL TYPE STRING,
UMREZ TYPE STRING,
UMREN TYPE STRING,
EAN11 TYPE STRING,
NUMTP TYPE STRING,
LAENG TYPE STRING,
BREIT TYPE STRING,
HOEHE TYPE STRING,
MEABM TYPE STRING,
VOLUM TYPE STRING,
VOLEH TYPE STRING,
BRGEW TYPE STRING,
NTGEW TYPE STRING,
GEWEI TYPE STRING,
MSEH3 TYPE STRING,
MSEH6 TYPE STRING,
VABME TYPE STRING,
MMSTA TYPE STRING,
STORE_AVAILIBILITY_DATE TYPE STRING,
BSTRF TYPE STRING,
ACTIVE TYPE STRING,
PLIFZ TYPE STRING,
ENDPA TYPE STRING,
SPABA TYPE STRING,
SPANA TYPE STRING,
WAERS TYPE STRING,
VKABA TYPE STRING,
VKBIA TYPE STRING,
PEINH TYPE STRING,
BPRME TYPE STRING,
LIFNR TYPE STRING,
RECIPIENT_NUM TYPE STRING,
SUPLG_PLANT TYPE STRING,
RECIPIENT_TYPE TYPE STRING,END OF T_EKKO_STR. DATA: WA_FIP_S_MATERIAL_ALL_INFO_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_FIP_S_MATERIAL_ALL_INFO_STR-MATNR sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MAKTX sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MATKL sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-WGBEZ sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-ATTYP sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-SATNR sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MHDHB sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MSTAE sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MSTDE sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-DATAB sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-LIQDT sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-FOLUP sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-AKTNR sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-AKTKT sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-BRAND_ID sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-HERKL sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-LANDX sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-RAUBE sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-STORAGE_DURATION sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MATERIAL_PIC sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-EAN11 sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MEINS sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-BSTME sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-BRGEW sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-NTGEW sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-GEWEI sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-VOLUM sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-VOLEH sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-COMPONENTS sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-VARIANTS sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-CONVERSIONS sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-UOM sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MTART sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-UNAME sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-LFRHY sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-PPTXT sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MRPPP sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-PPTXT_D sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-DEFAULT_ORDER_TYPE sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-FPRFM sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-DELIV_DATE_SP_PL sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-HORIZON sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-DISTRIBUTION_STRATEGY sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-FAIR_SHARE_PROFILE sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-ROUNDING_STRATEGY sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-PRICE_VALID_FOR sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-STATISTICAL_DATA sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MAIN_VENDOR sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-WERKS sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-ANGNR sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-IDNLF sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-HERKL_R sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-LANDX_R sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-LZEIT sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-PURCHASE_PRICES sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-UOM_SPECIFIC sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MEINH sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MSEHL sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-UMREZ sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-UMREN sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-EAN11 sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-NUMTP sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-LAENG sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-BREIT sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-HOEHE sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MEABM sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-VOLUM sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-VOLEH sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-BRGEW sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-NTGEW sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-GEWEI sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MSEH3 sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MSEH6 sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-VABME sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-MMSTA sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-STORE_AVAILIBILITY_DATE sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-BSTRF sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-ACTIVE sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-PLIFZ sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-ENDPA sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-SPABA sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-SPANA sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-WAERS sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-VKABA sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-VKBIA sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-PEINH sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-BPRME sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-LIFNR sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-RECIPIENT_NUM sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-SUPLG_PLANT sy-vline
WA_FIP_S_MATERIAL_ALL_INFO_STR-RECIPIENT_TYPE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.