Database table corresponding to Customer in Hybris ECP

Account details page in SAP CRM:

Account details page in SAP C4C:

Register an account with Hybris storefront:

After successful registration, you can see the successfully generated customer in backoffice, where the Customer ID is automatically generated, similar to the uuid in ABAP.

Use flexible search in Hybris Administration console to try to query the customer:

A record was found:

What is seen in the uuid and backoffice of the record is the same:

Looking at the SQL statement corresponding to flexible search, it is found that the "{customer}" used in select from has been translated into the real database table users. The customer defined in curly braces is called code in Hybris

The mapping from code to the real DB table is defined in the xml file:

You can check how many records there are in each DB table in Hybris Administration console:

For more original Jerry technical articles, please follow the official account "Wang Zixi" or scan the following QR code: