How is CRM order status modelling in HANA studio

版权声明：本文为博主汪子熙原创文章，未经博主允许不得转载。 https://cloud.tencent.com/developer/article/1438548

All system status are queried from TJ02 table:

The description of status code is from TJ02T table:

And there is a view which joins the two views above in order to return both system status code and system status description.

Data preview looks like below:

However this SystemStatusValueHelp view is only used in one OData service below:

And there is no model for user status.

For Opportunity status related HANA model, since in the report, it will show the total number of Opportunities with the following status:

won

lost

hasError

Open

InProcess

Its modelling detail:

the logic for isWon:

Final data preview result below:

From here we get the conclusion that the cardinality of Opportunity UUID : SystemStatus code is: 1:N.

For example, an Opportunity can have the system status “hasError” and “In process” for the same time, as also introduced in this picture below.

​