SAP Knowledge Base Article - Preview

2365168 - View LFC3 does not exist in the database when running on HANA

Symptom

The issue can happen in two different scenarios:

  1. Checks in DB02 shows that view LFC3 does not exist in the database when running on HANA.

    or

  2. When running SAP SFIN 2.0 it is possible to see the dump below refferring to table LFC3.
----------------------------------------------------------------------------------------------------
|Category               Installation Errors
|Runtime Errors         DBSQL_TABLE_UNKNOWN
|Date and Time          08.08.2016 17:42:15
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Short Text                                                                                        |
|    Table is unknown or does not exist.                                                           |
----------------------------------------------------------------------------------------------------




----------------------------------------------------------------------------------------------------
|                                                                                                  |
|    "DBSQL_TABLE_UNKNOWN"                                                                         |
|    "SAPLACKK" bzw. LACKKU08                                                                      |
|    "LINEITEM_SPGLTRANSACT_REPORT"                                                                |
|                                                                                                  |

----------------------------------------------------------------------------------------------------



----------------------------------------------------------------------------------------------------
|Information on where terminated                                                                   |
|    The termination occurred in ABAP program "SAPLACKK", in                                       |
|     "LINEITEM_SPGLTRANSACT_REPORT". The main program                                             |
|    was "SAPMF05A".                                                                               |
|                                                                                                  |
|    In the source code, the termination point is in line 85 of (Include)                          |
|    program "LACKKU08".                                                                           |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Source Code Extract                                                                               |
----------------------------------------------------------------------------------------------------
|Line |SourceCde                                                                                   |
----------------------------------------------------------------------------------------------------
|   83|      FINS_SET_STACK_TEMPERATURE lv_data_temperature.                                       |
|   84|                                                                                            |
|>>>>>|      SELECT * FROM LFC3 WHERE LIFNR = I_ACCNT                                              |
|   86|                         AND   BUKRS = I_BUKRS                                              |
|   87|                         AND   GJAHR = I_GJAHR.                                             |
|   88|        REFE = LFC3-SALDV + LFC3-SOLLL - LFC3-HABNL.                                        |
|   89|        CHECK REFE NE 0.                                                                    |
|   90|        LOOP AT TEXTAB WHERE KOART = 'K'                                                    |
|   91|                       AND   SHBKZ = LFC3-SHBKZ.                                            |
|   92|          SHIFT CHARA RIGHT BY 3 PLACES.                                                    |
|   93|          CHARA(2)   = ', '.                                                                |
|   94|          CHARA+2(1) = LFC3-SHBKZ.                                                          |
|   95|          REFE1     = REFE.                                                                 |
|   96|          EXIT.                                                                             |
|   97|        ENDLOOP.                                                                            |
|   98|      ENDSELECT.                                                                            |

Read more...

Environment

  • SAP Hana Database 1.0
  • SAP SFIN 2.0

Product

SAP HANA 1.0, platform edition

Keywords

DBSQL_TABLE_UNKNOWN, V_LFC3_2_1_DDL, ENT_2166, LFC3_AEDAT_DDL, LFC3_DDL, V_LFC3_RECON_DDL, V_LFC3_RECON_SUM_DDL, DB02, HANA, database, dump
, KBA , BC-DWB-DIC , ABAP Dictionary , 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 ONE Support launchpad (Login required).

Search for additional results

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