ABAP Select data from SAP table BAPI_ADFSH_FLGTDET 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 BAPI_ADFSH_FLGTDET 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 BAPI_ADFSH_FLGTDET. 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 BAPI_ADFSH_FLGTDET 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_BAPI_ADFSH_FLGTDET TYPE STANDARD TABLE OF BAPI_ADFSH_FLGTDET,
      WA_BAPI_ADFSH_FLGTDET TYPE BAPI_ADFSH_FLGTDET,
      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: <BAPI_ADFSH_FLGTDET> TYPE BAPI_ADFSH_FLGTDET.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM BAPI_ADFSH_FLGTDET
*  INTO TABLE @DATA(IT_BAPI_ADFSH_FLGTDET2).
*--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_BAPI_ADFSH_FLGTDET INDEX 1 INTO DATA(WA_BAPI_ADFSH_FLGTDET2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<BAPI_ADFSH_FLGTDET>-AIRLINE = 1.
<BAPI_ADFSH_FLGTDET>-FLIGHT_NUM = 1.
<BAPI_ADFSH_FLGTDET>-SECTOR_NUM = 1.
<BAPI_ADFSH_FLGTDET>-SEQUENCE_NUM = 1.
<BAPI_ADFSH_FLGTDET>-ACT_DATE = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_BAPI_ADFSH_FLGTDET-DELETE_IND, sy-vline,
  WA_BAPI_ADFSH_FLGTDET-FLIGHT_ROUT, sy-vline,
  WA_BAPI_ADFSH_FLGTDET-FLIGHT_TYP, sy-vline,
  WA_BAPI_ADFSH_FLGTDET-ACFT_TYPE, sy-vline,
  WA_BAPI_ADFSH_FLGTDET-STATUS_CODE, sy-vline,
  WA_BAPI_ADFSH_FLGTDET-ACFT_REG, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_BAPI_ADFSH_FLGTDET 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_BAPI_ADFSH_FLGTDET 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_BAPI_ADFSH_FLGTDET INTO WA_BAPI_ADFSH_FLGTDET.


*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 TPLNR, internal->external for field ACFT_REG
CALL FUNCTION 'CONVERSION_EXIT_TPLNR_OUTPUT'
  EXPORTING
    input =                      WA_BAPI_ADFSH_FLGTDET-ACFT_REG
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI_ADFSH_FLGTDET-ACFT_REG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TIMLO, internal->external for field PL_DEP_TIME
CALL FUNCTION 'CONVERSION_EXIT_TIMLO_OUTPUT'
  EXPORTING
    input =                      WA_BAPI_ADFSH_FLGTDET-PL_DEP_TIME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI_ADFSH_FLGTDET-PL_DEP_TIME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field DUR_UNIT
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_BAPI_ADFSH_FLGTDET-DUR_UNIT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI_ADFSH_FLGTDET-DUR_UNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field DIS_UNIT
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_BAPI_ADFSH_FLGTDET-DIS_UNIT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI_ADFSH_FLGTDET-DIS_UNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TIMLO, internal->external for field RV_DEP_TIME
CALL FUNCTION 'CONVERSION_EXIT_TIMLO_OUTPUT'
  EXPORTING
    input =                      WA_BAPI_ADFSH_FLGTDET-RV_DEP_TIME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI_ADFSH_FLGTDET-RV_DEP_TIME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TIMLO, internal->external for field ES_DEP_TIME
CALL FUNCTION 'CONVERSION_EXIT_TIMLO_OUTPUT'
  EXPORTING
    input =                      WA_BAPI_ADFSH_FLGTDET-ES_DEP_TIME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI_ADFSH_FLGTDET-ES_DEP_TIME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TIMLO, internal->external for field LT_DEP_TIME
CALL FUNCTION 'CONVERSION_EXIT_TIMLO_OUTPUT'
  EXPORTING
    input =                      WA_BAPI_ADFSH_FLGTDET-LT_DEP_TIME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI_ADFSH_FLGTDET-LT_DEP_TIME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TIMLO, internal->external for field AC_DEP_TIME
CALL FUNCTION 'CONVERSION_EXIT_TIMLO_OUTPUT'
  EXPORTING
    input =                      WA_BAPI_ADFSH_FLGTDET-AC_DEP_TIME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI_ADFSH_FLGTDET-AC_DEP_TIME.
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_BAPI_ADFSH_FLGTDET_STR, 
AIRLINE TYPE STRING,
FLIGHT_NUM TYPE STRING,
SECTOR_NUM TYPE STRING,
SEQUENCE_NUM TYPE STRING,
ACT_DATE TYPE STRING,
DELETE_IND TYPE STRING,
FLIGHT_ROUT TYPE STRING,
FLIGHT_TYP TYPE STRING,
ACFT_TYPE TYPE STRING,
STATUS_CODE TYPE STRING,
ACFT_REG TYPE STRING,
PL_DEP_APT TYPE STRING,
PL_ARR_APT TYPE STRING,
PL_DEP_TML TYPE STRING,
PL_ARR_TML TYPE STRING,
PL_DEP_BAY TYPE STRING,
PL_ARR_BAY TYPE STRING,
PL_DEP_TIME TYPE STRING,
PL_ARR_TIME TYPE STRING,
FLIGHT_DUR TYPE STRING,
DUR_UNIT TYPE STRING,
FLIGHT_DIS TYPE STRING,
DIS_UNIT TYPE STRING,
AC_DEP_APT TYPE STRING,
AC_DEP_TML TYPE STRING,
AC_DEP_BAY TYPE STRING,
AC_BELT TYPE STRING,
RV_DEP_TIME TYPE STRING,
ES_DEP_TIME TYPE STRING,
LT_DEP_TIME TYPE STRING,
AC_DEP_TIME TYPE STRING,
ARB_TIME TYPE STRING,
AC_ARR_APT TYPE STRING,
AC_ARR_TML TYPE STRING,
AC_ARR_BAY TYPE STRING,
OFPLARDT TYPE STRING,
REV_ARR_TIME TYPE STRING,
OFRVARDT TYPE STRING,
ES_ARR_TIME TYPE STRING,
OFESARDT TYPE STRING,
LT_ARR_TIME TYPE STRING,
OFLTARDT TYPE STRING,
AC_ARR_TIME TYPE STRING,
OFACARDT TYPE STRING,
LAND_TIME TYPE STRING,
MODE_OPER TYPE STRING,
INFLGT_SHP TYPE STRING,
ADO_VDO TYPE STRING,
SPL_MEAL TYPE STRING,
MAIN_MEAL TYPE STRING,
COLD_MEAL TYPE STRING,
BRKFST TYPE STRING,
SNACK TYPE STRING,
REFRSHMNT TYPE STRING,
ISD_PHONE TYPE STRING,
HZRD_GOODS TYPE STRING,
COLD_STRG TYPE STRING,
TOT_PAX TYPE STRING,
TOT_PAX_TST TYPE STRING,
TOT_MINOR TYPE STRING,
CARGO_WT TYPE STRING,
CARGO_UNIT TYPE STRING,
WHL_CHAIR TYPE STRING,
REVISION TYPE STRING,
PLDPDAT TYPE STRING,
ESDPDAT TYPE STRING,
RVDPDAT TYPE STRING,
LTDPDAT TYPE STRING,
ACDPDAT TYPE STRING,
ARBDAT TYPE STRING,
PLARDAT TYPE STRING,
ESARDAT TYPE STRING,
RVARDAT TYPE STRING,
LTARDAT TYPE STRING,
ACARDAT TYPE STRING,
LANDAT TYPE STRING,
FLGCON TYPE STRING,
ADBRKLDG TYPE STRING,
AUPLTLDG TYPE STRING,
NRMLDG TYPE STRING,
TOUCHNGO TYPE STRING,END OF T_EKKO_STR.
DATA: WA_BAPI_ADFSH_FLGTDET_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_BAPI_ADFSH_FLGTDET_STR-AIRLINE sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-FLIGHT_NUM sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-SECTOR_NUM sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-SEQUENCE_NUM sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ACT_DATE sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-DELETE_IND sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-FLIGHT_ROUT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-FLIGHT_TYP sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ACFT_TYPE sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-STATUS_CODE sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ACFT_REG sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-PL_DEP_APT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-PL_ARR_APT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-PL_DEP_TML sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-PL_ARR_TML sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-PL_DEP_BAY sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-PL_ARR_BAY sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-PL_DEP_TIME sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-PL_ARR_TIME sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-FLIGHT_DUR sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-DUR_UNIT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-FLIGHT_DIS sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-DIS_UNIT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-AC_DEP_APT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-AC_DEP_TML sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-AC_DEP_BAY sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-AC_BELT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-RV_DEP_TIME sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ES_DEP_TIME sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-LT_DEP_TIME sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-AC_DEP_TIME sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ARB_TIME sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-AC_ARR_APT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-AC_ARR_TML sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-AC_ARR_BAY sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-OFPLARDT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-REV_ARR_TIME sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-OFRVARDT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ES_ARR_TIME sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-OFESARDT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-LT_ARR_TIME sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-OFLTARDT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-AC_ARR_TIME sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-OFACARDT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-LAND_TIME sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-MODE_OPER sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-INFLGT_SHP sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ADO_VDO sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-SPL_MEAL sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-MAIN_MEAL sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-COLD_MEAL sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-BRKFST sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-SNACK sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-REFRSHMNT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ISD_PHONE sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-HZRD_GOODS sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-COLD_STRG sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-TOT_PAX sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-TOT_PAX_TST sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-TOT_MINOR sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-CARGO_WT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-CARGO_UNIT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-WHL_CHAIR sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-REVISION sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-PLDPDAT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ESDPDAT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-RVDPDAT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-LTDPDAT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ACDPDAT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ARBDAT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-PLARDAT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ESARDAT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-RVARDAT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-LTARDAT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ACARDAT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-LANDAT sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-FLGCON sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-ADBRKLDG sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-AUPLTLDG sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-NRMLDG sy-vline 
WA_BAPI_ADFSH_FLGTDET_STR-TOUCHNGO sy-vline      INTO ld_text SEPARATED BY SPACE.

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