How to Extract all components details from item structure.

Hi All

Good Day…!

Thanks in Advance..!

We received a user request for an ‘Item Structure’ extract that lists all component details for every FG item in a single run ("Covering subassemblies, raw materials, and packaging items, along with start date, end date, and quantity information").

Where they want to see any items which are updated recently. Please let me know if you have any SQL query to get all the above details.

Could you please share an SQL query that retrieves all of the above details?

Thanks,

Dilli Sarana