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.
要获取更多Jerry的原创文章，请关注公众号"汪子熙":