Exploring Data Migration Across SAP Landscapes

Usually, customers will have more than one SAP system landscapes in their environment. For example, Development; Quality & Production. To implement SAP Ariba solutions & features on the new or different landscapes, you need to transfer data in the database tables to the that landscapes.

Currently, the database table transfer to the new landscapes is performed manually which consumes time & resources. With this new functionality, customers can update the following data of the parameters & filters in the ARBCIG_TVARV table easily across SAP system landscapes in their environment:

• Values for the variant and the partition of the parameters
• Low and high values of the parameters

This feature also enables you to upload data to the Ariba Network Vendor table (ARBCIG_AN_VENDOR) & the System ID table (ARBCIG_SYSTIDMAP).

To update the values for the variant & the partition of the parameters & the low and high values of the parameters, you must use the Update Variant and Partition for Procurement and Sourcing and the Update Table Entries for Parameters and Filters options that are available in the ARBCIG_POST_CONFIG area menu sequentially.

To upload data to the Ariba Network Vendor table and the System ID tables, you must run the Mass Upload of Data report that is available in the ARBCIG_POST_CONFIG area menu.

Activity: 2.1 Tables to be transferred and updated in the new SAP system landscapes.

Maintenance Table	Data	Steps to Transfer Data
ARBCIG_TVARV	Values for the variant and the partition of the parameters	You must create a transport request & run the ARBCIG_POST_CONFIG transaction code in the SAP Easy Access screen.
ARBCIG_TVARV	Low and high value of the parameters	You must create a transport request & run the ARBCIG_POST_CONFIG transaction code in the SAP Easy Access screen.
ARBCIG_AN_VENDOR	Ariba Network Vendor table (ARBCIG_AN_VENDOR) maintains the vendors that are registered suppliers on Ariba Network.	Use the Mass Upload of Data menu option helps you download the template, update data in the template, and upload the file to update the ARBCIG_AN_VENDOR and the ARBCIG_SYSTIDMAP tables.
ARBCIG_SYSTIDMAP	The system ID table (ARBCIG_SYSTIDMAP)maintains the procurement master data.

Activity: 2.2 Tables to be maintained manually in the new SAP system landscape.

Maintenance Table	Data	Navigation
ARBCIG_RCVR_PORT	Contains the receiver port configuration data.	To access this table, navigate to Integration with Other SAP Components → SAP Ariba Cloud Integration Gateway → Global Settings and click the IMG - Activitynode for Configure Receiver Port.
ARBCIG_VAR_PAR	Contains the values for the variant and partition to be used in the new SAP system landscape. This table maps the values of variant and partition for SAP Ariba solutions.	To access this table, navigate to Integration with Other SAP Components → SAP Ariba Cloud Integration Gateway → Global Settings and click the IMG - Activity node for Map the Variant and Partition for SAP Ariba solutions.
ARBCIG_PRXYPARAM	Maintains the date and time stamp for payment proposal.	To access this table, navigate to Integration with Other SAP Components → SAP Ariba Cloud Integration Gateway → Ariba Network Integration → Application Specific Settings → Payment Proposal and click the IMG - Activity node for Maintain Date and Time for Payment Proposal.
ARBCIG_REQPARAM	Maintains the configuration related to the export of purchase requisition.	To access this table, navigate to Integration with Other SAP Components → SAP Ariba Cloud Integration Gateway → Ariba Network Integration → Application Specific Settings → Purchase Requisition and click the IMG - Activity node for Maintain Configuration Related to Requisition Export.
ARBCIG_FUNDER	Maintains the SAP vendor to funder details.	To access this table, navigate to Integration with Other SAP Components → SAP Ariba Cloud Integration Gateway → Ariba Network Integration → Application Specific Settings → Liability Transfer and click the IMG - Activity node for Maintain SAP Vendor to Funder Details.
ARBCIG_AUTHPARAM	Maintains the connection parameters for the master data.	To access this table, navigate to Integration with Other SAP Components → SAP Ariba Cloud Integration Gateway → Master Data Integration and click the IMG - Activity node for Connection Parameters for Master Data.
ARBCIG_INCRDTTIM	Maintains the date and time stamp for master data.	To access this table, navigate to Integration with Other SAP Components＞＞＞ SAP Ariba Cloud Integration Gateway＞＞＞Master Data Integration and click the IMG - Activity node for Maintain Date Time Stamp for Master Data.
ARBCIG_LASTCONTR	Maintains the last contract number.	To access this table, navigate to Integration with Other SAP Components → SAP Ariba Cloud Integration Gateway → SAP Ariba Procurement Integration → Application Specific Settings → Contract → IMG - Activity node for Maintain and click the the Last Contract Number.
ARBCIG_REMDATETM	Maintains date and time stamp for exporting payment remittance records to SAP Ariba Procurement solutions.	To access this table, navigate to Integration with Other SAP Components → SAP Ariba Cloud Integration Gateway → SAP Ariba Procurement Integration → General Settings and click the IMG - Activity node for Maintain Timestamp.

Activity: 2.3 Tables to be transferred using transports.

Maintenance Table	Data	Navigation
ARBCIG_TAXCATMAP	Maps SAP tax codes to tax categories.	To access this table, navigate to Integration with Other SAP Components → SAP Ariba Cloud Integration Gateway → Ariba Network Integration → Application Specific Settings → ERP-Initiated Invoice and click the IMG - Activity node for Map SAP Tax Codes to Tax Categories.
ARBCIG_FIELDMAP	Maintains field map for master data and catalog upload request.	To access this table, navigate to Integration with Other SAP Components → SAP Ariba Cloud Integration Gateway → Master Data Integration → Enhancements and click the IMG - Activity node for Maintain Field Map for Master Data and Catalog Upload Request.
ARBCIG_USR_GRP	Maintains user profiles for user master data.	To access this table, navigate to Integration with Other SAP Components → SAP Ariba Cloud Integration Gateway → Master Data Integration and click the IMG - Activity node for Maintain User Profiles for User Master Data.

