topic Re: Function Module on MAST,STPO in Application Development and Automation Discussions

Function Module on MAST,STPO

Former Member — Tue, 09 Jul 2013 10:19:10 GMT

Hi all,

I want to create a FM for a generic datasource with tables MAST and STPO for BOM report.I have created a structure(ZMASTSTPO) with all the fields of MAST,STPO tables(included common fields from MAST table not from STPO table) and also included the reference fields from reference tables T001,RC29P,CKHS in the same structure and given the same structure name and fields as the reference fields.We also need to call standard FM CSAP_MAT_BOM_ITEM_SELECT in the FM we create.I have copied RSAX function group with the FM RSAX_BIW_GET_DATA_SIMPLE and in TABLES section i have given the structure ZMASTSTPO.I really don't know what to do with the rest of the sections like in IMPORT,EXPORT,CHANGING,SOURCECODE.I understand that i need to write SELECT statement which gets all the fields from the tables that i have given to populate the structure ZMASTSTPO.

Could you please anybody explain me how to write the code to populate the fields of the structure or could if anybody already has done the similar approach please explain me?

Thanking you,

Re: Function Module on MAST,STPO

NAeda — Tue, 09 Jul 2013 11:03:24 GMT

Do a search on how to write a FM and use of import, export and table parameters

Moderator Message :Links without explanations are not permitted.

http://help.sap.com/saphelp_nw70/helpdata/en/9f/db98fc35c111d1829f0000e829fbfe/content.htm

Message was edited by: Venkat Gowrishankar

Re: Function Module on MAST,STPO

former_member213275 — Tue, 09 Jul 2013 12:50:20 GMT

Hi,

Refer below document which clearly explains how to extract BOM header and BOM item details into BW. You can also see page number 7 where there is logic written calling FM "CSAP_MAT_BOM_ITEM_SELECT". Hope this helps. Please close the thread if it is answered.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b0af489e-72b1-2b10-159d-abb8058fb88d?QuickLink=index&overridelayout=true&36837934524176

Srikanth.

Re: Function Module on MAST,STPO

Former Member — Tue, 09 Jul 2013 13:44:36 GMT

thanks Aeda and Srikanth.Srikanth i already have that document but the process they have explained is not clear and its not working.I have tried that.has anybody done this scenario if in case they were part of BW project.

Note: the table i have mentioned above CKHS..its actually STKO

Re: Function Module on MAST,STPO

former_member213275 — Wed, 10 Jul 2013 09:26:09 GMT

Hi,

Can i know where you are struck. Have you created generic data source in RSO2 specifying the Extraction method as "Function module" , Extractor as your new Function module name, and Extract Structure with your new structure ?

How to create generic data source using FM can be found from document mentioned in below link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70806d62-1c59-2e10-7597-91c114600d32?overridelayout=true

If you are facing trouble in creating functtion module then below link would be useful.

http://www.newtosap.info/2012/07/creating-function-module-and-using-it.html

Srikanth.

Re: Function Module on MAST,STPO

Former Member — Tue, 16 Jul 2013 09:44:02 GMT

Hi Srikanth sorry for late reply.I have created FM and Extract structure and finally created Generic dataosurce.When im checking in RSA3 it is giving ERRORS OCCURRED DURING EXTRACTION..not fetching any data.Do you have any idea.I think the code is looking fine.I have checked it ,no errors find.

Re: Function Module on MAST,STPO

Former Member — Fri, 26 Jul 2013 16:55:17 GMT

thanks everybody.I have copied a standard FM and used it for my scenario.Its working fine

Re: Function Module on MAST,STPO

former_member213275 — Fri, 26 Jul 2013 22:45:43 GMT

Hi,

Please close the thread.

Srikanth.