Performing Billing Process Configuration for Selection, Grouping, and Aggregation

Objective

After completing this lesson, you will be able to understand the configuration of the billing process

Billing Process Configuration

Lesson Overview

At the conclusion of this lesson, you will understand how to customize billable item data selection, groupings into billing units, and aggregation into billing item types.

Business Example

From a business perspective, Print Service Corporation has two different types of billable items:

  • Usages

  • Recurring Fees

Both types occur in data load and telecommunication services. The invoice should show data and telecommunication usage as one subtotal, and data and telecommunication fees as another subtotal. Therefore, Print Service Corporation defines selection and grouping criteria for the billing process.

Billing Process Configuration

Several customizing steps are necessary to run the billing process. In this lesson we go step by step through our business example to understand why the system selects and groups billable items as it did in the business example.

Business example for two different billing types:

You want to distinguish between billing documents that belong to periodic billing and billing documents that arise due to contract termination (final billing documents). This distinction is made using the billing type.

For final billing documents, you want to add additional informational items that are not relevant for posting.

Billing types are mandatory. You have to assign a billing type to each billing process at the level of the subprocess.

Business Example:

Print Service Corporation has private customers and commercial customers. Both groups receive invoices with different lists and different printouts.

Therefore, Print Service Corporation categorizes contract accounts into two groups:

  • Private Customer

  • Commercial Customer

Master data and the invoicing category influence both the billing and invoicing process.

You can define an invoicing category in customizing to sort contract accounts into different categories. In customizing, choose Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingInvoicingInvoicing ProcessesDefine Invoicing Categories.

For our business example, Print Service Corporation defines category YN01 for Residential Customer and YN03 for Business Customer.

You enter the invoicing categories in the master record of the contract account and use them for a finer control of invoicing.

You can use the invoicing category in billing and invoicing to fine-tune the billing and invoicing process flow. You enter the invoicing categories in the master record of the contract account.

There is no billing category. The invoicing category is used for the billing process as well as for the invoicing process.

You can assign different billing types and grouping variants to different invoicing categories, but this is optional.

Hint

Definition and use of invoicing categories is optional.

The invoicing category can also be used to fine-tune invoice processing and printing.

The billing process specifies which subprocesses it supports. For each subprocess, the billing process specifies the following:

  • Which contract accounts are billed

  • Which billable items are selected for billing (selection)

  • How the billable items are grouped into billing units and, as a consequence, how they are grouped into billing documents (grouping)

In addition, the billing process classifies billing documents from a business and accounting perspective by means of the billing types assigned to it.

In billing, the billing process can help you control the aggregation of billable items by means of a grouping variant.

You can create new billing processes in customizing for contract accounts receivable and payable under Convergent InvoicingBillingBilling ProcessesDefine Billing Processes.

It is possible to modify the result of the data selection with the event 8112. In the function modules that are processed at event 8112, you can check the selection scope and reduce it if necessary.

Note

You are only allowed to exclude complete processing packages.

Customizing IMGContract Accounts Receivable and PayableIntegrationBilling in Contract Accounts Receivable and PayableBilling ProcessesDefine Billing Processes.

Selection Variant:

The selection variant specifies which billable item classes the billable items are selected from, and also which billable items are processed in the billing process.

You can refine the selection further by specifying the billable item type and source transaction type for each billable item class. When doing so, you can also specify that certain individual values of these attributes are included or excluded from the selection.

The configuration also enables you to enter combinations of values of the attributes mentioned.

Business example for data selection variant:

  1. Select billable Items of billable item class PBLW and PCOL.

  2. From billable item class PCOL, select billable item type TEL1 or TEL2 with source transaction unequal 01.

Customizing IMGContract Accounts Receivable and PayableIntegrationBilling in Contract Accounts Receivable and PayableBilling ProcessesDefine Selection Variants.

Solution:

Define a selection variant VAR4. Assign billable item class PBLW and define two sequences for PCOL.

