Skip to Content
avatar image
Former Member

When a Secondary Index Table is really created when it is transported

Hi fellows.

I would like to know when really a new secondary index Z01 is created in the ZTable after transporting it.

Is it a background/assynchronus task ? When does it really start ?

best regards.

ABAP Senior Consultant

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 22, 2016 at 05:21 PM

    Hi Glauco,

    Go to SE14, utilities and then activation log.

    It shows the time when the Index was activated. OR DB utility also shows all these details.


    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 23, 2016 at 11:51 AM

    Hello Glauco

    in SE11, the index needs to have (index on all database systems)

    in that case, when you activate it it will request a TR, this TR when you move it it will create the index in the target system during the transport.

    if you dont want the index to be created and only the definition to be syncronized, you need to select "No database index" then it will not be creted when you transport it.

    if you want to move a TR with a big index, a good approach is to create the index with database tools before, because you can parallelize and when you move the transport (with option "Index on all database systems") SAP will see that the index is created in the DB and will not re-create it.

    you can check SAP note 334224 that gives an overview of this approach.

    Add comment
    10|10000 characters needed characters exceeded