How to Implement Flexible Billing Document Numbering with Configurable Parameters and Formulas (CPF) – Video Tutorial
Did you know that you can define rules that the system uses to determine number range intervals and number range prefixes for the numbering of newly created billing documents?
These rules evaluate header fields of the billing document that is being created to dynamically determine the resulting document number.
Custom number range intervals and prefixes can be useful if you want to make the origin of an invoice recognizable at a glance (for example, invoice UK123456 vs invoice US923456). They can also help to fulfill legal invoicing requirements that exist in some countries.
Flexible billing document numbering was previously only possible through the implementation of ABAP custom logic (via Business Add-Ins, AKA BAdIs).
Thanks to the Configurable Parameters and Formulas (CPF) framework, you can now set it up with just a few clicks across a handful of configuration steps in the Manage Your Solution app.
The following two-part video tutorial takes you through all the necessary steps:
- Overview of the example target implementation
- Creating your number range intervals and number range prefixes
- Creating your CPF formula, including the decision table that contains the numbering rules
- Making the required configurations to link your formula to specific billing document types through use of a custom routine
- Testing the new implementation by creating billing documents with specific attributes to trigger some of the implemented rules, then check whether they are applied correctly
You can watch the videos below. Happy viewing!
Related Links on SAP Help Portal:
Flexible Billing Document Numbering
Using Configurable Parameters and Formulas (CPF) to Implement Flexible Billing Document Numbering
Thank you for sharing! The functionality is clearly explained!
This is absolutely brilliant Ben. Thanks!
Thanks! Hope it's helpful!
The decision table seems like a very functional-friendly way to stipulate the priorities compared to writing code to stipulate this which I think I see more often around custom routines/logic/formula.
Are decision tables like this for configuration new at all or has this always been around?
I can't comment definitively for the whole of SAP S/4HANA, but it's the only decision table in configuration that I'm currently aware of.
I like to have videos explaining the functionalities. Thank you Ben 🙂
Thank you for this!
How can I make the conditions also yearly dependent? To configure different number ranges per Company codes and per years...
unfortunately this is currently not natively supported. If you are a customer, I would encourage you to create a feature request for this topic on the Customer Influence Portal.
Alternatively, it should be possible to achieve this by creating a custom billing document field via extensibility, using a BAdI implementation (BAdI "Custom Data Transfer for Billing Documents") to automatically fíll this field with the current year, and then include this custom field in your decision table.