{"id":1138,"date":"2013-12-05T13:06:48","date_gmt":"2013-12-05T12:06:48","guid":{"rendered":"http:\/\/blog.devportfolio.net\/?p=1138"},"modified":"2013-12-05T13:06:48","modified_gmt":"2013-12-05T12:06:48","slug":"passage-de-parametres-de-type-range-a-mon-composant-tsapinput","status":"publish","type":"post","link":"https:\/\/devportfolio.net\/wp-dev-blog\/passage-de-parametres-de-type-range-a-mon-composant-tsapinput\/","title":{"rendered":"Passage de param\u00e8tres de type RANGE \u00e0 mon composant tSapInput"},"content":{"rendered":"<p>Dans cet article nous allons :<\/p>\n<ul>\n<li>Cr\u00e9er une table ZDEVPORTFOLIO \u00e0 l&rsquo;aide de SE11,<\/li>\n<li>Renseigner 4\u00a0occurrences\u00a0de test dans cette table<\/li>\n<li>Cr\u00e9er la BAPI\u00a0ZRFC_DEVPORTFOLIO_RANGE<\/li>\n<li>Appeler la BAPI \u00e0 partie d&rsquo;un job TALEND Open Studio v4.2<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\"><strong>Cr\u00e9er la table ZDEVPORTFOLIO<\/strong><\/span><\/p>\n<p><a href=\"http:\/\/blog.devportfolio.net\/blog\/2012\/08\/06\/creer-une-table-sa-table-des-textes-et-generer-la-vue-de-gestion-associee\/\">http:\/\/blog.devportfolio.net\/blog\/2012\/08\/06\/creer-une-table-sa-table-des-textes-et-generer-la-vue-de-gestion-associee\/<\/a><\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Renseigner des donn\u00e9es dans la table ZDEVPORTFOLIO<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1164\" alt=\"4\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/4.jpg\" width=\"605\" height=\"214\" \/><\/a><span style=\"text-decoration: underline;\"><strong>SE37 &#8211; Cr\u00e9er la BAPI ZRFC_DEVPORTFOLIO_RANGE<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/DEV1100-Function-Builder-\u00e9cran-initial.jpg\"><img loading=\"lazy\" decoding=\"async\" alt=\"DEV(1)100 Function Builder  \u00e9cran initial\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/DEV1100-Function-Builder-\u00e9cran-initial.jpg\" width=\"419\" height=\"216\" \/><\/a><\/p>\n<p>Renseigner les param\u00e8tres suivants :<\/p>\n<p><span style=\"text-decoration: underline;\">Onglet <strong>Tables<\/strong><\/span><\/p>\n<p><em>T_DEVPORTFOLIO<\/em> est le param\u00e8tre de sortie, cette table \u00a0correspond \u00a0au r\u00e9sultat retourn\u00e9 pour la BAPI.<\/p>\n<p><a href=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1161\" alt=\"2\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/2.jpg\" width=\"593\" height=\"220\" \/><\/a><span style=\"text-decoration: underline;\">Onglet\u00a0<strong>Importation<\/strong><\/span><\/p>\n<p><em>T_RANGE_MATNR<\/em> est le param\u00e8tre d&rsquo;entr\u00e9e de la BAPI pour renseigner les enregistrements \u00e0 s\u00e9lectionner.<\/p>\n<p><a href=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/1.jpg\"><img loading=\"lazy\" decoding=\"async\" alt=\"1\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/1.jpg\" width=\"593\" height=\"223\" \/><\/a><\/p>\n<p>Le code source de la BAPI<\/p>\n<p><a href=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/3.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1162\" alt=\"3\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/3.jpg\" width=\"632\" height=\"330\" \/><\/a>Copier\/Coller le code suivant :<\/p>\n<pre>SELECT\n*\nFROM\nzdevportfolio\nINTO\u00a0TABLE\nt_devportfolio\nWHERE\nmatnr\u00a0IN\u00a0t_range_matnr.<\/pre>\n<p>Dans l&rsquo;onglet \u00ab\u00a0Propri\u00e9t\u00e9\u00a0\u00bb, S\u00e9lectionner \u00ab\u00a0Module accessible \u00e0 distance\u00a0\u00bb.<\/p>\n<p><a href=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/DEV1100-Function-Builder-\u00e9cran-initial4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1155\" alt=\"DEV(1)100 Function Builder  \u00e9cran initial4\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/DEV1100-Function-Builder-\u00e9cran-initial4.jpg\" width=\"625\" height=\"528\" \/><\/a><\/p>\n<p><strong>Enregistrer et compiler<\/strong><\/p>\n<p><span style=\"text-decoration: underline;\"><strong>TALEND &#8211; Cr\u00e9er un nouveau job<\/strong><\/span><\/p>\n<p>Glisser un composant tSapInput et un tLogRow sur la surface de travail.<\/p>\n<p><a href=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/8.jpg\"><img loading=\"lazy\" decoding=\"async\" alt=\"8\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/8.jpg\" width=\"523\" height=\"110\" \/><\/a><\/p>\n<p>Dans les param\u00e8tres du composant tSapInput :<\/p>\n<ul>\n<li>Renseigner le nom de la fonction \u00ab\u00a0ZRFC_DEVPORTFOLIO_RANGE\u00a0\u00bb.<\/li>\n<li>Renseigner les param\u00e8tres d&rsquo;entr\u00e9e comme d\u00e9taill\u00e9 sur l&rsquo;image ci-dessous. <em>Nous demandons \u00e0 lire les enregistrement <em>des articles 000001 et 000004\u00a0<\/em>dans la table ZDEVPORTFOLIO .<\/em><\/li>\n<\/ul>\n<blockquote><p>Pour info, le type <strong>input_table <\/strong>correspond aux param\u00e8tres d\u00e9clar\u00e9s dans l&rsquo;onglet <span style=\"text-decoration: underline;\"><em>Importation<\/em><\/span> dans <strong>SE37. <\/strong>Les param\u00e8tres d\u00e9clar\u00e9s dans l&rsquo;onglet <span style=\"text-decoration: underline;\"><em>Table<\/em><\/span> sont de type <strong>table_input<\/strong>.<\/p><\/blockquote>\n<p><a href=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/10.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1170\" alt=\"10\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/10.jpg\" width=\"703\" height=\"105\" \/><\/a><\/p>\n<ul>\n<li>Renseigner les param\u00e8tres de sortie comme d\u00e9taill\u00e9 sur l&rsquo;image ci-dessous :<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/9.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1167\" alt=\"7\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/7.jpg\" width=\"816\" height=\"66\" \/><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1169\" alt=\"9\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/9.jpg\" width=\"757\" height=\"159\" \/><\/a>Ex\u00e9cuter\u00a0le job :<\/p>\n<p><a href=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/11.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1172\" alt=\"11\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/12\/11.jpg\" width=\"383\" height=\"69\" \/><\/a>Le job retourne les prix des articles 000001 et 000004.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dans cet article nous allons : Cr\u00e9er une table ZDEVPORTFOLIO \u00e0 l&rsquo;aide de SE11, Renseigner 4\u00a0occurrences\u00a0de test dans cette table Cr\u00e9er la BAPI\u00a0ZRFC_DEVPORTFOLIO_RANGE Appeler la BAPI \u00e0 partie d&rsquo;un job TALEND Open Studio v4.2 Cr\u00e9er la table ZDEVPORTFOLIO http:\/\/blog.devportfolio.net\/blog\/2012\/08\/06\/creer-une-table-sa-table-des-textes-et-generer-la-vue-de-gestion-associee\/ Renseigner des donn\u00e9es dans la table ZDEVPORTFOLIO SE37 &#8211; Cr\u00e9er la BAPI ZRFC_DEVPORTFOLIO_RANGE Renseigner les param\u00e8tres [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,13],"tags":[],"class_list":["post-1138","post","type-post","status-publish","format-standard","hentry","category-sap","category-talend"],"_links":{"self":[{"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/posts\/1138","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/comments?post=1138"}],"version-history":[{"count":0,"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/posts\/1138\/revisions"}],"wp:attachment":[{"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/media?parent=1138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/categories?post=1138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/tags?post=1138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}