ABAP Select data from SAP table IEOUTBILMLTRNG 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 IEOUTBILMLTRNG 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 IEOUTBILMLTRNG. 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 IEOUTBILMLTRNG 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_IEOUTBILMLTRNG TYPE STANDARD TABLE OF IEOUTBILMLTRNG,
      WA_IEOUTBILMLTRNG TYPE IEOUTBILMLTRNG,
      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: <IEOUTBILMLTRNG> TYPE IEOUTBILMLTRNG.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM IEOUTBILMLTRNG
*  INTO TABLE @DATA(IT_IEOUTBILMLTRNG2).
*--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_IEOUTBILMLTRNG INDEX 1 INTO DATA(WA_IEOUTBILMLTRNG2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_IEOUTBILMLTRNG ASSIGNING <IEOUTBILMLTRNG>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<IEOUTBILMLTRNG>-MANDT = 1.
<IEOUTBILMLTRNG>-UTILITIESBILLINGDOCUMENT = 1.
<IEOUTBILMLTRNG>-UTILSBILLGPERIODDURATION = 1.
<IEOUTBILMLTRNG>-UTILSBILLGDOCTRANSACTIONCRCY = 1.
<IEOUTBILMLTRNG>-UTILSBILLGDOCTOTALNETAMT = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_IEOUTBILMLTRNG-UTILSBILLGDOCADJDTOTALNETAMT, sy-vline,
WA_IEOUTBILMLTRNG-UTILSPREVBILLGDOCNETAMT, sy-vline,
WA_IEOUTBILMLTRNG-UTILSPREVBILLGDOCADJDNETAMT, sy-vline,
WA_IEOUTBILMLTRNG-UTILSPREVBILLGDIFFNETAMT, sy-vline,
WA_IEOUTBILMLTRNG-UTILSPREVBILLGDIFFADJDNETAMT, sy-vline,
WA_IEOUTBILMLTRNG-UTILSPREVDOCMINNETAMT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_IEOUTBILMLTRNG 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_IEOUTBILMLTRNG 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_IEOUTBILMLTRNG INTO WA_IEOUTBILMLTRNG. *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 ALPHA, internal->external for field UTILITIESBILLINGDOCUMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IEOUTBILMLTRNG-UTILITIESBILLINGDOCUMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IEOUTBILMLTRNG-UTILITIESBILLINGDOCUMENT.
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_IEOUTBILMLTRNG_STR,
MANDT TYPE STRING,
UTILITIESBILLINGDOCUMENT TYPE STRING,
UTILSBILLGPERIODDURATION TYPE STRING,
UTILSBILLGDOCTRANSACTIONCRCY TYPE STRING,
UTILSBILLGDOCTOTALNETAMT TYPE STRING,
UTILSBILLGDOCADJDTOTALNETAMT TYPE STRING,
UTILSPREVBILLGDOCNETAMT TYPE STRING,
UTILSPREVBILLGDOCADJDNETAMT TYPE STRING,
UTILSPREVBILLGDIFFNETAMT TYPE STRING,
UTILSPREVBILLGDIFFADJDNETAMT TYPE STRING,
UTILSPREVDOCMINNETAMT TYPE STRING,
UTILSPREVDOCMAXNETAMT TYPE STRING,
UTILSPREVDOCAVGNETAMT TYPE STRING,
UTILSPREVDOCMDNNETAMT TYPE STRING,
UTILSPREVDOCSTDVNETAMT TYPE STRING,
UTILSPREVDOCVARCNETAMT TYPE STRING,
UTILSPREVDOCMINADJDNETAMT TYPE STRING,
UTILSPREVDOCMAXADJDNETAMT TYPE STRING,
UTILSPREVDOCAVGADJDNETAMT TYPE STRING,
UTILSPREVDOCMDNADJDNETAMT TYPE STRING,
UTILSPREVDOCSTDVADJDNETAMT TYPE STRING,
UTILSPREVDOCVARCADJDNETAMT TYPE STRING,
UTILSPREVDOCMINPREVNETAMT TYPE STRING,
UTILSPREVDOCMAXPREVNETAMT TYPE STRING,
UTILSPREVDOCAVGPREVNETAMT TYPE STRING,
UTILSPREVDOCMDNPREVNETAMT TYPE STRING,
UTILSPREVDOCSTDVPREVNETAMT TYPE STRING,
UTILSPREVDOCVARCPREVNETAMT TYPE STRING,
UTILSPREVDOCMINPREVADJDNETAMT TYPE STRING,
UTILSPREVDOCMAXPREVADJDNETAMT TYPE STRING,
UTILSPREVDOCAVGPREVADJDNETAMT TYPE STRING,
UTILSPREVDOCMDNPREVADJDNETAMT TYPE STRING,
UTILSPREVDOCSTDVPREVADJDNETAMT TYPE STRING,
UTILSPREVDOCVARCPREVADJDNETAMT TYPE STRING,
UTILSPREVDOCMINDIFFNETAMT TYPE STRING,
UTILSPREVDOCMAXDIFFNETAMT TYPE STRING,
UTILSPREVDOCAVGDIFFNETAMT TYPE STRING,
UTILSPREVDOCMDNDIFFNETAMT TYPE STRING,
UTILSPREVDOCSTDVDIFFNETAMT TYPE STRING,
UTILSPREVDOCVARCDIFFNETAMT TYPE STRING,
UTILSPREVDOCMINDIFFADJDNETAMT TYPE STRING,
UTILSPREVDOCMAXDIFFADJDNETAMT TYPE STRING,
UTILSPREVDOCAVGDIFFADJDNETAMT TYPE STRING,
UTILSPREVDOCMDNDIFFADJDNETAMT TYPE STRING,
UTILSPREVDOCSTDVDIFFADJDNETAMT TYPE STRING,
UTILSPREVDOCVARCDIFFADJDNETAMT TYPE STRING,
UTILSCURYRMINNETAMT TYPE STRING,
UTILSCURYRMAXNETAMT TYPE STRING,
UTILSCURYRAVGNETAMT TYPE STRING,
UTILSCURYRMDNNETAMT TYPE STRING,
UTILSCURYRSTDVNETAMT TYPE STRING,
UTILSCURYRVARCNETAMT TYPE STRING,
UTILSCURYRMINADJDTOTNETAMT TYPE STRING,
UTILSCURYRMAXADJDTOTNETAMT TYPE STRING,
UTILSCURYRAVGADJDTOTNETAMT TYPE STRING,
UTILSCURYRMDNADJDTOTNETAMT TYPE STRING,
UTILSCURYRSTDVADJDTOTNETAMT TYPE STRING,
UTILSCURYRVARCADJDTOTNETAMT TYPE STRING,
UTILSPREVYRBILLGDOCNETAMT TYPE STRING,
UTILSPREVYRBILLGDOCADJDNETAMT TYPE STRING,
UTILSPREVYRBILLGDIFFNETAMT TYPE STRING,
UTILSPREVYRBILLGDIFFADJDNETAMT TYPE STRING,
UTILSTHREEYRMINNETAMT TYPE STRING,
UTILSTHREEYRMAXNETAMT TYPE STRING,
UTILSTHREEYRAVGNETAMT TYPE STRING,
UTILSTHREEYRMDNNETAMT TYPE STRING,
UTILSTHREEYRSTDVNETAMT TYPE STRING,
UTILSTHREEYRVARCNETAMT TYPE STRING,
UTILSTHREEYRMINADJDNETAMT TYPE STRING,
UTILSTHREEYRMAXADJDNETAMT TYPE STRING,
UTILSTHREEYRAVGADJDNETAMT TYPE STRING,
UTILSTHREEYRMDNADJDNETAMT TYPE STRING,
UTILSTHREEYRSTDVADJDNETAMT TYPE STRING,
UTILSTHREEYRVARCADJDNETAMT TYPE STRING,
UTILSTHREEYRMINPREVYRNETAMT TYPE STRING,
UTILSTHREEYRMAXPREVYRNETAMT TYPE STRING,
UTILSTHREEYRAVGPREVYRNETAMT TYPE STRING,
UTILSTHREEYRMDNPREVYRNETAMT TYPE STRING,
UTILSTHREEYRSTDVPREVYRNETAMT TYPE STRING,
UTILSTHREEYRVARCPREVYRNETAMT TYPE STRING,
UTILSTHREEYRMINPREVADJDNETAMT TYPE STRING,
UTILSTHREEYRMAXPREVADJDNETAMT TYPE STRING,
UTILSTHREEYRAVGPREVADJDNETAMT TYPE STRING,
UTILSTHREEYRMDNPREVADJDNETAMT TYPE STRING,
UTILSTHREEYRSTDVPREVADJDNETAMT TYPE STRING,
UTILSTHREEYRVARCPREVADJDNETAMT TYPE STRING,
UTILSTHREEYRMINDIFFNETAMT TYPE STRING,
UTILSTHREEYRMAXDIFFNETAMT TYPE STRING,
UTILSTHREEYRAVGDIFFNETAMT TYPE STRING,
UTILSTHREEYRMDNDIFFNETAMT TYPE STRING,
UTILSTHREEYRSTDVDIFFNETAMT TYPE STRING,
UTILSTHREEYRVARCDIFFNETAMT TYPE STRING,
UTILSTHREEYRMINDIFFADJDNETAMT TYPE STRING,
UTILSTHREEYRMAXDIFFADJDNETAMT TYPE STRING,
UTILSTHREEYRAVGDIFFADJDNETAMT TYPE STRING,
UTILSTHREEYRMDNDIFFADJDNETAMT TYPE STRING,
UTILSTHREEYRSTDVDIFFADJDNETAMT TYPE STRING,
UTILSTHREEYRVARCDIFFADJDNETAMT TYPE STRING,END OF T_EKKO_STR. DATA: WA_IEOUTBILMLTRNG_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_IEOUTBILMLTRNG_STR-MANDT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILITIESBILLINGDOCUMENT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSBILLGPERIODDURATION sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSBILLGDOCTRANSACTIONCRCY sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSBILLGDOCTOTALNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSBILLGDOCADJDTOTALNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVBILLGDOCNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVBILLGDOCADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVBILLGDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVBILLGDIFFADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMINNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMAXNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCAVGNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMDNNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCSTDVNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCVARCNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMINADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMAXADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCAVGADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMDNADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCSTDVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCVARCADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMINPREVNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMAXPREVNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCAVGPREVNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMDNPREVNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCSTDVPREVNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCVARCPREVNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMINPREVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMAXPREVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCAVGPREVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMDNPREVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCSTDVPREVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCVARCPREVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMINDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMAXDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCAVGDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMDNDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCSTDVDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCVARCDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMINDIFFADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMAXDIFFADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCAVGDIFFADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCMDNDIFFADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCSTDVDIFFADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVDOCVARCDIFFADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSCURYRMINNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSCURYRMAXNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSCURYRAVGNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSCURYRMDNNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSCURYRSTDVNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSCURYRVARCNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSCURYRMINADJDTOTNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSCURYRMAXADJDTOTNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSCURYRAVGADJDTOTNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSCURYRMDNADJDTOTNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSCURYRSTDVADJDTOTNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSCURYRVARCADJDTOTNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVYRBILLGDOCNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVYRBILLGDOCADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVYRBILLGDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSPREVYRBILLGDIFFADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMINNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMAXNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRAVGNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMDNNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRSTDVNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRVARCNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMINADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMAXADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRAVGADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMDNADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRSTDVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRVARCADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMINPREVYRNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMAXPREVYRNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRAVGPREVYRNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMDNPREVYRNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRSTDVPREVYRNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRVARCPREVYRNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMINPREVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMAXPREVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRAVGPREVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMDNPREVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRSTDVPREVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRVARCPREVADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMINDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMAXDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRAVGDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMDNDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRSTDVDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRVARCDIFFNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMINDIFFADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMAXDIFFADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRAVGDIFFADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRMDNDIFFADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRSTDVDIFFADJDNETAMT sy-vline
WA_IEOUTBILMLTRNG_STR-UTILSTHREEYRVARCDIFFADJDNETAMT sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.