Reference 360 Extension for SAP Finance > Predefined assets of Reference 360 Extension for SAP Finance > Reference data sets
  

Reference data sets

Reference 360 Extension for SAP Finance includes reference data sets, code lists, and validation rules for General Ledger (GL) Accounts and Cost Centers master data sets.
You can use GL Accounts and Cost Center reference data sets to manage the SAP financial master data. Every reference data set includes code lists for SAP ECC and SAP S/4HANA.
Reference 360 Extension for SAP Finance provides master and lookup reference data sets. Evaluate dependencies before you make any changes to the predefined lookup reference data sets provided in the extension.

R360: GL COA Master reference data set for GL Account

The R360: GL COA Master reference data set stores information about a general ledger chart of account. The R360: GL COA Master reference data set is a master data that refers to lookup values, such as R360: Functional Area and R360: Account Type reference data sets.
The R360: GL COA Master reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: GL COA Master reference data set contain:
Attribute Name
Field Type
Description
Balance Sheet Account
Boolean
Indicates whether the account is a balance sheet account.
Blocked for Creation
Boolean
Indicates whether the account is blocked for creation in the chart of accounts and in the company code-specific area.
Blocked for Planning
Boolean
Indicates whether the account is blocked for planning in the chart of accounts and in the company code-specific area.
Blocked for Posting
Boolean
Indicates whether the account is blocked for posting in the chart of accounts and in the company code-specific area.
Code
String
Code for the financial transactions for a general ledger.
Description
String
Description of a general ledger account.
GL Account
String
Code for the financial transactions for a general ledger.
Long Description​​
String
Long description of a general ledger account.
Name
String
Code for the financial transactions for a general ledger.
Profit and Loss Account Type
String
Type of profit and loss statement account.
Search Term
String
Input value for a search field to provide the possible match results.
Account Group​
Reference Data
Reference data of criteria based on which the GL accounts in the account group are created.
Chart of Account​​
Reference Data
Reference data of the accounting transactions of a GL account, such as name and number of the GL account.
Functional Area​​
Reference Data
Reference data of an account characteristic to sort the transactions according to the function.
Account Type​​
Reference Data
Reference data of the accounting area to which an account belongs.
The following table lists the reference data type attributes of R360: GL COA Master reference data set that refers to reference data set with their code lists and display attributes:
Attribute Name
Reference Data Set
Code List
Display Attributes
Account Group​
R360: Account Group
  • - Enterprise R360: Account Group
  • - ECC Account Group
  • - S4H Account Group
AccountGroupCode1
Account Type​​
R360: Account Type
  • - Enterprise R360: Account Type
  • - ECC Account Type
  • - S4H Account Type
AccountType1
Chart of Account​​
R360: Chart of Account
  • - Enterprise R360: Chart of Account
  • - ECC Chart of Account
  • - S4H Chart of Account
ChartOfAccounts1
Functional Area​​
R360: Functional Area
  • - Enterprise R360: Functional Area
  • - ECC Functional Area
  • - S4H Functional Area
FunctionalArea1

R360: Account Group reference data set for GL Account

The R360: Account Group reference data set stores reference data of criteria based on which the GL accounts in the account group are created. The R360: GL COA Master reference data set refers to the R360: Account Group reference data as a lookup value.
The R360: Account Group reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Account Group reference data set contain:
Attribute Name
Field Type
Description
Account Group Code
String
Code value of the account group.
Account Group Description
String
Description about the account group.
Account Range
String
Account number range to group similar accounts.
Code
String
Code value of the account group.
Description
String
Description about the account group.
Lower Limit
String
The lower range of the account number to include in the account group.
Name
String
Code value of the account group.
Upper Limit
String
The upper range of the account number to include in the account group.

R360: Account Type reference data set for GL Account

The R360: Account Type reference data set stores reference data of how the general ledger account can be used in Accounting and Financial Close and Financial Planning and Analysis. The R360: GL COA Master reference data set refers to the R360: Account Type reference data as a lookup value.
The R360: Account Type reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Account Type reference data set contain:
Attribute Name
Field Type
Description
Account Type
String
Type of account to which an account belongs. For example, balance sheet account, non-operating expense or income, primary costs or revenue, secondary costs, and cash account.
Code
String
Type of account to which an account belongs. For example, balance sheet account, non-operating expense or income, primary costs or revenue, secondary costs, and cash account.
Description
String
Description of the type of account.
Name
String
Type of account to which an account belongs. For example, balance sheet account, non-operating expense or income, primary costs or revenue, secondary costs, and cash account.

