Skip to Content
author's profile photo Former Member
Former Member

Generic Extractor using Function Module

Hi,

we created 10 custom tables in ECC for FI/CO process. I need to create a generic extractor using function module. I found many posts to create a function module for single table.

Can I use one function module to extract data from more than one table? All the tables have relationships. or do I need to create 10 different function modules?

Please advise.

Thanks&Regards,

Hans.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2007 at 03:29 PM

    Hi Hans,

    You can build a single extract structure with all the required fields from those 10 different tables. In the function module you can fill in this extract structure by using select statements from 10 different tables.

    The other option would be to create a view on those 10 tables with all the possible relationships and create a generic extraction from view.

    Regards, Uday

    Assign points for helpful answers and get one point for yourself.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2007 at 03:28 PM

    Hi,

    With one functional module you can pull data from all the 10 tables.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      1. In my Cube i have some Junk Chars(invalid chars) how to remove it ?

      2.. I have a cube using since last 3 years i want to insert new infoobject what i have to do ? (is the cube must be empty to do this?)

      3. can we Customize the infoobject plz expalin with scenario ?

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 03:15 PM

    I could have resolved my problem.

    Thanks for all your help!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.