Hi,
The best way would be accessing directly the tables. Actual data for FM is stored in FMIT table (totals) and FMIFIIT table (details). Commitment data - FMIOI. Budgetary data: FMBH, FMBL (header and lines- and FMBDT (totals).
Regards,
Eli
Thank you Eli, I thought so that would be ideal way to do it. Though I would use these tables in any other method, I would want to understand if we have any other methods like Batch Job. I am trying to understand the methods of extracting the data to a file automatically every night.
Hi,
I usually do this using RW reports or query. In your case, you can write a RW report (Tcode GRR1) under library 4FM. Report can be executed directly or scheduled as a batch job. On the selection screen, you can specify output medium (screen / printer / file etc. and you can save it as a varant for batch job to use). If you are familiar with FM tables, you can also use ABAP Query, which is more flexible. Query reports can be run as batch job too and outputs can be directed to a spredsheet (or flat file).
Regards,
Ming
Hi,
The methods are numerous, but they are usually defined from the database, rather than from the application (i.e. reports, etc;), if you want to build a solid interface. You have to speak to your BASIS and DBA team: provide them the data, namely tables and SQL statements.
Regards,
Eli
