ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
ICM Query - Total Demands by Part Number
  
Q.    I am trying to determine the Total Demands by Part Number, regardless of Inventory or POs.  Can you direct me to the proper data element and and table
A   MRPACT table would contain the Demand information
       To get the Part Number and/or AVL information you would have to link the uniq_key fields to the INVENTOR and/or INVTMFHD Tables
Article ID: 3260