ABAP Select data from SAP table FPLTVB 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 FPLTVB 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 FPLTVB. 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 FPLTVB 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_FPLTVB TYPE STANDARD TABLE OF FPLTVB,
      WA_FPLTVB TYPE FPLTVB,
      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: <FPLTVB> TYPE FPLTVB.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FPLTVB
*  INTO TABLE @DATA(IT_FPLTVB2).
*--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_FPLTVB INDEX 1 INTO DATA(WA_FPLTVB2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FPLTVB>-MANDT = 1.
<FPLTVB>-FPLNR = 1.
<FPLTVB>-FPLTR = 1.
<FPLTVB>-FPTTP = 1.
<FPLTVB>-TETXT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FPLTVB-FKDAT, sy-vline,
  WA_FPLTVB-FPFIX, sy-vline,
  WA_FPLTVB-FAREG, sy-vline,
  WA_FPLTVB-FPROZ, sy-vline,
  WA_FPLTVB-WAERS, sy-vline,
  WA_FPLTVB-KURFP, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FPLTVB 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_FPLTVB 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_FPLTVB INTO WA_FPLTVB.


*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 EXCRT, internal->external for field KURFP
CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT'
  EXPORTING
    input =                      WA_FPLTVB-KURFP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FPLTVB-KURFP.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit EXCRT, internal->external for field KURRF
CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT'
  EXPORTING
    input =                      WA_FPLTVB-KURRF
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FPLTVB-KURRF.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit AU132, internal->external for field PAYMENT_AMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT'
  EXPORTING
    input =                      WA_FPLTVB-PAYMENT_AMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FPLTVB-PAYMENT_AMOUNT.
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_FPLTVB_STR, 
MANDT TYPE STRING,
FPLNR TYPE STRING,
FPLTR TYPE STRING,
FPTTP TYPE STRING,
TETXT TYPE STRING,
FKDAT TYPE STRING,
FPFIX TYPE STRING,
FAREG TYPE STRING,
FPROZ TYPE STRING,
WAERS TYPE STRING,
KURFP TYPE STRING,
FAKWR TYPE STRING,
FAKSP TYPE STRING,
FKARV TYPE STRING,
FKSAF TYPE STRING,
PERIO TYPE STRING,
FPLAE TYPE STRING,
MLSTN TYPE STRING,
MLBEZ TYPE STRING,
ZTERM TYPE STRING,
KUNRG TYPE STRING,
TAXK1 TYPE STRING,
TAXK2 TYPE STRING,
TAXK3 TYPE STRING,
TAXK4 TYPE STRING,
TAXK5 TYPE STRING,
TAXK6 TYPE STRING,
TAXK7 TYPE STRING,
TAXK8 TYPE STRING,
TAXK9 TYPE STRING,
VALTG TYPE STRING,
VALDT TYPE STRING,
NFDAT TYPE STRING,
TEMAN TYPE STRING,
FAKCA TYPE STRING,
AFDAT TYPE STRING,
NETWR TYPE STRING,
NETPR TYPE STRING,
WAVWR TYPE STRING,
KZWI1 TYPE STRING,
KZWI2 TYPE STRING,
KZWI3 TYPE STRING,
KZWI4 TYPE STRING,
KZWI5 TYPE STRING,
KZWI6 TYPE STRING,
CMPRE TYPE STRING,
SKFBP TYPE STRING,
BONBA TYPE STRING,
PRSOK TYPE STRING,
TYPZM TYPE STRING,
CMPRE_FLT TYPE STRING,
UELNR TYPE STRING,
UELTR TYPE STRING,
KURRF TYPE STRING,
CCACT TYPE STRING,
KORTE TYPE STRING,
OFKDAT TYPE STRING,
DESCR TYPE STRING,
POSTPR TYPE STRING,
REFDOC TYPE STRING,
SET_BY_FINAL TYPE STRING,
ITEM_USAGE TYPE STRING,
DB_KEY TYPE STRING,
PARENT_KEY TYPE STRING,
_DATAAGING TYPE STRING,
AD04FAREG TYPE STRING,
PEROP_BEG TYPE STRING,
PEROP_END TYPE STRING,
UPDKZ TYPE STRING,
SELKZ TYPE STRING,
KZMEI TYPE STRING,
TEBEZ TYPE STRING,
NETWRG TYPE STRING,
FKSAFK TYPE STRING,
CCINS TYPE STRING,
CCNUM TYPE STRING,
CCFOL TYPE STRING,
DATAB TYPE STRING,
DATBI TYPE STRING,
CCNAME TYPE STRING,
CSOUR TYPE STRING,
AUTWR TYPE STRING,
CCWAE TYPE STRING,
SETTL TYPE STRING,
AUNUM TYPE STRING,
AUTRA TYPE STRING,
AUDAT TYPE STRING,
AUTIM TYPE STRING,
MERCH TYPE STRING,
LOCID TYPE STRING,
TRMID TYPE STRING,
CCBTC TYPE STRING,
CCTYP TYPE STRING,
CCARD_GUID TYPE STRING,
PAYMENT_AMOUNT TYPE STRING,
DP_TOKEN TYPE STRING,
DP_PSP TYPE STRING,
DP_PAYID TYPE STRING,
DP_PSP_TRANSID TYPE STRING,
DP_TRANS_ID TYPE STRING,
DP_MERCHANT_ALIAS TYPE STRING,
DP_AUTH_REL_ID TYPE STRING,
DP_FRAUD_RISK TYPE STRING,
CCAUA TYPE STRING,
CCALL TYPE STRING,
REACT TYPE STRING,
AUTWV TYPE STRING,
CCOLD TYPE STRING,
CCVAL TYPE STRING,
CCPRE TYPE STRING,
UELTR_A TYPE STRING,
COPIED_FOR_CREDIT TYPE STRING,
RCAVR TYPE STRING,
RCAVA TYPE STRING,
RCAVZ TYPE STRING,
RCRSP TYPE STRING,
RTEXT TYPE STRING,
VCARD TYPE STRING,
RFCAUT TYPE STRING,
FNAUT_SETINIT TYPE STRING,
FNAUT_SETINFO TYPE STRING,
CVVAL TYPE STRING,
CVVCT TYPE STRING,
CVVST TYPE STRING,
RCCVV TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FPLTVB_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_FPLTVB_STR-MANDT sy-vline 
WA_FPLTVB_STR-FPLNR sy-vline 
WA_FPLTVB_STR-FPLTR sy-vline 
WA_FPLTVB_STR-FPTTP sy-vline 
WA_FPLTVB_STR-TETXT sy-vline 
WA_FPLTVB_STR-FKDAT sy-vline 
WA_FPLTVB_STR-FPFIX sy-vline 
WA_FPLTVB_STR-FAREG sy-vline 
WA_FPLTVB_STR-FPROZ sy-vline 
WA_FPLTVB_STR-WAERS sy-vline 
WA_FPLTVB_STR-KURFP sy-vline 
WA_FPLTVB_STR-FAKWR sy-vline 
WA_FPLTVB_STR-FAKSP sy-vline 
WA_FPLTVB_STR-FKARV sy-vline 
WA_FPLTVB_STR-FKSAF sy-vline 
WA_FPLTVB_STR-PERIO sy-vline 
WA_FPLTVB_STR-FPLAE sy-vline 
WA_FPLTVB_STR-MLSTN sy-vline 
WA_FPLTVB_STR-MLBEZ sy-vline 
WA_FPLTVB_STR-ZTERM sy-vline 
WA_FPLTVB_STR-KUNRG sy-vline 
WA_FPLTVB_STR-TAXK1 sy-vline 
WA_FPLTVB_STR-TAXK2 sy-vline 
WA_FPLTVB_STR-TAXK3 sy-vline 
WA_FPLTVB_STR-TAXK4 sy-vline 
WA_FPLTVB_STR-TAXK5 sy-vline 
WA_FPLTVB_STR-TAXK6 sy-vline 
WA_FPLTVB_STR-TAXK7 sy-vline 
WA_FPLTVB_STR-TAXK8 sy-vline 
WA_FPLTVB_STR-TAXK9 sy-vline 
WA_FPLTVB_STR-VALTG sy-vline 
WA_FPLTVB_STR-VALDT sy-vline 
WA_FPLTVB_STR-NFDAT sy-vline 
WA_FPLTVB_STR-TEMAN sy-vline 
WA_FPLTVB_STR-FAKCA sy-vline 
WA_FPLTVB_STR-AFDAT sy-vline 
WA_FPLTVB_STR-NETWR sy-vline 
WA_FPLTVB_STR-NETPR sy-vline 
WA_FPLTVB_STR-WAVWR sy-vline 
WA_FPLTVB_STR-KZWI1 sy-vline 
WA_FPLTVB_STR-KZWI2 sy-vline 
WA_FPLTVB_STR-KZWI3 sy-vline 
WA_FPLTVB_STR-KZWI4 sy-vline 
WA_FPLTVB_STR-KZWI5 sy-vline 
WA_FPLTVB_STR-KZWI6 sy-vline 
WA_FPLTVB_STR-CMPRE sy-vline 
WA_FPLTVB_STR-SKFBP sy-vline 
WA_FPLTVB_STR-BONBA sy-vline 
WA_FPLTVB_STR-PRSOK sy-vline 
WA_FPLTVB_STR-TYPZM sy-vline 
WA_FPLTVB_STR-CMPRE_FLT sy-vline 
WA_FPLTVB_STR-UELNR sy-vline 
WA_FPLTVB_STR-UELTR sy-vline 
WA_FPLTVB_STR-KURRF sy-vline 
WA_FPLTVB_STR-CCACT sy-vline 
WA_FPLTVB_STR-KORTE sy-vline 
WA_FPLTVB_STR-OFKDAT sy-vline 
WA_FPLTVB_STR-DESCR sy-vline 
WA_FPLTVB_STR-POSTPR sy-vline 
WA_FPLTVB_STR-REFDOC sy-vline 
WA_FPLTVB_STR-SET_BY_FINAL sy-vline 
WA_FPLTVB_STR-ITEM_USAGE sy-vline 
WA_FPLTVB_STR-DB_KEY sy-vline 
WA_FPLTVB_STR-PARENT_KEY sy-vline 
WA_FPLTVB_STR-_DATAAGING sy-vline 
WA_FPLTVB_STR-AD04FAREG sy-vline 
WA_FPLTVB_STR-PEROP_BEG sy-vline 
WA_FPLTVB_STR-PEROP_END sy-vline 
WA_FPLTVB_STR-UPDKZ sy-vline 
WA_FPLTVB_STR-SELKZ sy-vline 
WA_FPLTVB_STR-KZMEI sy-vline 
WA_FPLTVB_STR-TEBEZ sy-vline 
WA_FPLTVB_STR-NETWRG sy-vline 
WA_FPLTVB_STR-FKSAFK sy-vline 
WA_FPLTVB_STR-CCINS sy-vline 
WA_FPLTVB_STR-CCNUM sy-vline 
WA_FPLTVB_STR-CCFOL sy-vline 
WA_FPLTVB_STR-DATAB sy-vline 
WA_FPLTVB_STR-DATBI sy-vline 
WA_FPLTVB_STR-CCNAME sy-vline 
WA_FPLTVB_STR-CSOUR sy-vline 
WA_FPLTVB_STR-AUTWR sy-vline 
WA_FPLTVB_STR-CCWAE sy-vline 
WA_FPLTVB_STR-SETTL sy-vline 
WA_FPLTVB_STR-AUNUM sy-vline 
WA_FPLTVB_STR-AUTRA sy-vline 
WA_FPLTVB_STR-AUDAT sy-vline 
WA_FPLTVB_STR-AUTIM sy-vline 
WA_FPLTVB_STR-MERCH sy-vline 
WA_FPLTVB_STR-LOCID sy-vline 
WA_FPLTVB_STR-TRMID sy-vline 
WA_FPLTVB_STR-CCBTC sy-vline 
WA_FPLTVB_STR-CCTYP sy-vline 
WA_FPLTVB_STR-CCARD_GUID sy-vline 
WA_FPLTVB_STR-PAYMENT_AMOUNT sy-vline 
WA_FPLTVB_STR-DP_TOKEN sy-vline 
WA_FPLTVB_STR-DP_PSP sy-vline 
WA_FPLTVB_STR-DP_PAYID sy-vline 
WA_FPLTVB_STR-DP_PSP_TRANSID sy-vline 
WA_FPLTVB_STR-DP_TRANS_ID sy-vline 
WA_FPLTVB_STR-DP_MERCHANT_ALIAS sy-vline 
WA_FPLTVB_STR-DP_AUTH_REL_ID sy-vline 
WA_FPLTVB_STR-DP_FRAUD_RISK sy-vline 
WA_FPLTVB_STR-CCAUA sy-vline 
WA_FPLTVB_STR-CCALL sy-vline 
WA_FPLTVB_STR-REACT sy-vline 
WA_FPLTVB_STR-AUTWV sy-vline 
WA_FPLTVB_STR-CCOLD sy-vline 
WA_FPLTVB_STR-CCVAL sy-vline 
WA_FPLTVB_STR-CCPRE sy-vline 
WA_FPLTVB_STR-UELTR_A sy-vline 
WA_FPLTVB_STR-COPIED_FOR_CREDIT sy-vline 
WA_FPLTVB_STR-RCAVR sy-vline 
WA_FPLTVB_STR-RCAVA sy-vline 
WA_FPLTVB_STR-RCAVZ sy-vline 
WA_FPLTVB_STR-RCRSP sy-vline 
WA_FPLTVB_STR-RTEXT sy-vline 
WA_FPLTVB_STR-VCARD sy-vline 
WA_FPLTVB_STR-RFCAUT sy-vline 
WA_FPLTVB_STR-FNAUT_SETINIT sy-vline 
WA_FPLTVB_STR-FNAUT_SETINFO sy-vline 
WA_FPLTVB_STR-CVVAL sy-vline 
WA_FPLTVB_STR-CVVCT sy-vline 
WA_FPLTVB_STR-CVVST sy-vline 
WA_FPLTVB_STR-RCCVV sy-vline      INTO ld_text SEPARATED BY SPACE.

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