{"id":2853,"date":"2024-07-12T12:59:49","date_gmt":"2024-07-12T10:59:49","guid":{"rendered":"https:\/\/www.clavis.biz\/?page_id=2853"},"modified":"2024-09-10T14:53:16","modified_gmt":"2024-09-10T12:53:16","slug":"itsmobile-2","status":"publish","type":"page","link":"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/","title":{"rendered":"Left outer join"},"content":{"rendered":"\n<div class=\"wp-block-cover alignfull\" style=\"min-height:320px;aspect-ratio:unset;\"><span aria-hidden=\"true\" class=\"wp-block-cover__background has-nv-site-bg-background-color has-background-dim-100 has-background-dim\"><\/span><div class=\"wp-block-cover__inner-container is-layout-flow wp-block-cover-is-layout-flow\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading has-text-align-left has-neve-text-color-color has-text-color\">Selection of languages via left outer join<\/h2>\n\n\n\n<p class=\"has-neve-text-color-color has-text-color has-link-color wp-elements-03c6da7d875f7e8f2c79f6c65a820041\">Many ABAP developers will be familiar with this problem: In the case of a complex join across several tables, no data is returned in the result, even though all data is maintained in the main table and the other data is only accessed via LEFT OUTER JOIN. At least the data from the main table should therefore be found reliably. In these cases, the language key in the JOINs may be responsible for this.<\/p>\n\n\n\n<p class=\"has-neve-text-color-color has-text-color has-link-color wp-elements-4c53d8f5a56e749557f72f42d811208c\">If a table with a language key is accessed in a SELECT with a LEFT OUTER JOIN, it is decisive at which point the language is queried. If a label has not been translated for all languages, the data query returns no data. However, the aim is that in this case at least all other fields are returned, except for the description.<\/p>\n\n\n\n<p class=\"has-neve-text-color-color has-text-color has-link-color wp-elements-7c2f55d6f3a2a66dd3cd93246138d623\">Example: A material and its description are to be selected from the MARA and MAKT tables. In addition to the material number, the description in the logon language should be returned (query via sy-langu).<\/p>\n\n\n\n<p class=\"has-neve-text-color-color has-text-color has-link-color wp-elements-11be4b19c905f794c0c7dacecf6658ac\">If no description has been maintained in the logon language, at least the material number should still be returned.<\/p>\n\n\n\n<p class=\"has-neve-text-color-color has-text-color has-link-color wp-elements-b968af780bda50c72daba88e17b5bf99\">To do this, the language key must be queried in the ON condition and not in the WHERE condition!<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full has-custom-border\"><img loading=\"lazy\" decoding=\"async\" width=\"689\" height=\"383\" src=\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/07\/Left_Outer_Join.png\" alt=\"\" class=\"has-border-color has-neve-text-color-border-color wp-image-2857\" style=\"border-width:1px\" srcset=\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/07\/Left_Outer_Join.png 689w, https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/07\/Left_Outer_Join-300x167.png 300w\" sizes=\"auto, (max-width: 689px) 100vw, 689px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"has-neve-text-color-color has-text-color has-link-color wp-elements-db60e8a6d0e2333f2a1eae828a244092\">Then a LEFT OUTER JOIN will also return something from the main table (MARA-MATNR) if no description has been maintained in the appropriate language (in the MAKT). However, if the language is queried in the WHERE, the material number is not found in the MARA either. However, this is not desirable with a LEFT JOIN!<\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div><\/div>\n<\/div><\/div>\n\n<div class=\"wp-block-cover alignfull\" style=\"min-height:300px;aspect-ratio:unset;\"><span aria-hidden=\"true\" class=\"wp-block-cover__background has-nv-dark-bg-background-color has-background-dim-100 has-background-dim\"><\/span><div class=\"wp-block-cover__inner-container is-layout-flow wp-block-cover-is-layout-flow\">\n<div style=\"height:80px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"wp-block-image is-style-rounded\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"285\" height=\"285\" src=\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/cl_orange_Informationen.png\" alt=\"\" class=\"wp-image-765\" style=\"width:80px;height:80px\" srcset=\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/cl_orange_Informationen.png 285w, https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/cl_orange_Informationen-150x150.png 150w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><\/figure>\n<\/div>\n\n\n<div style=\"height:24px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-text-align-center has-nv-text-dark-bg-color has-text-color\">Do you have any questions?<br\/>Get in touch with us.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button is-style-default\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.clavis.biz\/en\/contact\/\">CONTACT<\/a><\/div>\n<\/div>\n\n\n\n<div style=\"height:80px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":982,"parent":2866,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"neve_meta_sidebar":"default","neve_meta_container":"","neve_meta_enable_content_width":"on","neve_meta_content_width":100,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"off","neve_meta_reading_time":"","_ti_tpc_template_sync":false,"_ti_tpc_template_id":"","footnotes":""},"class_list":["post-2853","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Selection of languages via left outer join<\/title>\n<meta name=\"description\" content=\"Why is no data returned for a left outer join across multiple tables? We provide the answer.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Selection of languages via left outer join\" \/>\n<meta property=\"og:description\" content=\"Why is no data returned for a left outer join across multiple tables? We provide the answer.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/\" \/>\n<meta property=\"og:site_name\" content=\"clavis berater soziet\u00e4t\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-10T12:53:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund_TipsTricks_Pixabay_sparks-692122.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1270\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/\",\"url\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/\",\"name\":\"Selection of languages via left outer join\",\"isPartOf\":{\"@id\":\"https:\/\/www.clavis.biz\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund_TipsTricks_Pixabay_sparks-692122.jpg\",\"datePublished\":\"2024-07-12T10:59:49+00:00\",\"dateModified\":\"2024-09-10T12:53:16+00:00\",\"description\":\"Why is no data returned for a left outer join across multiple tables? We provide the answer.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/#primaryimage\",\"url\":\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund_TipsTricks_Pixabay_sparks-692122.jpg\",\"contentUrl\":\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund_TipsTricks_Pixabay_sparks-692122.jpg\",\"width\":1920,\"height\":1270,\"caption\":\"SAP-TippsTricks_Image\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Start\",\"item\":\"https:\/\/www.clavis.biz\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SAP Technologies\",\"item\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SAP Tipps and Hints\",\"item\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Left outer join\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.clavis.biz\/en\/#website\",\"url\":\"https:\/\/www.clavis.biz\/en\/\",\"name\":\"clavis berater soziet\u00e4t\",\"description\":\"Beratung f\u00fcr SAP, mobile Anwendungen und Web-Entwicklung\",\"publisher\":{\"@id\":\"https:\/\/www.clavis.biz\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.clavis.biz\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.clavis.biz\/en\/#organization\",\"name\":\"clavis berater soziet\u00e4t\",\"url\":\"https:\/\/www.clavis.biz\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.clavis.biz\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/clavis-Logo_M.png\",\"contentUrl\":\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/clavis-Logo_M.png\",\"width\":441,\"height\":200,\"caption\":\"clavis berater soziet\u00e4t\"},\"image\":{\"@id\":\"https:\/\/www.clavis.biz\/en\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Selection of languages via left outer join","description":"Why is no data returned for a left outer join across multiple tables? We provide the answer.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/","og_locale":"en_US","og_type":"article","og_title":"Selection of languages via left outer join","og_description":"Why is no data returned for a left outer join across multiple tables? We provide the answer.","og_url":"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/","og_site_name":"clavis berater soziet\u00e4t","article_modified_time":"2024-09-10T12:53:16+00:00","og_image":[{"width":1920,"height":1270,"url":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund_TipsTricks_Pixabay_sparks-692122.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/","url":"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/","name":"Selection of languages via left outer join","isPartOf":{"@id":"https:\/\/www.clavis.biz\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/#primaryimage"},"image":{"@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund_TipsTricks_Pixabay_sparks-692122.jpg","datePublished":"2024-07-12T10:59:49+00:00","dateModified":"2024-09-10T12:53:16+00:00","description":"Why is no data returned for a left outer join across multiple tables? We provide the answer.","breadcrumb":{"@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/#primaryimage","url":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund_TipsTricks_Pixabay_sparks-692122.jpg","contentUrl":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund_TipsTricks_Pixabay_sparks-692122.jpg","width":1920,"height":1270,"caption":"SAP-TippsTricks_Image"},{"@type":"BreadcrumbList","@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/itsmobile-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Start","item":"https:\/\/www.clavis.biz\/en\/"},{"@type":"ListItem","position":2,"name":"SAP Technologies","item":"https:\/\/www.clavis.biz\/en\/sap-technologies\/"},{"@type":"ListItem","position":3,"name":"SAP Tipps and Hints","item":"https:\/\/www.clavis.biz\/en\/sap-technologies\/sap-tipps-and-hints\/"},{"@type":"ListItem","position":4,"name":"Left outer join"}]},{"@type":"WebSite","@id":"https:\/\/www.clavis.biz\/en\/#website","url":"https:\/\/www.clavis.biz\/en\/","name":"clavis berater soziet\u00e4t","description":"Beratung f\u00fcr SAP, mobile Anwendungen und Web-Entwicklung","publisher":{"@id":"https:\/\/www.clavis.biz\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.clavis.biz\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.clavis.biz\/en\/#organization","name":"clavis berater soziet\u00e4t","url":"https:\/\/www.clavis.biz\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.clavis.biz\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/clavis-Logo_M.png","contentUrl":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/clavis-Logo_M.png","width":441,"height":200,"caption":"clavis berater soziet\u00e4t"},"image":{"@id":"https:\/\/www.clavis.biz\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/pages\/2853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/comments?post=2853"}],"version-history":[{"count":5,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/pages\/2853\/revisions"}],"predecessor-version":[{"id":3742,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/pages\/2853\/revisions\/3742"}],"up":[{"embeddable":true,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/pages\/2866"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/media\/982"}],"wp:attachment":[{"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/media?parent=2853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}