Re: Cost Manipulation

Al Mac Wheel wrote:

My tentative approach plan:
* create logical file join-CJ1
** CMF cost master, only cost set-1 actual, joined to IIM item
master, only items of those raw classes that he wants to have actual
used in the new cost set
* create logical file join-CJ2
** CMF only cost set-2 standard with IIM all other items (than those
in join CJ1)
* in theory all items should be in join CJ1 or CJ2 except any that
lack standard or actual cost

Al,

I'm having a bit of time trying to determine what you say up there, but I
think I have the basics. You should be able to run something similar to
the following SQL:

Insert into newlib/cmf
(Select * from oldlib/cmfl01 c
Where cffac='xx' and cfcset=99 and exists (Select * from IIML01 Where
iprod=c.cfprod and iityp='X')


If you were changing the cost set identifier say from 99 to 98, then you
have to mention every field in the statement, like this:

Insert into newlib/cmf
(Select cfid, cfprod, cffac, 98, cfcbkt, cftlvl, cfplvl from
oldlib/cmfl01 c
Where cffac='xx' and cfcset=99 and exists (Select * from IIML01 Where
iprod=c.cfprod and iityp='X')


Bill