cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping issue for Summarizing of data

vijay_kumar133
Active Participant
0 Kudos

Hi friends...

In the Scnario JDBC-RFC.. in Jdbc there are all the data of sales happened at all branchs for different products...in a month.. now at the end of the month i need post the summarizing data of this into sap..

Can you give me th logic how can i sort and do sum for each branch and perticular product...

When i am posting to RFC the data should be for perticular branch all the products and there amont (sum of all the sales of that product in that branch). and in the same way i need post losses for that product at branch level..

Thanks and Regards

Vijay

Accepted Solutions (1)

Accepted Solutions (1)

vijay_kumar133
Active Participant
0 Kudos

Hi friends..

Thanks for replys...I will provide the the structure also...

Is there any option like if we use proxy in the target side..i can get data from jdbc to an internal table.. then after that can i do some all sort manupulations and send to the same RFC which is using now..

give me mail ids i will send the structure of the format...

Thanks and Regards

Vijay

Former Member
0 Kudos

Hi,

Is there any option like if we use proxy in the target side..i can get data from jdbc to an internal table.. then after that can i do some all sort manupulations and send to the same RFC which is using now..

Yes , we can use the BAPI inside the Proxy code also

/people/ravikumar.allampallam/blog/2005/08/14/choose-the-right-adapter-to-integrate-with-sap-systems

Regards

Seshagiri

Answers (2)

Answers (2)

Former Member
0 Kudos

could you provide ur source and target structures in case u want this to eb done thru UDF as preferrable solution in logic inside RFC

Former Member
0 Kudos

Hi,

You need to create Advanced UDF to sort the data comming from Sender JDNC and then have to summurize it as per requirment.

Its preferrable to add this kind of logic in RFC source code and formalize the data as per requirment. It will be pretty easy.

I will try to create the UDF for this, but it may take some time.

Thanks

Swarup