ABAP Select data from SAP table MMPUR_PRINT_COMPLIST_HDR into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP MMPUR_PRINT_COMPLIST_HDR 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 MMPUR_PRINT_COMPLIST_HDR. 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 MMPUR_PRINT_COMPLIST_HDR 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_MMPUR_PRINT_COMPLIST_HDR TYPE STANDARD TABLE OF MMPUR_PRINT_COMPLIST_HDR,
      WA_MMPUR_PRINT_COMPLIST_HDR TYPE MMPUR_PRINT_COMPLIST_HDR,
      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: <MMPUR_PRINT_COMPLIST_HDR> TYPE MMPUR_PRINT_COMPLIST_HDR.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MMPUR_PRINT_COMPLIST_HDR
*  INTO TABLE @DATA(IT_MMPUR_PRINT_COMPLIST_HDR2).
*--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_MMPUR_PRINT_COMPLIST_HDR INDEX 1 INTO DATA(WA_MMPUR_PRINT_COMPLIST_HDR2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_MMPUR_PRINT_COMPLIST_HDR ASSIGNING <MMPUR_PRINT_COMPLIST_HDR>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<MMPUR_PRINT_COMPLIST_HDR>-EBELP = 1.
<MMPUR_PRINT_COMPLIST_HDR>-ETENR = 1.
<MMPUR_PRINT_COMPLIST_HDR>-LFDAT = 1.
<MMPUR_PRINT_COMPLIST_HDR>-PRITX = 1.
<MMPUR_PRINT_COMPLIST_HDR>-MATNR = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MMPUR_PRINT_COMPLIST_HDR-PWWRK, sy-vline,
WA_MMPUR_PRINT_COMPLIST_HDR-LGORT, sy-vline,
WA_MMPUR_PRINT_COMPLIST_HDR-OBART, sy-vline,
WA_MMPUR_PRINT_COMPLIST_HDR-PLNUM, sy-vline,
WA_MMPUR_PRINT_COMPLIST_HDR-PAART, sy-vline,
WA_MMPUR_PRINT_COMPLIST_HDR-BESKZ, sy-vline.
ENDLOOP. *Add any further fields from structure WA_MMPUR_PRINT_COMPLIST_HDR 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_MMPUR_PRINT_COMPLIST_HDR 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_MMPUR_PRINT_COMPLIST_HDR INTO WA_MMPUR_PRINT_COMPLIST_HDR. *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 MATN1, internal->external for field MATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_MMPUR_PRINT_COMPLIST_HDR-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MMPUR_PRINT_COMPLIST_HDR-MATNR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit CUNIT, internal->external for field LAGME CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_MMPUR_PRINT_COMPLIST_HDR-LAGME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MMPUR_PRINT_COMPLIST_HDR-LAGME.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ABPSP, internal->external for field PSPEL CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_MMPUR_PRINT_COMPLIST_HDR-PSPEL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MMPUR_PRINT_COMPLIST_HDR-PSPEL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit NUMCV, internal->external for field REVLV CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_MMPUR_PRINT_COMPLIST_HDR-REVLV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MMPUR_PRINT_COMPLIST_HDR-REVLV.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit NUMCV, internal->external for field STLNR CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_MMPUR_PRINT_COMPLIST_HDR-STLNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MMPUR_PRINT_COMPLIST_HDR-STLNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ABPSP, internal->external for field DISUB_PSPNR CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_MMPUR_PRINT_COMPLIST_HDR-DISUB_PSPNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MMPUR_PRINT_COMPLIST_HDR-DISUB_PSPNR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ALPHA, internal->external for field DISUB_OWNER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_MMPUR_PRINT_COMPLIST_HDR-DISUB_OWNER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MMPUR_PRINT_COMPLIST_HDR-DISUB_OWNER.
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_MMPUR_PRINT_COMPLIST_HDR_STR,
EBELP TYPE STRING,
ETENR TYPE STRING,
LFDAT TYPE STRING,
PRITX TYPE STRING,
MATNR TYPE STRING,
PWWRK TYPE STRING,
LGORT TYPE STRING,
OBART TYPE STRING,
PLNUM TYPE STRING,
PAART TYPE STRING,
BESKZ TYPE STRING,
SOBES TYPE STRING,
GSMNG TYPE STRING,
TLMNG TYPE STRING,
AVMNG TYPE STRING,
LAGME TYPE STRING,
PSTTR TYPE STRING,
PEDTR TYPE STRING,
UMSKZ TYPE STRING,
KNTTP TYPE STRING,
SOBKZ TYPE STRING,
KZVBR TYPE STRING,
KZBWS TYPE STRING,
KDAUF TYPE STRING,
KDPOS TYPE STRING,
KDEIN TYPE STRING,
PSPEL TYPE STRING,
SERNR TYPE STRING,
PALTR TYPE STRING,
TECHS TYPE STRING,
REVLV TYPE STRING,
VERID TYPE STRING,
STLAN TYPE STRING,
STALT TYPE STRING,
STSTA TYPE STRING,
FRTHW TYPE STRING,
AENNR TYPE STRING,
CUOBJ TYPE STRING,
CUART TYPE STRING,
VERTO TYPE STRING,
AUSSL TYPE STRING,
OLDSL TYPE STRING,
RSNUM TYPE STRING,
RSPOS TYPE STRING,
AUFST TYPE STRING,
AUFWG TYPE STRING,
BAUST TYPE STRING,
BAUWG TYPE STRING,
DISST TYPE STRING,
ALTSL TYPE STRING,
STLTY TYPE STRING,
STLNR TYPE STRING,
PRNKZ TYPE STRING,
SBNUM TYPE STRING,
SBPOS TYPE STRING,
GSBTR TYPE STRING,
VFMNG TYPE STRING,
MDPBV TYPE STRING,
KZAVC TYPE STRING,
MTVFP TYPE STRING,
VRPLA TYPE STRING,
KFPOS TYPE STRING,
DUMPS TYPE STRING,
AUFPL_ORD TYPE STRING,
APLZL_ORD TYPE STRING,
WAMNG TYPE STRING,
WEMNG TYPE STRING,
EDGNO TYPE STRING,
FLIEF TYPE STRING,
PLSCN TYPE STRING,
PLWRK TYPE STRING,
BERID TYPE STRING,
ARSNR TYPE STRING,
EMLIF TYPE STRING,
STAEX TYPE STRING,
SGT_SCAT TYPE STRING,
DELVR TYPE STRING,
EBNVR TYPE STRING,
POSVR TYPE STRING,
BOM_VERSN TYPE STRING,
SERRU TYPE STRING,
ANZSN TYPE STRING,
DISUB_SOBKZ TYPE STRING,
DISUB_PSPNR TYPE STRING,
DISUB_KUNNR TYPE STRING,
DISUB_VBELN TYPE STRING,
DISUB_POSNR TYPE STRING,
DISUB_OWNER TYPE STRING,
PSTYP TYPE STRING,END OF T_EKKO_STR. DATA: WA_MMPUR_PRINT_COMPLIST_HDR_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_MMPUR_PRINT_COMPLIST_HDR_STR-EBELP sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-ETENR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-LFDAT sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-PRITX sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-MATNR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-PWWRK sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-LGORT sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-OBART sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-PLNUM sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-PAART sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-BESKZ sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-SOBES sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-GSMNG sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-TLMNG sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-AVMNG sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-LAGME sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-PSTTR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-PEDTR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-UMSKZ sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-KNTTP sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-SOBKZ sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-KZVBR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-KZBWS sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-KDAUF sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-KDPOS sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-KDEIN sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-PSPEL sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-SERNR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-PALTR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-TECHS sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-REVLV sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-VERID sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-STLAN sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-STALT sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-STSTA sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-FRTHW sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-AENNR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-CUOBJ sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-CUART sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-VERTO sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-AUSSL sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-OLDSL sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-RSNUM sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-RSPOS sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-AUFST sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-AUFWG sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-BAUST sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-BAUWG sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-DISST sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-ALTSL sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-STLTY sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-STLNR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-PRNKZ sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-SBNUM sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-SBPOS sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-GSBTR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-VFMNG sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-MDPBV sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-KZAVC sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-MTVFP sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-VRPLA sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-KFPOS sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-DUMPS sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-AUFPL_ORD sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-APLZL_ORD sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-WAMNG sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-WEMNG sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-EDGNO sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-FLIEF sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-PLSCN sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-PLWRK sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-BERID sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-ARSNR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-EMLIF sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-STAEX sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-SGT_SCAT sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-DELVR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-EBNVR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-POSVR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-BOM_VERSN sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-SERRU sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-ANZSN sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-DISUB_SOBKZ sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-DISUB_PSPNR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-DISUB_KUNNR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-DISUB_VBELN sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-DISUB_POSNR sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-DISUB_OWNER sy-vline
WA_MMPUR_PRINT_COMPLIST_HDR_STR-PSTYP sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.