You need to create a transport request & add the parameters & filters of the ARBCIG_TVARV table that you want to transfer from one SAP system landscape to another.

Perform the following steps:

1. Run the TCode SPRO, and navigate to:
   • Integration with Other SAP Components
   • SAP Ariba Cloud Integration Gateway
   • Configuration Activities to Transfer Data, click IMG-Activity for Transport Parameters and Filters.
2. The Change View "TVARV generalized for fields": Overview page appears.
3. Click Table View → Transport – the Prompt for Customizing request popup appears.
4. Do one of the following:
   • In the Request field, enter or choose the name of an existing request & click Continue. You can customize an existing request.
   • Click Own Requests. In the Create Request popup, enter the details to create a new transport request and click Save. In the Prompt for Customizing request popup, choose the new request that you have created and click Continue.
   • The Transport View "TVARV generalized for fields": Overview page appears.
   
5. In the TVARV generalized for fields table, choose the variable names that you want to add to the transport request that you have created & click Include in Request.
6. Click Save.

Activity: 4.1 Update Variant and Partition for Procurement and Sourcing

You can now update data in SAP system landscapes. You must use them on the SAP Easy Access Post Migration Configuration Activities page. A new area menu ARBCIG_POST_CONFIG is provided to perform this activity in sequential manner.

Before you start the process of updating variant & partition information in the new / target system, you must ensure that you have maintained the new values for the variants & partitions in the ARBCIG_VAR_PAR table in the target SAP system landscape.

To update this table, navigate to Integration with Other SAP Components → SAP Ariba Cloud Integration Gateway → Global Settings and click the Map the Variant and Partition for SAP Ariba solutions IMG-Activity node.

Performing this operation for a specific variable applies the variant and partition value changes to all instances of that variable. However, if you have included various types of variables, you must perform this operation for each of the variables.

Follow these steps –

1. In the SAP Easy Access screen, run the TCode – ARBCIG_POST_CONFIG – the SAP Easy Access Post Migration Configuration Activities page appears.
2. Under SAP Menu, double-click Update Variant and Partition for Procurement and Sourcing.
3. On the Update of Variant and Partition page, enter the details in the required fields.
4. Click Execute.

Field	Description
Current Variant value	Enter the existing value of the variant of the variable that you want to change. For example, VREALM_1234
Current Partition value	Enter the existing value of the partition of the variable that you want to change. For example, PREALM_1234
New Variant value	Enter the new value of the variant relevant for the new SAP landscape. For example, VREALM_5678
New Partition value	Enter the new value of the partition relevant for the new SAP landscape. For example, PREALM_5678

Activity: 4.2 Update Table Entries for Parameters and Filters

The Update Table Entries for Parameters and Filters menu option helps you update the Low and High values for the parameters and filters in the new SAP system landscape.

Follow these steps –

1. In the SAP Easy Access screen, run the TCode – ARBCIG_POST_CONFIG – the SAP Easy Access Post Migration Configuration Activities page appears.
2. Under SAP Menu, double-click Update Table Entries for Parameters and Filters.
3. On the Parameters page, click Modify to modify the values in the Low or the High field as required.
4. Once all the required modifications are done, click Save.

Activity: 4.3 Mass Upload of Data

This menu option is provided to upload table entries to Ariba Network Vendor (ARBCIG_AN_VENDOR) & System ID (ARBCIG_SYSTIDMAP) tables in bulk manner.

The ARBCIG_AN_VENDOR database table maintains the Vendors (SAP Vendor IDs) that are registered as suppliers on Ariba Network & their associated Company Codes. The ARBCIG_SYSTIDMAP table maintains the mapping between SAP Vendor ID & Ariba Procurement Common Supplier ID. This mapping is used during Supplier Master Data export.

Both the ARBCIG_AN_VENDOR & the ARBCIG_SYSTIDMAP database tables accept the files in the .xls format only. The Mass Upload of Data menu option helps you download the template, update data in the template & upload the file to update the ARBCIG_AN_VENDOR & the ARBCIG_SYSTIDMAP tables.

Follow these steps:

1. In the SAP Easy Access screen, run the TCode – ARBCIG_POST_CONFIG – The SAP Easy Access Post Migration Configuration Activities page appears.
2. Under SAP Menu, double-click Mass upload of data.
3. The Mass Upload program to load data in ARBCIG_AN_VENDOR, ARBCIG_SYSTIDMAP page appears.
4. To download the template, do the following:
   1. In the Select Table to upload data in field, choose ARBCIG_AN_VENDOR or ARBCIG_SYSTIDMAP based on the database table where you want to upload the table entries.
   2. Choose Download template.
   3. In the Select File field, enter or choose the path to the file where you want to download the template.
   4. Click Execute.
   5. In the SAP GUI Security popups to provide permissions to access the file & create the file in the directory that you have specified, click Allow.
   6. In the popup that confirms the successful download of the template, click Continue.
5. Using the downloaded template, update entries to be uploaded using the file in the .xls format only. Use excel cell options for the entries that prefixed with zeroes.
6. To upload the .xls file, do the following:
   1. In the Select Table to upload data in field, choose ARBCIG_AN_VENDOR or ARBCIG_SYSTIDMAP based on the database table where you want to upload the table entries.
   2. Choose Upload file into table.
   3. In the Select File field, enter or choose the path to the CSV file that contains the table entries.
   4. Click Execute.
   5. On the SAP GUI Security popup to provide permissions to access the file in the directory that you have specified, click Allow.
   6. On the popup that confirms the successful upload of the template, click Continue.