{"id":3801,"date":"2018-05-28T15:49:44","date_gmt":"2018-05-28T15:49:44","guid":{"rendered":"https:\/\/www.int4.com\/?p=1532"},"modified":"2020-05-18T15:31:06","modified_gmt":"2020-05-18T13:31:06","slug":"how-to-create-a-single-index-table-in-sap-aif","status":"publish","type":"post","link":"https:\/\/test11988.futurehost.pl\/how-to-create-a-single-index-table-in-sap-aif","title":{"rendered":"How to create a single index table in SAP AIF?"},"content":{"rendered":"
<\/p>\n

Single index table in SAP AIF<\/h2>\n<\/span>\n

Have you ever heard about single index table in SAP AIF<\/strong>? Have you ever encountered the issue while you were looking for a specific message in Monitoring and Error Handling? Let’s imagine the situation, that you receive tons of inbound messages every single day and you want to find a message with a specific purchase order number in your AIF Interface, but you don’t know what is the AIF message ID that contains this specific Purchase Order number.<\/p>\n

Here, single index table in SAP AIF<\/strong> with custom selection screen for the interface come to help us!<\/p>\n<\/div>\n

In this post, I will guide you how to create a select index table, create a module pool program and configure index table and the selection screen for the inbound sales order interface in SAP AIF.<\/p>\n

How to create Single Index table?<\/h3>\n

First of all, we have to create a single index table by copying template table: \/AIF\/STD_IDX_TBL<\/em><\/strong>.\u00a0<\/em>At the end of the table add additional field representing purchase order number.<\/p>\n

 <\/p>\n

\"Single<\/a>

Single Index table in SAP AIF – created based on a template<\/em><\/p><\/div>\n

 <\/p>\n

Selection Screen preparation<\/h3>\n

Now go to SE38<\/strong>\u00a0transaction code and create module pool program type, that will be used for selection screen extension in AIF Monitor and Error Handling.<\/p>\n

Please see the code snippet you can use for your program:<\/p>\n

PROGRAM\u00a0ZAIF_SEL_SCREEN_0001.<\/em>
\nDATA:\u00a0gv_po_num\u00a0TYPE\u00a0bstkd.<\/em><\/p>\n

SELECTION-SCREEN\u00a0BEGIN\u00a0OF\u00a0SCREEN\u00a00001\u00a0AS\u00a0SUBSCREEN.<\/em>
\nSELECT-OPTIONS:<\/em>
\n\u00a0\u00a0\u00a0\u00a0s_po\u00a0FOR\u00a0gv_po_num.<\/em>
\nSELECTION-SCREEN\u00a0END\u00a0OF\u00a0SCREEN\u00a00001.<\/em><\/p>\n

AT\u00a0SELECTION-SCREEN\u00a0OUTPUT.<\/em>
\n\u00a0\u00a0\/aif\/cl_global_tools=>get_value_from_mem(\u00a0).<\/em><\/p><\/blockquote>\n

 <\/p>\n

SAP AIF Customization steps<\/h3>\n

Now go to \u00a0Define Namespace-Specific Features <\/em><\/strong>in AIF Customizing. Make an entry as shown in the below screenshot:<\/p>\n

\"SAP<\/a>

SAP AIF – Namespace Specific Entries for Single Index Table<\/em><\/p><\/div>\n

 <\/p>\n

Now from the AIF Customizing open\u00a0 Define Interface<\/strong>–Specific features<\/strong> and in node Define Key Fields for Multi. Search make an entry as below, where BSTKD<\/strong> is a key field name in your Index Table and S_PO<\/strong> is your parameter from selection program. E1EDK01-BELNR<\/strong> will be the source field.<\/p>\n

\"SAP<\/a>

SAP AIF – Interface Specific entries necessary for Single Index Table<\/em><\/p><\/div>\n

 <\/p>\n

Congratulations! Right now you can go to AIF Monitor and Error Handling and search messages by specific Purchase Order Number
\nWant to learn more about indexing in SAP AIF<\/strong>? Check other articles about SAP AIF on Int4 blog.<\/a><\/strong><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Speed up your monitoring process by using single index table in SAP AIF! <\/p>\n","protected":false},"author":10,"featured_media":5673,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":""},"categories":[1],"tags":[53,30],"acf":[],"yoast_head":"\nHow to create a single index table in SAP AIF? - INT4<\/title>\n<meta name=\"description\" content=\"Have you ever heard about single index table in SAP AIF? Have you ever encountered the issue while you were looking for a specific message in Monitoring and Error Handling?\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to create a single index table in SAP AIF? - INT4\" \/>\n<meta property=\"og:description\" content=\"Have you ever heard about single index table in SAP AIF? Have you ever encountered the issue while you were looking for a specific message in Monitoring and Error Handling?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test11988.futurehost.pl\/how-to-create-a-single-index-table-in-sap-aif\" \/>\n<meta property=\"og:site_name\" content=\"INT4\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-28T15:49:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-18T13:31:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test11988.futurehost.pl\/wp-content\/uploads\/2018\/05\/SAP_AIF_How_to_create_single_index_table_Nowak.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"627\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Mateusz Nowak\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mateusz Nowak\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test11988.futurehost.pl\/how-to-create-a-single-index-table-in-sap-aif\",\"url\":\"https:\/\/test11988.futurehost.pl\/how-to-create-a-single-index-table-in-sap-aif\",\"name\":\"How to create a single index table in SAP AIF? - INT4\",\"isPartOf\":{\"@id\":\"https:\/\/test11988.futurehost.pl\/#website\"},\"datePublished\":\"2018-05-28T15:49:44+00:00\",\"dateModified\":\"2020-05-18T13:31:06+00:00\",\"author\":{\"@id\":\"https:\/\/test11988.futurehost.pl\/#\/schema\/person\/87c3e874c8211745f3806c3a529d627d\"},\"description\":\"Have you ever heard about single index table in SAP AIF? Have you ever encountered the issue while you were looking for a specific message in Monitoring and Error Handling?\",\"breadcrumb\":{\"@id\":\"https:\/\/test11988.futurehost.pl\/how-to-create-a-single-index-table-in-sap-aif#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test11988.futurehost.pl\/how-to-create-a-single-index-table-in-sap-aif\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test11988.futurehost.pl\/how-to-create-a-single-index-table-in-sap-aif#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test11988.futurehost.pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to create a single index table in SAP AIF?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test11988.futurehost.pl\/#website\",\"url\":\"https:\/\/test11988.futurehost.pl\/\",\"name\":\"INT4\",\"description\":\"Your soft landing in SAP API testing\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test11988.futurehost.pl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/test11988.futurehost.pl\/#\/schema\/person\/87c3e874c8211745f3806c3a529d627d\",\"name\":\"Mateusz Nowak\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/test11988.futurehost.pl\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/85470b120bc6761f1327d06134c7289a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/85470b120bc6761f1327d06134c7289a?s=96&d=mm&r=g\",\"caption\":\"Mateusz Nowak\"},\"description\":\"SAP Integration consultant since 2016. Mateusz is the author of SAP Press Book: Interface Monitoring and Error Handling with SAP AIF. He's also a trainer in the openSAP course Virtualize and Automate Your SAP Testing Using Int4 IFTT. Matt has been involved in multiple integrational projects as ABAP Developer, AIF lead and consultant. Skilled at a variety of tools and development techniques including ABAP, AIF, PO, BRFplus, IDocs, Adobe Forms, Smartforms, IDocs, ALE, SCPI.\",\"url\":\"https:\/\/test11988.futurehost.pl\/author\/mnow\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to create a single index table in SAP AIF? - INT4","description":"Have you ever heard about single index table in SAP AIF? Have you ever encountered the issue while you were looking for a specific message in Monitoring and Error Handling?","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_GB","og_type":"article","og_title":"How to create a single index table in SAP AIF? - INT4","og_description":"Have you ever heard about single index table in SAP AIF? Have you ever encountered the issue while you were looking for a specific message in Monitoring and Error Handling?","og_url":"https:\/\/test11988.futurehost.pl\/how-to-create-a-single-index-table-in-sap-aif","og_site_name":"INT4","article_published_time":"2018-05-28T15:49:44+00:00","article_modified_time":"2020-05-18T13:31:06+00:00","og_image":[{"width":"1200","height":"627","url":"https:\/\/test11988.futurehost.pl\/wp-content\/uploads\/2018\/05\/SAP_AIF_How_to_create_single_index_table_Nowak.png","type":"image\/png"}],"author":"Mateusz Nowak","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mateusz Nowak","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/test11988.futurehost.pl\/how-to-create-a-single-index-table-in-sap-aif","url":"https:\/\/test11988.futurehost.pl\/how-to-create-a-single-index-table-in-sap-aif","name":"How to create a single index table in SAP AIF? - INT4","isPartOf":{"@id":"https:\/\/test11988.futurehost.pl\/#website"},"datePublished":"2018-05-28T15:49:44+00:00","dateModified":"2020-05-18T13:31:06+00:00","author":{"@id":"https:\/\/test11988.futurehost.pl\/#\/schema\/person\/87c3e874c8211745f3806c3a529d627d"},"description":"Have you ever heard about single index table in SAP AIF? Have you ever encountered the issue while you were looking for a specific message in Monitoring and Error Handling?","breadcrumb":{"@id":"https:\/\/test11988.futurehost.pl\/how-to-create-a-single-index-table-in-sap-aif#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test11988.futurehost.pl\/how-to-create-a-single-index-table-in-sap-aif"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/test11988.futurehost.pl\/how-to-create-a-single-index-table-in-sap-aif#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test11988.futurehost.pl\/"},{"@type":"ListItem","position":2,"name":"How to create a single index table in SAP AIF?"}]},{"@type":"WebSite","@id":"https:\/\/test11988.futurehost.pl\/#website","url":"https:\/\/test11988.futurehost.pl\/","name":"INT4","description":"Your soft landing in SAP API testing","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test11988.futurehost.pl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/test11988.futurehost.pl\/#\/schema\/person\/87c3e874c8211745f3806c3a529d627d","name":"Mateusz Nowak","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/test11988.futurehost.pl\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/85470b120bc6761f1327d06134c7289a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/85470b120bc6761f1327d06134c7289a?s=96&d=mm&r=g","caption":"Mateusz Nowak"},"description":"SAP Integration consultant since 2016. Mateusz is the author of SAP Press Book: Interface Monitoring and Error Handling with SAP AIF. He's also a trainer in the openSAP course Virtualize and Automate Your SAP Testing Using Int4 IFTT. Matt has been involved in multiple integrational projects as ABAP Developer, AIF lead and consultant. Skilled at a variety of tools and development techniques including ABAP, AIF, PO, BRFplus, IDocs, Adobe Forms, Smartforms, IDocs, ALE, SCPI.","url":"https:\/\/test11988.futurehost.pl\/author\/mnow"}]}},"_links":{"self":[{"href":"https:\/\/test11988.futurehost.pl\/wp-json\/wp\/v2\/posts\/3801"}],"collection":[{"href":"https:\/\/test11988.futurehost.pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test11988.futurehost.pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test11988.futurehost.pl\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/test11988.futurehost.pl\/wp-json\/wp\/v2\/comments?post=3801"}],"version-history":[{"count":0,"href":"https:\/\/test11988.futurehost.pl\/wp-json\/wp\/v2\/posts\/3801\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test11988.futurehost.pl\/wp-json\/wp\/v2\/media\/5673"}],"wp:attachment":[{"href":"https:\/\/test11988.futurehost.pl\/wp-json\/wp\/v2\/media?parent=3801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test11988.futurehost.pl\/wp-json\/wp\/v2\/categories?post=3801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test11988.futurehost.pl\/wp-json\/wp\/v2\/tags?post=3801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}