IS-U&CRM Integration - How to Add Extra Fields to Business Agreements in SAP CRM

[Former Member]

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