博客首页
注册
建议与交流
排行榜
加入友情链接
推荐
投诉
搜索:
帮助
老白的ABAP博客
abaper.cublog.cn
管理博客
发表文章
留言
收藏夹
· ABAPer
博客圈
音乐
相册
· Photo
导入文章
文章
· SAP ABAP
· 其他
· 搞笑
首页
关于作者
姓名: 白天振(Barry.bai) 职业: ABAPer SAP Certified Development Consultant
||
<<
>>
||
我的分类
文章列表 - SAP ABAP
【置顶】文章索引
<DIV> <DIV id=art style="MARGIN: 15px" width="100%"> <DIV><A href="http://blog.chinaunix.net/u1/40527/showart.php?id=314397" target=_blank><FONT face=Arial color=#0099cc size=2>动态内表,动态SQL,取表结构信息</FONT></A></DIV> <DIV> <DIV align=left><A href="http://blog.chinaunix.net/u1/40527/showart.php?id=314475" target=_blank><FONT face=Arial color=#0099cc size=2>UP_DOWN_REQUEST</FONT></A></DIV> <DIV align=left><A href="http://blog.chinaunix.net/u1/40527/showart.php?id=314481" target=_blank><FONT face=Arial color=#0099cc size=2>金额大写转换</FONT></A></DIV> <DIV align=left><A href="http://blog.chinaunix.net/u1/40527/showart.php?id=314494" target=_blank><FONT face=Arial color=#0099cc size=2>SEARCH_ABAP_STRING</FONT></A></DIV> <DIV align=left><A href="http://blog.chinaunix.net/u1/40527/showart.php?id=315155" target=_blank><FONT face=Arial color=#0099cc size=2>自动刷新LIST(ALV不适用)</FONT></A></DIV> <DIV align=left><A href="http://blog.chinaunix.net/u1/40527/showart.php?id=31515……
查看全文
发表于:2008-07-03 ┆
阅读(854)
┆
评论(0)
【置顶】搜索
<FORM action=http://www.google.com/search method=get> <P> </P> <P><FONT face=幼圆 size=4>站内搜索:</FONT></P> <TABLE> <TBODY> <TR> <TD> <A href="http://www.google.com/"></A></TD> <TD><INPUT style="WIDTH: 299px; HEIGHT: 21px" maxLength=255 size=48 name=q> <INPUT style="WIDTH: 105px; HEIGHT: 23px" type=submit value="Google 搜索" name=btnG> <FONT size=2><BR><INPUT type=radio value="" name=sitesearch> 搜索WWW <INPUT type=radio CHECKED value=http://blog.chinaunix.net/u1/40527 name=sitesearch> 搜索老白的Blog</FONT></TD></TR></TBODY></TABLE></FORM> <DIV></DIV> <DIV></DIV> <FORM action=http://www.baidu.com/baidu> <TABLE> <TBODY> <TR> <TD><A href="http://www.biadu.com/"></A></TD> <TD> <INPUT style="WIDTH: 299px; HEIGHT: 21px" name=word> <INPUT style="WIDTH: 105px; HEIGHT: 23px" type=submit value="Baidu 搜索"> <INPUT type=hidden value=bds name=tn> <INPUT type=hidden value=3 name=cl> <INPUT type=hidden value=2097152 name=ct><FONT size=2><BR> <INPUT type=radio value="" name=si> 搜索WWW <INPUT type=radio CHECKED value=blog.chinaunix.net/u1/40527 name=si> 搜索老白的Blog </FONT></TD></TR></TBODY></TABLE></FORM> <DIV></DIV> <DIV></DIV> <DIV></DIV> <DIV></DIV> <DIV></DIV> <DIV></DIV> <DIV></DIV>
查看全文
发表于:2008-02-20 ┆
阅读(767)
┆
评论(5)
P类型的字段小数位为0时以整数显示
<DIV> <DIV align=center> </DIV> <TABLE style="COLOR: #02368d; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=700 align=center border=0> <TBODY> <TR height=25> <TD width=120>网友:<B> <A title=查看城市火柴的BLOG href="http://blog.chinaunix.net/jump/byuser.php?username=城市火柴" target=_blank><FONT color=#0000ff>城市火柴</FONT></A> </B></TD> <TD style="COLOR: #aaaaaa" align=right width=555></TD></TR> <TR> <TD bgColor=#d2dee2 colSpan=3 height=1></TD></TR> <TR> <TD bgColor=#ffffff colSpan=3 height=1></TD></TR> <TR> <TD colSpan=3> <TABLE style="BORDER-COLLAPSE: collapse; WORD-WRAP: break-word" borderColor=#111111 cellSpacing=0 cellPadding=0 width=700 border=0> <TBODY> <TR> <TD vAlign=top width=20></TD> <TD width=580><PRE style="MARGIN: 0px; LINE-HEIGHT: 150%" wrap="break-word">在表控件中如何将一个P类型的字段小数位为0时以整数显示,效果就如CO02中组件概览中的需求量那栏,请老白指点一下,谢谢。想要的结果就象任何一个标准事务中那样,如MB1B,MB1A,VA01,CO01等事务……
查看全文
发表于:2008-09-26 ┆
阅读(66)
┆
评论(0)
ALV GRID 使用过滤器(FILTER)的方法
<DIV>DATA: gt_filt TYPE lvc_t_filt,<BR> gs_filt TYPE lvc_s_filt.<BR></DIV> <DIV> gs_filt-fieldname = 'MBLNR'.<BR> gs_filt-low = '4900000000'.<BR> gs_filt-high = '5000000000'.<BR> gs_filt-sign = 'I'.<BR> gs_filt-option = 'BT'.<BR> APPEND gs_filt TO gt_filt .<BR></DIV> <DIV> CALL METHOD go_grid->set_table_for_first_display<BR> EXPORTING<BR> is_variant = gs_variant<BR> i_save = 'A'<BR> is_layout ……
查看全文
发表于:2008-09-20 ┆
阅读(103)
┆
评论(0)
SAP用户的地址数据
<DIV>视图:USER_ADDR</DIV>
查看全文
发表于:2008-09-19 ┆
阅读(96)
┆
评论(0)
利用ALVTree显示BOM结构
<DIV> <DIV align=center><IMG src="http://blogimg.chinaunix.net/blog/upfile2/080919085714.jpg" onload="javascript:if(this.width>500)this.width=500;" border=0></DIV></DIV> <DIV> </DIV> <DIV>REPORT z_barry_alv_tree1_bom MESSAGE-ID oo.</DIV> <DIV>TABLES: stpox.<BR>INCLUDE <icon>.</DIV> <DIV>CLASS: cl_gui_column_tree DEFINITION LOAD,<BR> cl_gui_cfw DEFINITION LOAD .</DIV> <DIV>DATA: tree1 TYPE REF TO cl_gui_alv_tree ,<BR> mr_toolbar TYPE REF TO cl_gui_toolbar .</DIV> <DIV>DATA: gs_stpox TYPE stpox,<BR> gt_stpox TYPE stpox OCCURS 0,<BR> gt_fieldcatalog TYPE lvc_t_fcat,<BR> gt_item_layout TYPE lvc_t_laci,<BR> gs_item_layout TYPE lvc_s_laci,<BR> okcode……
查看全文
发表于:2008-09-19 ┆
阅读(155)
┆
评论(2)
Excel、C#等通过RFC连接SAP取数中文乱码
<DIV>两个解决方法:</DIV> <DIV>1、添加环境变量:SAP_CODEPAGE,如果是ECC6,一般为8400</DIV> <DIV>2、在VBA或者C#的程序里面添加:oConnection.codepage = "8400"</DIV> <DIV> </DIV> <DIV></DIV>
查看全文
发表于:2008-09-18 ┆
阅读(96)
┆
评论(2)
Local Update
<H2 style="tab-stops: list .25in"><SPAN style="mso-ansi-language: EN-US">Local Update</SPAN></H2> <P class=MsoNormal><SPAN style="mso-ansi-language: EN-US">In a local update, the update program is run by the same work process that processed the request.</SPAN> <SPAN style="mso-ansi-language: EN-US">The dialog user has to wait for the update to finish before entering further data.</SPAN> <SPAN style="mso-ansi-language: EN-US">This kind of update is useful when you want to reduce the amount of access to the database.</SPAN> <SPAN style="mso-ansi-language: EN-US">The disadvantage of local updates is their parallel nature.</SPAN> <SPAN style="mso-ansi-language: EN-US">The updates can be processed by many different work processes, unlike asynchronous or synchronous update, where the update is serialized due to the fact that there are fewer update work processes (and maybe only one).</SPAN></P> <P class=MsoNormal><SPAN style="mso-ansi-language: EN-US">You switch to local update using the A……
查看全文
发表于:2008-09-10 ┆
阅读(106)
┆
评论(0)
SD相关表
<P>SD相关表 </P> <P>一、客户主数据<BR>基本数据放在KNA1里;<BR>公司代码放在KNB1里;<BR>销售视图放在KNVV里;<BR>合作伙伴放在KNVP里;<BR></P> <P>二、信用主数据<BR>KNKK里有信贷限额、应收总额、特别往来;<BR>S066里是未清订单值;<BR>S067里是未清交货值;<BR>KNKK里面的应收值不一定对,要和BSID表去比。S066、S067也是一样,不对的时候就要重组。<BR></P> <P>三、物料主数据<BR>MARA里是基本数据;<BR>MAKT是文本;<BR>MARC是工厂视图;<BR>MVKE是销售视图;<BR>MARM是物料的计量单位;<BR></P> <P>四、价格数据<BR>主数据在表AXXX里,XXX表示三个数字,KNOH和KONP分别存放抬头和行项;<BR>单据的价格在KONV里;<BR></P> <P>五、自动确定的科目<BR>在CXXX里,XXX表示三个数字;<BR></P> <P>六、销售订单<BR>VBAK抬头;<BR>VBAP行项;<BR>VBKD业务数据;<BR>VBPA是伙伴;<BR>VBEP是计划行;<BR>VBFA是单据流;<BR>VBUK抬头状态;<BR>VBUP行项状态;<BR></P> <P>七、交货<BR>LIKP抬头;<BR>LIPS行项;<BR>VTTK是Shipment抬头;<BR>VTTP是Shipment行项;<BR></P> <P>八、物料凭证<BR>MKPF抬头;<BR>MSEG行项;<BR></P> <P>九、发票<BR>VBRK是抬头;<BR>VBRP是……
查看全文
发表于:2008-09-05 ┆
阅读(156)
┆
评论(2)
在FM的Importing中传递SELECT-OPTIONS(Range)
<DIV>REPORT z_barry_test.</DIV> <DIV> </DIV> <DIV>TABLES makt.</DIV> <DIV> </DIV> <DIV>DATA: itab TYPE makt OCCURS 0 WITH HEADER LINE.</DIV> <DIV> </DIV> <DIV>SELECT-OPTIONS: s_matnr FOR makt-matnr.</DIV> <DIV> </DIV> <DIV>CALL FUNCTION 'Z_TEST'<BR> EXPORTING<BR> s_matnr = s_matnr[]<BR> TABLES<BR> it_makt = itab.</DIV> <DIV> </DIV> <DIV>**********************</DIV> <DIV> </DIV> <DIV>FUNCTION z_test.<BR>*"----------------------------------------------------------------------<BR>*"*"Local interface:<BR>*" IMPORTING<BR>*" VALUE(S_MATNR) TYPE ZZTTMATNR OPTIONAL<BR>*" TABLES<BR>*" IT_MAKT TYPE MAKT_UPL_TT OPTIONAL<BR>*"----------------------------------------------------------------------</DIV> <DIV> </DIV> <DIV> SELECT * INTO TABLE it_makt FROM makt WHERE matnr IN s_matnr.</DIV> <DIV> </DIV> <DIV>EN……
查看全文
发表于:2008-09-04 ┆
阅读(140)
┆
评论(0)
PDF417条码简介[转]
<DIV> <TABLE id=AutoNumber2 style="BORDER-COLLAPSE: collapse" borderColor=#111111 cellSpacing=1 cellPadding=0 width="98%" align=center border=0> <TBODY> <TR> <TD width="100%" height=1> <P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 5px; LINE-HEIGHT: 150%" align=center><FONT face=宋体 size=4><B>PDF417二维条码/二维码</B></FONT><B><FONT size=2> </FONT></B><FONT size=2> </FONT></P> <P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 5px; LINE-HEIGHT: 150%"><FONT size=2>PDF417是美国符号科技(Symbol Technologies, Inc.)发明的二维<A href="http://www.systron.com.cn/"><FONT color=#0000ff>条码</FONT></A>,发明人是台湾赴美学人王寅君博士,王博士於1984年毕业於国立交通大学资讯系,获得纽约州立大学石溪分校(University of New York at Stony Brook)电脑硕士和博士学位後,在1988年进入符号科技进行二维<A href="http://www.systron.com.cn/"><FONT color=#0000ff>条码</FONT></A>的研发工作,於1992年底推出PDF417,并於1989年至1992年间领导世界第一部二维<A href="http://www.systron.com.cn/"><FONT color=#0000ff>条码……
查看全文
发表于:2008-09-04 ┆
阅读(139)
┆
评论(2)
几个Smartforms的问题
<DIV align=left>1、使用SFSY-FORMPAGES显示总页数的时候,如果页数大于9,将会在前10页显示成星号*</DIV> <DIV> </DIV> <DIV>解决:</DIV> <DIV> </DIV> <P align=left><IMG src="http://blogimg.chinaunix.net/blog/upfile2/080903154305.jpg" onload="javascript:if(this.width>500)this.width=500;" border=0></P> <DIV align=left> </DIV> <DIV align=left>2、金额为零的时候不要输出 0.00 ,置空即可</DIV> <DIV align=left> </DIV> <DIV align=left>解决:</DIV> <DIV align=left> </DIV> <DIV align=left><IMG src="http://blogimg.chinaunix.net/blog/upfile2/080903154421.jpg" onload="javascript:if(this.width>500)this.width=500;" border=0></DIV> <DIV align=center> </DIV> <DIV align=left> </DIV> <DIV align=left> </DIV> <DIV align=left>3、金额或者数量字段显示不出来</DIV> <DIV align=left> </DIV> <DIV align=left>解决:</DIV> <DIV align=left> </DIV> <DIV align=left><IMG src="http://blogimg.chinaunix.net/blog/upfile2/080903154741.jpg" onload="javascript:if(this.w……
查看全文
发表于:2008-09-03 ┆
阅读(215)
┆
评论(2)
ABAP+OCX实现指示灯/LED效果
<DIV> <DIV align=center> <DIV align=center> <DIV align=center> </DIV> <OBJECT id=Shockwaveflash1 codeBase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0 height=293 width=366 classid=clsid:D27CDB6E-AE6D-11cf-96B8-444553540000 VIEWASTEXT><PARAM NAME="_cx" VALUE="9684"><PARAM NAME="_cy" VALUE="7752"><PARAM NAME="FlashVars" VALUE=""><PARAM NAME="Movie" VALUE="http://blogimg.chinaunix.net/blog/upfile2/080902095325.swf"><PARAM NAME="Src" VALUE="http://blogimg.chinaunix.net/blog/upfile2/080902095325.swf"><PARAM NAME="WMode" VALUE="Window"><PARAM NAME="Play" VALUE="0"><PARAM NAME="Loop" VALUE="-1"><PARAM NAME="Quality" VALUE="High"><PARAM NAME="SAlign" VALUE=""><PARAM NAME="Menu" VALUE="-1"><PARAM NAME="Base" VALUE=""><PARAM NAME="AllowScriptAccess" VALUE=""><PARAM NAME="Scale" VALUE="ShowAll"><PARAM NAME="DeviceFont" VALUE="0"><PARAM NAME="EmbedMovie" VALUE="0"><PARAM NAME="BGColor" VALUE=""><PARAM NAME="SWRemote" VALUE=""><PARAM NAME="MovieData" ……
查看全文
发表于:2008-09-01 ┆
阅读(298)
┆
评论(5)
FI中替代和校验的几个相关函数
<DIV>替代(Substitution):</DIV> <DIV>FI_SUBSTITUTION_HEADER</DIV> <DIV>FI_SUBSTITUTION_ITEM</DIV> <DIV>FI_SUBSTITUTION_DOC</DIV> <DIV>FI_SUBSTITUTION_ACTIVE</DIV> <DIV>。。。。</DIV> <DIV> </DIV> <DIV>校验(Validation):</DIV> <DIV>FI_VALIDATION_HEADER<BR>FI_VALIDATION_ITEM</DIV> <DIV>FI_VALIDATION_DOC</DIV> <DIV> </DIV> <DIV> <DIV> </DIV> <DIV>更多见函数组:FACS</DIV></DIV>
查看全文
发表于:2008-09-01 ┆
阅读(143)
┆
评论(0)
读取假脱机(SPOOL)的例程[ECC6]
<DIV>REPORT z_barry_test NO STANDARD PAGE HEADING MESSAGE-ID so LINE-SIZE 255 .</DIV> <DIV> </DIV> <DIV>DATA: objcont TYPE soli OCCURS 0 WITH HEADER LINE.<BR>DATA: owner LIKE soud-usrnam,<BR> rcode(4) .</DIV> <DIV> </DIV> <DIV>START-OF-SELECTION.<BR> owner = sy-uname.</DIV> <DIV> PERFORM read_spool TABLES objcont<BR> USING owner<BR> rcode.<BR> LOOP AT objcont.<BR> WRITE objcont-line.<BR> ENDLOOP.</DIV> <DIV><BR>*&---------------------------------------------------------------------*<BR>*& Form read_spool<BR>*&-------------------------------……
查看全文
发表于:2008-08-25 ┆
阅读(159)
┆
评论(0)
获取SAP App的运行环境变量
<DIV>可以获得TNS_ADMIN、ORACLE_SID、NLS_LANG、DB_SID、dbs_ora_schema、ORACLE_HOME。。等数据库信息以及LANG、SAPJDBHOST、LOGIN、G_BROKEN_FILENAMES、PATH、SAPDBHOST、LOGNAME、MAIL、ODMDIR、JAVA_HOME、SAPSYSTEMNAME等系统环境变量。</DIV> <DIV> </DIV> <DIV>例程:</DIV> <DIV>REPORT z_barry_test NO STANDARD PAGE HEADING .</DIV> <DIV> </DIV> <DIV>DATA: itab LIKE thenv OCCURS 0 WITH HEADER LINE.</DIV> <DIV> </DIV> <DIV>CALL FUNCTION 'TH_ENVIRONMENT'<BR> TABLES<BR> environment = itab.</DIV> <DIV> </DIV> <DIV>LOOP AT itab.<BR> WRITE itab-line .<BR>ENDLOOP.</DIV> <DIV> </DIV> <DIV> </DIV>
查看全文
发表于:2008-08-25 ┆
阅读(143)
┆
评论(1)
在新的Session执行TCODE
<DIV>FM:HLP_MODE_CREATE,如果不用区分是否BATCH_INPUT模式,可以用TH_CREATE_MODE。</DIV> <DIV> </DIV> <DIV>如果需要在另外一个系统打开一个新的窗口,请用TH_REMOTE_TRANSACTION,需要先在SM59维护另一个系统。</DIV> <DIV></DIV>
查看全文
发表于:2008-08-25 ┆
阅读(154)
┆
评论(0)
Message在Dialog的用法
<P>Message 用在Screen或者做增强的时候,和普通的Report有些差别,尽量不要在PBO中使用S以外的Message,尤其是E类型的Message,可能会直接导致程序的退出,而不给你改正数据的机会。如果需要有E类型的Message,可以放到PAI里面。<BR>如ME31K/ME32K的行项目检查增强,EXIT_SAPMM06E_016里面如果有E类型的Message将导致程序的直接退出。正确的方法是放到EXIT_SAPMM06E_017。</P> <P> </P> <P>附:各个类型Message在各个事件的处理方法</P> <P> <TABLE style="WIDTH: 293pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=390 border=0 x:str> <COLGROUP> <COL style="WIDTH: 167pt; mso-width-source: userset; mso-width-alt: 7104" width=222> <COL style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 896" span=6 width=28> <TBODY> <TR style="HEIGHT: 12pt" height=16> <TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 167pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent" width……
查看全文
发表于:2008-08-24 ┆
阅读(200)
┆
评论(0)
关于SAP收藏夹的几个函数
<DIV>函数组:SMTR_NAVIGATION_MODULES_2</DIV> <DIV> </DIV> <DIV>如果是只是添加TCODE到指定用户的收藏夹,可以使用函数:GUI_ADD_TCODE_TO_FAVORITES</DIV> <DIV> </DIV> <DIV>存储收藏夹内容的表:SMEN_BUFFC ,字段SORT_ORDER为收藏夹的顺序</DIV> <DIV>收藏夹最后更改的日期的表:SMENFAVDAT</DIV> <DIV></DIV>
查看全文
发表于:2008-08-23 ┆
阅读(169)
┆
评论(0)
BAPI_ACC_GL_POSTING_REV_POST
Parameters p_belnr like bkpf-belnr <FONT color=navy><B>default</B></FONT> <FONT color=navy>'0100000236'</FONT>. <BR> <BR>*Get last SA type document posted to build document key <BR>CALL FUNCTION <FONT color=navy>'NUMBER_GET_NEXT'</FONT> <BR>EXPORTING <BR>NR_RANGE_NR = <FONT color=navy>'01'</FONT> <BR>OBJECT = <FONT color=navy>'RF_BELEG'</FONT> <BR> <BR>QUANTITY = <FONT color=navy>'1'</FONT> <BR>SUBOBJECT = <FONT color=navy>'4000'</FONT> <FONT color=red>"company code </FONT><BR>TOYEAR = <FONT color=navy>'2005'</FONT> <BR> <BR>IGNORE_BUFFER = <FONT color=navy>'2005'</FONT> <BR>IMPORTING <BR>NUMBER = docnum <BR> <BR>QUANTITY = <BR>RETURNCODE = <BR>EXCEPTIONS <BR>INTERVAL_NOT_FOUND = 1 <BR>NUMBER_RANGE_NOT_INTERN = 2 <BR>OBJECT_NOT_FOUND = 3 <BR>QUANTITY_IS_0 = 4 <BR>QUANTITY_IS_NOT_1 = 5 <BR>INTERVAL_OVERFLOW = 6 <BR>BUFFER_OVERFLOW = 7 <BR>OTHERS = 8 <BR>. <BR>IF SY-SUBRC 0. <BR> <BR>MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO <BR>WITH SY-MSGV1 SY-MSGV2 SY-……
查看全文
发表于:2008-08-20 ┆
阅读(179)
┆
评论(0)