Skip to main content
Question

Good day,Our team do a Proof of Value for an O2C process in SAP. Table requirements are given, they are extracting the data. Are there templates available for Transformations for the Eventlogs?

  • October 10, 2022
  • 2 replies
  • 7 views

denise.kruge12
Level 7
Forum|alt.badge.img+15

We know what activities must be in the Eventlog and what tables are required but because it's the first time we work with O2C in SAP it takes time to search through the tables for the correct columns. I know there are connectors and apps available but it seems like when you work with file uploads you cant use them, I may be incorrect.

2 replies

Hi,

 

maybe try to creating views with same names as regular tables, it shouldn't matter if they come from transformations or live connection to system?

 

SQL code snippet:

Create view <regular table name> AS (SELECT * FROM <File_name.xlsx>)

 

Best Regards,

Mateusz Dudek


denise.kruge12
Level 7
Forum|alt.badge.img+15

Thank you Mateusz