To Create an Example Table in SAP MI BackEnd and Retrive in My Application

[Former Member]

Hello All

I am New To SAP-MI ,

>I Need a Steps to Create An Example Table In SAP MI BackEnd.

&

>To retrive Data into My Servlet Example Application.

>Send a link on this Issue.

Thanks And Regards,

Venu Gopal

[Former Member]

Hi Venu,

Creation of Backend table in R/3 system:

1) Go to transaction se11 and give an appropriate name against database table(ex:ztest_123)

2) press create button, give short text ,delivery class>A(example only),Data browser/tableview maint>select 2 option

3) Save the table in local(as table name starts with 'Z')

4) Goto technical settings->fill data class with APPL0,SIZE CATEGORY-->0

5) Save it again

6) press F3 and go to fields tab and mention the fields name the data element and check atleast one fields as primary key and save it and activate it.(create test data to this table)

Retriving data to client

1) once the tables are created and we need to develop bapi wrappers(Atleast getlist)

2) design syncbo and generate it and replicate it.

3) Create MCD and download it

4) Create a new project by using this downloaded XML.

5) Generate war file and deploy application to ur client.

6)Sync the client and you can see the recxords from backend.

This is only example creation of tables(test tables)

I may not be very clear, but hopefully this may help you.

I advice to go ABAPDOCU transaction to learn how to create Backend tables in ABAP.

Any furthur clarifications please do revert back.

Cheers,

Karthick