ABAP Select data from SAP table E1IST_COACC 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 E1IST_COACC 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 E1IST_COACC. 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 E1IST_COACC 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_E1IST_COACC TYPE STANDARD TABLE OF E1IST_COACC,
      WA_E1IST_COACC TYPE E1IST_COACC,
      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: <E1IST_COACC> TYPE E1IST_COACC.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM E1IST_COACC
*  INTO TABLE @DATA(IT_E1IST_COACC2).
*--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_E1IST_COACC INDEX 1 INTO DATA(WA_E1IST_COACC2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<E1IST_COACC>-MANDT = 1.
<E1IST_COACC>-VKONT = 1.
<E1IST_COACC>-GPART = 1.
<E1IST_COACC>-VKBEZ = 1.
<E1IST_COACC>-ERDAT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_E1IST_COACC-ERNAM, sy-vline,
  WA_E1IST_COACC-AEDATP, sy-vline,
  WA_E1IST_COACC-AENAMP, sy-vline,
  WA_E1IST_COACC-FDZTG, sy-vline,
  WA_E1IST_COACC-STOPD, sy-vline,
  WA_E1IST_COACC-QSZDT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_E1IST_COACC 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_E1IST_COACC 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_E1IST_COACC INTO WA_E1IST_COACC.


*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_E1IST_COACC_STR, 
MANDT TYPE STRING,
VKONT TYPE STRING,
GPART TYPE STRING,
VKBEZ TYPE STRING,
ERDAT TYPE STRING,
ERNAM TYPE STRING,
AEDATP TYPE STRING,
AENAMP TYPE STRING,
FDZTG TYPE STRING,
STOPD TYPE STRING,
QSZDT TYPE STRING,
EXVKO TYPE STRING,
OPBUK TYPE STRING,
ABWRE TYPE STRING,
ABWRA TYPE STRING,
ABWMA TYPE STRING,
EBVTY TYPE STRING,
ABVTY TYPE STRING,
EZAWE TYPE STRING,
EZASP TYPE STRING,
AZAWE TYPE STRING,
AZASP TYPE STRING,
VWNZA TYPE STRING,
LOEVM TYPE STRING,
ABWVK TYPE STRING,
IKEY TYPE STRING,
MAHNV TYPE STRING,
MANSP TYPE STRING,
MGRUP TYPE STRING,
FDGRP TYPE STRING,
VKPBZ TYPE STRING,
ADRNB TYPE STRING,
VKONV TYPE STRING,
ADRRE TYPE STRING,
ADRRA TYPE STRING,
ADRMA TYPE STRING,
ABWRH TYPE STRING,
ADRRH TYPE STRING,
ADRJDC TYPE STRING,
BEGRU TYPE STRING,
TOGRU TYPE STRING,
STOPG TYPE STRING,
TXJCD TYPE STRING,
COPRC TYPE STRING,
VBUND TYPE STRING,
CCARD_ID TYPE STRING,
CCARD_OUT TYPE STRING,
UEBTR TYPE STRING,
DEF_REC TYPE STRING,
DEF_REC_IND TYPE STRING,
QSSKZ_A TYPE STRING,
QSSKZ_E TYPE STRING,
QSZNR TYPE STRING,
CORR_MAHNV TYPE STRING,
FITYP TYPE STRING,
PROVINCE TYPE STRING,
COUNTY TYPE STRING,
VERTYP TYPE STRING,
ZAHLKOND TYPE STRING,
DAUBUCH TYPE STRING,
KEINZAHL TYPE STRING,
VERGUETG TYPE STRING,
EINZUGSZ TYPE STRING,
RUECKLZ TYPE STRING,
TWAERS_ISO TYPE STRING,
KOFIZ_SD TYPE STRING,
KTOKL TYPE STRING,
MAHNUNG_Z TYPE STRING,
RECHNUNG_Z TYPE STRING,
FORMKEY TYPE STRING,
LANGU_ISO TYPE STRING,
AUSGRUP_IN TYPE STRING,
OUTCOUNT TYPE STRING,
MANOUTS_IN TYPE STRING,
INT_INVOICE TYPE STRING,
GSBER TYPE STRING,
DATE_FROM_ACC TYPE STRING,
SENDCONTROL_MA TYPE STRING,
SENDCONTROL_RH TYPE STRING,
SENDCONTROL_GP TYPE STRING,
REGIOGR_CA_T TYPE STRING,
REGIOGR_CA_B TYPE STRING,
KZABSVER TYPE STRING,
JVLTE TYPE STRING,
PADEP TYPE STRING,
PAVER TYPE STRING,
PAABA TYPE STRING,
COVAR TYPE STRING,
COVWE TYPE STRING,
EXRYT TYPE STRING,
DEXBT TYPE STRING,
PAINR TYPE STRING,
PAIND TYPE STRING,
PAABD TYPE STRING,
MVARI TYPE STRING,
CB_GPART TYPE STRING,
CB_VKONT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_E1IST_COACC_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_E1IST_COACC_STR-MANDT sy-vline 
WA_E1IST_COACC_STR-VKONT sy-vline 
WA_E1IST_COACC_STR-GPART sy-vline 
WA_E1IST_COACC_STR-VKBEZ sy-vline 
WA_E1IST_COACC_STR-ERDAT sy-vline 
WA_E1IST_COACC_STR-ERNAM sy-vline 
WA_E1IST_COACC_STR-AEDATP sy-vline 
WA_E1IST_COACC_STR-AENAMP sy-vline 
WA_E1IST_COACC_STR-FDZTG sy-vline 
WA_E1IST_COACC_STR-STOPD sy-vline 
WA_E1IST_COACC_STR-QSZDT sy-vline 
WA_E1IST_COACC_STR-EXVKO sy-vline 
WA_E1IST_COACC_STR-OPBUK sy-vline 
WA_E1IST_COACC_STR-ABWRE sy-vline 
WA_E1IST_COACC_STR-ABWRA sy-vline 
WA_E1IST_COACC_STR-ABWMA sy-vline 
WA_E1IST_COACC_STR-EBVTY sy-vline 
WA_E1IST_COACC_STR-ABVTY sy-vline 
WA_E1IST_COACC_STR-EZAWE sy-vline 
WA_E1IST_COACC_STR-EZASP sy-vline 
WA_E1IST_COACC_STR-AZAWE sy-vline 
WA_E1IST_COACC_STR-AZASP sy-vline 
WA_E1IST_COACC_STR-VWNZA sy-vline 
WA_E1IST_COACC_STR-LOEVM sy-vline 
WA_E1IST_COACC_STR-ABWVK sy-vline 
WA_E1IST_COACC_STR-IKEY sy-vline 
WA_E1IST_COACC_STR-MAHNV sy-vline 
WA_E1IST_COACC_STR-MANSP sy-vline 
WA_E1IST_COACC_STR-MGRUP sy-vline 
WA_E1IST_COACC_STR-FDGRP sy-vline 
WA_E1IST_COACC_STR-VKPBZ sy-vline 
WA_E1IST_COACC_STR-ADRNB sy-vline 
WA_E1IST_COACC_STR-VKONV sy-vline 
WA_E1IST_COACC_STR-ADRRE sy-vline 
WA_E1IST_COACC_STR-ADRRA sy-vline 
WA_E1IST_COACC_STR-ADRMA sy-vline 
WA_E1IST_COACC_STR-ABWRH sy-vline 
WA_E1IST_COACC_STR-ADRRH sy-vline 
WA_E1IST_COACC_STR-ADRJDC sy-vline 
WA_E1IST_COACC_STR-BEGRU sy-vline 
WA_E1IST_COACC_STR-TOGRU sy-vline 
WA_E1IST_COACC_STR-STOPG sy-vline 
WA_E1IST_COACC_STR-TXJCD sy-vline 
WA_E1IST_COACC_STR-COPRC sy-vline 
WA_E1IST_COACC_STR-VBUND sy-vline 
WA_E1IST_COACC_STR-CCARD_ID sy-vline 
WA_E1IST_COACC_STR-CCARD_OUT sy-vline 
WA_E1IST_COACC_STR-UEBTR sy-vline 
WA_E1IST_COACC_STR-DEF_REC sy-vline 
WA_E1IST_COACC_STR-DEF_REC_IND sy-vline 
WA_E1IST_COACC_STR-QSSKZ_A sy-vline 
WA_E1IST_COACC_STR-QSSKZ_E sy-vline 
WA_E1IST_COACC_STR-QSZNR sy-vline 
WA_E1IST_COACC_STR-CORR_MAHNV sy-vline 
WA_E1IST_COACC_STR-FITYP sy-vline 
WA_E1IST_COACC_STR-PROVINCE sy-vline 
WA_E1IST_COACC_STR-COUNTY sy-vline 
WA_E1IST_COACC_STR-VERTYP sy-vline 
WA_E1IST_COACC_STR-ZAHLKOND sy-vline 
WA_E1IST_COACC_STR-DAUBUCH sy-vline 
WA_E1IST_COACC_STR-KEINZAHL sy-vline 
WA_E1IST_COACC_STR-VERGUETG sy-vline 
WA_E1IST_COACC_STR-EINZUGSZ sy-vline 
WA_E1IST_COACC_STR-RUECKLZ sy-vline 
WA_E1IST_COACC_STR-TWAERS_ISO sy-vline 
WA_E1IST_COACC_STR-KOFIZ_SD sy-vline 
WA_E1IST_COACC_STR-KTOKL sy-vline 
WA_E1IST_COACC_STR-MAHNUNG_Z sy-vline 
WA_E1IST_COACC_STR-RECHNUNG_Z sy-vline 
WA_E1IST_COACC_STR-FORMKEY sy-vline 
WA_E1IST_COACC_STR-LANGU_ISO sy-vline 
WA_E1IST_COACC_STR-AUSGRUP_IN sy-vline 
WA_E1IST_COACC_STR-OUTCOUNT sy-vline 
WA_E1IST_COACC_STR-MANOUTS_IN sy-vline 
WA_E1IST_COACC_STR-INT_INVOICE sy-vline 
WA_E1IST_COACC_STR-GSBER sy-vline 
WA_E1IST_COACC_STR-DATE_FROM_ACC sy-vline 
WA_E1IST_COACC_STR-SENDCONTROL_MA sy-vline 
WA_E1IST_COACC_STR-SENDCONTROL_RH sy-vline 
WA_E1IST_COACC_STR-SENDCONTROL_GP sy-vline 
WA_E1IST_COACC_STR-REGIOGR_CA_T sy-vline 
WA_E1IST_COACC_STR-REGIOGR_CA_B sy-vline 
WA_E1IST_COACC_STR-KZABSVER sy-vline 
WA_E1IST_COACC_STR-JVLTE sy-vline 
WA_E1IST_COACC_STR-PADEP sy-vline 
WA_E1IST_COACC_STR-PAVER sy-vline 
WA_E1IST_COACC_STR-PAABA sy-vline 
WA_E1IST_COACC_STR-COVAR sy-vline 
WA_E1IST_COACC_STR-COVWE sy-vline 
WA_E1IST_COACC_STR-EXRYT sy-vline 
WA_E1IST_COACC_STR-DEXBT sy-vline 
WA_E1IST_COACC_STR-PAINR sy-vline 
WA_E1IST_COACC_STR-PAIND sy-vline 
WA_E1IST_COACC_STR-PAABD sy-vline 
WA_E1IST_COACC_STR-MVARI sy-vline 
WA_E1IST_COACC_STR-CB_GPART sy-vline 
WA_E1IST_COACC_STR-CB_VKONT sy-vline      INTO ld_text SEPARATED BY SPACE.

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