Current and Historical Cost Data [JDE]


30
views
0
3 months ago by
Does anyone know how to untangle the standard cost table in JDE (jdestage.f4105_view) to determine historical values?

In other words, if I want the 2015 standard cost for an item, how would I do that?  How do I filter on the current year's cost?

REMINDER:  Please don't post actual data/results.
Community: Zimmer Biomet

1 Answer


3
3 months ago by
F4105_view is the item cost table. The table contains total costs for each SKU/Cost Center/Ledg Type combination. The key here is to select the correct ledgtype_coledg for the type of cost required for each sku/cost center being searched.

Here is the sql to find the ledger types and descriptions:

select
  d.userdefinedcode_drky, d.description001_drdl01
from
  jdestage.f0005_view d
where
  d.productcode_drsy = '40' and  d.userdefinedcodes_drrt = 'CM'
order by
          d.userdefinedcode_drky


Specific to the question above about standard cost for 2015 as an example, the historical standard ledg types begin with 81 as 2001, 82 as 2002, etc., so ledg type 95 is 2015. An example:


select
  d.identifier2nditem_colitm,
  d.costcenter_comcu,
  d.amountunitcost_councs
from
  jdestage.f4105_view d
where
  d.ledgtype_coledg = '95'


Other useful types are 07 (always the current standard cost), 05 (future cost, if loaded), and 80 (prior year standard cost).





Please login to add an answer/comment or follow this question.

Similar posts:
Search »