Print layout history

[Former Member]

My client place somebody created a print layout .we want to find out who created the layout as well as the date & time.

Please give some solution as soon as possible.

regards

kavitha

[Former Member]

Hi Kavitha,

Try this, sample Query.

SELECT DocCode, DocName, Author, TimeFormat, DateFormat FROM RDOC WHERE DocCode = 'INV20001'

Result: TimeFormat = 0, DateFormat = 0.

i think it is not possible in SAP B1.

Regards,

Madhan.

[Former Member]

It was not possible in SAP B1.

regards

kavita S

[Former Member]

Hi Kavitha,

Yes, i'm also try this.

i think it is not possible in SAP B1.

Close the thread if issue solved

Regards,

Madhan.

[Former Member]

Hi Kavitha,

IF you want a details of who was created the Print layout design.

->> Open any one PLD then Choose the Print Layout Designer on Menu bar and Click Display Document Properties.

->> Open the Display Document Properties Window.

->> Move to Cursor to Document ID in General Tab.

that is the PLD DocCode. note that document id and use to Query Condition.

Try this (Sample) Query in SQL Server Management Studio.

SELECT * FROM RDOC WHERE DocCode = 'INV20001'

Result : You will get complete list of PLD's Details.

SELECT DocCode, DocName, Author  FROM RDOC WHERE DocCode = 'INV20001'

Result : DocCode, DocName, Author

Regards,

Madhan.

Edited by: Madhan Babu C on Sep 2, 2009 2:26 PM

[Former Member]

I got the author but i want to know the date and time when the layout was created.

regards

kavitha s

[Former Member]

Hi Kavitha,

Access RDOC Table thorugh SAP B1. You will get complete list of PLD Details.

The Tables related to PLD document templates are RDOC and RITM. When you set a PLD as default for a user or

BP then entried are created in RDFL tables. You can also check RTYP.

If I have more info I will post it.

Regards,

Madhan.

Edited by: Madhan Babu C on Sep 2, 2009 1:28 PM