ABAP Select data from SAP table E1EDD10 into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP E1EDD10 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 E1EDD10. 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 E1EDD10 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_E1EDD10 TYPE STANDARD TABLE OF E1EDD10,
      WA_E1EDD10 TYPE E1EDD10,
      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: <E1EDD10> TYPE E1EDD10.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM E1EDD10
*  INTO TABLE @DATA(IT_E1EDD102).
*--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_E1EDD10 INDEX 1 INTO DATA(WA_E1EDD102).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_E1EDD10 ASSIGNING <E1EDD10>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<E1EDD10>-MOT = 1.
<E1EDD10>-VALDAT = 1.
<E1EDD10>-DGCAO = 1.
<E1EDD10>-DGNHM = 1.
<E1EDD10>-TKUI = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_E1EDD10-DGNU, sy-vline,
  WA_E1EDD10-COLNO, sy-vline,
  WA_E1EDD10-DGRES1, sy-vline,
  WA_E1EDD10-DGRES2, sy-vline,
  WA_E1EDD10-DGRES3, sy-vline,
  WA_E1EDD10-DGREMP, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_E1EDD10 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_E1EDD10 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_E1EDD10 INTO WA_E1EDD10.


*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.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_E1EDD10_STR, 
MOT TYPE STRING,
VALDAT TYPE STRING,
DGCAO TYPE STRING,
DGNHM TYPE STRING,
TKUI TYPE STRING,
DGNU TYPE STRING,
COLNO TYPE STRING,
DGRES1 TYPE STRING,
DGRES2 TYPE STRING,
DGRES3 TYPE STRING,
DGREMP TYPE STRING,
DGRERQ TYPE STRING,
DGCL TYPE STRING,
DGSC TYPE STRING,
SDBC TYPE STRING,
SLBE TYPE STRING,
LDBC TYPE STRING,
LWDG TYPE STRING,
EINU TYPE STRING,
EICN TYPE STRING,
EMSN1 TYPE STRING,
EMSN2 TYPE STRING,
MFAG1 TYPE STRING,
MFAG2 TYPE STRING,
HQTU TYPE STRING,
HQTUN TYPE STRING,
PIN TYPE STRING,
PINLQ TYPE STRING,
PGRO TYPE STRING,
HNU TYPE STRING,
HPN1 TYPE STRING,
HPN2 TYPE STRING,
HPN3 TYPE STRING,
HPN4 TYPE STRING,
HPN5 TYPE STRING,
HPN6 TYPE STRING,
HPN7 TYPE STRING,
LAB1 TYPE STRING,
LAB2 TYPE STRING,
LAB3 TYPE STRING,
LAB4 TYPE STRING,
LAB5 TYPE STRING,
LAB6 TYPE STRING,
LAB7 TYPE STRING,
LAB8 TYPE STRING,
LAB9 TYPE STRING,
LAB10 TYPE STRING,
PBI TYPE STRING,
DGPTA TYPE STRING,
NHME TYPE STRING,
DGSHE TYPE STRING,
PIMDG TYPE STRING,
SPPRO TYPE STRING,
MAPOL TYPE STRING,
EXCEP TYPE STRING,
AGRNO TYPE STRING,
REGNO TYPE STRING,
SDGCL TYPE STRING,
TDGCL TYPE STRING,
LWDGN TYPE STRING,
RVLID TYPE STRING,
MOS1 TYPE STRING,
MOS2 TYPE STRING,
MOS3 TYPE STRING,
MOS4 TYPE STRING,
MOS5 TYPE STRING,
MOS6 TYPE STRING,
MOS7 TYPE STRING,
MOS8 TYPE STRING,
MOS9 TYPE STRING,
MOSA TYPE STRING,
DGTNA TYPE STRING,
DGWOS TYPE STRING,
SCASE TYPE STRING,
EIMDG TYPE STRING,
MSEPR1 TYPE STRING,
MSEPR2 TYPE STRING,
MSEPR3 TYPE STRING,
MSEPR4 TYPE STRING,
MSEPR5 TYPE STRING,
MSEPR6 TYPE STRING,
MSEPR7 TYPE STRING,
MSEPR8 TYPE STRING,
MSEPR9 TYPE STRING,
MSEPRA TYPE STRING,
MSEPRB TYPE STRING,
MSEPRC TYPE STRING,
MSEPRD TYPE STRING,
MSEPRE TYPE STRING,
MSEPRF TYPE STRING,
MSEPRG TYPE STRING,
MSEPRH TYPE STRING,
MLOAR1 TYPE STRING,
MLOAR2 TYPE STRING,
MLOAR3 TYPE STRING,
MLOAR4 TYPE STRING,
MLOAR5 TYPE STRING,
MLOAR6 TYPE STRING,
MLOAR7 TYPE STRING,
MLOAR8 TYPE STRING,
MLOAR9 TYPE STRING,
MLOARA TYPE STRING,
RSMLG1 TYPE STRING,
RSMLG2 TYPE STRING,
RSMLG3 TYPE STRING,
ESMLG1 TYPE STRING,
ESMLG2 TYPE STRING,
ESMLG3 TYPE STRING,
PPDG1 TYPE STRING,
PPDG2 TYPE STRING,
PPDG3 TYPE STRING,
PPDG4 TYPE STRING,
PPDG5 TYPE STRING,
PPDG6 TYPE STRING,
PPDG7 TYPE STRING,
PPDG8 TYPE STRING,
PPDG9 TYPE STRING,
PPDGA TYPE STRING,
PPDGB TYPE STRING,
PPDGC TYPE STRING,
PPDGE TYPE STRING,
PPDGF TYPE STRING,
PPDGG TYPE STRING,
LFDNR TYPE STRING,
SUBPOS_NR TYPE STRING,
DG_NET_WEIGHT TYPE STRING,
DG_GROSS_WEIGHT TYPE STRING,
DG_WEIGHT_U TYPE STRING,
LANGU TYPE STRING,END OF T_EKKO_STR.
DATA: WA_E1EDD10_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_E1EDD10_STR-MOT sy-vline 
WA_E1EDD10_STR-VALDAT sy-vline 
WA_E1EDD10_STR-DGCAO sy-vline 
WA_E1EDD10_STR-DGNHM sy-vline 
WA_E1EDD10_STR-TKUI sy-vline 
WA_E1EDD10_STR-DGNU sy-vline 
WA_E1EDD10_STR-COLNO sy-vline 
WA_E1EDD10_STR-DGRES1 sy-vline 
WA_E1EDD10_STR-DGRES2 sy-vline 
WA_E1EDD10_STR-DGRES3 sy-vline 
WA_E1EDD10_STR-DGREMP sy-vline 
WA_E1EDD10_STR-DGRERQ sy-vline 
WA_E1EDD10_STR-DGCL sy-vline 
WA_E1EDD10_STR-DGSC sy-vline 
WA_E1EDD10_STR-SDBC sy-vline 
WA_E1EDD10_STR-SLBE sy-vline 
WA_E1EDD10_STR-LDBC sy-vline 
WA_E1EDD10_STR-LWDG sy-vline 
WA_E1EDD10_STR-EINU sy-vline 
WA_E1EDD10_STR-EICN sy-vline 
WA_E1EDD10_STR-EMSN1 sy-vline 
WA_E1EDD10_STR-EMSN2 sy-vline 
WA_E1EDD10_STR-MFAG1 sy-vline 
WA_E1EDD10_STR-MFAG2 sy-vline 
WA_E1EDD10_STR-HQTU sy-vline 
WA_E1EDD10_STR-HQTUN sy-vline 
WA_E1EDD10_STR-PIN sy-vline 
WA_E1EDD10_STR-PINLQ sy-vline 
WA_E1EDD10_STR-PGRO sy-vline 
WA_E1EDD10_STR-HNU sy-vline 
WA_E1EDD10_STR-HPN1 sy-vline 
WA_E1EDD10_STR-HPN2 sy-vline 
WA_E1EDD10_STR-HPN3 sy-vline 
WA_E1EDD10_STR-HPN4 sy-vline 
WA_E1EDD10_STR-HPN5 sy-vline 
WA_E1EDD10_STR-HPN6 sy-vline 
WA_E1EDD10_STR-HPN7 sy-vline 
WA_E1EDD10_STR-LAB1 sy-vline 
WA_E1EDD10_STR-LAB2 sy-vline 
WA_E1EDD10_STR-LAB3 sy-vline 
WA_E1EDD10_STR-LAB4 sy-vline 
WA_E1EDD10_STR-LAB5 sy-vline 
WA_E1EDD10_STR-LAB6 sy-vline 
WA_E1EDD10_STR-LAB7 sy-vline 
WA_E1EDD10_STR-LAB8 sy-vline 
WA_E1EDD10_STR-LAB9 sy-vline 
WA_E1EDD10_STR-LAB10 sy-vline 
WA_E1EDD10_STR-PBI sy-vline 
WA_E1EDD10_STR-DGPTA sy-vline 
WA_E1EDD10_STR-NHME sy-vline 
WA_E1EDD10_STR-DGSHE sy-vline 
WA_E1EDD10_STR-PIMDG sy-vline 
WA_E1EDD10_STR-SPPRO sy-vline 
WA_E1EDD10_STR-MAPOL sy-vline 
WA_E1EDD10_STR-EXCEP sy-vline 
WA_E1EDD10_STR-AGRNO sy-vline 
WA_E1EDD10_STR-REGNO sy-vline 
WA_E1EDD10_STR-SDGCL sy-vline 
WA_E1EDD10_STR-TDGCL sy-vline 
WA_E1EDD10_STR-LWDGN sy-vline 
WA_E1EDD10_STR-RVLID sy-vline 
WA_E1EDD10_STR-MOS1 sy-vline 
WA_E1EDD10_STR-MOS2 sy-vline 
WA_E1EDD10_STR-MOS3 sy-vline 
WA_E1EDD10_STR-MOS4 sy-vline 
WA_E1EDD10_STR-MOS5 sy-vline 
WA_E1EDD10_STR-MOS6 sy-vline 
WA_E1EDD10_STR-MOS7 sy-vline 
WA_E1EDD10_STR-MOS8 sy-vline 
WA_E1EDD10_STR-MOS9 sy-vline 
WA_E1EDD10_STR-MOSA sy-vline 
WA_E1EDD10_STR-DGTNA sy-vline 
WA_E1EDD10_STR-DGWOS sy-vline 
WA_E1EDD10_STR-SCASE sy-vline 
WA_E1EDD10_STR-EIMDG sy-vline 
WA_E1EDD10_STR-MSEPR1 sy-vline 
WA_E1EDD10_STR-MSEPR2 sy-vline 
WA_E1EDD10_STR-MSEPR3 sy-vline 
WA_E1EDD10_STR-MSEPR4 sy-vline 
WA_E1EDD10_STR-MSEPR5 sy-vline 
WA_E1EDD10_STR-MSEPR6 sy-vline 
WA_E1EDD10_STR-MSEPR7 sy-vline 
WA_E1EDD10_STR-MSEPR8 sy-vline 
WA_E1EDD10_STR-MSEPR9 sy-vline 
WA_E1EDD10_STR-MSEPRA sy-vline 
WA_E1EDD10_STR-MSEPRB sy-vline 
WA_E1EDD10_STR-MSEPRC sy-vline 
WA_E1EDD10_STR-MSEPRD sy-vline 
WA_E1EDD10_STR-MSEPRE sy-vline 
WA_E1EDD10_STR-MSEPRF sy-vline 
WA_E1EDD10_STR-MSEPRG sy-vline 
WA_E1EDD10_STR-MSEPRH sy-vline 
WA_E1EDD10_STR-MLOAR1 sy-vline 
WA_E1EDD10_STR-MLOAR2 sy-vline 
WA_E1EDD10_STR-MLOAR3 sy-vline 
WA_E1EDD10_STR-MLOAR4 sy-vline 
WA_E1EDD10_STR-MLOAR5 sy-vline 
WA_E1EDD10_STR-MLOAR6 sy-vline 
WA_E1EDD10_STR-MLOAR7 sy-vline 
WA_E1EDD10_STR-MLOAR8 sy-vline 
WA_E1EDD10_STR-MLOAR9 sy-vline 
WA_E1EDD10_STR-MLOARA sy-vline 
WA_E1EDD10_STR-RSMLG1 sy-vline 
WA_E1EDD10_STR-RSMLG2 sy-vline 
WA_E1EDD10_STR-RSMLG3 sy-vline 
WA_E1EDD10_STR-ESMLG1 sy-vline 
WA_E1EDD10_STR-ESMLG2 sy-vline 
WA_E1EDD10_STR-ESMLG3 sy-vline 
WA_E1EDD10_STR-PPDG1 sy-vline 
WA_E1EDD10_STR-PPDG2 sy-vline 
WA_E1EDD10_STR-PPDG3 sy-vline 
WA_E1EDD10_STR-PPDG4 sy-vline 
WA_E1EDD10_STR-PPDG5 sy-vline 
WA_E1EDD10_STR-PPDG6 sy-vline 
WA_E1EDD10_STR-PPDG7 sy-vline 
WA_E1EDD10_STR-PPDG8 sy-vline 
WA_E1EDD10_STR-PPDG9 sy-vline 
WA_E1EDD10_STR-PPDGA sy-vline 
WA_E1EDD10_STR-PPDGB sy-vline 
WA_E1EDD10_STR-PPDGC sy-vline 
WA_E1EDD10_STR-PPDGE sy-vline 
WA_E1EDD10_STR-PPDGF sy-vline 
WA_E1EDD10_STR-PPDGG sy-vline 
WA_E1EDD10_STR-LFDNR sy-vline 
WA_E1EDD10_STR-SUBPOS_NR sy-vline 
WA_E1EDD10_STR-DG_NET_WEIGHT sy-vline 
WA_E1EDD10_STR-DG_GROSS_WEIGHT sy-vline 
WA_E1EDD10_STR-DG_WEIGHT_U sy-vline 
WA_E1EDD10_STR-LANGU sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.