Advanced features of attribute views

In the previous section we created a simple attribute view, using only certain fields from one base table. In this section we will take a look at more advanced features of attribute views.

The client field

If you can still see the data preview screen of the attribute view, and you switch to the Grid tab of this panel, you will see that the CUSTID number 1 is present twice. This is a problem, especially since this customer is apparently from both the UK and France.

If you recall when we described the data in the previous chapter, we saw the notion of client and the fact that there could be two instances of SAP's ERP software running on the same database at the same time, using two different Client IDs. In our example tables, there is data from both the client 100 and the client 200, and this is why the CUSTID appears twice.

Note

It is very important here to note that even though the CUSTID is the same, the customer 1 from client 100 is not the same customer...