Skip to main content
Question

what is the DB file for Supplier Ledger Open Items Report

  • August 26, 2024
  • 1 reply
  • 43 views

Forum|alt.badge.img+16

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.

 

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • August 26, 2024

@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.



Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings