SAP Knowledge Base Article - Preview

3749902 - Transaction se16 shows entries in table MARDH while HANA sql query on table MARDH returns 0 records

Symptom

  • A mismatch is observed between application-level table data and direct database query results for table MARDH
  • In the GUI (SE16/General Table Display) table MARDH shows entries
  • A direct query in HANA returns 0 for the same table: SELECT COUNT(*) FROM "SAPABAP1"."MARDH"
  • The application layer shows data in MARDH, but a direct SQL query on MARDH returns zero rows


Read more...

Environment

  • SAP S/4HANA foundation
  • SAP HANA, platform edition

Product

SAP HANA, platform edition all versions ; SAP S/4HANA foundation all versions

Keywords

mardh, nsdm_v_mardh, se16, se16n, record count mismatch, hana sql count, zero rows, compatibility view, s/4hana inventory data model, material inventory management, table vs view, sapabap1 schema, data model change, redirect to view, hana query , KBA , HAN-DB , SAP HANA Database , 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.