Skip to main content

Appendix B: SAP Data Services Jobs, Global Variables

This appendix contains the descriptions of SAP Data Services jobs that are created during the setup of Transaction Replication. It also lists the global variables that you need to update before running these jobs.

SAP Data Services Jobs

During the setup of SAP Data Services objects for loading transaction and balance data, import the .atl file of your source system into the SAP Data Services repository using SAP Data Services Designer. This creates projects and jobs specific to your source system in the repository.

Note: The .atl files for your source system are available at <SetupFolder>\<SourceSystem>\<SourceDatabase>\Mappings.

For information about setting up SAP Data Services objects, see Set Up Data Services ObjectsThis chapter provides information about setting up SAP Data Services objects for Transaction, AVL, Drilldown, SyncBack, and Reconciliation.Prerequisite TasksOn the computer on which SAP Data Services is installed, make sure that the following tasks are complete: In the DSConfig.txt file at \\ProgramData\SAP BusinessObjects\Data Services\conf, update the value of ANSI_Varchar_Behavior as False.Ensure that the data store configurations point to the staging database.Copy the SourceConnect folder at <SetupFolder>\Sample_folder_structure into the computer on which SAP Data Services is installed.Ensure that the setup files are available at the following locations:The .atl files for your source system are available at <SetupFolder>\<SourceSystem>\<SourceDatabase>\Mappings.The common .atl files are available at <SetupFolder>\Common_Mappings.Note: While importing multiple .atl files or reimporting .atl files, right-click the data store and select Exclude Tree to avoid overwriting the data store connection details.For 1C:Enterprise, ensure that the folder containing the .csv files is accessible to the SAP Data Services server.Set Up SAP Data Services Objects for Transaction and AVLYou can import the .atl file pertaining to your source system into your SAP Data Services repository through SAP Data Services Designer. For each source system, the project, data stores, and jobs are created in the repository. Then, you can update the connection details in the data stores to point to your source system objects.Note: For information about the password that you must use for importing the .atl file, contact insightsoftware Support.To set up SAP Data Services Objects for Transaction and AVLOpen SAP Data Services Designer as an administrator, and connect to your repository.For the transaction data, perform the following: Import the <SourceSystem>_Journals%.atl file into your SAP Data Services repository. The <SourceSystem>_Journals project and the corresponding data stores and jobs are created.Additionally, for NetSuite, import the NetSuite_DataLoad.atl file. The NetSuite_DataLoad project and the corresponding data stores and jobs are created.Note: If the following message appears while importing the .atl file, select Yes.For the balances data, perform the following:Create balance sheet accounts in SAP S/4HANA.Create the Accounts Receivable, Accounts Payable, and General Ledger clearing accounts that you need to specify in the $%Clearing_account variable while running the <SourceSystem>%_Balances job. For information about the $%Clearing_account variable for your source system, see Appendix B: SAP Data Services Jobs, Global Variables in Appendix B.Optionally, clear the Accounts Receivable and Accounts Payable clearing accounts manually. The General Ledger clearing account will be cleared automatically. Import the <SourceSystem>_Balances.atl file into the SAP Data Services repository. The <SourceSystem>_Balances project and the corresponding data stores and jobs are created. For JD Edwards EnterpriseOne, the out-of-the-box view for balances extraction must be updated according to the JD Edwards EnterpriseOne account setup. The account ranges should be modified in the view definition to indicate the account types. For example, if the account type is Assets, modify the value for the GBOBJ field to be between 100000 and 199999.Note: For information about the list of projects and the corresponding jobs pertaining to your source system, see Appendix B: SAP Data Services Jobs, Global Variables in Appendix B.For Reconciliation data, perform the following:Import the <SourceSystem>_RECON_L1_L5.atl file into your SAP Data Services repository. The <SourceSystem>_RECON_L1_L5 project and the corresponding data stores and jobs are created.Import the RECON_STG.atl file into your SAP Data Services repository. The RECON_STG project and the corresponding data stores and jobs are created.For AVL data, import the AVL_<SourceSystem>.atl file into your SAP Data Services repository. The AVL_<SourceSystem> project and the corresponding data stores and jobs are created.Update the connection details in the following data stores to point to your source system objects: Oracle E-Business Suite, IFS Applications, Oracle PeopleSoft, and Infor BaanData store nameDescriptionDS_<SourceSystem>_CDC The CDC schema that you created during the installation of Transaction.DS_<SourceSystem>_MASTERThe schema that contains the extraction views.DS_<SourceSystem>_STG The staging schema or database that contains the staging tables.DS_<SourceSystem>_SLT The SLT Replication Server database in which you created the /1LT/CF_E% tables.JD Edwards EnterpriseOneData store nameDescriptionRTD_DS_JDE_APPLThe JD Edwards EnterpriseOne database in which the JD Edwards EnterpriseOne tables exist.RTD_DS_JDE_BAL_APPLThe JD Edwards EnterpriseOne database in which the JD Edwards EnterpriseOne tables exist.DS_RD_JDE_CDCThe CDC schema.RTD_DS_JDE_MASTER The schema that contains the extraction views. RTD_DS_JDE_BAL_MASTERThe schema that contains the extraction views.RTD_DS_JDE_STGThe schema that contains the staging tables.HANA_RECON_REPThe staging schema in the staging database.RTD_DS_JDE_SLTSpecify the details of the SLT Replication server database in which the /1LT/CF_E% tables are present.Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics SL, Microsoft Dynamics GP, Dynamics 365 Finance and Operations, Dynamics 365 Business Central (on-premises and cloud), Epicor iScala, Infor CloudSuite Industrial (SyteLine), Deltek Costpoint, and NetSuiteData store nameDescriptionDS_<SourceSystem>_STGThe staging schema or database that contains the staging tables.DS_<SourceSystem>_SLTThe SLT Replication Server database in which the /1LT/CF_E% tables are present.DS_<SourceSystem>_VIEWSThe database that contains the extraction views.DS_MSFTAX_CDC (For Microsoft Dynamics AX only)The database in which the SQL Server CDC table for the GENERALJOURNALENTRY table is created.DS_NetSuite_NS_System (For NetSuite only)The system that contains NetSuite application table.Workday, QAD, 1C:EnterpriseData store nameDescriptionDS_<SourceSystem>_MASTER The staging database that contains the staging tables.DS_<SourceSystem>_SLTThe SLT Replication Server database in which the /1LT/CF_E% tables are present. For the RECON_SOURCE data store, update the connection details to point to the schema containing the extraction views.For the DS_S4_APPL data store, update the connection details to point to SAP S/4HANA.For the %DS_<SourceSystem>_PSCACHE data store, update the Cache directory field to point to the Cache folder at \\SourceConnect\MasterMapping in which the cache file needs to be created.Additionally, update the connection details in the following data stores to point to your staging objects:Data store nameDescriptionHANA_RECON_REP The staging schema in the staging database.RTD_DS_<SourceSystem>_STG The schema that contains the staging tables.RTD_DS_<SourceSystem>_SLTThe SLT Replication Server database in which the /1LT/CF_E% tables are present.For all the jobs in the staging database-related data stores, make the following changes:Depending on your source system, in the jobs pertaining to one or more of the following data stores, remove the target table in each data flow:DS_<SourceSystem>_STGRTD_DS_JDE_STGDS_<SourceSystem>_MASTERHANA_RECON_REPRECON_SOURCEAdd the target table in the data store to the data flow.Save the changes.For the <SourceSystem>_ERROR_LOG and <SourceSystem>_REPROCESS_FILE flat files in SAP Data Services Designer, edit the Root directory field to point to the Log and Reprocess folders respectively in the SourceConnect folder.For the MSC_LOOKUP_DATA Excel workbook in SAP Data Services Designer, edit the Directory field to point to the MasterMapping folder in the SourceConnect folder.After you set up the objects, you can load the transaction and balances data from your source systems into SLT Replication Server. For information about loading the data, see Load Data into SLT Replication Server in Loading Data, Reprocessing Documents.Before loading the data from NetSuite, you must perform some prerequisite tasks. For information, see Prerequisite Tasks for Loading NetSuite Data into SLT Replication Server in Loading Data, Reprocessing Documents.Set Up SAP Data Services Objects for Flat File Data LoadYou can import the .atl file pertaining to your source system into your SAP Data Services repository through SAP Data Services Designer. The project, data stores, and jobs are created in the repository. Then, you can update the connection details in the data stores to point to your source system objects.To set up SAP Data Services objects for flat file data load Open SAP Data Services Designer as an administrator, and connect to your repository. Import the UFF_Journals.atl file located at <SetupFolder>\UFF\Mappings into your SAP Data Services repository. The following projects and jobs are created:UFF_Journals project: UFF_Journals and UFF_Reprocess_Journals UFF_MasterData_Mapping project: Master_Lookup_LoadNote: The Reconciliation-related objects for Transaction are applicable to flat file data as well. For information about these objects, see Set Up SAP Data Services Objects for Transaction and AVL. Update the $v_uff_email variable of the UFF_Journals and UFF_Reprocess_Journals jobs with the email address of the point of contact. The error messages will be sent to the specified email address. Import the UFF_AVL.atl file located at <SetupFolder>\UFF\Mappings into your SAP Data Services repository. The UFF_AVL project, and the following jobs are created.UFF_AVL_CI: Loads the Customer Invoice data from Flat files to SLT tables. UFF_AVL_CO: Loads the Sales Order data from Flat files to SLT tables.UFF_AVL_PO: Loads the Purchase Order and Goods Receipt Note data from Flat files to SLT tables. UFF_AVL_SI: Loads the Supplier Invoice data from Flat files to SLT tables.Master_Lookup_Load: Loads the master data from MSC_Lookup_Data.xlsx to the MSC_MASTER_LOOKUP table and creates a persistent cache on the MSC_ MASTER_LOOKUP table for lookup data.Update the $FILE_PATH variable with the folder location where you have the UFF files available.Update the $SOURCE_SYSTEM variable with the source system name.Set up the $G_MATERIAL variable with DUMMY as the value in places where the source transaction is not defined with a material value. It will then be mapped to a material value in SAP S/4HANA. For the DS_UFF_MASTER data store, provide the connection details of the staging database that contains the configuration tables.For the DS_UFF_AVL_STG data store, provide the connection details of the staging database that contains the configuration tables.For the DS_UFF_SLT data store, specify the details of the SLT Replication Server database in which the /1LT/CF_E% tables are present.For the DS_UFF_AVL_SLT data store, specify the details of the SLT Replication Server database in which the /1LT/CF_E% tables are present. For the DS_UFF_PSCACHE data store, update the Cache directory field to point to the folder where you want to create the cache file.Set Up SAP Data Services Objects for DrilldownYou can import the .atl file pertaining to your source system into your SAP Data Services repository through SAP Data Services Designer. The project, data stores, and jobs are created in the repository. Then, you can update the connection details in the data stores to point to your source system objects.Important: On the computer on which SAP Data Services is installed, make sure that the following tasks are complete: In the DSConfig.txt file at \\ProgramData\SAP BusinessObjects\Data Services\conf, update the value of ANSI_Varchar_Behavior as False.The data store configurations point to the staging database.The setup files are available at the following locations: <SetupFolder>\<SourceSystem>\<SourceDatabase>\Mappings<SetupFolder>\<SourceSystem>\<SourceDatabase>\Scripts<SetupFolder>\StageTo set up SAP Data Services Objects for DrilldownOpen the SAP Data Services Designer as an administrator, and connect to your repository.For transaction data, import the .atl file for your source system into your SAP Data Services repository. Note: For information about the password that you must use for importing the .atl file, contact insightsoftware Support.The <SourceSystem>_SCD project, the following jobs, and the corresponding data stores are created: <SourceSystem>_CDC_TRX: Performs the incremental data load for transaction data. <SourceSystem>CDC_Set_Status_On: Enables the incremental data load for the <SourceSystem>_CDC_TRX job.<SourceSystem>CDC_Set_Status_Off: Stops the incremental data load for the <SourceSystem>_CDC_TRX job.<SourceSystem>_OT_<ModuleName>_TRX: Performs the initial data load for transaction data. The <ModuleName> refers to AP, AR, GL, PO or SO. <SourceSystem>_OT_MASTER_DATA: Performs the initial data load for master data. Edit the settings of the data stores to update the connection details to point to your source system objects: DS_<SourceSystem>_APPL: Update the connection details to point to your source database that contains the source tables.DS_HANA_SCD: Update the connection details to point to the Drilldown user that you created in the SAP HANA database during the Drilldown installation.DS_<SourceSystem>_CDC: Update the connection details to point to the CDC schema that you created during the Transaction installation.For all the jobs in the DS_HANA_SCD data store, make the following changes:Remove the target table in each data flow.Add the target table in the data store to the data flow.Save the changes.After you set up the objects, you can load the transaction data into SAP S/4HANA for Drilldown reporting. For information, see "Loading Data, Reprocessing Documents" in SAP Central Finance Transaction Replication by insightsoftware Administrator Guide.Set Up SAP Data Services Objects for SyncBackYou can import the .atl file pertaining to your source system into your SAP Data Services repository through SAP Data Services Designer. The project, data stores, and jobs are created in the repository. Then, you can update the connection details in the data stores to point to your source system objects.Important: On the computer on which SAP Data Services is installed, make sure that the following tasks are complete: In the DSConfig.txt file at \\ProgramData\SAP BusinessObjects\Data Services\conf, update the value of ANSI_Varchar_Behavior as False.The data store configurations point to the staging database.To set up SAP Data Services Objects for SyncBackOpen the SAP Data Services Designer as an administrator, and connect to your repository.Import the <SourceSystem>_Syncback.atl file located at <SetupFolder>\<SourceSystem>\Mappings into your SAP Data Services repository. The <SourceSystem>_Syncback project, the corresponding data stores, and jobs are created: Job nameDescriptionS4_<SourceSystem>_AP_Payment_OTPerforms an initial load of payments data from SAP S/4HANA into a vendor payment-specific table in the source database or a file.S4_<SourceSystem>_AR_Payment_OTPerforms an initial load of receipts data from SAP S/4HANA into a customer receipt-specific table in the source database or a file.S4_<SourceSystem>_AP_Payment_CDC Performs an incremental load of payments data from SAP S/4HANA into a vendor payment-specific table in the source database or a file.S4_<SourceSystem>_AR_Payment_CDC Performs an incremental load of receipts data from SAP S/4HANA into a customer receipt-specific table in the source database or a file.S4_<SourceSystem>CDC_Set_Status_On Enables the incremental data load for the S4_<SourceSystem>_AP|AR_Payment_CDC job.S4_<SourceSystem>CDC_Set_Status_OffStops the incremental data load for the S4_<SourceSystem>_AP|AR_Payment_CDC job.Additionally, for all staging databases except SAP HANA, the following jobs are created: Job nameDescriptionS4_<SourceSystem>_AP_Payment_Trx Performs an initial load of the payments data from SAP S/4HANA into the AP_FIN_PYMT_TRX table in the staging database.S4_<SourceSystem>_AR_Payment_TrxPerforms an initial load of the receipts data from SAP S/4HANA into the AR_FIN_PYMT_TRX table in the staging database.S4_<SourceSystem>_AP_Payment_Trx_CDC Performs an incremental load of payments data from SAP S/4HANA into the AP_FIN_PYMT_TRX table in the staging database.S4_<SourceSystem>_AR_Payment_Trx_CDCPerforms an incremental load of receipts data from SAP S/4HANA into the AR_FIN_PYMT_TRX table in the staging database.S4_<SourceSystem>STG_Set_Status_On Enables the incremental data load for the S4_<SourceSystem>_AP|AR_Payment_Trx_CDC job.S4_<SourceSystem>STG_Set_Status_OffStops the incremental data load for the S4_<SourceSystem>_AP|AR_Payment_Trx_CDC job.Edit the settings of the data stores to update the connection details to point to your source system objects:DS_S4_DB: Update the connection details to point to the database in SAP S/4HANA in which the extraction views were created during the installation of SyncBack.DS_<SourceSystem>_MASTER: Update the connection details to point to the schema in which the synonyms were created during the installation of SyncBack.RTD_DS_<SourceSystem>_STG/DS_MAG_STG: Update the connection details to point to the schema that contains the staging tables in your source instance.For all the jobs in the RTD_DS_<SourceSystem>_STG/DS_MAG_STG data store, make the following changes:Remove the target table in each data flow.Add the target table in the data store to the data flow.Save the changes.After you set up the objects, you can load the data from SAP S/4HANA into your source system using SyncBack. For information, see " Loading Data, Reprocessing Documents" in SAP Central Finance Transaction Replication by insightsoftware Administrator Guide. in the SAP Central Finance Transaction Replication by insightsoftware Installation and Configuration Guide.

