ABAP Select data from SAP table OI0_IFEKPOOAITEX 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 OI0_IFEKPOOAITEX 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 OI0_IFEKPOOAITEX. 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 OI0_IFEKPOOAITEX 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_OI0_IFEKPOOAITEX TYPE STANDARD TABLE OF OI0_IFEKPOOAITEX,
      WA_OI0_IFEKPOOAITEX TYPE OI0_IFEKPOOAITEX,
      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: <OI0_IFEKPOOAITEX> TYPE OI0_IFEKPOOAITEX.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM OI0_IFEKPOOAITEX
*  INTO TABLE @DATA(IT_OI0_IFEKPOOAITEX2).
*--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_OI0_IFEKPOOAITEX INDEX 1 INTO DATA(WA_OI0_IFEKPOOAITEX2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<OI0_IFEKPOOAITEX>-EBELP = 1.
<OI0_IFEKPOOAITEX>-LOEKZ = 1.
<OI0_IFEKPOOAITEX>-TXZ01 = 1.
<OI0_IFEKPOOAITEX>-MATNR = 1.
<OI0_IFEKPOOAITEX>-EMATN = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_OI0_IFEKPOOAITEX-WERKS, sy-vline,
  WA_OI0_IFEKPOOAITEX-LGORT, sy-vline,
  WA_OI0_IFEKPOOAITEX-BEDNR, sy-vline,
  WA_OI0_IFEKPOOAITEX-MATKL, sy-vline,
  WA_OI0_IFEKPOOAITEX-INFNR, sy-vline,
  WA_OI0_IFEKPOOAITEX-IDNLF, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_OI0_IFEKPOOAITEX 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_OI0_IFEKPOOAITEX 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_OI0_IFEKPOOAITEX INTO WA_OI0_IFEKPOOAITEX.


*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_OI0_IFEKPOOAITEX_STR, 
EBELP TYPE STRING,
LOEKZ TYPE STRING,
TXZ01 TYPE STRING,
MATNR TYPE STRING,
EMATN TYPE STRING,
WERKS TYPE STRING,
LGORT TYPE STRING,
BEDNR TYPE STRING,
MATKL TYPE STRING,
INFNR TYPE STRING,
IDNLF TYPE STRING,
KTMNG TYPE STRING,
MEINS TYPE STRING,
BPRME TYPE STRING,
BPUMZ TYPE STRING,
BPUMN TYPE STRING,
NETPR TYPE STRING,
PEINH TYPE STRING,
WEBAZ TYPE STRING,
MWSKZ TYPE STRING,
BONUS TYPE STRING,
INSMK TYPE STRING,
SPINF TYPE STRING,
PRSDR TYPE STRING,
SCHPR TYPE STRING,
MAHN1 TYPE STRING,
MAHN2 TYPE STRING,
MAHN3 TYPE STRING,
UEBTO TYPE STRING,
UEBTK TYPE STRING,
UNTTO TYPE STRING,
BWTAR TYPE STRING,
PSTYP TYPE STRING,
KNTTP TYPE STRING,
VRTKZ TYPE STRING,
TWRKZ TYPE STRING,
WEPOS TYPE STRING,
WEUNB TYPE STRING,
REPOS TYPE STRING,
WEBRE TYPE STRING,
KZABS TYPE STRING,
LABNR TYPE STRING,
KONNR TYPE STRING,
KTPNR TYPE STRING,
EVERS TYPE STRING,
KUNNR TYPE STRING,
EKKOL TYPE STRING,
SKTOF TYPE STRING,
PLIFZ TYPE STRING,
NTGEW TYPE STRING,
GEWEI TYPE STRING,
TXJCD TYPE STRING,
SSQSS TYPE STRING,
BSTAE TYPE STRING,
REVLV TYPE STRING,
GEBER TYPE STRING,
FISTL TYPE STRING,
FIPOS TYPE STRING,
MEPRF TYPE STRING,
PRDAT TYPE STRING,
BRGEW TYPE STRING,
VOLUM TYPE STRING,
VOLEH TYPE STRING,
INCO1 TYPE STRING,
INCO2 TYPE STRING,
KOLIF TYPE STRING,
LTSNR TYPE STRING,
UEBPO TYPE STRING,
LEWED TYPE STRING,
EMLIF TYPE STRING,
LBLKZ TYPE STRING,
KANBA TYPE STRING,
XERSY TYPE STRING,
AKTNR TYPE STRING,
ANZPU TYPE STRING,
PUNEI TYPE STRING,
SAISO TYPE STRING,
SAISJ TYPE STRING,
EBON2 TYPE STRING,
EBON3 TYPE STRING,
EBONF TYPE STRING,
MHDRZ TYPE STRING,
ANFNR TYPE STRING,
ANFPS TYPE STRING,
BANFN TYPE STRING,
BNFPO TYPE STRING,
REFBS TYPE STRING,
REFPS TYPE STRING,
UPTYP TYPE STRING,
RETPO TYPE STRING,
AUREL TYPE STRING,
BSGRU TYPE STRING,
OID_EXTBOL TYPE STRING,
OID_MISCDL TYPE STRING,
OIC_LIFNR TYPE STRING,
OIC_DCITYC TYPE STRING,
OIC_DCOUNC TYPE STRING,
OIC_DREGIO TYPE STRING,
OIC_DLAND1 TYPE STRING,
OIC_OCITYC TYPE STRING,
OIC_OCOUNC TYPE STRING,
OIC_OREGIO TYPE STRING,
OIC_OLAND1 TYPE STRING,
OIC_PORGIN TYPE STRING,
OIC_PDESTN TYPE STRING,
OIC_PTRIP TYPE STRING,
OIC_PBATCH TYPE STRING,
OIC_MOT TYPE STRING,
OIC_AORGIN TYPE STRING,
OIC_ADESTN TYPE STRING,
OIC_TRUCKN TYPE STRING,
OIHANTYP TYPE STRING,
OIINEX TYPE STRING,
OIA_BASELO TYPE STRING,
OIFEEDT TYPE STRING,
OINETCYC TYPE STRING,
OISBREL TYPE STRING,
OIBASPROD TYPE STRING,
OIMATCYC TYPE STRING,END OF T_EKKO_STR.
DATA: WA_OI0_IFEKPOOAITEX_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_OI0_IFEKPOOAITEX_STR-EBELP sy-vline 
WA_OI0_IFEKPOOAITEX_STR-LOEKZ sy-vline 
WA_OI0_IFEKPOOAITEX_STR-TXZ01 sy-vline 
WA_OI0_IFEKPOOAITEX_STR-MATNR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-EMATN sy-vline 
WA_OI0_IFEKPOOAITEX_STR-WERKS sy-vline 
WA_OI0_IFEKPOOAITEX_STR-LGORT sy-vline 
WA_OI0_IFEKPOOAITEX_STR-BEDNR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-MATKL sy-vline 
WA_OI0_IFEKPOOAITEX_STR-INFNR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-IDNLF sy-vline 
WA_OI0_IFEKPOOAITEX_STR-KTMNG sy-vline 
WA_OI0_IFEKPOOAITEX_STR-MEINS sy-vline 
WA_OI0_IFEKPOOAITEX_STR-BPRME sy-vline 
WA_OI0_IFEKPOOAITEX_STR-BPUMZ sy-vline 
WA_OI0_IFEKPOOAITEX_STR-BPUMN sy-vline 
WA_OI0_IFEKPOOAITEX_STR-NETPR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-PEINH sy-vline 
WA_OI0_IFEKPOOAITEX_STR-WEBAZ sy-vline 
WA_OI0_IFEKPOOAITEX_STR-MWSKZ sy-vline 
WA_OI0_IFEKPOOAITEX_STR-BONUS sy-vline 
WA_OI0_IFEKPOOAITEX_STR-INSMK sy-vline 
WA_OI0_IFEKPOOAITEX_STR-SPINF sy-vline 
WA_OI0_IFEKPOOAITEX_STR-PRSDR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-SCHPR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-MAHN1 sy-vline 
WA_OI0_IFEKPOOAITEX_STR-MAHN2 sy-vline 
WA_OI0_IFEKPOOAITEX_STR-MAHN3 sy-vline 
WA_OI0_IFEKPOOAITEX_STR-UEBTO sy-vline 
WA_OI0_IFEKPOOAITEX_STR-UEBTK sy-vline 
WA_OI0_IFEKPOOAITEX_STR-UNTTO sy-vline 
WA_OI0_IFEKPOOAITEX_STR-BWTAR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-PSTYP sy-vline 
WA_OI0_IFEKPOOAITEX_STR-KNTTP sy-vline 
WA_OI0_IFEKPOOAITEX_STR-VRTKZ sy-vline 
WA_OI0_IFEKPOOAITEX_STR-TWRKZ sy-vline 
WA_OI0_IFEKPOOAITEX_STR-WEPOS sy-vline 
WA_OI0_IFEKPOOAITEX_STR-WEUNB sy-vline 
WA_OI0_IFEKPOOAITEX_STR-REPOS sy-vline 
WA_OI0_IFEKPOOAITEX_STR-WEBRE sy-vline 
WA_OI0_IFEKPOOAITEX_STR-KZABS sy-vline 
WA_OI0_IFEKPOOAITEX_STR-LABNR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-KONNR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-KTPNR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-EVERS sy-vline 
WA_OI0_IFEKPOOAITEX_STR-KUNNR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-EKKOL sy-vline 
WA_OI0_IFEKPOOAITEX_STR-SKTOF sy-vline 
WA_OI0_IFEKPOOAITEX_STR-PLIFZ sy-vline 
WA_OI0_IFEKPOOAITEX_STR-NTGEW sy-vline 
WA_OI0_IFEKPOOAITEX_STR-GEWEI sy-vline 
WA_OI0_IFEKPOOAITEX_STR-TXJCD sy-vline 
WA_OI0_IFEKPOOAITEX_STR-SSQSS sy-vline 
WA_OI0_IFEKPOOAITEX_STR-BSTAE sy-vline 
WA_OI0_IFEKPOOAITEX_STR-REVLV sy-vline 
WA_OI0_IFEKPOOAITEX_STR-GEBER sy-vline 
WA_OI0_IFEKPOOAITEX_STR-FISTL sy-vline 
WA_OI0_IFEKPOOAITEX_STR-FIPOS sy-vline 
WA_OI0_IFEKPOOAITEX_STR-MEPRF sy-vline 
WA_OI0_IFEKPOOAITEX_STR-PRDAT sy-vline 
WA_OI0_IFEKPOOAITEX_STR-BRGEW sy-vline 
WA_OI0_IFEKPOOAITEX_STR-VOLUM sy-vline 
WA_OI0_IFEKPOOAITEX_STR-VOLEH sy-vline 
WA_OI0_IFEKPOOAITEX_STR-INCO1 sy-vline 
WA_OI0_IFEKPOOAITEX_STR-INCO2 sy-vline 
WA_OI0_IFEKPOOAITEX_STR-KOLIF sy-vline 
WA_OI0_IFEKPOOAITEX_STR-LTSNR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-UEBPO sy-vline 
WA_OI0_IFEKPOOAITEX_STR-LEWED sy-vline 
WA_OI0_IFEKPOOAITEX_STR-EMLIF sy-vline 
WA_OI0_IFEKPOOAITEX_STR-LBLKZ sy-vline 
WA_OI0_IFEKPOOAITEX_STR-KANBA sy-vline 
WA_OI0_IFEKPOOAITEX_STR-XERSY sy-vline 
WA_OI0_IFEKPOOAITEX_STR-AKTNR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-ANZPU sy-vline 
WA_OI0_IFEKPOOAITEX_STR-PUNEI sy-vline 
WA_OI0_IFEKPOOAITEX_STR-SAISO sy-vline 
WA_OI0_IFEKPOOAITEX_STR-SAISJ sy-vline 
WA_OI0_IFEKPOOAITEX_STR-EBON2 sy-vline 
WA_OI0_IFEKPOOAITEX_STR-EBON3 sy-vline 
WA_OI0_IFEKPOOAITEX_STR-EBONF sy-vline 
WA_OI0_IFEKPOOAITEX_STR-MHDRZ sy-vline 
WA_OI0_IFEKPOOAITEX_STR-ANFNR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-ANFPS sy-vline 
WA_OI0_IFEKPOOAITEX_STR-BANFN sy-vline 
WA_OI0_IFEKPOOAITEX_STR-BNFPO sy-vline 
WA_OI0_IFEKPOOAITEX_STR-REFBS sy-vline 
WA_OI0_IFEKPOOAITEX_STR-REFPS sy-vline 
WA_OI0_IFEKPOOAITEX_STR-UPTYP sy-vline 
WA_OI0_IFEKPOOAITEX_STR-RETPO sy-vline 
WA_OI0_IFEKPOOAITEX_STR-AUREL sy-vline 
WA_OI0_IFEKPOOAITEX_STR-BSGRU sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OID_EXTBOL sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OID_MISCDL sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_LIFNR sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_DCITYC sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_DCOUNC sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_DREGIO sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_DLAND1 sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_OCITYC sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_OCOUNC sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_OREGIO sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_OLAND1 sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_PORGIN sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_PDESTN sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_PTRIP sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_PBATCH sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_MOT sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_AORGIN sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_ADESTN sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIC_TRUCKN sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIHANTYP sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIINEX sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIA_BASELO sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIFEEDT sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OINETCYC sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OISBREL sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIBASPROD sy-vline 
WA_OI0_IFEKPOOAITEX_STR-OIMATCYC sy-vline      INTO ld_text SEPARATED BY SPACE.

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