ABAP Select data from SAP table VV_T554C_O 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 VV_T554C_O 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 VV_T554C_O. 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 VV_T554C_O 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_VV_T554C_O TYPE STANDARD TABLE OF VV_T554C_O,
      WA_VV_T554C_O TYPE VV_T554C_O,
      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: <VV_T554C_O> TYPE VV_T554C_O.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM VV_T554C_O
*  INTO TABLE @DATA(IT_VV_T554C_O2).
*--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_VV_T554C_O INDEX 1 INTO DATA(WA_VV_T554C_O2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<VV_T554C_O>-MANDT = 1.
<VV_T554C_O>-MOLGA = 1.
<VV_T554C_O>-MODIF = 1.
<VV_T554C_O>-KLBEW = 1.
<VV_T554C_O>-OCABS = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_VV_T554C_O-ENDDA, sy-vline,
  WA_VV_T554C_O-BEGDA, sy-vline,
  WA_VV_T554C_O-TEXTS, sy-vline,
  WA_VV_T554C_O-KLS01, sy-vline,
  WA_VV_T554C_O-REF01, sy-vline,
  WA_VV_T554C_O-PRC01, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_VV_T554C_O 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_VV_T554C_O 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_VV_T554C_O INTO WA_VV_T554C_O.


*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_VV_T554C_O_STR, 
MANDT TYPE STRING,
MOLGA TYPE STRING,
MODIF TYPE STRING,
KLBEW TYPE STRING,
OCABS TYPE STRING,
ENDDA TYPE STRING,
BEGDA TYPE STRING,
TEXTS TYPE STRING,
KLS01 TYPE STRING,
REF01 TYPE STRING,
PRC01 TYPE STRING,
DRC01 TYPE STRING,
KLS02 TYPE STRING,
REF02 TYPE STRING,
PRC02 TYPE STRING,
DRC02 TYPE STRING,
KLS03 TYPE STRING,
REF03 TYPE STRING,
PRC03 TYPE STRING,
DRC03 TYPE STRING,
KLS04 TYPE STRING,
REF04 TYPE STRING,
PRC04 TYPE STRING,
DRC04 TYPE STRING,
KLS05 TYPE STRING,
REF05 TYPE STRING,
PRC05 TYPE STRING,
DRC05 TYPE STRING,
KLS06 TYPE STRING,
REF06 TYPE STRING,
PRC06 TYPE STRING,
DRC06 TYPE STRING,
KLS07 TYPE STRING,
REF07 TYPE STRING,
PRC07 TYPE STRING,
DRC07 TYPE STRING,
KLS08 TYPE STRING,
REF08 TYPE STRING,
PRC08 TYPE STRING,
DRC08 TYPE STRING,
KLS09 TYPE STRING,
REF09 TYPE STRING,
PRC09 TYPE STRING,
DRC09 TYPE STRING,
KLS10 TYPE STRING,
REF10 TYPE STRING,
PRC10 TYPE STRING,
DRC10 TYPE STRING,
TIM01 TYPE STRING,
TPR01 TYPE STRING,
UNT01 TYPE STRING,
SPL01 TYPE STRING,
LGA01 TYPE STRING,
DRW01 TYPE STRING,
TIM02 TYPE STRING,
TPR02 TYPE STRING,
UNT02 TYPE STRING,
SPL02 TYPE STRING,
LGA02 TYPE STRING,
DRW02 TYPE STRING,
TIM03 TYPE STRING,
TPR03 TYPE STRING,
UNT03 TYPE STRING,
SPL03 TYPE STRING,
LGA03 TYPE STRING,
DRW03 TYPE STRING,
TIM04 TYPE STRING,
TPR04 TYPE STRING,
UNT04 TYPE STRING,
SPL04 TYPE STRING,
LGA04 TYPE STRING,
DRW04 TYPE STRING,
TIM05 TYPE STRING,
TPR05 TYPE STRING,
UNT05 TYPE STRING,
SPL05 TYPE STRING,
LGA05 TYPE STRING,
DRW05 TYPE STRING,
TIM06 TYPE STRING,
TPR06 TYPE STRING,
UNT06 TYPE STRING,
SPL06 TYPE STRING,
LGA06 TYPE STRING,
DRW06 TYPE STRING,
TIM07 TYPE STRING,
TPR07 TYPE STRING,
UNT07 TYPE STRING,
SPL07 TYPE STRING,
LGA07 TYPE STRING,
DRW07 TYPE STRING,
TIM08 TYPE STRING,
TPR08 TYPE STRING,
UNT08 TYPE STRING,
SPL08 TYPE STRING,
LGA08 TYPE STRING,
DRW08 TYPE STRING,
TIM09 TYPE STRING,
TPR09 TYPE STRING,
UNT09 TYPE STRING,
SPL09 TYPE STRING,
LGA09 TYPE STRING,
DRW09 TYPE STRING,
TIM10 TYPE STRING,
TPR10 TYPE STRING,
UNT10 TYPE STRING,
SPL10 TYPE STRING,
LGA10 TYPE STRING,
DRW10 TYPE STRING,
TIM11 TYPE STRING,
TPR11 TYPE STRING,
UNT11 TYPE STRING,
SPL11 TYPE STRING,
LGA11 TYPE STRING,
DRW11 TYPE STRING,
TIM12 TYPE STRING,
TPR12 TYPE STRING,
UNT12 TYPE STRING,
SPL12 TYPE STRING,
LGA12 TYPE STRING,
DRW12 TYPE STRING,
TIM13 TYPE STRING,
TPR13 TYPE STRING,
UNT13 TYPE STRING,
SPL13 TYPE STRING,
LGA13 TYPE STRING,
DRW13 TYPE STRING,
TIM14 TYPE STRING,
TPR14 TYPE STRING,
UNT14 TYPE STRING,
SPL14 TYPE STRING,
LGA14 TYPE STRING,
DRW14 TYPE STRING,
TIM15 TYPE STRING,
TPR15 TYPE STRING,
UNT15 TYPE STRING,
SPL15 TYPE STRING,
LGA15 TYPE STRING,
DRW15 TYPE STRING,
CYCLS TYPE STRING,
TIMES TYPE STRING,
OPERA TYPE STRING,
GENER TYPE STRING,END OF T_EKKO_STR.
DATA: WA_VV_T554C_O_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_VV_T554C_O_STR-MANDT sy-vline 
WA_VV_T554C_O_STR-MOLGA sy-vline 
WA_VV_T554C_O_STR-MODIF sy-vline 
WA_VV_T554C_O_STR-KLBEW sy-vline 
WA_VV_T554C_O_STR-OCABS sy-vline 
WA_VV_T554C_O_STR-ENDDA sy-vline 
WA_VV_T554C_O_STR-BEGDA sy-vline 
WA_VV_T554C_O_STR-TEXTS sy-vline 
WA_VV_T554C_O_STR-KLS01 sy-vline 
WA_VV_T554C_O_STR-REF01 sy-vline 
WA_VV_T554C_O_STR-PRC01 sy-vline 
WA_VV_T554C_O_STR-DRC01 sy-vline 
WA_VV_T554C_O_STR-KLS02 sy-vline 
WA_VV_T554C_O_STR-REF02 sy-vline 
WA_VV_T554C_O_STR-PRC02 sy-vline 
WA_VV_T554C_O_STR-DRC02 sy-vline 
WA_VV_T554C_O_STR-KLS03 sy-vline 
WA_VV_T554C_O_STR-REF03 sy-vline 
WA_VV_T554C_O_STR-PRC03 sy-vline 
WA_VV_T554C_O_STR-DRC03 sy-vline 
WA_VV_T554C_O_STR-KLS04 sy-vline 
WA_VV_T554C_O_STR-REF04 sy-vline 
WA_VV_T554C_O_STR-PRC04 sy-vline 
WA_VV_T554C_O_STR-DRC04 sy-vline 
WA_VV_T554C_O_STR-KLS05 sy-vline 
WA_VV_T554C_O_STR-REF05 sy-vline 
WA_VV_T554C_O_STR-PRC05 sy-vline 
WA_VV_T554C_O_STR-DRC05 sy-vline 
WA_VV_T554C_O_STR-KLS06 sy-vline 
WA_VV_T554C_O_STR-REF06 sy-vline 
WA_VV_T554C_O_STR-PRC06 sy-vline 
WA_VV_T554C_O_STR-DRC06 sy-vline 
WA_VV_T554C_O_STR-KLS07 sy-vline 
WA_VV_T554C_O_STR-REF07 sy-vline 
WA_VV_T554C_O_STR-PRC07 sy-vline 
WA_VV_T554C_O_STR-DRC07 sy-vline 
WA_VV_T554C_O_STR-KLS08 sy-vline 
WA_VV_T554C_O_STR-REF08 sy-vline 
WA_VV_T554C_O_STR-PRC08 sy-vline 
WA_VV_T554C_O_STR-DRC08 sy-vline 
WA_VV_T554C_O_STR-KLS09 sy-vline 
WA_VV_T554C_O_STR-REF09 sy-vline 
WA_VV_T554C_O_STR-PRC09 sy-vline 
WA_VV_T554C_O_STR-DRC09 sy-vline 
WA_VV_T554C_O_STR-KLS10 sy-vline 
WA_VV_T554C_O_STR-REF10 sy-vline 
WA_VV_T554C_O_STR-PRC10 sy-vline 
WA_VV_T554C_O_STR-DRC10 sy-vline 
WA_VV_T554C_O_STR-TIM01 sy-vline 
WA_VV_T554C_O_STR-TPR01 sy-vline 
WA_VV_T554C_O_STR-UNT01 sy-vline 
WA_VV_T554C_O_STR-SPL01 sy-vline 
WA_VV_T554C_O_STR-LGA01 sy-vline 
WA_VV_T554C_O_STR-DRW01 sy-vline 
WA_VV_T554C_O_STR-TIM02 sy-vline 
WA_VV_T554C_O_STR-TPR02 sy-vline 
WA_VV_T554C_O_STR-UNT02 sy-vline 
WA_VV_T554C_O_STR-SPL02 sy-vline 
WA_VV_T554C_O_STR-LGA02 sy-vline 
WA_VV_T554C_O_STR-DRW02 sy-vline 
WA_VV_T554C_O_STR-TIM03 sy-vline 
WA_VV_T554C_O_STR-TPR03 sy-vline 
WA_VV_T554C_O_STR-UNT03 sy-vline 
WA_VV_T554C_O_STR-SPL03 sy-vline 
WA_VV_T554C_O_STR-LGA03 sy-vline 
WA_VV_T554C_O_STR-DRW03 sy-vline 
WA_VV_T554C_O_STR-TIM04 sy-vline 
WA_VV_T554C_O_STR-TPR04 sy-vline 
WA_VV_T554C_O_STR-UNT04 sy-vline 
WA_VV_T554C_O_STR-SPL04 sy-vline 
WA_VV_T554C_O_STR-LGA04 sy-vline 
WA_VV_T554C_O_STR-DRW04 sy-vline 
WA_VV_T554C_O_STR-TIM05 sy-vline 
WA_VV_T554C_O_STR-TPR05 sy-vline 
WA_VV_T554C_O_STR-UNT05 sy-vline 
WA_VV_T554C_O_STR-SPL05 sy-vline 
WA_VV_T554C_O_STR-LGA05 sy-vline 
WA_VV_T554C_O_STR-DRW05 sy-vline 
WA_VV_T554C_O_STR-TIM06 sy-vline 
WA_VV_T554C_O_STR-TPR06 sy-vline 
WA_VV_T554C_O_STR-UNT06 sy-vline 
WA_VV_T554C_O_STR-SPL06 sy-vline 
WA_VV_T554C_O_STR-LGA06 sy-vline 
WA_VV_T554C_O_STR-DRW06 sy-vline 
WA_VV_T554C_O_STR-TIM07 sy-vline 
WA_VV_T554C_O_STR-TPR07 sy-vline 
WA_VV_T554C_O_STR-UNT07 sy-vline 
WA_VV_T554C_O_STR-SPL07 sy-vline 
WA_VV_T554C_O_STR-LGA07 sy-vline 
WA_VV_T554C_O_STR-DRW07 sy-vline 
WA_VV_T554C_O_STR-TIM08 sy-vline 
WA_VV_T554C_O_STR-TPR08 sy-vline 
WA_VV_T554C_O_STR-UNT08 sy-vline 
WA_VV_T554C_O_STR-SPL08 sy-vline 
WA_VV_T554C_O_STR-LGA08 sy-vline 
WA_VV_T554C_O_STR-DRW08 sy-vline 
WA_VV_T554C_O_STR-TIM09 sy-vline 
WA_VV_T554C_O_STR-TPR09 sy-vline 
WA_VV_T554C_O_STR-UNT09 sy-vline 
WA_VV_T554C_O_STR-SPL09 sy-vline 
WA_VV_T554C_O_STR-LGA09 sy-vline 
WA_VV_T554C_O_STR-DRW09 sy-vline 
WA_VV_T554C_O_STR-TIM10 sy-vline 
WA_VV_T554C_O_STR-TPR10 sy-vline 
WA_VV_T554C_O_STR-UNT10 sy-vline 
WA_VV_T554C_O_STR-SPL10 sy-vline 
WA_VV_T554C_O_STR-LGA10 sy-vline 
WA_VV_T554C_O_STR-DRW10 sy-vline 
WA_VV_T554C_O_STR-TIM11 sy-vline 
WA_VV_T554C_O_STR-TPR11 sy-vline 
WA_VV_T554C_O_STR-UNT11 sy-vline 
WA_VV_T554C_O_STR-SPL11 sy-vline 
WA_VV_T554C_O_STR-LGA11 sy-vline 
WA_VV_T554C_O_STR-DRW11 sy-vline 
WA_VV_T554C_O_STR-TIM12 sy-vline 
WA_VV_T554C_O_STR-TPR12 sy-vline 
WA_VV_T554C_O_STR-UNT12 sy-vline 
WA_VV_T554C_O_STR-SPL12 sy-vline 
WA_VV_T554C_O_STR-LGA12 sy-vline 
WA_VV_T554C_O_STR-DRW12 sy-vline 
WA_VV_T554C_O_STR-TIM13 sy-vline 
WA_VV_T554C_O_STR-TPR13 sy-vline 
WA_VV_T554C_O_STR-UNT13 sy-vline 
WA_VV_T554C_O_STR-SPL13 sy-vline 
WA_VV_T554C_O_STR-LGA13 sy-vline 
WA_VV_T554C_O_STR-DRW13 sy-vline 
WA_VV_T554C_O_STR-TIM14 sy-vline 
WA_VV_T554C_O_STR-TPR14 sy-vline 
WA_VV_T554C_O_STR-UNT14 sy-vline 
WA_VV_T554C_O_STR-SPL14 sy-vline 
WA_VV_T554C_O_STR-LGA14 sy-vline 
WA_VV_T554C_O_STR-DRW14 sy-vline 
WA_VV_T554C_O_STR-TIM15 sy-vline 
WA_VV_T554C_O_STR-TPR15 sy-vline 
WA_VV_T554C_O_STR-UNT15 sy-vline 
WA_VV_T554C_O_STR-SPL15 sy-vline 
WA_VV_T554C_O_STR-LGA15 sy-vline 
WA_VV_T554C_O_STR-DRW15 sy-vline 
WA_VV_T554C_O_STR-CYCLS sy-vline 
WA_VV_T554C_O_STR-TIMES sy-vline 
WA_VV_T554C_O_STR-OPERA sy-vline 
WA_VV_T554C_O_STR-GENER sy-vline      INTO ld_text SEPARATED BY SPACE.

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