{"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 wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\">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-fe48e5de 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}]}}