FormID per Form

[Former Member]

Hi,

To better support our customers we are creating a database wherein we store all the queries, query categories from our customers installations. We also wish to know what formatted searches our customers use. I know I can query the CSHS table for this but this table only containes the FormId's the ItemId's and the ColumnId's. I also know I can find out what FormId is what form by using the DebugData but I wonder if there is some kind of exhaustive list with all the forms/items/columns with there respective ID's.

Does anybody if this is available somewhere?

Kind regards,

Ivo Vink

[AlexGrebennikov · Accepted solution]

here is a smart link: /people/lutz.morrien3/blog/2004/10/01/all-sap-business-one-formtypes-at-one-look

[Former Member · Accepted solution]

Brilliant!!!!!

THX a lot. I hope I will find the ItemID's and columns in the same manner!

[barend_morkel2 · Accepted solution]

Ivo,

The Form ID "0" is not in that list. If you need to intercept system messages - this would be the ID you would use. (Form ID "0" = system messages)

Thus any confirmation, error etc. boxes popped up by SBO will have Form ID "0".

Just in case you need it....

[Former Member · Accepted solution]

Ivo,

I think one of the functionalities of my soon-to-be-released application solves the documentation need that you mentioned.

With a couple of mouse clicks you get an Excel workbook with query details, including the form titles that the query is used in.

You'll need a couple of more mouse clicks to get a PowerPoint presentation for each of the fields that has a formatted search on it.

You may have a look at a small subset of example output at

http://xprts.biz/files/small_sample.zip

I am not aware of a document containing full metadata mapping from UI items/columns to DB tables & columns. One of these days someone may write a piece of code that loops through forms & items and extracts these mappings ;-).

HTH

Juha

[former_member185703 · Accepted solution]

Re:

" am not aware of a document containing full metadata mapping from UI items/columns to DB tables & columns. One of these days someone may write a piece of code that loops through forms & items and extracts these mappings ;-)."

This is impossible anyway because at some points UserDataSources are used... so it needs more than a bit of code to accomplish this task

Best regards,

Frank

[Former Member · Accepted solution]

OK, this was easier than I thought.

In order to find out DB-mappings of for each form item

you "just" have to rip off the XML and transform it with

an XSL.

If you want to do-it-yourself then you can start with a

code snippet provided by Sebastien:

Check an example output (beware: there is an advertisement)

http://xprts.biz/files/XML_Form_Check_Fund.xml

HTH

Juha