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


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