Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
SQL to find the Costs used by S&OP / DM . We are stand alone implementation — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL to find the Costs used by S&OP / DM . We are stand alone implementation

Received Response
29
Views
2
Comments
edited Jun 2, 2019 3:22PM in Supply Chain Planning and Collaboration 2 comments

Summary

SQL to find the Costs used by S&OP / DM

Content

Hello,

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!