The FI-GL table BSEG, which is one of our biggest PR1 tables, is an example of a clustered table. At the database-level, there is no table called BSEG, but instead RFBLG is being used for the BSEG data. Most of the fields known in BSEG are not known in the database table RFBLG, but are compressed in a VARDATA field of RFBLG. So tests in the WHERE clause of SELECTs agains BSEG are not used by the database (e.g. lifnr = vendor account number, hkont = G/L account, kostl = cost center). As a consequence, these tests are done after the facts similar to using the CHECK statement, and as already said in tip 1, CHECK statements are worse than tests in the WHERE-clause.
% S$ ^/ t* C+ v+ Z" ~我的SAP之旅【mysaplcub.cn】我的SAP之旅【mysaplcub.cn】7 X7 A2 U: E" |
Check this link also.SAP讨论 SAP标准教材 SAP资料 SAP下载 IDES ECC5) g, b/ h9 |$ G! s
https://forums.sdn.sap.com/threa ... ageID=373481#373481
2 n6 O0 E+ }( C& \9 l* D8 I1) select with header information from bkpf
. H* A& \6 o  @3 U% O6 Z+ x9 Mmysapclub,SAP爱好者,SAP,标准教材,IDES,ECC62) use secondary index tables
8 V0 P0 H& u6 ~$ s( V, @+ v6 s& bhttp://forums.sdn.sap.com/jive3/ ... ageID=105504#105504mysapclub,SAP爱好者,SAP,标准教材,IDES,ECC61 `0 W8 T  B; w" J
1.BSAK Accounting: Secondary Index for Vendors
- c' W" F! E! ^bbs.mysapclub.cn2.BSAS Accounting: Secondary Index for G/L AccountsSAP讨论 SAP标准教材 SAP资料 SAP下载 IDES ECC5& V7 G) M2 X' [
3.BSIK Accounting: Secondary Index for Vendors
) F8 G; z4 U2 @/ u( S我们的SAP论坛 SAP讨论 SAP标准教材 SAP资料 SAP下载 IDES SAP招聘 SAP求职 ABAP源码库4.BSID Accounting: Secondary Index for Customers
) j2 q! ^% h& g9 nbbs.mysapclub.cn5.BSIM Secondary Index, Documents for Material我们的SAP论坛 SAP讨论 SAP标准教材 SAP资料 SAP下载 IDES SAP招聘 SAP求职 ABAP源码库( `/ ^% }5 k' l: M* m& j' |
6.BSAD Accounting: Secondary index for customersbbs.mysapclub.cn1 n2 \- S7 E  q3 e  }: x2 a
7.BSIS Accounting: Secondary Index for G/L Accountsbbs.mysapclub.cn+ @$ H$ [  y% ^
3) use logical data base e.g.: BRF
posted on 2009-05-31 13:47  levin  阅读(534)  评论(0编辑  收藏  举报