SAP ERP, SAP Customer Relationship Management

Turn on change log for notes/text in both ECC and CRM

How to turn on change log for notes/text, when custom text objects are created for customer object (KNA1/BUT000) in both ECC and CRM.

Customizing Notes/Long text in SAP CRM

In SAP CRM the text determination procedure is customized via the SPRO transaction for a particular transaction process.

  1. Log in to SAP CRM and enter SPRO in the command box.
  2. Click SAP Reference IMG and navigate to Customer Relationship Management->Basic Functions->Text Management

In the Define Text Objects and Text Types screen, create the Text Types and Text Objects that you need.

SAP ERP, SAP Customer Relationship Management

3. In the Define Text Determination Procedure screen, create a new procedure and link it to the text object created.

4. Navigate to Customer Relationship Management->Transactions->Basic Settings.

5. In the Define Transaction Types screen, assign the text determination procedure to the transaction type (‘Business partner’ in this case).

SAP ERP, SAP Customer Relationship Management

The values configured for the ‘Changes’ field for the different text types determine the behavior of the notes on SAP CRM Service Manager.

The following change control values can be configured for the note types:

  • Edit – you can edit the texts here. This is the default mode.
  • Log (P) – the text you enter here will be appended to the note of type ‘Display Log’.
  • Display Log (R) – this is read-only text where the content gets updated from the note of type ‘Log’.
  • Paste (A) – you can create this text only once, after which it becomes non-editable.
  • Display (C) – you cannot create or change this text. This automatically reads specific texts from an associated object.

Customizing Notes/Long text in SAP ECC

Long Texts (also referred as SapScript texts or text objects) are the containers for containing long texts in SAP systems, and they are usually attached to business objects, that users can enter free comments.

In certain table we would like to create records in CDHDR and CDPOS tables on change of some custom fields or some standard fields.

In our case we want to track the changes for customer objects (KNA1).

The long texts / notes are directly saved in STXH and STXL tables in ERP. So to build an audit of changes to long texts, it is necessary to track the changes in STXH/STXL tables for customer object.

1. For this first activate the log change for STXH and STXL tables via technical settings in SE11.

Go to SE11.

Enter you table name, then press display, You will find a technical setting tab. Click on that technical setting tab.

SAP ERP, SAP Customer Relationship Management

Then press edit.

SAP ERP, SAP Customer Relationship Management

When you click on the Change button, then the all fields will be in editable mode.

At the bottom, you will find an option Log data changes.

Just tick on the option and save your data.

SAP ERP, SAP Customer Relationship Management

Follow the same process to activate log data changes for the STXL.

SAP ERP, SAP Customer Relationship Management

2. For capturing text changes in tables ( STXH/STXL ) needs at least an entry to be maintained in table STXXFILTER.

Further details please refer SAP NOTE : 2515264 – Logging of tables STXH and STXL.

SAP ERP, SAP Customer Relationship Management

This enabling of logging changes is a standard configuration. The logs are written to a table called DBTABLOG, where audit trial can be viewed.

Note: If DBTABLOG table is not recording any changes to STXH and STXL. This is due to release of the kernel patch. In that case Implement the below SAP Note.

2652603 – STXH/STXL long texts are not saved in DBTABLOG.

SAP ERP, SAP Customer Relationship Management

Test case 1: Add a Long text in ECC and it will automatically sync to CRM.

  • Go to XD02 t-code and open customer in ECC.
  • Go into the menu Extras -> Texts.
  • Currently no text/notes exist:

SAP ERP, SAP Customer Relationship Management

Double click on a row, e.g. “Customer Service notes”,

Enter a text:

SAP ERP, SAP Customer Relationship Management

Click on Save.

SAP ERP, SAP Customer Relationship Management SAP ERP, SAP Customer Relationship Management

the text is saved on the customer and is available in the audit trail (via t-code AUT10).

To see change logs follow below steps.

i)Go to transaction AUT10

ii)Go to enhancement mode

SAP ERP, SAP Customer Relationship Management

iii) On the right pane pick the long text logs tab

Please feed in these details and click on execute

SAP ERP, SAP Customer Relationship Management

You shall the see the output. Text old/new shall show the changed values.

SAP ERP, SAP Customer Relationship Management

The note we just created in ECC, can be viewed on the customer in CRM (web-interface/GUI).

Open the same customer in CRM webui.

SAP ERP, SAP Customer Relationship Management

The note is saved under the text type “Correspondence”. To view the whole note, click on the blue text.

Test case 2: Add a Note/ Long text in CRM and it will automatically sync to ECC.

Open business partner and add a long text / note for business partner by click on new in CRM.

SAP ERP, SAP Customer Relationship Management

Choose which “Text Type” you want (in this case we chose “Insurance Notes”, and add your note, before pressing “Back”.

SAP ERP, SAP Customer Relationship Management

Click on Save.

SAP ERP, SAP Customer Relationship Management

This note can now be seen in the text type “Correspondence”, click on the blue text.

SAP ERP, SAP Customer Relationship Management

If we go back to ECC, this note can now be found in XD02 on customer.

SAP ERP, SAP Customer Relationship Management

You can double click on the row and read the full note.

SAP ERP, SAP Customer Relationship Management

You can also go into the audit trail in AUT10 (follow instructions above).

SAP ERP, SAP Customer Relationship Management

Leave a Reply

Your email address will not be published. Required fields are marked *