ABAP Select data from SAP table PES_DAQ_IDEA_QFIELDS_2007 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 PES_DAQ_IDEA_QFIELDS_2007 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 PES_DAQ_IDEA_QFIELDS_2007. 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 PES_DAQ_IDEA_QFIELDS_2007 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_PES_DAQ_IDEA_QFIELDS_2007 TYPE STANDARD TABLE OF PES_DAQ_IDEA_QFIELDS_2007,
      WA_PES_DAQ_IDEA_QFIELDS_2007 TYPE PES_DAQ_IDEA_QFIELDS_2007,
      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: <PES_DAQ_IDEA_QFIELDS_2007> TYPE PES_DAQ_IDEA_QFIELDS_2007.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PES_DAQ_IDEA_QFIELDS_2007
*  INTO TABLE @DATA(IT_PES_DAQ_IDEA_QFIELDS_20072).
*--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_PES_DAQ_IDEA_QFIELDS_2007 INDEX 1 INTO DATA(WA_PES_DAQ_IDEA_QFIELDS_20072).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PES_DAQ_IDEA_QFIELDS_2007>-NUMR = 1.
<PES_DAQ_IDEA_QFIELDS_2007>-PTTIP = 1.
<PES_DAQ_IDEA_QFIELDS_2007>-NACHN = 1.
<PES_DAQ_IDEA_QFIELDS_2007>-NACH2 = 1.
<PES_DAQ_IDEA_QFIELDS_2007>-VORNA = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PES_DAQ_IDEA_QFIELDS_2007-NAF, sy-vline,
  WA_PES_DAQ_IDEA_QFIELDS_2007-FECIN, sy-vline,
  WA_PES_DAQ_IDEA_QFIELDS_2007-SEXO, sy-vline,
  WA_PES_DAQ_IDEA_QFIELDS_2007-GBDAT, sy-vline,
  WA_PES_DAQ_IDEA_QFIELDS_2007-NACIO, sy-vline,
  WA_PES_DAQ_IDEA_QFIELDS_2007-IPF, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PES_DAQ_IDEA_QFIELDS_2007 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_PES_DAQ_IDEA_QFIELDS_2007 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_PES_DAQ_IDEA_QFIELDS_2007 INTO WA_PES_DAQ_IDEA_QFIELDS_2007.


