LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

using SAP connector to return data

  • 1.  using SAP connector to return data

    Employee
    Posted 06-25-2015 07:15

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dhrobertson

    Hi all,

    I'm really struggling to work out how the ERP Connector works to return data. I have got the ERP Connector and the ERP metadata node, to connect to and instance of SAP fine. I can use the metadata node to find information of the functions etc and I can pull details back with the ERP connector using the example in the "Getting Started guide" regarding pulling back bank details, but that is all I can do, nothing else I can get to work.

    I want to do the following:

    I want to return a list of all vendors from the vendor table which I believe is LFA1 in SAP.

    I have used the BAPI_VENDOR_GETDETAIL function.
    I don't know how to use the Scalar parameters in order to pull back all vendor data. you seem to have to be specific eg. vendorno=1000
    even if I do this and use a vendor number that is in the system, it always returns an error saying it cant find the vendor in the system, even though I can see it in the SAP GUI so I know the vendor number is correct.

    Can someone with knowledge of how these SAP nodes work, let me know how I can retrieve all vendor data from the vendor table in SAP? can I somehow use wildcards or something like that?

    thanks

    Douglas