URGENT help needed - Table exists in database, but not in ABAP dictionary

[symon_braunbaer]

Dear Experts,

I am preparing to export an SRM system and there is an inconsistency in the ABAP dictionary.

In my case, the table exists in the databse, but it's not present in the ABAP dictionary:

SQL> select object_name, object_type from dba_objects where object_name='BBP_OUTPUT_SEND';

OBJECT_NAME          OBJECT_TYPE

--------------------              -------------------

BBP_OUTPUT_SEND      TABLE

SQL> select count(*) from SAPSR3.BBP_OUTPUT_SEND;

  COUNT(*)

----------

         5

SQL> select tabname, tabart from sapsr3.dd09l where tabname='BBP_OUTPUT_SEND';

no rows selected

And all the topics which I find in notes and on forums are for the opposite case - when the table is missing in the DB, but it's present in the ABAP dictionary.

SAP note 117219 - DB02 reports missing DD/DB objects: procedure      advises the following:

  a) Check whether the object was created directly with database

      means.

But OF COURSE, they are not saying how to do that, and I somehow can't think of any method how to check it.

Also I had a BIG hope in note

1248769 - Inconsistency between database and ABAP Dictionary

but, when I select Reconstruct in SE14, it just says:

Request: Convert Table BBP_OUTPUT_SEND (DDIC/28.07.16/11:53)

Process: pnhsrd_0_4336

Table BBP_OUTPUT_SEND does not exist

Activation of Table BBP_OUTPUT_SEND not possible (please check)

Request for BBP_OUTPUT_SEND could not be executed

So, if I try to summarize things, I can only think of 2 solutions:

1) Create an entry in DBDIFF

2) Create the table in the ABAP dictionary in transaction SE11.

Please kindly advise on what to do. I will not open an OSS message for this, as they will respond earliest in a week and I have to do the export

TOMORROW !!! Please let me know, it is very very urgent!

Thanks a lot in advance!

[former_member610534]

Hi Symon,
How you doing. I am facing same kind of issue with a standard table(Available in database but not in data-dictionary(Se11)). Can you please let us know , how your issue resolved?

[Brindavan_M]

Hi Symon Braunbaer,

You can follwo as per the note to reconstruction the table. As per the note follow the steps.

1) Log on with user DDIC

2) call transaction SE14

3) Enter the name of the "Table "--> "Reconstruct".

4) confrim the excution as an emrgency repair.

5) Select the radio button for the processing type as follow:

" Direct" or (for the very larger tables) " background".

6) Select the "svae data" radio button.

choose "Activate and adjust database" to activate the table.

check the consistency of the table again.

Thanks,

BM

[symon_braunbaer]

Hello Brindavan and many thanks for your answer.

Although, as I have stated in my initial post, this method doesn't work:

Also I had a BIG hope in note

1248769 - Inconsistency between database and ABAP Dictionary

but, when I select Reconstruct in SE14, it just says:

Request: Convert Table BBP_OUTPUT_SEND (DDIC/28.07.16/11:53)

Process: pnhsrd_0_4336

Table BBP_OUTPUT_SEND does not exist

Activation of Table BBP_OUTPUT_SEND not possible (please check)

Request for BBP_OUTPUT_SEND could not be executed

[Brindavan_M]

Hi,

Then create this table(BBP_OUTPUT_SEND) in ABAP dictionary. so that already table exist will identified in database.

Thanks,

BM

[symon_braunbaer]

Hi Brindavan,

I have tried recreating the table, but this is very very difficult !!

I have created some entry, I even created a transport request for it, BUT it's still not possible

to activate the table. I am getting a LOT of errors and missing entries:

I can easily get the data types using desc in oracle, but the data types in SAP are different

and now I can't remember where I've seen the correspondence of oracle data types to SAP

data types...

Please help me, it is now extremely urgent. Thanks !!

[former_member267192]

Hi Symon - maybe you already considered this, my idea would be:

Do you have any Test or Development SRM-System in your Landscape? Then you could Transport the Table-Definition of the table from an other SRM System to your System - what Data is stored in your table ? - you also could Transport table Definition and data to your System - Prior that you should Export Data. if there are just a few entries an simple SQL "spool <filename>" and "select * from <table-owner>.<tablename>" would be enough to get the data back after that...

[symon_braunbaer]

Hi Winfried and many thanks for your suggestion.

Of course I thought about that, but the problem is present across the entire landscape.

All the DEV, QAS and PRD system have this problem.

Even a look in SE11 would help to copy the values, but we don't have other SRM systems

to look at. I tried to check a CRM system, but this table is not present there either 😕

I also just figured out, that it's not possible to open an OSS message for those systems at all.

[former_member267192]

Hi Symon ... try to open an SAP Incident - if you are in the middle or right at the starting Point of an upgrade procedure, i would try to put it to "high" or "very high" ... im sorry not to have more help for you  - opening an sap incident is never a failure - dont you think ? ... hope you get quick help !!!

sorry....

[symon_braunbaer]

Hi Winfried,

I am unable to select the SID of the system to open an OSS message.

There is just a link to some company, which is obviously managing the system and

when I click on it, a logon screen to some SAP system appears and I can't login.

Anyway, I have very bad experience with the SAP support. They won't accept a

very high priority message unless there is a production system down 😞

Thank you anyway!

[former_member182505]

Hi Symon

The solution you are thinking is right,

if you need you can take ABAP member help

Thanks

Sadiq

[symon_braunbaer]

Hi Sadiq,

thanks for encouraging, but which solution ? Create a DBDIFF entry or create the table in SE11 ?

[former_member182505]

Hi

Yes please