For the first sequence for PCOL, select TEL1.

For the second sequence, select TEL2 and exclude source transaction 01.

The selection number is used when you configure the selection variant for billable items. It is used so that for each billable item class, you can enter multiple valid combinations of billable item types and source transaction types for billable items.

Assume that multiple values have been entered for the billable item type for one sequence number of the selection. In this case, the system links these values in the selection statement using a logical or condition. The same applies for the source transaction type.

If there are combined selection specifications in the selection statement, then the system links the billable item types and source transaction types with a logical and condition. This is assuming that they have the same sequence number of the selection. If they have different sequence numbers, then the system links them using a logical or condition.

In making this decision, the system interprets the sequence number only within one billable item class.

You can find the customizing for selection variants under Customizing Implementation GuideFinancial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling ProcessesDefine Selection Variants.

Due to the defined data selection variant VAR4, the three billable item types are not selected for billing process BiDA and billing subprocess BSDA.

Billing Units

Facts about billing units:

  • Billable Items are summarized in billing units to be processed and displayed on a billing document together. The billing unit is the basis for the billing.
  • In a first step, the system groups all source documents that have the same contract account, business partner, and subprocess.
  • Dependent on a grouping variant, the billing documents can be further grouped into billing units.
  • The grouping proposal can be processed on a customer-specific basis in event 8114.
  • For billing in dialog in expert mode, the billing units created are offered for selection in a dialog box.

When more than one billable item is processed during billing of a contract account, it can be advantageous not to process these billable items in one common billing document. Instead, companies often want to group items together based on specific criteria (such as a common currency or a common billing period). The system then needs to create a separate billing document for each of these groups.

Hint

The default setting groups all billable items for the same contract account, business partner, and subprocess together.

Grouping separate billable items into different billing units.

Grouping variants are not necessary, you can retain the system default.

Billing in contract accounts receivable and payable provides this function in the form of billing units. A billing unit groups together all billable items that are to be processed together during billing and for which the system creates a common billing document.

The system can create billing units automatically using the rules for grouping control that are entered for the billing process. In addition, you can influence the creation of billing units manually in the processing dialog for billing.

In customizing for contract accounts receivable and payable, choose Billing in Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling ProcessesDefine Grouping Variants.

Customizing IMG-Contract Accounts Receivable and PayableIntegrationBilling in Contract Accounts Receivable and PayableBilling ProcessesDefine Grouping Variants.

Exception for billing in dialog in expert mode:

The billing units created are offered for selection in a dialog box.

You can find the customizing for grouping variants under Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling ProcessesDefine Grouping Variants.

Customizing IMGContract Accounts Receivable and PayableIntegrationBilling in Contract Accounts Receivable and PayableBilling ProcessesAssign Billing Item Type.

In this customizing activity, you define how grouping variants are determined for controlling the aggregation of billable items in billing.

The grouping variant mentioned here controls the link between the billable items and the items of the billing document (aggregation of billable items). You can define the granularity of this linkage. It can range from a 1:1 relationship between the individual billable items and the related billing document items to the blanket assignment of all billable items in a billing document to all billing document items.

With the default setting, billable items where all the relevant fields are identical are merged.

Again, the grouping criteria have to be seen as split criteria.

For billable item class PBLW, we split along the BIT date (this is the date of the origin of the billable Item).

The result is different for billable items with different BIT dates.

Customizing IMGContract Accounts Receivable and PayableIntegrationBilling in Contract Accounts Receivable and PayableBilling ProcessesAssign Billing Item type.

You assign the billing item type of the item in the billing document to the attributes subprocess and item types of the billable item.

By making this assignment, you are able to represent the business meaning of the billable item by the item type of the billing document item, so that it is available in invoicing and for printing the invoice.

IMG: Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling ProcessesDefine Billing Item Types.

IMG: Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingB illing ProcessesAssign Billing Item Types.

