ABAP Select data from SAP table V_OIGSDOCS 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 V_OIGSDOCS 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 V_OIGSDOCS. 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 V_OIGSDOCS 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_V_OIGSDOCS TYPE STANDARD TABLE OF V_OIGSDOCS,
      WA_V_OIGSDOCS TYPE V_OIGSDOCS,
      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: <V_OIGSDOCS> TYPE V_OIGSDOCS.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM V_OIGSDOCS
*  INTO TABLE @DATA(IT_V_OIGSDOCS2).
*--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_V_OIGSDOCS INDEX 1 INTO DATA(WA_V_OIGSDOCS2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_V_OIGSDOCS ASSIGNING <V_OIGSDOCS>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<V_OIGSDOCS>-MANDT = 1.
<V_OIGSDOCS>-VBELN = 1.
<V_OIGSDOCS>-POSNR = 1.
<V_OIGSDOCS>-ERNAM = 1.
<V_OIGSDOCS>-ERZET = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_V_OIGSDOCS-ERDAT, sy-vline,
WA_V_OIGSDOCS-BZIRK, sy-vline,
WA_V_OIGSDOCS-VSTEL, sy-vline,
WA_V_OIGSDOCS-VKORG, sy-vline,
WA_V_OIGSDOCS-LFART, sy-vline,
WA_V_OIGSDOCS-AUTLF, sy-vline.
ENDLOOP. *Add any further fields from structure WA_V_OIGSDOCS 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_V_OIGSDOCS 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_V_OIGSDOCS INTO WA_V_OIGSDOCS. *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 VBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-VBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-VBELN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KUNNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-KUNNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-KUNNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KUNAG CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-KUNAG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-KUNAG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field GEWEI CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-GEWEI IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-GEWEI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field VOLEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-VOLEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-VOLEH.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field STAFO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-STAFO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-STAFO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRT, internal->external for field STCUR CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-STCUR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-STCUR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KUNIV CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-KUNIV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-KUNIV.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KNKLI CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-KNKLI IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-KNKLI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field LIFNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-LIFNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-LIFNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field XABLN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-XABLN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-XABLN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field TERNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-TERNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-TERNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field IMEINS CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-IMEINS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-IMEINS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field IMATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-IMATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-IMATNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field IVBELV CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-IVBELV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-IVBELV.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field IVRKME CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-IVRKME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-IVRKME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field IGEWEI CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-IGEWEI IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-IGEWEI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field IVOLEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-IVOLEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-IVOLEH.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field IVGBEL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_OIGSDOCS-IVGBEL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OIGSDOCS-IVGBEL.
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_V_OIGSDOCS_STR,
MANDT TYPE STRING,
VBELN TYPE STRING,
POSNR TYPE STRING,
ERNAM TYPE STRING,
ERZET TYPE STRING,
ERDAT TYPE STRING,
BZIRK TYPE STRING,
VSTEL TYPE STRING,
VKORG TYPE STRING,
LFART TYPE STRING,
AUTLF TYPE STRING,
KZAZU TYPE STRING,
WADAT TYPE STRING,
LDDAT TYPE STRING,
TDDAT TYPE STRING,
LFDAT TYPE STRING,
KODAT TYPE STRING,
ABLAD TYPE STRING,
INCO1 TYPE STRING,
INCO2 TYPE STRING,
EXPKZ TYPE STRING,
ROUTE TYPE STRING,
FAKSK TYPE STRING,
LIFSK TYPE STRING,
VBTYP TYPE STRING,
KNFAK TYPE STRING,
TPQUA TYPE STRING,
TPGRP TYPE STRING,
LPRIO TYPE STRING,
VSBED TYPE STRING,
KUNNR TYPE STRING,
KUNAG TYPE STRING,
KDGRP TYPE STRING,
STZKL TYPE STRING,
STZZU TYPE STRING,
BTGEW TYPE STRING,
NTGEW TYPE STRING,
GEWEI TYPE STRING,
VOLUM TYPE STRING,
VOLEH TYPE STRING,
ANZPK TYPE STRING,
BEROT TYPE STRING,
LFUHR TYPE STRING,
GRULG TYPE STRING,
LSTEL TYPE STRING,
TRAGR TYPE STRING,
FKARV TYPE STRING,
FKDAT TYPE STRING,
PERFK TYPE STRING,
ROUTA TYPE STRING,
STAFO TYPE STRING,
KALSM TYPE STRING,
KNUMV TYPE STRING,
WAERK TYPE STRING,
VKBUR TYPE STRING,
VBEAK TYPE STRING,
ZUKRL TYPE STRING,
VERUR TYPE STRING,
COMMN TYPE STRING,
STWAE TYPE STRING,
STCUR TYPE STRING,
EXNUM TYPE STRING,
AEDAT TYPE STRING,
LGNUM TYPE STRING,
VKOIV TYPE STRING,
VTWIV TYPE STRING,
SPAIV TYPE STRING,
FKAIV TYPE STRING,
PIOIV TYPE STRING,
FKDIV TYPE STRING,
KUNIV TYPE STRING,
KKBER TYPE STRING,
KNKLI TYPE STRING,
GRUPP TYPE STRING,
SBGRP TYPE STRING,
CTLPC TYPE STRING,
CMWAE TYPE STRING,
AMTBL TYPE STRING,
BOLNR TYPE STRING,
LIFNR TYPE STRING,
TRATY TYPE STRING,
TRAID TYPE STRING,
CMFRE TYPE STRING,
CMNGV TYPE STRING,
XABLN TYPE STRING,
WADAT_IST TYPE STRING,
TRSPG TYPE STRING,
TPSID TYPE STRING,
LIFEX TYPE STRING,
TERNR TYPE STRING,
KALSM_CH TYPE STRING,
KLIEF TYPE STRING,
KALSP TYPE STRING,
KNUMP TYPE STRING,
AULWE TYPE STRING,
WERKS TYPE STRING,
KOQUK TYPE STRING,
WBSTK TYPE STRING,
PKSTK TYPE STRING,
TRSTA TYPE STRING,
IMEINS TYPE STRING,
ICHARG TYPE STRING,
IMATNR TYPE STRING,
IVBELV TYPE STRING,
IBWTAR TYPE STRING,
IWERKS TYPE STRING,
ILGMNG TYPE STRING,
ILFIMG TYPE STRING,
IVRKME TYPE STRING,
ILGORT TYPE STRING,
IBRGEW TYPE STRING,
INTGEW TYPE STRING,
ILADGR TYPE STRING,
ITRAGR TYPE STRING,
IGEWEI TYPE STRING,
IVOLUM TYPE STRING,
IVOLEH TYPE STRING,
IVGBEL TYPE STRING,
IVGPOS TYPE STRING,
IVGTYP TYPE STRING,END OF T_EKKO_STR. DATA: WA_V_OIGSDOCS_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_V_OIGSDOCS_STR-MANDT sy-vline
WA_V_OIGSDOCS_STR-VBELN sy-vline
WA_V_OIGSDOCS_STR-POSNR sy-vline
WA_V_OIGSDOCS_STR-ERNAM sy-vline
WA_V_OIGSDOCS_STR-ERZET sy-vline
WA_V_OIGSDOCS_STR-ERDAT sy-vline
WA_V_OIGSDOCS_STR-BZIRK sy-vline
WA_V_OIGSDOCS_STR-VSTEL sy-vline
WA_V_OIGSDOCS_STR-VKORG sy-vline
WA_V_OIGSDOCS_STR-LFART sy-vline
WA_V_OIGSDOCS_STR-AUTLF sy-vline
WA_V_OIGSDOCS_STR-KZAZU sy-vline
WA_V_OIGSDOCS_STR-WADAT sy-vline
WA_V_OIGSDOCS_STR-LDDAT sy-vline
WA_V_OIGSDOCS_STR-TDDAT sy-vline
WA_V_OIGSDOCS_STR-LFDAT sy-vline
WA_V_OIGSDOCS_STR-KODAT sy-vline
WA_V_OIGSDOCS_STR-ABLAD sy-vline
WA_V_OIGSDOCS_STR-INCO1 sy-vline
WA_V_OIGSDOCS_STR-INCO2 sy-vline
WA_V_OIGSDOCS_STR-EXPKZ sy-vline
WA_V_OIGSDOCS_STR-ROUTE sy-vline
WA_V_OIGSDOCS_STR-FAKSK sy-vline
WA_V_OIGSDOCS_STR-LIFSK sy-vline
WA_V_OIGSDOCS_STR-VBTYP sy-vline
WA_V_OIGSDOCS_STR-KNFAK sy-vline
WA_V_OIGSDOCS_STR-TPQUA sy-vline
WA_V_OIGSDOCS_STR-TPGRP sy-vline
WA_V_OIGSDOCS_STR-LPRIO sy-vline
WA_V_OIGSDOCS_STR-VSBED sy-vline
WA_V_OIGSDOCS_STR-KUNNR sy-vline
WA_V_OIGSDOCS_STR-KUNAG sy-vline
WA_V_OIGSDOCS_STR-KDGRP sy-vline
WA_V_OIGSDOCS_STR-STZKL sy-vline
WA_V_OIGSDOCS_STR-STZZU sy-vline
WA_V_OIGSDOCS_STR-BTGEW sy-vline
WA_V_OIGSDOCS_STR-NTGEW sy-vline
WA_V_OIGSDOCS_STR-GEWEI sy-vline
WA_V_OIGSDOCS_STR-VOLUM sy-vline
WA_V_OIGSDOCS_STR-VOLEH sy-vline
WA_V_OIGSDOCS_STR-ANZPK sy-vline
WA_V_OIGSDOCS_STR-BEROT sy-vline
WA_V_OIGSDOCS_STR-LFUHR sy-vline
WA_V_OIGSDOCS_STR-GRULG sy-vline
WA_V_OIGSDOCS_STR-LSTEL sy-vline
WA_V_OIGSDOCS_STR-TRAGR sy-vline
WA_V_OIGSDOCS_STR-FKARV sy-vline
WA_V_OIGSDOCS_STR-FKDAT sy-vline
WA_V_OIGSDOCS_STR-PERFK sy-vline
WA_V_OIGSDOCS_STR-ROUTA sy-vline
WA_V_OIGSDOCS_STR-STAFO sy-vline
WA_V_OIGSDOCS_STR-KALSM sy-vline
WA_V_OIGSDOCS_STR-KNUMV sy-vline
WA_V_OIGSDOCS_STR-WAERK sy-vline
WA_V_OIGSDOCS_STR-VKBUR sy-vline
WA_V_OIGSDOCS_STR-VBEAK sy-vline
WA_V_OIGSDOCS_STR-ZUKRL sy-vline
WA_V_OIGSDOCS_STR-VERUR sy-vline
WA_V_OIGSDOCS_STR-COMMN sy-vline
WA_V_OIGSDOCS_STR-STWAE sy-vline
WA_V_OIGSDOCS_STR-STCUR sy-vline
WA_V_OIGSDOCS_STR-EXNUM sy-vline
WA_V_OIGSDOCS_STR-AEDAT sy-vline
WA_V_OIGSDOCS_STR-LGNUM sy-vline
WA_V_OIGSDOCS_STR-VKOIV sy-vline
WA_V_OIGSDOCS_STR-VTWIV sy-vline
WA_V_OIGSDOCS_STR-SPAIV sy-vline
WA_V_OIGSDOCS_STR-FKAIV sy-vline
WA_V_OIGSDOCS_STR-PIOIV sy-vline
WA_V_OIGSDOCS_STR-FKDIV sy-vline
WA_V_OIGSDOCS_STR-KUNIV sy-vline
WA_V_OIGSDOCS_STR-KKBER sy-vline
WA_V_OIGSDOCS_STR-KNKLI sy-vline
WA_V_OIGSDOCS_STR-GRUPP sy-vline
WA_V_OIGSDOCS_STR-SBGRP sy-vline
WA_V_OIGSDOCS_STR-CTLPC sy-vline
WA_V_OIGSDOCS_STR-CMWAE sy-vline
WA_V_OIGSDOCS_STR-AMTBL sy-vline
WA_V_OIGSDOCS_STR-BOLNR sy-vline
WA_V_OIGSDOCS_STR-LIFNR sy-vline
WA_V_OIGSDOCS_STR-TRATY sy-vline
WA_V_OIGSDOCS_STR-TRAID sy-vline
WA_V_OIGSDOCS_STR-CMFRE sy-vline
WA_V_OIGSDOCS_STR-CMNGV sy-vline
WA_V_OIGSDOCS_STR-XABLN sy-vline
WA_V_OIGSDOCS_STR-WADAT_IST sy-vline
WA_V_OIGSDOCS_STR-TRSPG sy-vline
WA_V_OIGSDOCS_STR-TPSID sy-vline
WA_V_OIGSDOCS_STR-LIFEX sy-vline
WA_V_OIGSDOCS_STR-TERNR sy-vline
WA_V_OIGSDOCS_STR-KALSM_CH sy-vline
WA_V_OIGSDOCS_STR-KLIEF sy-vline
WA_V_OIGSDOCS_STR-KALSP sy-vline
WA_V_OIGSDOCS_STR-KNUMP sy-vline
WA_V_OIGSDOCS_STR-AULWE sy-vline
WA_V_OIGSDOCS_STR-WERKS sy-vline
WA_V_OIGSDOCS_STR-KOQUK sy-vline
WA_V_OIGSDOCS_STR-WBSTK sy-vline
WA_V_OIGSDOCS_STR-PKSTK sy-vline
WA_V_OIGSDOCS_STR-TRSTA sy-vline
WA_V_OIGSDOCS_STR-IMEINS sy-vline
WA_V_OIGSDOCS_STR-ICHARG sy-vline
WA_V_OIGSDOCS_STR-IMATNR sy-vline
WA_V_OIGSDOCS_STR-IVBELV sy-vline
WA_V_OIGSDOCS_STR-IBWTAR sy-vline
WA_V_OIGSDOCS_STR-IWERKS sy-vline
WA_V_OIGSDOCS_STR-ILGMNG sy-vline
WA_V_OIGSDOCS_STR-ILFIMG sy-vline
WA_V_OIGSDOCS_STR-IVRKME sy-vline
WA_V_OIGSDOCS_STR-ILGORT sy-vline
WA_V_OIGSDOCS_STR-IBRGEW sy-vline
WA_V_OIGSDOCS_STR-INTGEW sy-vline
WA_V_OIGSDOCS_STR-ILADGR sy-vline
WA_V_OIGSDOCS_STR-ITRAGR sy-vline
WA_V_OIGSDOCS_STR-IGEWEI sy-vline
WA_V_OIGSDOCS_STR-IVOLUM sy-vline
WA_V_OIGSDOCS_STR-IVOLEH sy-vline
WA_V_OIGSDOCS_STR-IVGBEL sy-vline
WA_V_OIGSDOCS_STR-IVGPOS sy-vline
WA_V_OIGSDOCS_STR-IVGTYP sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.