ABAP Select data from SAP table FKK_VT_DYNP 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 FKK_VT_DYNP 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 FKK_VT_DYNP. 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 FKK_VT_DYNP 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_FKK_VT_DYNP TYPE STANDARD TABLE OF FKK_VT_DYNP,
      WA_FKK_VT_DYNP TYPE FKK_VT_DYNP,
      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: <FKK_VT_DYNP> TYPE FKK_VT_DYNP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FKK_VT_DYNP
*  INTO TABLE @DATA(IT_FKK_VT_DYNP2).
*--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_FKK_VT_DYNP INDEX 1 INTO DATA(WA_FKK_VT_DYNP2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FKK_VT_DYNP>-VALDT = 1.
<FKK_VT_DYNP>-VALTI = 1.
<FKK_VT_DYNP>-VALDT_SEL = 1.
<FKK_VT_DYNP>-VALTI_SEL = 1.
<FKK_VT_DYNP>-GPTXT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FKK_VT_DYNP-ADTXT, sy-vline,
  WA_FKK_VT_DYNP-VTPOS_DATFR, sy-vline,
  WA_FKK_VT_DYNP-VTPOS_TIMFR, sy-vline,
  WA_FKK_VT_DYNP-VTPOS_DATTO, sy-vline,
  WA_FKK_VT_DYNP-VTPOS_TIMTO, sy-vline,
  WA_FKK_VT_DYNP-BUTXT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FKK_VT_DYNP 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_FKK_VT_DYNP 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_FKK_VT_DYNP INTO WA_FKK_VT_DYNP.


*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 ABPSN, internal->external for field PS_POSID
CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT'
  EXPORTING
    input =                      WA_FKK_VT_DYNP-PS_POSID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FKK_VT_DYNP-PS_POSID.
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_FKK_VT_DYNP_STR, 
VALDT TYPE STRING,
VALTI TYPE STRING,
VALDT_SEL TYPE STRING,
VALTI_SEL TYPE STRING,
GPTXT TYPE STRING,
ADTXT TYPE STRING,
VTPOS_DATFR TYPE STRING,
VTPOS_TIMFR TYPE STRING,
VTPOS_DATTO TYPE STRING,
VTPOS_TIMTO TYPE STRING,
BUTXT TYPE STRING,
VKBEZ TYPE STRING,
VKORGT TYPE STRING,
SPARTT TYPE STRING,
VTWEGT TYPE STRING,
BUKRST TYPE STRING,
PRCTRT TYPE STRING,
GSBERT TYPE STRING,
STDSPT TYPE STRING,
SEGMTT TYPE STRING,
PRTXT TYPE STRING,
VTBEG_DATE TYPE STRING,
VTBEG_TIME TYPE STRING,
VTEND_DATE TYPE STRING,
VTEND_TIME TYPE STRING,
CYCLE_DAY_TXT TYPE STRING,
INV_LOCKREASON TYPE STRING,
INV_LOCKREASON_TXT TYPE STRING,
XTREE TYPE STRING,
XGRID TYPE STRING,
XCNCL TYPE STRING,
TTZZT TYPE STRING,
TR_DETAIL TYPE STRING,
VTTRI TYPE STRING,
VTTRT TYPE STRING,
SRVRPT TYPE STRING,
MABEZ TYPE STRING,
MAPRDT TYPE STRING,
XRNOW TYPE STRING,
XRVAL TYPE STRING,
XRNOW_TXT TYPE STRING,
XRVAL_TXT TYPE STRING,
VALID_TXT TYPE STRING,
TSTMP_TXT TYPE STRING,
VTDAT TYPE STRING,
VTTIM TYPE STRING,
VTPOS_POST TYPE STRING,
PTSRLT TYPE STRING,
VTCHRT TYPE STRING,
VTKRFT TYPE STRING,
INV_SCHEDULE_TXT TYPE STRING,
PS_POSID TYPE STRING,
PS_POSIDT TYPE STRING,
AUFNRT TYPE STRING,
CB_SOLDTO_TXT TYPE STRING,
CB_BILLTO_TXT TYPE STRING,
CB_BEMOT_TXT TYPE STRING,
CB_DZTERM_TXT TYPE STRING,
RATING_AREA TYPE STRING,
RA_TXT TYPE STRING,
PRTXT_SP TYPE STRING,
RAREL_TXT TYPE STRING,
RA_REFTYPE_TXT TYPE STRING,
TRPRC_CURR_TXT TYPE STRING,
TRPRC_FREQ_UNIT_TXT TYPE STRING,
SSPRC_CURR_TXT TYPE STRING,
SSPRC_FREQ_UNIT_TXT TYPE STRING,
VALID_TO_CTRTERM_DATE TYPE STRING,
VALID_TO_CTRTERM_TIME TYPE STRING,
CHRSN_TXT TYPE STRING,
REGIO_PSD TYPE STRING,
COUNC_PSD TYPE STRING,
REGIO_PSD_TXT TYPE STRING,
COUNC_PSD_TXT TYPE STRING,
CB_CCARD_TXT TYPE STRING,
ADRSR_TXT TYPE STRING,
ADRSR_FIX TYPE STRING,
STATUTXT TYPE STRING,
STATUSTXT TYPE STRING,
BEGRU_TXT TYPE STRING,
BILLPLANNO_C TYPE STRING,
ASUAC TYPE STRING,
TRPRC_CURR TYPE STRING,
TRPRC_CURR_TXT1 TYPE STRING,
SSPRC_CURR TYPE STRING,
SSPRC_CURR_TXT1 TYPE STRING,
MAHNV_TEXT TYPE STRING,
LANDL_TEXT TYPE STRING,
TAX_COUNTRY_TEXT TYPE STRING,
EBVTY_TXT TYPE STRING,
ABVTY_TXT TYPE STRING,
CCARD_TXT TYPE STRING,
CCARD_OUT_TXT TYPE STRING,
EZAWE_TXT TYPE STRING,
AZAWET_TXT TYPE STRING,
INC_PAY_LOCK TYPE STRING,
OUTG_PAY_LOCK TYPE STRING,
INCPAYLOCKREASON TYPE STRING,
OUTGPAYLOCKREASON TYPE STRING,
ABWRE_TXT TYPE STRING,
ABWRA_TXT TYPE STRING,
MNDID_TXT TYPE STRING,
ZAHLKOND_TXT TYPE STRING,
PAY_PAR_INACTIVE TYPE STRING,
DUNN_PAR_INACTIVE TYPE STRING,
DUNNING_LOCK TYPE STRING,
DUNNINGLOCKREASON TYPE STRING,
XDISCOEXEMPT_TXT TYPE STRING,
QUANTITY_UNIT_TXT TYPE STRING,
VALID_FROM_CTRTERM_DATE TYPE STRING,
VALID_FROM_CTRTERM_TIME TYPE STRING,
RECURR_SERVICE_TYPE_TXT TYPE STRING,
SENDER_TEXT TYPE STRING,
PRTXT_COPA TYPE STRING,
QUANTITY_C TYPE STRING,
REV_REC_KEY_TXT TYPE STRING,
SOLUTION_ORDER_ID_TXT TYPE STRING,
CHARGE_TYPE_TXT TYPE STRING,
BSTKD_TXT TYPE STRING,
BSTDK_DATE TYPE STRING,
RA_OI_ORIG_TXT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FKK_VT_DYNP_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_FKK_VT_DYNP_STR-VALDT sy-vline 
WA_FKK_VT_DYNP_STR-VALTI sy-vline 
WA_FKK_VT_DYNP_STR-VALDT_SEL sy-vline 
WA_FKK_VT_DYNP_STR-VALTI_SEL sy-vline 
WA_FKK_VT_DYNP_STR-GPTXT sy-vline 
WA_FKK_VT_DYNP_STR-ADTXT sy-vline 
WA_FKK_VT_DYNP_STR-VTPOS_DATFR sy-vline 
WA_FKK_VT_DYNP_STR-VTPOS_TIMFR sy-vline 
WA_FKK_VT_DYNP_STR-VTPOS_DATTO sy-vline 
WA_FKK_VT_DYNP_STR-VTPOS_TIMTO sy-vline 
WA_FKK_VT_DYNP_STR-BUTXT sy-vline 
WA_FKK_VT_DYNP_STR-VKBEZ sy-vline 
WA_FKK_VT_DYNP_STR-VKORGT sy-vline 
WA_FKK_VT_DYNP_STR-SPARTT sy-vline 
WA_FKK_VT_DYNP_STR-VTWEGT sy-vline 
WA_FKK_VT_DYNP_STR-BUKRST sy-vline 
WA_FKK_VT_DYNP_STR-PRCTRT sy-vline 
WA_FKK_VT_DYNP_STR-GSBERT sy-vline 
WA_FKK_VT_DYNP_STR-STDSPT sy-vline 
WA_FKK_VT_DYNP_STR-SEGMTT sy-vline 
WA_FKK_VT_DYNP_STR-PRTXT sy-vline 
WA_FKK_VT_DYNP_STR-VTBEG_DATE sy-vline 
WA_FKK_VT_DYNP_STR-VTBEG_TIME sy-vline 
WA_FKK_VT_DYNP_STR-VTEND_DATE sy-vline 
WA_FKK_VT_DYNP_STR-VTEND_TIME sy-vline 
WA_FKK_VT_DYNP_STR-CYCLE_DAY_TXT sy-vline 
WA_FKK_VT_DYNP_STR-INV_LOCKREASON sy-vline 
WA_FKK_VT_DYNP_STR-INV_LOCKREASON_TXT sy-vline 
WA_FKK_VT_DYNP_STR-XTREE sy-vline 
WA_FKK_VT_DYNP_STR-XGRID sy-vline 
WA_FKK_VT_DYNP_STR-XCNCL sy-vline 
WA_FKK_VT_DYNP_STR-TTZZT sy-vline 
WA_FKK_VT_DYNP_STR-TR_DETAIL sy-vline 
WA_FKK_VT_DYNP_STR-VTTRI sy-vline 
WA_FKK_VT_DYNP_STR-VTTRT sy-vline 
WA_FKK_VT_DYNP_STR-SRVRPT sy-vline 
WA_FKK_VT_DYNP_STR-MABEZ sy-vline 
WA_FKK_VT_DYNP_STR-MAPRDT sy-vline 
WA_FKK_VT_DYNP_STR-XRNOW sy-vline 
WA_FKK_VT_DYNP_STR-XRVAL sy-vline 
WA_FKK_VT_DYNP_STR-XRNOW_TXT sy-vline 
WA_FKK_VT_DYNP_STR-XRVAL_TXT sy-vline 
WA_FKK_VT_DYNP_STR-VALID_TXT sy-vline 
WA_FKK_VT_DYNP_STR-TSTMP_TXT sy-vline 
WA_FKK_VT_DYNP_STR-VTDAT sy-vline 
WA_FKK_VT_DYNP_STR-VTTIM sy-vline 
WA_FKK_VT_DYNP_STR-VTPOS_POST sy-vline 
WA_FKK_VT_DYNP_STR-PTSRLT sy-vline 
WA_FKK_VT_DYNP_STR-VTCHRT sy-vline 
WA_FKK_VT_DYNP_STR-VTKRFT sy-vline 
WA_FKK_VT_DYNP_STR-INV_SCHEDULE_TXT sy-vline 
WA_FKK_VT_DYNP_STR-PS_POSID sy-vline 
WA_FKK_VT_DYNP_STR-PS_POSIDT sy-vline 
WA_FKK_VT_DYNP_STR-AUFNRT sy-vline 
WA_FKK_VT_DYNP_STR-CB_SOLDTO_TXT sy-vline 
WA_FKK_VT_DYNP_STR-CB_BILLTO_TXT sy-vline 
WA_FKK_VT_DYNP_STR-CB_BEMOT_TXT sy-vline 
WA_FKK_VT_DYNP_STR-CB_DZTERM_TXT sy-vline 
WA_FKK_VT_DYNP_STR-RATING_AREA sy-vline 
WA_FKK_VT_DYNP_STR-RA_TXT sy-vline 
WA_FKK_VT_DYNP_STR-PRTXT_SP sy-vline 
WA_FKK_VT_DYNP_STR-RAREL_TXT sy-vline 
WA_FKK_VT_DYNP_STR-RA_REFTYPE_TXT sy-vline 
WA_FKK_VT_DYNP_STR-TRPRC_CURR_TXT sy-vline 
WA_FKK_VT_DYNP_STR-TRPRC_FREQ_UNIT_TXT sy-vline 
WA_FKK_VT_DYNP_STR-SSPRC_CURR_TXT sy-vline 
WA_FKK_VT_DYNP_STR-SSPRC_FREQ_UNIT_TXT sy-vline 
WA_FKK_VT_DYNP_STR-VALID_TO_CTRTERM_DATE sy-vline 
WA_FKK_VT_DYNP_STR-VALID_TO_CTRTERM_TIME sy-vline 
WA_FKK_VT_DYNP_STR-CHRSN_TXT sy-vline 
WA_FKK_VT_DYNP_STR-REGIO_PSD sy-vline 
WA_FKK_VT_DYNP_STR-COUNC_PSD sy-vline 
WA_FKK_VT_DYNP_STR-REGIO_PSD_TXT sy-vline 
WA_FKK_VT_DYNP_STR-COUNC_PSD_TXT sy-vline 
WA_FKK_VT_DYNP_STR-CB_CCARD_TXT sy-vline 
WA_FKK_VT_DYNP_STR-ADRSR_TXT sy-vline 
WA_FKK_VT_DYNP_STR-ADRSR_FIX sy-vline 
WA_FKK_VT_DYNP_STR-STATUTXT sy-vline 
WA_FKK_VT_DYNP_STR-STATUSTXT sy-vline 
WA_FKK_VT_DYNP_STR-BEGRU_TXT sy-vline 
WA_FKK_VT_DYNP_STR-BILLPLANNO_C sy-vline 
WA_FKK_VT_DYNP_STR-ASUAC sy-vline 
WA_FKK_VT_DYNP_STR-TRPRC_CURR sy-vline 
WA_FKK_VT_DYNP_STR-TRPRC_CURR_TXT1 sy-vline 
WA_FKK_VT_DYNP_STR-SSPRC_CURR sy-vline 
WA_FKK_VT_DYNP_STR-SSPRC_CURR_TXT1 sy-vline 
WA_FKK_VT_DYNP_STR-MAHNV_TEXT sy-vline 
WA_FKK_VT_DYNP_STR-LANDL_TEXT sy-vline 
WA_FKK_VT_DYNP_STR-TAX_COUNTRY_TEXT sy-vline 
WA_FKK_VT_DYNP_STR-EBVTY_TXT sy-vline 
WA_FKK_VT_DYNP_STR-ABVTY_TXT sy-vline 
WA_FKK_VT_DYNP_STR-CCARD_TXT sy-vline 
WA_FKK_VT_DYNP_STR-CCARD_OUT_TXT sy-vline 
WA_FKK_VT_DYNP_STR-EZAWE_TXT sy-vline 
WA_FKK_VT_DYNP_STR-AZAWET_TXT sy-vline 
WA_FKK_VT_DYNP_STR-INC_PAY_LOCK sy-vline 
WA_FKK_VT_DYNP_STR-OUTG_PAY_LOCK sy-vline 
WA_FKK_VT_DYNP_STR-INCPAYLOCKREASON sy-vline 
WA_FKK_VT_DYNP_STR-OUTGPAYLOCKREASON sy-vline 
WA_FKK_VT_DYNP_STR-ABWRE_TXT sy-vline 
WA_FKK_VT_DYNP_STR-ABWRA_TXT sy-vline 
WA_FKK_VT_DYNP_STR-MNDID_TXT sy-vline 
WA_FKK_VT_DYNP_STR-ZAHLKOND_TXT sy-vline 
WA_FKK_VT_DYNP_STR-PAY_PAR_INACTIVE sy-vline 
WA_FKK_VT_DYNP_STR-DUNN_PAR_INACTIVE sy-vline 
WA_FKK_VT_DYNP_STR-DUNNING_LOCK sy-vline 
WA_FKK_VT_DYNP_STR-DUNNINGLOCKREASON sy-vline 
WA_FKK_VT_DYNP_STR-XDISCOEXEMPT_TXT sy-vline 
WA_FKK_VT_DYNP_STR-QUANTITY_UNIT_TXT sy-vline 
WA_FKK_VT_DYNP_STR-VALID_FROM_CTRTERM_DATE sy-vline 
WA_FKK_VT_DYNP_STR-VALID_FROM_CTRTERM_TIME sy-vline 
WA_FKK_VT_DYNP_STR-RECURR_SERVICE_TYPE_TXT sy-vline 
WA_FKK_VT_DYNP_STR-SENDER_TEXT sy-vline 
WA_FKK_VT_DYNP_STR-PRTXT_COPA sy-vline 
WA_FKK_VT_DYNP_STR-QUANTITY_C sy-vline 
WA_FKK_VT_DYNP_STR-REV_REC_KEY_TXT sy-vline 
WA_FKK_VT_DYNP_STR-SOLUTION_ORDER_ID_TXT sy-vline 
WA_FKK_VT_DYNP_STR-CHARGE_TYPE_TXT sy-vline 
WA_FKK_VT_DYNP_STR-BSTKD_TXT sy-vline 
WA_FKK_VT_DYNP_STR-BSTDK_DATE sy-vline 
WA_FKK_VT_DYNP_STR-RA_OI_ORIG_TXT sy-vline      INTO ld_text SEPARATED BY SPACE.

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