Databases Reference
In-Depth Information
Before any object in SAP HANA can be used, it needs to be activated.
Readers familiar with the SAP ERP development cycle will have come
across this notion often.
Activation is simple—as you can see in the screenshot, at the top-right of the development
pane is a round green button with a right-facing arrow. This button saves and then activates
the current development object. Click this button now so that we can use our attribute view.
The results of the activation request are in the
Job Log
pane at the bottom of the screen (by
default, unless you have moved or hidden it):
In order to check that our attribute view is working correctly, SAP HANA provides a
Data
Preview
function. This is roughly the equivalent of the SE16 transaction in a SAP ERP
system, and shows a tabular listing of the view's contents. It's a very useful debugging tool.
In the
Content
node of the
Navigator
pane, right-click the attribute view (you might need to
expand the tree to see your newly created view), and select
Data Preview
. SAP HANA will
present you with the contents of the view, as shown:
As expected, the contents of the attribute view correspond to the contents of the underlying
CUSTOMERS
table; however, only the two fields
CUST_ID
and
CUST_NAME
are visible in
the view.
Congratulations! We've created an attribute view, one of the most important building blocks of
a SAP HANA application.
