Skip to Content
Former Member
Oct 01, 2014 at 06:26 AM

Logic and design tools behind SAP B1 Reports


Dear all,

I have got a small scale process improvement and new Reports creation assignment with one of my clients who run on SAP B1.

Basically my skills lie in SAP ERP (enterprise and retail components) space and not in SAP B1 at all.

highly appreciate if you could please help me in this very initial days to get my head around with my following basic queries in relates to understanding the architecture behind this SAP B1 reporting.

Client uses SAP B1 version 9.0.

When I run few customized reports (such as daily production sheet, delivery run sheet etc , etc) system pops up with selection criteria for the report( such as date, business partner, product category etc ) to run and when executed it shows me the report outcome on PDF form.

  1. how do I see the relevant SQL statement executed to get me this results set in PDF form ? I need this underlined SQL statement to understand the business logic behind the report.
  2. how do I know which development framework/tools that the client has used to generate these reports, whether its SAP crystal reports or, .net or Query manager and query generator or any other tool ?. because I need to change the layout of some reports and few changes to some report logic as well.
  3. how do I know the data sources that these PDF reports uses to connect to SAP B1 ?

Once again your help is greatly appreciated during this initial few days of me on B1. Thanks heaps !