Wednesday, March 28, 2012

Items with Inv in F41112 and missing Base closing period costs


SELECT   indct, infy, inctry, initm, inlitm, inaitm, inmcu, inglpt,
         (SUM (innq01 + innq02)) / 1000
    FROM proddta.f41112
   WHERE infy = 12
     AND inctry = 20
     AND indct = 'BF'
     AND NOT EXISTS (
            SELECT *
              FROM proddta.f554105
             WHERE initm = c2itm
               AND inmcu = c2mcu
               AND c2ctry = 20
               AND c2fy = 12
               AND c2pn = 2
               AND c2ledg = '02'
               AND c2uncs <> 0)
GROUP BY indct, infy, inctry, initm, inlitm, inaitm, inmcu, inglpt
  HAVING SUM (innq01 + innq02) <> 0;

No comments:

Post a Comment