ABAP Select data from SAP table VV_T554C_X 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_X 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_X. 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_X 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_X TYPE STANDARD TABLE OF VV_T554C_X,
      WA_VV_T554C_X TYPE VV_T554C_X,
      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_X> TYPE VV_T554C_X.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM VV_T554C_X
*  INTO TABLE @DATA(IT_VV_T554C_X2).
*--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_X INDEX 1 INTO DATA(WA_VV_T554C_X2).


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

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

ENDLOOP.

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

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


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