In these activities, you define and assign the billing item type of the item in the billing document to the attributes subprocess and item type of the billable item.

First, define number ranges for billing documents by specifying the upper and lower limit in customizing under Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling DocumentsMaintain Number Ranges for Billing Documents. You cannot use external number assignment. The billing document numbers are exclusively numerical. For number assignment, the system distinguishes between individual processing and mass processing.

The name of the number range for individual processing must begin with a number between 1 and 9. The name of the number range for mass processing must begin with a letter (A - Z).

Define the billing types and assign them to number ranges in customizing under Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling DocumentsMaintain Document Types and Assign Number Ranges.

In the third step, you define the determination of document types for the billing documents for posting area 8110 (Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling DocumentsAssign Document Types). We recommend that you assign different document types to actual billing documents, reversal documents, and simulation documents.

Note

The Result of the Billing Process ...

  • … is the entry of the billing document in the temporary list of invoicing orders …
  • … but this is not the end of the story …

Configure Billing Process

Business Example

Print Service Corporation has decided to launch the new product line Data High Speed. Billable item class TD## should be used productively from the beginning of next month. Configure a new billing subprocess BS## for billable item class TD## with the property, Only selection of billable item class TD##.

As billing and invoicing will be scheduled differently for the new product line Data High Speed from existing processes at Telcom One, a new billing process is defined.

Perform exercise (Task 1 to 9) in back-end system T41 client 400, user BR245-## password Welcome1.

Exercise Options

To perform this exercise, you have two options:

  1. Watch the simulation: to start the simulation, choose Start Exercise in the figure below.
  2. Perform the steps, as described below.

Task 1:

