topic Persistent class for table with columns with predefined types? in Application Development and Automation Discussions

Persistent class for table with columns with predefined types?

Former Member — Thu, 23 Oct 2014 09:02:11 GMT

Hi,

I tried to create a persistent class for the table SNWD_COMPANY (from the Enterprise Procurement Model).

However, when I try to map the column COMPANY_NAME to an attribute I get the error message

You must specify a type for a value attribute

Message no. SOS_MAPPING147

Well, I don't find a way to specify a type for the column (which has a predefined type of CHAR(80) instead of using a data element) on the mapping screen.

Do I miss something on the mapping screen? Is there another work-around available for cases like this?

Thanks in advance.

Regards,

Valentin

Re: Persistent class for table with columns with predefined types?

former_member218188 — Mon, 03 Nov 2014 09:41:19 GMT

Hi Valentin,

SNWD_COMPANY is a table which has only one entry in the Enterprise Procurement Model. The table represents the main company name, logo etc. For tests with persistency classes you should use SNWD_AD. This is an address table and it has no associations to any other tables. All fields here have data elements defined.

After you have done your tests you should regenerate data by using the data generator:

Transaction sepm_dg
Fress proceed (F8) with Default Settings

After this all EPM tables are filled with valid values. It may happen that you want to recreate data from time to time - for that use "recreate" selection in master data.

For more information see also http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0a7f673-59da-2f10-6e8b-bc7fe5dd4d0f?QuickLink=index&…

Regards,

Stefan

Re: Persistent class for table with columns with predefined types?

Former Member — Tue, 04 Nov 2014 08:27:20 GMT

Hi Stefan,

Thanks for your reply. I am aware of the fact that I can use different tables for tinkering with the Object Services. However, if I want to use the Object Services in a real-world project I may not be able to use different tables.

That is why my question is about the limitation of the Object Services.

Kind regards,

Valentin

Re: Persistent class for table with columns with predefined types?

stefan_bresch — Tue, 18 Nov 2014 09:20:52 GMT

Hi Valentin,

there is no workaround in the mapping screen.Tables to be mapped to persitence classes must not have fields with predefined types.

Best Regards,

Stefan

Re: Persistent class for table with columns with predefined types?

Former Member — Wed, 19 Nov 2014 11:33:08 GMT

Hi Stefan,

Thanks for the confirmation.

Kind regards,

Valentin