Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

from where i can find activity name

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
vijay
New Member
Posts: 1
New Member
11/16/2005 10:50 AM
    i am using table mmdist table for details.But as it having only activity code and accounting_category code.,But i also wants activity name and accounting category name also in my report.
    Inwhich table i canget them and how i can relate them to mmdist
    Keri White
    Basic Member
    Posts: 6
    Basic Member
    12/14/2005 10:30 PM
      You can use the ACACTIVITY and ACACCTCAT tables to get the descriptions. Relate on ACTIVITY and ACCT-CATEGORY respectively.
      John Henley
      Posts: 3353
      12/14/2005 10:45 PM
        In (Oracle) SQL, it would look something like this:
        SELECT
        MMD.ACTIVITY,
        ACV.DESCRIPTION,
        MMD.ACCT_CATEGORY,
        AAX.DESCRIPTION
        FROM
        MMDIST MMD,
        ACACTIVITY ACV,
        ACACCTCAT AAX
        WHERE
        MMD.ACTIVITY=ACV.ACTIVITY(+)
        AND
        MMD.ACCT_CATEGORY=AAX.ACCT_CATEGORY(+)
        Thanks for using the LawsonGuru.com forums!
        John