Hi All,

I'm newbie for Crystal Report for Baan LN.
If any of you, has experience using Crystal Report, really appreciate sharing session.
I've link crystal report with database sql , but when I read the table , I don't understand.
it doesn't look like what we always see in Baan.
for example :
we have tdpur401 for PO lines in Baan.
but in CR tables, I don't see any tdpur401 .
Can share tips & tricks to speed up my learning process ?

Thank you

The way tables are named in SQL for Baan/LN tables: t<LN Table Name><LN Company Number>. So, if you're looking for table tdpur401 for company number 100, the database table name would be ttdpur401100. The field names are t_<LN Field Name>, so, for the orno field in that table, the full field name would be ttdpur401100.t_orno.

Hope that helps.

Vince