Using Custom Fields for Balance Validation

Objective

After completing this lesson, you will be able to use custom fields for Balance Validation rules.

Custom Fields for Balance Validation Rules

Max has been informed that a validation rule needs to be created based on a custom field that's been included in the Universal Journal. He would like to understand how to be able to include this in the Balance Validation process. This custom field segregates data according to a company-specific level and is important in validating data for each area.

In setting up your SAP S/4HANA, your IT Business Analyst might have created custom fields to fit your company’s unique requirements. You can choose to show these fields on the validation result details pages. Before you do this, however, certain conditions need to be met.

Note

Should you encounter any issues while creating the rule, this information will prove helpful and you might need to involve your IT Business Analyst who handles the accounting tables.

Two boxes side by side. The first box shows the business contexts needed to use custom fields. The box on the right shows the Core Data Services Views needed to use custom fields.

As a prerequisite, the field must have been created in one of the following business contexts during the deployment in order to be used in Balance Validation:

  • Accounting: Market Segment (FINS_MARKET_SEGMENT)
  • Accounting: Coding Block (FINS_CODING_BLOCK)
  • Accounting: Journal Entry Item (FINS_JOURNAL_ENTRY_ITEM)

With a custom field created, then it will need to be included in the following Core Data Services (CDS) views to ensure that it is available for defining validation rules and displaying it in the validation result drill-down page:

  • Accounting Balance Validation (FAC_GLACCOUNTLINIEITEM)
  • Accounting Balance Validation Selection (FINAC_SELECTION)
  • General Ledger Account Line Item (I_GLACCOUNTLINEITEM)

If the custom field is to be included in the Display Line Items in General Ledger app, you need to enable the field usage in the OData service FAC_GLV_GL_ACCOUNT_LINE_ITEMS_SRV

Log in to track your progress & complete quizzes