{"id":550,"date":"2013-01-08T11:43:43","date_gmt":"2013-01-08T10:43:43","guid":{"rendered":"http:\/\/blog.devportfolio.net\/?p=550"},"modified":"2013-01-08T11:43:43","modified_gmt":"2013-01-08T10:43:43","slug":"utiliser-le-composant-tsapoutput-pour-mettre-a-jour-une-table-specifique-sap","status":"publish","type":"post","link":"https:\/\/devportfolio.net\/wp-dev-blog\/utiliser-le-composant-tsapoutput-pour-mettre-a-jour-une-table-specifique-sap\/","title":{"rendered":"Utiliser le composant tSapOutput pour mettre \u00e0 jour une table sp\u00e9cifique SAP"},"content":{"rendered":"<p><strong>1 \u2013 SE11 &#8211; Cr\u00e9er la table sp\u00e9cifique<\/strong> <\/p>\n<p>a)\tCr\u00e9er une table applicative ZDEVPORTFOLIO dans SE11<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/SE11-Creer-Table-A.png\" alt=\"SE11-Creer Table-A\" width=\"427\" height=\"383\" class=\"aligncenter size-full wp-image-552\" \/><\/p>\n<p>b)\tCr\u00e9er les quatre zones suivantes et activez la table<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/SE11-Creer-Table-B.png\" alt=\"SE11-Creer Table-B\" width=\"843\" height=\"335\" class=\"aligncenter size-full wp-image-553\" \/><\/p>\n<p>Suivre l\u2019article <a href=\"http:\/\/blog.devportfolio.net\/blog\/2012\/08\/06\/creer-une-table-sa-table-des-textes-et-generer-la-vue-de-gestion-associee\/\" title=\"Cr\u00e9er un table SAP\" target=\"_blank\" rel=\"noopener noreferrer\">Cr\u00e9er une table et &#8230;<\/a> pour plus d&rsquo;infos.<\/p>\n<p><strong>2 \u2013 SE37 &#8211; Cr\u00e9er la BAPI  sp\u00e9cifique <\/strong><\/p>\n<p>a)\tNommer la BAPI ZRFC_DEVPORTFOLIO et cliquer sur le bouton \u00ab Cr\u00e9er \u00bb<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/SE37-Creer-BAPI-A.png\" alt=\"SE37-Creer BAPI-A\" width=\"401\" height=\"213\" class=\"aligncenter size-full wp-image-555\" \/><\/p>\n<p>b)\tdans l\u2019onglet \u00ab Importation \u00bb d\u00e9finir le param\u00e8tre d\u2019import \u00ab W_ZDEVPORTFOLIO \u00bb de type ZDEVPORTFOLIO et cocher l\u2019option \u00ab Passage par valeur \u00bb.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/SE37-Creer-BAPI-B.png\" alt=\"SE37-Creer BAPI-B\" width=\"797\" height=\"235\" class=\"aligncenter size-full wp-image-556\" \/><\/p>\n<p>c)\tImpl\u00e9menter le code dans l\u2019onglet \u00ab Source \u00bb<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/SE37-Creer-BAPI-C.png\" alt=\"SE37-Creer BAPI-C\" width=\"587\" height=\"749\" class=\"aligncenter size-full wp-image-557\" \/><\/p>\n<blockquote><p>\n<code><br \/>\n<strong>FUNCTION zrfc_devportfolio<\/strong>.<br \/>\n*\"-----------------------------------------------------<br \/>\n*\"*\"Interface locale :<br \/>\n*\"  IMPORTING<br \/>\n*\"     VALUE(W_ZDEVPORTFOLIO) TYPE  ZDEVPORTFOLIO<br \/>\n*\"  EXCEPTIONS<br \/>\n*\"      NOT_AUTHORIZED<br \/>\n*\"      TABLE_NOT_AVAILABLE<br \/>\n*\"      ERROR_ON_UPDATE<br \/>\n*\"-----------------------------------------------------<br \/>\n* contr\u00f4le des autorisations d'update.<br \/>\n  CALL FUNCTION 'VIEW_AUTHORITY_CHECK'<br \/>\n    EXPORTING<br \/>\n      view_action                    = 'U'<br \/>\n      view_name                      = 'ZDEVPORTFOLIO'<br \/>\n    EXCEPTIONS<br \/>\n      no_authority                   = 2<br \/>\n      no_clientindependent_authority = 2<br \/>\n      no_linedependent_authority     = 2<br \/>\n      OTHERS                         = 1.<\/p>\n<p>  IF sy-subrc = 2.<br \/>\n    RAISE not_authorized.<br \/>\n  ELSEIF sy-subrc = 1.<br \/>\n    RAISE table_not_available.<br \/>\n  ENDIF.<\/p>\n<p>  MODIFY zdevportfolio FROM w_zdevportfolio.<\/p>\n<p>  IF sy-subrc NE 0.<br \/>\n    RAISE error_on_update.<br \/>\n  ENDIF.<br \/>\n<strong>ENDFUNCTION<\/strong>.<br \/>\n<\/code>\n<\/p><\/blockquote>\n<p>d)\tDans l\u2019onglet \u00ab Propri\u00e9t\u00e9s \u00bb cocher l\u2019option \u00ab Module accessible \u00e0 distance \u00bb et activer la BAPI<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/SE37-Creer-BAPI-D.png\" alt=\"SE37-Creer BAPI-D\" width=\"622\" height=\"524\" class=\"aligncenter size-full wp-image-558\" \/><\/p>\n<p><strong>3 \u2013 TALEND &#8211; Cr\u00e9er un nouveau Job TALEND<\/strong><\/p>\n<p>a)\tCr\u00e9er le job \u00ab JOB_DEVPORTFOLIO \u00bb et glisser 3 composants sur la surface de travail :<\/p>\n<ul>\n<li>tSapConnexion<\/li>\n<li>tFileInput<\/li>\n<li>tSAPOutput<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/TALEND-Creer-Job-A.png\" alt=\"TALEND-Creer Job-A\" width=\"512\" height=\"410\" class=\"aligncenter size-full wp-image-559\" \/><\/p>\n<p>b)\tCr\u00e9er le fichier TOTO.csv  avec le sch\u00e9ma suivant<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/TALEND-Creer-Job-B.png\" alt=\"TALEND-Creer Job-B\" width=\"538\" height=\"275\" class=\"aligncenter size-full wp-image-560\" \/><\/p>\n<p>et alimenter le fichier par les valeurs suivantes :<\/p>\n<blockquote>\n<pre>\n000000000000000001;10.54;EUR\n000000000000000002;3.80;EUR\n000000000000000003;6.30;EUR\n<\/pre>\n<\/blockquote>\n<p>c)\tSaisir les param\u00e8tres du composant tSAPOutput<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/TALEND-Creer-Job-C.png\" alt=\"TALEND-Creer Job-C\" width=\"619\" height=\"165\" class=\"aligncenter size-full wp-image-551\" \/><\/p>\n<p>d)\tEx\u00e9cuter le job <\/p>\n<p><strong>4 \u2013 SE16N \u2013 Valider la cr\u00e9ation des occurrences dans ZDEVPORTFOLIO<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/devportfolio.net\/wp-dev-blog\/wp-content\/uploads\/2013\/01\/SE16N-Valider-occurences.png\" alt=\"SE16N-Valider occurences\" width=\"588\" height=\"287\" class=\"aligncenter size-full wp-image-554\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1 \u2013 SE11 &#8211; Cr\u00e9er la table sp\u00e9cifique a) Cr\u00e9er une table applicative ZDEVPORTFOLIO dans SE11 b) Cr\u00e9er les quatre zones suivantes et activez la table Suivre l\u2019article Cr\u00e9er une table et &#8230; pour plus d&rsquo;infos. 2 \u2013 SE37 &#8211; Cr\u00e9er la BAPI sp\u00e9cifique a) Nommer la BAPI ZRFC_DEVPORTFOLIO et cliquer sur le bouton \u00ab [&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":[33,34,35,14,36],"class_list":["post-550","post","type-post","status-publish","format-standard","hentry","category-sap","category-talend","tag-appels-disatants","tag-rfc","tag-sap-2","tag-talend","tag-tsapoutput"],"_links":{"self":[{"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/posts\/550","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=550"}],"version-history":[{"count":0,"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/posts\/550\/revisions"}],"wp:attachment":[{"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/media?parent=550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/categories?post=550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devportfolio.net\/wp-dev-blog\/wp-json\/wp\/v2\/tags?post=550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}