SAP Knowledge Base Article - Preview

2198254 - DB02 shows missing views in the database

Symptom


If you check in DB02->Diagnostics->Missing Tables and Indexes, you find DDL SQL views below are listed as "Objects missing in the database", such as:

<1>

CDS_M_M2S_PD_ITM
CDS_M_M2S_PD_I_C
CDS_M_M2S_POIV_B
CDS_M_M2S_POIV_M
CDS_M_PHL_EKBE_C

......

M_V_M2S_POIV_VM_B
M_V_PD_ITM_STATUS
M_V_POH_VAL0

......

V_MRP_MFG_COMPS
V_MRP_MFG_ORDERS
V_MRP_PRE_TRANSF
V_MRP_PROD_DEM
V_MRP_TRANSF_DEM

......

 

<2>

ESJIFIDUNAREA

ESJIFIDUNAREATXT

ESJISDCUSTTXCLS

......

You have tried to click the "Create on DB" button in Action column in DB02, or reactivate the views in SE11, but all finished with error.
It may return a result as executed successfully for some views, however, if you go to SE11 to check the views again, you still get warning that this view is not existing in the database.


Read more...

Environment

SAP system based on SAP NETWEAVER 7.40

Product

SAP NetWeaver 7.4

Keywords

DB02, Missing Tables and Indexes, Objects missing in the database, ESJIFIDUNAREA, ESJIFIDUNAREATXT, ESJISDCUSTTXCLS, CDS_M_M2S_PD_ITM, CDS_M_M2S_PD_I_C, CDS_M_M2S_POIV_B, CDS_M_M2S_POIV_M, CDS_M_PHL_EKBE_C, CDS_M_PHL_VAL, CDS_M_POH_AGGR, CDS_M_POH_EKBEMC, CDS_M_POH_EKBE_C, CDS_M_POH_EKBZMC, CDS_M_POH_VAL, M_V_M2S_POIV_VM_B, M_V_PD_ITM_STATUS, M_V_POH_VAL0, ESJISOSLDD, EHHSSV_SPLCP_ARS, RUN_RUTDDLSCREATE_TRANS,This is not supported on DB , KBA , BC-DWB-DIC , ABAP Dictionary , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.