IS-U&CRM Integration – How to Add Extra Fields to Business Agreements in SAP CRM
1. Objective
This blog describes how to add additional fields to Business Agreements (BUAG) in releases SAP CRM 2007 and SAP CRM 7.0 (i.e. Customer-specific fields).
2. Prerequisites
- SAP CRM 2007 or SAP CRM 7.0
- For release SAP IS-U 4.72 or lower: Implementation of SAP note 718234
- Implementation of SAP note 1280914
3. Instructions
In order to store additional fields in the database, it’s recommended to use the append technique (two alternatives).
If one way doesn’t work for you, try another one.
There are two alternatives:
A) Append a field to table CRMM_BUAG_H (special data of business agreements)
Fields of the same name and in the same sequence (very important!) has to be appended to each of the following structures:
- BAPIBUS1006130_SPEC_DATA
- BAPIBUS1006130_SPEC_DATA_EXP
- BAPIBUS1006130_SPEC_DATA_X
- CRMT_BUAGS_EI_SPEC_DATA_X (both in SAP CRM and in R/3 or ERP (Plug-In))
- BAPI_TE_FKKVKP (in R73 or ERP (Plug-In))
For the fields to be added to structures BAPIBUS1006130_SPEC_DATA_X and CRMT_BUAGS_EI_SPEC_DATA_X, choose field type BAPIUPDATE.
B) Append a field to table CRMM_BABR_H (general data of business agreements)
Fields of the same name and in the same sequence (very important!) has to be appended to each of the following structures:
- BAPIBUS1006130_GNRL_DATA
- BAPIBUS1006130_GNRL_DATA_EXP
- BAPIBUS1006130_GNRL_DATA_X
- CRMT_BUAGS_EI_GNRL_DATA (both in CRM and in R/3 or ERP (Plug-In))
- CRMT_BUAGS_EI_GNRL_DATA_X (both in CRM and in R/3 or ERP (Plug-In))
For the field to be added to structures BAPIBUS1006130_GNRL_DATA_X and
CRMT_BUAGS_EI_GNRL_DATA_X, choose field type BAPIUPDATE.
4. Validations
If necessary, for the BAPI, use method DATA_CHECK_BAPI of business add-in CRM_MDBP_BUAG.
5. IC-Webclient UI enhancements
New fields are automatically available at BOL (Business Object Layer) level.
You need just add them to existing nodes and view configuration tab.
Use transaction BSP_WD_CMPWB (BSP WD Workbench) and enhancement sets to maintain the enhancement of views.
Otherwise, in WEB UI you can use AET (Application Enhancement tool) for the same purpose.
If you want to show new fields (by BSP WD Workbench or AET in WEB UI) then the following views are relevant (views that show some information about object Business Agreement):
Context |
Component |
View |
IC Agent |
BUAG_DETAIL |
BUAG_DETAIL/BuAgCorr |
BUAG_DETAIL/BuAgDetails |
||
BUAG_DETAIL/BuAgDunning |
||
BUAG_DETAIL/BuAgInvoice |
||
BUAG_DETAIL/BuAgMoreFields |
||
BUAG_DETAIL/BuAgPayments |
||
BUAG_DETAIL/BuAgRefunds |
||
BUAG_DETAIL/BuAgTax |
||
BUAG_QUERY |
BUAG_QUERY/BuAgDynBuAgList |
|
BUAG_QUERY/BuAgList |
||
BUAG_QUERY/BuAgListEdit |
||
Utilities Sales |
IUBUAG |
IUBUAG/Details |
IUBUAGS |
IUBUAGS/ResultList |
Hi
The methods mentioned in the post limit the data types of the fields that can be added. The structure BAPI_TE_FKKVKP in method 1 and the structure BAPIBUS1006130_GNRL_DATA of method 2 have the enhancement category as char only.
Is there any work around when it is required to add a non-character field, say currency?
Hi Evgenia,
Thanks for nice blog.
I have a requirement regarding replication between ISU and CRM.
I wanted to replicate ISU contract account language standard field to SAP CRM custom filed.
Please let me know, If you have solution.
Best Regards,
Ravi Narravula