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.
      16. $G_BP_EXTRACT_LOAD: Set to Y to run the source-to-staging extract job only.
      17. $G_BP_GOLD_LOAD: Set to Y to run the staging-to-target gold job only.
      18. $G_BP_MAPPING_LOAD: Set to Y to run the target-to-target mapping job only.
      19. $G_BP_RECON_LOAD: Set to Y to run the target-to-stage reconciliation job only.
      20. $G_BP_CREDIT_GROUP: Indicates the credit group used to categorize and bundle different transactions (such as sales orders or deliveries) for credit checks during Credit Management data replication from EBS to Central Finance.
      21. $G_BP_CREDIT_SEGMET: Indicates the credit segment used to group credit data for separate management during Credit Management data replication from EBS to Central Finance.
      22. $G_BP_RATING_PROC: Indicates the rating procedure used to assess creditworthiness during Credit Management data replication from EBS to Central Finance.
      23. $G_BP_CHECK_RULE: Indicates the check rule that defines the system's conditions for credit verification during order processing in Credit Management data replication from EBS to Central Finance.
    • 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.
      18. $G_CC_EXTRACT_LOAD: Set to Y to run the source-to-staging extract job only.
      19. $G_CC_GOLD_LOAD: Set to Y to run the staging-to-target gold job only.
      20. $G_CC_MAPPING_LOAD: Set to Y to run the target-to-target mapping job only.
      21. $G_CC_RECON_LOAD: Set to Y to run the target-to-stage reconciliation job only.
    • 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.
      16. $G_PC_EXTRACT_LOAD: Set to Y to run the source-to-staging extract job only.
      17. $G_PC_GOLD_LOAD: Set to Y to run the staging-to-target gold job only.
      18. $G_PC_MAPPING_LOAD: Set to Y to run the target-to-target mapping job only.
      19. $G_PC_RECON_LOAD: Set to Y to run the target-to-stage reconciliation job only.
    • 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.
      14. $G_MAT_EXTRACT_LOAD: Set to Y to run the source-to-staging extract job only.
      15. $G_MAT_GOLD_LOAD: Set to Y to run the staging-to-target gold job only.
      16. $G_MAT_MAPPING_LOAD: Set to Y to run the target-to-target mapping job only.
      17. $G_MAT_RECON_LOAD: Set to Y to run the target-to-stage reconciliation job only.
    • 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.
      17. $G_GLACC_EXTRACT_LOAD: Set to Y to run the source-to-staging extract job only.
      18. $G_GLACC_GOLD_LOAD: Set to Y to run the staging-to-target gold job only.
      19. $G_GLACC_MAPPING_LOAD: Set to Y to run the target-to-target mapping job only.
      20. $G_GLACC_RECON_LOAD: Set to Y to run the target-to-stage reconciliation job only.
  3. Run the job. A message indicating the job status displays.

Replicating Credit Management Data from Central Finance to Oracle E-Business Suite

To synchronize credit master data, credit limits, exposures, and credit check results from Central Finance back to EBS after updates have been made, follow these steps:

  1. In the Local Object Library > Projects tab, open the MDR_EBS_CCM job within the MDR_EBS_CCM project.
  2. Select Tools > Variables and update the following variable:
    • $G_SOURCE_SYSTEM: Set to EBS
  3. Run the job.

Was this article helpful?

We're sorry to hear that.