11
Basis 常用T-Code
Basis 常用T-Code[@more@]1 系统监视1.1 进程监视SM66/SM50 进程查看管理员需全天监看系统的进程。长时间运行的后台工作,有缺陷的报表程序,若不进行控制都将消耗掉大量的系统资源。管理员用这个事务码检查他们的环境。当然,在杀掉这些进程前,需要与最终用户协商。1.2 服务器监视SM51 R/3服务器的列表可用SM51显示,管理员用它来监视不同服务器之间的工作进程。想要显示某一服务器的进程,鼠标指针点中服务器的名称,然后选Processes。RZ20 CCMS监控 双击要查看的菜单项,检查系统收集的监控信息,遇到报警和错误信息要查清原因,找出解
SQL的优化[转]
为什么要优化SQL语句:. SQL语句是对数据库进行操作的惟一途径,对数据库系统的性能起着决定性的作用。. SQL语句消耗了70%至90%的数据库资源。. SQL语句独立于程序设计逻辑,对SQL语句进行优化不会影响程序逻辑。. SQL语句有不同的写法,在性能上的差异非常大。. SQL语句易学,但难精通。[@more@] SQL优化: 固定的SQL书写习惯,相同的查询尽量保持相同,存储过程的效率较高。 应该编写与其格式一致的语句,包括字母的大小写、标点符号、换行的位置等都要一致 ORACLE优化器: 在任何可能的时候都会对表达式进行评估,并且把特定的语法结构
[轉]SAP SD定价技术分析
定价技术一直是SAP引以为豪的一个设计。设计也很复杂,闲下空来DEBUG了一下SAP的标准程式。基础的IMG设定(定价表/访问顺序/定价类型/定价过程)就不说了,现将一些SAP的定价逻辑分享给大家,希望能给做定价增强的ABAPer兄弟一些些帮助。[@more@]1) 定价程序FunctionPool: SAPLV61AFunction Name: Pricing2) 变量说明XKOMV 记录系统定价结果(Item Level)TKOMV 记录系统定价结果(Doc. Level)KOMT1 定价过程KOMT2 访问顺序KOMK 定价关键字(表头)KOMP 定价关键字(行)3) 程序处理逻辑A) 整理 KOMK / KOMP 的值 (SAP提供接口做增强,SO/DN/BILLING
[轉]how to introduce yourself in the interview
1. So, tell me a little about yourself. You don’t need to explain everything from birth to present day. Relevant facts about education, your career and your current life situation are fine. [@more@]2. Why are you looking (or why did you leave you last job)? This should be a straightforward question to answer, but it can trip you up. Presumably you are looking for a new job (or any job) because you want to advance your career and get a position that allows you to grow as a person and an employee
VOV7—unlock transaction flow field
In VOV7, if you want to maintain transaction flow section, there are 4 field is locked. How to unlock the fields: Incompletion Procedure, Partner Determination Procedure, Text Determination Procedure, Item Category Status Group?[@more@]In VOV7, if you want to maintain transaction flow section, there are 4 field is locked. How to unlock the fields: Incompletion Procedure, Partner Determination Procedure, Text Determination Procedure, Item Category Status Group?1.Incompletion Procedure: Sales and
when create SO order, Delivery Date has been postponed one day.
Symptom: when user use VA01 to create SO order, she encounter Delivery Date postponing one day(2010-1-7), which the order is create on 2010-1-6. So the Delivery Date should be 2010-1-6. Why it postpone one day? [@more@]Symptom: when user use VA01 to create SO order, she encounter Delivery Date postponing one day(2010-1-7), which the order is create on 2010-1-6. So the Delivery Date should be 2010-1-6. Why it postpone one day? Below picture for reference.Root course: In SAP, there is “Standard C
[轉]Sales Order 中的User Exit开发
在标准SAP业务应用中常会修改标准程序和增加一些自己的功能代码来满足特定化的需求,SAP提供了一些出口对特定的程序、屏幕、MENU以及Docuement进行扩展与修改,他们并不包含任何功能,并被分离存在特定的package里所以他既不会影响标准SAP源代码也不会妨碍升级。除了通过后台配置客户化,我们常用主要有三种用户出口来进行Enhancement和Modification:[@more@]在标准SAP业务应用中常会修改标准程序和增加一些自己的功能代码来满足特定化的需求,SAP提供了一些出口对特定的程序、屏幕、MENU以及Docuement进行扩展与修改,他们并不包含任何功