The following sections provide the project and job details for each source system.

Oracle E-Business Suite

To import transaction data, load the SC_Journals.atl file from\\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Journals project:

  • SC_Journals: Manages both initial (OT) and incremental (CDC) data loads for journal data, with an option to concurrently run L1-L3 reconciliation reports.
  • SC_CDC_Set_Status_On: Enables the incremental data load for the SC_Journals job.
  • SC_CDC_Set_Status_Off: Disables the incremental data load for the SC_Journals job.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Reprocess: Processes data for transactions that failed during initial and incremental data loads.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.
  • SC_Level1_Refresh: Verifies missing source records, updates corresponding tables, and adjusts L1 reconciliation reports accordingly.

To import balances data, load the SC_Balances.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Balances project:

  • SC_Balances: Loads general ledger account opening balances, customer balances, and vendor balances into SAP S/4HANA.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import AVL data, load the SC_AVL.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_AVL project:

  • SC_CI_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for customer invoice information.
  • SC_CO_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for customer order information.
  • SC_PO_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for purchase order information.
  • SC_SI_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for sales invoice information.

Note: For AVL transaction, the TOBEDELETED column flag value has been changed to " ". It implies that the value must not be deleted. However, when this value is X, it must be deleted. The delete functionality is applicable for flat file AVL transactions only.

IFS Applications

To import transaction data, load the IFS_Journals.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the IFS_Journals project:

  • IFS_Journals_OT: Performs an initial data load for journal data.
  • IFS_Journals_CDC: Performs an incremental data load for journal data.
  • IFSCDC_Set_Status_On: Enables the incremental data load for the IFS_Journals_CDC job.
  • IFSCDC_Set_Status_Off: Disables the incremental data load for the IFS_Journals_CDC job.
  • IFS_Reprocess_Journals: Processes data for transactions that failed during initial and incremental data loads.
  • Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import balances data, load the IFS_Balances.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the IFS_Balances project:

  • IFS_GL_Balances: Loads general ledger account opening balances into SAP S/4HANA.
  • IFS_Customer_Balances: Loads customer balances into SAP S/4HANA.
  • IFS_Vendor_Balances: Loads vendor balances into SAP S/4HANA.

