6 Replies Latest reply on Sep 17, 2017 4:00 AM by Pankaj Vasle

    Informatica Real Time Integration using SAP BAPI

    Pankaj Vasle New Member
    Pankaj Vasle Sep 17, 2017 4:00 AM

      Hi All,

       

      I am new to Informatica Real Time Integration, so require help and guidance of the experts.

       

      My requirement is to achieve real time integration where SAP BAPI will be the source and Salesforce will be the target.

      I am using Guide Designer to achieve this, but not able to fetch data from SAP BAPI.

       

      I am able to create a  SAP BAPI connection and can see the published meta-data.

       

      SAP BAPI Connection

      2.PNG

      Published Metadata

      1.PNG

      Have to pass the input Material number and Plant to IT_MATADATASET to fetch the data.

      ET_ITEM contains the output.

       

      But I am not able to fetch the data by creating a process in guide designer.

       

      So please guide me through this.

       

      Thanks and Regards,

      Pankaj

        • 1. Re: Informatica Real Time Integration using SAP BAPI
          Scott Nelson Guru
          Scott Nelson Jun 27, 2017 10:30 AM (in response to Pankaj Vasle)

          Hi Pankaj,

           

          In your process, you will want to create a temporary field based on the BAPI output by selecting the connector and an output type. Then you will need an assignment step to populate that field with a query.

           

          HTH

           

          Scott S Nelson

          • 2. Re: Informatica Real Time Integration using SAP BAPI
            Pankaj Vasle New Member
            Pankaj Vasle Jun 28, 2017 5:37 AM (in response to Scott Nelson)

            Hi Scott,

             

            Thank you for your response.

             

            I have did the same as you mentioned.

            I have created the process, please check the screenshot and after publishing the process I am getting a Service URL which I am testing in Advanced REST Client tool to check that service url is working or not.

             

            Process Screenshot

            Process.png

            Advanced REST Client screenshot


            ARC.PNG

            I am not getting anything in response.

             

            Please have a look and let me know if you have any suggestions on this.

             

            Thanks and Regards,

            Pankaj Vasle

            • 3. Re: Informatica Real Time Integration using SAP BAPI
              Scott Nelson Guru
              Scott Nelson Jun 28, 2017 8:38 AM (in response to Pankaj Vasle)

              Hi Pankaj,

               

              I suggest you set the log output as verbose and check the process monitor to debug.

               

              HTH

               

              Scott S Nelson

              1 of 1 people found this helpful
              • 4. Re: Informatica Real Time Integration using SAP BAPI
                Pankaj Vasle New Member
                Pankaj Vasle Jul 3, 2017 5:04 AM (in response to Scott Nelson)

                Hi Scott,

                 

                Really appreciate your help on this. That Process Monitor was really helpful to find the issue.

                 

                I am facing the issue in passing the input to the SAP BAPI

                 

                I am passing a variable BIN (temporary field in process) to BAPI input which is <LPO_MATDATA_GETDETAIL_INPUT>

                Type of BIN is <LPO_MATDATA_GETDETAIL_INPUT>


                and I am passing like below XML format in the service call:

                 

                <LPO_MATDATA_GETDETAIL_INPUT>

                  <Import>

                      <IV_LANG></IV_LANG>

                      <IS_DS_OPTION>

                        <ITEM_GET_DETAIL>{$input.in_item_detail}</ITEM_GET_DETAIL> (input field i have defined)

                      </IS_DS_OPTION>

                      <IT_MATDATASET>

                        <PLANT>{$input.in_plant}</PLANT> (input field i have defined)

                        <MATERIAL>{$input.in_material}</MATERIAL> (input field i have defined)

                      </IT_MATDATASET>

                   </Import>

                </LPO_MATDATA_GETDETAIL_INPUT>

                 

                PFA attached screenshot for the error which is "Error executing cloud process [hostRuntimeCall] with id [1644]: Cannot convert field IT_MATDATASET of type TABLE to StructureRecord"


                process_issue.PNG


                So can you tell me how to pass the data in to this BAPI

                Looking forward for a reply


                Thanks and Regards,

                Pankaj Vasle

                • 5. Re: Informatica Real Time Integration using SAP BAPI
                  Scott Nelson Guru
                  Scott Nelson Jul 3, 2017 10:09 AM (in response to Pankaj Vasle)

                  Hi Pankaj,

                   

                  It is not clear to me where you are trying to use your BIN value, or where it is coming from. You may need to assign it to a temporary field and then use that temporary field in your process. The error message could be because you are getting the value from a Database or Table connection through a query, at which point you will want to find the individual field returned from the query rather than passing the entire result.

                   

                  HTH

                   

                  Regards,

                   

                  Scott S Nelson

                  • 6. Re: Informatica Real Time Integration using SAP BAPI
                    Prakash Jain Guru
                    Prakash Jain Jul 24, 2017 10:46 AM (in response to Pankaj Vasle)

                    Hi Pankaj,

                     

                    Just to let everyone know this is identified to be defect with reference number CON-8569 for "BAPI with Ttype field inside structure is failing in runtime". Will be resolve in future releases.

                     

                    Thanks,

                    Prakash Jain