R360: Chart of Account reference data set for GL Account

The R360: Chart of Account reference data set stores reference data of the accounting transactions of a GL account, such as name and number of the GL account. The R360: GL COA Master reference data set refers to the R360: Chart of Account reference data as a lookup value.
The R360: Chart of Account reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Chart of Account reference data set contain:
Attribute Name
Field Type
Description
Chart of Accounts
String
Code value of a group of GL accounts with accounting transactions.
Chart of Accounts Description
String
Description about the chart of accounts.
Code
String
Code value of a group of GL accounts with accounting transactions.
Description
String
Description about the chart of accounts.
Length of GL Account Number
String
Length of the GL account numbers for the chart of accounts.
Maintenance Language
String
Language to use to describe the GL accounts for the chart of accounts.
Name
String
Code value of a group of GL accounts with accounting transactions.

R360: Functional Area reference data set for GL Account

The R360: Functional Area reference data set stores reference data of an account assignment characteristic to sort the transactions according to the function. The R360: GL COA Master reference data set refers to the R360: Functional Area reference data as a lookup value.
The R360: Functional Area reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Functional Area reference data set contain:
Attribute Name
Field Type
Description
Code
String
Code of a functional area. For example, administrative functions or production processes.
Description
String
Description of a functional area.
Functional Area
String
Code of a functional area. For example, administrative functions or production processes.
Name
String
Code of a functional area. For example, administrative functions or production processes.

R360: GL CompanyCode Master reference data set for GL Account

The R360: GL CompanyCode Master reference data set stores data that is valid for one company code such as currency in which the account is to be maintained. The R360: GL CompanyCode Master reference data set is a master data that refers to the R360: GL COA Master reference data set as a lookup value.
The GL Company Code Master reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: GL Company Code Master reference data set contain:
Attribute Name
Field Type
Description
Account Blocked For Posting
Boolean
Indicates whether the account is blocked for posting in the chart of accounts and in the company code-specific area.
Balance In Local Currency
Boolean
Indicates whether the local currency is used to maintain the balance transaction figures.
Mark for Delete
Boolean
Flag to indicate whether the record is marked for deletion.
Open Item Management
Boolean
Indicates whether the account manages incomplete transactions.
Post Automatically
Boolean
Indicates whether the account is blocked for manual posting.
Posting Without Tax Allowed
Boolean
Indicates whether no tax code needs to be entered when posting to the account.
Reconciliation Account
Boolean
Indicates whether the reconciliation account is ready for input at the time of posting.
Account Currency
Reference Data
Reference data of a currency used for postings made to an account.
Company Code
Reference Data
Reference data of company codes to generate financial statements.
Field Status Group
Reference Data
Reference data of the status of a field.
Reconciliation Account Indicator
Reference Data
Reference data of a reconciliation account that receives postings from subsidiary ledgers.
Sort Key
Reference Data
Reference data to populate the assignment number in the line items of a GL account.
Tax Code
Reference Data
Reference data of a tax component that defines the tax rates.
Code
String
Company code to generate financial statements.
Cost Element Category​
String
Category type to classify primary and secondary cost elements.
Description
String
Description of a company code.
Name
String
Company code to generate financial statements.
The following table lists the reference data type attributes of R360: GL Company Code Master reference data set that refers to reference data set with their code lists and display attributes:
Attribute Name
Reference Data Set
Code List
Display Attributes
Company Code
R360: Company Code
  • - Enterprise R360: Company Code
  • - ECC Company Code
  • - S4H Company Code
Company Code
Account Currency
R360: Currency
  • - Enterprise R360: Currency
  • - ECC Currency
  • - S4H Currency
Currency
Field Status Group
R360: Field Status
  • - Enterprise R360: Field Status
  • - ECC Field Status
  • - S4H Field Status
Field Status Group
Reconciliation Account type
R360: Reconciliation Account Type
  • - Enterprise R360: Reconciliation Account Type
  • - ECC Reconciliation Account Type
  • - S4H Reconciliation Account Type
Reconciliation Account Type
Sort Key
R360: Sort Key
  • - Enterprise R360: Sort Key
  • - ECC Sort Key
  • - S4H Sort Key
Sort Key
Tax Code
R360: Tax Code
  • - Enterprise R360: Tax Code
  • - ECC Tax Code
  • - S4H Tax Code
Jurisdiction For Tax Calculation

R360: Company Code reference data set for GL Account

