Tuesday, 28 February 2017

PRT for operation

Case 1 :
   AFKO-AUFPL = AFFH-AUFPL

Case 2 : Table
  MAPL , PLPO , PLAS , PLFH

Wednesday, 22 February 2017

VB For Application - Object Browser


1. Open Excel or Word.
2. Hold Alt + F11 for open Microsoft Visual Basic for Applications

3. Click button Object Browser.






ABAP OLE Programming for Excel


DATAh_excel TYPE ole2_object,        " Excel object
        h_mapl TYPE ole2_object,         " list of workbooks
        h_map TYPE ole2_object,          " workbook
        v_filename TYPE string VALUE 'C:\Users\phoonookan\Desktop\1111.xlsx'.

  CREATE OBJECT h_excel 'EXCEL.APPLICATION'.
  SET PROPERTY OF h_excel  'Visible' 1.
  CALL METHOD OF h_excel 'Workbooks' h_mapl.
  CALL METHOD OF h_mapl 'Open' h_map
    EXPORTING
    #1 v_filename.

*CALL METHOD OF h_map 'PrintOut'.
  CALL METHOD OF h_map 'PrintPreview'.
  CALL METHOD OF h_mapl 'Close'.

Tuesday, 14 February 2017

MS word editor in Smartforms


Go to se38
Run RSCPSETEDITOR
     Check is SAPscript and Smart Form boxes Active.
     Uncheck is SAPscript and Smart Form boxes Inactive.
And click in Activate button.