 如何加快按生产订单查找物料凭证的报表的速度 |
在sap的物料凭证中mseg表中有AUFNR字段对应订单主数据的AUFK的aufnr字段，很多程序员会按照该关系去查找数据，由于mseg表中有AUFNR没有建立索引，查询非常慢。其实订单到物料凭证的关系存在aufm表，通过该表查询速度将快100倍以上。aufm其实就类似sd的索引器。大家以后碰到报表慢，解决的方法首先是考虑sap的有没有对应的索引器表，实在没有才去建索引。(11/05/2006 20:09:31,430) [查看全文] |
| SAP 月末结帐步骤 |
The following processes including SD,MM,PP,FI,CO .
SD Relevant Steps:
1.Check if all deliver(11/05/2006 19:56:14,2030) [查看全文] |
| SAP CO知识点 |
· 一个成本控制范围下可包含一个公司代码，也可包含多个公司代码。
(11/05/2006 19:55:30,880) [查看全文] |
| SAP财务知识点 |
· 科目表位于公司代码(11/05/2006 19:54:14,948) [查看全文] |
| SAP的模块划分 和 SAP Accouting的介绍 |
SAP Accouting 分为以下五个模块:
1, Extrenal Accouting(外部会计)， 为外部利益相关方提供各种报表reports，由SAP中的FI(Financial Accounting)模块支持
(11/05/2006 19:34:29,857) [查看全文] |
| FI中的Organizational Structure组织结构 |
1， Chart of accounts（会计报表），一般与Company Code一一对应.
2， Business area: 根据财务的标准，把企业进行按部门或业务的划分为多个business area.
以便于在每个期末出报表时,结算出每个部门或业务(Buiness area)的盈亏状况.
(11/05/2006 19:31:37,694) [查看全文] |
| 财务专业术语表 |
财务专业术语表
(10/26/2006 09:29:12,3447) [查看全文] |
| CO知识点 |
CO(10/26/2006 09:28:31,763) [查看全文] |
| 财务知识点 |
财务知识点
(10/26/2006 09:27:55,451) [查看全文] |
| Process Of Letter of Credit for Imports |
Process Of Letter of Credit for Imports
1. The Clearing agent ask for amount, the person who receive the product will give Letter of Authority to Clearing(10/18/2006 08:51:37,283) [查看全文] |
| Update Trading Partner Field for Posted Documents |
Update Trading Partner Field for Posted Documents
In FBL5N/FBL1N, I have checked the related documents and found that one of the line items is having 'Trad(10/18/2006 08:51:11,182) [查看全文] |
| Recurring Documents and Interest Calculation |
Recurring Documents and Interest Calculation
How to create recurring doucment template? How to run recurring document and what date should normally put to (10/18/2006 08:50:50,150) [查看全文] |
| FI Questions about GR/IR |
FI Questions about GR/IR
1. How do we post the FI transactions after doing MIGO.
(10/18/2006 08:50:04,308) [查看全文] |
| Setting Up Automatic Payment Program |
Setting Up Automatic Payment Program
(10/18/2006 08:45:42,182) [查看全文] |
| Delink Cheque Payment from Payment Document |
Delink Cheque Payment from Payment Document
(10/18/2006 08:44:53,172) [查看全文] |
新闻动态
