Learning Objectives:-
This unit describes:-
- How to Delete a business object SAP Business Partner in SAP Business One?
Introduction: #
This tutorial will learn How to Delete a Business partner object in SAP Business one using operation DELETE in SAP business one Adapter. As we knew already, to Delete the records of the Business Partner module in the SAP Business One Client Application, we don’t need the body. Still, we need to know the card code, and we need to using PATH Parameter to Delete the record in Business Partner. For Delete the record of BusinessPartner in SAP Business One, we need the request Interface.We can process data manually and scheduler to know detail about How to run the outbound interface manually or scheduler please follow this link: https://docs.skyvva-dev.com/docs/tutorial-v2-41-lightning/129-how-to-run-the-outbound-interface-through-the-manually-or-scheduler/
Pre-required: #
- Create Integration
- Create Connection destination on SAP Control Board.
- Generate SAP Business one Metadata by using Import SAP Metadata.
- Create Outbound Interface linked with Metadata SAP Business one.
- Create SAP Business one Adapter on SAP Control Board.
Step 1: Create Integration:
To know detail about Integration, please follow this tutorial. What is Integration, and How to use it?
- Here’s Integration
Step 2: Create Connection Destination SAP Control Board.
- Click SAP Control Board on Integration.
- Fill name choosing type SAP Business One and click Continue.
- Here’s an example.
- Fill Host URL, Port Forward, Username, Password, URL Path, and Company Database of SAP Business one Application.
- Click ping SAP Connection and Click Save Button.
- Here’s Example.
Step 3: Create Metadata SAP by using SAP Import Metadata.
[su_box title=”Note” box_color=”#2a8af0″ title_color=”#000000″] We need to create Metadata Provider and a Repository. [/su_box]
Follow this link to see detail about How to use and create Metadata Provider and Repository.
- Go to Repository and click Import SAP Meta
- Choosing Direct SAP Connection
- select Connection Type,
- Select Connection Destination,
- Choose to Create Message Type to invoke SAP Business One API
- click Retrieve.
- Search Metadata Name Business Partner, choose a business partner, and click create Message Type.
[su_box title=”Note” box_color=”#2a8af0″ title_color=”#000000″]Copy the URL of module order that we choose for using in API endpoint on Adapter [/su_box]
After that, we will see the message type object Business Partner.
- Here’s the message type of business Partner.
- We need to create fieldd CardCode in PATH Parameter Message Type.
Go to Path Parameter Message Type in URL Message Type of Request Message Type and then click PATH Parameter. See the example below.
- Go to Related and Create Message Type Field Entry by clicking Button New. See the example below.
- Fill Message type Entry Name and Istructure. This section wants to Delete the business partner record so we need to create CardCode Message Type field Entry as a PATH parameter to use with the business partner record.
- We need to fill in Message type Field Entry Name and Istructure and click save Button. See the example below.
Step 4: Create Outbound Interface and Linked with this message type.
- Go to Integration detail, click Interface tap, click the New Interface button.
- Here’s Outbound Interface that is linked with SAP business Partner Message Type.
- Do mapping
In this step, we can use mapping by Instance value and Dynamic Value. When salesforce records have a value of card code already, we need to map the field to field in PATH Parameter. Here’s an example. We have field SAP_ID that stores the value of business partners, so we need to map that field to target fields of CardCode in PATH Parameter.
- See the picture below.
Step 5: Create SAP Business One Adapter on SAP control Board.
- Go to the SAP control board and click tap Adapter.
- Click New Button.
- Fill Name, Type: SAP Business one, Deployment: On Cloud, Integration Framework: Service Layer, Protocol: Rest, Authentication: Basic, Past the API endpoint that we copy from Create Metadata in the properties API service Endpoint URL, Choosing Operation Delete, Request and Response Format Json, and choosing connection Destination.
- We need to put (‘{!CardCode}’) in fields URL PATH Parameter.
- Click ping connection to make sure that the configuration adapter is successful.
- click save
- Here’s Example.
• Go to Request Interface and Linked this adapter.
• Here’s an example.
- Here’s the Record that we need to delete in SAP Business One
Step 6: Callout data by using Manual Process to delete record business one.
- Go to Interface Tap on SAP Control Board.
- Select Interface and click Manual Process. See the example below.
- Select Manually Select the sObjects using the Query Builder and click Next.
- Click Execute SOQL, a select record that we want to send to SAP business one, and click OK.
- Click Send
- Go to message Monitor to see the result.
- Here’s the result In SAP Business one Application. We can’t see the record ‘G13’ in sap business one application because this record deleted.
Summary #
Finally, we have learned how to Delete the record from salesforce to SAP Business One Application using operation DELETE in SAP Business one Adapter. In the next section, we will learn how to Query record from Business Partner using Operation GET in SAP Business One Adapter.