ABAP Select data from SAP table V_T496T 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 V_T496T 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_T496T. 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_T496T 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_T496T TYPE STANDARD TABLE OF V_T496T,
      WA_V_T496T TYPE V_T496T,
      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_T496T> TYPE V_T496T.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM V_T496T
*  INTO TABLE @DATA(IT_V_T496T2).
*--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_T496T INDEX 1 INTO DATA(WA_V_T496T2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<V_T496T>-MANDT = 1.
<V_T496T>-AUTYP = 1.
<V_T496T>-AUART = 1.
<V_T496T>-WERKS = 1.
<V_T496T>-DISPO = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_V_T496T-TCODE, sy-vline,
  WA_V_T496T-DVARG, sy-vline,
  WA_V_T496T-DCOPG, sy-vline,
  WA_V_T496T-PSTEU, sy-vline,
  WA_V_T496T-SLIST, sy-vline,
  WA_V_T496T-LGO1X, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_V_T496T 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_T496T 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_T496T INTO WA_V_T496T.


*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_V_T496T_STR, 
MANDT TYPE STRING,
AUTYP TYPE STRING,
AUART TYPE STRING,
WERKS TYPE STRING,
DISPO TYPE STRING,
TCODE TYPE STRING,
DVARG TYPE STRING,
DCOPG TYPE STRING,
PSTEU TYPE STRING,
SLIST TYPE STRING,
LGO1X TYPE STRING,
LG1VS TYPE STRING,
LG1CS TYPE STRING,
LG01P TYPE STRING,
LGO2X TYPE STRING,
LG2VS TYPE STRING,
LG2CS TYPE STRING,
LG02P TYPE STRING,
LGO3X TYPE STRING,
LG3VS TYPE STRING,
LG3CS TYPE STRING,
LG03P TYPE STRING,
LGO4X TYPE STRING,
LG4VS TYPE STRING,
LG4CS TYPE STRING,
LG04P TYPE STRING,
LVO1X TYPE STRING,
LV1VS TYPE STRING,
LV1CS TYPE STRING,
LV01P TYPE STRING,
LVO2X TYPE STRING,
LV2VS TYPE STRING,
LV2CS TYPE STRING,
LV02P TYPE STRING,
LVO3X TYPE STRING,
LV3VS TYPE STRING,
LV3CS TYPE STRING,
LV03P TYPE STRING,
LVO4X TYPE STRING,
LV4VS TYPE STRING,
LV4CS TYPE STRING,
LV04P TYPE STRING,
LFO1X TYPE STRING,
LF1VS TYPE STRING,
LF1CS TYPE STRING,
LF01P TYPE STRING,
LFO2X TYPE STRING,
LF2VS TYPE STRING,
LF2CS TYPE STRING,
LF02P TYPE STRING,
LFO3X TYPE STRING,
LF3VS TYPE STRING,
LF3CS TYPE STRING,
LF03P TYPE STRING,
LFO4X TYPE STRING,
LF4VS TYPE STRING,
LF4CS TYPE STRING,
LF04P TYPE STRING,
LKO1X TYPE STRING,
LK1VS TYPE STRING,
LK1CS TYPE STRING,
LK01P TYPE STRING,
LKO2X TYPE STRING,
LK2VS TYPE STRING,
LK2CS TYPE STRING,
LK02P TYPE STRING,
LKO3X TYPE STRING,
LK3VS TYPE STRING,
LK3CS TYPE STRING,
LK03P TYPE STRING,
LKO4X TYPE STRING,
LK4VS TYPE STRING,
LK4CS TYPE STRING,
LK04P TYPE STRING,
LPO1X TYPE STRING,
LP1VS TYPE STRING,
LP1CS TYPE STRING,
LP01P TYPE STRING,
LPO2X TYPE STRING,
LP2VS TYPE STRING,
LP2CS TYPE STRING,
LP02P TYPE STRING,
LPO3X TYPE STRING,
LP3VS TYPE STRING,
LP3CS TYPE STRING,
LP03P TYPE STRING,
LPO4X TYPE STRING,
LP4VS TYPE STRING,
LP4CS TYPE STRING,
LP04P TYPE STRING,
INFOS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_V_T496T_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_T496T_STR-MANDT sy-vline 
WA_V_T496T_STR-AUTYP sy-vline 
WA_V_T496T_STR-AUART sy-vline 
WA_V_T496T_STR-WERKS sy-vline 
WA_V_T496T_STR-DISPO sy-vline 
WA_V_T496T_STR-TCODE sy-vline 
WA_V_T496T_STR-DVARG sy-vline 
WA_V_T496T_STR-DCOPG sy-vline 
WA_V_T496T_STR-PSTEU sy-vline 
WA_V_T496T_STR-SLIST sy-vline 
WA_V_T496T_STR-LGO1X sy-vline 
WA_V_T496T_STR-LG1VS sy-vline 
WA_V_T496T_STR-LG1CS sy-vline 
WA_V_T496T_STR-LG01P sy-vline 
WA_V_T496T_STR-LGO2X sy-vline 
WA_V_T496T_STR-LG2VS sy-vline 
WA_V_T496T_STR-LG2CS sy-vline 
WA_V_T496T_STR-LG02P sy-vline 
WA_V_T496T_STR-LGO3X sy-vline 
WA_V_T496T_STR-LG3VS sy-vline 
WA_V_T496T_STR-LG3CS sy-vline 
WA_V_T496T_STR-LG03P sy-vline 
WA_V_T496T_STR-LGO4X sy-vline 
WA_V_T496T_STR-LG4VS sy-vline 
WA_V_T496T_STR-LG4CS sy-vline 
WA_V_T496T_STR-LG04P sy-vline 
WA_V_T496T_STR-LVO1X sy-vline 
WA_V_T496T_STR-LV1VS sy-vline 
WA_V_T496T_STR-LV1CS sy-vline 
WA_V_T496T_STR-LV01P sy-vline 
WA_V_T496T_STR-LVO2X sy-vline 
WA_V_T496T_STR-LV2VS sy-vline 
WA_V_T496T_STR-LV2CS sy-vline 
WA_V_T496T_STR-LV02P sy-vline 
WA_V_T496T_STR-LVO3X sy-vline 
WA_V_T496T_STR-LV3VS sy-vline 
WA_V_T496T_STR-LV3CS sy-vline 
WA_V_T496T_STR-LV03P sy-vline 
WA_V_T496T_STR-LVO4X sy-vline 
WA_V_T496T_STR-LV4VS sy-vline 
WA_V_T496T_STR-LV4CS sy-vline 
WA_V_T496T_STR-LV04P sy-vline 
WA_V_T496T_STR-LFO1X sy-vline 
WA_V_T496T_STR-LF1VS sy-vline 
WA_V_T496T_STR-LF1CS sy-vline 
WA_V_T496T_STR-LF01P sy-vline 
WA_V_T496T_STR-LFO2X sy-vline 
WA_V_T496T_STR-LF2VS sy-vline 
WA_V_T496T_STR-LF2CS sy-vline 
WA_V_T496T_STR-LF02P sy-vline 
WA_V_T496T_STR-LFO3X sy-vline 
WA_V_T496T_STR-LF3VS sy-vline 
WA_V_T496T_STR-LF3CS sy-vline 
WA_V_T496T_STR-LF03P sy-vline 
WA_V_T496T_STR-LFO4X sy-vline 
WA_V_T496T_STR-LF4VS sy-vline 
WA_V_T496T_STR-LF4CS sy-vline 
WA_V_T496T_STR-LF04P sy-vline 
WA_V_T496T_STR-LKO1X sy-vline 
WA_V_T496T_STR-LK1VS sy-vline 
WA_V_T496T_STR-LK1CS sy-vline 
WA_V_T496T_STR-LK01P sy-vline 
WA_V_T496T_STR-LKO2X sy-vline 
WA_V_T496T_STR-LK2VS sy-vline 
WA_V_T496T_STR-LK2CS sy-vline 
WA_V_T496T_STR-LK02P sy-vline 
WA_V_T496T_STR-LKO3X sy-vline 
WA_V_T496T_STR-LK3VS sy-vline 
WA_V_T496T_STR-LK3CS sy-vline 
WA_V_T496T_STR-LK03P sy-vline 
WA_V_T496T_STR-LKO4X sy-vline 
WA_V_T496T_STR-LK4VS sy-vline 
WA_V_T496T_STR-LK4CS sy-vline 
WA_V_T496T_STR-LK04P sy-vline 
WA_V_T496T_STR-LPO1X sy-vline 
WA_V_T496T_STR-LP1VS sy-vline 
WA_V_T496T_STR-LP1CS sy-vline 
WA_V_T496T_STR-LP01P sy-vline 
WA_V_T496T_STR-LPO2X sy-vline 
WA_V_T496T_STR-LP2VS sy-vline 
WA_V_T496T_STR-LP2CS sy-vline 
WA_V_T496T_STR-LP02P sy-vline 
WA_V_T496T_STR-LPO3X sy-vline 
WA_V_T496T_STR-LP3VS sy-vline 
WA_V_T496T_STR-LP3CS sy-vline 
WA_V_T496T_STR-LP03P sy-vline 
WA_V_T496T_STR-LPO4X sy-vline 
WA_V_T496T_STR-LP4VS sy-vline 
WA_V_T496T_STR-LP4CS sy-vline 
WA_V_T496T_STR-LP04P sy-vline 
WA_V_T496T_STR-INFOS sy-vline      INTO ld_text SEPARATED BY SPACE.

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