cancel
Showing results for 
Search instead for 
Did you mean: 

retrive value from OSRI table

Former Member
0 Kudos

hi,

can i know weather "OSRI" table is master object, document object, or no object table. how can i retrive values from OSRI table and store to a variable for calculation

REgard,

Puneeth S

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi puneeth,

You can find the information like this :

SAPbobsCOM.SerialNumbers oSerialNumber;

oSerialNumber = (SAPbobsCOM.SerialNumbers)SBO_Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oStockTakings);

Regards

Michael

Answers (1)

Answers (1)

Nussi
Active Contributor
0 Kudos

Hi puneeth,

the OSRI table is a SAP data table - it contains all Serial Numbers for the Items.

i would collect the data with a recordset.

let's say you want all Manufacturer Serial No. from a given item make this:

oRecordSet.DoQuery("SELECT SuppSerial FROM OSRI Where ItemCode='A1000'")

what you can do now is to loop through the recordset and store the result in a matrix.

why a matrix ? because you can get more SuppSerial for a item.

lg David