How to extract particular print layout design in B1?

[Former Member]

Hi,

I had design some of the marketing documents using print layout design. How do I extract the particulars marketing documents?

Currently I'm copy the whole table and replace it.

Please advice.

Thank you.

Regards,

Foong Yee

[Former Member · Accepted solution]

Hi Foong Yee,

SAP Note 600813 might help a bit (copying LD templates) The direct link:

https://websmp101.sap-ag.de/~sapidb/012006153200000183292003E.ITF

---- Replace *SOURCE* with the source database name.
---- Replace *DEST* with the destination database name.

insert into [*DEST*].[dbo].[RDOC]
select [*SOURCE*].[dbo].[RDOC].*

from
[*SOURCE*].[dbo].[RDOC],[*DEST*].[dbo].[cinf],[*SOURCE*].[dbo].[cinf]

where [*DEST*].[dbo].[cinf].[lawsset]=[*SOURCE*].[dbo].[cinf].[lawsset]and [*DEST*].[dbo].[cinf].[version]=[*SOURCE*].[dbo].[cinf].[version] and [*SOURCE*].[dbo].[RDOC].[Doccode]NOT IN (SELECT Doccode from [*DEST*].[dbo].[RDOC])

insert into [*DEST*].[dbo].[RITM]
select [*SOURCE*].[dbo].[RITM].*

from [*SOURCE*].[dbo].[RITM],[*DEST*].[dbo].[cinf],[*SOURCE*].[dbo].[cinf] where [*SOURCE*].[dbo].[RITM].[Doccode] NOT IN (select Doccode from [*DEST*].[dbo].[RITM])AND [*SOURCE*].[dbo].[RITM].[Doccode]IN (SELECT Doccode from [*DEST*].[dbo].[RDOC])

Hope it helps!

Rowdy