The R360: Company Code reference data set stores reference data of company codes to generate financial statements. The R360: GL Company Code Master reference data set refers to the R360: Company Code reference data as a lookup value.
The R360: Company Code reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Company Code reference data set contain:
Attribute Name
Field Type
Description
Code
String
Company code to generate financial statements.
Company Code
String
Company code to generate financial statements.
Description
String
Description of the company code.
Name
String
Company code to generate financial statements.

R360: Currency reference data set for GL Account

The R360: Currency reference data set stores reference data of a currency used for postings made to an account. The R360: GL Company Code Master reference data set refers to the R360: Currency reference data as a lookup value.
The R360: Currency reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Currency reference data set contain:
Attribute Name
Field Type
Description
Code
String
Currency code to maintain the transaction figures and to display the account balance.
Currency
String
Currency code to maintain the transaction figures and to display the account balance.
Description
String
Description of a currency.
ISO Code
String
ISO currency code.
Name
String
Currency code to maintain the transaction figures and to display the account balance.

R360: Field Status reference data set for GL Account

The R360: Field Status reference data set stores reference data for the status of a field. The R360: GL Company Code Master reference data set refers to the R360: Field Status reference data as a lookup value.
The R360: Field Status reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Field Status reference data set contain:
Attribute Name
Field Type
Description
Code
String
Status code of a field for posting transactional data to the GL account. For example, optional or suppressed.
Description
String
Description of a field status.
Field Status Group
String
Status code of a field for posting transactional data to the GL account. For example, optional or suppressed.
Name
String
Status code of a field for posting transactional data to the GL account. For example, optional or suppressed.

R360: Tax Code reference data set for GL Account

The R360: Tax Code reference data set stores reference data of a tax component that defines the tax rates. The R360: GL Company Code Master reference data set refers to the R360: Tax Code reference data as a lookup value.
The R360: Tax Code reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Tax Code reference data set contain:
Attribute Name
Field Type
Description
Code
String
Tax component specification to calculate tax.
Description
String
Description of the tax component.
Name
String
Tax component specification to calculate tax.
Tax Code
String
Tax component specification code to calculate tax.

R360: Reconciliation Account Type reference data set for GL Account

The R360: Reconciliation Account Type reference data set stores reference data of a reconciliation account that receives postings from subsidiary ledgers. The R360: GL Company Code Master reference data set refers to the R360: Reconciliation Account reference data as a lookup value.
The R360: Reconciliation Account Type reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Reconciliation Account Type reference data set contain:
Attribute Name
Field Type
Description
Code
String
Code for a GL account to characterize the GL account as a reconciliation account. For example, assets, customers, vendors, or contract accounts receivable.
Description
String
Description of the type of a reconciliation account.
Name
String
Code for a GL account to characterize the GL account as a reconciliation account. For example, assets, customers, vendors, or contract accounts receivable.
Reconciliation Account Type
String
Code for a GL account to characterize the GL account as a reconciliation account. For example, assets, customers, vendors, or contract accounts receivable.

R360: Sort Key reference data set for GL Account

The R360: Sort Key reference data set stores reference data to populate the assignment number in the line items of a GL account. The R360: GL Company Code Master reference data set refers to the R360: Sort Key reference data as a lookup value.
The R360: Sort Key reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Sort Key reference data set contain:
Attribute Name
Field Type
Description
Code
String
Assignment number in the line items of a GL account.
Description
String
Description of the sort key.
Name
String
Assignment number in the line items of a GL account.
Sort Key
String
Assignment number in the line items of a GL account.

R360: Cost Center reference data set for Cost Center

