Skip to main content

Community,

 

anyone know what is the DB file behind this report?  or is it a joint file?  I would like do a SQL query aganist this/these DB files.

 

@ronhu once you order the report, the data is written in table: sup_open_item_rpt. Data can be fetched also from view sup_open_item_rpv.

Just keep in mind, in order to query the data, you need to Order the report so that result_key is generated. Then you query the table or view based on the result_key.

If you wanna see the data without running the report first, then I guess you would need to explore the SUP_OPEN_ITEM_RPI package to see how the data is fteched when written into the sup_open_item_rpt table.


Reply