ABAP Select data from SAP table GLOB 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 GLOB 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 GLOB. 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 GLOB 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_GLOB TYPE STANDARD TABLE OF GLOB,
      WA_GLOB TYPE GLOB,
      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: <GLOB> TYPE GLOB.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM GLOB
*  INTO TABLE @DATA(IT_GLOB2).
*--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_GLOB INDEX 1 INTO DATA(WA_GLOB2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_GLOB ASSIGNING <GLOB>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<GLOB>-VORGA = 1.
<GLOB>-NOBQP = 1.
<GLOB>-NOPUP = 1.
<GLOB>-NOKVC = 1.
<GLOB>-KALKTYP = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_GLOB-NO_SAPR_READ, sy-vline,
WA_GLOB-FAMILY_PRICING, sy-vline,
WA_GLOB-KBELN, sy-vline,
WA_GLOB-VKKAB, sy-vline,
WA_GLOB-VKKBI, sy-vline,
WA_GLOB-PRSDT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_GLOB 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_GLOB 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_GLOB INTO WA_GLOB. *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 KBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_GLOB-KBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_GLOB-KBELN.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit GJAHR, internal->external for field SAISJ CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_GLOB-SAISJ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_GLOB-SAISJ.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field ERDOCN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_GLOB-ERDOCN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_GLOB-ERDOCN.
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_GLOB_STR,
VORGA TYPE STRING,
NOBQP TYPE STRING,
NOPUP TYPE STRING,
NOKVC TYPE STRING,
KALKTYP TYPE STRING,
NO_SAPR_READ TYPE STRING,
FAMILY_PRICING TYPE STRING,
KBELN TYPE STRING,
VKKAB TYPE STRING,
VKKBI TYPE STRING,
PRSDT TYPE STRING,
MATKL TYPE STRING,
LIFNR TYPE STRING,
LTSNR TYPE STRING,
AKTNR TYPE STRING,
SAISO TYPE STRING,
SAISJ TYPE STRING,
LIGRU TYPE STRING,
LIVAR TYPE STRING,
LISKZ TYPE STRING,
NEUKA TYPE STRING,
COMWO TYPE STRING,
TRTYP TYPE STRING,
EKERV TYPE STRING,
VKERV TYPE STRING,
MPROZ TYPE STRING,
AWAER TYPE STRING,
MABSO TYPE STRING,
NOSTA TYPE STRING,
NOVRK TYPE STRING,
NOEKP TYPE STRING,
NOLIF TYPE STRING,
INIAM TYPE STRING,
KLART TYPE STRING,
AUTOK TYPE STRING,
DRUKZ TYPE STRING,
FEHLP TYPE STRING,
BELKZ TYPE STRING,
ARCKZ TYPE STRING,
WSLOG TYPE STRING,
WLOGV TYPE STRING,
LIF2S TYPE STRING,
KABVP TYPE STRING,
FRBNR TYPE STRING,
KAVTL TYPE STRING,
KDFSA TYPE STRING,
FSH_SEASON_YEAR TYPE STRING,
FSH_SEASON TYPE STRING,
FSH_COLLECTION TYPE STRING,
FSH_THEME TYPE STRING,
WAKHD TYPE STRING,
MANDT TYPE STRING,
AKTNR TYPE STRING,
AKTYP TYPE STRING,
AKART TYPE STRING,
WAELA TYPE STRING,
WAERA TYPE STRING,
VGLAK TYPE STRING,
LISRE TYPE STRING,
AUFAR TYPE STRING,
BEKTY TYPE STRING,
KSBEK TYPE STRING,
AKVST TYPE STRING,
AKAST TYPE STRING,
AKBST TYPE STRING,
VKGST TYPE STRING,
EKGST TYPE STRING,
BEKST TYPE STRING,
AKNBS TYPE STRING,
AKNFG TYPE STRING,
AKNBF TYPE STRING,
AKNTH TYPE STRING,
AKNPO TYPE STRING,
AKNWM TYPE STRING,
AKNTX TYPE STRING,
NEKKO TYPE STRING,
NVKKO TYPE STRING,
NARTS TYPE STRING,
ATNPO TYPE STRING,
VTART TYPE STRING,
EKDAB TYPE STRING,
EKDBI TYPE STRING,
VKDAB TYPE STRING,
VKDBI TYPE STRING,
ALIVO TYPE STRING,
ALIBI TYPE STRING,
SPDAB TYPE STRING,
SPGRU TYPE STRING,
EKKON TYPE STRING,
VKKON TYPE STRING,
KOBOG TYPE STRING,
EKORG TYPE STRING,
EKGRP TYPE STRING,
VKORG TYPE STRING,
VTWEG TYPE STRING,
PLUEP TYPE STRING,
PLUEN TYPE STRING,
PLUVP TYPE STRING,
PLMGE TYPE STRING,
PLANZ TYPE STRING,
MELAK TYPE STRING,
MELRA TYPE STRING,
PDUEP TYPE STRING,
PDUEN TYPE STRING,
PDUVP TYPE STRING,
PDMGE TYPE STRING,
PDANZ TYPE STRING,
VAUEP TYPE STRING,
VAUEN TYPE STRING,
VAUVP TYPE STRING,
VAMGE TYPE STRING,
RFIND TYPE STRING,
VAANZ TYPE STRING,
ERNAM TYPE STRING,
ERDAT TYPE STRING,
AENAM TYPE STRING,
AEDAT TYPE STRING,
KOBVK TYPE STRING,
FADAT TYPE STRING,
SADAT TYPE STRING,
FLDAT TYPE STRING,
SLDAT TYPE STRING,
ADDIBELNR TYPE STRING,
VZKON TYPE STRING,
KALKE TYPE STRING,
PLTYP TYPE STRING,
NO_KALK TYPE STRING,
EKERV TYPE STRING,
RFCDEST TYPE STRING,
ERAPPL TYPE STRING,
KSCHL_PERC TYPE STRING,
KSCHL_VAL TYPE STRING,
PLUNP TYPE STRING,
PLURE TYPE STRING,
PLULO TYPE STRING,
MEDIA_TYPE TYPE STRING,
CUSTOMER_TYPE TYPE STRING,
ALLOW_PMAT_IGNO TYPE STRING,
ITEMS_4_BBY TYPE STRING,
ALLOW_DISP_MAT TYPE STRING,
INIT_SLS_PRICE TYPE STRING,
REF_PROMO TYPE STRING,
CGPL_GUID TYPE STRING,
EXTERNAL_ID TYPE STRING,
IS_REF_PROMO TYPE STRING,
BEKST2 TYPE STRING,
ERDOCN TYPE STRING,
HIER_ID TYPE STRING,
BPROF TYPE STRING,
SELKZ TYPE STRING,
UPDKZ TYPE STRING,
TXTL TYPE STRING,
AKTKT TYPE STRING,
TXTBZ TYPE STRING,
NUMKI TYPE STRING,
NUMKE TYPE STRING,
GEN_METHOD TYPE STRING,
PFLKN_MAX TYPE STRING,
PDUNP TYPE STRING,
PDURE TYPE STRING,
PDULO TYPE STRING,
REF_PROMO_TEXT TYPE STRING,
CGPL_PROJ_TEXT TYPE STRING,END OF T_EKKO_STR. DATA: WA_GLOB_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_GLOB_STR-VORGA sy-vline
WA_GLOB_STR-NOBQP sy-vline
WA_GLOB_STR-NOPUP sy-vline
WA_GLOB_STR-NOKVC sy-vline
WA_GLOB_STR-KALKTYP sy-vline
WA_GLOB_STR-NO_SAPR_READ sy-vline
WA_GLOB_STR-FAMILY_PRICING sy-vline
WA_GLOB_STR-KBELN sy-vline
WA_GLOB_STR-VKKAB sy-vline
WA_GLOB_STR-VKKBI sy-vline
WA_GLOB_STR-PRSDT sy-vline
WA_GLOB_STR-MATKL sy-vline
WA_GLOB_STR-LIFNR sy-vline
WA_GLOB_STR-LTSNR sy-vline
WA_GLOB_STR-AKTNR sy-vline
WA_GLOB_STR-SAISO sy-vline
WA_GLOB_STR-SAISJ sy-vline
WA_GLOB_STR-LIGRU sy-vline
WA_GLOB_STR-LIVAR sy-vline
WA_GLOB_STR-LISKZ sy-vline
WA_GLOB_STR-NEUKA sy-vline
WA_GLOB_STR-COMWO sy-vline
WA_GLOB_STR-TRTYP sy-vline
WA_GLOB_STR-EKERV sy-vline
WA_GLOB_STR-VKERV sy-vline
WA_GLOB_STR-MPROZ sy-vline
WA_GLOB_STR-AWAER sy-vline
WA_GLOB_STR-MABSO sy-vline
WA_GLOB_STR-NOSTA sy-vline
WA_GLOB_STR-NOVRK sy-vline
WA_GLOB_STR-NOEKP sy-vline
WA_GLOB_STR-NOLIF sy-vline
WA_GLOB_STR-INIAM sy-vline
WA_GLOB_STR-KLART sy-vline
WA_GLOB_STR-AUTOK sy-vline
WA_GLOB_STR-DRUKZ sy-vline
WA_GLOB_STR-FEHLP sy-vline
WA_GLOB_STR-BELKZ sy-vline
WA_GLOB_STR-ARCKZ sy-vline
WA_GLOB_STR-WSLOG sy-vline
WA_GLOB_STR-WLOGV sy-vline
WA_GLOB_STR-LIF2S sy-vline
WA_GLOB_STR-KABVP sy-vline
WA_GLOB_STR-FRBNR sy-vline
WA_GLOB_STR-KAVTL sy-vline
WA_GLOB_STR-KDFSA sy-vline
WA_GLOB_STR-FSH_SEASON_YEAR sy-vline
WA_GLOB_STR-FSH_SEASON sy-vline
WA_GLOB_STR-FSH_COLLECTION sy-vline
WA_GLOB_STR-FSH_THEME sy-vline
WA_GLOB_STR-WAKHD sy-vline
WA_GLOB_STR-MANDT sy-vline
WA_GLOB_STR-AKTNR sy-vline
WA_GLOB_STR-AKTYP sy-vline
WA_GLOB_STR-AKART sy-vline
WA_GLOB_STR-WAELA sy-vline
WA_GLOB_STR-WAERA sy-vline
WA_GLOB_STR-VGLAK sy-vline
WA_GLOB_STR-LISRE sy-vline
WA_GLOB_STR-AUFAR sy-vline
WA_GLOB_STR-BEKTY sy-vline
WA_GLOB_STR-KSBEK sy-vline
WA_GLOB_STR-AKVST sy-vline
WA_GLOB_STR-AKAST sy-vline
WA_GLOB_STR-AKBST sy-vline
WA_GLOB_STR-VKGST sy-vline
WA_GLOB_STR-EKGST sy-vline
WA_GLOB_STR-BEKST sy-vline
WA_GLOB_STR-AKNBS sy-vline
WA_GLOB_STR-AKNFG sy-vline
WA_GLOB_STR-AKNBF sy-vline
WA_GLOB_STR-AKNTH sy-vline
WA_GLOB_STR-AKNPO sy-vline
WA_GLOB_STR-AKNWM sy-vline
WA_GLOB_STR-AKNTX sy-vline
WA_GLOB_STR-NEKKO sy-vline
WA_GLOB_STR-NVKKO sy-vline
WA_GLOB_STR-NARTS sy-vline
WA_GLOB_STR-ATNPO sy-vline
WA_GLOB_STR-VTART sy-vline
WA_GLOB_STR-EKDAB sy-vline
WA_GLOB_STR-EKDBI sy-vline
WA_GLOB_STR-VKDAB sy-vline
WA_GLOB_STR-VKDBI sy-vline
WA_GLOB_STR-ALIVO sy-vline
WA_GLOB_STR-ALIBI sy-vline
WA_GLOB_STR-SPDAB sy-vline
WA_GLOB_STR-SPGRU sy-vline
WA_GLOB_STR-EKKON sy-vline
WA_GLOB_STR-VKKON sy-vline
WA_GLOB_STR-KOBOG sy-vline
WA_GLOB_STR-EKORG sy-vline
WA_GLOB_STR-EKGRP sy-vline
WA_GLOB_STR-VKORG sy-vline
WA_GLOB_STR-VTWEG sy-vline
WA_GLOB_STR-PLUEP sy-vline
WA_GLOB_STR-PLUEN sy-vline
WA_GLOB_STR-PLUVP sy-vline
WA_GLOB_STR-PLMGE sy-vline
WA_GLOB_STR-PLANZ sy-vline
WA_GLOB_STR-MELAK sy-vline
WA_GLOB_STR-MELRA sy-vline
WA_GLOB_STR-PDUEP sy-vline
WA_GLOB_STR-PDUEN sy-vline
WA_GLOB_STR-PDUVP sy-vline
WA_GLOB_STR-PDMGE sy-vline
WA_GLOB_STR-PDANZ sy-vline
WA_GLOB_STR-VAUEP sy-vline
WA_GLOB_STR-VAUEN sy-vline
WA_GLOB_STR-VAUVP sy-vline
WA_GLOB_STR-VAMGE sy-vline
WA_GLOB_STR-RFIND sy-vline
WA_GLOB_STR-VAANZ sy-vline
WA_GLOB_STR-ERNAM sy-vline
WA_GLOB_STR-ERDAT sy-vline
WA_GLOB_STR-AENAM sy-vline
WA_GLOB_STR-AEDAT sy-vline
WA_GLOB_STR-KOBVK sy-vline
WA_GLOB_STR-FADAT sy-vline
WA_GLOB_STR-SADAT sy-vline
WA_GLOB_STR-FLDAT sy-vline
WA_GLOB_STR-SLDAT sy-vline
WA_GLOB_STR-ADDIBELNR sy-vline
WA_GLOB_STR-VZKON sy-vline
WA_GLOB_STR-KALKE sy-vline
WA_GLOB_STR-PLTYP sy-vline
WA_GLOB_STR-NO_KALK sy-vline
WA_GLOB_STR-EKERV sy-vline
WA_GLOB_STR-RFCDEST sy-vline
WA_GLOB_STR-ERAPPL sy-vline
WA_GLOB_STR-KSCHL_PERC sy-vline
WA_GLOB_STR-KSCHL_VAL sy-vline
WA_GLOB_STR-PLUNP sy-vline
WA_GLOB_STR-PLURE sy-vline
WA_GLOB_STR-PLULO sy-vline
WA_GLOB_STR-MEDIA_TYPE sy-vline
WA_GLOB_STR-CUSTOMER_TYPE sy-vline
WA_GLOB_STR-ALLOW_PMAT_IGNO sy-vline
WA_GLOB_STR-ITEMS_4_BBY sy-vline
WA_GLOB_STR-ALLOW_DISP_MAT sy-vline
WA_GLOB_STR-INIT_SLS_PRICE sy-vline
WA_GLOB_STR-REF_PROMO sy-vline
WA_GLOB_STR-CGPL_GUID sy-vline
WA_GLOB_STR-EXTERNAL_ID sy-vline
WA_GLOB_STR-IS_REF_PROMO sy-vline
WA_GLOB_STR-BEKST2 sy-vline
WA_GLOB_STR-ERDOCN sy-vline
WA_GLOB_STR-HIER_ID sy-vline
WA_GLOB_STR-BPROF sy-vline
WA_GLOB_STR-SELKZ sy-vline
WA_GLOB_STR-UPDKZ sy-vline
WA_GLOB_STR-TXTL sy-vline
WA_GLOB_STR-AKTKT sy-vline
WA_GLOB_STR-TXTBZ sy-vline
WA_GLOB_STR-NUMKI sy-vline
WA_GLOB_STR-NUMKE sy-vline
WA_GLOB_STR-GEN_METHOD sy-vline
WA_GLOB_STR-PFLKN_MAX sy-vline
WA_GLOB_STR-PDUNP sy-vline
WA_GLOB_STR-PDURE sy-vline
WA_GLOB_STR-PDULO sy-vline
WA_GLOB_STR-REF_PROMO_TEXT sy-vline
WA_GLOB_STR-CGPL_PROJ_TEXT sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.