Good day,
I would like to find out if it is possible to auto generate BP code in HANA using a Formatted Search (FMS)?
The requirements are as follows:
For Customers/Leads:
1. BP Code must starts with a 'C' for Customer/Lead and 'S' for Supplier.
2. Three letters which is from a UDF field which the user pre-selects.
3. Numeric numbers that need to increase starting at 0001. (Example: CGPJ0001)
For suppliers:
1. BP Code must start with a 'S' for Supplier.
2. Numeric numbers that need to increase starting at 0001. (Example: S0001)
I know how to achieve this in SQL but the same FMS syntax don't work in HANA due to the syntax differences.
If possible can anyone please share how to achieve this?
Regards,
Kobus