What is the significance of SN tables in the database?

[former_member637469]

Hi Experts,

I was looking at the DB structure today and found tables ending with SN, these tables follow the naming patterns as SN. Could you please explain what is the significance of these tables and where are they used.

the tables have columns namely paylodeBefore and payloadAfter, these attributes have JSON with type attributes and their PK values.

Could you please share in case you are aware of the same.

thanks,

[former_member620692 · Accepted solution]

These are Audit Log tables. Hybris (SAP Commerce) persists audit logs for types configured for auditing automatically. It uses a default storage implementation for that purpose. For each type, a new corresponding table is created during initialization or update. The table name follows the <deploymentName><numericTypeCode>sn naming convention. For example, an audit table for the User type would be called users4sn.

Please check the following links for more details:

1. https://help.sap.com/viewer/d0224eca81e249cb821f2cdf45a82ace/1905/en-US/08a27931a21441b59094c8a6aa2a...

2. https://help.sap.com/viewer/d0224eca81e249cb821f2cdf45a82ace/1905/en-US/3e2b8491449d43b391eb1ce9c73c...

You can also check a similar Q/A, https://answers.sap.com/questions/12767768/need-to-know-the-corresponding-model-for-audit-tab.html?c...