about datatable

[Former Member]

hi,

can i use datatable as SAP Tables

[Former Member · Accepted solution]

Hi Shankar,

As i know it Datatable is for viewing purposes only.You can assign a query to it and view the result.And what do you mean by SAP tables.

[Former Member · Accepted solution]

i want to use datatable in the table "OSRI". Is that possible.

[Nussi]

Hi Puneeth,

as long as you do a query like in this sample you can access every table.

but it's like Raghu said: to view only

sample:

frm.DataSources.DataTables.Add ("OSRI")
frm.DataSources.DataTables.item("OSRI").ExecuteQuery ("Select itemcode, sysserial from OSRI")

frm.Items.item("matrix").Specific.columns.item("ColItem").DataBind.Bind "OSRI", "itemcode"
frm.Items.item("matrix").Specific.columns.item("ColSerial").DataBind.Bind "OSRI", "sysserial "

frm.Items.item("matrix").Specific.Clear
frm.Items.item("matrix").Specific.LoadFromDataSource

create your matrix and look at the sample - and you view the data

lg David

[Former Member]

after viewing the data can i use event handling inside the matrix

[Nussi]

Hi Puneeth,

of course you can use event handling.

event handling is something you can use on every form.

the only thing you have to take care about is to that

when you use eventfilter: than you have to activate the "eventstypes" for the given formtype

lg David