ABAP Select data from SAP table MEOUT_ITEM_DATAX 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 MEOUT_ITEM_DATAX 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 MEOUT_ITEM_DATAX. 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 MEOUT_ITEM_DATAX 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_MEOUT_ITEM_DATAX TYPE STANDARD TABLE OF MEOUT_ITEM_DATAX,
      WA_MEOUT_ITEM_DATAX TYPE MEOUT_ITEM_DATAX,
      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: <MEOUT_ITEM_DATAX> TYPE MEOUT_ITEM_DATAX.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MEOUT_ITEM_DATAX
*  INTO TABLE @DATA(IT_MEOUT_ITEM_DATAX2).
*--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_MEOUT_ITEM_DATAX INDEX 1 INTO DATA(WA_MEOUT_ITEM_DATAX2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_MEOUT_ITEM_DATAX ASSIGNING <MEOUT_ITEM_DATAX>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<MEOUT_ITEM_DATAX>-EBELN = 1.
<MEOUT_ITEM_DATAX>-EBELP = 1.
<MEOUT_ITEM_DATAX>-LOEKZ = 1.
<MEOUT_ITEM_DATAX>-TXZ01 = 1.
<MEOUT_ITEM_DATAX>-MATNR = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MEOUT_ITEM_DATAX-EMATN, sy-vline,
WA_MEOUT_ITEM_DATAX-WERKS, sy-vline,
WA_MEOUT_ITEM_DATAX-LGORT, sy-vline,
WA_MEOUT_ITEM_DATAX-BEDNR, sy-vline,
WA_MEOUT_ITEM_DATAX-MATKL, sy-vline,
WA_MEOUT_ITEM_DATAX-INFNR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_MEOUT_ITEM_DATAX 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_MEOUT_ITEM_DATAX 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_MEOUT_ITEM_DATAX INTO WA_MEOUT_ITEM_DATAX. *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_MEOUT_ITEM_DATAX_STR,
EBELN TYPE STRING,
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,
ABMNG TYPE STRING,
BPRME TYPE STRING,
BPUMZ TYPE STRING,
BPUMN TYPE STRING,
NETPR TYPE STRING,
PEINH TYPE STRING,
TARGET_VALUE TYPE STRING,
EXTMATERIALFORPURG TYPE STRING,
WEBAZ TYPE STRING,
MWSKZ TYPE STRING,
TXDAT_FROM TYPE STRING,
TXDAT TYPE STRING,
TAX_COUNTRY 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,
ELIKZ TYPE STRING,
EREKZ TYPE STRING,
PSTYP TYPE STRING,
KNTTP TYPE STRING,
VRTKZ TYPE STRING,
TWRKZ TYPE STRING,
WEPOS TYPE STRING,
WEUNB TYPE STRING,
REPOS TYPE STRING,
UMSON TYPE STRING,
WEBRE TYPE STRING,
KZABS TYPE STRING,
LABNR TYPE STRING,
KONNR TYPE STRING,
KTPNR TYPE STRING,
ABDAT TYPE STRING,
ABFTZ TYPE STRING,
ETFZ1 TYPE STRING,
ETFZ2 TYPE STRING,
KZSTU TYPE STRING,
NOTKZ TYPE STRING,
EVERS TYPE STRING,
KUNNR TYPE STRING,
ADRNR 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,
ADRN2 TYPE STRING,
XERSY TYPE STRING,
EILDT 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,
AUREL TYPE STRING,
BSGRU TYPE STRING,
RETPC TYPE STRING,
J_1BNBM TYPE STRING,
J_1BMATUSE TYPE STRING,
J_1BMATORG TYPE STRING,
J_1BOWNPRO TYPE STRING,
J_1BINDUST TYPE STRING,
J_1AINDXP TYPE STRING,
J_1AIDATEP TYPE STRING,
EGLKZ TYPE STRING,
KZTLF TYPE STRING,
NOVET TYPE STRING,
AFNAM TYPE STRING,
IPRKZ TYPE STRING,
CALCTYPE TYPE STRING,
FKBER TYPE STRING,
GRANT_NBR TYPE STRING,
KBLNR TYPE STRING,
KBLPOS TYPE STRING,
LFRET TYPE STRING,
NO_ROUNDING TYPE STRING,
PO_PRICE TYPE STRING,
RESLO TYPE STRING,
ABUEB TYPE STRING,
FABKZ TYPE STRING,
APOMS TYPE STRING,
SRM_CONTRACT_ID TYPE STRING,
SRM_CONTRACT_ITM TYPE STRING,
SGT_SCAT TYPE STRING,
WEORA TYPE STRING,
INCO2_L TYPE STRING,
INCO3_L TYPE STRING,
DUMMY TYPE STRING,
ADVCODE TYPE STRING,
SOURCE_ID TYPE STRING,
SOURCE_KEY TYPE STRING,
PUT_BACK TYPE STRING,
POL_ID TYPE STRING,
REF_ITEM TYPE STRING,
BUDGET_PD TYPE STRING,
TC_AUT_DET TYPE STRING,
MANUAL_TC_REASON TYPE STRING,
FISCAL_INCENTIVE TYPE STRING,
TAX_SUBJECT_ST TYPE STRING,
FISCAL_INCENTIVE_ID TYPE STRING,
SERVICEPERFORMER TYPE STRING,
PRODUCTTYPE TYPE STRING,
MATERIALTYPE TYPE STRING,
BLK_REASON_ID TYPE STRING,
EXLIN TYPE STRING,
EXSNR TYPE STRING,END OF T_EKKO_STR. DATA: WA_MEOUT_ITEM_DATAX_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_MEOUT_ITEM_DATAX_STR-EBELN sy-vline
WA_MEOUT_ITEM_DATAX_STR-EBELP sy-vline
WA_MEOUT_ITEM_DATAX_STR-LOEKZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-TXZ01 sy-vline
WA_MEOUT_ITEM_DATAX_STR-MATNR sy-vline
WA_MEOUT_ITEM_DATAX_STR-EMATN sy-vline
WA_MEOUT_ITEM_DATAX_STR-WERKS sy-vline
WA_MEOUT_ITEM_DATAX_STR-LGORT sy-vline
WA_MEOUT_ITEM_DATAX_STR-BEDNR sy-vline
WA_MEOUT_ITEM_DATAX_STR-MATKL sy-vline
WA_MEOUT_ITEM_DATAX_STR-INFNR sy-vline
WA_MEOUT_ITEM_DATAX_STR-IDNLF sy-vline
WA_MEOUT_ITEM_DATAX_STR-KTMNG sy-vline
WA_MEOUT_ITEM_DATAX_STR-MEINS sy-vline
WA_MEOUT_ITEM_DATAX_STR-ABMNG sy-vline
WA_MEOUT_ITEM_DATAX_STR-BPRME sy-vline
WA_MEOUT_ITEM_DATAX_STR-BPUMZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-BPUMN sy-vline
WA_MEOUT_ITEM_DATAX_STR-NETPR sy-vline
WA_MEOUT_ITEM_DATAX_STR-PEINH sy-vline
WA_MEOUT_ITEM_DATAX_STR-TARGET_VALUE sy-vline
WA_MEOUT_ITEM_DATAX_STR-EXTMATERIALFORPURG sy-vline
WA_MEOUT_ITEM_DATAX_STR-WEBAZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-MWSKZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-TXDAT_FROM sy-vline
WA_MEOUT_ITEM_DATAX_STR-TXDAT sy-vline
WA_MEOUT_ITEM_DATAX_STR-TAX_COUNTRY sy-vline
WA_MEOUT_ITEM_DATAX_STR-BONUS sy-vline
WA_MEOUT_ITEM_DATAX_STR-INSMK sy-vline
WA_MEOUT_ITEM_DATAX_STR-SPINF sy-vline
WA_MEOUT_ITEM_DATAX_STR-PRSDR sy-vline
WA_MEOUT_ITEM_DATAX_STR-SCHPR sy-vline
WA_MEOUT_ITEM_DATAX_STR-MAHN1 sy-vline
WA_MEOUT_ITEM_DATAX_STR-MAHN2 sy-vline
WA_MEOUT_ITEM_DATAX_STR-MAHN3 sy-vline
WA_MEOUT_ITEM_DATAX_STR-UEBTO sy-vline
WA_MEOUT_ITEM_DATAX_STR-UEBTK sy-vline
WA_MEOUT_ITEM_DATAX_STR-UNTTO sy-vline
WA_MEOUT_ITEM_DATAX_STR-BWTAR sy-vline
WA_MEOUT_ITEM_DATAX_STR-ELIKZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-EREKZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-PSTYP sy-vline
WA_MEOUT_ITEM_DATAX_STR-KNTTP sy-vline
WA_MEOUT_ITEM_DATAX_STR-VRTKZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-TWRKZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-WEPOS sy-vline
WA_MEOUT_ITEM_DATAX_STR-WEUNB sy-vline
WA_MEOUT_ITEM_DATAX_STR-REPOS sy-vline
WA_MEOUT_ITEM_DATAX_STR-UMSON sy-vline
WA_MEOUT_ITEM_DATAX_STR-WEBRE sy-vline
WA_MEOUT_ITEM_DATAX_STR-KZABS sy-vline
WA_MEOUT_ITEM_DATAX_STR-LABNR sy-vline
WA_MEOUT_ITEM_DATAX_STR-KONNR sy-vline
WA_MEOUT_ITEM_DATAX_STR-KTPNR sy-vline
WA_MEOUT_ITEM_DATAX_STR-ABDAT sy-vline
WA_MEOUT_ITEM_DATAX_STR-ABFTZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-ETFZ1 sy-vline
WA_MEOUT_ITEM_DATAX_STR-ETFZ2 sy-vline
WA_MEOUT_ITEM_DATAX_STR-KZSTU sy-vline
WA_MEOUT_ITEM_DATAX_STR-NOTKZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-EVERS sy-vline
WA_MEOUT_ITEM_DATAX_STR-KUNNR sy-vline
WA_MEOUT_ITEM_DATAX_STR-ADRNR sy-vline
WA_MEOUT_ITEM_DATAX_STR-EKKOL sy-vline
WA_MEOUT_ITEM_DATAX_STR-SKTOF sy-vline
WA_MEOUT_ITEM_DATAX_STR-PLIFZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-NTGEW sy-vline
WA_MEOUT_ITEM_DATAX_STR-GEWEI sy-vline
WA_MEOUT_ITEM_DATAX_STR-TXJCD sy-vline
WA_MEOUT_ITEM_DATAX_STR-SSQSS sy-vline
WA_MEOUT_ITEM_DATAX_STR-BSTAE sy-vline
WA_MEOUT_ITEM_DATAX_STR-REVLV sy-vline
WA_MEOUT_ITEM_DATAX_STR-GEBER sy-vline
WA_MEOUT_ITEM_DATAX_STR-FISTL sy-vline
WA_MEOUT_ITEM_DATAX_STR-FIPOS sy-vline
WA_MEOUT_ITEM_DATAX_STR-MEPRF sy-vline
WA_MEOUT_ITEM_DATAX_STR-PRDAT sy-vline
WA_MEOUT_ITEM_DATAX_STR-BRGEW sy-vline
WA_MEOUT_ITEM_DATAX_STR-VOLUM sy-vline
WA_MEOUT_ITEM_DATAX_STR-VOLEH sy-vline
WA_MEOUT_ITEM_DATAX_STR-INCO1 sy-vline
WA_MEOUT_ITEM_DATAX_STR-INCO2 sy-vline
WA_MEOUT_ITEM_DATAX_STR-KOLIF sy-vline
WA_MEOUT_ITEM_DATAX_STR-LTSNR sy-vline
WA_MEOUT_ITEM_DATAX_STR-UEBPO sy-vline
WA_MEOUT_ITEM_DATAX_STR-LEWED sy-vline
WA_MEOUT_ITEM_DATAX_STR-EMLIF sy-vline
WA_MEOUT_ITEM_DATAX_STR-LBLKZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-KANBA sy-vline
WA_MEOUT_ITEM_DATAX_STR-ADRN2 sy-vline
WA_MEOUT_ITEM_DATAX_STR-XERSY sy-vline
WA_MEOUT_ITEM_DATAX_STR-EILDT sy-vline
WA_MEOUT_ITEM_DATAX_STR-AKTNR sy-vline
WA_MEOUT_ITEM_DATAX_STR-ANZPU sy-vline
WA_MEOUT_ITEM_DATAX_STR-PUNEI sy-vline
WA_MEOUT_ITEM_DATAX_STR-SAISO sy-vline
WA_MEOUT_ITEM_DATAX_STR-SAISJ sy-vline
WA_MEOUT_ITEM_DATAX_STR-EBON2 sy-vline
WA_MEOUT_ITEM_DATAX_STR-EBON3 sy-vline
WA_MEOUT_ITEM_DATAX_STR-EBONF sy-vline
WA_MEOUT_ITEM_DATAX_STR-MHDRZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-ANFNR sy-vline
WA_MEOUT_ITEM_DATAX_STR-ANFPS sy-vline
WA_MEOUT_ITEM_DATAX_STR-BANFN sy-vline
WA_MEOUT_ITEM_DATAX_STR-BNFPO sy-vline
WA_MEOUT_ITEM_DATAX_STR-REFBS sy-vline
WA_MEOUT_ITEM_DATAX_STR-REFPS sy-vline
WA_MEOUT_ITEM_DATAX_STR-UPTYP sy-vline
WA_MEOUT_ITEM_DATAX_STR-AUREL sy-vline
WA_MEOUT_ITEM_DATAX_STR-BSGRU sy-vline
WA_MEOUT_ITEM_DATAX_STR-RETPC sy-vline
WA_MEOUT_ITEM_DATAX_STR-J_1BNBM sy-vline
WA_MEOUT_ITEM_DATAX_STR-J_1BMATUSE sy-vline
WA_MEOUT_ITEM_DATAX_STR-J_1BMATORG sy-vline
WA_MEOUT_ITEM_DATAX_STR-J_1BOWNPRO sy-vline
WA_MEOUT_ITEM_DATAX_STR-J_1BINDUST sy-vline
WA_MEOUT_ITEM_DATAX_STR-J_1AINDXP sy-vline
WA_MEOUT_ITEM_DATAX_STR-J_1AIDATEP sy-vline
WA_MEOUT_ITEM_DATAX_STR-EGLKZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-KZTLF sy-vline
WA_MEOUT_ITEM_DATAX_STR-NOVET sy-vline
WA_MEOUT_ITEM_DATAX_STR-AFNAM sy-vline
WA_MEOUT_ITEM_DATAX_STR-IPRKZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-CALCTYPE sy-vline
WA_MEOUT_ITEM_DATAX_STR-FKBER sy-vline
WA_MEOUT_ITEM_DATAX_STR-GRANT_NBR sy-vline
WA_MEOUT_ITEM_DATAX_STR-KBLNR sy-vline
WA_MEOUT_ITEM_DATAX_STR-KBLPOS sy-vline
WA_MEOUT_ITEM_DATAX_STR-LFRET sy-vline
WA_MEOUT_ITEM_DATAX_STR-NO_ROUNDING sy-vline
WA_MEOUT_ITEM_DATAX_STR-PO_PRICE sy-vline
WA_MEOUT_ITEM_DATAX_STR-RESLO sy-vline
WA_MEOUT_ITEM_DATAX_STR-ABUEB sy-vline
WA_MEOUT_ITEM_DATAX_STR-FABKZ sy-vline
WA_MEOUT_ITEM_DATAX_STR-APOMS sy-vline
WA_MEOUT_ITEM_DATAX_STR-SRM_CONTRACT_ID sy-vline
WA_MEOUT_ITEM_DATAX_STR-SRM_CONTRACT_ITM sy-vline
WA_MEOUT_ITEM_DATAX_STR-SGT_SCAT sy-vline
WA_MEOUT_ITEM_DATAX_STR-WEORA sy-vline
WA_MEOUT_ITEM_DATAX_STR-INCO2_L sy-vline
WA_MEOUT_ITEM_DATAX_STR-INCO3_L sy-vline
WA_MEOUT_ITEM_DATAX_STR-DUMMY sy-vline
WA_MEOUT_ITEM_DATAX_STR-ADVCODE sy-vline
WA_MEOUT_ITEM_DATAX_STR-SOURCE_ID sy-vline
WA_MEOUT_ITEM_DATAX_STR-SOURCE_KEY sy-vline
WA_MEOUT_ITEM_DATAX_STR-PUT_BACK sy-vline
WA_MEOUT_ITEM_DATAX_STR-POL_ID sy-vline
WA_MEOUT_ITEM_DATAX_STR-REF_ITEM sy-vline
WA_MEOUT_ITEM_DATAX_STR-BUDGET_PD sy-vline
WA_MEOUT_ITEM_DATAX_STR-TC_AUT_DET sy-vline
WA_MEOUT_ITEM_DATAX_STR-MANUAL_TC_REASON sy-vline
WA_MEOUT_ITEM_DATAX_STR-FISCAL_INCENTIVE sy-vline
WA_MEOUT_ITEM_DATAX_STR-TAX_SUBJECT_ST sy-vline
WA_MEOUT_ITEM_DATAX_STR-FISCAL_INCENTIVE_ID sy-vline
WA_MEOUT_ITEM_DATAX_STR-SERVICEPERFORMER sy-vline
WA_MEOUT_ITEM_DATAX_STR-PRODUCTTYPE sy-vline
WA_MEOUT_ITEM_DATAX_STR-MATERIALTYPE sy-vline
WA_MEOUT_ITEM_DATAX_STR-BLK_REASON_ID sy-vline
WA_MEOUT_ITEM_DATAX_STR-EXLIN sy-vline
WA_MEOUT_ITEM_DATAX_STR-EXSNR sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.