Monthly Archives: June 2010
Push button on selection screen’s toolbar
REPORT z_test9 NO STANDARD PAGE HEADING . TABLES: sscrfields. SELECTION-SCREEN FUNCTION KEY 1.SELECTION-SCREEN FUNCTION KEY 2. PARAMETERS: P_TEST(8) TYPE C. INITIALIZATION. sscrfields-functxt_01 = ‘button1′. sscrfields-functxt_02 = ‘button2′. AT SELECTION-SCREEN. CASE sy-ucomm. WHEN ‘FC01′. P_TEST = ‘FC01′. WHEN ‘FC02′. P_TEST = ‘FC02′. ENDCASE.
Using tabstrip on selection screen
This is a simplest exmaple: REPORT zdemo_sel_screen_with_tabstrip. * SUBSCREEN 1SELECTION-SCREEN BEGIN OF SCREEN 100 AS SUBSCREEN.SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME.PARAMETERS: p1(10) TYPE c, p2(10) TYPE c, p3(10) TYPE c.SELECTION-SCREEN END OF BLOCK b1.SELECTION-SCREEN END OF SCREEN 100. * SUBSCREEN 2SELECTION-SCREEN BEGIN OF SCREEN 200 AS SUBSCREEN.SELECTION-SCREEN BEGIN OF BLOCK b2 WITH FRAME.PARAMETERS: q1(10) [...]
EXCEL中超过7层以上IF语句的替代方案
贴一个做好的计算扣个人所得税的公式: =A1*LOOKUP(A1,{0,2001,2501,4001,7001,22001,42001,62001,82001,102001},{0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45})-LOOKUP(A1,{0,2001,2501,4001,7001,22001,42001,62001,82001,102001},{0,0,25,125,375,1375,3375,6375,10375,15375})
MATLAB tips
1. MATLAB的文件编译: 编译单个文件:pcode suspension.m 编译当前文件夹所有文件:pcode *.m 2. 读取注册表信息 winqueryreg ‘HKEY_LOCAL_MACHINE’ ‘SYSTEMControlSet001ServicesTcpipParameters’ ‘Domain’ 3.在windows的命令行读取注册表 req query HKLMSYSTEMControlSet001ServicesTcpipParameters /v Domain MATLAB生成可执行文件的方法没有仔细研究,可以参考这篇文章
[转载]Configuration of the SAP-Oracle Database Interface
from:http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f01e743e-a7bf-2c10-399a-bd3cf2074ff3?QuickLink=ora&overridelayout=true pdf文件本地链接:http://filer.blogbus.com/1064822/resource_10648221275442443a.pdf 与上篇for all entries clause相关部分内容: Important paramters: rsdb/prefer_union_all = FALSE | TRUE = 0 | 1 a OR b or UNIONrsdb/prefer_in_itab_opt = FALSE | TRUE = 0 | 1 IN (a, b, …)rsdb/prefer_join = FALSE | TRUE = 0 | 1 FROM join_tablersdb/max_blocking_factor = 5 | n max. num. OR or UNIONrsdb/max_in_blocking_factor = 5 [...]
[转载]Disadvanges of “for all entries“ abap clause
from: http://it.toolbox.com/blogs/sap-on-db2/for-all-entries-vs-db2-join-8912 All abap programers and most of the dba’s that support abap programmers are familiar with the abap clause “for all entries”. Most of the web pages I visited recently, discuss 3 major drawbacks of the “for all entries” clause: 1. duplicate rows are automatically removed2. if the itab used in the clause is [...]