• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Supply Chain Management Infor SCM

S3 Prod Table List

 7 Replies
 2 Subscribed to this topic
 18 Subscribed to this forum
Sort:
Author
Messages
AReilly
New Member Send Private Message
Posts: 3
New Member
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
Veteran Member Send Private Message
Posts: 80
Veteran Member
4/6/2016 7:45 PM

Hi AReilly, the information you are looking for is in the FILEDEF table in GEN.

AReilly
New Member Send Private Message
Posts: 3
New Member
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
Veteran Member Send Private Message
Posts: 80
Veteran Member
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
Veteran Member Send Private Message
Posts: 80
Veteran Member
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
New Member Send Private Message
Posts: 3
New Member
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
Veteran Member Send Private Message
Posts: 80
Veteran Member
4/7/2016 2:29 PM
Good luck!
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
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