Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to extract particular print layout design in B1?


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.


Foong Yee

Former Member
Former Member replied

Hi Foong Yee,

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

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

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


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!


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question