SAP Knowledge Base Article - Preview

2198254 - DB02 shows missing views in the database

Symptom

DDL SQL views below are listed as "Objects missing in the database" in transaction DB02->Diagnostics->Missing Tables and Indexes, , 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

......

When tried to click on the "Create on DB" button in Action column in DB02, or reactivate the views in SE11, the activation finished with error.
It may return a result as executed successfully for some views, however, in transaction SE11 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 and ABAP CDS , Problem

About this page

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

Search for additional results

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