{"id":579,"date":"2013-01-09T11:11:09","date_gmt":"2013-01-09T10:11:09","guid":{"rendered":"http:\/\/blog.devportfolio.net\/?p=579"},"modified":"2013-01-09T11:11:09","modified_gmt":"2013-01-09T10:11:09","slug":"utiliser-rfc_read_table-avec-le-composant-tsapinput","status":"publish","type":"post","link":"https:\/\/devportfolio.net\/wp-dev-blog\/utiliser-rfc_read_table-avec-le-composant-tsapinput\/","title":{"rendered":"Utiliser RFC_READ_TABLE avec le composant tSAPInput"},"content":{"rendered":"<p><span style=\"text-decoration: underline;\"><strong>1\u00a0\u2013 TALEND &#8211; Cr\u00e9er un nouveau Job TALEND<\/strong><\/span><\/p>\n<p>Ce job s\u00e9lectionne les occurrences dans la table standard SAP <strong>TADIR<\/strong> et liste l&rsquo;ensemble des objets sp\u00e9cifiques (OBJ_NAME LIKE &lsquo;Z%&rsquo;).<\/p>\n<p>a) Cr\u00e9er le job \u00ab RFC_READ_TABLE \u00bb et glisser 3 composants sur la surface de travail :<\/p>\n<ul>\n<li>tSapConnexion<\/li>\n<li>tSAPInput<\/li>\n<li>tLogRow<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-580\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/RFC_READ_TABLE_1.jpg\" alt=\"RFC_READ_TABLE_1\" width=\"703\" height=\"284\" \/><\/p>\n<p>b) Saisir les param\u00e8tres du composant tSAPInput<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-581\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/RFC_READ_TABLE_2.jpg\" alt=\"RFC_READ_TABLE_2\" width=\"675\" height=\"369\" \/><\/p>\n<p>Les param\u00e8tres d&rsquo;entr\u00e9e du premier tableau correspondent aux param\u00e8tres pass\u00e9 \u00e0 la BAPI <strong>RFC_READ_TABLE<\/strong> :<\/p>\n<ul>\n<li>Le premier param\u00e8tres <strong>QUERY_TABLE<\/strong> attend le nom de la table sur laquelle doit \u00eatre ex\u00e9cut\u00e9e la requ\u00eate. Dans notre cas il s&rsquo;agit de la table <strong>TADIR<\/strong>.<\/li>\n<li>Le deuxi\u00e8me param\u00e8tre <strong>FIELDS<\/strong> attend le nom de la ou des colonnes \u00e0 extraire (Liste des noms de colonne s\u00e9par\u00e9s par les virgules). Seuls les valeurs de cette colonne seront ramen\u00e9es. Dans notre cas il s&rsquo;agit de la colonne TADIR-<strong>OBJ_NAME<\/strong>. Il est conseill\u00e9 de limiter le nombre de colonne en sortie car la structure de retour WA est limit\u00e9 \u00e0 512 caract\u00e8res.<\/li>\n<li>Le troisi\u00e8me param\u00e8tre <strong>OPTIONS<\/strong> correspond aux filtres appliqu\u00e9s \u00e0 la requ\u00eate. Dans notre cas on demande d&rsquo;extraire les objets sp\u00e9cifiques <strong>OBJ_NAME LIKE &lsquo;Z%&rsquo;<\/strong>.<\/li>\n<\/ul>\n<p>Les param\u00e8tres de sortie du deuxi\u00e8me tableau correspondent aux valeurs retourn\u00e9s par la BAPI <strong>RFC_READ_TABLE<\/strong> :<\/p>\n<ul>\n<li><strong>VBAK<\/strong> est le sch\u00e9ma de sortie. Dans notre cas c&rsquo;est un STRING<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-633\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/RFC_READ_TABLE_4.jpg\" alt=\"RFC_READ_TABLE_4\" width=\"556\" height=\"136\" \/><\/li>\n<li><strong>DATA<\/strong> est le nom du param\u00e8tre de sortie et <strong>WA<\/strong> est le type de structure du param\u00e8tre <strong>DATA<\/strong>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-634\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/RFC_READ_TABLE_5.jpg\" alt=\"RFC_READ_TABLE_5\" width=\"762\" height=\"147\" \/><\/li>\n<\/ul>\n<p>d) Ex\u00e9cuter le job<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-583\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/RFC_READ_TABLE_3.jpg\" alt=\"RFC_READ_TABLE_3\" width=\"564\" height=\"503\" \/><\/p>\n<p>Les param\u00e8tres de type input_table peuvent \u00eatre pass\u00e9 de la mani\u00e8re suivante :<\/p>\n<pre class=\"\">Copier cette instruction : \"OBJ_NAME\",\"AUTHOR\"<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1\u00a0\u2013 TALEND &#8211; Cr\u00e9er un nouveau Job TALEND Ce job s\u00e9lectionne les occurrences dans la table standard SAP TADIR et liste l&rsquo;ensemble des objets sp\u00e9cifiques (OBJ_NAME LIKE &lsquo;Z%&rsquo;). a) Cr\u00e9er le job \u00ab RFC_READ_TABLE \u00bb et glisser 3 composants sur la surface de travail : tSapConnexion tSAPInput tLogRow b) Saisir les param\u00e8tres du composant tSAPInput [&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-579","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\/579","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=579"}],"version-history":[{"count":0,"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/posts\/579\/revisions"}],"wp:attachment":[{"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/media?parent=579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/categories?post=579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/tags?post=579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}