IDOC TO JDBC structure ampping

[Former Member]

Hi,

All

i hvae a ZIDOC having following Structure fields.

ZBRIDOC_I01

IDOC

BEGIN

[Former Member]

Hi S Kumar,

are you upateing or select or Inserting the date into oracle. How Many tables are there in Target.

please be cleary i can send you a documnet

1. http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

2. /people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

3.https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3928.. [original link is broken] [original link is broken] [original link is broken] [original link is broken]

Follow these you will do your senario.

Regd's

Raj

[Former Member]

Hi

Raj

i hvae a ZIDOC having following Structure fields.

ZBRIDOC_I01

IDOC

BEGIN

EDIDC_40

SEGMENT

FIELD1

FIELD2 (Etc)

1. ZNOMI (Zsegment)

SEGMENT

FIELD1

FIELD2

FIELD3

FIELD4

FIELD5

2. ZPREEXP(Zsegment)

SEGMENT

FIELD1

FIELD2

FIELD3

FIELD4

FIELD5

3. ZVARDET (Zsegment)

SEGMENT

FIELD1

FIELD2

FIELD3

FIELD4

FIELD5

4. ZFIXDET (Zsegment)

SEGMENT

FIELD1

FIELD2

FIELD3

FIELD4

FIELD5

5. ZLANGUE (Zsegment)

SEGMENT

FIELD1

FIELD2

FIELD3

FIELD4

FIELD5

6. ZFAMILY (Zsegment)

SEGMENT

FIELD1

FIELD2

FIELD3

FIELD4

FIELD5

7. ZEDUCATION (Zsegment)

SEGMENT

FIELD1

FIELD2

FIELD3

FIELD4

FIELD5

8. ZADDRESS (Zsegment)

SEGMENT

FIELD1

FIELD2

FIELD3

FIELD4

FIELD5

i need to map these structure to 8 tables in oracle how can i map these tables in oracle

regards

kumar

[Former Member]

Hi,

here ist the datatype for your taget:

<<YourDataType>

__<StatementforTable_1> 0..1

____<dbtableName>

____<action> // type_attribute_map_to_constant: insert

____<table> // map_to_constant:_your_tablename

____<access>

______<tablefield_1> //map_to_IDOC_field

______<tablefield_2> //map_to_IDOC_field

______<tablefield_etc> //map_to_IDOC_field_

____

__<StatementforTable_2> 0..1

____<dbtableName>

____<action>__// type_attribute_map_to_constant: insert

____<table>___// map_to_constant:_your_tablename

____<access>

______<tablefield_1> //map to IDOC field

______<tablefield_2> //map to IDOC field

______<tablefield_etc> //map to IDOC field

...

__<StatementforTable_8> 0..1

____<dbtableName>

____<action>__// type attribute map to constant: insert

____<table>___// map to constant: your tablename

____<access>

______<tablefield_1>___//map to IDOC field

______<tablefield_2>___//map to IDOC field

______<tablefield_etc>_//map to IDOC field

Regards Mario