ABAP Select data from SAP table PYMT_DATA 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 PYMT_DATA 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 PYMT_DATA. 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 PYMT_DATA 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_PYMT_DATA TYPE STANDARD TABLE OF PYMT_DATA,
      WA_PYMT_DATA TYPE PYMT_DATA,
      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: <PYMT_DATA> TYPE PYMT_DATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PYMT_DATA
*  INTO TABLE @DATA(IT_PYMT_DATA2).
*--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_PYMT_DATA INDEX 1 INTO DATA(WA_PYMT_DATA2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PYMT_DATA>-MANDT = 1.
<PYMT_DATA>-LAUFD = 1.
<PYMT_DATA>-LAUFI = 1.
<PYMT_DATA>-ORIGN = 1.
<PYMT_DATA>-PYDOC = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PYMT_DATA-BUKRS, sy-vline,
  WA_PYMT_DATA-PACUR, sy-vline,
  WA_PYMT_DATA-PAMTL, sy-vline,
  WA_PYMT_DATA-PAMTF, sy-vline,
  WA_PYMT_DATA-GPTYP, sy-vline,
  WA_PYMT_DATA-PARNO, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PYMT_DATA 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_PYMT_DATA 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_PYMT_DATA INTO WA_PYMT_DATA.


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

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

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

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

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

*Conversion exit ISOLA, internal->external for field SPRAS
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_PYMT_DATA-SPRAS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PYMT_DATA-SPRAS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ISOLA, internal->external for field ZSPRA
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_PYMT_DATA-ZSPRA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PYMT_DATA-ZSPRA.
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_PYMT_DATA_STR, 
MANDT TYPE STRING,
LAUFD TYPE STRING,
LAUFI TYPE STRING,
ORIGN TYPE STRING,
PYDOC TYPE STRING,
BUKRS TYPE STRING,
PACUR TYPE STRING,
PAMTL TYPE STRING,
PAMTF TYPE STRING,
GPTYP TYPE STRING,
PARNO TYPE STRING,
KTTYP TYPE STRING,
KONTO TYPE STRING,
PAYEE TYPE STRING,
FILKD TYPE STRING,
DTAMS TYPE STRING,
DTAWS TYPE STRING,
LZBKZ TYPE STRING,
DUEDT TYPE STRING,
VALUT TYPE STRING,
CRVAL TYPE STRING,
XPORE TYPE STRING,
UZAWE TYPE STRING,
ZWELS TYPE STRING,
SWTXT TYPE STRING,
PAYGR TYPE STRING,
PYGRP TYPE STRING,
ZLSPR TYPE STRING,
HKONT TYPE STRING,
UBHKT TYPE STRING,
GSBER TYPE STRING,
ZALDT TYPE STRING,
REFN1 TYPE STRING,
REFN2 TYPE STRING,
TXTSL TYPE STRING,
TXERG TYPE STRING,
HWAER TYPE STRING,
RSKON TYPE STRING,
RWSKT TYPE STRING,
BUSAB TYPE STRING,
EIKTO TYPE STRING,
GPART_TYP TYPE STRING,
ANRED TYPE STRING,
NAME1 TYPE STRING,
NAME2 TYPE STRING,
NAME3 TYPE STRING,
NAME4 TYPE STRING,
LAND1 TYPE STRING,
REGIO TYPE STRING,
PSTLZ TYPE STRING,
ORT01 TYPE STRING,
ORT02 TYPE STRING,
STRAS TYPE STRING,
HSNM1 TYPE STRING,
HSNM2 TYPE STRING,
LAND2 TYPE STRING,
ORTPF TYPE STRING,
PSTL2 TYPE STRING,
PFACH TYPE STRING,
PSTL3 TYPE STRING,
STCD1 TYPE STRING,
SPRAS TYPE STRING,
TLFX1 TYPE STRING,
TLFX2 TYPE STRING,
TELF1 TYPE STRING,
TELF2 TYPE STRING,
TELX1 TYPE STRING,
ZGPART_TYP TYPE STRING,
ZANRE TYPE STRING,
ZNME1 TYPE STRING,
ZNME2 TYPE STRING,
ZNME3 TYPE STRING,
ZNME4 TYPE STRING,
ZLAND TYPE STRING,
ZREGI TYPE STRING,
ZPSTL TYPE STRING,
ZORT1 TYPE STRING,
ZORT2 TYPE STRING,
ZSTRA TYPE STRING,
ZHSNM1 TYPE STRING,
ZHSNM2 TYPE STRING,
ZLAND2 TYPE STRING,
ZORTPF TYPE STRING,
ZPSTL2 TYPE STRING,
ZPFAC TYPE STRING,
ZPSTL3 TYPE STRING,
ZSTCD1 TYPE STRING,
ZSPRA TYPE STRING,
ZTLFX1 TYPE STRING,
ZTLFX2 TYPE STRING,
ZTELF1 TYPE STRING,
ZTELF2 TYPE STRING,
ZTELX1 TYPE STRING,
HKTID TYPE STRING,
HBKID TYPE STRING,
UBNKS TYPE STRING,
UBNKY TYPE STRING,
UBKNT TYPE STRING,
UBKON TYPE STRING,
UBNKL TYPE STRING,
ZBNKS TYPE STRING,
ZBNKY TYPE STRING,
ZBNKN TYPE STRING,
ZBKON TYPE STRING,
ZBNKL TYPE STRING,
ZBKRF TYPE STRING,
ZBKIN TYPE STRING,
ZSWIF TYPE STRING,
BTYP1 TYPE STRING,
BNKS1 TYPE STRING,
BNKL1 TYPE STRING,
BNKN1 TYPE STRING,
BKON1 TYPE STRING,
BKLZ1 TYPE STRING,
BKRF1 TYPE STRING,
SWIF1 TYPE STRING,
BTYP2 TYPE STRING,
BNKS2 TYPE STRING,
BNKL2 TYPE STRING,
BNKN2 TYPE STRING,
BKON2 TYPE STRING,
BKLZ2 TYPE STRING,
BKRF2 TYPE STRING,
SWIF2 TYPE STRING,
BTYP3 TYPE STRING,
BNKS3 TYPE STRING,
BNKL3 TYPE STRING,
BNKN3 TYPE STRING,
BKON3 TYPE STRING,
BKLZ3 TYPE STRING,
BKRF3 TYPE STRING,
SWIF3 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PYMT_DATA_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_PYMT_DATA_STR-MANDT sy-vline 
WA_PYMT_DATA_STR-LAUFD sy-vline 
WA_PYMT_DATA_STR-LAUFI sy-vline 
WA_PYMT_DATA_STR-ORIGN sy-vline 
WA_PYMT_DATA_STR-PYDOC sy-vline 
WA_PYMT_DATA_STR-BUKRS sy-vline 
WA_PYMT_DATA_STR-PACUR sy-vline 
WA_PYMT_DATA_STR-PAMTL sy-vline 
WA_PYMT_DATA_STR-PAMTF sy-vline 
WA_PYMT_DATA_STR-GPTYP sy-vline 
WA_PYMT_DATA_STR-PARNO sy-vline 
WA_PYMT_DATA_STR-KTTYP sy-vline 
WA_PYMT_DATA_STR-KONTO sy-vline 
WA_PYMT_DATA_STR-PAYEE sy-vline 
WA_PYMT_DATA_STR-FILKD sy-vline 
WA_PYMT_DATA_STR-DTAMS sy-vline 
WA_PYMT_DATA_STR-DTAWS sy-vline 
WA_PYMT_DATA_STR-LZBKZ sy-vline 
WA_PYMT_DATA_STR-DUEDT sy-vline 
WA_PYMT_DATA_STR-VALUT sy-vline 
WA_PYMT_DATA_STR-CRVAL sy-vline 
WA_PYMT_DATA_STR-XPORE sy-vline 
WA_PYMT_DATA_STR-UZAWE sy-vline 
WA_PYMT_DATA_STR-ZWELS sy-vline 
WA_PYMT_DATA_STR-SWTXT sy-vline 
WA_PYMT_DATA_STR-PAYGR sy-vline 
WA_PYMT_DATA_STR-PYGRP sy-vline 
WA_PYMT_DATA_STR-ZLSPR sy-vline 
WA_PYMT_DATA_STR-HKONT sy-vline 
WA_PYMT_DATA_STR-UBHKT sy-vline 
WA_PYMT_DATA_STR-GSBER sy-vline 
WA_PYMT_DATA_STR-ZALDT sy-vline 
WA_PYMT_DATA_STR-REFN1 sy-vline 
WA_PYMT_DATA_STR-REFN2 sy-vline 
WA_PYMT_DATA_STR-TXTSL sy-vline 
WA_PYMT_DATA_STR-TXERG sy-vline 
WA_PYMT_DATA_STR-HWAER sy-vline 
WA_PYMT_DATA_STR-RSKON sy-vline 
WA_PYMT_DATA_STR-RWSKT sy-vline 
WA_PYMT_DATA_STR-BUSAB sy-vline 
WA_PYMT_DATA_STR-EIKTO sy-vline 
WA_PYMT_DATA_STR-GPART_TYP sy-vline 
WA_PYMT_DATA_STR-ANRED sy-vline 
WA_PYMT_DATA_STR-NAME1 sy-vline 
WA_PYMT_DATA_STR-NAME2 sy-vline 
WA_PYMT_DATA_STR-NAME3 sy-vline 
WA_PYMT_DATA_STR-NAME4 sy-vline 
WA_PYMT_DATA_STR-LAND1 sy-vline 
WA_PYMT_DATA_STR-REGIO sy-vline 
WA_PYMT_DATA_STR-PSTLZ sy-vline 
WA_PYMT_DATA_STR-ORT01 sy-vline 
WA_PYMT_DATA_STR-ORT02 sy-vline 
WA_PYMT_DATA_STR-STRAS sy-vline 
WA_PYMT_DATA_STR-HSNM1 sy-vline 
WA_PYMT_DATA_STR-HSNM2 sy-vline 
WA_PYMT_DATA_STR-LAND2 sy-vline 
WA_PYMT_DATA_STR-ORTPF sy-vline 
WA_PYMT_DATA_STR-PSTL2 sy-vline 
WA_PYMT_DATA_STR-PFACH sy-vline 
WA_PYMT_DATA_STR-PSTL3 sy-vline 
WA_PYMT_DATA_STR-STCD1 sy-vline 
WA_PYMT_DATA_STR-SPRAS sy-vline 
WA_PYMT_DATA_STR-TLFX1 sy-vline 
WA_PYMT_DATA_STR-TLFX2 sy-vline 
WA_PYMT_DATA_STR-TELF1 sy-vline 
WA_PYMT_DATA_STR-TELF2 sy-vline 
WA_PYMT_DATA_STR-TELX1 sy-vline 
WA_PYMT_DATA_STR-ZGPART_TYP sy-vline 
WA_PYMT_DATA_STR-ZANRE sy-vline 
WA_PYMT_DATA_STR-ZNME1 sy-vline 
WA_PYMT_DATA_STR-ZNME2 sy-vline 
WA_PYMT_DATA_STR-ZNME3 sy-vline 
WA_PYMT_DATA_STR-ZNME4 sy-vline 
WA_PYMT_DATA_STR-ZLAND sy-vline 
WA_PYMT_DATA_STR-ZREGI sy-vline 
WA_PYMT_DATA_STR-ZPSTL sy-vline 
WA_PYMT_DATA_STR-ZORT1 sy-vline 
WA_PYMT_DATA_STR-ZORT2 sy-vline 
WA_PYMT_DATA_STR-ZSTRA sy-vline 
WA_PYMT_DATA_STR-ZHSNM1 sy-vline 
WA_PYMT_DATA_STR-ZHSNM2 sy-vline 
WA_PYMT_DATA_STR-ZLAND2 sy-vline 
WA_PYMT_DATA_STR-ZORTPF sy-vline 
WA_PYMT_DATA_STR-ZPSTL2 sy-vline 
WA_PYMT_DATA_STR-ZPFAC sy-vline 
WA_PYMT_DATA_STR-ZPSTL3 sy-vline 
WA_PYMT_DATA_STR-ZSTCD1 sy-vline 
WA_PYMT_DATA_STR-ZSPRA sy-vline 
WA_PYMT_DATA_STR-ZTLFX1 sy-vline 
WA_PYMT_DATA_STR-ZTLFX2 sy-vline 
WA_PYMT_DATA_STR-ZTELF1 sy-vline 
WA_PYMT_DATA_STR-ZTELF2 sy-vline 
WA_PYMT_DATA_STR-ZTELX1 sy-vline 
WA_PYMT_DATA_STR-HKTID sy-vline 
WA_PYMT_DATA_STR-HBKID sy-vline 
WA_PYMT_DATA_STR-UBNKS sy-vline 
WA_PYMT_DATA_STR-UBNKY sy-vline 
WA_PYMT_DATA_STR-UBKNT sy-vline 
WA_PYMT_DATA_STR-UBKON sy-vline 
WA_PYMT_DATA_STR-UBNKL sy-vline 
WA_PYMT_DATA_STR-ZBNKS sy-vline 
WA_PYMT_DATA_STR-ZBNKY sy-vline 
WA_PYMT_DATA_STR-ZBNKN sy-vline 
WA_PYMT_DATA_STR-ZBKON sy-vline 
WA_PYMT_DATA_STR-ZBNKL sy-vline 
WA_PYMT_DATA_STR-ZBKRF sy-vline 
WA_PYMT_DATA_STR-ZBKIN sy-vline 
WA_PYMT_DATA_STR-ZSWIF sy-vline 
WA_PYMT_DATA_STR-BTYP1 sy-vline 
WA_PYMT_DATA_STR-BNKS1 sy-vline 
WA_PYMT_DATA_STR-BNKL1 sy-vline 
WA_PYMT_DATA_STR-BNKN1 sy-vline 
WA_PYMT_DATA_STR-BKON1 sy-vline 
WA_PYMT_DATA_STR-BKLZ1 sy-vline 
WA_PYMT_DATA_STR-BKRF1 sy-vline 
WA_PYMT_DATA_STR-SWIF1 sy-vline 
WA_PYMT_DATA_STR-BTYP2 sy-vline 
WA_PYMT_DATA_STR-BNKS2 sy-vline 
WA_PYMT_DATA_STR-BNKL2 sy-vline 
WA_PYMT_DATA_STR-BNKN2 sy-vline 
WA_PYMT_DATA_STR-BKON2 sy-vline 
WA_PYMT_DATA_STR-BKLZ2 sy-vline 
WA_PYMT_DATA_STR-BKRF2 sy-vline 
WA_PYMT_DATA_STR-SWIF2 sy-vline 
WA_PYMT_DATA_STR-BTYP3 sy-vline 
WA_PYMT_DATA_STR-BNKS3 sy-vline 
WA_PYMT_DATA_STR-BNKL3 sy-vline 
WA_PYMT_DATA_STR-BNKN3 sy-vline 
WA_PYMT_DATA_STR-BKON3 sy-vline 
WA_PYMT_DATA_STR-BKLZ3 sy-vline 
WA_PYMT_DATA_STR-BKRF3 sy-vline 
WA_PYMT_DATA_STR-SWIF3 sy-vline      INTO ld_text SEPARATED BY SPACE.

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