Adding attributes to the SAP Connector for AppOne

Note: The information in this guide applies to the SAP Purchase-to-Pay Connector for AppOne and SAP Order-to-Cash Connector for AppOne.

Introduction

In the SAP Connector several attributes are defined by default. If you want to use other attributes, you can add these to the SAP Connector. If the attribute is a new attribute on the entity that is the Case ID, the attribute will serve as case attribute. Follow the steps in this guide to add an attribute.

Adding an attribute

1. Decide to which entity the attribute belongs and whether this is stored on header or item level.
2. Change the expression TABLE attributes in the Globals table to extend the fields that are extracted from the table. See the illustration below.
   
   

   

   
   

3. Right click on the applicable input table in 1. Input and select Reload. The new attribute will be added in the table item list. See the illustration below.

   
   

   

   
   

4. Double click on the new attribute to open the Edit Datasource Attribute dialog and select the Attribute type.

   • If the values in the fields are text, set the Attribute type to Text.

     Note: Sometimes identifier values are parsed as integers, which causes problems such as that leading zeros are removed.
   • If it is a date value, set the Attribute type to Date and make sure the date format matches with the input. In SAP, the date values that are not available are usually stores as 00000000. Optionally, you can set that value in the NULL value in datasource field.
5. Click on the entity table in the 2. Entities folder for which this new attribute is added. In the table item list, right click on the new attribute and select Availability - Private.
6. Create an expression that gives the new attribute a meaningful name entity table in the 2. Entities folder.
7. If the new attribute also appears in other entity tables in the 2. Entities folder, set the Availability to Hidden if the attribute is not used.
8. Since the entity tables are used in the Entity relations, the newly created expression is made available on the tables in the folder 3. Event log creation - Entity relations. Set the Availability of the new expression to Hidden on these tables in the folder 3. Event log creation - Entity relations to prevent problems in a union afterwards.
9. You can use the new expression in the tables in the folders in 3. Event log creation - Events to extent the event attributes or update the event detail expressions.