Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

View

Former Member
0 Likes
456

Hi,

When I use a search help for a field in CJ01 for the PROJ-PSPID.

When I check in se11, I first get an information message saying 'View does not exists in database' but still it opens when i click enter.

Any clue on why this happens?

Thanks,

Anami

1 ACCEPTED SOLUTION
Read only

RichHeilman
Developer Advocate
Developer Advocate
0 Likes
425

Sounds like the view exists in the ABAP dictionary but not in the database for some reason. You must know that SAP provides an abstraction from the database layer, this is the ABAP Dictionary, but in some cases you could have the meta data in the dictionary, but the actuall DB object doesn't exist on the DB level. This is a rare occurance in my experience. In order to fix this, you need to go to transaction SE14, enter the view name and hit enter. In the "status" section, you may see as "Active", and then below, it may say "does not exist in DB", Make sure to select the radiobutton below for "Save Data", and click the Activate and Adjust button and see if it gets created in the DB.

Regards,

Rich Heilman

2 REPLIES 2
Read only

RichHeilman
Developer Advocate
Developer Advocate
0 Likes
426

Sounds like the view exists in the ABAP dictionary but not in the database for some reason. You must know that SAP provides an abstraction from the database layer, this is the ABAP Dictionary, but in some cases you could have the meta data in the dictionary, but the actuall DB object doesn't exist on the DB level. This is a rare occurance in my experience. In order to fix this, you need to go to transaction SE14, enter the view name and hit enter. In the "status" section, you may see as "Active", and then below, it may say "does not exist in DB", Make sure to select the radiobutton below for "Save Data", and click the Activate and Adjust button and see if it gets created in the DB.

Regards,

Rich Heilman

Read only

Former Member
0 Likes
425

Which view?

Max