Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Extracting Booking History Details - Demand Management

edited Aug 14, 2024 7:27PM in Reporting and Analytics for SCM 1 comment

Summary:

Hi All,

I am trying to extract booking history details for a particular org for the last 3 years, along with the customer details. However, along with bookings history I also need the sales order details but when I try joining the "msc_system_items" with "egp_system_items" I only see item_number = item_name join, because org and inventory_item_id is different in these 2 tables for the same item. Without joining egp_system_items table properly I dont think I would be able to use doo tables. Can someone please help me understand the joining condition that should be used, or if already available pass me the

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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