The R360: Cost Center reference data set stores reference data for cost center for financial reporting. The R360: Cost Center reference data set is a master data that refers to lookup values, such as R360: Business Area and R360: Controlling Area reference data sets.
The R360: Cost Center reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Cost Center reference data set contain:
Attribute Name
Field Type
Description
Lock Indicator for Commitment Update
Boolean
Indicates whether a cost center is locked for commitment update.
Lock Indicator for Planning Primary Costs
Boolean
Indicates whether a cost center is locked for posting with primary costs in the plan.
Lock Indicator for Planning Revenue
Boolean
Indicates whether a cost center is locked for posting with planning revenues.
Lock Indicator for Planning Secondary Costs
Boolean
Indicates whether a cost center is locked for posting with secondary costs in the plan.
Business Area
Reference Data
Reference data of a specific business segment.
Company Code
Reference Data
Reference data of company codes to generate financial statements.
Controlling Area
Reference Data
Reference data of controlling areas to perform cost accounting.
Cost Center Category
Reference Data
Reference data of the components that add to the cost.
Country Key
Reference Data
Reference data of countries.
Functional Area
Reference Data
Reference data of an account characteristic to sort the transactions according to the function.
Language Key
Reference Data
Reference data of languages to maintain a GL account.
Profit Center
Reference Data
Reference data of an area for which profit is determined.
Tax Jurisdiction
Reference Data
Reference data of the tax jurisdiction codes.
Standard Hierarchy Area
Reference Data
Reference data of cost center groups in a cost center standard hierarchy.
City
String
Regions and transport zones of a cost center.
Code
String
Code for a cost center.
Cost Center
String
Type of cost center.
Created On
String
Date on which the cost center creation was created.
Currency Key
String
Code of the currencies for a transaction.
Department
String
Department of a cost center that adds to a cost.
Description
String
Description of a cost center.
Effective End Date
String
Date till when the cost center is valid.
Effective Start Date
String
Date from when a cost center is valid.
General Name
String
Name of a cost center.
House Number and Street
String
House number and street of a cost center address.
Name
String
Code for a cost center.
PO Box
String
Postal address of a cost center.
PO Box Postal Code
String
PO box postal code of a cost center.
Person Responsible
String
Person responsible for a cost center.
Postal Code
String
Postal code of a cost center.
Tax Jurisdiction
String
Tax jurisdiction code.
User Responsible
String
User responsible for a cost center.
The following table lists the reference data type attributes of R360: Cost Center reference data set that refers to reference data set with their code lists and display attributes:
Attribute Name
Reference Data Set
Code List
Display Attributes
Business Area
R360: Business Area
  • - Enterprise R360: Business Area
  • - ECC Business Area
  • - S4H Business Area
BusinessArea1
Company Code
R360: Company Code
  • - Enterprise R360: Company Code
  • - ECC Company Code
  • - S4H Company Code
CompanyCode1
Controlling Area
R360:Controlling Area
  • - Enterprise R360: Controlling Area
  • - ECC Controlling Area
  • - S4H Controlling Area
COArea1
Cost Center Category
R360: Cost Center Type
  • - Enterprise R360: Cost Center Type
  • - ECC Cost Center Type
  • - S4H Cost Center Type
CostCenterCategory1
Country Key
R360: Country
  • - Enterprise R360: Country
  • - ECC Country
  • - S4H Country
Country
Currency
R360: Currency
  • - Enterprise R360: Currency
  • - ECC Currency
  • - S4H Currency
Currency
Functional Area
R360: Functional Area
  • - Enterprise R360: Functional Area
  • - ECC Functional Area
  • - S4H Functional Area
FunctionalArea1
Language Key
R360: Language
  • - Enterprise R360: Language
  • - ECC Language
  • - S4H Language
LanguageCode1
Profit Center
R360: Profit Center
  • - Enterprise R360: Profit Center
  • - ECC Profit Center
  • - S4H Profit Center
ProfitCenter1
Tax Jurisdiction
R360: Tax Jurisdiction
  • - Enterprise R360: Currency
  • - ECC Currency
  • - S4H Currency
JurisdictionForTaxCalculation1
Standard Hierarchy Area
R360: Standard Hierarchy
  • - Enterprise R360: Currency
  • - ECC Currency
  • - S4H Currency
CostCenterGroup

R360: Business Area reference data set for Cost Center

The R360: Business Area reference data set stores reference data of a specific business segment. The R360: Cost Center reference data set refers to the R360: Business Area reference data as a lookup values.
The R360: Business Area reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Business Area reference data set contain:
Attribute Name
Field Type
Description
Business Area
String
Code for a business segment of an operation.
Code
String
Code for a business segment of an operation.
Description
String
Description of a business area.
Name
String
Code for a business segment of an operation.

R360: Company Code reference data set for Cost Center

The R360: Company Code reference data set stores reference data of company codes to generate financial statements. The R360: Cost Center reference data set refers to the R360: Company Code reference data as a lookup value.
The R360: Company Code reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Company Code reference data set contain:
Attribute Name
Field Type
Description
Code
String
Company code to generate financial statements.
Company Code
String
Company code to generate financial statements.
Description
String
Description of the company code.
Name
String
Company code to generate financial statements.

R360: Controlling Area reference data set for Cost Center

The R360: Controlling Area reference data set stores reference data for controlling area to perform cost accounting. The R360: Cost Center and R360: Cost Center Text reference data sets refer to the R360: Controlling Area reference data as a lookup value.
The R360: Controlling Area reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Controlling Area reference data set contain:
Attribute Name
Field Type
Description
Code
String
Code of a controlling area.
Controlling Area
String
Code of a controlling area.
Description
String
Description of a controlling area.
Name
String
Code of a controlling area.

