![Tips & Tricks: Building queries from different tables using drag & drop in SAP Business One - Teamsoft Tips & Tricks: Building queries from different tables using drag & drop in SAP Business One - Teamsoft](https://www.teamsoft.ie/assets/uploads/sap-b1-tips-drag-drop-queries.png)
Tips & Tricks: Building queries from different tables using drag & drop in SAP Business One - Teamsoft
![SAP ABAP Table BUT0ID (BP: ID Numbers), sap-tables.org - The Best Online document for SAP ABAP Tables SAP ABAP Table BUT0ID (BP: ID Numbers), sap-tables.org - The Best Online document for SAP ABAP Tables](https://www.sap-tables.org/table/but0id/sap-table-BUT0ID-erd.png)
SAP ABAP Table BUT0ID (BP: ID Numbers), sap-tables.org - The Best Online document for SAP ABAP Tables
![SAP ABAP Table TBZ9 (BP relationship categories), sap-tables.org - The Best Online document for SAP ABAP Tables SAP ABAP Table TBZ9 (BP relationship categories), sap-tables.org - The Best Online document for SAP ABAP Tables](https://www.sap-tables.org/table/tbz9/sap-table-TBZ9-erd.png)
SAP ABAP Table TBZ9 (BP relationship categories), sap-tables.org - The Best Online document for SAP ABAP Tables
![SAP ABAP Table BPDKNB1 (BP: Business Partner-Relevant Fields in KNB1), sap- tables.org - The Best Online document for SAP ABAP Tables SAP ABAP Table BPDKNB1 (BP: Business Partner-Relevant Fields in KNB1), sap- tables.org - The Best Online document for SAP ABAP Tables](https://www.sap-tables.org/table/bpdknb1/sap-table-BPDKNB1-erd.png)
SAP ABAP Table BPDKNB1 (BP: Business Partner-Relevant Fields in KNB1), sap- tables.org - The Best Online document for SAP ABAP Tables
![SAP ABAP Table BPI000 (BP: Attributes of General Business Partner), sap- tables.org - The Best Online document for SAP ABAP Tables SAP ABAP Table BPI000 (BP: Attributes of General Business Partner), sap- tables.org - The Best Online document for SAP ABAP Tables](https://www.sap-tables.org/table/bpi000/sap-table-BPI000-erd.png)
SAP ABAP Table BPI000 (BP: Attributes of General Business Partner), sap- tables.org - The Best Online document for SAP ABAP Tables
![SAP ABAP Table BUT000 (BP: General data I), sap-tables.org - The Best Online document for SAP ABAP Tables SAP ABAP Table BUT000 (BP: General data I), sap-tables.org - The Best Online document for SAP ABAP Tables](https://www.sap-tables.org/table/but000/sap-table-BUT000-erd.png)