Skip to Content
author's profile photo
Former Member

Index

Hi,

I had this mssg and i followed the steps as posted by the experts here.

<b> Be aware of Note number 597909 when setting line item DataSources

Message no. GQPI 063

Diagnosis

You have successfully generated an extraction structure for the FI-SL line item table ZGLT1A.

Before implementing a DataSource that accesses the line items for table ZGLT1A, you need to create an additional, secondary index for this table in the data dictionary. This index can significantly speed up data access.

Procedure

Create a (non-unique) index for table ZGLT1A in the DDIC that includes the following fields:

RCLNT

RLDNR

CPUDT

CPUTM

You can find additional details about this in SAP Note number 597909</b>.

this was done on R/3 and i did replicate this datasource and am trying to use the info source in an ODS i am wondering if i gotta to do anything while creating ODS too under the Indexes tab of the ODS?

is there any link for these two indexes???

Thankyou

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Oct 05, 2005 at 06:12 PM

    No, no...

    ODS index can be built only if you need to speed up specific situation in which you have to do reporting or select statement to retrieve info in some internal coding...

    R/3 table index is instead very useful (and suggested at once by SAP itself) when you will perform the extraction process...

    So, go on with only what you already do !

    Bye,

    Roberto

    Add comment
    10|10000 characters needed characters exceeded