Please enable JavaScript.

Coggle requires JavaScript to display documents.

Stocklayer - berechnete Felder (on-the-fly Berechnung (Nachteile…

Stocklayer - berechnete Felder

konkretes Berechnungsbeispiel in SQL

ATP stock

select allocation.ID, allocation.ARTICLE_ID, sum(wstock.ATP) as atp
from allocation allocation
join ARTICLE article on allocation.ARTICLE_ID = article.ID
join WAREHOUSE_STOCK wstock on article.ID = wstock.article_id
group by allocation.ID, allocation.ARTICLE_ID;

Global stock

select
       a.ID,
       a.ARTICLE_ID,
       global_a.crv as globalstock
from allocation a
left join (
  select
    COVERED_REMAINING_VALUE crv,
    ARTICLE_ID
  from allocation global_a
  where global_a.VIRTUAL_WAREHOUSE_ID = 'Global'
  ) global_a on a.ARTICLE_ID = global_a.ARTICLE_ID
;