What is Retroactive Payroll A payroll run is repeated for a period for which payroll has already been performed in the payroll past. Retroactive accounting is triggered during the payroll run for the current period if the certain master and time data affecting the payroll past has been changed in the meantime. Only changes to […]
Category: SAP ABAP General
ABAP Program to Upload Routing
How to use BAPI_ROUTING_CREATE We would to share Full ABAP Program to upload Routing using BAPI_ROUTING_CREATE . Routing data is located in Excel file. Below is the template from excel file. and you can modify it according to your needs
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
perform fill_cell using 1 1 'X' 'Material No' 'L' 'C'. perform fill_cell using 1 2 'X' 'Task List Description' 'L' 'C'. perform fill_cell using 1 3 'X' 'Plant' 'L' 'C'. perform fill_cell using 1 4 'X' 'Task List Usage' 'L' 'C'. perform fill_cell using 1 5 'X' 'Status' 'L' 'C'. perform fill_cell using 1 6 'X' 'From Lot Size' 'L' 'C'. perform fill_cell using 1 7 'X' 'UoM Task List' 'L' 'C'. perform fill_cell using 1 8 'X' 'Work Center' 'L' 'C'. perform fill_cell using 1 9 'X' 'Control Key' 'L' 'C'. perform fill_cell using 1 10 'X' 'Operation Short Text' 'L' 'C'. perform fill_cell using 1 11 'X' 'Base Qty' 'L' 'C'. perform fill_cell using 1 12 'X' 'Valid From(YYYYMMDD)' 'L' 'C'. perform fill_cell using 1 13 'X' 'Machine' 'L' 'C'. perform fill_cell using 1 14 'X' 'FOH' 'L' 'C'. perform fill_cell using 1 15 'X' 'Labor' 'L' 'C'. perform fill_cell using 1 16 'X' 'Carrier' 'L' 'C'. perform fill_cell using 1 17 'X' 'Qty per Jig' 'L' 'C'. perform fill_cell using 1 18 'X' 'Jig Available' 'L' 'C'. |
You can download ABAP Program to upload or download Routing here – > Upload SAP Routing […]
Enhancing Your ABAP Code – Part 1
There are various reason why ABAP Developments don’t always run correctly, the first category is the errors are caused by the developer’s basic lack of ABAP skills. In this article allowed me to explain some of errors that may be occured. The second category of errors can be characterized that wrong assumptions about the data […]
How to download Excel File With Password Protection
SAP ABAP Tutorial – You can download excel file from SAP System using function module EXCEL_OLE_STANDARD_DAT, this function module will generate excel file contain data from internal table and you able to password excel file. Check out this ABAP Code.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 |
REPORT ztest. DATA : BEGIN OF li_makt OCCURS 0, matnr TYPE matnr, maktx TYPE maktx, END OF li_makt. DATA: BEGIN OF li_head OCCURS 0, field(30) TYPE c, END OF li_head. SELECTION-SCREEN BEGIN OF BLOCK b2 WITH FRAME TITLE TEXT-002. PARAMETERS: p_file TYPE rlgrap-filename OBLIGATORY. SELECTION-SCREEN END OF BLOCK b2. AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file. PERFORM browse_file CHANGING p_file. START-OF-SELECTION. REFRESH li_head. DEFINE mc_head. li_head-field = &1. APPEND li_head. END-OF-DEFINITION. SELECT matnr maktx INTO TABLE li_makt FROM makt UP TO 20 ROWS WHERE spras = sy-langu . mc_head : 'Material No', 'Material Description'. CALL FUNCTION 'EXCEL_OLE_STANDARD_DAT' EXPORTING file_name = p_file create_pivot = 0 data_sheet_name = 'Data Material' pivot_sheet_name = ' ' password = 'plazapp' password_option = 1 TABLES data_tab = li_makt fieldnames = li_head EXCEPTIONS file_not_exist = 1 filename_expected = 2 communication_error = 3 ole_object_method_error = 4 ole_object_property_error = 5 invalid_filename = 6 invalid_pivot_fields = 7 download_problem = 8 OTHERS = 9. IF sy-subrc <> 0. MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4. ENDIF. FORM browse_file CHANGING p_file LIKE rlgrap-filename. DATA: filetab TYPE filetable, rc TYPE i, lv_offset TYPE i. FREE filetab. CALL METHOD cl_gui_frontend_services=>file_open_dialog EXPORTING window_title = 'Choose File' default_extension = '*.*' default_filename = 'c:\*.xls' CHANGING file_table = filetab rc = rc EXCEPTIONS file_open_dialog_failed = 1 cntl_error = 2 error_no_gui = 3 OTHERS = 4. IF sy-subrc = 0. READ TABLE filetab INTO p_file INDEX 1. ENDIF. ENDFORM. " browse_file |
You must fill parameter PASSWORD with your password and give ‘1’ into parameter PASSWORD_OPTION. When […]
Running Function Modules with Test Sequences using SE37
The Function Builder ( SE37 ) has an interface that allows you to test function module. Some function modules are required to run one after another, However you can’t run them one by one using classical test methods because some functions in sequence might depend on previous one. The main difference with using test sequences […]