There is only no documentation for this object available. Sorry.

Sie könnten aber im wiki hilfreiche Informationen finden.

wiki
Date Views Headline Answers
23.01.2013 62 can't join tables using Calculated Attributes 3
23.01.2013 46 calculated attribute to combine BELNR (char -10) and GJAHR(numc-4) 2
04.01.2013 75 Documents posted in Table CKMLAVRDOC 3
11.12.2012 98 Porblem in 0FI_GL_4 Datasource field AWREF (ref. document Nmbr) 4
07.12.2012 322 pass internal table  in standard report select-option 16
26.11.2012 342 FBL1N Report 14
23.11.2012 429 Program goes in Infinite loop 16
21.11.2012 115 system generation for accounting entries wrt good receipt 6
14.11.2012 353 SAP Report that displays both Vendor Invoice and PO info 3
07.11.2012 111 secondary index for ztable 3
06.11.2012 103 function modul for read follow-on Documents in TA MIR4 4
19.10.2012 55 Enhancement problem 3
17.10.2012 113 Regarding Customer Invoice payment 6
15.10.2012 159 Enhancement Issue 20
05.10.2012 68 DS is not filling 5
21.09.2012 157 ABAP ZRF03 Report for offset accounting 5
07.09.2012 578 Link between MIGO & MIRO 21
24.08.2012 337 time out while fetching data from bkpf 15
08.08.2012 74 invoice creation with reference 5
06.08.2012 76 can anyone  tell me  what is the  fieldnames for  goods  issue and invoice 3
26.07.2012 284 Generic Delta with two fields 11
25.07.2012 72 Table or Function Module for Relation Invoice in MM and FI 2
24.07.2012 588 Link between RBKP and BSEG 13
19.07.2012 61 Payment transaction details along with PO details 5
19.07.2012 179 Identifcation link between Physical Inv. Doc., Material doc. & Accounting doc. 4
18.07.2012 52 How to link the shipement cost items leg(SD) with BSEG table(FI). 1
18.07.2012 47 the table for material documents and linked accounting documents 4
25.06.2012 997 0FIGL_O14 DSO field map to 0FI_GL_14 DataSource 12
11.06.2012 186 pr to vendor payment report 7
08.06.2012 1567 Table - material document with accounting document 5
02.03.2012 70 I need the field for Goods receipt / Invoice recei 3
01.03.2012 83 Concatenation Statement throwing shot  dump. 4
22.02.2012 162 How to get the payment usage data available in FB0 6
16.02.2012 104 PO numbeer relevant to Cheque / clearing document 4
13.02.2012 137 Error in BKPF-AWKEY from asset accounting 3
03.02.2012 64 link MSEG table to general ledger 3
01.02.2012 117 Tax Code and Description 8
23.01.2012 134 Mapping Issue 10
17.01.2012 108 RE: Asset History sheet 3
06.01.2012 285 using parameters in filter in a CE_PROJECTION 9
21.12.2011 270 MM Invoice and relevant FI document number details 9
16.12.2011 295 How to get the Equity Share (%) based on a BSEG re 4
09.12.2011 204 BELNR FROM BKPF Based on RSEG. 2
08.12.2011 109 BAPI for F-53 1
07.12.2011 111 BAPI for F-53 2
08.12.2011 277 BAPI for F-53 5
07.12.2011 112 BAPI for F-53 2
06.12.2011 93 BAPI for F-53 1
06.12.2011 218 Table that link Contract and FI doc 5
06.12.2011 225 Purchasing Doc. No in Vendor Line item 8
01.12.2011 148 Purcahsing organisation in FBL3N Report 6
02.11.2011 109 link up  Payment block in BSEG table to its r 2
29.10.2011 369 Billing Document and Material Document Relation 6
25.10.2011 120 BSEG-BELNR based on VBRK-VBELN 5
24.10.2011 331 Enhancing Invoice Verification(MR) Communication A 9
19.10.2011 138 BSEG-BELNR based on VBRK-VBELN 14
17.10.2011 129 Relationship between FI docs and incoming invoice 8
14.10.2011 88 To link the MIRO doc no/reference in payment FI do 5
03.10.2011 1739 Is it worth creating secondary index on BKPF table 25
01.10.2011 117 fbl1n txn for updating vendor line item 3
27.09.2011 120 Link between table VBKPF and RSEG. 6
22.09.2011 75 What are the information capture purchasing docume 4
21.09.2011 261 HA ABAP System copy Target Installation - ABAP Imp 12
16.09.2011 317 Enhancement for updating FI doc in MIGO 4
15.09.2011 223 PO to Payment Report 8
13.09.2011 195 FBL1N: User wants invoice no to be displayed in as 11
02.09.2011 101 Determining FI document of an MM Invoice Posting 3
26.08.2011 106 Z Sort key not working 2
23.08.2011 567 Performance issues with BKPF and BSET. 12
09.08.2011 372 BKPF and BSEG table performance problem. 4
03.08.2011 93 COEP/COBK to BKPF/BSEG -- method and reference fie 1
26.07.2011 520 join between VBRK and BSID to get  all cust o 12
25.07.2011 142 Validation to check cash journal number and cost c 2
25.07.2011 460 Performance issue in BI due to direct query on BKP 5
12.07.2011 198 link between fi doc created against Migo and fi do 7
27.06.2011 236 Need to Know table and field name for a invoice do 8
04.07.2011 237 Inputs or tables required for customizing purchase 8
16.06.2011 99 AP adjustment issue 2
09.06.2011 490 BSEG to VBAK 5
08.06.2011 488 Assignment Field is blank in the Accounting Docume 7
06.06.2011 430 fi documents 11
06.06.2011 386 Populating Assignment Field with PO number 13
28.05.2011 383 Purchase Tax Value 9
26.04.2011 421 Alternate table for BKPF 5
25.04.2011 1024 how to get relationship between material document 6
20.04.2011 945 Get FI Documet number from BKPF table using CO doc 2
15.04.2011 462 PO detail report 7
06.04.2011 447 Accounting document and controlling documents 4
31.03.2011 1246 Purchase Order report with MIRO invoice and/or FI 10
29.03.2011 204 Assign value to Account doc reference field 2
16.03.2011 487 cash document number in document posted in FI 5
14.03.2011 1350 Table to read VAT, CST amount at item level form M 11
11.03.2011 1144 MIRO posting issue 8
11.03.2011 248 AWKEY changed after upgrade 2
10.03.2011 724 BSEG Line item Value 3
09.03.2011 679 How to get recurring revenue doc details from SAP 4
09.03.2011 722 How to use same Data Type and Length for two field 10
22.02.2011 277 BAPI_ACC_PYMNTBLK_UPDATE_CHECK Bapi 1
21.02.2011 493 Change of General Ledger Account in MIRO transacti 2
21.02.2011 227 Clearig rules for Customer and Vendor accounts 2

