topic How to get/put data to/from table clusters using IMPORT/Export... from database..id.. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-put-data-to-from-table-clusters-using-import-export-from/m-p/8996404#M1697639 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P> I am trying to store 5-10 tables data for one key field (for example user) in a table cluster (ZC1) using Export stsmt. And will have to write logic to get the same using import stmt. created a table cluster using sap help and also created cluster tables (ztabl1, ztable2 and ztable3) and assigned them to table cluster (ZC1).</P><P>i tried to use stmt export it_ztable1 to database ZC1(ar) id &lt;zc1-keyfield&gt; but its expecting a component 'CLUSTR'&nbsp; and throw some error. I searched a lot but lot of explanation is with respect to INDX or PCL* table cluster but i want the same exlanation with respect to a custom table cluster. any help or a sample program would be greatly appreciated.</P><P></P><P>Mani</P></BODY></HTML> Sun, 26 Aug 2012 04:35:31 GMT Former Member 2012-08-26T04:35:31Z How to get/put data to/from table clusters using IMPORT/Export... from database..id.. https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-put-data-to-from-table-clusters-using-import-export-from/m-p/8996404#M1697639 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P> I am trying to store 5-10 tables data for one key field (for example user) in a table cluster (ZC1) using Export stsmt. And will have to write logic to get the same using import stmt. created a table cluster using sap help and also created cluster tables (ztabl1, ztable2 and ztable3) and assigned them to table cluster (ZC1).</P><P>i tried to use stmt export it_ztable1 to database ZC1(ar) id &lt;zc1-keyfield&gt; but its expecting a component 'CLUSTR'&nbsp; and throw some error. I searched a lot but lot of explanation is with respect to INDX or PCL* table cluster but i want the same exlanation with respect to a custom table cluster. any help or a sample program would be greatly appreciated.</P><P></P><P>Mani</P></BODY></HTML> Sun, 26 Aug 2012 04:35:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-put-data-to-from-table-clusters-using-import-export-from/m-p/8996404#M1697639 Former Member 2012-08-26T04:35:31Z Re: How to get/put data to/from table clusters using IMPORT/Export... from database..id.. https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-put-data-to-from-table-clusters-using-import-export-from/m-p/8996405#M1697640 <HTML><HEAD></HEAD><BODY><P>any reply?</P></BODY></HTML> Mon, 27 Aug 2012 16:32:15 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-put-data-to-from-table-clusters-using-import-export-from/m-p/8996405#M1697640 Former Member 2012-08-27T16:32:15Z Re: How to get/put data to/from table clusters using IMPORT/Export... from database..id.. https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-put-data-to-from-table-clusters-using-import-export-from/m-p/8996406#M1697641 <HTML><HEAD></HEAD><BODY><P>To use IMPORT FROM/EXPORT to database, your database table <STRONG>MUST</STRONG> respect the following str<SPAN style="font-size: 10pt;">ucture</SPAN><SPAN style="font-family: arial,helvetica,sans-serif;"> <A href="http://help.sap.com/abapdocu_70/en/ABENEXPORT_DATA_CLUSTER_INDX.htm">structure</A></SPAN><SPAN style="font-size: 10pt;">. (fr</SPAN>om <A href="http://help.sap.com/abapdocu_70/en/ABAPEXPORT_DATA_CLUSTER_MEDIUM.htm">EXPORT -&nbsp; medium</A> in abap online documentation) Adapt your z-table respecting the structure.</P><P></P><P>Regards,</P><P>Raymond</P></BODY></HTML> Mon, 27 Aug 2012 17:17:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-put-data-to-from-table-clusters-using-import-export-from/m-p/8996406#M1697641 RaymondGiuseppi 2012-08-27T17:17:18Z