Copy PLD templates

[Former Member]

Hi all,

I am trying to copy a PLD template from one DB to another.

I am using the query that I found here on the forum:

INSERT INTO [Target].[DBO].[RDOC]

SELECT [Source].[DBO].[RDOC].* FROM [Source].[DBO].[RDOC]

WHERE [Source].[DBO].[RDOC].DOCCODE = 'VPM10003'

INSERT INTO [Target].[DBO].[RITM]

SELECT [Source].[DBO].[RITM].*

FROM [Source].[DBO].[RITM]

WHERE [Source].[DBO].[RITM].DOCCODE = 'VPM10003' AND [Source].[DBO].[RITM].DOCCODE

IN (SELECT DOCCODE FROM [Target].[DBO].[RDOC])

I get the following error however and I havent been able to figure out why:

Insert Error: Column name or number of supplied values does not match table definition.

I would normally use the method of copying all the fields, but the 2 databases are on different patch levels so i cant log into the source DB in the normal way.

Can anyone give me any suggestions as to what I may be doing wrong??

Thanks and regards,

John O'Brien

[former_member583013 · Accepted solution]

John O'Brien,

If I remember, Since Patch 36 onwards SAP has added a column to the RDOC and RITM tables and this is probably what is causing the error.

Suda

[Former Member]

Hi Suda,

Thanks for quick reply.

I will try to get this cust upgraded asap.

Thanks again,

John

[former_member583013]

The column is called Shading [Print Item Background\] and it is a Y / N field.