How To Fix RSRV070 - Check blank entries in SID and master data tables of characteristic &1

RSRV070 - Overview

• Message type: E = Error

• Message class: RSRV -

• Message number: 070

• Message text: Check blank entries in SID and master data tables of characteristic &1

Description:
After the tables are created on the database, an <ZH>initial record</>
(also called an <ZH>initial entry</>) is written in
the <DS:GLOS.364F05CAFBD02AB1E10000009B38F982>SID</> tables and in the
master data tables of a characteristic.
This test checks whether there are valid initial records in the
<AB>SID</> tables and in the master data tables. Depending on the
master data table, an initial record has different forms:
In a <AB>SID</> table, the initial record has the following
structure: The value of the characteristic and (if the characteristic
is compounded) the value of the higher-level characteristic are blank.
The <AB>SID</> field is also blank (=0). The three indicators
<AB>CHCKFL</>, <AB>DATAFL</> and <AB>INCFL</> have the value '<AB>X
</>'.
For initial records in a
<DS:GLOS.A4B8A6CE8643D51188040090273D34CB>P-table</> all the fields are
blank, with the exception of the <AB>OBJVERS</> field, which has the
value '<AB>A</>'.
The initial record of a
<DS:GLOS.15C7C0969E43D51188040090273D34CB>Q-table</> consists of blank
fields, with the exception of <AB>OBJ</>VERS = 'A', DATEFROM =
'01.01.1000' and DATETO ='31.12.9999'.
In a <DS:GLOS.74BBA6CE8643D51188040090273D34CB>X-table</> all the
fields are blank, with the exception of the <AB>OBJVERS</> field, which
has the value '<AB>A</>'.
In a <DS:GLOS.48F5E00CBF43D51188040090273D34CB>Y-table</> all the
fields are blank, with the exception of the <AB>OBJVERS</> field that
initially has the value '<AB>A'</>, <AB>DATEFROM</> = '<AB>01.01.1000
</>' and <AB>DATETO</> = '<AB>31.12.9999</>'.
Repairs:
Missing initial records are generated in the repair mode.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSRV070 - Check blank entries in SID and master data tables of characteristic &1 ?

  The SAP error message RSRV070 indicates that there are blank entries in the SID (Surrogate ID) and master data tables for a specific characteristic in the SAP BW (Business Warehouse) system. This can lead to issues in reporting and data consistency.
  
  Cause:
  The error typically arises due to one or more of the following reasons:
  
  Data Load Issues: During the data loading process, some records may not have been populated correctly, leading to blank entries in the SID or master data tables.
  Data Transformation Errors: If there are issues in the transformation rules or mappings, it can result in missing values.
  Data Cleansing Problems: If the source data has blanks or null values, and these are not handled properly during the ETL (Extract, Transform, Load) process, it can lead to this error.
  Manual Data Entry Errors: If data is entered manually, there may be instances where users leave fields blank.
  
  
  Solution:
  To resolve the RSRV070 error, you can