Posts

Showing posts from August, 2015

Excel upload

*&---------------------------------------------------------------------* *& Report  ZJTEST_EXCEL_UPLOAD *& *&---------------------------------------------------------------------* *& *& *&---------------------------------------------------------------------* REPORT  ZJTEST_EXCEL_UPLOAD . TYPE-POOLS  truxs . *TABLES : zscarr. Types  :  Begin  of  wa  ,         matnr ( 50 )  type  c ,         werks ( 10 )  type  c ,         mtart ( 20 )  type  c ,         maktx ( 20 )  type  c ,        End  of  wa . Data  itab  type  table  of  wa . data  itab_wa  type  wa . data  it_type  TYPE  truxs_t_t...
*&---------------------------------------------------------------------* *& Report  YJFIR01 *& Name : Jatin Singhal *  Date : 03.02.15 *&---------------------------------------------------------------------* *& *& *&---------------------------------------------------------------------* REPORT  yjfir01 . DATA  :  gt_alv  TYPE  TABLE  OF  yjalv01 ,      " Global table for Display        gi_fcat  TYPE  slis_t_fieldcat_alv .  " Global field catalogue DATA  :  gv_gjahr  LIKE  rbco - gjahr ,        gv_bukrs  LIKE  rbco - bukrs ,        gv_blart  LIKE  bsak - blart ,        gv_augdt  LIKE  bsak - a...

Export xls using BDC

REPORT  ysdr7900 MESSAGE-ID yy. *----------------------------------------------------------------------- *                         P R O G R A M *                     D E S C R I P T I O N * * Create commodity codes from excel sheet. * *----------------------------------------------------------------------- *  Transaction: ZSD122 *----------------------------------------------------------------------- TYPES: BEGIN OF st_inrec,          land1  TYPE land1,          stawn  TYPE stawn,          text1  TYPE bezei40,          bemeh  TYPE bemeh,        END OF ...

Export data to xls using OOPS

* REPORT  ZDEMO_EXCEL20 * Demo for method zcl_excel_worksheet-bind_alv: * export data from ALV (CL_GUI_ALV_GRID) object to excel *--------------------------------------------------------------------* REPORT  zdemo_excel20. *----------------------------------------------------------------------* *       CLASS lcl_handle_events DEFINITION *----------------------------------------------------------------------* * *----------------------------------------------------------------------* CLASS lcl_handle_events DEFINITION.   PUBLIC SECTION.     METHODS:       on_user_command FOR EVENT added_function OF cl_salv_events         IMPORTING e_salv_function. ENDCLASS.                    "lcl_handle_events DEFINITION *---------------------------------------------------------------------...

Smartforms demo

data l_work type ypm_st_pmord. * Language   g_control-langu = sy-langu.     "Language * Printer dialog   if s_diag = 'X'.     g_control-no_dialog = ' '.   else.     g_control-no_dialog = 'X'.   endif. * Print options   g_output-tddest     = s_print.   "Printer name   g_output-tdcopies   = s_copy.    "Number of copies   g_control-preview   = s_prev.    "Preview   g_output-tdimmed    = s_pnow.    "Print immediately.   g_output-tdnewid    = s_spol.    "New spool request call function 'SSF_FUNCTION_MODULE_NAME'        EXPORTING             formname           = 'YPM_DIMMING'        IMPORTING ...

Multiple joins example

loop at gt_equip_work. select                ekkn~aufnr             "order                ekkn~ablad             "Order by                afih~iwerk             "Plant                ekko~ebeln             "PO number                ekko~bedat             "document date              ...

Error handling in update FM