Skip to main content
Question

Why I am getting Error: No common table could be found in S4HANA starter kit although I am using Celonis standard transformation and model.

  • November 28, 2023
  • 2 replies
  • 8 views
B
Level 2

I am getting below error in Knowledge Model ->Records->Transaction Activities. Although I have joined both the tables BSEG and _CEL_AR_ACTIVITIES in data model, using key columns

 

Join

TransactionActivityJoin

    2 replies

    N
    Level 6
    Forum|alt.badge.img+5
    • noel.vasan
    • Level 6
    • November 28, 2023

    I would suggest an alias of the same name to the Activity table. Check the variable VAR_ACTIVITY_TABLE 's value and use that name as an alias in the data model.

    B
    Level 2

    I would suggest an alias of the same name to the Activity table. Check the variable VAR_ACTIVITY_TABLE 's value and use that name as an alias in the data model.

    Hi, Thanks for your quick response! I have checked the value of variable “_ VAR_ACTIVITY_TABLE” and the activity table name both are same. Please see the Screenshot attached. Can you suggest any other solution? Variable [cid:image001.png@01DA222D.3B5C5330] Table Name [cid:image002.png@01DA222E.0447B820] Thanks, Bhupendra
    Community Code of ConductAccessibility statement