Mass Maintenance

Create a Template that Uses the Custom Pages in Mass Maintenance

Before performing this task:

1. Create a looped template and process in Integrate. Refer to BDC Script Template with Looping Enabled or GUI Script Template with Looping Enabled in Integrate for more information.
2. Create all tt Tables and tx Views for the Integrate Process
3. Create rt Tables from the tt Tables
4. Create Custom Pages and Views

Once all of the custom pages and their views are created, follow these steps to use them in Mass Maintenance.

NOTE: A Post Message table must be defined on the Template (Post Message Table) page (Team > Templates > Vertical View > Configuration > Post Message Tables). This page must have a record for the Data Entry table that contains the column where the returned Post Message is stored. If the Post Message table is not defined, an error displays when a user clicks Post on the Request (Roles) page and the posting process stops.

To create a template that uses the custom pages:

1. Select Team on the Navigation pane.

2. Click Create Custom Template for a team.

   NOTE: Do not use the Create New Template From Integrate Template icon to create the template.

3. Click Add.

   View the field descriptions for the Create Custom Templates page’s Vertical View.

4. Enter a name in the TEMPLATE NAME field.

5. Enter the SAP transaction code in the TRANSACTION CODE field.

6. Select the target ERP system connection from the CONNECTION ID list box.
7. Click Save.
8. Click the Create Template icon.

9. Click Vertical View for the newly created template on the Templates page.

10. Click Configuration tab.
11. Click Post Message Tables.

12. Click Add.

    View the field descriptions for the Template (Post Message Tables) page.

    NOTE: When the custom template is saved, one post message table is created by default. A post message table for the main table created in Create all tt Tables and tx Views for the Integrate Process must also be added.

13. Select the data source that stores the tt tables created in Create all tt Tables and tx Views for the Integrate Process from the DATA SOURCE ID list box.
14. Select the tt table name for the header table from the TABLE NAME list box.
15. Select ID from the POSTING PRIMARY KEY COLUMN list box.
16. Select PostError from the POST ERROR COLUMN list box.
17. Select PostMessage from the POST MESSAGE COLUMN list box.
18. Click Save.

19. Click Add.

    View the field descriptions for the Template (Post Message Tables) page.

20. Select the data source that stores the rt tables created in Create all tt Tables and tx Views for the Integrate Process from the DATA SOURCE ID list box.
21. Select the rt table name for the header table from the TABLE NAME list box.
22. Select ID from the POSTING PRIMARY KEY COLUMN list box.
23. Select PostError from the POST ERROR COLUMN list box.
24. Select PostMessage from the POST MESSAGE COLUMN list box.

25. Click Save.

    NOTE: The following steps must be performed for each additional tt / rt table combination:

26. Click Add.

    View the field descriptions for the Template (Post Message Tables) page.

27. Select the data source that stores the tt tables created in Create all tt Tables and tx Views for the Integrate Process from the DATA SOURCE ID list box.
28. Select the tt table name for the detail table from the TABLE NAME list box.
29. Select ParentID from the POSTING PRIMARY KEY COLUMN list box.
30. Select PostError from the POST ERROR COLUMN list box.
31. Select PostMessage from the POST MESSAGE COLUMN list box.
32. Click Save.
33. Click Add.
34. Select the data source that stores the rt tables created in Create all tt Tables and tx Views for the Integrate Process from the DATA SOURCE ID list box.
35. Select the rt table name for the detail table from the TABLE NAME list box.
36. Select ParentID from the POSTING PRIMARY KEY COLUMN list box.
37. Select PostError from the POST ERROR COLUMN list box.
38. Select PostMessage from the POST MESSAGE COLUMN list box.
39. Click Save.

To continue configuring the template:

1. Navigate to the Templates page’s Vertical View.
2. Click Configuration tab.

3. Click Edit.

   View the field descriptions for the Templates page’s Vertical View.

4. Select the name of the Integrate template created in Create a Looped Template and Process in Integrate from the Integrate Template ID list box.
5. Select the name of the Integrate process created in Create a Looped Template and Process in Integrate from the Integrate Process ID list box.
6. Click Advanced tab.
7. Select the component name that contains the Archive pages created for the header loop in Create Archive Pages from the Template Archive WebAppID list box.

8. Select the page name for the Archive page created in Create Archive Pages from the Template Archive Page ID list box.

   NOTE: The page listed here will be the page linked to from Archive Page ID on the Request page after posting. Depending upon the business requirements, modifications may need to be made to this page and underlying view to link to pages for the other data entered and archived.

9. Click Save.

10. Click Custom Archive Tables.

    View the field descriptions for the Template (Archive Settings) page

11. Click Add.
12. Select the component name that contains the tt tables created in Create all tt tables and tx views for the Integrate Process from the ACTIVE TABLE DATA SOURCE ID list box.
13. Select the tt header table name from the Active Table Name list box.
14. Select the component name that contains the rt tables created in Create rt Tables from the tt Tables from the ARCHIVE TABLE DATA SOURCE ID list box.

15. Select the corresponding rt table name from the ARCHIVE TABLE NAME list box.

    NOTE: Repeat steps 11-15 for each of the tt/rt detail tables created for the Integrate Process loops.

    Continue with Add Custom Roles for the Looped Template.