SAP Knowledge Base Article - Preview

3429540 - What is BASIS_INFO BI in the diagnostic SQL script HANA_Data_DuplicateKeys_CommandGenerator_1.00.100+.txt ?

Symptom

You want to execute the diagnostic SQL script HANA_Data_DuplicateKeys_CommandGenerator_1.00.100+.txt but you wonder what BASIS_INFO BI is, as there is no BASIS_INFO BI table?

BASIS_INFO AS
( SELECT                      /* Modification section */
      '%' SCHEMA_NAME,
      '/BIC/SCMACCTN21' TABLE_NAME,
      '' KEY_COLUMNS,
      '' INDEX_NAME,
      'NO_AGGR_SIMPLIFICATION, NO_GROUPING_SIMPLIFICATION' EXECUTION_HINT
    FROM
      DUMMY
),
KEY_COLUMNS AS
( SELECT
    MAP(BI.KEY_COLUMNS, '', IC.KEY_COLUMNS, BI.KEY_COLUMNS) KEY_COLUMNS
  FROM
    BASIS_INFO BI,


Read more...

Environment

  • SAP HANA 1.0
  • SAP HANA 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, enterprise edition all versions ; SAP HANA, platform edition 2.0 ; SAP S/4HANA 2021

Keywords

BASIS_INFO BI, BASIS_INFO , HANA_Data_DuplicateKeys_CommandGenerator_1.00.100+ , KBA , HAN-DB , SAP HANA Database , HAN-DB-ENG , SAP HANA DB Engines , 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.