ABAP Select data from SAP table BIW_FI_TV_02 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 BIW_FI_TV_02 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 BIW_FI_TV_02. 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 BIW_FI_TV_02 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_BIW_FI_TV_02 TYPE STANDARD TABLE OF BIW_FI_TV_02,
      WA_BIW_FI_TV_02 TYPE BIW_FI_TV_02,
      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: <BIW_FI_TV_02> TYPE BIW_FI_TV_02.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM BIW_FI_TV_02
*  INTO TABLE @DATA(IT_BIW_FI_TV_022).
*--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_BIW_FI_TV_02 INDEX 1 INTO DATA(WA_BIW_FI_TV_022).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<BIW_FI_TV_02>-PERNR = 1.
<BIW_FI_TV_02>-REINR = 1.
<BIW_FI_TV_02>-ENTRY_TYPE = 1.
<BIW_FI_TV_02>-WAERS = 1.
<BIW_FI_TV_02>-MOLGA = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_BIW_FI_TV_02-MOREI, sy-vline,
  WA_BIW_FI_TV_02-SCHEM, sy-vline,
  WA_BIW_FI_TV_02-KZREA, sy-vline,
  WA_BIW_FI_TV_02-BEREI, sy-vline,
  WA_BIW_FI_TV_02-KZTKT, sy-vline,
  WA_BIW_FI_TV_02-ZLAND, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_BIW_FI_TV_02 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_BIW_FI_TV_02 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_BIW_FI_TV_02 INTO WA_BIW_FI_TV_02.