» See all 594 related threads

07

Nov 2012

secondary index for ztable

19:42


Venkata B

Hi all,

In my ZF001_BASE table, I have the fields MANDT VBELN FKART VKORG VKBUR SPART KUNRG FKDAT MATNR WERKS FKIMG VRKME NETWR WAERK and so on...

I have created secondary INDEX ID1 for WERKS and declared it in my select statement as below

SELECT  VBELN

                KUNRG

                FKDAT

                WERKS

                BSTKD

                ZLRNO

                ZLRDATE

                ZLOG_CODE

                ZLOG_NAME

                ZGRNO_CUST

                ZGRNO_DT

                ZSTATUS

                  FROM  ZF001_BASE

                      INTO  TABLE IT_BASE

                              FOR ALL ENTRIES IN IT_BSID

                              WHERE VBELN EQ IT_BSID-AWKEY

           %_HINTS ORACLE 'INDEX("ZF001_BASE" "ZF001_BASE~ID1")'.

For how many fields I have to create secondary INDEX or do I need to create secondary INDEX for the fields that are defined after SELECT keyword?

I am new to this concept. Please help me.

Thanks,

Venkata.

 

07

Nov 2012

Re: secondary index for ztable

22:03


Swanand Lakka

Hello,

Usually 4 to 5 fields are more than enough to create your secondary INDEX It is also recommended to use those many fields. But there is a limitation to have at the most 9 secondary indices if you are thinking of creating further secondary indices.

Also read this -

http://help.sap.com/saphelp_45b/helpdata/en/aa/47349d0f1c11d295380000e8353423/content.htm

best regards,

swanand

Message was edited by: Thomas Zloch

08

Nov 2012

Re: secondary index for ztable

09:42


Yuri Ziryukin

Well, I am not aware of the 9 indexes limitation. I don't think it exists.

However common sense should be applied when creating database indexes.

There is no general advice of having 4-5 fields in the INDEX this statement is misleading.

Before asking such general questions you should read in Internet (google, wikipedia) about the database indexes - what are they, why do we need them, how do they work.