cancel
Showing results for 
Search instead for 
Did you mean: 

Table DD02L not found in the control table DMC_MT_TABLES

former_member182537
Active Participant
0 Kudos

Hi,

I am getting below error for DD02L as well as few other tables where intial laod with replication does not work but if I just load it works. We are pulling data from SAP ECC to SLT ->ORACLE

Table DD02L not found in the control table DMC_MT_TABLES

Message no. CNV_IUUC_REPL_TS027

Diagnosis

Table DD02L is not present in the data transfer master table.

System Response

The replication cannot proceed until the control tables are properly
updated.

Procedure

Try to load and replicate this table again. If the error persists, contact
your system administrator.

Procedure for System Administration

No entry found in table DMC_MT_HEADER for table DD02L.

Any idea on this issue as my SLT SP is DMIS 2011_SP9 and ECC is on SP7. I am not able to get any notes to fix this.

Kindly advice

thanks

Nilesh

Accepted Solutions (1)

Accepted Solutions (1)

former_member182537
Active Participant

all errors in this post were fixed by applying SAP NOTE 2175207 on SLT SP9 system.

Thanks

Answers (1)

Answers (1)

former_member182537
Active Participant
0 Kudos

Friends, any help on this issue

former_member182537
Active Participant
0 Kudos


trying for othe table.VBUK - getting error that table does not exists and replication fails and further in TABLE HEALTH CHECK - same error is there as -

Table VBUK not found in the control table DMC_MT_TABLES

Please can gurus advice..on this as even after replictaion DD02 table for one other config -getting this issue.

former_member182537
Active Participant
0 Kudos

even adding this table in ADVANCED REplication setting - when i am creating table by SIMUlation

It says does not exist....there only

Saritha_K
Contributor
0 Kudos

Hi,

Are you facing issues for replication of both tables DD02L and VBUK?

Try fixing DD02L error first as it holds meta data information for all tables.

I think VBUK error is happening as DD02L is not having the meta data information.

Can you check logs in your source and SLT system when DD02L is getting started?

tcode- ST22 and SM21

Regards,

Saritha K

former_member182537
Active Participant
0 Kudos

no these are separate linked to different source system.

VBUK is even failing when we have done DD02L correctly and thing is that after adding in advabnced replication setitng when we try to SIMULATE CREATE TABLE - there only it says table does not exists.

I have checked logs no dump in ST22 ....

Can you please advice if there can be some issue as our target system is ORACLE ..

former_member182537
Active Participant
0 Kudos

hi Saritha,

I got that error fixed by chnaging in advcanced rpelication settings - while changing table name - template location was changed to SOURCE system and now the load is happending to target oracel DB but in log shows as replictaion failed

even tough record count matches between ECC and oracle. Please see attached error message-

DDIC activation failed for one of structures below-

Please advice as we have seen table is active in ECC and this error came for MARC table we trried

though all records had passed to oracle.

i tried looking for note as our SLT is on sp9.

thanks

Saritha_K
Contributor
0 Kudos

Hi Nilesh,

I havent come across such an error before, but can you please share your advanced replication screen shot for MARC table once?

Can you check if note 175207 - SLT (2011 SP09) - Correction 01 is relevant for you or not??

I believe there should  be some dump generated..can you check it once?

Regards,

Saritha K

former_member182537
Active Participant
0 Kudos

Tthanks will do. But I can't find any dump generated ,

former_member182537
Active Participant
0 Kudos

CCan't  check note as looks not released yet , can you confirm

Saritha_K
Contributor
0 Kudos

Hi Nilesh,

This note is available. You need your S-id to open it.

Regards,

Saritha K

former_member182537
Active Participant
0 Kudos


ok will check again,. please see screenshot attached as req

However i have noticed in ERP system -there are few appends in NEW status, cna that ben an issue?

former_member182537
Active Participant
0 Kudos

hi Saritha,

checked again that NOte is not released - cannot download from market place

I logged in via OSS ID too. please ca you confirm from where can i get list of SAP notes for SP9

Thanks

Nilesh

Saritha_K
Contributor
0 Kudos

Hi Nilesh,

I just checked again, though I can see the note active, I am not able to download it.

May be you can check with sap support team by raising incident?

Regards,

Saritha K

former_member182537
Active Participant
0 Kudos

Thanks will check.

However just tried few more option sfor different tables and we are getting below error across most of them where we have append structure. i

Aany idea dea on this?

In this case records are getting loaded to oracle target but just in error log it thorws error-

thanks