- 博客(51)
- 资源 (18)
- 收藏
- 关注
原创 ZRMM178 GR
*&---------------------------------------------------------------------**& Report ZRMM178 REL : 7.1c Author : Peak Huang ** Created : 2011.06.21 APP : All Type
2012-08-08 17:50:09 1950
原创 download to mutiple worksheets
************************************************************************* Program : ZRFI140 REL : 4.6c Author : Jetty jiang ** Created : 16-05-2011 APP : All Type
2012-07-31 10:51:45 913
原创 Auto create and/or approve PN based on new SO line item (ZRPP144)
************************************************************************* Program : ZRPP144 REL : ERP2004 Author : Daniel JIang ** Created : 21-11-2011 APP : PP Type
2012-07-18 11:29:18 1687
原创 EIL MU Analysis Report (ZRPP143)
************************************************************************* Program : ZRPP143 REL : 4.6c Author : Dainel Jiang ** Created : 03-11-2011 APP : All Type
2012-07-18 11:28:08 7778
原创 CAL - ISPS automate V01 GR (ZRPP106B)
************************************************************************ Program : ZRPP106B REL : 4.6C Author : Steven* Created : 2010.11.23 APP : ZPP* Title : Back
2012-07-18 11:26:38 3715
原创 SAP REPLACE STRANGE CHARS
*&---------------------------------------------------------------------**& Module F4_WASH INPUT*&---------------------------------------------------------------------** text*-----
2012-03-12 17:22:49 1872
原创 ME_PROCESS_PO_CUST
method IF_EX_ME_PROCESS_PO_CUST~CHECK. data im_item TYPE REF TO if_longtexts_mm. data ld_formatted type mmpur_bool. data lt_line type table of mmpur_textlines . data wa_line l
2011-11-30 11:41:26 4437
原创 ME_PURCHDOC_POSTED
This method is used to copy the text to po schedule line text when create po with ME21N method IF_EX_ME_PURCHDOC_POSTED~POSTED."create on 2011.11.05 by daniel data l_thead TYPE thead . dat
2011-11-30 11:36:11 3034
原创 F4 help research
zpp126PROCESS BEFORE OUTPUT.* MODULE STATUS_0200. MODULE TC001_INIT. LOOP AT G_TC001_ITAB INTO ZPP_STD_STRU WITH CONTROL TC001 CURSOR TC001-CURRENT_LINE. M
2011-11-30 11:20:28 1126
原创 丝丝记忆
丝丝记忆 -- 张学友迷上你的浅笑 我的心被照耀生生世世都不会忘掉迷上你的姿态 每一分亦美妙比起我那一切重要每晚都会掀起丝丝记忆记著你风中浅笑记著你乌黑一缕长发 随著你那脚步轻轻飘然而为何偏偏止於记忆记著你风中浅笑记著你乌黑一缕长发
2011-09-28 08:58:05 687
原创 从不放弃
从不放弃[ti:从不放弃]<br />[ar:郑少秋]<br />郑少秋:从不放弃<br />电视剧天地男儿主题曲<br />作曲:徐嘉良填词:潘伟源<br /><br />一丝丝记忆勾起了一串串滋味<br />它不少也不会多分享了重聚跟别离<br />一张张照片框起了一个个天地<br />不声不语偏说出岁月多依稀<br />一声声叹息终止了一处处境地<br />它将所有悲与喜编好了年月跟日期<br />一天天变更不可以一次次躲避<br />它需不竭的勇敢向梦想高飞<br />何愁面前浪破浪涌个无了期<br
2011-04-28 09:12:00 991
原创 Hide the columns in table-control
loop at i_final into wa_final with control table_control cursor table_control-current_line. module hide_columns_dynamically.endloop.* Module to hide the columns of table controlmodule hide_columns_dynamically.module hide_columns_dynamically output.if .da
2011-04-26 12:18:00 910
原创 DBIF_RSQL_INVALID_RSQL (FAE AND IN cause this error)
What can you do? Note down which actions and inputs caused the error. To process the problem further, contact you SAP system administrator. Using Transaction ST22 for ABAP Dump Analysis, you can look at and manage termination messages, and y
2011-04-10 12:35:00 20229 2
转载 sap去除后缀0方法
<br />sap去除后缀0方法 <br /> <br />文章摘要:SHIFT str LEFT DELETING LEADING '0'.如果要在layout显示不出前面的0 格式: &字段(zc)&如果要在layout显示不出小数点后面的0 格式: &字段(.0)& 去,号REPORT z_m.DATA curr TYPE c.curr='123,456,789.00 '.while sy-subrc=0.replace ',' with '' into curr.endwhile.condense
2011-03-27 15:55:00 2801
转载 FOR ALL ENTRIES vs DB2 JOIN
<br />http://it.toolbox.com/blogs/sap-on-db2/for-all-entries-vs-db2-join-8912<br /> <br /> 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
2011-03-27 15:49:00 1529
原创 Modifying a set of lines directly
<br /><br />Modifying all lines completely <br />* Entries: 100 (outer table), 20 (inner table)<br />* The entries to be modified: 50<br />* Actually, only the component FLAG is updated.<br />* However, the complete lines are moved.<br />LOOP AT ITAB INTO
2011-03-27 15:38:00 859
原创 Typed vs untyped Parameters
<br />Untyped parameters <br />Runtime: 5 microseconds <br />PERFORM UP1 USING 10 M6-DIMID M6-ZAEHL M6-ISOCODE M6-ANDEC M6-PRIMARY.<br />FORM UP1 USING<br /> REPEAT<br /> DIMID<br /> ZAEHL<br /> ISOCO
2011-03-27 15:36:00 1080
原创 fixed and unfixed length strings
<br />Character fields (fixed length) <br />Runtime: 1 microseconds <br />*data c1(200) type c.<br />*data c2(200) type c.<br />*data c3(400) type c.<br />c1 = 'mysap'.<br />c2 = '.com'.<br />concatenate c1 c2 into c3.<br /><br />String (unfixed length) <b
2011-03-27 15:35:00 783
原创 Case vs Perform i Of
<br />* (I = 5 in this test)<br /> CASE I.<br /> WHEN 1. PERFORM PV1.<br /> WHEN 2. PERFORM PV2.<br /> WHEN 3. PERFORM PV3.<br /> WHEN 4. PERFORM PV4.<br /> WHEN 5. PERFORM PV5.<br /> WHEN 6. PERFORM PV6.<br /> WHEN 7. PERFORM PV7.<br /> WHEN 8. P
2011-03-27 15:29:00 693
原创 Filling nested internal tables
<br />Bottom-up strategy <br />Runtime: 131 microseconds <br />* Entries: 50 (outer table), 10 (inner tables)<br />* Line width: 500 (outer), 4 (inner)<br />DO 50 TIMES.<br /> CLEAR WA.<br /> DO 10 TIMES.<br /> APPEND N TO WA-INTTAB.<br /> ADD 1 TO
2011-03-27 15:28:00 747
原创 Single Read Sorted vs hashed tables
<br />READ on a unique sorted table <br />* Entries: 1000<br />* Line width: 100, key width: 20<br />* STAB is a unique sorted table, 250 entries are read<br />DO 250 TIMES.<br /> N = 4 * SY-INDEX.<br /> READ TABLE STAB INTO WA WITH TABLE KEY K = N.<br /
2011-03-27 15:22:00 842
原创 Building unique standard hashed tables
<br /><br />One-step approach <br />* Entries: 1000, Duplicates: 250<br />* Line width: 100, Key width: 20<br />* ITAB2 takes 750 entries with unique key K<br />REFRESH ITAB2.<br />LOOP AT ITAB1 INTO WA.<br /> READ TABLE ITAB2 WITH KEY K = WA-K<br />
2011-03-27 15:20:00 630
原创 Part Seq access Hashed vs sorted
<br />Partial sequential access on a sorted table <br />* Entries: 10000, Line width: 100<br />* key width: 60, Subkey width: 20<br />* HTAB is a hashed table, 2000 entries are read<br />* Key fields: K, DATA<br />LOOP AT HTAB INTO WA WHERE K = SUBKEY.<br
2011-03-27 15:18:00 678
原创 Building unique sorted hashed tables.
<br />INSERT in a sorted table with unique key <br /><br />* Entries: 1000, Duplicates: 250<br />* Line width: 100, Key width: 20<br />* ITAB2 takes 750 entries with unique key K<br />REFRESH ITAB2.<br />LOOP AT ITAB1 INTO WA.<br /> INSERT WA INTO TABLE I
2011-03-27 15:17:00 832
原创 Joining internal tables.
<br />Naive join: loop ITAB1, read ITAB2 w/key <br />Runtime: 732 microseconds <br />* Entries: 1000 (ITAB1), 300 (ITAB2)<br />* Line width: 100<br />* Both tables sorted by unique key K ascending<br />LOOP AT ITAB1 INTO WA1.<br /> READ TABLE ITAB2 INTO W
2011-03-27 15:15:00 566
原创 Nested loops
<br />Straightforward nested loop <br />Runtime: 8,987 microseconds <br /><br />* Entries: 100 (ITAB1), 1000 (ITAB2)<br />* Line width: 100<br />* Both tables sorted by key K<br />LOOP AT ITAB1 INTO WA1.<br /> LOOP AT ITAB2 INTO WA2<br /> W
2011-03-27 15:13:00 688
原创 Intersection of internal tables
<br />Using a sorted table temporarily <br />Runtime: 101 microseconds <br /><br />* Entries: 200 (ITAB1), 100 (ITAB2)<br />* Intersection: 50 (ITAB3)<br />* Line width: 100, Key width: 20<br />STAB1 = ITAB1.<br />REFRESH ITAB3.<br />LOOP AT ITAB2 ASSIGNIN
2011-03-27 15:12:00 1013
原创 Secondary indices
<br />No secondary index => linear search <br /> <br />* Entries: 1000, Line width: 100<br />* Key width: 20<br />* The READ locates the 500th entry.<br />READ TABLE ITAB INTO WA<br /> WITH KEY DATE = SY-DATUM.<br />IF SY-SUBRC = 0.<br
2011-03-27 14:57:00 774
原创 Supply Demand vs select
<br />SELECT:<br /> <br />SELECT * FROM SBOOK INTO SBOOK_WA UP TO 10 ROWS.<br /> SELECT SINGLE AIRPFROM AIRPTO INTO (AP1, AP2)<br /> FROM SPFLI<br /> WHERE CARRID = SBOOK_WA-CARRID<br /> AND CONNID = SBOOK_WA-CONNID.<br /> SELE
2011-03-27 14:54:00 809
原创 Using A Subquery
Using two selects :SELECT * FROM SPFLI INTO TABLE T_SPFLI WHERE CITYFROM = 'FRANKFURT' AND CITYTO = 'NEW YORK'.SELECT * FROM SFLIGHT AS F INTO SFLIGHT_WA FOR ALL ENTRIES IN T_SPFLI WHERE SEATSOCC AND CARRID = T_SPFLI-CARRID AND CON
2011-03-27 14:50:00 711
原创 FOR ALL ENTRIES WHERE
<br /> FOR ALL ENTRIES WHERE Syntax <br />... FOR ALL ENTRIES IN itab WHERE ... col operator itab-comp ...Effect <br />If the addition FOR ALL ENTRIES is specified before the language element WHERE, then the components comp of the internal table itab can b
2010-12-23 12:04:00 806
原创 ABAP实现ALV表头动态输出--日期
<br /> data: begin of it_date occurs 0,<br /> lv_date like vbak-vdatu,<br /> end of it_date.<br />data: begin of it_month occurs 0,<br /> month(8) type c,<br /> end of it_month. <br /> <br />获取每个SO的所有交货日期(yyyymm)<br /> <br /> select j_3arqda<br />
2010-11-27 11:45:00 2497
原创 ABAP 中的null 与 space / ''
1、 select sum( vv801 ) into lv_vv801 from ce11000 where kaufn = '' and vrgar = 'A' and paledger = '02' and plikz = '0'.结果有值,说明数据库表中存在kaufn 为 space 或者''的情况,但我却不知道怎么在ce11000表中查找kaufn 为space的记录 select sum( vv801 ) in
2010-11-26 21:42:00 6156
原创 财务报表性能分析--实例
1. select distinct kaufn as vbeln bukrs into corresponding fields of table it_so1 from ce11000 where kaufn in s_vbeln and perio in s_perid and vrgar in ('A','B','F') and paledger = '02' and plikz = '0' and
2010-11-26 21:10:00 1410
原创 实现树形下拉列表 GridView数据绑定
<br />using System;<br />using System.Data;<br />using System.Configuration;<br />using System.Collections;<br />using System.Web;<br />using System.Web.Security;<br />using System.Web.UI;<br />using System.Web.UI.WebControls;<br />using System.Web.UI.WebC
2010-06-03 20:51:00 1873
原创 DataTable.DataSet 属性
获取此表所属的 DataSet。 命名空间: System.Data程序集: System.Data(在 System.Data.dll 中)属性值类型:System.Data.DataSet此表所属的 DataSet。 备注如果控件的数据与 DataTable 绑定且该表属于 DataSet,则可通过该属性获取 DataS
2010-05-29 09:55:00 617
转载 SQL语句优化
SQL语句优化 我们要做到不但会写SQL,还要做到写出性能优良的SQL,以下为笔者学习、摘录、并汇总部分资料与大家分享!(1)选择最有效率的表名顺序(只在基于规则的优化器中有效):orACLE的解析器按照从右到左的顺序处理FROM子句中的表名,FROM子句中写在最后的表(基础表 driving table)将被最先处理,在FROM子句中包含多个表的情况下,你必须选择记录条数最少的表作为基础
2010-04-07 16:20:00 539
转载 影响SQL server性能的关键三个方面
影响SQL server性能的关键三个方面(转贴) 关键词:Sql Server 转贴自:http://202.200.129.193/ 1 逻辑数据库和表的设计 数据库的逻辑设计、包括表与表之间的关系是优化关系型数据库性能的核心。一个好的逻辑数据库设计可以为 优化数据库和应用程序打下良好的基础。 标准化的数据库逻辑设计包括用多的、有相互关系的窄表来代替很多列的长数据表。下面是一些使用标准化 表的
2010-04-07 16:16:00 594
转载 sql优化
SQL语句: 是对数据库(数据)进行操作的惟一途径; 消耗了70%~90%的数据库资源;独立于程序设计逻辑,相对于对程序源代码的优化,对SQL语句的优化在时间成本和风险上的代价都很低; 可以有不同的写法;易学,难精通。 SQL优化: 固定的SQL书写习惯,相同的查询尽量保持相同,存储过程的效率较高。 应该编写与其格式一致的语句,包括字母的大小写、标点符号、换行的位置等都要一致 ORACLE优化器:
2010-04-07 16:11:00 519
转载 优化数据库的思想及sql语句优化的原则
优化数据库的思想:================1、关键字段建立索引。2、使用存储过程,它使SQL变得更加灵活和高效。3、备份数据库和清除垃圾数据。4、SQL语句语法的优化。(可以用Sybase的SQL Expert,可惜我没找到unexpired的序列号)5、清理删除日志。SQL语句优化的原则: ==================1、使用索引来更快地遍历表。缺省情况下建立的索引是非群集索
2010-04-07 16:01:00 624
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人