Skip to Content

Create missing objects at once (in batch)

Dear Experts,

I've got 2 questions, I apologize that I'm putting them together in one thread, if you badmouth me a lot for

doing it, I will open another thread :-)

1) After SPS implementation on a BW system, ST04 diagnostics shows a lot of missing objects in the DB,

like 20-30 tables and over 100 missing secondary indexes. There is a button next to each of them, which

provides the option to create the object on DB level. But for nearly 200 objects all together - isn't there a

possibility to do them all in some kind of batch mode ? As it's quite cumbersome to click that many times...

2) I have a table missing in the ABAP dictionary (NetWeaver 7.4) - the table is MLICHECK~

While there are a lot of notes about MLICHECK, there is nothing about MLICHECK~ or at least I'm not sure

how to search for it. As table MLICHECK stores the old licenses, for 7.4 this table is no longer required. Does

that mean that I can simply drop both tables (MLICHECK and MLICHECK~) on DB level ?

And I have checked, that there is an entry in DBDIFFVIEW for MLICHECK. If I drop the table on DB level,

won't I get another error, that MLICHECK doesn't exeist on the DB level ?

Please advise on how to proceed. Many thanks in advance!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 13, 2016 at 10:25 PM

    1 - There is an option for Mass Processing in Tx SE14 - DB Requests - Mass Processing. Displaying Requests for Mass Processing - Application Development on AS ABAP - SAP Library. As I have not done this before I cannot provide the exact steps but I believe you need to select all the missing indexes in Tx DBACOCKPIT / DB02 and then go for the option "create in DB" which will then queue up the items for mass processing. You next call Tx SE14 for mass processing and get them executed. I don't have a system to cross check and give you the exact steps but you can poke around in the Tx DBACOCKPIT / DB02 screen options and get it working.

    2 - MLICHECK~ tables appears to be a shadow table. Shadow tables are created during an upgrade/update. The shadow tables have ~ at the end. I wouldn't do anything with the MLICHECK table but I would query the table MLICHECK~ from the database level and see if it is empty before I drop.

    Use this link as a reference: Missing database objects - zavisko.comzavisko.com

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.