SAP CRM Business Partner Relationship defines the relationship between different SAP CRM BP.
This post will explain the SAP CRM BP Relationship Data Model (tables) and list of SAP BAPI for handling SAP CRM BP Relationship.
Check also SAP CRM Business Partner: Tables and BAPI
SAP CRM Business Partner Relationship Data Model
The SAP CRM Business Partner Relationship Main table is BUT050.
Each Relalionship is defined in SAP CRM by a guid (RELNR), 2 guids of SAP CRM Partners and a type of Relationship ( RELTYP )
- RELNR is SAP CRM BP Relationship Number
- PARTNER1 is the guid of SAP CRM BP part of relationship
- PARTNER2 is the guid of the Order SAP CRM BP Part
- DATE_TO is Validity Date (Valid To)
- DATE_FROM is Validity date (valid from)
- RELTYP is Business Partner Relationship Category
SAP CRM Business Partner Relationship Category
The field RELTYP defines the Category of the relationship between 2 SAP CRM BP.
All the SAP CRM BP relationship categories are stored in TBZ9 and TBZ9T for Description.
In SAP CRM, the Relationship is divided into 2 parts. For example: the relationship Parent-Child, has the first part ‘Has Child’ and the second part ‘has Parent’.
The standard list of SAP CRM BP Relationship Categories can be found here: SAP CRM Business Partner Relationship Category
SAP CRM Business Partner Relationship BAPI
When dealing with SAP CRM BP Relationship, check the following the SAP CRM BAPI starting with
SAP CRM BAPI for BP Relationship
|BAPI_BUPA_RELATIONSHIPS_GET||Read all BP Relationships|
|BAPI_BUPR_RELATIONSHIP_GET||Read General Relationship|
|BAPI_BUPR_RELSHIP_CHECKEXIT||Check if a Relationship exists|
|BAPI_BUPR_RELSHIP_GET_DETAIL||Read General Relationship|
|BAPI_BUPA_ADDRESS_ADD||Add address for Business Partner|
|BAPI_BUPR_RELATIONSHIP_CREATE||Create relationship between Contact Person and BP ( Relationship Category = BUR001 )|
|BAPI_BUPR_RELATIONSHIP_CHANGE||Maintain General Relationship|
|BAPI_BUPR_RELATIONSHIP_DELETE||Delete General Relationship|
|BAPI_BUPR_RELATIONSHIP_REMOVE||Delete a Relationship|
SAP CRM BAPI For BP Contact Person
|BAPI_BUPR_CONTP_ADDRESSES_GET||Retrieve all Contact Person Relationship Addresses|
|BAPI_BUPR_CONTP_ADDR_GETDETAIL||Read single Contact Person Relationship Address|
|BAPI_BUPR_CONTP_GETDETAIL||Read Contact Person Relationship|
|BAPI_PARTNER_CONTACT_SEARCH||Search for Business Partner Contact by details:Telephone/Email/ Address…|
|BAPI_BUPA_CREATE_FROM_DATA||Creation Business Partner or Contact Person|
|BAPI_BUPR_CONTP_ADDR_CHANGE||Change Contact Person Relationship Address|
|BAPI_BUPR_CONTP_ADDR_REMOVE||Remove Contact Person Relationship Address|
|BAPI_BUPR_CONTP_CHANGE||Change Contact Person Relationship|
|BAPI_BUPR_CONTP_DELETE||Delete Contact Person Relationship|
SAP CRM BAPI For BP Employee
|BAPI_BUPR_RESP_EMPLO_CHECKEXIST||Read the Employee Responsible of BP|
|BAPI_BUPR_EMPLO_GETDETAIL||Read Employee Relationship|
|BAPI_BUPR_EMPLO_ADDRESSES_GET||Retrieve all Employee Relationship Addresses|
|BAPI_BUPR_EMPLO_ADDR_GETDETAILS||Read single Employee Relationship Address|
|BAPI_BUPR_EMPLO_ADDR_CHANGE||Maintain Employee Address|
|BAPI_BUPR_EMPLO_ADDR_REMOVE||Delete Employee Address|
|BAPI_BUPR_EMPLO_DELETE||Delete Employee of BP|
|BAPI_BUPR_RESP_EMPLO_DELETE||Delete Employee Responsible Relationship|