JD Edwards EnterpriseOne

To import transaction data, load the SC_Journals.atl file from\\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Journals project:

  • SC_Journals: Manages both initial (OT) and incremental (CDC) data loads for journal data, with an option to concurrently run L1-L3 reconciliation reports.
  • SC_CDC_Set_Status_On: Enables the incremental data load for the SC_Journals job.
  • SC_CDC_Set_Status_Off: Disables the incremental data load for the SC_Journals job.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Reprocess: Processes data for transactions that failed during initial and incremental data loads.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.
  • SC_Level1_Refresh: Verifies missing source records, updates corresponding tables, and adjusts L1 reconciliation reports accordingly.

To import balances data, load the SC_Balances.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Balances project:

  • SC_Balances: Loads general ledger account opening balances, customer balances, and vendor balances into SAP S/4HANA.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

Oracle PeopleSoft

To import transaction data, load the SC_Journals.atl file from\\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Journals project:

  • SC_Journals: Manages both initial (OT) and incremental (CDC) data loads for journal data, with an option to concurrently run L1-L3 reconciliation reports.
  • SC_CDC_Set_Status_On: Enables the incremental data load for the SC_Journals job.
  • SC_CDC_Set_Status_Off: Disables the incremental data load for the SC_Journals job.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Reprocess: Processes data for transactions that failed during initial and incremental data loads.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.
  • SC_Level1_Refresh: Verifies missing source records, updates corresponding tables, and adjusts L1 reconciliation reports accordingly.

To import balances data, load the SC_Balances.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Balances project:

  • SC_Balances: Loads general ledger account opening balances, customer balances, and vendor balances into SAP S/4HANA.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import AVL data, load the SC_AVL.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_AVL project:

  • SC_CI_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for customer invoice information.
  • SC_CO_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for customer order information.
  • SC_PO_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for purchase order information.
  • SC_SI_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for sales invoice information.

Microsoft Dynamics AX

To import transaction data, load the msftax_Journals.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the MSFTX_Journals project:

  • MSFTAX_Journals_OT: Performs an initial data load for journal data.
  • MSFTAX_Journals_CDC: Performs an incremental data load for journal data.
  • MSFTAXCDC_Set_Status_On: Enables the incremental data load for the MSFTAX_Journals_CDC job.
  • MSFTAXCDC_Set_Status_Off: Disables the incremental data load for the MSFTAX_Journals_CDC job.
  • MSFTAX_Reprocess_Journals: Processes data for transactions that failed during initial and incremental data loads.
  • Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import balances data, load the MSFTAX_Balances.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the MSFTAX_Balances project:

  • MSFTAX_GL_ACCOUNT_Balances: Loads general ledger account opening balances into SAP S/4HANA.
  • MSFTAX_Customer_Balances: Loads customer balances into SAP S/4HANA.
  • MSFTAX_Vendor_Balances: Loads vendor balances into SAP S/4HANA.

Microsoft Dynamics NAV

To import transaction data, load the MSFTNAV_Journals.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the MSFTNAV_Journals project:

  • MSFTNAV_Journals_OT: Performs an initial data load for journal data.
  • MSFTNAV_Journals_CDC: Performs an incremental data load for journal data.
  • MSFTNAVCDC_Set_Status_On: Enables the incremental data load for the MSFTNAV_Journals_CDC job.
  • MSFTNAVCDC_Set_Status_Off: Disables the incremental data load for the MSFTNAV_Journals_CDC job.

To import balances data, load the MSFTNAV_Balances.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the MSFTNAV_Balances project:

  • MSFTNAV_GL_ACCOUNT_Balances: Loads general ledger account opening balances into SAP S/4HANA.
  • MSFTNAV_Customer_Balances: Loads customer balances into SAP S/4HANA.
  • MSFTNAV_Vendor_Balances: Loads vendor balances into SAP S/4HANA.

Microsoft Dynamics SL

To import transaction data, load the MSFTSL_Journals.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the MSFTNSL_Journals project:

  • MSFTSL_Journals_OT: Performs an initial data load for journal data.
  • MSFTSL_Journals_CDC: Performs an incremental data load for journal data.
  • MSFTSLCDC_Set_Status_On: Enables the incremental data load for the MSFTSL_Journals_CDC job.
  • MSFTSLCDC_Set_Status_Off: Disables the incremental data load for the MSFTSL_Journals_CDC job.
  • MSFTSL_Reprocess_Journals: Processes data for transactions that failed during initial and incremental data loads.
  • Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import balances data, load the MSFTSL_Balances.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the MSFTSL_Balances project:

  • MSFTSL_GL_Account_Balances: Loads general ledger account opening balances into SAP S/4HANA.
  • MSFTSL_Customer_Balances: Loads customer balances into SAP S/4HANA.
  • MSFTSL_Vendor_Balances: Loads vendor balances into SAP S/4HANA.

Microsoft Dynamics GP

To import transaction data, load the SC_Journals.atl file from\\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Journals project:

  • SC_Journals: Manages both initial (OT) and incremental (CDC) data loads for journal data, with an option to concurrently run L1-L3 reconciliation reports.
  • SC_CDC_Set_Status_On: Enables the incremental data load for the SC_Journals job.
  • SC_CDC_Set_Status_Off: Disables the incremental data load for the SC_Journals job.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Reprocess: Processes data for transactions that failed during initial and incremental data loads.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.
  • SC_Level1_Refresh: Verifies missing source records, updates corresponding tables, and adjusts L1 reconciliation reports accordingly.

To import balances data, load the SC_Balances.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Balances project:

  • SC_Balances: Loads general ledger account opening balances, customer balances, and vendor balances into SAP S/4HANA.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

Microsoft Dynamics 365 Finance and Operations

To import transaction data, load the SC_Journals.atl file from\\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Journals project:

  • SC_Journals: Manages both initial (OT) and incremental (CDC) data loads for journal data, with an option to concurrently run L1-L3 reconciliation reports.
  • SC_CDC_Set_Status_On: Enables the incremental data load for the SC_Journals job.
  • SC_CDC_Set_Status_Off: Disables the incremental data load for the SC_Journals job.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Reprocess: Processes data for transactions that failed during initial and incremental data loads.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.
  • SC_Level1_Refresh: Verifies missing source records, updates corresponding tables, and adjusts L1 reconciliation reports accordingly.

To import balances data, load the SC_Balances.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Balances project:

  • SC_Balances: Loads general ledger account opening balances, customer balances, and vendor balances into SAP S/4HANA.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import AVL data, load the SC_AVL.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_AVL project:

  • SC_CI_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for customer invoice information.
  • SC_CO_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for customer order information.
  • SC_PO_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for purchase order information.
  • SC_SI_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for sales invoice information.

Microsoft Dynamics 365 Business Central (On-premises and Cloud)

To import transaction data, load the SC_Journals.atl file from\\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Journals project:

  • SC_Journals: Manages both initial (OT) and incremental (CDC) data loads for journal data, with an option to concurrently run L1-L3 reconciliation reports.
  • SC_CDC_Set_Status_On: Enables the incremental data load for the SC_Journals job.
  • SC_CDC_Set_Status_Off: Disables the incremental data load for the SC_Journals job.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Reprocess: Processes data for transactions that failed during initial and incremental data loads.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.
  • SC_Level1_Refresh: Verifies missing source records, updates corresponding tables, and adjusts L1 reconciliation reports accordingly.

To import balances data, load the SC_Balances.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Balances project:

  • SC_Balances: Loads general ledger account opening balances, customer balances, and vendor balances into SAP S/4HANA.

Epicor iScala

To import transaction data, load the iScala_Journals.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the iScala_Journals project:

  • SCA_Journals_OT: Performs an initial data load for journal data.
  • SCA_Journals_CDC: Performs an incremental data load for journal data.
  • SCACDC_Set_Status_On: Enables the incremental data load for the SCA_Journals_CDC job.
  • SCACDC_Set_Status_Off: Disables the incremental data load for the SCA_Journals_CDC job.
  • SCA_Reprocess_Journals: Processes data for transactions that failed during initial and incremental data loads.
  • Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import balances data, load the iScala_Balances.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the iScala_Balances project:

  • SCA_GL_Account_Balances: Loads general ledger account opening balances into SAP S/4HANA.
  • SCA_Customer_Balances: Loads customer balances into SAP S/4HANA.
  • SCA_Vendor_Balances: Loads vendor balances into SAP S/4HANA.

