cancel
Showing results for 
Search instead for 
Did you mean: 

What is oracle flat table structure?

Former Member
0 Kudos

Hi All,

What is oracle flat table structure? and how do i read it in XI if the Oracle Table is the Source System?

Regards,

XIer

Accepted Solutions (0)

Answers (2)

Answers (2)

Jitendra_Jeswan
Contributor
0 Kudos

You will create a Message Type

<MT_MessageTyepName>

<resultset> 1..1

<row>0..n

<column-name1>0..1

<column-name2>0..1

......

Column would depend on the number of columns in the table.

For more details click http://help.sap.com/saphelp_nw04/helpdata/en/0d/5ab43b274a960de10000000a114084/frameset.htm

Regards.

Jeet.

Former Member
0 Kudos

Hi,

Below link will help you

http://articles.techrepublic.com.com/5100-22-5031845.html

Thanks

Swarup

Former Member
0 Kudos

Guys, appreciate your response, but I want to know the difference between Oracle Flat Table structure and normal table structure.

It's urgent..

Thanks,

Xier

prateek
Active Contributor
0 Kudos

Where have u read this term Oracle Flat table? I have nt heard of it

Regards,

Prateek

Former Member
0 Kudos

Xler,

if you see in general there is no difference between these two objects. the difference is in syntax or method how you make a table. Oracle have different language to make a structure of table but use same concept. Wherever you make a table it always can have a primary key or not on which basis we search its data and save other field.

R3/SQL or any other database follow same approach. Just the difference is of how the output is displayed at Console and how we make its structure.

To load this table dat in to XI you need an appropriate adapter.

BR,

Alok