SAP MIC Module standard extractor

[Former Member]

Hi

I am currently engaged in creating the ABAP reports which will substitute the standard management, tabular reports in the MIC module.The customer has asked me to create the BW reports after i finish the ABAP reports.In my ABAP i was accesing tables such as HRP1000,HRP1001 and HRP1804 for getting the organisational unit specific info and the processes associated with it.Then i went to some cutom infotypes in order to get the numbr of issues,assesments,tests and finally remediation plans for those org units.

All this i need to model in BIW .Is there a standard extractor for MIC first? If yes will it have all these fields which combine the main infotype tables?

HRP1000-MC_STEXT

HRP1000-ENDDA

HRP1000-OBTYPE

HRP1000-OBJID

HRP1001-OTYPE

HRP1001-RSIGN

HRP1001-ENDDA

HRP1001-RELAT

HRP1001-SCLAS

HRP1001-SOBID

The last resort would be to see the same kind of code in a generic extractor using a function module and then fill up the ods because then all the processing will happen on the R3 side?

Also i need to know is there a oranisational unit hierarchy datasorce available which will have a orgunit and then the orgunits under it and so on, maybe an HR one would be there?

Regards

Vikrant

[edwin_harpino · Accepted solution]

hi Vikrant,

take a look hr business content datasources

(expand left nodes)

http://help.sap.com/saphelp_nw04/helpdata/en/37/5fb13cd0500255e10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2a/77eb3cad744026e10000000a11405a/frameset.htm

'organizational management'

http://help.sap.com/saphelp_nw2004s/helpdata/en/72/2e193ca1f5e713e10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/2b/7f193c45f9fa13e10000000a114084/frameset.htm

e.g staff assignments

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/5ca63a2719f539e10000000a11402f/frameset.htm

'organizational unit hierarchy'

http://help.sap.com/saphelp_nw2004s/helpdata/en/56/6abf394b629e19e10000000a11402f/frameset.htm

you can search in help.sap.com by table name and field,

click 'search documentation' and option 'netweaver'.

hope this helps.

[Former Member]

Hi

I have got the information on my own but would like to share the link with everyone just in case someone comes across the MIC module which aims at SOX complaince.

Please try this :

http://help.sap.com/saphelp_nw04/helpdata/en/41/570126e96e2f19e10000000a114b54/frameset.htm

One interesting observation is that as this module in the business content doen't deliver any infocubes but just ODS and the master data is time dependant understandbly so.

Thanks and Regards

Vikrant

[Former Member]

Hi Vikrant

I guess you will have to follow the procedure given in SAP Help Library .

I hope you are enjoying the life at Melbourne.

Regards

Pradip

(I guess you have my email ID )