S3 Prod Table List - LawsonGuru.com - LawsonGuru.com Forums -

Prev Go to previous topic

Go to next topic

Last Post 4/28/2016 5:50 PM by Greg Moeller

S3 Prod Table List

7 Replies

Sort:


You are not authorized to post a reply.

Author

Messages

AReilly
Sr. Business Analyst, Supply Chain Informatics
Private

(7 points)
New Member
Posts:3

Send Message:

4/6/2016 4:07 PM
I am looking for an editable list, preferably Excel, of all table names under each section of S3 Production. For example, under "PO, Purchase Order" in Prod, I'd like an editable list of all subsequent table name, e.g. BUYCLASS, BUYER, POLINE etc. I want to be able to do comparisons for what tables exist in different cubes we have built in order to "harmonize" different data mart environments. I can't seem to find any way to export this data. Appreciate any help you folks can provide.

pbelsky
Corporate Applications Analyst
Green Bay Packaging

(230 points)
Veteran Member
Posts:80

Send Message:

4/6/2016 7:45 PM
Hi AReilly, the information you are looking for is in the FILEDEF table in GEN.

AReilly
Sr. Business Analyst, Supply Chain Informatics
Private

(7 points)
New Member
Posts:3

Send Message:

4/6/2016 9:07 PM
Thank you for the insight. So I'm a BI analyst, not a DBA by any means, despite having a lot of access to our servers, so I'm not exactly sure how I would execute that search. But I did a quick search and looks like I'm going to need access to LID. May need to hunt down a technical Lawson peep in IT I'm guessing.

pbelsky
Corporate Applications Analyst
Green Bay Packaging

(230 points)
Veteran Member
Posts:80

Send Message:

4/6/2016 9:17 PM
If you have access to dump the FILEDEF program in LID, you can do that, export it to excel and then sort it however you would like. We are on Windows AND i am lazy, so I find it easier to just access the database directly. It is super-obvious what all the FILEDEF columns are. Your IT peep should be able to do this for you in a jif! I'd do it for you myself and attach the file, but we do not use procurement here. SELECT SYSTEMCODE, FILENAME FROM FILEDEF WHERE PRODUCTLINE = ORDER BY SYSTEMCODE

pbelsky
Corporate Applications Analyst
Green Bay Packaging

(230 points)
Veteran Member
Posts:80

Send Message:

4/6/2016 9:18 PM
Excuse my strategic typo. Meant to say, "If you have access to dump the FILEDEF file/table in LID"

AReilly
Sr. Business Analyst, Supply Chain Informatics
Private

(7 points)
New Member
Posts:3

Send Message:

4/6/2016 10:05 PM
Awesome, thanks for the details! I've tracked down the IT guy I need and am on my way to getting LID access, so soon I'll be dangerous with what you've given me:)

pbelsky
Corporate Applications Analyst
Green Bay Packaging

(230 points)
Veteran Member
Posts:80

Send Message:

Greg Moeller
Private
Private

(4157 points)
Veteran Member
Posts:1485

Send Message:

4/28/2016 5:50 PM
For some help.... the LID command for doing this would be rngdbdump -cnt gen filedef -f systemcode filename > d:\lawson\filename.csv or you could do something like rngdbdump -cnt gen filedef -f systemcode filename \| lashow and save the file from there

You are not authorized to post a reply.