on 01-20-2012 11:38 AM
Hi experts,
My scenario is i have to send a multiple records in a single file which have to be saved in database and also my condition is, for example if price is less than 100 it has to be saved in table 1 and if price is greater than 100 it has to be saved in table 2. i hope u guys have understood the problem...
Thanks & Regards,
B.Srinivas Prasad.
>for example if price is less than 100 it has to be saved in table 1 and if price is greater than 100 it has to be saved in table 2. i hope u guys have understood the problem...
Create JDBC Receiver structure with multiple Statements. Each Statement represents a table. So if the source field value is less than 100 then map to the respective statement which deals that table. You don't really need multimapping. Refer SAP JDBC document structure help link.
Sample:
<root>
<StatementName1>
<dbTableName action=u201DINSERTu201D>
<table>Table1</table>
<access>
<col1>val1</col1>
<col2>val2</col2>
</access>
</dbTableName>
</StatementName1>
<StatementName2>
<dbTableName action=u201DINSERTu201D>
<table>Table2</table>
<access>
<col1>val1</col1>
<col2>val2</col2>
</access>
</dbTableName>
</StatementName2>
</root>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi, very easy
you create data type with two statement objects conditionin your mapping or create in DD store procedure or funcition.
statement 0 .1
statement2 0 .unbounded
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
if receiver is JDBC :
you have to create 2 tables in receiver side and in interface determination u have mention condition.
if receiver is sap db:
you have to create multi mapping(1:n) then in interface determination u have mention condition.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Create receiver JDBC receiver data type with two statement objects and write a condition accodingly. in one mapping you can achive it easily.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi experts,
>
> My scenario is i have to send a multiple records in a single file which have to be saved in database and also my condition is, for example if price is less than 100 it has to be saved in table 1 and if price is greater than 100 it has to be saved in table 2. i hope u guys have understood the problem...
>
>
>
>
> Thanks & Regards,
> B.Srinivas Prasad.
use multimapping. and then using conditional interface determination push the data into different tables
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.