*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.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_PES_DAQ_IDEA_QFIELDS_2007_STR, 
NUMR TYPE STRING,
PTTIP TYPE STRING,
NACHN TYPE STRING,
NACH2 TYPE STRING,
VORNA TYPE STRING,
NAF TYPE STRING,
FECIN TYPE STRING,
SEXO TYPE STRING,
GBDAT TYPE STRING,
NACIO TYPE STRING,
IPF TYPE STRING,
SITUA TYPE STRING,
CNTXT TYPE STRING,
CODIG TYPE STRING,
ANMES TYPE STRING,
ANDIA TYPE STRING,
CONTR TYPE STRING,
REGSS TYPE STRING,
TXTCO TYPE STRING,
ATEP TYPE STRING,
TRDOM TYPE STRING,
TRPRO TYPE STRING,
TRTEL TYPE STRING,
TRMUN TYPE STRING,
TRCPO TYPE STRING,
TCNAE TYPE STRING,
CIFNI TYPE STRING,
RAZON TYPE STRING,
CCC TYPE STRING,
CATXT TYPE STRING,
CACOD TYPE STRING,
EMPLA TYPE STRING,
EMDOM TYPE STRING,
EMPRO TYPE STRING,
EMMUN TYPE STRING,
EMCPO TYPE STRING,
EMTEL TYPE STRING,
EMCON TYPE STRING,
EMETT TYPE STRING,
ASUNP TYPE STRING,
SRVPR TYPE STRING,
SRVAJ TYPE STRING,
TRABD TYPE STRING,
SRVMA TYPE STRING,
NINGU TYPE STRING,
LGCOD TYPE STRING,
LGTRA TYPE STRING,
LGPAI TYPE STRING,
LGPRO TYPE STRING,
LGMUN TYPE STRING,
LGDIR TYPE STRING,
LGVKM TYPE STRING,
LGOTR TYPE STRING,
CEEMP TYPE STRING,
CECEN TYPE STRING,
CIFTY TYPE STRING,
DTRAZ TYPE STRING,
DTDOM TYPE STRING,
DTPRO TYPE STRING,
DTMUN TYPE STRING,
DTCPO TYPE STRING,
DTTEL TYPE STRING,
DTPLA TYPE STRING,
DTCCC TYPE STRING,
DCNAT TYPE STRING,
DCNAC TYPE STRING,
ACFAC TYPE STRING,
ACFBA TYPE STRING,
ACDIA TYPE STRING,
ACHOR TYPE STRING,
ACHTR TYPE STRING,
ACHAB TYPE STRING,
ACEVA TYPE STRING,
ACDES TYPE STRING,
ENLUG TYPE STRING,
ENTIP TYPE STRING,
PRTRA TYPE STRING,
PRTTR TYPE STRING,
TAACT TYPE STRING,
TAESP TYPE STRING,
TAAGE TYPE STRING,
DEHEC TYPE STRING,
DEDES TYPE STRING,
DEAGE TYPE STRING,
MDTIP TYPE STRING,
MDFOR TYPE STRING,
MDTXT TYPE STRING,
MDAGE TYPE STRING,
AMMUL TYPE STRING,
AMTES TYPE STRING,
AMDAT TYPE STRING,
ASLES TYPE STRING,
ASGRA TYPE STRING,
ASPAR TYPE STRING,
MENOM TYPE STRING,
MEDOM TYPE STRING,
METEL TYPE STRING,
ASTIP TYPE STRING,
HOCOD TYPE STRING,
HONOM TYPE STRING,
MEMES TYPE STRING,
MEDIA TYPE STRING,
MEBAS TYPE STRING,
ANB1 TYPE STRING,
ANB2 TYPE STRING,
ANTOT TYPE STRING,
ANPRO TYPE STRING,
SUPRA TYPE STRING,
SUPRB TYPE STRING,
SUTOT TYPE STRING,
SUIND TYPE STRING,
FENOM TYPE STRING,
FECAL TYPE STRING,
FEPRO TYPE STRING,
FEFEC TYPE STRING,
EGCOD TYPE STRING,
EGNUM TYPE STRING,
EGFEC TYPE STRING,
ALCOD TYPE STRING,
ALNUM TYPE STRING,
ALFEC TYPE STRING,
ACMOT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PES_DAQ_IDEA_QFIELDS_2007_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_PES_DAQ_IDEA_QFIELDS_2007_STR-NUMR sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-PTTIP sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-NACHN sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-NACH2 sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-VORNA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-NAF sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-FECIN sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-SEXO sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-GBDAT sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-NACIO sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-IPF sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-SITUA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-CNTXT sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-CODIG sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ANMES sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ANDIA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-CONTR sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-REGSS sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-TXTCO sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ATEP sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-TRDOM sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-TRPRO sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-TRTEL sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-TRMUN sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-TRCPO sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-TCNAE sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-CIFNI sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-RAZON sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-CCC sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-CATXT sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-CACOD sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-EMPLA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-EMDOM sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-EMPRO sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-EMMUN sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-EMCPO sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-EMTEL sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-EMCON sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-EMETT sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ASUNP sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-SRVPR sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-SRVAJ sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-TRABD sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-SRVMA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-NINGU sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-LGCOD sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-LGTRA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-LGPAI sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-LGPRO sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-LGMUN sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-LGDIR sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-LGVKM sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-LGOTR sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-CEEMP sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-CECEN sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-CIFTY sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-DTRAZ sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-DTDOM sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-DTPRO sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-DTMUN sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-DTCPO sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-DTTEL sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-DTPLA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-DTCCC sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-DCNAT sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-DCNAC sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ACFAC sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ACFBA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ACDIA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ACHOR sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ACHTR sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ACHAB sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ACEVA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ACDES sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ENLUG sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ENTIP sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-PRTRA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-PRTTR sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-TAACT sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-TAESP sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-TAAGE sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-DEHEC sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-DEDES sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-DEAGE sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-MDTIP sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-MDFOR sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-MDTXT sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-MDAGE sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-AMMUL sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-AMTES sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-AMDAT sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ASLES sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ASGRA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ASPAR sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-MENOM sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-MEDOM sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-METEL sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ASTIP sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-HOCOD sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-HONOM sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-MEMES sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-MEDIA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-MEBAS sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ANB1 sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ANB2 sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ANTOT sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ANPRO sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-SUPRA sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-SUPRB sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-SUTOT sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-SUIND sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-FENOM sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-FECAL sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-FEPRO sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-FEFEC sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-EGCOD sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-EGNUM sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-EGFEC sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ALCOD sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ALNUM sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ALFEC sy-vline 
WA_PES_DAQ_IDEA_QFIELDS_2007_STR-ACMOT sy-vline      INTO ld_text SEPARATED BY SPACE.

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