Go Back > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 6th October 2016, 15:00
The_Hummer The_Hummer is offline
Junior Member
Join Date: Oct 2016
Posts: 3
The_Hummer is on a distinguished road
Baan: NA - DB: NA - OS: NA
BOM - Table
Baan: Baan IVc4
DB: Other/Unknown
OS: AIX 6.1
C/S: None/Unknown

Hello all,
I'm kind of newbie in regards BAAN.
We are basically decom BAAN and archive in to an archiving platform, and we need to replicate some report, specifically for BillOfMaterial extract and related costs.
Is there any particular view or table aggregation I may use for the purpose?

Many thanks
Kind Regs
Reply With Quote
Old 7th October 2016, 22:54
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,111
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Well it depends on what all information you are looking for - tibom010 bill of material and tiitm001(item master) are two of the main one we use. There are other tables that could come into play for specific things(ie - unit effectivity, date effectivity, etc).

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
Old 8th October 2016, 14:37
bdittmar's Avatar
bdittmar bdittmar is offline
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,721
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
ticst , tirou a.s.o.

Hello, as Mark suggested,
tibom010 and tiitm001
also ticst (Cost) tables and tirou (Routing) tables maybe for interest.

Reply With Quote
Old 10th October 2016, 14:53
The_Hummer The_Hummer is offline
Junior Member
Join Date: Oct 2016
Posts: 3
The_Hummer is on a distinguished road
Baan: NA - DB: NA - OS: NA
Thanks you both for the good start: is there any standard SQL statement for a BOM explosion + related cost using as input a Material Master (main equipment)?

Thanks a lot
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Use of "background" keyword in Baan kruyoupatel Tools Development 2 27th April 2016 07:03
Zoom Menu Return Multi Value layswan Tools Development 3 24th July 2012 09:42
zoom to correct business partner jojovalenton Tools Development 5 14th October 2009 10:26
Tables used for MRP and PRP. BurghMan Tools Development 1 10th February 2005 14:08
copy records c_siek Tools Development 9 18th June 2004 15:43

All times are GMT +2. The time now is 22:24.

©2001-2018 - -