Skip to main content
Question

Is it possible to extract the text fields from SAP systems to Celonis EMS? Eg: STXL is a cluster table which stores information about text fields but in LRAW format. Is it possible to convert it during our data extraction process and visualize a

  • November 15, 2022
  • 5 replies
  • 13 views

Is it possible to extract the text fields from SAP systems to Celonis EMS? Eg: STXL is a cluster table which stores information about text fields but in LRAW format. Is it possible to convert it during our data extraction process and visualize as string?

5 replies

dennis.pflug
Level 10
  • Level 10
  • November 15, 2022

Hi Vamshi,

 

that is not possible.

You can only read the data by using FM: READ_TEXT

 

I found a possible workaround in another community.

They solved it by scheduling a daily report that translates the table into another table. Then you can extract this translated table to Celonis EMS. But I am not sure if it is worth doing it.

 

Regards,

Dennis


muthappan.alaga
Level 8
Forum|alt.badge.img+1

Hi Vamshi,

 

Follow this celonis documentation for STXL table data need.

 

https://<team name>.<Region>.celonis.cloud/help/display/CIBC/Extracting+the+table+STXL

 

Regards

Muthappan


Hi Vamshi,

 

Follow this celonis documentation for STXL table data need.

 

https://<team name>.<Region>.celonis.cloud/help/display/CIBC/Extracting+the+table+STXL

 

Regards

Muthappan

It says forbidden


dennis.pflug
Level 10
  • Level 10
  • November 15, 2022

It says forbidden

Use: https://docs.celonis.com/en/extracting-the-table-stxl.html

 

It describes the same thing as I mentioned. But good point from Muthappan to point at the documentation. Didn't know that Celonis provides a converter program.

 

"Rather than extending the RFC Module functionality, we have developed a separate program (the attachment is at the end of the page) that decrypts STXL into a readable format using the native SAP function READ_TEXT, and then writes this data into another table - ZSTXL.

This table can be afterwards extracted using our standard RFC Extractor."


Thanks for the information.