To import drilldown data, load the iScala_SCD.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the iScala_SCD project:

  • IScala_OT_AP_TRX: Transfers historic and one-time data from the Payables tables in the iScala system to the corresponding mirror tables in the Transaction Replication Stage environment.
  • IScala_OT_AR_TRX: Transfers historic and one-time data from the Receivables tables in the iScala system to the corresponding mirror tables in the Transaction Replication Stage environment.
  • IScala_OT_GL_TRX: Transfers historic and one-time data from the General Ledger tables in the iScala system to the corresponding mirror tables in the Transaction Replication Stage environment.
  • IScala_OT_PO_TRX: Transfers historic and one-time data from the Purchase Orders tables in the iScala system to the corresponding mirror tables in the Transaction Replication Stage environment.
  • IScala_OT_SO_TRX: Transfers historic and one-time data from the Sales Order tables in the iScala system to the corresponding mirror tables in the Transaction Replication Stage environment.
  • IScala_OT_MASTER_DATA: Transfers historic and one-time data from the Entity tables (such as customer, vendor, material, etc.) in the iScala system to the corresponding mirror tables in the Transaction Replication Stage environment.
  • SCD_JOB_ISCALA_CDC: Initiates the incremental data transfer from master and transaction tables in the iScala system to the corresponding mirror tables in the Transaction Replication Stage environment.

Infor CloudSuite Industrial (SyteLine)

To import transaction data, load the Syteline_Journals.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the Syteline_Journals project:

  • Syteline_Journals_OT: Performs an initial data load for journal data.
  • Syteline_Journals_CDC: Performs an incremental data load for journal data.
  • SytelineCDC_Set_Status_On: Enables the incremental data load for the Syteline_Journals_CDC job.
  • SytelineCDC_Set_Status_Off: Disables the incremental data load for the Syteline_Journals_CDC job.
  • Syteline_Reprocess_Journals: Processes data for transactions that failed during initial and incremental data loads.
  • Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import balances data, load the Syteline_Balances.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the Syteline_Balances project:

  • Syteline_GL_Account_Balances: Loads general ledger account opening balances into SAP S/4HANA.
  • Syteline_Customer_Balances: Loads customer balances into SAP S/4HANA.
  • Syteline_Vendor_Balances: Loads vendor balances into SAP S/4HANA.

Infor Baan

To import transaction data, load the BAAN_Journals.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the BAAN_Journals project:

  • BAAN_Journals_OT: Performs an initial data load for journal data.
  • BAAN_Journals_CDC: Performs an incremental data load for journal data.
  • BAANCDC_Set_Status_On: Enables the incremental data load for the BAAN_Journals_CDC job.
  • BAANCDC_Set_Status_Off: Disables the incremental data load for the BAAN_Journals_CDC job.
  • BAAN_Reprocess_Journals: Processes data for transactions that failed during initial and incremental data loads.
  • Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import balances data, load the BAAN_Balances.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the BAAN_Balances project:

  • BAAN_GL_Balances: Loads general ledger account opening balances into SAP S/4HANA.
  • BAAN_Customer_Balances: Loads customer balances into SAP S/4HANA.
  • BAAN_Vendor_Balances: Loads vendor balances into SAP S/4HANA.

Infor LN (On-Premises)

To import transaction data, load the SC_Journals.atl file from\\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Journals project:

  • SC_Journals: Manages both initial (OT) and incremental (CDC) data loads for journal data, with an option to concurrently run L1-L3 reconciliation reports.
  • SC_CDC_Set_Status_On: Enables the incremental data load for the SC_Journals job.
  • SC_CDC_Set_Status_Off: Disables the incremental data load for the SC_Journals job.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Reprocess: Processes data for transactions that failed during initial and incremental data loads.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.
  • SC_Level1_Refresh: Verifies missing source records, updates corresponding tables, and adjusts L1 reconciliation reports accordingly.

To import balances data, load the SC_Balances.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Balances project:

  • SC_Balances: Loads the general ledger account opening balances, customer balances, and vendor balances into SAP S/4HANA.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import AVL data, load the SC_AVL.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_AVL project:

  • SC_CI_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for customer invoice information.
  • SC_CO_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for customer order information.
  • SC_PO_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for purchase order information.
  • SC_SI_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for sales invoice information.

Workday

To import transaction data, load the Workday_Journals.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the Workday_Journals project:

  • Workday_Journals: Performs an initial data load for journal data.
  • Workday_Reprocess_Journals: Processes data for transactions that failed during data loads.
  • Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import balances data, load the Workday_Balances.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the Workday_Balances project:

  • Workday_GL_Account_Balances: Loads general ledger account opening balances into SAP S/4HANA.
  • Workday_Customer_Balances: Loads customer balances into SAP S/4HANA.
  • Workday_Vendor_Balances: Loads vendor balances into SAP S/4HANA.

QAD

To import transaction data, load the QAD_Journals.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the QAD_Journals project:

  • QAD_Journals: Performs an initial data load for journal data.
  • QAD_Reprocess_Journals: Processes data for transactions that failed during data loads.
  • Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

NetSuite

To import transaction data, load the NetSuite_DataLoad.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the NetSuite_DataLoad project:

  • Netsuite_Account: Loads initial accounting data from your source system.
  • cdc_NetSuite_Account: Loads incremental accounting data from your source system.
  • NetSuite_Accounting_Periods: Loads initial accounting periods data from your source system.
  • cdc_NetSuite_Accounting_Periods: Loads incremental accounting periods data from your source system.
  • NetSuite_Currencies: Loads initial currencies data from your source system.
  • cdc_NetSuite_Currencies: Loads incremental currencies data from your source system.
  • NetSuite_Customers: Loads initial customer data from your source system.
  • cdc_NetSuite_Customers: Loads incremental customer data from your source system.
  • NetSuite_Employees: Loads initial employee data from your source system.
  • cdc_NetSuite_Employees: Loads incremental employee data from your source system.
  • NetSuite_Subsidiaries: Loads initial subsidiary information from your source system.
  • cdc_NetSuite_subsidiary: Loads incremental subsidiary information from your source system.
  • NetSuite_Uom: Loads initial UOM data from your source system.
  • cdc_NetSuite_Uom: Loads incremental UOM data from your source system.
  • NetSuite_Vendors: Loads initial vendor data from your source system.
  • cdc_NetSuite_Vendors: Loads incremental vendor data from your source system.
  • NetSuite_Posting_Account_Activity: Loads initial data for posting account activity from your source system.
  • NetSuite_TransactionLines: Loads initial data for transaction lines from your source system.
  • NetSuite_Transactions: Loads initial transaction data from your source system.
  • NetSuite_trx_CDC: Loads incremental data for transactions, transaction lines, and posting account activity from your source system.
  • NSCDC_Set_Status_Off: Disables the incremental data load process for the NetSuite_trx_CDC job.
  • NSCDC_Set_Status_On: Enables the incremental data load for the NetSuite_trx_CDC job.

Additionally, to import transaction data, load the NetSuite_Journals.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the NetSuite_Journals project:

  • NetSuite_Journals_OT: Performs an initial data load for journal data.
  • NetSuite_Journals_CDC: Performs an incremental data load for journal data.
  • NetSuiteCDC_Set_Status_On: Enables the incremental data load for the NetSuite_Journals_CDC job.
  • NetSuiteCDC_Set_Status_Off: Disables the incremental data load process for the NetSuite_Journals_CDC job.
  • NetSuite_Reprocess_Journals: Processes data for transactions that failed during initial and incremental data loads.
  • Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import balances data, load the NetSuite_Balances.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the NetSuite_Balances project:

  • NetSuite_GL_Account_Balances: Loads general ledger account opening balances into SAP S/4HANA.
  • NetSuite_Customer_Balances: Loads customer balances into SAP S/4HANA.
  • NetSuite_Vendor_Balances: Loads vendor balances into SAP S/4HANA.

Deltek Costpoint

To import transaction data, load the CSPT_Journals_hvr.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the CSPT_Journals project:

  • CSPT_Journals_OT: Performs an initial data load for the journal data.
  • CSPT_Journals_CDC: Performs an incremental data load for the journal data.
  • CSPTCDC_Set_Status_on: Enables the incremental data load for the CSPT_Journals_CDC job.
  • CSPTCDC_Set_Status_Off: Disables the incremental data load for the CSPT_Journals_CDC job.
  • CSPT_Reprocess_Journals: Processes data for transactions that failed during initial and incremental data loads.
  • Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

1C:Enterprise

To import transaction data, load the 1C_Journals.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the 1C_Journals project:

  • 1C_Journals: Performs an initial data load for the journal data.
  • 1C_Reprocess_Journals: Processes data for transactions that failed during data loads.
  • Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import balances data, load the 1C_Balances.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the 1C_Balances project:

  • 1C_Balances: Loads general ledger account opening balances, customer balances, and vendor balances into SAP S/4HANA.

To import drilldown data, load the 1C_SCD.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the 1C_SCD project:

  • 1C_SCD_Trx: Transfers data from the 1C system to the corresponding mirror tables in the Transaction Replication Stage environment.

Flat File

To import transaction data, load the SC_Journals.atl file from\\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Journals project:

  • SC_Journals: Manages both initial (OT) and incremental (CDC) data loads for journal data, with an option to concurrently run L1-L3 reconciliation reports.
  • SC_CDC_Set_Status_On: Enables the incremental data load for the SC_Journals job.
  • SC_CDC_Set_Status_Off: Disables the incremental data load for the SC_Journals job.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Reprocess: Processes data for transactions that failed during initial and incremental data loads.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.
  • SC_Level1_Refresh: Verifies missing source records, updates corresponding tables, and adjusts L1 reconciliation reports accordingly.

To import balances data, load the SC_Balances.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_Balances project:

  • SC_Balances: Loads general ledger account opening balances, customer balances, and vendor balances into SAP S/4HANA.
  • SC_Generate_Cache: Updates cache files, enabling them for transactions and syncback, as applicable.
  • SC_Master_Lookup_Load: Loads master data from MSC_Lookup_Data.xlsx into the MSC_MASTER_LOOKUP table and creates a persistent cache for lookup data.

