Skip to Content

how can I display table's owner with table in the object browser

such as


20191009-110611.jpg (199.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Posted on Oct 14, 2019 at 02:16 PM

    You can show the owner of the object in the object browser using the label property (as stated in the documentation "Specifies the display name of the attribute, which will appear in the PowerDesigner interface.")

    I generaly use an Extended model for that.

    Add comment
    10|10000 characters needed characters exceeded

    • Well done for finding this one. Here's my version

      Function %GetObjectLabel%(obj)
      ' Compute a string label for displaying
      ' the object in browser, symbol and combo box
      if not obj.Owner is nothing then
      %GetObjectLabel% = obj.Owner.Code & ":" & obj.Name
      %GetObjectLabel% = "== NO OWNER ==" & ":" & obj.Name
      end if
      End Function

      This works instantly in the diagram and browser if the table already has an owner. There does appear to be a small bug - if I create a new user via the owner property on the Table's general tab, it displays OK in the diagram but defaults to USER_n:TableName in the Browser. I suspect it would be OK when I re-open the model.

      I'm looking at the %SetObjectLabel% event handler, wonder how I can use that one?

  • Posted on Oct 09, 2019 at 08:40 AM

    I am afraid, that the only two attributes displayable in object browser are Name and Code of the object. So if your Names and Codes are equal, you can use Name to contain both table owner and table name. But if you are already using Name as business label of table, then you have no other option left.

    I think this could be a good topic for SAP to make the object browser content appearance more configurable. I can imagine that it could be similar to Display Preferences - Content settings.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 09, 2019 at 09:53 AM

    I suggest using either a list of tables (from the Model menu), or a List Report. In a list of tables you can include details of the Table Owner, and sort and filter the list if you want to.

    In a List Report you can go even further - this List Report focuses on Columns, and includes details of the Table, plus the name of the Table Owner:

    Add comment
    10|10000 characters needed characters exceeded