*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 FMCTP, internal->external for field HOTEL_PROPERTY
CALL FUNCTION 'CONVERSION_EXIT_FMCTP_OUTPUT'
  EXPORTING
    input =                      WA_BIW_FI_TV_02-HOTEL_PROPERTY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BIW_FI_TV_02-HOTEL_PROPERTY.
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_BIW_FI_TV_02_STR, 
PERNR TYPE STRING,
REINR TYPE STRING,
ENTRY_TYPE TYPE STRING,
WAERS TYPE STRING,
MOLGA TYPE STRING,
MOREI TYPE STRING,
SCHEM TYPE STRING,
KZREA TYPE STRING,
BEREI TYPE STRING,
KZTKT TYPE STRING,
ZLAND TYPE STRING,
HRGIO TYPE STRING,
DATV1 TYPE STRING,
UHRV1 TYPE STRING,
DATB1 TYPE STRING,
UHRB1 TYPE STRING,
PLAN_STATUS TYPE STRING,
ACTIVITY_TYPE TYPE STRING,
REC_LOCATOR TYPE STRING,
USERG TYPE STRING,
CATEGORY TYPE STRING,
BELNR TYPE STRING,
REAL_CAT TYPE STRING,
HOTEL_CHAIN TYPE STRING,
HOTEL_PROPERTY TYPE STRING,
HOTEL_DATE_ARR TYPE STRING,
HOTEL_DATE_DEP TYPE STRING,
HOTEL_LOC TYPE STRING,
HOTEL_NAME TYPE STRING,
HOTEL_ROOMTYPE TYPE STRING,
HOTEL_MEALS TYPE STRING,
HOTEL_RATE TYPE STRING,
HOTEL_PRICE TYPE STRING,
HOTEL_STATUS TYPE STRING,
HOTEL_RATE_CODE TYPE STRING,
ROOM_RATE_CODE TYPE STRING,
HOTEL_AREA TYPE STRING,
HOTEL_NIGHTS TYPE STRING,
HOTEL_BOOKINGS TYPE STRING,
CAR_PROVIDER TYPE STRING,
CAR_DATE_BEG TYPE STRING,
CAR_LOC_BEG TYPE STRING,
CAR_DATE_END TYPE STRING,
CAR_LOC_END TYPE STRING,
CAR_CLASS TYPE STRING,
CAR_TYPE TYPE STRING,
CAR_PRICE TYPE STRING,
CAR_RATE_CODE TYPE STRING,
CAR_TOT_RATETYPE TYPE STRING,
CAR_TOTAL_RATE TYPE STRING,
CAR_STATUS TYPE STRING,
CAR_AREA TYPE STRING,
CAR_DAYS TYPE STRING,
CAR_BOOKINGS TYPE STRING,
CAR_PICKUP_LOC TYPE STRING,
AIRLINE TYPE STRING,
FLIGHT_NR TYPE STRING,
FLIGHT_DATE_DEP TYPE STRING,
FLIGHT_TIME_DEP TYPE STRING,
FLIGHT_LOC_DEP TYPE STRING,
FLIGHT_LOC_ARR TYPE STRING,
RESTRICT_FARE TYPE STRING,
FLIGHT_CABIN TYPE STRING,
FLIGHT_RBD TYPE STRING,
FLIGHT_STATUS TYPE STRING,
FLIGHT_NUMBER TYPE STRING,
FARE_BASIS_CODE TYPE STRING,
LOCAL_TST TYPE STRING,
LAST_DATE TYPE STRING,
TICKET_MODE TYPE STRING,
SALES_IND TYPE STRING,
FARE TYPE STRING,
TOTAL_FARE TYPE STRING,
AIRLINE1 TYPE STRING,
AIRLINE2 TYPE STRING,
AIRLINE3 TYPE STRING,
AIRLINE4 TYPE STRING,
AIRLINE_UNIQUE TYPE STRING,
FLIGHT_CABIN1 TYPE STRING,
FLIGHT_CABIN2 TYPE STRING,
FLIGHT_CABIN3 TYPE STRING,
FLIGHT_CABIN4 TYPE STRING,
FLIGHT_CABIN_UNI TYPE STRING,
FLIGHT_RBD1 TYPE STRING,
FLIGHT_RBD2 TYPE STRING,
FLIGHT_RBD3 TYPE STRING,
FLIGHT_RBD4 TYPE STRING,
FLIGHT_RBD_UNI TYPE STRING,
FLIGHT_LOC_VIA1 TYPE STRING,
FLIGHT_LOC_VIA2 TYPE STRING,
FLIGHT_RETURNS TYPE STRING,
CAR_CORPORATE_ID TYPE STRING,
OP_AIRLINE TYPE STRING,
HOTEL_CORP_ID TYPE STRING,
PLATING_CARRIER TYPE STRING,
TST_ISSUE_TYPE TYPE STRING,
REBATE_FARE TYPE STRING,
TICKETNUMBER TYPE STRING,
TICKETTYPE TYPE STRING,
TST_FARE_TYPE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_BIW_FI_TV_02_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_BIW_FI_TV_02_STR-PERNR sy-vline 
WA_BIW_FI_TV_02_STR-REINR sy-vline 
WA_BIW_FI_TV_02_STR-ENTRY_TYPE sy-vline 
WA_BIW_FI_TV_02_STR-WAERS sy-vline 
WA_BIW_FI_TV_02_STR-MOLGA sy-vline 
WA_BIW_FI_TV_02_STR-MOREI sy-vline 
WA_BIW_FI_TV_02_STR-SCHEM sy-vline 
WA_BIW_FI_TV_02_STR-KZREA sy-vline 
WA_BIW_FI_TV_02_STR-BEREI sy-vline 
WA_BIW_FI_TV_02_STR-KZTKT sy-vline 
WA_BIW_FI_TV_02_STR-ZLAND sy-vline 
WA_BIW_FI_TV_02_STR-HRGIO sy-vline 
WA_BIW_FI_TV_02_STR-DATV1 sy-vline 
WA_BIW_FI_TV_02_STR-UHRV1 sy-vline 
WA_BIW_FI_TV_02_STR-DATB1 sy-vline 
WA_BIW_FI_TV_02_STR-UHRB1 sy-vline 
WA_BIW_FI_TV_02_STR-PLAN_STATUS sy-vline 
WA_BIW_FI_TV_02_STR-ACTIVITY_TYPE sy-vline 
WA_BIW_FI_TV_02_STR-REC_LOCATOR sy-vline 
WA_BIW_FI_TV_02_STR-USERG sy-vline 
WA_BIW_FI_TV_02_STR-CATEGORY sy-vline 
WA_BIW_FI_TV_02_STR-BELNR sy-vline 
WA_BIW_FI_TV_02_STR-REAL_CAT sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_CHAIN sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_PROPERTY sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_DATE_ARR sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_DATE_DEP sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_LOC sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_NAME sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_ROOMTYPE sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_MEALS sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_RATE sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_PRICE sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_STATUS sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_RATE_CODE sy-vline 
WA_BIW_FI_TV_02_STR-ROOM_RATE_CODE sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_AREA sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_NIGHTS sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_BOOKINGS sy-vline 
WA_BIW_FI_TV_02_STR-CAR_PROVIDER sy-vline 
WA_BIW_FI_TV_02_STR-CAR_DATE_BEG sy-vline 
WA_BIW_FI_TV_02_STR-CAR_LOC_BEG sy-vline 
WA_BIW_FI_TV_02_STR-CAR_DATE_END sy-vline 
WA_BIW_FI_TV_02_STR-CAR_LOC_END sy-vline 
WA_BIW_FI_TV_02_STR-CAR_CLASS sy-vline 
WA_BIW_FI_TV_02_STR-CAR_TYPE sy-vline 
WA_BIW_FI_TV_02_STR-CAR_PRICE sy-vline 
WA_BIW_FI_TV_02_STR-CAR_RATE_CODE sy-vline 
WA_BIW_FI_TV_02_STR-CAR_TOT_RATETYPE sy-vline 
WA_BIW_FI_TV_02_STR-CAR_TOTAL_RATE sy-vline 
WA_BIW_FI_TV_02_STR-CAR_STATUS sy-vline 
WA_BIW_FI_TV_02_STR-CAR_AREA sy-vline 
WA_BIW_FI_TV_02_STR-CAR_DAYS sy-vline 
WA_BIW_FI_TV_02_STR-CAR_BOOKINGS sy-vline 
WA_BIW_FI_TV_02_STR-CAR_PICKUP_LOC sy-vline 
WA_BIW_FI_TV_02_STR-AIRLINE sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_NR sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_DATE_DEP sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_TIME_DEP sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_LOC_DEP sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_LOC_ARR sy-vline 
WA_BIW_FI_TV_02_STR-RESTRICT_FARE sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_CABIN sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_RBD sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_STATUS sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_NUMBER sy-vline 
WA_BIW_FI_TV_02_STR-FARE_BASIS_CODE sy-vline 
WA_BIW_FI_TV_02_STR-LOCAL_TST sy-vline 
WA_BIW_FI_TV_02_STR-LAST_DATE sy-vline 
WA_BIW_FI_TV_02_STR-TICKET_MODE sy-vline 
WA_BIW_FI_TV_02_STR-SALES_IND sy-vline 
WA_BIW_FI_TV_02_STR-FARE sy-vline 
WA_BIW_FI_TV_02_STR-TOTAL_FARE sy-vline 
WA_BIW_FI_TV_02_STR-AIRLINE1 sy-vline 
WA_BIW_FI_TV_02_STR-AIRLINE2 sy-vline 
WA_BIW_FI_TV_02_STR-AIRLINE3 sy-vline 
WA_BIW_FI_TV_02_STR-AIRLINE4 sy-vline 
WA_BIW_FI_TV_02_STR-AIRLINE_UNIQUE sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_CABIN1 sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_CABIN2 sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_CABIN3 sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_CABIN4 sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_CABIN_UNI sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_RBD1 sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_RBD2 sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_RBD3 sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_RBD4 sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_RBD_UNI sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_LOC_VIA1 sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_LOC_VIA2 sy-vline 
WA_BIW_FI_TV_02_STR-FLIGHT_RETURNS sy-vline 
WA_BIW_FI_TV_02_STR-CAR_CORPORATE_ID sy-vline 
WA_BIW_FI_TV_02_STR-OP_AIRLINE sy-vline 
WA_BIW_FI_TV_02_STR-HOTEL_CORP_ID sy-vline 
WA_BIW_FI_TV_02_STR-PLATING_CARRIER sy-vline 
WA_BIW_FI_TV_02_STR-TST_ISSUE_TYPE sy-vline 
WA_BIW_FI_TV_02_STR-REBATE_FARE sy-vline 
WA_BIW_FI_TV_02_STR-TICKETNUMBER sy-vline 
WA_BIW_FI_TV_02_STR-TICKETTYPE sy-vline 
WA_BIW_FI_TV_02_STR-TST_FARE_TYPE sy-vline      INTO ld_text SEPARATED BY SPACE.

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