on 11-19-2014 6:22 AM
working on 2 reports CJI3 and KOB1, need to transfer resultant file(.TXT) to MS Projects...
can someone please guide me how can we transfer projects from SAP to Micro soft projects .... ????
Hi Manish,
If you don’t want ZREPORT, just download both reports separately
in EXCEL.
Then export a project from MSP to excel or CSV file.
On this MSP excel file you will get all the information of MSP
project in excel format.
Paste all the relevant information matching the CJI3 &
KOB1 reports in MSP excel, in addition use information from table PRPS, AUFK
etc. to fill the ES,EF,dates,resourse, duration etc.
Once you have updated all the information in MSP excel,
import it in MSP and your project will be ready.
Else go for a development, which will take considerably good
amount of time.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Now business extracting data form CJI3 and KOB1 and send the files to MSP team for manual execution.
Business wants to make this process automated.
Please suggest..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
its not technically feasible to map fields of cji3 & kob1 reports and send it across to msp.. because of the factors involved in capturing data in SAP. what should be the trigger for sending the data to MSP?
Who all are authorised to run CJI3? what's the frequency you are looking at..
what you are doing currently is what you can do..
Not Possible any automated process. Think about two points:
1) Are you able to map SAP data (CJI3, KOB1) to MSP manually? (I don't think, its possible.)
2) How you schedule a back ground job if linking b/w two is not possible
Also MSP is not allowed to do Programming and develop such program.
Go thru below link, may be help you:
As sammar said is correct: what you are doing currently is what you can do!
Regards
Shishir
Hi,
Not sure if you are asking this question in the correct forum.
But here is my judgement for the future roadmap in your case:
Please enhance the idea as per the business requirement.
Hope it helps!
Thanks and Regards,
Varshal Kachole
Hi,
I don't think, you can migrate or transfer your actuals from CJI3 to MSP. Only Project Structure can be transfer to MSP via OpenPS.
For details of objects can be transferred, check below link
Anyways on the other work around, you can attach your resultant(.txt) file to MSP via attachment option:
Hope it helps
Regards
Shishir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manish,
you can only transfer project structure and time lines from SAP PS to MSP using Open PS? Do you have Open PS installed in your system?
I don't think there is an option of transferring the financial data from SAP PS to MSP.
Regards
Sammar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.