«

»

May 23 2010

Writing a P80010 Table Definition Browser App.

VN:F [1.9.22_1171]
Rating: 5.0/5 (1 vote cast)

In OneWorld XE/8.0 days, we used to have an application – P80010 – Table Definition Browser Application. This application was of great help, as it showed the database fields in the Table, its indexes, the DD item name, description, the Data type of the field etc.

You can do the same in the Newer versions of EnterpriseOne too, with a very simple app as follows

  1. Create a New BSVW say V5598711.
  2. Add Tables F9860 (Object Librarian master) and F98711 (Table Columns) joined on the NameObject (OBNM) column
  3. Add Table Description (MD) from F9860 and from F98711 include OBND, PSEQ, and SQLC.
  4. Create an Interactive Application with a Find/Browse Form.
  5. Use the above business view (V5598711) for the form.
  6. Add all the columns into the Grid, and put a Form Filter field with F98711.OBNM
  7. Use the B9800420 – GetDataDictionaryDefinition Business Function to retrieve the DD item Description, Data Type, length of the field, and decimals etc in to the grid row. You can also join with the table F9210 to retrieve the same information.

The screen will look like the screen shot below.

 

Table Browser Application

P80010 Table Browser Application for E9

 

Now, once you get the table definitions, I guess wouldn’t you like to go a little further…! Get the indexes! know the primary keys of the table..?

Here it goes, Very similar to the above form , only difference is to use the tables F98712 (indexes header) and F98713 (indexes detail) to create the business view under the form. The F98712 has the names of the indexes on the table & if the key is Unique/Primary Key, and F98713 would show the fields under the index.

Published under the license.

VN:F [1.9.22_1171]
Rating: 5.0/5 (1 vote cast)
Writing a P80010 Table Definition Browser App., 5.0 out of 5 based on 1 rating
(Visited 782 times, 1 visits today)

About the author

Deepesh M Divakaran

Deepesh MD is more of a Gizmo Geek, and a techie.
A very experienced Technical Consultant on Oracle JD Edwards EnterpriseOne, and OneWorld. As a consultant he has worked for wide range of industries, from Manufacturing, Media, Oil & gas etc. and has worked on re-engineering modules, and areas of customization.
With a touch of class and understanding towards what ever he does, he is often regarded by his colleagues as the one stop answer for all Technical/Software related queries.

8 comments

Skip to comment form

  1. David

    Hi,

    A very good idea, but I believe that OBJECT browser is a excellent solution to use, and it’s absolutely free.

    http://www.patwel.com/

    kind regards,
    David

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
    1. Deepesh M Divakaran

      Object Browser is a very good software, but then why would anyone use a 3rd party software, when they can open an application to see the specs while logged in E1 😉
      Thanks for reading the article.

      VN:F [1.9.22_1171]
      Rating: +1 (from 1 vote)
  2. David Terborg

    Hi,

    The whole purpose is to save time and still get the result you wanted Deepesh ;-D
    Why try inventing the wheel while it’s already there ;-D

    Object browser can be launched while logged in E1, and if you’re in Object browser, it will give you the benefit of skipping entering password when signing on in E1.

    I believe in finding the simplest solution for every challenge.
    That way things remain understandable for everyone, at least this is how I look at things.

    But still good tutorial Deepesh, no criticism on my part Deepesh, just alternative solutions.

    kind regards,
    David

    VN:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
    1. Deepesh M Divakaran

      David,
      Its all about discussion, and knowledge & actually Thanks for letting know about the tool. I’d only read its features. As it was a third party tool I thought, you would have to connect it separately than E1.
      And yes… any constructive criticism is always welcome.

      VN:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
  3. olivier

    David,Deepesh

    the advantage of deepesh’s solution is that if deployed, you can use it with only a web browser, while with object browser you’ll need to have a client with SOlution Explorer installed.

    Regards

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  4. kav

    Hi ive been trying to install the app, but it crashes in the Description part. where it is configuring the c++ part the installation crashes. Ive formatted my pc servral times, and even install it on my laptop but same problem
    It say win 32 has encountered a problem and needs to close, i have even re downloaded it and reinstall it, it is the same…
    Please anyone can help me…

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  5. David Terborg

    Hi Kav,

    What OS are you using?
    Have you already installed E1?

    any additional information is welcome.

    kind regards,
    David

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  6. Ken

    Hi Deepesh,

    I found F98711 in 9.2 DEMO is empty?
    Thanks.

    Ken

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)

Leave a Reply