User Defined Objects

[Former Member]

Hi

I have defined 2 user defined tables, one object type master data and the other object type master data lines.

My form for data entry is fine using a user defined object.

I need to import some of the customers old data from a spreadsheet and I am unsure the best way to do this.

Can anyone give me any ideas pls ?

Regards Andy

[Former Member · Accepted solution]

Hi Paul.

Usually I create my own small program that connects via DI and makes all the inserts. This program is not a SAP add-on, but a windows program running outside SBO.

When dealing with data lines, you need to handle the foreign keys, which keeps track of master data and the lines.

- Thomas

[Former Member · Accepted solution]

Hi Thomas

That's what I am interested in, what ojbect do you use to connect to the data ?

Regards Andy

[Former Member · Accepted solution]

Hi,

At the moment, DI API haven't any object to conect to the data of the UDO, I think that the solution proposed by Thomas is tha you use SQL directly for this action, SAP don't support this kinds of actions, but from my point of view is the one and only posibility that you have, because UserTables object of the DI API can't access to user tables of UDO.

Best Regards.

[Former Member · Accepted solution]

Hi Guys

Thanks for your help. I am just surprised there isn't an object to handle it.

Regards Andy

[Former Member]

Hi,

You need to mantain the integrity of the document numbers in ONNM table.

Best regards.