R360: Cost Center Type reference data set for Cost Center

The R360: Cost Center Type reference data set stores reference data of the components that add to the cost. The R360: Cost Center reference data set refers to the R360: Cost Center Type reference data as a lookup value.
The R360: Cost Center Type reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Cost Center Type reference data set contain:
Attribute Name
Field Type
Description
Code
String
Code for a type of a cost center.
Cost Center Category
String
Code for a type of a cost center.
Description
String
Description of the type of a cost center.
Name
String
Code for a type of a cost center.

R360: Country reference data set for Cost Center

The R360: Country reference data set stores reference data of countries. The R360: Cost Center reference data set refers to the R360: Country reference data as a lookup value.
The R360: Country reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Country reference data set contain:
Attribute Name
Field Type
Description
Code
String
Code of a country.
Country
String
Code of a country.
Description
String
Description of the code of a country.
Name
String
Code of a country.

R360: Currency reference data set for Cost Center

The R360: Currency reference data set stores reference data of a currency used for postings made to an account. The R360: Cost Center reference data set refers to the R360: Currency reference data as a lookup value.
The R360: Currency reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Currency reference data set contain:
Attribute Name
Field Type
Description
Code
String
Code of a currency to maintain the transaction figures and to display the account balance.
Currency
String
Code of a currency to maintain the transaction figures and to display the account balance.
Description
String
Description of a currency.
ISO Code
String
ISO currency code.
Name
String
Code of a currency to maintain the transaction figures and to display the account balance.

R360: Functional Area reference data set for Cost Center

The R360: Functional Area reference data set stores reference data of an account characteristic to sort the transactions according to the function. The R360: Cost Center reference data set refers to the R360: Functional Area reference data as a lookup value.
The R360: Functional Area reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Functional Area reference data set contain:
Attribute Name
Field Type
Description
Code
String
Code of a functional area. For example, administrative functions or production processes.
Description
String
Description of a functional area.
Functional Area
String
Code of a functional area. For example, administrative functions or production processes.
Name
String
Code of a functional area. For example, administrative functions or production processes.

R360: Language reference data set for GL Account

The R360: Language reference data set stores reference data of languages to maintain a GL account.
The R360: Language reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Language reference data set contain:
Attribute Name
Field Type
Description
Code
String
Code for the language key format.
Description
String
Description of the language key format.
Language Code
String
Code for the language key format.
Name
String
Code for the language key format.

R360: Profit Center reference data set for Cost Center

The R360: Profit Center reference data set stores reference data of an area for which profit is determined. The R360: Cost Center reference data set refers to the R360: Profit Center reference data as a lookup value.
The R360: Profit Center reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Profit Center reference data set contain:
Attribute Name
Field Type
Description
Code
String
Code of a profit center.
Description
String
Description of a profit center.
Name
String
Code of a profit center.
Profit Center
String
Code of a profit center.

R360: Tax Jurisdiction reference data set for Cost Center

The R360: Tax Jurisdiction reference data set stores reference data of the tax jurisdiction codes. The R360: Cost Center reference data set refers to the R360: Tax Jurisdiction reference data as a lookup value.
The R360: Tax Jurisdiction reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Tax Jurisdiction reference data set contain:
Attribute Name
Field Type
Description
Code
String
Code of a jurisdiction for tax calculation.
Description
String
Description of the jurisdiction for tax calculation
Jurisdiction For Tax Calculation
String
Code of a jurisdiction for tax calculation.
Name
String
Code of a jurisdiction for tax calculation.
Procedure
String
Tax calculation procedure.

R360: Standard Cost Center Hierarchy reference data set

The R360: Standard Cost Center Hierarchy reference data set stores reference data of a cost center within an organizational hierarchy. The R360: Standard Cost Center Hierarchy reference data set is a master data that refers to the R360: Cost Center reference data set as a lookup value.
The R360: Standard Cost Center Hierarchy reference data set contains the following code lists:
The following table lists the attributes that the code lists in the R360: Standard Cost Center Hierarchy reference data set contain:
Attribute Name
Field Type
Description
Code
String
Code value of an account group.
Controlling Area
Reference Data
Reference data of a controlling area to which the accounts in the standard hierarchy belong.
Cost Center Group
String
Group that a cost center is part of.
Description
String
Description of a standard hierarchy.
Name
String
Code value of an account group.
Note: Reference 360 Extension for SAP Finance supports descriptions only in English. To use descriptions in other languages, specify the language code of the SAP system when you configure the application connection to connect to the SAP system.
For more information about the SAP language codes, see the SAP documentation.