Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Where's the PLAN table in crystal rpts?

 3 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Sarah
Advanced Member
Posts: 33
Advanced Member
2/15/2012 7:56 PM
    The table that warehouses all the BN15 information, what table is this in if I want to run a crystal rpt? when I hold down my ctrl, shift and O key it shows PLN and the field name but I can't find the PLAN table for me to write a report out of crystal rpts on it. I spoke to our IT group and they can't find it either; they wondered if it's been renamed in the 9.01 version?
    If so, anyone know what name it's called now because Lawson still calls it the PLAN table.

    I hope this makes sense.

    TIA,

    Sarah
    Bob Canham
    Veteran Member
    Posts: 217
    Veteran Member
    2/15/2012 8:32 PM
      If you're using an Oracle database, it is in the R_PLAN table. I'm not sure if it is a different name on other database types.
      Woozy
      Veteran Member
      Posts: 709
      Veteran Member
      2/15/2012 10:18 PM
        The table is R_PLAN in DB2 as well.
        Kelly Meade
        J. R. Simplot Company
        Boise, ID
        Sarah
        Advanced Member
        Posts: 33
        Advanced Member
        2/23/2012 3:58 PM
          Thank you! I was able to use the R_PLAN table for my reports.