IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

Sending IDOC from BC to SAP urgent

  • 1.  Sending IDOC from BC to SAP urgent

    Posted Wed June 02, 2004 01:10 AM

    Hello,
    I can receive a document from remote system and put it into records.
    How can I send it to SAP as sales Order. I’m interesting in setup routing rules and services which should I use to transfer IDOC to SAP system. If is there any other idea to create sales order in SAP from BC please rewrite.
    Thanks,
    Marcnus


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 2.  RE: Sending IDOC from BC to SAP urgent

    Posted Wed June 02, 2004 10:13 AM

    Hey
    We have standard SAP delivered BAPIs for creating sales orders.

    BAPI_SALESORDER_CREATEFROMDAT1 (obsolete from 4.6 version)
    BAPI_SALESORDER_CREATEFROMDAT2

    for calling bapis u can use BAPI look-up functionality and outboundmap from BC to SAP. After fetching the records u can fill the required records/lists for the bapi and outbound map call would do the rest.

    hope it helps u…
    Thanks


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 3.  RE: Sending IDOC from BC to SAP urgent

    Posted Wed June 02, 2004 11:32 AM

    Thanks for reply.
    I’ve created outbound map for BAPI_SALESORDER_CREATEFROMDATA (is there something different to BAPI_SALESORDER_CREATEFROMDAT1?). How can I send/view in SAP order document? Is there any additional routing rule need before sending?
    Thanks in advance,
    Marcnus


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 4.  RE: Sending IDOC from BC to SAP urgent

    Posted Wed June 02, 2004 01:32 PM

    When I run my service (generated from BAPI_SALESORDER_CREATEFROMDATA), BC server crash. Anybody could explain me how can I transfer ORDERS01 or
    similar via ALE to SAP?
    Regards,
    Marcnus


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 5.  RE: Sending IDOC from BC to SAP urgent

    Posted Wed June 02, 2004 01:50 PM

    I suggest you to test this BAPI in SE37 transaction code in SAP GUI and check whether or not it’s creating sales order in SAP. Check out hte server exceptions for which it crashed…

    if u wish u to go for ALE instead of BAPI method, u can use this system service pub.sap.transport.ALE:outboundProcess whose input variables are self-explanatory…
    happy sending orders…


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 6.  RE: Sending IDOC from BC to SAP urgent

    Posted Wed June 02, 2004 11:59 PM

    Thanks for help Sreedhar Kurella.
    I used pub.sap.transport.ALE:outboundProcess to send Idoc to SAP system. When I displain’ Idoc list Idoc which I’ve send appears with following errors:
    Status: 56 Idoc with error added
    Message: EDI: Partner profile not available

    I think it depends of Control Record:
    Control record Direction: Inbound Sender: LS/ / IDoc type: ORDERS01 Message: ORDERS
    which have no all fields filled.

    Is BC should fill this fields (Routing > Routing Rules) or EDI_DC40?

    Routing rule on my BC:

    Sender: BC
    Receiver: SAP100 (logical system on SAP server)
    Message Type: ORDERS
    Main flow service: wm.PartnerMgr.flows.BC.SAP100RDERS
    Transport: ALE (R/3 IDOC)
    SAP Destination: TESTSAP

    EDI_DC40 I’ve filled with following data:
    IDOCTYP ORDERS01
    MESTYP ORDERS
    MESCOD CS
    SNDPOR BC
    SNDPRT LS
    RCVPOR SAP100
    RCVPRT LS

    Regards,
    Marcnus


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 7.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu June 03, 2004 09:11 AM

    Try sending “BC” as SNDPRN and “SAP100” RCVPRN in the Control Record. (In fact the routing rules have the values of receiver/sender and the same values must figure in the IDOC control Record for the IDOC processing to happen in SAP R3)

    HTH
    Bhavani Shankar


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 8.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu June 03, 2004 10:49 AM

    I’ve sent it with following results:
    Control record Direction: Inbound Sender: LS/ /BC IDoc type: ORDERS01 Message: ORDERS
    Message: EDI: Partner profile inbound not available

    Fields in Control Record:
    Recipient - Port: ________
    Partner type: LS
    Partner no.: SAP100

    Sender -
    Port: BC
    Partner type: LS
    Partner no.: BC

    I’ve got configuration for inbound Partner Profile as -
    Partner number: SAP100
    Partner type: LS
    Inbound parameters -
    Message type: ORDERS
    Inbound process code: ORDE

    Regards,
    Marcnus


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 9.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu June 03, 2004 12:42 PM

    Could someone rewrite here guide (step-by-step) how to configure Idoc flow from BC (Outbound) to SAP R/3 system (Inbound). Maybe I forgot about something.
    Thanks in advance,
    Marcnus


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 10.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu June 03, 2004 01:28 PM

    I’ve solved my problem.There was a wrong field value in EDI_DC40 -> MESCOD which hasn’t in SAP Partner Profile.
    Thanks for help,
    Marcnus


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 11.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu June 24, 2004 06:41 AM

    Hi Marcin,

    Can u please post the guide(step-by-step) how to configure IDoc flow from BC(outbound) to SAP R/3 system(inbound).

    we are in very much need of this i am not able to configure the BC properly…

    Thanks in advance,
    vamshi


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 12.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu June 24, 2004 08:37 AM

    Hello,

    If the IDOC in BC is in a record, probably you have to convert it using TransformHierarchytoFlat
    and then later invoke the OutboundProcess with the TransportParams filled with serverName

    HTH
    Bhavani Shankar


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 13.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu June 24, 2004 01:48 PM

    Hi Shankar,

    Thanks for your reply…

    I need some help from you…I am totally a new to this…

    I have installed the SAP BC 4.6 and SAP 4.6b running on the same machine.From legacy system i will get the XML document into which i have to convert it into idoc and update in SAP.I dont know how to do this…

    Can u please help me out…
    Thanks,
    vamshi


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 14.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu June 24, 2004 01:49 PM

    Hi Shankar,

    Thanks for your reply…

    I need some help from you…I am totally a new to this…

    I have installed the SAP BC 4.6 and SAP 4.6b running on the same machine.From legacy system i will get the XML document into which i have to convert it into idoc and update in SAP.I dont know how to do this…

    Can u please help me out…
    Thanks,
    vamshi


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 15.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu June 24, 2004 02:35 PM

    Please have a look at the service “sap.demo:handleIDocXMLPost” in SAP Package. This is useful provided the Legacy system sends IDOCs as a XML Document. This posts IDOCs, taking XML as the input.

    However, if the input data is not an IDOC, then you must create steps that can convert the input to the IDOC Structure and then invoke the OutboundProcess.

    HTH.
    Bhavani Shankar


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 16.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu June 24, 2004 02:44 PM

    Hi Shankar,

    Legacy system in our requirment is Lotus Notus where we created frontend forms for customer master creation when LnUser submits XML doc is created…my doubt is where should i store this XML doc so that SAP BC picksup and converts into IDoc first and then updates into SAP…

    Like i have doubts where to store the xml doc,creating routing rules…etc.Can u please helpme out…can u tell me the steps tobe followed…

    Basically i can say integration between legacy system to SAP

    Thanks,
    vamshi


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 17.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu June 24, 2004 11:16 PM

    Hi,
    I’m also receivin’ XML files from external system.
    In my solution first I read file from storage (I wrote simple java service to do it) and convert it to String. Then I use stringToDocument
    (it converts string to node) and documentToRecord which conversts node to boundNode. Previous steps are useful for checking xml syntax and various employments. Next I map boundNode to hierarchical record (should generate this record from xml schema) or directly to IDoc. Last steps are transformHierarchyToFlat and OutboundProcess (for sending IDoc to SAP system).
    In routing rules you should define sender (BC) and receiver system (SAP) and message type. As transport choose for example ALE (R/3 IDoc) and specify your destination server. Hope it helps.
    Regards,
    MW


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 18.  RE: Sending IDOC from BC to SAP urgent

    Posted Fri June 25, 2004 06:13 AM

    Hi,

    First of all thanks for the replies…

    Marcin can u please send me the code of java service and procedure for writing the Routing Rules…becos i am new to this…

    As shankar told there are some services which takes xml as input and convert into IDoc …etc. Shankar i also have the same query

    " But the question is How can the Legacy System write into the IS? "
    do u have any idea about this…

    Thanks,
    vamshi


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 19.  RE: Sending IDOC from BC to SAP urgent

    Posted Fri June 25, 2004 09:46 AM

    Looks like you are confused. Routing rules are required only to route the IDOCs to the SAP R3 based on the Sender, Receiver and Message Type combinations. Generally, it is not required when you do a OutboundProcess directly in your SAP BC Service.

    Regarding the data transfer, please follow the following steps.

    Create a new PORT in the SAP BC as “webMethods/FTP Port”.

    Give any number, mention the package name and save. Also change the Access mode to “Allow by default” or specify the Legacy systems IP address only.

    By this you have created a FTP Port on your SAP BC.

    Further to this, your Legacy system can use “ftp-put” to send data to the IS.
    Here, the ftp directory path must be like, for example (/ns/FTPDemo/get) if the servicenamespace is FTPDemo:get

    The BC service will have a contentStream object as the input and the first step is to use the “streamToString” service which converts the stream into a string.

    This can be further converted to a IDOC using xmltodocument and transformhierarchytoflat.

    HTH and have fun.
    Bhavani Shankar

    Note :
    Please refer SAPBCAdministrationGuide.pdf. This will give more details on how to configure ports and allow access. (Note, the PDF file name could be different, but it is surely Adminstration.pdf and available in the docs folder of your SAP BC Server setup.)


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 20.  RE: Sending IDOC from BC to SAP urgent

    Posted Mon June 28, 2004 11:23 AM

    Hi Shankar,

    Now i am clear that what you are telling…and i am trying these going thru the SAPBCAdministrationGuide.pdf .

    And my another challenging requirement is that i want to send the MasterData which is in SAP R/3-Oracle DB to another Oracle DB thru
    the SAP BC and IDoc. Can we do this,if so how…

    can u guide me if there any solution…

    Thanks,
    vamshi


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 21.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu July 01, 2004 10:36 AM

    Hi,
    just send that data in for example IDOC DEBMAS to SAP BC then using JDBC (writing java service) or some internal SAP BC database connector (refer BC guide) put that data into Oracle DB.
    Regards,
    MW


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 22.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu September 23, 2004 11:42 AM

    I have one query. I have successfully installed and tested(through the administrator interface) the outbound and inbound RFC calls with respect to SAP. I have also successfully tested the inbound call to webMethods 6.1 through the developer. To perform the outbound call from webMethods 6.1 to SAP I had mapped one flow service to an RFC. But I deleted that flow service accidentally. Now the WM 6.1 administrator is not allowing me to map any flow service to that particular RFC for outbound calls. It gives the following error: “Name already used by another service type” when I try to map any flow service to that RFC for outbound call. Can anybody suggest me any solution to this problem?


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 23.  RE: Sending IDOC from BC to SAP urgent

    Posted Wed March 02, 2005 06:48 AM

    Hi Marcin ,

    Thank you for your promt reply. I have got an xml file for sales order from a thirdparty software,

    now my query is what should be done in “SAP BC” to get this xml file and what are the consequetive steps that has to be followed in order to convert this “XML” to “IDOC”.

    should any settings be maintained at SAP R/3.

    Kindly suggest a step by step guide to achieve the above objective.

    Looking forward for your reply.

    Thanks a lot,
    Regards,
    charandeep N


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 24.  RE: Sending IDOC from BC to SAP urgent

    Posted Wed April 06, 2005 02:44 PM

    Hai MARC,
    My doubt is that where this XML file is stored when client posts using http service and using which service i capture this file to BC-Developer to start mapping to Xcbl Standards .

    Thanks in advance,
    Shankar


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 25.  RE: Sending IDOC from BC to SAP urgent

    Posted Wed July 06, 2005 06:53 PM

    hai all,

    I have created inbound map(SAP calling SAPBC) using IS 6.1 with appropriate service .when ever i execute that service  with input value(CompanyCode) then the IS server is shutting down.could any one please help me in this regard. 
    

    Thanks in advance


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 26.  RE: Sending IDOC from BC to SAP urgent

    Posted Thu July 14, 2005 04:36 PM

    Hi all,

    I’d like to add an extra doubt.
    If I have a document with same structure of an IDOC, I have to convert it in an IDOC.
    I’m trying to use the service pub.sap.idoc:transformHierarchyToFlat, passing my document to the parameter boundNode, but the IDOC_DATA and IDOC_CONTROL returned are blanlk or null.

    I think that before I pass my document to the boundNode I should convert it as boundNode. Is it right? What can I do to conver a document from IS 6 to an IDOC?

    Regards,

    Kleber Ferreira


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 27.  RE: Sending IDOC from BC to SAP urgent

    Posted Tue July 19, 2005 02:45 PM

    I am using SAP BC adapter for integrating with SAP. I have gone through the user guide and the SAP Integration Implementation guide but not clear on the following ares:

    SAB BC –> SAP (RFC/BAPI)

    1. Can perform this using the service sap.transport.OutboundRFC directly or creating a map and using it(sap.map.OutboundRFC internally)

    What is the difference in the two approaches is there any benifit other then the generation of the service by webMethods in creating outbound maps.

    1. In cases using the partner manager the same can be done using the direct service calls.

    The advantage I see in partner manager is :
    A. logging of the messages to the message store and
    B. Custom content based routing of documents.

    What is the larger scope of it and I see some of the functionalities performed similar to TN. I want to know if i am missing a larger picture/functionality.

    Partner manager as I understand is independent of SAP adapter and has specific features when SAP adapter or Rosettanet.

    The document for SAP adapter 4.6 points out that the service wm.PartnerMgr.gateway.transport.ALEutboundProcess is deprecated and any new development has to use pub.sap.transport.ALEutboundProcess service but when the routing rule is configured it generates the service and uses the wm.PartnerMgr.gateway.transport.ALEutboundProcess service within, I am confused about this too.

    I am trying to understand the best option to adopt in the development can anyone help me on these.


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 28.  RE: Sending IDOC from BC to SAP urgent

    Posted Fri November 11, 2005 06:10 AM

    Hi,
    We are in the process to call inbound SAP call from wM6.1 developer. We had configured SAP connection and listener. But how do we have to proceed further and tested the same through wM6.1 developer? I would appreciate your help in this regard

    Thanks & Regards
    Sachin


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 29.  RE: Sending IDOC from BC to SAP urgent

    Posted Mon July 24, 2006 05:29 PM

    Hi All,

    I have an unique problem, In SAP BC during upload process from legacy to SAP.
    It reads the files from the legacy system and then once the files are moved into BC into a list type, they are deleted from the legacy system. And then the IDOC is generated it is moved to SAP.

    We have a problem at this juncture, at times we are losing the RFC connections and during such times the data or the Idoc has not been moved to SAP and is still in SAPBC, when the connection reestablishes then we are not able to reprocess these values.

    Because now BC will read the files which are there in legacy system which in turn will overwrite the old values which was not sent to SAP due to loss of RFC connection.

    Due to this this data which was supposed to get to SAP is lost and the file in legacy system is also deleted, thus making It difficult for us to track.
    Is there someway we can avoid this, that is reprocess the data which is in BC list type, which was lost during the RFC connection loss.

    Regards
    -C@rthik


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB