ABAP Select data from SAP table CMD_BS_MAT_S_MAT_EXTERN 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 CMD_BS_MAT_S_MAT_EXTERN 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 CMD_BS_MAT_S_MAT_EXTERN. 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 CMD_BS_MAT_S_MAT_EXTERN 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_CMD_BS_MAT_S_MAT_EXTERN TYPE STANDARD TABLE OF CMD_BS_MAT_S_MAT_EXTERN,
WA_CMD_BS_MAT_S_MAT_EXTERN TYPE CMD_BS_MAT_S_MAT_EXTERN,
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: <CMD_BS_MAT_S_MAT_EXTERN> TYPE CMD_BS_MAT_S_MAT_EXTERN.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_CMD_BS_MAT_S_MAT_EXTERN.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM CMD_BS_MAT_S_MAT_EXTERN
INTO TABLE IT_CMD_BS_MAT_S_MAT_EXTERN.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM CMD_BS_MAT_S_MAT_EXTERN
* INTO TABLE @DATA(IT_CMD_BS_MAT_S_MAT_EXTERN2).
*--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_CMD_BS_MAT_S_MAT_EXTERN INDEX 1 INTO DATA(WA_CMD_BS_MAT_S_MAT_EXTERN2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_CMD_BS_MAT_S_MAT_EXTERN ASSIGNING <CMD_BS_MAT_S_MAT_EXTERN>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<CMD_BS_MAT_S_MAT_EXTERN>-PRODUCT = 1.
<CMD_BS_MAT_S_MAT_EXTERN>-MARA_TAB = 1.
<CMD_BS_MAT_S_MAT_EXTERN>-MARA_X_TAB = 1.
<CMD_BS_MAT_S_MAT_EXTERN>-MAKT_TAB = 1.
<CMD_BS_MAT_S_MAT_EXTERN>-MAKT_X_TAB = 1.
ENDLOOP. LOOP AT IT_CMD_BS_MAT_S_MAT_EXTERN INTO WA_CMD_BS_MAT_S_MAT_EXTERN. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_CMD_BS_MAT_S_MAT_EXTERN-MARC_TAB, sy-vline,
WA_CMD_BS_MAT_S_MAT_EXTERN-MARC_X_TAB, sy-vline,
WA_CMD_BS_MAT_S_MAT_EXTERN-MARD_TAB, sy-vline,
WA_CMD_BS_MAT_S_MAT_EXTERN-MARD_X_TAB, sy-vline,
WA_CMD_BS_MAT_S_MAT_EXTERN-MARM_TAB, sy-vline,
WA_CMD_BS_MAT_S_MAT_EXTERN-MARM_X_TAB, sy-vline.
ENDLOOP. *Add any further fields from structure WA_CMD_BS_MAT_S_MAT_EXTERN 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_CMD_BS_MAT_S_MAT_EXTERN 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_CMD_BS_MAT_S_MAT_EXTERN INTO WA_CMD_BS_MAT_S_MAT_EXTERN. *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_CMD_BS_MAT_S_MAT_EXTERN_STR,
PRODUCT TYPE STRING,
MARA_TAB TYPE STRING,
MARA_X_TAB TYPE STRING,
MAKT_TAB TYPE STRING,
MAKT_X_TAB TYPE STRING,
MARC_TAB TYPE STRING,
MARC_X_TAB TYPE STRING,
MARD_TAB TYPE STRING,
MARD_X_TAB TYPE STRING,
MARM_TAB TYPE STRING,
MARM_X_TAB TYPE STRING,
MEAN_TAB TYPE STRING,
MEAN_X_TAB TYPE STRING,
MFHM_TAB TYPE STRING,
MFHM_X_TAB TYPE STRING,
MLAN_PURCHASE_TAB TYPE STRING,
MLAN_PURCHASE_X_TAB TYPE STRING,
MLAN_SALES_TAB TYPE STRING,
MLAN_SALES_X_TAB TYPE STRING,
MBEW_TAB TYPE STRING,
MBEW_X_TAB TYPE STRING,
MLGN_TAB TYPE STRING,
MLGN_X_TAB TYPE STRING,
MLGT_TAB TYPE STRING,
MLGT_X_TAB TYPE STRING,
MPGD_TAB TYPE STRING,
MPGD_X_TAB TYPE STRING,
MPOP_TAB TYPE STRING,
MPOP_X_TAB TYPE STRING,
MVKE_TAB TYPE STRING,
MVKE_X_TAB TYPE STRING,
NOTES_TAB TYPE STRING,
NOTES_LINES_TAB TYPE STRING,
NOTES_X_TAB TYPE STRING,
PLANT_NOTES_TAB TYPE STRING,
PLANT_NOTES_LINES_TAB TYPE STRING,
PLANT_NOTES_X_TAB TYPE STRING,
SALES_NOTES_TAB TYPE STRING,
SALES_NOTES_LINES_TAB TYPE STRING,
SALES_NOTES_X_TAB TYPE STRING,
QMAT_TAB TYPE STRING,
QMAT_X_TAB TYPE STRING,
CKMLHD_TAB TYPE STRING,
CKMLHD_X_TAB TYPE STRING,
CKMLCR_TAB TYPE STRING,
CKMLCR_X_TAB TYPE STRING,
CKMLPR_TAB TYPE STRING,
CKMLPR_X_TAB TYPE STRING,
MDMA_TAB TYPE STRING,
MDMA_X_TAB TYPE STRING,
E1CUCOM_TAB TYPE STRING,
E1CUCOM_X_TAB TYPE STRING,
E1CUCFG_TAB TYPE STRING,
E1CUCFG_X_TAB TYPE STRING,
E1CUVAL_TAB TYPE STRING,
E1CUVAL_X_TAB TYPE STRING,
E1CUINS_TAB TYPE STRING,
E1CUINS_X_TAB TYPE STRING,
WLK2_TAB TYPE STRING,
WLK2_X_TAB TYPE STRING,
MAW1_TAB TYPE STRING,
MAW1_X_TAB TYPE STRING,
MAMT_TAB TYPE STRING,
MAMT_X_TAB TYPE STRING,
MLEA_TAB TYPE STRING,
MLEA_X_TAB TYPE STRING,
FSH_SEASONS_MAT_TAB TYPE STRING,
FSH_SEASONS_MAT_X_TAB TYPE STRING,
WRF_MATGRP_SKU_TAB TYPE STRING,
WRF_MATGRP_SKU_X_TAB TYPE STRING,
WRPP_TAB TYPE STRING,
WRPP_X_TAB TYPE STRING,
WRPL_TAB TYPE STRING,
WRPL_X_TAB TYPE STRING,
DRAD_TAB TYPE STRING,
DRAD_X_TAB TYPE STRING,
DRAD_NOTES_TAB TYPE STRING,
DRAD_NOTES_X_TAB TYPE STRING,
AEOI_TAB TYPE STRING,
MKAL_TAB TYPE STRING,
MKAL_X_TAB TYPE STRING,
KEY_DATE TYPE STRING,
INOB TYPE STRING,
KSSK_INSERT TYPE STRING,
KSSK_DELETE TYPE STRING,
AUSP_INSERT TYPE STRING,
AUSP_DELETE TYPE STRING,
MATLSPP_TAB TYPE STRING,
MATLSPP_X_TAB TYPE STRING,
MATGROUP_TAB TYPE STRING,
MATGROUP_X_TAB TYPE STRING,
STKO_TAB TYPE STRING,
STKO_X_TAB TYPE STRING,
STPO_TAB TYPE STRING,
STPO_X_TAB TYPE STRING,
T415B_TAB TYPE STRING,
T415B_X_TAB TYPE STRING,
PRD_PLNT_APS_EXT_TAB TYPE STRING,
PRD_PLNT_APS_EXT_X_TAB TYPE STRING,
PRD_DMND_PENALTY_TAB TYPE STRING,
PRD_DMND_PENALTY_X_TAB TYPE STRING,
PRD_MATPLSTA_TAB TYPE STRING,
PRD_MATPLSTA_X_TAB TYPE STRING,
CLASSIFICATION_DATA TYPE STRING,
VARIANT_CONFIGURATION TYPE STRING,END OF T_EKKO_STR. DATA: WA_CMD_BS_MAT_S_MAT_EXTERN_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_CMD_BS_MAT_S_MAT_EXTERN_STR-PRODUCT sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MARA_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MARA_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MAKT_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MAKT_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MARC_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MARC_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MARD_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MARD_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MARM_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MARM_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MEAN_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MEAN_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MFHM_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MFHM_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MLAN_PURCHASE_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MLAN_PURCHASE_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MLAN_SALES_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MLAN_SALES_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MBEW_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MBEW_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MLGN_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MLGN_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MLGT_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MLGT_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MPGD_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MPGD_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MPOP_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MPOP_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MVKE_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MVKE_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-NOTES_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-NOTES_LINES_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-NOTES_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-PLANT_NOTES_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-PLANT_NOTES_LINES_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-PLANT_NOTES_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-SALES_NOTES_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-SALES_NOTES_LINES_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-SALES_NOTES_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-QMAT_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-QMAT_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-CKMLHD_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-CKMLHD_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-CKMLCR_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-CKMLCR_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-CKMLPR_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-CKMLPR_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MDMA_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MDMA_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-E1CUCOM_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-E1CUCOM_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-E1CUCFG_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-E1CUCFG_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-E1CUVAL_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-E1CUVAL_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-E1CUINS_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-E1CUINS_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-WLK2_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-WLK2_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MAW1_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MAW1_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MAMT_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MAMT_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MLEA_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MLEA_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-FSH_SEASONS_MAT_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-FSH_SEASONS_MAT_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-WRF_MATGRP_SKU_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-WRF_MATGRP_SKU_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-WRPP_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-WRPP_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-WRPL_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-WRPL_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-DRAD_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-DRAD_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-DRAD_NOTES_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-DRAD_NOTES_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-AEOI_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MKAL_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MKAL_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-KEY_DATE sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-INOB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-KSSK_INSERT sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-KSSK_DELETE sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-AUSP_INSERT sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-AUSP_DELETE sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MATLSPP_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MATLSPP_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MATGROUP_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-MATGROUP_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-STKO_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-STKO_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-STPO_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-STPO_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-T415B_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-T415B_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-PRD_PLNT_APS_EXT_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-PRD_PLNT_APS_EXT_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-PRD_DMND_PENALTY_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-PRD_DMND_PENALTY_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-PRD_MATPLSTA_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-PRD_MATPLSTA_X_TAB sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-CLASSIFICATION_DATA sy-vline
WA_CMD_BS_MAT_S_MAT_EXTERN_STR-VARIANT_CONFIGURATION sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.