Skip to main content
Question

what is the DB file for Supplier Ledger Open Items Report

  • August 26, 2024
  • 1 reply
  • 39 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.


Reply


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