ABAP Select data from SAP table PKW_HKWPMGV0_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 PKW_HKWPMGV0_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 PKW_HKWPMGV0_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 PKW_HKWPMGV0_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_PKW_HKWPMGV0_DATA TYPE STANDARD TABLE OF PKW_HKWPMGV0_DATA,
      WA_PKW_HKWPMGV0_DATA TYPE PKW_HKWPMGV0_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: <PKW_HKWPMGV0_DATA> TYPE PKW_HKWPMGV0_DATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PKW_HKWPMGV0_DATA
*  INTO TABLE @DATA(IT_PKW_HKWPMGV0_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_PKW_HKWPMGV0_DATA INDEX 1 INTO DATA(WA_PKW_HKWPMGV0_DATA2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PKW_HKWPMGV0_DATA>-ACTNO = 1.
<PKW_HKWPMGV0_DATA>-VTYPE = 1.
<PKW_HKWPMGV0_DATA>-ACTNO = 1.
<PKW_HKWPMGV0_DATA>-CINEE = 1.
<PKW_HKWPMGV0_DATA>-ARFNM = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PKW_HKWPMGV0_DATA-CINEE, sy-vline,
  WA_PKW_HKWPMGV0_DATA-ARFNM, sy-vline,
  WA_PKW_HKWPMGV0_DATA-ARSNM, sy-vline,
  WA_PKW_HKWPMGV0_DATA-ARSNM, sy-vline,
  WA_PKW_HKWPMGV0_DATA-ARTNM, sy-vline,
  WA_PKW_HKWPMGV0_DATA-ARLNM, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PKW_HKWPMGV0_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_PKW_HKWPMGV0_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_PKW_HKWPMGV0_DATA INTO WA_PKW_HKWPMGV0_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 PDATE, internal->external for field GBDAT
CALL FUNCTION 'CONVERSION_EXIT_PDATE_OUTPUT'
  EXPORTING
    input =                      WA_PKW_HKWPMGV0_DATA-GBDAT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PKW_HKWPMGV0_DATA-GBDAT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PDATE, internal->external for field GBDAT
CALL FUNCTION 'CONVERSION_EXIT_PDATE_OUTPUT'
  EXPORTING
    input =                      WA_PKW_HKWPMGV0_DATA-GBDAT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PKW_HKWPMGV0_DATA-GBDAT.
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_PKW_HKWPMGV0_DATA_STR, 
ACTNO TYPE STRING,
VTYPE TYPE STRING,
ACTNO TYPE STRING,
CINEE TYPE STRING,
ARFNM TYPE STRING,
CINEE TYPE STRING,
ARFNM TYPE STRING,
ARSNM TYPE STRING,
ARSNM TYPE STRING,
ARTNM TYPE STRING,
ARLNM TYPE STRING,
ARTNM TYPE STRING,
ARLNM TYPE STRING,
ENFNM TYPE STRING,
ENFNM TYPE STRING,
ENSNM TYPE STRING,
ENSNM TYPE STRING,
ENTNM TYPE STRING,
ENLNM TYPE STRING,
ENTNM TYPE STRING,
ENLNM TYPE STRING,
NATIO TYPE STRING,
GETXT TYPE STRING,
NATIO TYPE STRING,
GBORT TYPE STRING,
GETXT TYPE STRING,
GBDAT TYPE STRING,
GBORT TYPE STRING,
GBDAT TYPE STRING,
MATXT TYPE STRING,
MATXT TYPE STRING,
QUALI TYPE STRING,
PROFI TYPE STRING,
QUALI TYPE STRING,
JBTXT TYPE STRING,
PROFI TYPE STRING,
JBTXT TYPE STRING,
STEXT TYPE STRING,
PPNUM TYPE STRING,
STEXT TYPE STRING,
PPCOL TYPE STRING,
PPNUM TYPE STRING,
PPCOL TYPE STRING,
PPISS TYPE STRING,
PPDAT TYPE STRING,
PPISS TYPE STRING,
EXPID TYPE STRING,
PPDAT TYPE STRING,
DEPNM TYPE STRING,
EXPID TYPE STRING,
DEPNM TYPE STRING,
RETXT TYPE STRING,
RETXT TYPE STRING,
STRAS TYPE STRING,
FLOOR TYPE STRING,
STRAS TYPE STRING,
FLOOR TYPE STRING,
POSTA TYPE STRING,
HIDAT TYPE STRING,
POSTA TYPE STRING,
BSALA TYPE STRING,
HIDAT TYPE STRING,
BSALA TYPE STRING,
TELNR TYPE STRING,
MOBIL TYPE STRING,
TELNR TYPE STRING,
MOBIL TYPE STRING,
OCNUM TYPE STRING,
ARFN2 TYPE STRING,
OCNUM TYPE STRING,
ARFN2 TYPE STRING,
ARSN2 TYPE STRING,
ARSN2 TYPE STRING,
ARTN2 TYPE STRING,
ARLN2 TYPE STRING,
ARTN2 TYPE STRING,
ARLN2 TYPE STRING,
ENFN2 TYPE STRING,
ARFA2 TYPE STRING,
ENSN2 TYPE STRING,
ENFN2 TYPE STRING,
ENTN2 TYPE STRING,
ENLN2 TYPE STRING,
ENSN2 TYPE STRING,
ENTN2 TYPE STRING,
ONAME TYPE STRING,
ENLN2 TYPE STRING,
NATI2 TYPE STRING,
BSAL2 TYPE STRING,
ONAME TYPE STRING,
JBTX2 TYPE STRING,
NATI2 TYPE STRING,
BSAL2 TYPE STRING,
PHONE TYPE STRING,
JBTX2 TYPE STRING,
OCITY TYPE STRING,
OAREA TYPE STRING,
PHONE TYPE STRING,
OCITY TYPE STRING,
OSTRE TYPE STRING,
BUTYP TYPE STRING,
OAREA TYPE STRING,
FLOO2 TYPE STRING,
OSTRE TYPE STRING,
APART TYPE STRING,
BUTYP TYPE STRING,
FLOO2 TYPE STRING,
POBOX TYPE STRING,
APART TYPE STRING,
POSTC TYPE STRING,
EMAIL TYPE STRING,
POBOX TYPE STRING,
POSTC TYPE STRING,
VINUM TYPE STRING,
EMAIL TYPE STRING,
VIDAT TYPE STRING,
VINUM TYPE STRING,
TBL_DEP TYPE STRING,
PERNM TYPE STRING,
VIDAT TYPE STRING,
LADAT TYPE STRING,
TBL_DEP TYPE STRING,
PERNM TYPE STRING,
WAERS TYPE STRING,
LADAT TYPE STRING,
WAERS TYPE STRING,
VACTN TYPE STRING,
OUNIF TYPE STRING,
ACIVI TYPE STRING,
BSANM TYPE STRING,
BSADC TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PKW_HKWPMGV0_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_PKW_HKWPMGV0_DATA_STR-ACTNO sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-VTYPE sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ACTNO sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-CINEE sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARFNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-CINEE sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARFNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARSNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARSNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARTNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARLNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARTNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARLNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENFNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENFNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENSNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENSNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENTNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENLNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENTNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENLNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-NATIO sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-GETXT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-NATIO sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-GBORT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-GETXT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-GBDAT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-GBORT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-GBDAT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-MATXT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-MATXT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-QUALI sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PROFI sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-QUALI sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-JBTXT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PROFI sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-JBTXT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-STEXT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PPNUM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-STEXT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PPCOL sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PPNUM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PPCOL sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PPISS sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PPDAT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PPISS sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-EXPID sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PPDAT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-DEPNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-EXPID sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-DEPNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-RETXT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-RETXT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-STRAS sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-FLOOR sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-STRAS sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-FLOOR sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-POSTA sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-HIDAT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-POSTA sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-BSALA sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-HIDAT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-BSALA sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-TELNR sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-MOBIL sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-TELNR sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-MOBIL sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-OCNUM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARFN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-OCNUM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARFN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARSN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARSN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARTN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARLN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARTN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARLN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENFN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ARFA2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENSN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENFN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENTN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENLN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENSN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENTN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ONAME sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ENLN2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-NATI2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-BSAL2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ONAME sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-JBTX2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-NATI2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-BSAL2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PHONE sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-JBTX2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-OCITY sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-OAREA sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PHONE sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-OCITY sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-OSTRE sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-BUTYP sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-OAREA sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-FLOO2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-OSTRE sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-APART sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-BUTYP sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-FLOO2 sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-POBOX sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-APART sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-POSTC sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-EMAIL sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-POBOX sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-POSTC sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-VINUM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-EMAIL sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-VIDAT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-VINUM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-TBL_DEP sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PERNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-VIDAT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-LADAT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-TBL_DEP sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-PERNM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-WAERS sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-LADAT sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-WAERS sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-VACTN sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-OUNIF sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-ACIVI sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-BSANM sy-vline 
WA_PKW_HKWPMGV0_DATA_STR-BSADC sy-vline      INTO ld_text SEPARATED BY SPACE.

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