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

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

Forum|alt.badge.img+5
  • 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.


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