Steps

  1. Define a new subprocess and assign a billable item class

    Define a new billing subprocess with the following identifier and name: BS## Billing Subprocess Group XX, and assign billing subprocess BS## to billable item class TD##.

    You define the billing subprocess in customizing under Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBasic FunctionsBillable ItemsBillable Item ManagementDefine Subprocesses of Billing.

    Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBasic FunctionsBillable ItemsBillable Item ManagementAssign Subprocesses to Classes.

    1. In the Define Subprocess of Billing menu, choose EditNew Entry.

      SubprocessBS##
      Subprocess Descr.Billing Subprocess Group ##

      To save your entries, choose Table ViewSave.

      Class:TD##
      Subprocess:BS##

      To save your entries, choose Table ViewSave.

  2. Assign billable item types to the subprocess

    Assign billable item type BI00 to billing subprocess BS##.

    You assign the billable item type to the subprocess in customizing under Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBasic FunctionsBillable ItemsBillable Item ManagementAssign Item Types to Subprocesses.

    .

    1. In customizing, choose Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBasic FunctionsBillable ItemsBillable Item ManagementAssign Item Types to Subprocesses.

      In the menu, choose EditNew Entry.

      SubprocessBS##
      Bill. Item TypeBI00

      To save your entries, choose Table ViewSave.

  3. Assign organizational information to subprocess

    Assign company code 1010 and division 00 to subprocess BSXX and billable item type Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBasic FunctionsBillable ItemsBillable Item TransferAccount Assignment DerivationDefine Account Assignments (Posting Area 8120).

    Insert the following details:

    Billing SubprocessBSXX
    Billable ItemBI00
    Key 1Key 4*
    Company Code1010
    Division00
  4. Define Main Transactions and Sub-transactions

    Assign main transactions and sub-transactions to subprocess a billable item type Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBasic FunctionsBillable ItemsBillable Item TransferAccount Assignment DerivationDefine Main Transactions and Subtransactions (Posting Area 8121).

    Insert the following details:

    Billing SubprocessBSXX
    Billable ItemBI00
    Key 1—Key 4*
    Debit MT6000
    Debit ST0010
    Credit MT6000
    Credit ST0020
  5. Define the selection variant

    Define selection variant SV## for billable item class TD##.

    You define the selection variant in customizing under Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling ProcessesDefine Selection VariantsAssign Billable Item Classes.

    1. In customizing, choose Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling ProcessesDefine Selection Variants.

      Choose EditNew Entry.

      Variant:SV##
      Name:Selection Variant Group ##

      To save your entries, choose Table ViewSave.

      Select SV## and choose Assign Billable Item Class.

      Billable Item Class: TD##

      To save your entries, choose Table ViewSave.

  6. Define a billing process

    Define billing process BP## with subprocess BS## and selection variant SV## and Billing type BIDA.

    You define the billing process in customizing under Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling ProcessesDefine Billing Processes.

    1. In customizing, choose Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling ProcessesDefine Billing Processes.

      Choose EditNew Entry.

      Billing Process:BP##
      Billing Process Group:Billing Process Group ##

      To save your entries, choose Table ViewSave.

      Assign

      SubprocessSel.VariantGroup. VariantBilling TypePriority
      BS##SV##leave blankBIDAleave blank
  7. Assign a billing item type

    Assign billing item type ZDAT to billing subprocess BS## and billable item type BI00.

    You assign the billing item type in customizing under Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling ProcessesAssign Billing Item Types.

    1. In customizing, choose Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling ProcessesAssign Billing Item Types.

      Choose EditNew Entry.

      Billing Subprocess:BS##
      Billable Item Type:BI00
      Billing Item Type:ZDAT

      To save your entries, choose Table ViewSave.

      You have now made the customizing settings for the billing process.

  8. Assign document type to billing process and billing type

    Financial Accounting (New)Contract Accounts Receivable and PayableConvergent InvoicingBillingBilling DocumentsAssign Document Types.

    Assign to

    Billing ProcessBilling TypeDocTypeRev.DocDTSimSourceDoc
    BP##BIDA010102001
  9. Create billable items as test data for your own billing process

    Create billable items for your contract account CA## for billable item class TD##, subprocess BS##, with a random amount.

    Run program RFKKBIXBITSAMPLE with variant TESTOWNBILLING to generate test data.

    In the SAP Easy Access menu, choose ToolsABAP WorkbenchDevelopmentABAP Editor (transaction se38).

    ProgramRFKKBIXBITSAMPLE
    With VariantTESTOWNBILLING

    Change the following fields:

    Billable Item Class:Change ## to your group number
    Subprocess:Change ## to your group number
    Contract Account:Change ## to your group number

    Choose ProgramExecute.

    1. Run program RFKKBIXBITSAMPLE with variant TESTOWNBILLING to generate test data.

      In the SAP Easy Access menu, choose ToolsABAP WorkbenchDevelopmentABAP Editor (transaction se38).

      Program:RFKKBIXBITSAMPLE
      With Variant:TESTOWNBILLING

      Change the following fields:

      Billable Item ClassChange ## to your group number
      SubprocessChange ## to your group number
      Contract AccountChange ## to your group number

      The billable item class is already initialized with TD##, subprocess BS##, and billable item type BI00.

      Choose ProgramExecute.

      As a result, the system outputs the message Generation of sample data.

      Result: The report has generated 3 billable items for your billing process.

      If the generation is not successful, the system creates a log file with an error message. In this case, check your billing process customizing again step by step.

  10. Create billing documents for contract account CA##.

    Use the following parameters:

    Billing ProcessBP##
    Billing SubprocessBS##
    Billing Datetoday + one month
    Contract AccountCA##

    Write down the billing document numbers for use in later exercises: ________________

    1. In the SAP Fiori launchpad open the tile Execute Billing - Business Partner (Corresponding back-end transaction FKKBIX_S).

    2. Enter the data from the table above.

    3. Execute this report as an update run afterwards.

    4. Write down the billing document numbers for use in later exercises: ________________

      If you are not able to run the billing process, the system outputs an error message. This message indicates which step in the customizing of your billing process was incorrect. Follow the hint and try to run the process again.

Log in to track your progress & complete quizzes