hello all,
We have a scenario where we are working with Manugistics database. Once the sales
orders are posted into Manugistics thru XI, Manugistics (transport & planning system) plans the delv and shipping and that information should be available in SAP as IDOCS via XI.The data that forms the Delv and Shipment document is available in Manugistics from 50 fields that are scattered accross 10 different tables. That is i will be needing 10 fields from Table 1,5 fields from Table 2, 20 Fields from Table 3 and so
on...and i will be extracting the required 50 fields from theses different tables and forming one record set for creating one delv doc..Also note that any field is subjected to change at any point of time.
1. My thoughts are: We can write Queries/Stored proceedures to maintain Z-table in Manugistics and maintain the record set/delta record set in the Z-table and then we can poll the JDBC from XI and pick up each record and map it to IDOC and create a DELV IDOC in SAP.My understaning is this is the best way to handle this interface.But due to some reason, my customer would not like to handle the stored proceedure logic in MANUGISTICS.they want to maintain the tables in ECC. Like replicating the tables in SAP Z-tables and then through a z-program,Z_BAPI pick up each record set and then create the delv IDOC....
2. so the way to do would be: replicate all the 10 tales in ECC as Z_table1, z-table2 and so on. when we have all the 10 tables, thru a BAPI/Z-program form the IDOC.But for replicating each of the 10 tables in ECC thru XI would be a difficult task. there may be 10,000s of records in real time, so if we were to design replicating the 10 tables in ECC as Z-tables we have to have 10 different adapters and 10 BAPIs to do this..!! or may be there is a better wy of doing it which i m not ware of.
3. also, of all i have this Question about JDBC: when we poll the adapter for every 60S, lets say to get field1,field2,field3 from table1 does the adapter poll 1 record every 60 S or does it poll all the records that has field 1 2 &3 every 60S.
Also some body previously had suggested the below info abt Manugistics which is in German...so if somebody ould provide me with details in English..it would be gr8.
wiao.fraunhofer.de/docs/BusinessIntegrationSoftware_MediaVision.pdf
Experts, pls share your thoughts and let me know if my thoughts are rite?
Thanks in advance
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.