{"id":111308,"date":"2024-12-02T08:36:48","date_gmt":"2024-12-02T07:36:48","guid":{"rendered":"https:\/\/dataunit.nadlotest.ch\/?p=111308"},"modified":"2026-07-26T21:27:08","modified_gmt":"2026-07-26T21:27:08","slug":"abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart","status":"publish","type":"post","link":"https:\/\/dataunit.nadlotest.ch\/en\/2024\/12\/02\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/","title":{"rendered":"Creating queries in SAP Business One | SQL &amp; HANA explained simply"},"content":{"rendered":"<div class=\"x-resp-embed x-is-video x-is-youtube\"><iframe loading=\"lazy\" title=\"Abfragen in SAP Business One erstellen | SQL &amp; HANA einfach erkl\u00e4rt\" src=\"https:\/\/www.youtube.com\/embed\/I0z8PuK4YBs?feature=oembed\" width=\"1080\" height=\"608\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<p>&nbsp;<\/p>\n<p>In SAP Business One, you can create your own queries and lists directly from the database.<\/p>\n<p>Bruno shows:<\/p>\n<p class=\"gt-block\">how the system information is used<br \/>\nhow to find tables and fields<br \/>\nwhich assistants SAP B1 offers for this<br \/>\nand how to build the first simple queries<\/p>\n<p>Ideal for anyone who wants to get more out of their data.<\/p>\n<p class=\"gt-block\">\ud83d\udc49 Which SAP B1 topics interest you?<br \/>\n<a href=\"mailto:tippsundtricks@dataunit.ch\">tipsandtricks@dataunit.ch<\/a><\/p>\n<p>#SAPBusinessOne #SQL #SAPB1 #DATAUNIT<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; In SAP Business One, you can create your own queries and lists directly from the database. Bruno shows: how the system information is used how to find tables and fields which assistants SAP B1 offers for this and how to build the first simple queries Ideal for anyone who wants to get more out [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":111309,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[10096,10099],"tags":[],"class_list":["post-111308","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tipps-und-tricks","category-youtube-video"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating queries in SAP Business One | SQL &amp; HANA explained simply | DATA UNIT<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating queries in SAP Business One | SQL &amp; HANA explained simply | DATA UNIT\" \/>\n<meta property=\"og:description\" content=\"&nbsp; In SAP Business One, you can create your own queries and lists directly from the database. Bruno shows: how the system information is used how to find tables and fields which assistants SAP B1 offers for this and how to build the first simple queries Ideal for anyone who wants to get more out [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/\" \/>\n<meta property=\"og:site_name\" content=\"DATA UNIT\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-02T07:36:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-26T21:27:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dataunit.nadlotest.ch\/wp-content\/uploads\/2024\/12\/maxresdefault-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"dataunit\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dataunit\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/2026\\\/07\\\/26\\\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/2026\\\/07\\\/26\\\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\\\/\"},\"author\":{\"name\":\"dataunit\",\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/#\\\/schema\\\/person\\\/73e7ceb9560a7d5782155c8e2170d013\"},\"headline\":\"Creating queries in SAP Business One | SQL &amp; HANA explained simply\",\"datePublished\":\"2024-12-02T07:36:48+00:00\",\"dateModified\":\"2026-07-26T21:27:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/2026\\\/07\\\/26\\\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\\\/\"},\"wordCount\":82,\"image\":{\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/2026\\\/07\\\/26\\\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/maxresdefault-2.jpg\",\"articleSection\":[\"Tipps und Tricks\",\"YouTube Video\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/2026\\\/07\\\/26\\\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\\\/\",\"url\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/2026\\\/07\\\/26\\\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\\\/\",\"name\":\"Creating queries in SAP Business One | SQL &amp; HANA explained simply | DATA UNIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/2026\\\/07\\\/26\\\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/2026\\\/07\\\/26\\\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/maxresdefault-2.jpg\",\"datePublished\":\"2024-12-02T07:36:48+00:00\",\"dateModified\":\"2026-07-26T21:27:08+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/#\\\/schema\\\/person\\\/73e7ceb9560a7d5782155c8e2170d013\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/2026\\\/07\\\/26\\\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/2026\\\/07\\\/26\\\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/2026\\\/07\\\/26\\\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/maxresdefault-2.jpg\",\"contentUrl\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/maxresdefault-2.jpg\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/2026\\\/07\\\/26\\\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Start\",\"item\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating queries in SAP Business One | SQL &amp; HANA explained simply\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/#website\",\"url\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/\",\"name\":\"DATA UNIT\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/#\\\/schema\\\/person\\\/73e7ceb9560a7d5782155c8e2170d013\",\"name\":\"dataunit\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5978f069d57b019dd8bfaf8562d4a843b785b9773bd799d825c6d3ea9d1009ee?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5978f069d57b019dd8bfaf8562d4a843b785b9773bd799d825c6d3ea9d1009ee?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5978f069d57b019dd8bfaf8562d4a843b785b9773bd799d825c6d3ea9d1009ee?s=96&d=mm&r=g\",\"caption\":\"dataunit\"},\"description\":\"Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography\",\"sameAs\":[\"https:\\\/\\\/dataunit.nadlotest.ch\"],\"url\":\"https:\\\/\\\/dataunit.nadlotest.ch\\\/en\\\/author\\\/dataunit\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating queries in SAP Business One | SQL &amp; HANA explained simply | DATA UNIT","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Creating queries in SAP Business One | SQL &amp; HANA explained simply | DATA UNIT","og_description":"&nbsp; In SAP Business One, you can create your own queries and lists directly from the database. Bruno shows: how the system information is used how to find tables and fields which assistants SAP B1 offers for this and how to build the first simple queries Ideal for anyone who wants to get more out [&hellip;]","og_url":"https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/","og_site_name":"DATA UNIT","article_published_time":"2024-12-02T07:36:48+00:00","article_modified_time":"2026-07-26T21:27:08+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/dataunit.nadlotest.ch\/wp-content\/uploads\/2024\/12\/maxresdefault-2.jpg","type":"image\/jpeg"}],"author":"dataunit","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dataunit","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/#article","isPartOf":{"@id":"https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/"},"author":{"name":"dataunit","@id":"https:\/\/dataunit.nadlotest.ch\/#\/schema\/person\/73e7ceb9560a7d5782155c8e2170d013"},"headline":"Creating queries in SAP Business One | SQL &amp; HANA explained simply","datePublished":"2024-12-02T07:36:48+00:00","dateModified":"2026-07-26T21:27:08+00:00","mainEntityOfPage":{"@id":"https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/"},"wordCount":82,"image":{"@id":"https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/#primaryimage"},"thumbnailUrl":"https:\/\/dataunit.nadlotest.ch\/wp-content\/uploads\/2024\/12\/maxresdefault-2.jpg","articleSection":["Tipps und Tricks","YouTube Video"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/","url":"https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/","name":"Creating queries in SAP Business One | SQL &amp; HANA explained simply | DATA UNIT","isPartOf":{"@id":"https:\/\/dataunit.nadlotest.ch\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/#primaryimage"},"image":{"@id":"https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/#primaryimage"},"thumbnailUrl":"https:\/\/dataunit.nadlotest.ch\/wp-content\/uploads\/2024\/12\/maxresdefault-2.jpg","datePublished":"2024-12-02T07:36:48+00:00","dateModified":"2026-07-26T21:27:08+00:00","author":{"@id":"https:\/\/dataunit.nadlotest.ch\/#\/schema\/person\/73e7ceb9560a7d5782155c8e2170d013"},"breadcrumb":{"@id":"https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/#primaryimage","url":"https:\/\/dataunit.nadlotest.ch\/wp-content\/uploads\/2024\/12\/maxresdefault-2.jpg","contentUrl":"https:\/\/dataunit.nadlotest.ch\/wp-content\/uploads\/2024\/12\/maxresdefault-2.jpg","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/dataunit.nadlotest.ch\/en\/2026\/07\/26\/abfragen-in-sap-business-one-erstellen-sql-hana-einfach-erklart\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Start","item":"https:\/\/dataunit.nadlotest.ch\/en\/"},{"@type":"ListItem","position":2,"name":"Creating queries in SAP Business One | SQL &amp; HANA explained simply"}]},{"@type":"WebSite","@id":"https:\/\/dataunit.nadlotest.ch\/#website","url":"https:\/\/dataunit.nadlotest.ch\/","name":"DATA UNIT","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dataunit.nadlotest.ch\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/dataunit.nadlotest.ch\/#\/schema\/person\/73e7ceb9560a7d5782155c8e2170d013","name":"dataunit","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/5978f069d57b019dd8bfaf8562d4a843b785b9773bd799d825c6d3ea9d1009ee?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5978f069d57b019dd8bfaf8562d4a843b785b9773bd799d825c6d3ea9d1009ee?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5978f069d57b019dd8bfaf8562d4a843b785b9773bd799d825c6d3ea9d1009ee?s=96&d=mm&r=g","caption":"dataunit"},"description":"Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography Biography","sameAs":["https:\/\/dataunit.nadlotest.ch"],"url":"https:\/\/dataunit.nadlotest.ch\/en\/author\/dataunit\/"}]}},"_links":{"self":[{"href":"https:\/\/dataunit.nadlotest.ch\/en\/wp-json\/wp\/v2\/posts\/111308","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dataunit.nadlotest.ch\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dataunit.nadlotest.ch\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dataunit.nadlotest.ch\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dataunit.nadlotest.ch\/en\/wp-json\/wp\/v2\/comments?post=111308"}],"version-history":[{"count":2,"href":"https:\/\/dataunit.nadlotest.ch\/en\/wp-json\/wp\/v2\/posts\/111308\/revisions"}],"predecessor-version":[{"id":111324,"href":"https:\/\/dataunit.nadlotest.ch\/en\/wp-json\/wp\/v2\/posts\/111308\/revisions\/111324"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dataunit.nadlotest.ch\/en\/wp-json\/wp\/v2\/media\/111309"}],"wp:attachment":[{"href":"https:\/\/dataunit.nadlotest.ch\/en\/wp-json\/wp\/v2\/media?parent=111308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dataunit.nadlotest.ch\/en\/wp-json\/wp\/v2\/categories?post=111308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dataunit.nadlotest.ch\/en\/wp-json\/wp\/v2\/tags?post=111308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}