ABAP Select data from SAP table VIAJRECORD 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 VIAJRECORD 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 VIAJRECORD. 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 VIAJRECORD 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_VIAJRECORD TYPE STANDARD TABLE OF VIAJRECORD,
      WA_VIAJRECORD TYPE VIAJRECORD,
      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: <VIAJRECORD> TYPE VIAJRECORD.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM VIAJRECORD
*  INTO TABLE @DATA(IT_VIAJRECORD2).
*--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_VIAJRECORD INDEX 1 INTO DATA(WA_VIAJRECORD2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<VIAJRECORD>-MANDT = 1.
<VIAJRECORD>-RECORDGUID = 1.
<VIAJRECORD>-PROCESSGUID = 1.
<VIAJRECORD>-INTRENO = 1.
<VIAJRECORD>-TERMNO = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_VIAJRECORD-ADJMRULE, sy-vline,
  WA_VIAJRECORD-ADJMSUBRULE, sy-vline,
  WA_VIAJRECORD-ADJMSUBMETH, sy-vline,
  WA_VIAJRECORD-ADJMDRECORDSTAT, sy-vline,
  WA_VIAJRECORD-ADJMRULEDEFAULT, sy-vline,
  WA_VIAJRECORD-ADJMRECSTEPNO, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_VIAJRECORD 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_VIAJRECORD 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_VIAJRECORD INTO WA_VIAJRECORD.


*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 TERMNO
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_VIAJRECORD-TERMNO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VIAJRECORD-TERMNO.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit REDAT, internal->external for field CONDVALIDTOOLD
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_VIAJRECORD-CONDVALIDTOOLD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VIAJRECORD-CONDVALIDTOOLD.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field TERMNOAJNEW
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_VIAJRECORD-TERMNOAJNEW
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VIAJRECORD-TERMNOAJNEW.
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_VIAJRECORD_STR, 
MANDT TYPE STRING,
RECORDGUID TYPE STRING,
PROCESSGUID TYPE STRING,
INTRENO TYPE STRING,
TERMNO TYPE STRING,
ADJMRULE TYPE STRING,
ADJMSUBRULE TYPE STRING,
ADJMSUBMETH TYPE STRING,
ADJMDRECORDSTAT TYPE STRING,
ADJMRULEDEFAULT TYPE STRING,
ADJMRECSTEPNO TYPE STRING,
DERF TYPE STRING,
TERF TYPE STRING,
RERF TYPE STRING,
FDELETE TYPE STRING,
CONDGUIDOLD TYPE STRING,
CONDGUIDNEW TYPE STRING,
CONDGUIDREF TYPE STRING,
ADJMFROMOLD TYPE STRING,
ADJMFROMCALC TYPE STRING,
ADJMFROMMOD TYPE STRING,
UNITPRICEOLD TYPE STRING,
UNITPRICECALC TYPE STRING,
UNITPRICEMOD TYPE STRING,
ADJMCONDDELETE TYPE STRING,
METHREFGUID TYPE STRING,
ADJMFROMMODDATE TYPE STRING,
ADJMFROMMODUSER TYPE STRING,
UNITPRICEMODDATE TYPE STRING,
UNITPRICEMODUSER TYPE STRING,
CONDVALIDTOOLD TYPE STRING,
ADJMCONDNEW TYPE STRING,
UPBEFORECAPPING TYPE STRING,
MONTHCAPPING TYPE STRING,
DISSOLVEINGUID TYPE STRING,
ADJMREASON TYPE STRING,
CHGREASON TYPE STRING,
CHGREASONOLD TYPE STRING,
CARRYFROMGUID TYPE STRING,
CARRYOVERCT TYPE STRING,
RECGROUPGUID TYPE STRING,
INTRENODEPEND TYPE STRING,
RECORDUPDATE TYPE STRING,
UNITPRICEANN TYPE STRING,
ADJMFROMANN TYPE STRING,
CONDPURPOSENEW TYPE STRING,
CONDTYPECEA TYPE STRING,
CONDTYPENEW TYPE STRING,
TERMNOAJNEW TYPE STRING,
TAKETERMNO TYPE STRING,
MAXINCREL TYPE STRING,
UPLESSCAPMONTH TYPE STRING,
ADJMFROMLESSCM TYPE STRING,
UPPOSMARGIN TYPE STRING,
UPPOSMARGINUSED TYPE STRING,
UPINCALLOWED TYPE STRING,
UNITPRICEMODZERO TYPE STRING,
ADJMACTIVDATE TYPE STRING,
ADJMACTIVUSER TYPE STRING,
DUEDATEUP TYPE STRING,
DUEDATEUPOLD TYPE STRING,
ADJMANNOUNCETO TYPE STRING,
ADJMANNOUNCEDATE TYPE STRING,
ADJMANNOUNCEUSER TYPE STRING,
ADJMAPPROVALTO TYPE STRING,
ADJMAPPROVALDATE TYPE STRING,
ADJMAPPROVALUSER TYPE STRING,
ADJMDECLINEDATE TYPE STRING,
ADJMDECLINEUSER TYPE STRING,
ADJMREVERSALDATE TYPE STRING,
ADJMREVERSALUSER TYPE STRING,
ADJMDOCDATE TYPE STRING,
ADJMDOCCOUNT TYPE STRING,
ADJMDUNLEVEL TYPE STRING,
ADJMDUNDATE TYPE STRING,
ADJMDUNCOUNT TYPE STRING,
ADJMAPPDATE TYPE STRING,
ADJMAPPCOUNT TYPE STRING,
ADJMANNDATE TYPE STRING,
ADJMANNCOUNT TYPE STRING,
ADJMDEACTIVDATE TYPE STRING,
ADJMDEACTIVUSER TYPE STRING,END OF T_EKKO_STR.
DATA: WA_VIAJRECORD_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_VIAJRECORD_STR-MANDT sy-vline 
WA_VIAJRECORD_STR-RECORDGUID sy-vline 
WA_VIAJRECORD_STR-PROCESSGUID sy-vline 
WA_VIAJRECORD_STR-INTRENO sy-vline 
WA_VIAJRECORD_STR-TERMNO sy-vline 
WA_VIAJRECORD_STR-ADJMRULE sy-vline 
WA_VIAJRECORD_STR-ADJMSUBRULE sy-vline 
WA_VIAJRECORD_STR-ADJMSUBMETH sy-vline 
WA_VIAJRECORD_STR-ADJMDRECORDSTAT sy-vline 
WA_VIAJRECORD_STR-ADJMRULEDEFAULT sy-vline 
WA_VIAJRECORD_STR-ADJMRECSTEPNO sy-vline 
WA_VIAJRECORD_STR-DERF sy-vline 
WA_VIAJRECORD_STR-TERF sy-vline 
WA_VIAJRECORD_STR-RERF sy-vline 
WA_VIAJRECORD_STR-FDELETE sy-vline 
WA_VIAJRECORD_STR-CONDGUIDOLD sy-vline 
WA_VIAJRECORD_STR-CONDGUIDNEW sy-vline 
WA_VIAJRECORD_STR-CONDGUIDREF sy-vline 
WA_VIAJRECORD_STR-ADJMFROMOLD sy-vline 
WA_VIAJRECORD_STR-ADJMFROMCALC sy-vline 
WA_VIAJRECORD_STR-ADJMFROMMOD sy-vline 
WA_VIAJRECORD_STR-UNITPRICEOLD sy-vline 
WA_VIAJRECORD_STR-UNITPRICECALC sy-vline 
WA_VIAJRECORD_STR-UNITPRICEMOD sy-vline 
WA_VIAJRECORD_STR-ADJMCONDDELETE sy-vline 
WA_VIAJRECORD_STR-METHREFGUID sy-vline 
WA_VIAJRECORD_STR-ADJMFROMMODDATE sy-vline 
WA_VIAJRECORD_STR-ADJMFROMMODUSER sy-vline 
WA_VIAJRECORD_STR-UNITPRICEMODDATE sy-vline 
WA_VIAJRECORD_STR-UNITPRICEMODUSER sy-vline 
WA_VIAJRECORD_STR-CONDVALIDTOOLD sy-vline 
WA_VIAJRECORD_STR-ADJMCONDNEW sy-vline 
WA_VIAJRECORD_STR-UPBEFORECAPPING sy-vline 
WA_VIAJRECORD_STR-MONTHCAPPING sy-vline 
WA_VIAJRECORD_STR-DISSOLVEINGUID sy-vline 
WA_VIAJRECORD_STR-ADJMREASON sy-vline 
WA_VIAJRECORD_STR-CHGREASON sy-vline 
WA_VIAJRECORD_STR-CHGREASONOLD sy-vline 
WA_VIAJRECORD_STR-CARRYFROMGUID sy-vline 
WA_VIAJRECORD_STR-CARRYOVERCT sy-vline 
WA_VIAJRECORD_STR-RECGROUPGUID sy-vline 
WA_VIAJRECORD_STR-INTRENODEPEND sy-vline 
WA_VIAJRECORD_STR-RECORDUPDATE sy-vline 
WA_VIAJRECORD_STR-UNITPRICEANN sy-vline 
WA_VIAJRECORD_STR-ADJMFROMANN sy-vline 
WA_VIAJRECORD_STR-CONDPURPOSENEW sy-vline 
WA_VIAJRECORD_STR-CONDTYPECEA sy-vline 
WA_VIAJRECORD_STR-CONDTYPENEW sy-vline 
WA_VIAJRECORD_STR-TERMNOAJNEW sy-vline 
WA_VIAJRECORD_STR-TAKETERMNO sy-vline 
WA_VIAJRECORD_STR-MAXINCREL sy-vline 
WA_VIAJRECORD_STR-UPLESSCAPMONTH sy-vline 
WA_VIAJRECORD_STR-ADJMFROMLESSCM sy-vline 
WA_VIAJRECORD_STR-UPPOSMARGIN sy-vline 
WA_VIAJRECORD_STR-UPPOSMARGINUSED sy-vline 
WA_VIAJRECORD_STR-UPINCALLOWED sy-vline 
WA_VIAJRECORD_STR-UNITPRICEMODZERO sy-vline 
WA_VIAJRECORD_STR-ADJMACTIVDATE sy-vline 
WA_VIAJRECORD_STR-ADJMACTIVUSER sy-vline 
WA_VIAJRECORD_STR-DUEDATEUP sy-vline 
WA_VIAJRECORD_STR-DUEDATEUPOLD sy-vline 
WA_VIAJRECORD_STR-ADJMANNOUNCETO sy-vline 
WA_VIAJRECORD_STR-ADJMANNOUNCEDATE sy-vline 
WA_VIAJRECORD_STR-ADJMANNOUNCEUSER sy-vline 
WA_VIAJRECORD_STR-ADJMAPPROVALTO sy-vline 
WA_VIAJRECORD_STR-ADJMAPPROVALDATE sy-vline 
WA_VIAJRECORD_STR-ADJMAPPROVALUSER sy-vline 
WA_VIAJRECORD_STR-ADJMDECLINEDATE sy-vline 
WA_VIAJRECORD_STR-ADJMDECLINEUSER sy-vline 
WA_VIAJRECORD_STR-ADJMREVERSALDATE sy-vline 
WA_VIAJRECORD_STR-ADJMREVERSALUSER sy-vline 
WA_VIAJRECORD_STR-ADJMDOCDATE sy-vline 
WA_VIAJRECORD_STR-ADJMDOCCOUNT sy-vline 
WA_VIAJRECORD_STR-ADJMDUNLEVEL sy-vline 
WA_VIAJRECORD_STR-ADJMDUNDATE sy-vline 
WA_VIAJRECORD_STR-ADJMDUNCOUNT sy-vline 
WA_VIAJRECORD_STR-ADJMAPPDATE sy-vline 
WA_VIAJRECORD_STR-ADJMAPPCOUNT sy-vline 
WA_VIAJRECORD_STR-ADJMANNDATE sy-vline 
WA_VIAJRECORD_STR-ADJMANNCOUNT sy-vline 
WA_VIAJRECORD_STR-ADJMDEACTIVDATE sy-vline 
WA_VIAJRECORD_STR-ADJMDEACTIVUSER sy-vline      INTO ld_text SEPARATED BY SPACE.

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