Maintenance view error

[Former Member]

Hi All,

I am facing a weird issue: -

There is a view /asgws/scr_v001 (a z view in custom namespace). This view is transported from system G1 to G2.

G1 system is SAP4.7 and G2 system is SAP ECC6.0.

Now maintenance view for this view is maintained and generated successfully. It is working fine in G1 system.

But in G2 system when i try to see its contents through Se11, it shows "No database view exists for the view /asgws/scr_v001".

I have seen other threads also and found relevant solutions : -

1) View Type: It is C in both the cases, so no problem with that

2) Table maintenance allowed or not: It is 'Table display/maintenance allowed with restrictions' in both the systems G1 and G2.

However, I could see one difference while comparing the tables in both systems.

Database entry Dd02L-Mainflag is 'X' in G1 system where it is working fine.

Database entry DD02L-mainflag is ' ' in G2 system where it is not working.

As per my understanding this is because table maintenance is not allowed in this case. but again there are no differences in both the systems.

Also Is compare flag related to this in anyways. Though i could not find any reelvance just confirming because so far no clues of why things are going wrong ??

Request you to please help me sorting this issue.

Thanks in advance for your valuable time and inputs.

[Sandra_Rossi]

Could you create manually another one in the ECC6 system identical to the one in 4.7, check whether it works (of course), and then compare the DD02L-MAINFLAG for the 2 in ECC6. Just to be sure what is the origin of the problem.

[Former Member]

Hello,

You really need to pay attention when transporting objects especially dictionary objects between different releases of SAP.

Technically the import will succeed most of the time, but generation errors can happen, certain functionalities may no longer work, table data can be truncated, etc ...

I never transport view definitions from a lower release towards an ECC 6.0 system (Netweaver 7.0).

In Netweaver 7.0 SAP has built in new features for dictionary objects like views, tables, etc.

This is why most of the DD0** tables in Netweaver 7.0 contain extra fields and extra field values.

These new field values can never be transported from a lower release because they don't exist there !

A good starting point is the composite OSS-note:

SAP Note 1090842 Composite note: Transport across several releases

Wim

[Former Member]

Resolved. It was a bug in ECC6.0 and was resolved through a custom bug-fix program to set DD02L_MAINFLAG = 'X'.

Thanks,

Shreya