SAP AIF multi index and single index tables<\/strong><\/h2>\n<\/span>\nHi there! In this blog I will show you how you can use SAP AIF<\/strong> multi index table and single index tables in your interfaces.<\/p>\nThis blog is the extension of the previous blog: How To Create a Single Index Table in SAP AIF<\/a> and therefore some steps will be explained in a more general way. You can always visit the previous blog in case you occur any issues with details, but I believe that you won’t have any problems, as you mastered this knowledge last time reading the previous blog! \ud83d\ude42<\/p>\n<\/div>\nMultiple selection index tables are used in situations you want to create additional selection screen for the values, that appear more than once in a single message (for example plant ID on item level or material number in Sales Order).<\/p>\n
In this blog I will show you how to use multiple index table to handle selection for the material number in inbound IDoc sales order interface in IDoc segment E1EDP01-E1EDP19-IDTNR.\u00a0<\/strong><\/p>\nHow to create SAP AIF multi index table?<\/h3>\n
First of all, you have to create an additional table based on a template table: \/AIF\/MIDX_TEMPL<\/strong>\u00a0\u00a0<\/strong>in transaction SE11<\/strong>. Once you created the table, add a field MATNR <\/strong>at the end of the table with type MATNR, <\/strong>in the same way, you did it for single index table. In addition, you will see, that this template table contains\u00a0another field COUNTER, <\/strong>that has our favourite data type: INT4 <\/strong>\ud83d\ude42 This field is added right after MSGUID <\/strong>field and has to be defined as Key field:<\/p>\n![\"\"](\"https:\/\/www.int4.com\/wp-content\/uploads\/2018\/05\/int4_blog_1.png\")
<\/a>Template table for SAP AIF <\/em>multi index table<\/em><\/p><\/div>\n <\/p>\n
Module pool program for SAP AIF multi index table<\/h3>\n
Next, we have to create or extend existing module pool program. I will extend the module pool used in previous blog with the select options for material number. In case of any issues see the following code snippet of this program. For multiple index table, we need additional S_MAT <\/strong>select-options.<\/p>\nPROGRAM\u00a0ZAIF_SEL_SCREEN_0001.<\/em>
\nDATA:\u00a0gv_po_num\u00a0TYPE\u00a0bstkd,<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0gv_kunnr\u00a0\u00a0TYPE\u00a0kunag,<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0gv_matnr\u00a0\u00a0TYPE\u00a0matnr.<\/em><\/p>\nSELECTION-SCREEN\u00a0BEGIN\u00a0OF\u00a0SCREEN\u00a00001\u00a0AS\u00a0SUBSCREEN.<\/em>
\nSELECT-OPTIONS:<\/em>
\n\u00a0\u00a0\u00a0\u00a0s_po\u00a0\u00a0FOR\u00a0gv_po_num,<\/em>
\n\u00a0\u00a0\u00a0\u00a0s_kun\u00a0FOR\u00a0gv_kunnr,<\/em>
\n\u00a0\u00a0\u00a0\u00a0s_mat\u00a0FOR\u00a0gv_matnr.<\/em>
\n\u00a0\u00a0\u00a0\u00a0.<\/em>
\nSELECTION-SCREEN\u00a0END\u00a0OF\u00a0SCREEN\u00a00001.<\/em><\/p>\nAT\u00a0SELECTION-SCREEN\u00a0OUTPUT.<\/em>
\n\u00a0\u00a0\/aif\/cl_global_tools=>get_value_from_mem(\u00a0).<\/em><\/p>\n <\/p>\n
SAP AIF Customization required for multi index tables<\/h3>\n
In the last step, you have to configure newly created index table in AIF Customizing. Go to transaction \/n\/AIF\/CUST<\/strong> and go to SAP Application Interface Framework –> Error Handling –> Define Interface-Specific Features<\/em>.<\/p>\nHere you can see one difference between a single index and multi-index tables configuration. For single index table you have to add table name in Define Namespace-Specific features <\/em>first. For multiple index tables you shouldn’t do it, because you will add it directly in Interface-Specific features.<\/p>\nAdd a New entry. As first thing change Multi.Selection Type<\/em> to M Multiple Selection<\/strong> and click ENTER.\u00a0<\/em>Then fill all the rest information as the one shown in the screenshot below:<\/p>\n![\"SAP](\"https:\/\/www.int4.com\/wp-content\/uploads\/2018\/05\/SAP_AIF_Multi_Index_Table_customization.png\")
<\/a>SAP AIF multi index\u00a0table customization<\/p><\/div>\n
Congrats! Multiple index table in SAP AIF is configured properly!<\/p>\n
Now when you send via WE19 or SOAPUI a message with two line items and you open your multi-index table in SE16N you should see two entries with the same SAP AIF GUID, but with different material numbers. Thanks to this we know, that our AIF multi-index works!<\/p>\n
This blog is the extension of the previous blog: How To Create a Single Index Table in SAP AIF<\/a> and therefore some steps will be explained in a more general way. You can always visit the previous blog in case you occur any issues with details, but I believe that you won’t have any problems, as you mastered this knowledge last time reading the previous blog! \ud83d\ude42<\/p>\n<\/div>\n Multiple selection index tables are used in situations you want to create additional selection screen for the values, that appear more than once in a single message (for example plant ID on item level or material number in Sales Order).<\/p>\n In this blog I will show you how to use multiple index table to handle selection for the material number in inbound IDoc sales order interface in IDoc segment E1EDP01-E1EDP19-IDTNR.\u00a0<\/strong><\/p>\n First of all, you have to create an additional table based on a template table: \/AIF\/MIDX_TEMPL<\/strong>\u00a0\u00a0<\/strong>in transaction SE11<\/strong>. Once you created the table, add a field MATNR <\/strong>at the end of the table with type MATNR, <\/strong>in the same way, you did it for single index table. In addition, you will see, that this template table contains\u00a0another field COUNTER, <\/strong>that has our favourite data type: INT4 <\/strong>\ud83d\ude42 This field is added right after MSGUID <\/strong>field and has to be defined as Key field:<\/p>\n Template table for SAP AIF <\/em>multi index table<\/em><\/p><\/div>\n <\/p>\n Next, we have to create or extend existing module pool program. I will extend the module pool used in previous blog with the select options for material number. In case of any issues see the following code snippet of this program. For multiple index table, we need additional S_MAT <\/strong>select-options.<\/p>\n PROGRAM\u00a0ZAIF_SEL_SCREEN_0001.<\/em> SELECTION-SCREEN\u00a0BEGIN\u00a0OF\u00a0SCREEN\u00a00001\u00a0AS\u00a0SUBSCREEN.<\/em> AT\u00a0SELECTION-SCREEN\u00a0OUTPUT.<\/em> <\/p>\n In the last step, you have to configure newly created index table in AIF Customizing. Go to transaction \/n\/AIF\/CUST<\/strong> and go to SAP Application Interface Framework –> Error Handling –> Define Interface-Specific Features<\/em>.<\/p>\n Here you can see one difference between a single index and multi-index tables configuration. For single index table you have to add table name in Define Namespace-Specific features <\/em>first. For multiple index tables you shouldn’t do it, because you will add it directly in Interface-Specific features.<\/p>\n Add a New entry. As first thing change Multi.Selection Type<\/em> to M Multiple Selection<\/strong> and click ENTER.\u00a0<\/em>Then fill all the rest information as the one shown in the screenshot below:<\/p>\n SAP AIF multi index\u00a0table customization<\/p><\/div>\n Congrats! Multiple index table in SAP AIF is configured properly!<\/p>\n Now when you send via WE19 or SOAPUI a message with two line items and you open your multi-index table in SE16N you should see two entries with the same SAP AIF GUID, but with different material numbers. Thanks to this we know, that our AIF multi-index works!<\/p>\nHow to create SAP AIF multi index table?<\/h3>\n
<\/a>Module pool program for SAP AIF multi index table<\/h3>\n
\nDATA:\u00a0gv_po_num\u00a0TYPE\u00a0bstkd,<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0gv_kunnr\u00a0\u00a0TYPE\u00a0kunag,<\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0gv_matnr\u00a0\u00a0TYPE\u00a0matnr.<\/em><\/p>\n
\nSELECT-OPTIONS:<\/em>
\n\u00a0\u00a0\u00a0\u00a0s_po\u00a0\u00a0FOR\u00a0gv_po_num,<\/em>
\n\u00a0\u00a0\u00a0\u00a0s_kun\u00a0FOR\u00a0gv_kunnr,<\/em>
\n\u00a0\u00a0\u00a0\u00a0s_mat\u00a0FOR\u00a0gv_matnr.<\/em>
\n\u00a0\u00a0\u00a0\u00a0.<\/em>
\nSELECTION-SCREEN\u00a0END\u00a0OF\u00a0SCREEN\u00a00001.<\/em><\/p>\n
\n\u00a0\u00a0\/aif\/cl_global_tools=>get_value_from_mem(\u00a0).<\/em><\/p>\nSAP AIF Customization required for multi index tables<\/h3>\n
<\/a>
![\"Content](\"https:\/\/www.int4.com\/wp-content\/uploads\/2018\/05\/SAP_AIF_Multi_Index_Table_SE16n.png\")
<\/a>