Skip to Content
avatar image
Former Member

Help me for print layout designer

Hi!

Can you tell me, if a layout was designed, can we use it for other company.

Becase i do not want design new for other copmpany. Require for layout of new company also same old one.

Thanks for support.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 20, 2007 at 11:10 PM

    Yes you can use a PLD layout across multiple company DB. You can use the SAP Addon CopyExpress to copy a PLD from One company DB to another. There is also a SQL script, and a cut and paste method to copy a PLD format from one DB to another.

    Dan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      If you have formatted search and UDT in your report, you should use CopyExpress if you don't want to copy manuelly all the Formatted searches and UDT too.

      In the beginning I was using this SQL query to transfer the report, but it's wasn't very useful in case where the primary key was already use in the previous report...

      I think CopyExpress is a free add-on. I use it now and it's much better.

      For the SQL, try this :

      DEST = Destination Database

      SOURCE = Source Database

      ? = Your username

      insert into [DEST].[dbo].[RDOC]

      select *

      from [SOURCE].[dbo].[RDOC]

      where [SOURCE].[dbo].[RDOC].Author = '?'

      insert into [DEST].[dbo].[RITM]

      select [SOURCE].[dbo].[RITM].*

      from [SOURCE].[dbo].[RITM], [SOURCE].[dbo].[RDOC]

      where [SOURCE].[dbo].[RITM].DocCode = [SOURCE].[dbo].[RDOC].DocCode and

      [SOURCE].[dbo].[RDOC].Author = '?'