Set NVARCHAR for VARCHAR by default for template tables.

dataservices job design
1

Is there any way to get this box to be check by default for all template tables. We need this in all of our tables just about for special characters.

I am sick of having to set it every time I create a template table.

DENMARK_SAP :denmark: (BOB member since 2011-03-16)

2

The ability to use unicode (nvarchar) in a template table is itself a new feature. Probably worth your entering an enhancement request for this.

Then again, if you’re creating template tables every day, maybe it’s worth asking why. :wink:

dnewton :us: (BOB member since 2004-01-30)

3

Because I am building jobs :smiley:

Currently I am working on a project where we are taking the data from an international company located in 10 different countries in Europe, that has one sub company per country. They each have there own ERP system and we are migrating these into SAP. Starting with Customer, Vendor and Material Master data. When you are building this many jobs obviously you want to start with building template tables and then later switch them to permanent tables.Because many of the table have fields with Unicode characters, it would be much easier to make every template table by default be set to nvarchar. Its easy to forget when you are in the process of building about 30 different Data Service Jobs.

I will create an enhancement request but it makes me a little sad in the short term, but such is life.

DENMARK_SAP :denmark: (BOB member since 2011-03-16)

4

Thanks for entering it. I agree, we should have thought about this first place.

Werner Daehn :de: (BOB member since 2004-12-17)

5

Thanks
Werner

DENMARK_SAP :denmark: (BOB member since 2011-03-16)

6

Hi all,

i know that this is a quite old request, but is this now implemented in DS?

We’re on DS 4.2 SP7 and we need NVARCHAR in Template Tables by Default.

Thanks in advance!

Best Regards

barthodo :de: (BOB member since 2012-04-18)