To import AVL data, load the SC_AVL.atl file from \\Mappings into your SAP Data Services repository. This creates the following jobs within the SC_AVL project:

  • SC_CI_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for customer invoice information.
  • SC_CO_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for customer order information.
  • SC_PO_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for purchase order information.
  • SC_SI_STAGE_LOAD: Performs an initial (OT) and incremental (CDC) data load for sales invoice information.

Reconciliation

To import reconciliation data, load the <SourceSystem>_RECON_L1_L5.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the <SourceSystem>_RECON_L1_L5 project:

  • <SourceSystem>_Account_Recon: Loads initial account balances from the source system and SAP S/4HANA into the LEVEL5_RECON_GLBAL_STG table in the staging schema.
  • <SourceSystem>_Period_Balances_CDC: Loads incremental account balances from the source system's balances table into the <SourceSystem>_SOURCE_BALANCES tables in the staging schema.
  • <SourceSystem>_Period_Balances_OT: Loads initial account balances from the source system's balances table into the <SourceSystem>_SOURCE_BALANCES tables in the staging schema.
  • <SourceSystem>_Period_Balances: (for GP) Loads the initial and incremental reconciliation for account balances.
  • <SourceSystem>_S4_FIN_Dataload: Loads initial journal information from SAP S/4HANA into the S4_FIN_TRX_STG table in the staging schema.
  • <SourceSystem>_S4_FIN_Dataload_CDC: Loads incremental journal information from SAP S/4HANA into the S4_FIN_TRX_STG table in the staging schema.
  • <SourceSystem>_Source_Doc_Info: Loads initial journal information from the source table in the source schema into the SOURCE_DOC_INFO table in the staging schema.
  • <SourceSystem>_Source_Doc_Info_CDC: Loads incremental journal information from the source table in the source schema into the SOURCE_DOC_INFO table in the staging schema.
  • <SourceSystem>_SRCDOC_Set_Status_Off: Disables the incremental data load for the <SourceSystem>_Source_Doc_Info_CDC job.
  • <SourceSystem>_SRCDOC_Set_Status_On: Enables the incremental data load for the <SourceSystem>_Source_Doc_Info_CDC job.
  • <SourceSystem>CDC_PERIOD_Bal_Set_Status_Off: Disables the incremental data load for the <SourceSystem>_Period_Balances_CDC job.
  • <SourceSystem>CDC_PERIOD_Bal_Set_Status_On: Enables the incremental data load for the <SourceSystem>_Period_Balances_CDC job.

To import reconciliation data, load the RECON_STG.atl file from \\Mappings into the SAP Data Services repository. This creates the following jobs within the RECON_STG project:

  • RECON_CDC: Performs an incremental data load into the LEVEL<1|2|3|4|5>_RECON%_STG tables in the staging schema. The system skips the job when no new or changed records are detected.
  • RECON_DEL_HIST: Deletes historical data in the LEVEL<1|2|3|4|5>_RECON_STG tables based on the values provided for the Company, Fiscal Year and/or Fiscal Period parameters during the job run.
  • RECON_OT: Performs an initial data load into the LEVEL<1|2|3|4|5>_RECON%_STG tables in the staging schema.
  • RECONCDC_Set_Status_On: Enables the incremental data load for the RECON_CDC job.
  • RECONCDC_Set_Status_Off: Disables the incremental data load for the job.
  • SLT_FIN_STG: Performs an initial data load from the SLT tables into the SLT_DATA table in the staging schema.
  • SLT_FIN_STG_CDC: Performs an incremental data load from the SLT tables into the SLT_DATA table in the staging schema.
  • RECON_L1_L3: Refreshes L1-L3 reconciliation reports.
  • RECON_L4_L5: Refreshes L4 and L5 reconciliation reports.

Cleanup

The following job is common for all source systems.

  • SCT_CLEANUP: Performs data cleanup according to specified parameters.

Global Variables

Before executing the jobs to load data from the source system into the SLT Replication Server, ensure you update the relevant global variables. Some variables are specific to only certain source systems. For more information on running the jobs, refer toLoading Data and Reprocessing Documents.

Note: The capitalization of the variables may differ across source systems.

GL Balances Job

The list of variables that you need to specify before running the <SourceSystem>_GL%Balances job in the <SourceSystem>_Balances project is as follows:

  • $set_of_book_id/$Ledger_id: Optional; it indicates the set of books/ledger identifier using which the general ledger balance is extracted.
  • $Company_Code: Indicates the company code (balancing segment) using which the general ledger account balances are extracted for a company.
  • $Year_to_Extract/$Fiscal_Year_To_Extract: Indicates the year in which the balances are extracted from the source system.
  • $Period_Name_to_extract: (Only for NetSuite) Indicates the period name using which the balances are extracted from the source system. For example, specify "Dec 2018".
  • $Period_Num_to_Extract: Indicates the period number using which the balances are extracted.
  • $Natural_Account: Indicates the account number for which the balances are extracted from the source system.
  • $Year_to_Post/$Fiscal_Year_To_Post: Indicates the year in which the balances are posted to SAP S/4HANA.
  • $GL_Date: Indicates the general ledger date on which the balance is posted to SAP S/4HANA.
  • $GL_Clearing_Account/$clearing_account: Indicates the general ledger account number to which the clearing amount is posted to balance the journal.

GL Open Item Balances Job

The list of variables that you need to specify before running the <SourceSystem>_GL%OPEN_ITEM job in the <SourceSystem>_GL_OPEN_ITEM project is as follows:

  • $G_GL: Indicates whether the journals pertaining to general ledger can be loaded into SAP S/4HANA; set to 1 to enable the load for general ledger.
  • $G_SLT: Indicates whether the documents can be loaded into SLT Replication Server; set to 1 to enable SLT for the data load.
  • $G_FROM_DATE: Indicates the date from which the journals are processed in the DD-MON-YYYY format. For example, 29-MAR-2022.
  • $G_TO_DATE: Indicates the date up to which the journals are processed in the DD-MON-YYYY format. For example, 29-MAR-2022.
  • $G_COMP_CODE/$COMP_CODE: For Oracle E-Business Suite, use $G_COMP_CODE and for Oracle PeopleSoft, use $COMP_CODE , to enter the company code for which you want to load the general ledger open items.
  • $G_GL_CLEARING_ACCOUNT: Enter the general ledger account to which any offset amounts are posted.

Vendor Balances Job

The list of variables that you need to specify before running the <SourceSystem>%Vendor_Balances job in the <SourceSystem>_Balances project is as follows:

  • $Ledger_id: Indicates the ledger identifier using which the vendor balance is extracted.
  • $As_of_date: Indicates the date up to which the balance is calculated and extracted.
  • $vendor_id/$Vendor_number: Optional; it indicates whether the job is run for a specific vendor or for all vendors; specify the vendor number to run the job for a single vendor or leave it blank to run the job for all vendors.
  • $Vendor_Clearing_Account: Indicates the vendor account number to which the clearing amount is posted to balance the journal.
  • $AP_Clearing_Account: Indicates the Accounts Payable account to which any offset amounts are posted.
  • $gl_date: Indicates the general ledger date on which the balance is posted to SAP S/4HANA.
  • $Year_to_Post/$Fiscal_Year_To_Post: Indicates the year in which the balances are posted to SAP S/4HANA.
  • $Period_Num_to_post: Indicates the period number using which the balances are posted.
  • $Summary_Mode: Y indicates that the balances are posted as transaction for each vendor. N indicates that the balances are posted as transaction for each invoice.
  • $G_SLT: Indicates whether the documents can be loaded into SLT Replication Server; set to 1 to enable SLT for the data load.
  • $<SourceSystem>_Company/$Company_Code: Indicates the company code (balancing segment) using which the vendor balances for a company are extracted.
  • $G_DB_TYPE: Indicates the staging database type.
  • $RUN_ID: Indicates the unique job run identifier used by different source systems for the same job.

Customer Balances Job

The list of variables that you need to specify before running the <SourceSystem>%Customer_Balances job in the <SourceSystem>_Balances project is as follows:

  • $Ledger_id: Indicates the ledger identifier using which the customer balance is extracted.
  • $<SourceSystem>_Company: Indicates the company code (balancing segment) using which the customer balances for a company are extracted.
  • $As_of_date: Specifies the date up to which the balance is calculated and extracted.
  • $Customer_Number: Optional; it indicates whether the job is run for a single customer or for all customers; specify the customer number to run the job for a single customer or leave it blank to run the job for all customers.
  • $Customer_clearing_account: Indicates the general ledger account number to which the clearing amount is posted to balance the journal.
  • $GL_Date: Indicates the general ledger date on which the balance is posted to SAP S/4HANA.
  • $Year_to_post: Indicates the year in which the balance is posted to SAP S/4HANA.

1C_Balances Job

  • $1C_FILEPATH: Indicates the path in which the .csv file containing the source data is available.
  • $v_email: Indicates the email address of the point of contact. The error messages or notifications are sent to the specified email address.
  • $POSTING_DATE: Indicates the date up to which the balances gets posted into SAP S/4HANA.
  • $CLEARING_ACCOUNT: Indicates the account number to which the clearing amount is posted to balance the journal.
  • $SOURCE_SYSTEM: Indicates the source system for which the balance is extracted.

1C_SCD_Trx Job

  • $UFF_FILEPATH_SRC1: Indicates the folder path where the flat files are available.
  • $UFF_ARCHIVE_SRC1: Indicates the archive folder path where the processed files are moved.
  • $UFF_SRC1_EXCEPTION: Indicates the folder path where the exception files are created.
  • $G_SOURCE_SYSTEM: Indicates the source system name.
  • $G_USER: Indicates the Created By username.

Stage Load Job

The list of variables that you must provide before running the AVL-related jobs is as follows:

  • $FILE_PATH: Indicates the location of the Master lookup file.
  • $STAGE_DB: Indicates the Staging database, such as SQL Server, HANA.
  • $<SourceSystem>_CO_OT: Indicates intial load if set to '1'.
  • $<SourceSystem>_CI_OT: Indicates intial load if set to '1'.
  • $<SourceSystem>_CI_CDC: Indicates incremental load if set to '1'.
  • $<SourceSystem>_CO_CDC: Indicates incremental load if set to '1'.
  • $<SourceSystem>_PO_OT: Indicates intial load if set to '1'.
  • $<SourceSystem>_PO_CDC: Indicates incremental load if set to '1'.
  • $<SourceSystem>_SI_OT: Indicates intial load if set to '1'.
  • $<SourceSystem>_SI_CDC: Indicates incremental load if set to '1'.
  • $G_DB_TYPE: Indicates the staging database type.
  • $G_ERP: Indicates the ERP type. PSFT, UC, EBS, D365FNO, MSFTBC, InforLN
  • $SCT_VERSION: Indicates the product version.
  • $G_JOB_NAME: Indicates the job name that is run.

SC Balances Job

The list of variables for the SC_Balances job:

  • $G_ERP: Indicates the ERP name, such as InforLN, EBS, JDE, PSFT, D365FNO, MSFTBC, MSFTGP, or UC.
  • $G_SOURCE_SYSTEM: Indicates the source system name.
  • $G_UC_FOLDER_LOCATION: (for UC) Indicates the folder path from which the utility should retrieve files. If left blank, the utility will default to the folder path defined in the SourceConnect Management Console Connection tab during UC datasource configuration.
  • $G_UC_File_Wildcard: (for UC) Indicates the file name pattern (wildcard) that the utility should use to identify relevant files. The default value is *.CSV. Some examples include UC_*.CSV, EBS_*.CSV.
  • $G_UC_Skipped_Rows: (for UC) Indicates the number of initial data rows to skip during file extraction. The default value is 0. Only positive integers are allowed.

    Note: Do not include empty lines in this count. Only count rows that contain data and need to be skipped. For example, if rows 1–3 contain data and rows 4–5 are empty, enter 3 as the value. The empty rows will be skipped automatically.

  • $G_DB_TYPE: Indicates the database type (HANA, Microsoft_SQL_Server).
  • $G_CUSTOMER: Indicates whether to load the customer journals into SAP S/4HANA. Set to 1 if yes.
  • $G_VENDOR: Indicates whether to load the vendor journals into SAP S/4HANA. Set to 1 if yes.
  • $G_GL: Indicates whether the journals pertaining to general ledger can be loaded into SAP S/4HANA; set to 1 to enable the load for general ledger.
  • $G_SLT: Indicates whether the documents can be loaded into SLT Replication Server; set to 1 to enable SLT for the data load.
  • $G_FISCAL_YEAR: Indicates the year for which the data should be deleted in the LEVEL<1|2|3|4|5>_RECON%_STG tables in the staging schema.
  • $G_GL_DATE: Indicates the posting date, which can be either the current date or a specified date to run the job.
  • $G_LEDGER_ID: Indicates the ledger identifier using which the customer balance is extracted.
  • $G_AS_OF_DATE: Specifies the date up to which the balance is calculated and extracted.
  • $G_TRANSACTION_ID: Indicates a combination of Header ID and Doc type separated with a colon (:). Example: ‘20240001:ARC’ or ‘20240001'.
  • $G_PERIOD_NUM_TO_EXTRACT: Indicates the month up to which the data should be loaded (example, January = 01).
  • $G_COMPANY_CODE: Indicates the company code (balancing segment) using which the general ledger account balances are extracted for a company.
  • $G_GL_CURRENCY_CODE: Filters records based on currency.
  • $G_AP_CLEARING_ACCT: Indicates the AP Clearing Account to be loaded for the clearing lines.
  • $G_AR_CLEARING_ACCT: Indicates the AR Clearing Account to be loaded for the clearing lines.
  • $G_GL_CLEARING_ACCT: Indicates the GL Clearing Account to be loaded for the clearing lines.
  • $G_CLEARING_ACCOUNT_FOR_POPACCTPROC: Indicates the clearing account value.
  • $G_UC_LOG_FILEPATH: Indicates the location of the log file to be loaded for error records.
  • $G_EMAIL: Indicates the email for job notifications.

SC Journals Job

The list of variables for the SC_Journals and SC_Reprocess jobs:

  • SC_Journals
    • $G_ERP: Indicates the ERP name, such as InforLN, EBS, JDE, PSFT, D365FNO, MSFTBC, MSFTGP, or UC.
    • $G_SOURCE_SYSTEM: Indicates the source system name.
    • $G_UID: Indicates that it is automatically triggered from Management console.
    • $G_COMMIT_SIZE: (for UC) Indicates the commit size. Default is 100000.
    • $G_UC_FOLDER_LOCATION: (for UC) Indicates the folder path from which the utility should retrieve files. If left blank, the utility will default to the folder path defined in the SourceConnect Management Console Connection tab during UC datasource configuration.
    • $G_UC_File_Wildcard: (for UC) Indicates the file name pattern (wildcard) that the utility should use to identify relevant files. The default value is *.CSV. Some examples include UC_*.CSV, EBS_*.CSV.
    • $G_UC_Skipped_Rows: (for UC) Indicates the number of initial data rows to skip during file extraction. The default value is 0. Only positive integers are allowed.

      Note: Do not include empty lines in this count. Only count rows that contain data and need to be skipped. For example, if rows 1–3 contain data and rows 4–5 are empty, enter 3 as the value. The empty rows will be skipped automatically.

    • $G_DB_TYPE: Indicates the database type (HANA, Microsoft_SQL_Server).
    • $G_RUN_OT: Indicates whether to run OT (1 to run, 0 otherwise).
    • $G_AP: (for JDE and EBS) Indicates whether to run the AP module (1 to run, 0 otherwise).
    • $G_AR: (for JDE and EBS) Indicates whether to run the AR module (1 to run, 0 otherwise).
    • $G_GL: (for JDE and EBS) Indicates whether to run the GL module (1 to run, 0 otherwise).
    • $G_SLT: Indicates whether to run SLT (1 to run, 0 otherwise).
    • $G_HEADER_ID:
      • (for JDE) Indicates a combination of Company code, Doc batch, and Doc number/Doc number join separated with a colon (:). Example: ‘00001:1893:1083’ or ‘00001::’.
      • (for EBS, PSFT, D365FNO, MSFTBC, MSFTGP) Indicates the JE_HEADER_ID value.
      • (for InforLN) Indicates a combination of Company code, Doc type, and Header ID separated with a colon (:). Example: ‘121:ARC:20240001’ or ‘121:ARC’ or '121'.
    • $G_FROM_DATE: Indicates the start date from which data should be fetched and loaded.
    • $G_TO_DATE: Indicates the end date until which data should be fetched and loaded.
    • $G_AP_CLEARING_ACCT: Indicates the AP Clearing Account to be loaded for the clearing lines.
    • $G_AR_CLEARING_ACCT: Indicates the AR Clearing Account to be loaded for the clearing lines.
    • $G_GL_CLEARING_ACCT: Indicates the GL Clearing Account to be loaded for the clearing lines.
    • $IF_COPA: (for EBS, GP, UC) Indicates if there are copa fields (1 to load copa fields for a document, 0 otherwise).
    • $IF_EXTENT: Indicates if there are any extension fields (1 to load extension fields for a document, 0 otherwise).
    • $G_RUN_CDC: Indicates whether to run CDC (1 to run, 0 otherwise).
    • $G_SUBSCRIPTION: Indicates the subscription name to be provided when the job is triggered for CDC load.
    • $RE_INITIALIZE_TAB: Indicates the status of the CDC records when loaded for the first time (set to ‘N’).
    • $G_RUN_RECON: Indicates whether to run reconciliation reports (1 to run, 0 otherwise).
    • $G_LOGICAL_SYSTEM: Indicates the logical system for which the account balances data is loaded into the staging schema from the source system and SAP S/4HANA.
    • $G_SELECT_RECON_REPORT: Indicates the reconciliation report to be run. Default is L1, L2, L3.
    • $G_LOCATION: Indicates the location of the recon records to load. Default is ‘ALL’.
    • $CDC_HIST_DEL_DAYS: Indicates the required days to refresh CDC history.
    • $G_VALIDATE_AIF: Indicates whether to validate AIF errors ('Y' to validate).
    • $G_UC_LOG_FILEPATH: Indicates the location of the log file to be loaded for error records.
    • $G_EMAIL: Indicates the email for job notifications.
  • SC_Reprocess
    • $G_ERP: Indicates the ERP name, such as InforLN, EBS, JDE, PSFT, D365FNO, MSFTBC, MSFTGP, or UC.
    • $G_SOURCE_SYSTEM: Indicates the source system name.
    • $G_UID: Indicates that it is automatically triggered from Management console.
    • $G_DB_TYPE: Indicates the database type (HANA, Microsoft_SQL_Server).
    • $G_COMMIT_SIZE: (for UC) Indicates the commit size. Default is 100000.
    • $G_UC_FOLDER_LOCATION: (for UC) Indicates the folder path from which the utility should retrieve files. If left blank, the utility will default to the folder path defined in the SourceConnect Management Console Connection tab during UC datasource configuration.
    • $G_UC_File_Wildcard: (for UC) Indicates the file name pattern (wildcard) that the utility should use to identify relevant files. The default value is *.CSV. Some examples include UC_*.CSV, EBS_*.CSV.
    • $G_UC_Skipped_Rows: (for UC) Indicates the number of initial data rows to skip during file extraction. The default value is 0. Only positive integers are allowed.

      Note: Do not include empty lines in this count. Only count rows that contain data and need to be skipped. For example, if rows 1–3 contain data and rows 4–5 are empty, enter 3 as the value. The empty rows will be skipped automatically.

    • $G_SLT: Indicates whether to run SLT (1 to run, 0 otherwise).
    • $IF_COPA: (for EBS, GP, UC) Indicates if there are copa fields (1 to load copa fields for a document, 0 otherwise).
    • $IF_EXTENT: Indicates if there are any extension fields (1 to load extension fields for a document, 0 otherwise).
    • $G_USE_AUTO_INPUT: Indicates whether records are picked in an automated process. Set to ‘Y’ to run, else ‘N’.
    • $G_USE_MANUAL_INPUT: Indicates whether records are picked in a manual process. Set to ‘Y’ to run, else ‘N’.
    • $G_PROCESS_MISSING_DOCS: Indicates whether to check for source missing records. Set to ‘Y’ to run, else ‘N’.
    • $G_Process_Validation_Errors: Indicates whether to check for stage error records. Set to ‘Y’ to run, else ‘N’.
    • $G_Process_AIF_UIDs: Indicates whether to check for AIF error records. Set to ‘Y’ to run, else ‘N’.
    • $G_UC_LOG_FILEPATH: Indicates the location of the log file to be loaded for error records.
    • $G_UC_REPROCESS_FILEPATH: Indicates the location of the reprocess file to be loaded for error records.
    • $G_FROM_DATE: Indicates the start date from which data should be fetched and loaded.
    • $G_TO_DATE: Indicates the end date from which data should be fetched and loaded.
    • $G_AP_CLEARING_ACCT: Indicates the AP Clearing Account to be loaded for the clearing lines.
    • $G_AR_CLEARING_ACCT: Indicates the AR Clearing Account to be loaded for the clearing lines.
    • $G_GL_CLEARING_ACCT: Indicates the GL Clearing Account to be loaded for the clearing lines.
    • $G_CLEARING_ACCOUNT_FOR_POPACCTPROC: Indicates the clearing account value.
    • $G_RUN_RECON: Indicates whether to run reconciliation reports (1 to run, 0 otherwise).
    • $G_LOGICAL_SYSTEM: Indicates the logical system for which the account balances data is loaded into the staging schema from the source system and SAP S/4HANA.
    • $G_SELECT_RECON_REPORT: Indicates the reconciliation report to be run. Default is L1, L2, L3.
    • $G_LOCATION: Indicates the location of the recon records to load. Default is ALL.
    • $CDC_HIST_DEL_DAYS: Indicates the required days to refresh CDC history.

Journals Job

The list of variables that must specify before running the <SourceSystem>_Journals job in the <SourceSystem>_Journals project is as follows:

  • $<SourceSystem>_FILEPATH: Indicates the path in which the .csv file containing the source data is available.
  • $DOC_SPLIT_CLEARING_ACCOUNT: Indicates the general ledger account to which any offset amounts are posted.
  • $v_<SourceSystem>_email: Indicates the email address of the point of contact. The error messages are sent to the specified email address.
  • $FileName: Indicates the name of the .csv file containing the source data.
  • $SOURCE_SYSTEM: Indicates the source system for which the journal information is loaded from the source system into the staging schema.

Journals CDC Job

The list of variables that you must specify before running the <SourceSystem>_Journals_CDC job in the <SourceSystem>_Journals project is as follows:

  • $G_GL_CLEARING_ACCOUNT: Indicates the general ledger account to which any offset amounts are posted.
  • $G_AR_CLEARING_ACCOUNT: Indicates the receivables account to which any offset amounts are posted.
  • $G_AP_CLEARING_ACCOUNT: Indicates the Accounts Payable account to which any offset amounts are posted.

Journals OT, Reprocess Journals Jobs

The list of variables that you must specify before running the <SourceSystem>_Journals_OT or <SourceSystem>_Reprocess_Journals job in the <SourceSystem>_Journals project is as follows:

  • $G_AP: Indicates whether the journals/documents pertaining to Accounts Payable can be loaded into SLT Replication Server; set to 1 to enable the load for Accounts Payable.
  • $G_AR: Indicates whether the journals/documents pertaining to Accounts Receivable can be loaded into SLT Replication Server; set to 1 to enable the load for Accounts Receivable.
  • $G_GL: Indicates whether the journals/documents pertaining to General Ledger can be loaded into SLT Replication Server; set to 1 to enable the load for General Ledger.
  • $G_SLT: Indicates whether the documents can be loaded into SLT Replication Server; set to 1 to enable SLT for the data load.
  • $G_FROM_DATE: Indicates the date from which the journals are processed.
  • $G_TO_DATE: Indicates the date up to which the journals are processed.
  • $G_GL_CLEARING_ACCOUNT: Indicates the general ledger account to which any offset amounts are posted.
  • $G_AR_CLEARING_ACCOUNT: Indicates the receivables account to which any offset amounts are posted.
  • $G_AP_CLEARING_ACCOUNT: Indicates the Accounts Payable account to which any offset amounts are posted.
  • $<SourceSystem>_FILEPATH: Indicates the path in which the .csv file containing the source data is available.
  • $DOC_SPLIT_CLEARING_ACCOUNT: Indicates the general ledger account to which any offset amounts are posted.
  • $v_<SourceSystem>_email: Indicates the email address of the point of contact. The error messages are sent to the specified email address.

The following variables indicate whether the job is run for a specific journal or for all journals:

  • $Doc_Number: For JD Edwards EnterpriseOne, specify the gldoc column value of the F0911 table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $Doc_Batch: For JD Edwards EnterpriseOne, specify the glicu column value of the F0911 table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $Company: For JD Edwards EnterpriseOne, specify the glco column value of the F0911 table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $JE_HEADER_ID: For PeopleSoft, specify the JOURNAL_ID column value of the PS_JRNL_HEADER table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $Company_Code: For PeopleSoft, specify the BUSINESS_UNIT column value of the PS_VOUCHER table in the source database to run the job for the vouchers created in the required business unit or leave it blank to run the job for the vouchers created in all business units.
  • $JE_HEADER_ID: For Oracle E-Business Suite, specify the je_header_id column value of the GL_JE_HEADRES table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $JE_HEADER_ID: For IFS Applications, specify the VOUCHER_NO column value of the GEN_LED_VOUCHER_TAB table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $REC_ID: For Microsoft Dynamics AX, specify the RECID column value of the GENERALJOURNALENTRY table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $REC_ID: For Microsoft Dynamics NAV, specify the NO_ column value of the %G_L Register table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $BATCH_NO: For Microsoft Dynamics SL, specify the BATNBR column value of the BATCH table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $JE_HEADER_ID: For Microsoft Dynamics GP, specify the JRNENTRY column value of the GL20000 table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $TRX_NO: For Epicor iScala, specify the GL06002 column value of the GL06 table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $JOURNAL_NO: For Epicor iScala, specify the GL06023 column value of the GL06 table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $Batch_id: For Infor CloudSuite Industrial (SyteLine), specify the journal_batch_id column value of the LEDGER_MST table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $REF_NO: For Infor CloudSuite Industrial (SyteLine), specify the check_num column value of the LEDGER_MST table in the source database for payment documents or the voucher column value in the table for other documents to run the job for the required journal or leave it blank to run the job for all journals.
  • $T_ODOC: For Infor Baan, specify the T_ODOC column value of the TTFGLD106<CompanyCode> table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $G_TRANSACTION_ID: For NetSuite, specify the TRANSACTION_ID column value of the NS_TRANSACTIONS table in the source database to run the job for the required journal or leave it blank to run the job for all journals.
  • $G_HEADER_KEY: For Deltek Costpoint, specify the LVL1_KEY column value of the GL_POST_SUM table in the source database to run the job for the required journal or leave it blank to run the job for all journals.

SC AVL Jobs

The list of variables for the SC_CI_STAGE_LOAD, SC_CO_STAGE_LOAD, SC_PO_STAGE_LOAD, SC_SI_STAGE_LOAD jobs.

  • $FILE_PATH: (for UC) Indicates the location of the file.
  • $G_RUN_OT: Indicates whether to execute the job once (1 to run, 0 otherwise).
  • $G_RUN_CDC: Indicates whether to execute incremental runs (1 to run, 0 otherwise).
  • $G_SLT: Indicates whether the documents can be loaded into the SLT Replication Server (1 to enable SLT for the data load, 0 otherwise).
  • $G_DB_TYPE: Indicates the database type (HANA, Microsoft_SQL_Server).
  • $G_MANDT: Indicates the client that is used for SAP Central Finance.
  • $G_DB_VERSION: Indicates the database version.
  • $G_ERP: Indicates the ERP name, such as InforLN, EBS, PSFT, D365FNO, or UC.
  • $G_FROM_DATE: Indicates the start date for processing journals in the DD-MON-YYYY format. For example, 29-MAR-2022.
  • $G_TO_DATE: Indicates the end date for processing journals in the DD-MON-YYYY format. For example, 29-MAR-2022.
  • $G_CI_IDor$G_CO_IDor$G_PO_IDor$G_SI_ID: Indicates the customer invoice, customer order, purchase order, or sales order ID respectively.
  • $IF_RECON: Indicates whether reconciliation should be executed. Always set to 1.
  • $G_SLEEP: Indicates the delay between each run of a job in milliseconds; modify the value based on the size of the data load with a minimum of 900000 and a maximum of 3600000, which is the default value.
  • $G_SOURCE_SYSTEM: Indicates the source system name.
  • $G_SOURCE_COMPANYCODE: Indicates the company code value in the source.
  • $G_TARGET_COMPANYCODE: Indicates the company code value in the target.
  • $G_LOGICALSYSTEM: Indicates the logical system for which the account balances data is loaded into the staging schema from the source system and SAP S/4HANA.
  • $ARCHIVE_FILE_PATH: (for UC) Indicates the location of the archived file.

Reconciliation Jobs

The list of variables that you must provide before running the Reconciliation data-related jobs are as follows:

  • RECON_CDC Job:
    • $G_Source_ID: Indicates the source system.
    • $G_SLEEP: Indicates the delay between each run of a job in milliseconds; modify the value based on the size of the data load with a minimum of 900000 and a maximum of 3600000, which is the default value.
    • $CDC_HIST_DEL_DAYS: Indicates the number of days for which the job run history is retained for RECON_CDC in the CDC_RECON_STATUS table.
    • $G_LOCATION: Indicates the location of the recon records to load. Default is ‘ALL’.
    • $G_RECON_REPORT: Indicates the reconciliation report to be run. Default is L1, L2, L3, L4, L5.
  • RECON_DEL_HIST Job:
    • $g_comp_code: Optional; indicates the code of the source company for which the data should be deleted in the LEVEL<1|2|3|4|5>_RECON%_STG tables in the staging schema.
    • $g_fiscal_year: Indicates the year for which the data should be deleted in the LEVEL<1|2|3|4|5>_RECON%_STG tables in the staging schema.
    • $g_fiscal_period: Indicates the period of the year for which the data should be deleted in the LEVEL<1|2|3|4|5>_RECON%_STG tables in the staging schema.
  • RECON_OT Job:
    • $G_Source_System: Indicates the source system.
    • $G_Postingdate_Start_Date: Indicates the start date for posting reconciliation.
    • $G_Postingdate_End_Date: Indicates the end date for posting reconciliation.
    • $G_Operation: Indicates if the load is one-time or CDC.
    • $G_RECON_REPORT: Indicates the reconciliation report to be run. Default is L1, L2, L3, L4, L5.
    • $G_LOCATION: Indicates the location of the recon records to load. Default is ‘ALL’.
    • $G_DB_TYPE: Indicates the database type (HANA, Microsoft_SQL_Server).
    • $CDC_HIST_DEL_DAYS: Indicates the number of days for which the job run history is retained for RECON_CDC in the CDC_RECON_STATUS table.
  • SLT_FIN_STG Job
    • $V_START_DATE: Indicates the reconciliation start date.
    • $V_END_DATE: Indicates the reconciliation end date.
    • $G_LOGICAL_SYSTEM: Indicates the logical system for which the account balances data is loaded into the staging schema from the source system and SAP S/4HANA.
  • SLT_FIN_STG_CDC Job
    • $no_of_days: Indicates the last number of days from which the data should be loaded from SLT into the staging schema during the incremental data load.
    • $G_LOGICAL_SYSTEM: Indicates the logical system for which the account balances data is loaded into the staging schema from the source system and SAP S/4HANA.
  • <SourceSystem>_Account_Recon Job
    • $G_LOGICAL_SYSTEM: Indicates the logical system for which the account balances data is loaded into the staging schema from the source system and SAP S/4HANA.
    • $G_Source_System: Indicates the source system.
    • $G_Fiscal_Year: Indicates the fiscal year to load balances.
    • $G_Fiscal_Period: Indicates the fiscal period to load balances.
  • <SourceSystem>_S4_FIN_Dataload Job
    • $SOURCE_TYPE: Indicates the unique number of the source system for which the journal information is loaded into the staging schema.
    • $V_START_DATE: Indicates the reconciliation start date.
    • $V_END_DATE: Indicates the reconciliation end date.
    • $G_LOGICAL_SYSTEM: Indicates the logical system for which the account balances data is loaded into the staging schema from the source system and SAP S/4HANA.
  • <SourceSystem>_S4_FIN_Dataload_CDC Job
    • $SOURCE_TYPE: Indicates the unique number of the source system for which the journal information is loaded from the source system into the staging schema.
    • $no_of_days: Indicates the last number of days from which the data should be loaded from SLT into the staging schema during the incremental data load.
    • $G_LOGICAL_SYSTEM: Indicates the logical system for which the account balances data is loaded into the staging schema from the source system and SAP S/4HANA.
  • <SourceSystem>_Source_Doc_Info, <SourceSystem>_Source_Doc_Info_CDC, <SourceSystem>_SRCDOC_Set_Status_Off, <SourceSystem>_SRCDOC_Set_Status_On Jobs
    • $SOURCE_SYSTEM: Indicates the unique number of the source system for which the journal information is loaded into the staging schema during the incremental data load.
  • RECON_L1_L3 Job
    • $G_Source_ID: Indicates the source system.
    • $G_RECON_REPORT: Indicates the reports that will be refreshed. Default is L1, L2, L3
    • $G_START_DATE: Indicates the reconciliation start date in YYYYMMDD format.
    • $G_END_DATE: Indicates the reconciliation end date in YYYYMMDD format.
    • $G_Operation: Indicates if the load is one-time or CDC.
    • $G_LOCATION: Indicates the location of the recon records to load. Default is ‘ALL’.
    • $G_LOGICAL_SYSTEM: Indicates the logical system for which the account balances data is loaded into the staging schema from the source system and SAP S/4HANA.
  • RECON_L4_L5 Job
    • $G_Source_ID: Indicates the source system.
    • $G_RECON_REPORT: Indicates the reports that will be refreshed. Default is L4,L5.
    • $G_START_DATE: Indicates the reconciliation start date in YYYYMMDD format.
    • $G_END_DATE: Indicates the reconciliation end date in YYYYMMDD format.
    • $G_Operation: Indicates if the load is one-time or CDC.
    • $G_LOCATION: Indicates the location of the recon records to load. Default is ‘ALL’.
    • $G_LOGICAL_SYSTEM: Indicates the logical system for which the account balances data is loaded into the staging schema from the source system and SAP S/4HANA.
  • SC_Level1_Refresh Job
    • $REAL_TIME_LOAD: If set to 1, initiates a refresh for the specified number of days. If set to 0, provides dates for the refresh activity.
    • $G_SOURCE_SYSTEM: Indicates the source system name.
    • $No_of_Refresh_days: Indicates the duration of the refresh in days.
    • $G_FROM_DATE: Indicates the start date for processing journals in the DD-MON-YYYY format. For example, 29-MAR-2022.
    • $G_TO_DATE: Indicates the end date for processing journals in the DD-MON-YYYY format. For example, 29-MAR-2022.

Cleanup Job

The list of variables for the SCT_CLEANUP job.

  • $SCT_FILEPATH: Indicates the location of the cleanup file when using a CSV input.
  • $ARCHIVE_CLEANUP_FILEPATH: Indicates the location of the archived CSV cleanup file.
  • $ARCHIVE_FILEPATH: Indicates the location of the archived file containing records of the deleted data.
  • $G_ERP: Indicates the ERP name.
  • $G_SOURCE_SYSTEM: Indicates the source system name.
  • $G_IF_CSV_INPUT: Indicates whether filters are loaded manually using a CSV file (Y) or updated automatically (N). The filters for automatic cleanup include: $G_FISCAL_YEAR, $G_COMPANY_CODE, $G_DOC_TYPE, $G_FROM_POSTING_DATE, $G_TO_POSTING_DATE, and $G_RUN_ID.
  • $G_IF_FIN: Indicates whether to delete FIN% data (Y).
  • $G_IF_STGONE: Indicates whether to delete MAGNITUDE_STG_ONE data (Y).
  • $G_IF_SLT: Indicates whether to delete SLT data (Y).
  • $G_RUN_ID: Indicates the run IDs to delete.
  • $G_FISCAL_YEAR: Indicates the fiscal year to delete.
  • $G_COMPANY_CODE: Indicates the company code to delete.
  • $G_DOC_TYPE: Indicates the SAP Central Finance document types to delete.
  • $G_FROM_POSTING_DATE: Indicates the start date for deleting data.
  • $G_TO_POSTING_DATE: Indicates the end date for deleting data.

Was this article helpful?

We're sorry to hear that.