3751465 - MSS: Specific missing views (V_MRP_MFG_COMPS, V_MRP_MFG_ORDERS, V_MRP_PROD_DEM)

• Missing indexes/views are displayed in DBACOCKPIT for a system planned for conversion to S4/HANA
  
  
• Specific missing views: V_MRP_MFG_COMPS, V_MRP_MFG_ORDERS, V_MRP_PROD_DEM.
  
  
• When attempting to create the missing view in the database, it fails with error.
  
  For example:
  
  Cannot find either column 'ABC' or the user-defined function or aggregate 'ABC.SAP_LPAD', or the name is ambiguous. 
  The SQL statement was not executed. Statements for View V_MRP_MFG_ORDERS could not be executed. 
  Request for V_MRP_MFG_ORDERS could not be executed.

• SAP Netweaver products running on MS SQL server
• The system is set up by either system copy or system rename

dbacockpit, missing views, sql server, v_mrp_mfg_comps, v_mrp_mfg_orders, v_mrp_prod_dem, cds view activation, rutddlscreate, rutcnvfunccre1, sap_lpad, missing indexes , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem