ABAP Select data from SAP table PMXCXXXX 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 PMXCXXXX 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 PMXCXXXX. 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 PMXCXXXX 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_PMXCXXXX TYPE STANDARD TABLE OF PMXCXXXX,
      WA_PMXCXXXX TYPE PMXCXXXX,
      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: <PMXCXXXX> TYPE PMXCXXXX.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PMXCXXXX
*  INTO TABLE @DATA(IT_PMXCXXXX2).
*--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_PMXCXXXX INDEX 1 INTO DATA(WA_PMXCXXXX2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PMXCXXXX>-TINCA = 1.
<PMXCXXXX>-RINCA = 1.
<PMXCXXXX>-RAUSE = 1.
<PMXCXXXX>-FESTA = 1.
<PMXCXXXX>-INOERR = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PMXCXXXX-IF2001, sy-vline,
  WA_PMXCXXXX-FMAGN, sy-vline,
  WA_PMXCXXXX-FMSUA, sy-vline,
  WA_PMXCXXXX-FOFIC, sy-vline,
  WA_PMXCXXXX-FPREL, sy-vline,
  WA_PMXCXXXX-FCIFR, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PMXCXXXX 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_PMXCXXXX 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_PMXCXXXX INTO WA_PMXCXXXX.


*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 GJAHR, internal->external for field ANPRO
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_PMXCXXXX-ANPRO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PMXCXXXX-ANPRO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SPDEV, internal->external for field PDEST
CALL FUNCTION 'CONVERSION_EXIT_SPDEV_OUTPUT'
  EXPORTING
    input =                      WA_PMXCXXXX-PDEST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PMXCXXXX-PDEST.
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_PMXCXXXX_STR, 
TINCA TYPE STRING,
RINCA TYPE STRING,
RAUSE TYPE STRING,
FESTA TYPE STRING,
INOERR TYPE STRING,
IF2001 TYPE STRING,
FMAGN TYPE STRING,
FMSUA TYPE STRING,
FOFIC TYPE STRING,
FPREL TYPE STRING,
FCIFR TYPE STRING,
FINIC TYPE STRING,
FEMIS TYPE STRING,
FOPAG TYPE STRING,
ALTSS TYPE STRING,
MODSS TYPE STRING,
BAJSS TYPE STRING,
AEACT TYPE STRING,
AEPRO TYPE STRING,
GNMED TYPE STRING,
ISIND TYPE STRING,
IPUNI TYPE STRING,
IPCOM TYPE STRING,
IPPRO TYPE STRING,
IVPRM TYPE STRING,
ISDIA TYPE STRING,
ISINT TYPE STRING,
IDECL TYPE STRING,
IPERI TYPE STRING,
F90 TYPE STRING,
IEMPR TYPE STRING,
IEMPL TYPE STRING,
IREDU TYPE STRING,
IULT TYPE STRING,
IRSLT TYPE STRING,
CINFO TYPE STRING,
CFONA TYPE STRING,
ANPRO TYPE STRING,
TEST TYPE STRING,
CCNOM TYPE STRING,
FCALC TYPE STRING,
PERIO TYPE STRING,
NPERI TYPE STRING,
POREC TYPE STRING,
POFIN TYPE STRING,
UTIL TYPE STRING,
SDMAX TYPE STRING,
INTER TYPE STRING,
WAERS TYPE STRING,
ISAPS TYPE STRING,
PDEST TYPE STRING,
CDEST TYPE STRING,
DAYIN TYPE STRING,
FEREP TYPE STRING,
BLIST TYPE STRING,
HSORT TYPE STRING,
SALTA TYPE STRING,
SMODI TYPE STRING,
SBAJA TYPE STRING,
SCALC TYPE STRING,
STEST TYPE STRING,
NCTEV TYPE STRING,
FMEDI TYPE STRING,
IDETA TYPE STRING,
CIMSS TYPE STRING,
ATEMP TYPE STRING,
BAING TYPE STRING,
BASENOR TYPE STRING,
RFC_SEP TYPE STRING,
BIDIRI14 TYPE STRING,
BINORM14 TYPE STRING,
BIDIRECT TYPE STRING,
BINORMAL TYPE STRING,
PAYIDUNI TYPE STRING,
PAYIDFREE TYPE STRING,
PAYIDFIX TYPE STRING,
IMP_EJER TYPE STRING,
IMP_NOVYUNO TYPE STRING,
AJIMP TYPE STRING,
OCRSN TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PMXCXXXX_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_PMXCXXXX_STR-TINCA sy-vline 
WA_PMXCXXXX_STR-RINCA sy-vline 
WA_PMXCXXXX_STR-RAUSE sy-vline 
WA_PMXCXXXX_STR-FESTA sy-vline 
WA_PMXCXXXX_STR-INOERR sy-vline 
WA_PMXCXXXX_STR-IF2001 sy-vline 
WA_PMXCXXXX_STR-FMAGN sy-vline 
WA_PMXCXXXX_STR-FMSUA sy-vline 
WA_PMXCXXXX_STR-FOFIC sy-vline 
WA_PMXCXXXX_STR-FPREL sy-vline 
WA_PMXCXXXX_STR-FCIFR sy-vline 
WA_PMXCXXXX_STR-FINIC sy-vline 
WA_PMXCXXXX_STR-FEMIS sy-vline 
WA_PMXCXXXX_STR-FOPAG sy-vline 
WA_PMXCXXXX_STR-ALTSS sy-vline 
WA_PMXCXXXX_STR-MODSS sy-vline 
WA_PMXCXXXX_STR-BAJSS sy-vline 
WA_PMXCXXXX_STR-AEACT sy-vline 
WA_PMXCXXXX_STR-AEPRO sy-vline 
WA_PMXCXXXX_STR-GNMED sy-vline 
WA_PMXCXXXX_STR-ISIND sy-vline 
WA_PMXCXXXX_STR-IPUNI sy-vline 
WA_PMXCXXXX_STR-IPCOM sy-vline 
WA_PMXCXXXX_STR-IPPRO sy-vline 
WA_PMXCXXXX_STR-IVPRM sy-vline 
WA_PMXCXXXX_STR-ISDIA sy-vline 
WA_PMXCXXXX_STR-ISINT sy-vline 
WA_PMXCXXXX_STR-IDECL sy-vline 
WA_PMXCXXXX_STR-IPERI sy-vline 
WA_PMXCXXXX_STR-F90 sy-vline 
WA_PMXCXXXX_STR-IEMPR sy-vline 
WA_PMXCXXXX_STR-IEMPL sy-vline 
WA_PMXCXXXX_STR-IREDU sy-vline 
WA_PMXCXXXX_STR-IULT sy-vline 
WA_PMXCXXXX_STR-IRSLT sy-vline 
WA_PMXCXXXX_STR-CINFO sy-vline 
WA_PMXCXXXX_STR-CFONA sy-vline 
WA_PMXCXXXX_STR-ANPRO sy-vline 
WA_PMXCXXXX_STR-TEST sy-vline 
WA_PMXCXXXX_STR-CCNOM sy-vline 
WA_PMXCXXXX_STR-FCALC sy-vline 
WA_PMXCXXXX_STR-PERIO sy-vline 
WA_PMXCXXXX_STR-NPERI sy-vline 
WA_PMXCXXXX_STR-POREC sy-vline 
WA_PMXCXXXX_STR-POFIN sy-vline 
WA_PMXCXXXX_STR-UTIL sy-vline 
WA_PMXCXXXX_STR-SDMAX sy-vline 
WA_PMXCXXXX_STR-INTER sy-vline 
WA_PMXCXXXX_STR-WAERS sy-vline 
WA_PMXCXXXX_STR-ISAPS sy-vline 
WA_PMXCXXXX_STR-PDEST sy-vline 
WA_PMXCXXXX_STR-CDEST sy-vline 
WA_PMXCXXXX_STR-DAYIN sy-vline 
WA_PMXCXXXX_STR-FEREP sy-vline 
WA_PMXCXXXX_STR-BLIST sy-vline 
WA_PMXCXXXX_STR-HSORT sy-vline 
WA_PMXCXXXX_STR-SALTA sy-vline 
WA_PMXCXXXX_STR-SMODI sy-vline 
WA_PMXCXXXX_STR-SBAJA sy-vline 
WA_PMXCXXXX_STR-SCALC sy-vline 
WA_PMXCXXXX_STR-STEST sy-vline 
WA_PMXCXXXX_STR-NCTEV sy-vline 
WA_PMXCXXXX_STR-FMEDI sy-vline 
WA_PMXCXXXX_STR-IDETA sy-vline 
WA_PMXCXXXX_STR-CIMSS sy-vline 
WA_PMXCXXXX_STR-ATEMP sy-vline 
WA_PMXCXXXX_STR-BAING sy-vline 
WA_PMXCXXXX_STR-BASENOR sy-vline 
WA_PMXCXXXX_STR-RFC_SEP sy-vline 
WA_PMXCXXXX_STR-BIDIRI14 sy-vline 
WA_PMXCXXXX_STR-BINORM14 sy-vline 
WA_PMXCXXXX_STR-BIDIRECT sy-vline 
WA_PMXCXXXX_STR-BINORMAL sy-vline 
WA_PMXCXXXX_STR-PAYIDUNI sy-vline 
WA_PMXCXXXX_STR-PAYIDFREE sy-vline 
WA_PMXCXXXX_STR-PAYIDFIX sy-vline 
WA_PMXCXXXX_STR-IMP_EJER sy-vline 
WA_PMXCXXXX_STR-IMP_NOVYUNO sy-vline 
WA_PMXCXXXX_STR-AJIMP sy-vline 
WA_PMXCXXXX_STR-OCRSN sy-vline      INTO ld_text SEPARATED BY SPACE.

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