ABAP Select data from SAP table MC04P_3ARB 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 MC04P_3ARB 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 MC04P_3ARB. 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 MC04P_3ARB 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_MC04P_3ARB TYPE STANDARD TABLE OF MC04P_3ARB,
      WA_MC04P_3ARB TYPE MC04P_3ARB,
      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: <MC04P_3ARB> TYPE MC04P_3ARB.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MC04P_3ARB
*  INTO TABLE @DATA(IT_MC04P_3ARB2).
*--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_MC04P_3ARB INDEX 1 INTO DATA(WA_MC04P_3ARB2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_MC04P_3ARB ASSIGNING <MC04P_3ARB>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<MC04P_3ARB>-ABRUE = 1.
<MC04P_3ARB>-ARBPL = 1.
<MC04P_3ARB>-ARUZE = 1.
<MC04P_3ARB>-ASVRG = 1.
<MC04P_3ARB>-A_TAB = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MC04P_3ARB-BEARZ, sy-vline,
WA_MC04P_3ARB-BEAZE, sy-vline,
WA_MC04P_3ARB-BUDAT, sy-vline,
WA_MC04P_3ARB-DFZEH, sy-vline,
WA_MC04P_3ARB-DFZEXEH, sy-vline,
WA_MC04P_3ARB-FSAVD, sy-vline.
ENDLOOP. *Add any further fields from structure WA_MC04P_3ARB 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_MC04P_3ARB 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_MC04P_3ARB INTO WA_MC04P_3ARB. *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 ARUZE CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_MC04P_3ARB-ARUZE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MC04P_3ARB-ARUZE.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field WRTZE CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_MC04P_3ARB-WRTZE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MC04P_3ARB-WRTZE.
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_MC04P_3ARB_STR,
ABRUE TYPE STRING,
ARBPL TYPE STRING,
ARUZE TYPE STRING,
ASVRG TYPE STRING,
A_TAB TYPE STRING,
BEARZ TYPE STRING,
BEAZE TYPE STRING,
BUDAT TYPE STRING,
DFZEH TYPE STRING,
DFZEXEH TYPE STRING,
FSAVD TYPE STRING,
FSEDD TYPE STRING,
GMNGA TYPE STRING,
GRUND TYPE STRING,
IADD TYPE STRING,
IEAVD TYPE STRING,
IEDD TYPE STRING,
ILE01 TYPE STRING,
ILE02 TYPE STRING,
ILE03 TYPE STRING,
ILE04 TYPE STRING,
ILE05 TYPE STRING,
ILE06 TYPE STRING,
ISAVD TYPE STRING,
ISDD TYPE STRING,
ISM01 TYPE STRING,
ISM02 TYPE STRING,
ISM03 TYPE STRING,
ISM04 TYPE STRING,
ISM05 TYPE STRING,
ISM06 TYPE STRING,
I_ABRUE TYPE STRING,
I_BEARZ TYPE STRING,
I_DFZ TYPE STRING,
I_DFZ_EX TYPE STRING,
I_DLZ TYPE STRING,
I_DLZ_EX TYPE STRING,
I_RUEST TYPE STRING,
KABRS TYPE STRING,
KBEAS TYPE STRING,
KEINH TYPE STRING,
KRUES TYPE STRING,
LIEGZ TYPE STRING,
LIGZE TYPE STRING,
LMNGA TYPE STRING,
LOGRP TYPE STRING,
MEINH TYPE STRING,
MGVRG TYPE STRING,
PERNR TYPE STRING,
QUALF TYPE STRING,
RMNGA TYPE STRING,
RSTZE TYPE STRING,
RUEST TYPE STRING,
R_TAB TYPE STRING,
SMNG1 TYPE STRING,
SMNG2 TYPE STRING,
SMNG3 TYPE STRING,
SMNG4 TYPE STRING,
SMNG5 TYPE STRING,
SMNG6 TYPE STRING,
SSADD TYPE STRING,
SSAVD TYPE STRING,
SSEDD TYPE STRING,
S_DFZ TYPE STRING,
S_DFZ_EX TYPE STRING,
S_DLZ TYPE STRING,
S_DLZ_EX TYPE STRING,
TRANZ TYPE STRING,
TRAZE TYPE STRING,
UVORN TYPE STRING,
VGE01 TYPE STRING,
VGE02 TYPE STRING,
VGE03 TYPE STRING,
VGE04 TYPE STRING,
VGE05 TYPE STRING,
VGE06 TYPE STRING,
VORNR TYPE STRING,
WARTZ TYPE STRING,
WERKS TYPE STRING,
WRTZE TYPE STRING,
XMNGA TYPE STRING,
ZGR01 TYPE STRING,
ZGR02 TYPE STRING,
ZGR03 TYPE STRING,
ZGR04 TYPE STRING,
ZGR05 TYPE STRING,
ZGR06 TYPE STRING,
ZMNG1 TYPE STRING,
ZMNG1OZ TYPE STRING,
ZMNG2 TYPE STRING,
ZMNG2OZ TYPE STRING,
ZMNG3 TYPE STRING,
ZMNG3OZ TYPE STRING,
ZMNG4 TYPE STRING,
ZMNG4OZ TYPE STRING,
ZMNG5 TYPE STRING,
ZMNG5OZ TYPE STRING,
ZMNG6 TYPE STRING,
ZMNG6OZ TYPE STRING,
Z_TAB TYPE STRING,END OF T_EKKO_STR. DATA: WA_MC04P_3ARB_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_MC04P_3ARB_STR-ABRUE sy-vline
WA_MC04P_3ARB_STR-ARBPL sy-vline
WA_MC04P_3ARB_STR-ARUZE sy-vline
WA_MC04P_3ARB_STR-ASVRG sy-vline
WA_MC04P_3ARB_STR-A_TAB sy-vline
WA_MC04P_3ARB_STR-BEARZ sy-vline
WA_MC04P_3ARB_STR-BEAZE sy-vline
WA_MC04P_3ARB_STR-BUDAT sy-vline
WA_MC04P_3ARB_STR-DFZEH sy-vline
WA_MC04P_3ARB_STR-DFZEXEH sy-vline
WA_MC04P_3ARB_STR-FSAVD sy-vline
WA_MC04P_3ARB_STR-FSEDD sy-vline
WA_MC04P_3ARB_STR-GMNGA sy-vline
WA_MC04P_3ARB_STR-GRUND sy-vline
WA_MC04P_3ARB_STR-IADD sy-vline
WA_MC04P_3ARB_STR-IEAVD sy-vline
WA_MC04P_3ARB_STR-IEDD sy-vline
WA_MC04P_3ARB_STR-ILE01 sy-vline
WA_MC04P_3ARB_STR-ILE02 sy-vline
WA_MC04P_3ARB_STR-ILE03 sy-vline
WA_MC04P_3ARB_STR-ILE04 sy-vline
WA_MC04P_3ARB_STR-ILE05 sy-vline
WA_MC04P_3ARB_STR-ILE06 sy-vline
WA_MC04P_3ARB_STR-ISAVD sy-vline
WA_MC04P_3ARB_STR-ISDD sy-vline
WA_MC04P_3ARB_STR-ISM01 sy-vline
WA_MC04P_3ARB_STR-ISM02 sy-vline
WA_MC04P_3ARB_STR-ISM03 sy-vline
WA_MC04P_3ARB_STR-ISM04 sy-vline
WA_MC04P_3ARB_STR-ISM05 sy-vline
WA_MC04P_3ARB_STR-ISM06 sy-vline
WA_MC04P_3ARB_STR-I_ABRUE sy-vline
WA_MC04P_3ARB_STR-I_BEARZ sy-vline
WA_MC04P_3ARB_STR-I_DFZ sy-vline
WA_MC04P_3ARB_STR-I_DFZ_EX sy-vline
WA_MC04P_3ARB_STR-I_DLZ sy-vline
WA_MC04P_3ARB_STR-I_DLZ_EX sy-vline
WA_MC04P_3ARB_STR-I_RUEST sy-vline
WA_MC04P_3ARB_STR-KABRS sy-vline
WA_MC04P_3ARB_STR-KBEAS sy-vline
WA_MC04P_3ARB_STR-KEINH sy-vline
WA_MC04P_3ARB_STR-KRUES sy-vline
WA_MC04P_3ARB_STR-LIEGZ sy-vline
WA_MC04P_3ARB_STR-LIGZE sy-vline
WA_MC04P_3ARB_STR-LMNGA sy-vline
WA_MC04P_3ARB_STR-LOGRP sy-vline
WA_MC04P_3ARB_STR-MEINH sy-vline
WA_MC04P_3ARB_STR-MGVRG sy-vline
WA_MC04P_3ARB_STR-PERNR sy-vline
WA_MC04P_3ARB_STR-QUALF sy-vline
WA_MC04P_3ARB_STR-RMNGA sy-vline
WA_MC04P_3ARB_STR-RSTZE sy-vline
WA_MC04P_3ARB_STR-RUEST sy-vline
WA_MC04P_3ARB_STR-R_TAB sy-vline
WA_MC04P_3ARB_STR-SMNG1 sy-vline
WA_MC04P_3ARB_STR-SMNG2 sy-vline
WA_MC04P_3ARB_STR-SMNG3 sy-vline
WA_MC04P_3ARB_STR-SMNG4 sy-vline
WA_MC04P_3ARB_STR-SMNG5 sy-vline
WA_MC04P_3ARB_STR-SMNG6 sy-vline
WA_MC04P_3ARB_STR-SSADD sy-vline
WA_MC04P_3ARB_STR-SSAVD sy-vline
WA_MC04P_3ARB_STR-SSEDD sy-vline
WA_MC04P_3ARB_STR-S_DFZ sy-vline
WA_MC04P_3ARB_STR-S_DFZ_EX sy-vline
WA_MC04P_3ARB_STR-S_DLZ sy-vline
WA_MC04P_3ARB_STR-S_DLZ_EX sy-vline
WA_MC04P_3ARB_STR-TRANZ sy-vline
WA_MC04P_3ARB_STR-TRAZE sy-vline
WA_MC04P_3ARB_STR-UVORN sy-vline
WA_MC04P_3ARB_STR-VGE01 sy-vline
WA_MC04P_3ARB_STR-VGE02 sy-vline
WA_MC04P_3ARB_STR-VGE03 sy-vline
WA_MC04P_3ARB_STR-VGE04 sy-vline
WA_MC04P_3ARB_STR-VGE05 sy-vline
WA_MC04P_3ARB_STR-VGE06 sy-vline
WA_MC04P_3ARB_STR-VORNR sy-vline
WA_MC04P_3ARB_STR-WARTZ sy-vline
WA_MC04P_3ARB_STR-WERKS sy-vline
WA_MC04P_3ARB_STR-WRTZE sy-vline
WA_MC04P_3ARB_STR-XMNGA sy-vline
WA_MC04P_3ARB_STR-ZGR01 sy-vline
WA_MC04P_3ARB_STR-ZGR02 sy-vline
WA_MC04P_3ARB_STR-ZGR03 sy-vline
WA_MC04P_3ARB_STR-ZGR04 sy-vline
WA_MC04P_3ARB_STR-ZGR05 sy-vline
WA_MC04P_3ARB_STR-ZGR06 sy-vline
WA_MC04P_3ARB_STR-ZMNG1 sy-vline
WA_MC04P_3ARB_STR-ZMNG1OZ sy-vline
WA_MC04P_3ARB_STR-ZMNG2 sy-vline
WA_MC04P_3ARB_STR-ZMNG2OZ sy-vline
WA_MC04P_3ARB_STR-ZMNG3 sy-vline
WA_MC04P_3ARB_STR-ZMNG3OZ sy-vline
WA_MC04P_3ARB_STR-ZMNG4 sy-vline
WA_MC04P_3ARB_STR-ZMNG4OZ sy-vline
WA_MC04P_3ARB_STR-ZMNG5 sy-vline
WA_MC04P_3ARB_STR-ZMNG5OZ sy-vline
WA_MC04P_3ARB_STR-ZMNG6 sy-vline
WA_MC04P_3ARB_STR-ZMNG6OZ sy-vline
WA_MC04P_3ARB_STR-Z_TAB sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.