SQL to find the Costs used by S&OP / DM . We are stand alone implementation
SummarySQL to find the Costs used by S&OP / DM
We are implementing S&OP using FBDI uploads (Stand alone).
We are looking for SQL to identify which items are missing the cost of the items at the Org level. How do we identify this from front end? We have lots of Organizations and this is a challenge. We are planning to develop a BIP report which can address this data exception.
Issue is -we are unable to find backend table where the item costs are stored. It does not look straight forward to me.
Looking for help from Community to provide 'sql' query to find the items with zero cost.