Content Release Notes 2.1.x (SQL)
Version & Date | Components | 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 | |
AP_DuplicatePaymentsEnhanced | Added missing dab:Link columns | |
AP_DuplicatePaymentsEnhanced | 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 | |
PU_BaseTable | 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 | |
BL_BaseTable | Added VBRP_KOWRR & c_Statistical_Value_RC | |
BL_BaseTable | If statistical → NETWR fields set to 0 | |
BL_BaseTable | 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 |
All analytics | Fixed issues with dab Link columns | |
All analytics | 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 |
AU_SystemCheck | 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 |
