Display Information Tables in SAP Crystal Reports

To display information tables in SAP B1 Data Sources, you must find out the table information of a specific SAP Business One window, pane, or field before in the SAP Business One menu bar, choose View → System Information. Then, by moving your cursor around the window, you can see the window’s table information displayed in the SAP Business One status bar at the bottom of the screen. In the example below, the table is OINV and the Name field that the cursor is pointing to is based on the CardName column of the OINV table.

When selecting tables from an SAP Business One data source, you can display the table information as follows :

1. In the Database Expert window, in the Available Data Sources pane, right-click a Connection → choose Options.
   

   SAP Business One Tips – Display Information Tables in SAP Crystal Reports

2. In the Options window, in the Tables and Fields area, select the Show Both radio button.
3. Choose the OK button.
   

   SAP Business One Tips – Display Information Tables in SAP Crystal Reports

4. A description is shown for each SAP Business One table in the hierarchy tree as shown below.
   

   SAP Business One Tips – Display Information Tables in SAP Crystal Reports

Also read:

• Additional Information on Bill of Materials Component
• Change Log Now Contains More Valuable Information
• Display QR Code in Crystal Report
• Change Display on Choose From List Using Display Description
• Displays Canceled and Cancellation Watermarks