SAPLookup – an Excel formula for reading SAP data




About this tutorial:

Video duration: 3:6
SAPLookup will transform any company using SAP by letting users access information from a simple Excel formula.
** Not endorsed yet by SAP AG or Microsoft
*** SAP and BAPI are registered trademarks of SAP AG

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

22 thoughts on “SAPLookup – an Excel formula for reading SAP data

    aSim Shehzad

    (July 23, 2018 - 12:09 am)

    Any one required to this full function available with me, for SQ Database ,Oracle Database and SAP Hana Database easily making report as you want . Contact: asimshehzad_S@yahoo.com, +923339581695

    aSim Shehzad

    (July 23, 2018 - 12:09 am)

    SAP will transform any company using SAP by letting users access information from a simple Excel formula. Addins

    aSim Shehzad

    (July 23, 2018 - 12:09 am)

    Yes i do it 100% if any one required this
    Email me asimshehzad_S@yahoo.com

    escasinas ramil

    (July 23, 2018 - 12:09 am)

    is there any way to get all transaction details as report made in migo?

    Ronen Almog

    (July 23, 2018 - 12:09 am)

    #Ox4Sap integrate #microsoftoffice and #sap

    bixlord

    (July 23, 2018 - 12:09 am)

    Could I, please, have the function code?

    oliver johnson

    (July 23, 2018 - 12:09 am)

    Does this work in Excel 2013 ? I have typed in the function you show but nothing appears…

    Balan Bk

    (July 23, 2018 - 12:09 am)

    hi how can i learn from about this tool….very interesting……

    Robbert Boon

    (July 23, 2018 - 12:09 am)

    Hi guys,
    Similar to others when i insert the formula it just comes up with an error, it never seems to link to SAP. Can anyone help?

    Thanks all!

    Adam Hancharik

    (July 23, 2018 - 12:09 am)

    Ray,

    Is there a certain Add-in or Tools–>References that you activate to have this function? If so, which?

    Peter Bocsak

    (July 23, 2018 - 12:09 am)

    This looks amazing! Probably what I need for my project! Where can I get this function? Thanks!

    josedonizeth

    (July 23, 2018 - 12:09 am)

    how to connect sap x excel via VBA or VBA access? You could send me a sample file to use in my applications in Brazil?

    Teff Ethiopia

    (July 23, 2018 - 12:09 am)

    Great introduction!

    ahyahyahy

    (July 23, 2018 - 12:09 am)

    Do you have more information on this i am interested? I would like to figure out how to get job statuses, schedules, from sm37, extract spreadsheets from we05 results, etc… really sounds promising but need more information. Thank you.

    Muhammet Mustafa Aslan

    (July 23, 2018 - 12:09 am)

    hey i am looking this function too, how can we get this..

    Jolly R

    (July 23, 2018 - 12:09 am)

    The formula was similar to V-lookup and if function of excel wasn't it ??

    Ray Mannion

    (July 23, 2018 - 12:09 am)

    @TheNusiot Thank you very much for your message. We will be posting more information on SAPLookup shortly. The product is still currently in development with an expected production date of 8/31/10. I'll be back in touch when I have more info to share. Thanks again.

    TheNusiot

    (July 23, 2018 - 12:09 am)

    Hey there raymond can i get some more info that you suggested on this; i am a Maintenance Planner and run SAP. I am interested

    Ray Mannion

    (July 23, 2018 - 12:09 am)

    @tomthat Thanks for your comments. We actually put this project on hold a year or so ago due to the enormous cost of becoming an SAP partner. I'm now working on finishing the product and looking for other companies with whom I can collaborate to get it fully productive and on the market. It certainly will save companies a ton of time and money.

    sankar babu

    (July 23, 2018 - 12:09 am)

    Thanx for your prompt reply.

    This is for my personal learning experience and not to the Co right now.
    I will try to look into the applications what u have mentioned here.
    If u can, please post me the exact name of application or the things to do to find the applications, means how it is exactly to request to the system administrator

    Oneonta Taekwondo

    (July 23, 2018 - 12:09 am)

    Thanks for commenting. This application contains an Excel add-in and some SAP ABAP objects. Without both installed, you won't get anything to work. Would your company like more information?

    sankar babu

    (July 23, 2018 - 12:09 am)

    Awesome work,thnx for sharing ur knowledge to us. Can u help me how to connect(the network) the SAP with steps??Because when I tried to enter after the formula, I got the error in field and not the window(the formaul was right as it's accepted).Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *