Skip to main content

Replicating Master Data for Business Partner, Material, Cost Center, GL Account, and Profit Center Entities

This topic provides job and global variable information required to replicate master data for Business Partner, Material, Cost Center, GL Account, and Profit Center entities.

Perform the following steps to extract data from data sources, import the extracted data into SAP S/4HANA, upload data mappings, and initiate reconciliation:

Note: Reconciliation is only supported for the following entities: Business Partner, Material, Cost Center, and GL Account. For information on reconciliation reports, see SAP Central Finance Master Data Replication Comparison Reports Guide.

  1. In the Local Object Library > Projects tab, open the required job depending on the entity:

    Entity Project Job

    Business Partner

    MDR_ Business_Partner

    MDR_JOB_Business_Partner

    Material

    MDR_Material

    MDR_JOB_Material

    Cost Center

    MDR_Cost_Center

    MDR_JOB_Cost_Center

    GL Account

    MDR_GL_Account

    MDR_JOB_GL_Account

    Profit Center

    MDR_Profit_Center

    MDR_JOB_Profit_Center

  2. Update the values of the following variables in the job using the Tools > Variables option depending on the entity:
    • Business Partner
      1. $G_ERP: Indicates the ERP name, such as EBS, JDE, PSFT, D365FNO, MSFTBC, MSFTGP, or UC.
      2. $G_SOURCE_SYSTEM: Indicates the source system name.
      3. $G_UID: Indicates that the job is automatically triggered from the Management Console.
      4. $G_COMPANY_CODE: Indicates the SAP S/4HANA company code.
      5. $G_COMMIT_SIZE: (for UC) Indicates the commit size. The default value is 100000.
      6. $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 the UC data source configuration.
      7. $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.
      8. $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.

      9. $G_DB_TYPE: Indicates the database type (HANA, Microsoft_SQL_Server).
      10. $G_CUSTOMER_RECON_ACCOUNT: Indicates the customer reconciliation account number.
      11. $G_VENDOR_RECON_ACCOUNT: Indicates the vendor reconciliation account number.
      12. $G_DEFAULT_LANGUAGE: Indicates the language code that must be used if no language code is defined in the source system.
      13. $G_BP_GROUP: Indicates the SAP S/4HANA business partner group for internal number generation.
      14. $G_CLIENT: Indicates the SAP S/4HANA client number.
      15. $G_MDG_SOURCE_SYSTEM: Indicates the logical system name of SAP S/4HANA.
    • Cost Center
      1. $G_ERP: Indicates the ERP name, such as EBS, JDE, PSFT, D365FNO, MSFTBC, MSFTGP, or UC.
      2. $G_SOURCE_SYSTEM: Indicates the source system name.
      3. $G_UID: Indicates that the job is automatically triggered from the Management Console.
      4. $G_COMMIT_SIZE: (for UC) Indicates the commit size. The default value is 100000.
      5. $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 the UC data source configuration.
      6. $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.
      7. $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.

      8. $G_CHART_OF_ACCOUNTS_ID: Indicates the chart of accounts identifier in Oracle E-Business Suite for which the records must be extracted.
      9. $G_COST_CENTER_CATEGORY: Indicates the cost center category of the GL account in SAP.
      10. $G_COMPANY_CODE: Indicates the SAP S/4HANA company code.
      11. $G_CO_AREA: Indicates the controlling area.
      12. $G_MANDT: Indicates the ECC client number.
      13. $G_CLIENT: Indicates the SAP S/4HANA client number.
      14. $G_LANGUAGE: Indicates the language code that must be used for the cost center description.
      15. $G_DB_TYPE: Indicates the database type (HANA, Microsoft_SQL_Server).
      16. $G_MDG_SOURCE_SYSTEM: Indicates the logical system name of SAP S/4HANA.
      17. $G_PARTNER_NUMBER: Indicates the partner number for the IDoc.
    • Profit Center
      1. $G_ERP: Indicates the ERP name, such as EBS, JDE, PSFT, D365FNO, MSFTBC, MSFTGP, or UC.
      2. $G_SOURCE_SYSTEM: Indicates the source system name.
      3. $G_UID: Indicates that the job is automatically triggered from the Management Console.
      4. $G_COMMIT_SIZE: (for UC) Indicates the commit size. The default value is 100000.
      5. $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 the UC data source configuration.
      6. $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.
      7. $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.

      8. $G_COMPANY_CODE: Indicates the SAP S/4HANA company code.
      9. $G_CO_AREA: Indicates the controlling area.
      10. $G_DB_TYPE: Indicates the database type (HANA, Microsoft_SQL_Server).
      11. $G_MDG_SOURCE_SYSTEM: Indicates the logical system name of SAP S/4HANA.
      12. $G_CLIENT: Indicates the ECC client number.
      13. $G_PROFITCENTER_GROUP: Indicates the profit center group.
      14. $G_LANGUAGE: Indicates the language code that must be used for the profit center description.
      15. $G_PARTNER_NUMBER: Indicates the partner number for the IDoc.
    • Material
      1. $G_ERP: Indicates the ERP name, such as EBS, JDE, PSFT, D365FNO, MSFTBC, MSFTGP, or UC.
      2. $G_SOURCE_SYSTEM: Indicates the source system name.
      3. $G_UID: Indicates that the job is automatically triggered from the Management Console.
      4. $G_COMMIT_SIZE: (for UC) Indicates the commit size. The default value is 100000.
      5. $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 the UC data source configuration.
      6. $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.
      7. $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.

      8. $G_DB_TYPE: Indicates the database type (HANA, Microsoft_SQL_Server).
      9. $G_MATERIAL_GROUP: Indicates the material group.
      10. $G_INDUSTRY_SECTOR: Indicates the industry sector of the material.
      11. $G_MDG_SOURCE_SYSTEM: Indicates the logical system name of SAP S/4HANA.
      12. $G_LANGUAGE: Indicates the language code that must be used for the material description.
      13. $G_CLIENT: Indicates the SAP S/4HANA client number.
    • GL Account
      1. $G_ERP: Indicates the ERP name, such as EBS, JDE, PSFT, D365FNO, MSFTBC, MSFTGP, or UC.
      2. $G_SOURCE_SYSTEM: Indicates the source system name.
      3. $G_UID: Indicates that the job is automatically triggered from the Management Console.
      4. $G_COMMIT_SIZE: (for UC) Indicates the commit size. The default value is 100000.
      5. $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 the UC data source configuration.
      6. $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.
      7. $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.

      8. $G_CHART_OF_ACCOUNTS_ID: Indicates the chart of accounts identifier in Oracle E-Business Suite for which the records must be extracted.
      9. $G_ECC_CLIENT: Indicates the ECC client number.
      10. $G_CFIN_CLIENT: Indicates the Central Finance client number.
      11. $G_DB_TYPE: Indicates the database type (HANA, Microsoft_SQL_Server).
      12. $G_FIELD_STATUS_GROUP: Indicates the field status group for the data sources (other than SAP ECC) to load into SAP S/4HANA.
      13. $G_COST_CENTER_CATEGORY: Indicates the cost center category of the GL account in SAP.
      14. $G_PL_ACCOUNT_TYPE: Indicates the P&L statement account type of the GL account in SAP.
      15. $G_PARTNER_NUMBER: Indicates the partner number for the IDoc.
      16. $G_MDG_SOURCE_SYSTEM: Indicates the logical system name of SAP S/4HANA.
  3. Run the job. A message indicating the job status displays.

Was this article helpful?

We're sorry to hear that.