Release Notes Content SQL 2.1.x
| Version & Date | Component | Changes |
|---|---|---|
| 2.1.11 2023-10-30 | AP_RootCause | Execute Root Cause AI for nearly every AP Analytic Step |
| All AP Analytics | Added required fields for execution of Root Cause AI | |
| PI_O2C_Split / PI_P2P_Split | Prepared analytic for process.science | |
| 2.1.10 2023-10-24 | SD_CriticalCountries | New analytic |
| SD_ConditionChanges | Added KONV_KINAK to extraction list | |
| SD_ManualConditionChanges | Added KONV_KINAK to extraction list | |
| SD_BaseTable | Check c_Next_CredLimit_XX fields for numeric values | |
| AP_DuplicatePaymentsEnhanced | Added missing prefixes Added missing dab:Link columns Creation of one line pool linked to list | |
| 2.1.9 2023-10-12 | PU_CurrencyKeyChanges | Removed dab Link columns on item level (header-only analytic) |
| 2.1.8 2023-10-12 | CU/GL/MM/PU/SD/VE BaseTables | Consider client fields to improve performance |
| PU_BaseTable | Removed c_PO_Approver_History | |
| PI_O2C_EventLog | Performance optimization for out-of-scope SO/Delivery | |
| PU_BaseTable | Added EBAN info based on EKET Removed c_Requ_Value fallback based on EBELN | |
| SD_BaseTable | Check RE/RG partner functions also on item level | |
| MM_QuantityUnitChanges | Added CDPOS_VALUE_NEW | |
| VE_NoDuplicateCheckFlag | Added filter for customers without deletion flags | |
| SD_ConditionChanges | Added KONV_KWERT & KONV_KSTAT | |
| SD_ManualConditionChanges | Added KONV_KWERT & KONV_KSTAT | |
| UserOverview tables | Added company code to joins | |
| AR_OpenItems | Fixed c_Overdue_360 bug (361 days) | |
| CU_DeletionBlockChanges | Renamed to CU_DeliveryBlockChanges | |
| MM_BaseTable | Fixed MARA client join | |
| SD_BaseTable | Fixed ADRC client join | |
| All Analytic Steps | Fixed currency conversion for bad TCURF data | |
| 2.1.7 2023-09-18 | All Analytic Steps | Fixed missing fields issue (ADRC, BSEC, KONP, VBFA) in Nexus >= 1.11 |
| 2.1.6 2023-09-15 | All Analytic Steps | Fixed currency conversion for very old TCURR entries |
| 2.1.5 2023-09-15 | BL_ListValueVsNetValue | Removed inactive conditions |
| BL_BaseTable | Identify statistical values via VBRP_KOWRR Added VBRP_KOWRR & c_Statistical_Value_RC If statistical → NETWR fields set to 0 Removed ZTAGG=00 check for text determination | |
| SD_BaseTable | Removed ZTAGG=00 check for text determination | |
| All Analytic Steps | Fixed decimals for negative conversion rates | |
| BL_BaseTable | Removed KONV reference (unused) | |
| 2.1.4 2023-08-24 | CU_SpecialPaymentTerms | Added c_BUKRS, added c_PT_Differ logic |
| PU_InvoiceReceivedAfterFinalInvoiceFlag | Check CDPOS_VALUE_NEW = 'X' | |
| VE_SpecialPaymentTerms | Added c_BUKRS, added c_PT_Differ logic | |
| MD_BaseTable | Removed HKNOT determination & several BSEG/SKAT fields | |
| BL_BaseTable | Removed list value info | |
| BL_FreeGoods | Removed list value info | |
| SD_BaseTable | Removed list value info | |
| VE_BaseTable | Added c_Count_BankAccounts & c_Count_Countries | |
| VE_BankCountryDifference | Removed B-segment info | |
| 2.1.3 2023-08-09 | AP_DuplicatePayments with AI | Pool + one-line result table + R-Script call |
| AP_ManualPayments | Replaced clearing fields with new ones | |
| AR_ManualPayments | Replaced clearing fields with new ones | |
| SD_PaymentTermsChanges | Field renamed + fix for ZTAGG=00 | |
| AP_BaseTable | Removed c_Clearing_History + fixes for multiple clearing items | |
| AR_BaseTable | Removed c_Clearing_History + fixes for multiple clearing items | |
| PI_P2P_Split | PO_Amt_RC takes first event value | |
| BL_BaseTable | Fix NULL handling when KONV_BL missing | |
| CU/VE BankAccountChanges | Remove duplicates for outdated payment runs | |
| MD_BaseTable | Fixed freeze in account text determination | |
| SD_BaseTable | Correct document creation date for credit limit currency conversion | |
| BL_InvoiceCanceled | Correct user type description, renamed fields | |
| CU_CreditLimitChanges | Fixed join for username description | |
| 2.1.2 2023-06-25 | All analytics | Enabled dab Link by default Fixed issues with dab Link columns Rewrote currency conversion for ACL alignment |
| BL_BaseTable | ADRC_NATION='' filter; fallback logic | |
| DL_BaseTable | ADRC filters improved | |
| SD_BaseTable | ADRC filters improved; use VBKD_FKDAT for text determination | |
| SD_PaymentTermsChanges | Use VBKD_FKDAT | |
| PI_P2P_EventLog | Improved ADRC filtering | |
| CU_CreditLimitChanges | Added currency conversion | |
Various Select * | Added SELECT * to many tables | |
| CU/VE BankAccountChanges | Fix joins + use finance basetable | |
| CU/VE_Duplicates | Initialize c_Unique_Id even when empty | |
| PU_EqualUsers | Use c_EKPO_ERNAM instead of c_EKKO_ERNAM | |
| GL_UserOverview | Add BKPF_GJAHR & BKPF_BUKRS | |
| 2.1.1 2023-06-17 | MD_BaseTable | Fixed freeze during execution |
| 2.1.0 2023 | CU_DuplicatesEnhanced / VE_DuplicatesEnhanced | Fuzzy duplicate search |
| CU_Outliers / VE_Outliers | Outlier detection in master data | |
| AM/AR/AP/DL BaseTables | Index-based joins for performance & tempdb protection | |
| 2.0.0 2023 | AU_SystemCheck | Added client info to configuration Renamed columns, updated password rules |
| MasterPackage | Added dependencies & bank statement info | |
| MD_BaseTable | Added client joins | |
| GL_AccountBalances | New analytic | |
| O2C_BaseTable | Use VBFA_DL instead of VBFA | |
| AU_P2P_EventLog | Correct source for FI invoice reversal | |
| AM_BaseTable | Added ANLC_GJAHR | |
| AM_NeverDeprecated | Improved AFABE join | |
| AP_BaseTable | Clearing BSCHL concatenation + count | |
| AR_BaseTable | Clearing BSCHL concatenation + count | |
| BL_TaxOnForeignDelivery | Null handling improvements | |
| CU/VE DuplicateBankAccounts | Filter to non-deletion customers/vendors | |
| DL_BaseTable | Correct join for text value | |
| MD_SegregationsOfDuties | Filter to SoD violations | |
| O2C_BaseTable | Increase length of c_BSAD_BSCHL_Clearing | |
| PU_PriceChanges | Fixed several price calculation issues | |
| VE_CriticalBankAccountCountries | Added LFBK fields | |
| VE_ShortBankAccountLifetime | Clean & reorder bank fields | |
| VE_SpecialPaymentTerms | Company-code-independent logic | |
| PU_BaseTable | Fixed sorting & localization | |
| PI_P2P_EventLog | Added many agreement/unit fields | |
| MM_Loan | Aggregate MVKE_KONDM | |
| DL_InvoiceAfterDeliveryYear | Correct VBRP/BSAD join | |
| AP_BaseTable | Use CurrencyConversion for amounts | |
| AR_BaseTable | Use CurrencyConversion for amounts | |
| BL_BaseTable | No KONV entry required anymore | |
| CU_BaseTable_Finance | Improved timescope logic | |
| CU_SpecialPaymentTerms | Fix KNVV count | |
| SD_BaseTable | Fixed credit limit determination | |
| VE_BaseTable_Finance | Improved timescope logic | |
| VE_BankAccountChanges | Fixed lifetime calc, cleaned TIBAN join | |
| PU_BaseTable | Consider EKET for c_BNFPO when EKPO_BNFPO=00000 |