Table mismatch

[former_member420959]

Hello all,

In the quality system all the trasaction based on ekko tables are leading to short dump.

When i explored the problem , fields in the %_KEKKO in the function pool /1BCDWB/DBEKKO are deleted in quality some how but are in developemnt.

the program /1BCDWB/DBEKKO in quality is as below

In development it is as

And also I observed of the program in se80 screen 1000 is missing in quality but in developement its present

In quality

In development it is as

Is there any way we can regenerate this and bring it back to normal in quality

Regards

Ujwal

[matt]

/1BCDWB/DBEKKO is a program generated by SAP when you run transaction SE16 to look at the contents of EKKO.

What do you mean you are getting a dump with all transactions based on EKKO? And what dump are you getting? An SE16 program being unavailable is not going to affect other transactions.

[former_member420959]

Yes,

Its dumping when i go to se16 also

Its saying due to no fields in %_KEKKO structure.

The ME21N transaction is leading to dump when save

[matt]

If you would simply give the details of the issue instead of pursuing your (wrong) idea of what is causing it, we'd make better progress.

You are not getting problems because /1BCDWB/DBEKKO is faulty. That is just a symptom. The SE16 dump is useless. Far more important is what dump do you get with ME21N?

[jogeswararao_kavala]

Hi Ujwal,

One possibility can be the inconsistency with table EKKO arose out of ZZ fields in Include structure CI_EKKODB. Investigate in this angle. Compare this structure between trouble-free client and Quality client. Also check the status of your EKKO table. Is it Partly Active?

Jogeswara Rao K

[former_member420959]

Hi ,

The structure in both the clients is same.

[Private_Member_7726]

Hi,

Are there any red entries in SE11 activation log for table EKKO; via menu Utilities->Activation Log? Any errors reported in SE11 Utilities->Database Object->Check and Utilites->Runtime Object->Check? Also, what exactly is the error in ME21N dump?

cheers

Janis

[former_member420959]

The problem now is not only to EKKO

When we try to adjust any Ztable in SE14 also its throwing below errors

Donno how far the above dump for EKKO and this ztables adjustment related.

again its in QAS system only

[former_member420959]

Same error is also for EKKO table as in above screenshot.

[Private_Member_7726]

I'd report this to Basis/DBA... If you want to continue investigating, however:

1) what DB is this;

2) what SUBRC does the DB_EXISTS_TABLE and DD_EXISTS_DATA Function Modules return for those tables?

cheers

Janis

P.s. don't we all programmers just loooooove those "either this or that" error messages..? I know I've written my share of them

[Former Member]

Hi Ujwal,

Please check whether table-EKKO is partly active?

Regards,

Sudeesh Soni

[former_member420959]

Hi Sudeesh , EKKO table is active

[Former Member]

Hi Ujwal,

Check the table-EKKO version history. Is there any change done on table recently?

Also, compare table version history ideally it should be same in both the system.

Regards,

Sudeesh Soni

[former_member420959]

already done that...nothing applied.

While I display contents of a table i am getting below dump

At below line

same in the case of EKKO table also near the same select statement.

Ujwal

[jogeswararao_kavala]

Your investigation should be around the Ztable ZWEIGHMENNT.

See the status of this table, and the status of any Append Structures here, version history etc.

Jogeswara Rao K

[Former Member]

Hi Ujwal,

Is there any appended structure in EKKO table?

Regards,

Sudeesh Soni

[Private_Member_7726]

It doesn't bring us much further, but SyBooks Online say:

590

16

Dynamic SQL error - Prepared statement `%.*s' does not exist. Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.

Something's (seriously) wrong with the database on Quality, I believe. DB admin (and maybe SAP Basis guy) should be looking into it.

cheers

Janis

[former_member420959]

no append structure .

a fields has been added in CI_EKKODB.

[Private_Member_7726]

To answer your original question: you can force regeneration in SE16 via menu Table->Generate Progam. It will be regenerated next time you try to display data:

I don't think it will solve the problem, however...

cheers,

Janis

[matt]

I agree. If ME21N is failing then the problem isn't with SE16 or /1BCDWB/DBEKKO. The problem lies with table EKKO as it is on the database. That requires DBA (BASIS) intervention.

Since anything you do could make things worse, I suggest that you get hold of someone who knows what they are doing.

[Former Member]

Hi,

Check the versions of table EKKO in both the clients and if there are any differences in versions raise the OSS to sap.

Regards

Ravi

[Former Member]

in SE16, use generate program..this same thing happened for me and resolved me in PRD system

Regards

Vdamalai A

[Former Member]

Hi ujwal,

Check the SPDD and SPAU list and confirm you have not missed contents.

Please try to regenarate the missing program.

Regards,

Kannan

[Former Member]

Hi.

The problem isn't in the SAP table. Are in the database. I had a similar problem. The DBA had to recreate the table directly in ORACLE (in my case).

Get help from BASIS.

Regards.

Douglas Santos

[RaymondGiuseppi]

Does not seems to be related to Abap, but to database (Sybase ASE ?) so ask your database admin or let them raise an error (Sybase Support - report an incident (case))

Nevertheless, if no admin available

• Check if table active in database and not only in ddic
• Try also to browse data with SE16N (dynamic) and not SE16 (generated report)
• Sometimes more information available in SM21 following activation, also check activation log thru SE11

Regards,

Raymond