Release Notes Content SQL 2.2.x
| Version & Date | Component | Changes |
|---|---|---|
| 2.2.4 2024-02-06 | Root Cause | The values of the columns Root_Cause_Count and Root_Cause_Volume are correctly mapped to the SQL column names |
| AM_BaseTable | Use most recent values from ANLZ in analytic time period | |
| AP_DelayedPayments | Added c_Cluster to standard result set | |
| AP_InvoiceBeforeVendorCreation | Added c_Cluster to standard result set | |
| AP_OneTimeAccounts | Added c_LFB1_ERDAT to standard result set | |
| AR_CreditNoteClearing | Added c_UpdateKey_AnalyticStep to standard result set | |
| AR_CustomerTurnover | Added c_UpdateKey_AnalyticStep to standard result set | |
| AR_Discount | Filter for results changed to percentage | |
| AR_RoundAmounts | Added more categorys, removed line items with STBLG | |
| AR_PaymentTerms | Added filter for T052 values Added c_KNB1_ZTAG1, c_KNB1_ZTAG2, c_KNB1_ZTAG3, c_KNB1_ZPRZ1, c_KNB1_ZPRZ2 to standard result set | |
| AM_DepreciationCalculation | Fixed error when c_ANLC_MAX_KANSW_RC = 0 AND c_Useful_Life_Years = 0 | |
| AM_DepreciationOver | Use of local currency values for detection | |
| AM_NoDepreciation | Use of local currency values for identification | |
| Currency Conversion | Revert to TCURF usage | |
| AP_DelayedPayments | Fixed calculation for c_Age, when c_FinalDueDate is NULL | |
| AP_OneTimeAccounts | Filter added to exclude old items | |
| Currency conversion | Exclude invalid entries in TCURF | |
| dab DEAN | Introduction of dab: DEAN for AP, AR, BL, DL, GL, MD, MM, PU, SD | |
| 2.2.3 2024-01-17 | DL_RootCause | Execute Root Cause AI for nearly every DL Analytic Step |
| All DL Analytics | Added missing fields for execution of Root Cause | |
| AM_RootCause | Execute Root Cause AI for nearly every AM Analytic Step | |
| All AM Analytics | Added missing fields for execution of Root Cause | |
| GL_RootCause | Execute Root Cause AI for nearly every GL Analytic Step | |
| All GL Analytics | Added missing fields for execution of Root Cause | |
| MD_RootCause | Execute Root Cause AI for nearly every MD Analytic Step | |
| All MD Analytics | Added missing fields for execution of Root Cause | |
| MM_RootCause | Execute Root Cause AI for nearly every MM Analytic Step | |
| All MM Analytics | Added missing fields for execution of Root Cause | |
| SD_RootCause | Execute Root Cause AI for nearly every SD Analytic Step | |
| All SD Analytics | Added missing fields for execution of Root Cause | |
| EB_CriticalPayeeCountries, EB_PayeeCountryDifference, EB_PayeeDifference | Initial port from dab AnalyticSuite (ACL) | |
| Custom Analytics | Added function for alphabetic filtering dabFilterAlphabetic | |
| MD_UnusualPostings | Matching analytic name in the sql code | |
| Currency conversion | Omit unvalid entries in TCURR | |
| BL_BaseTable | Remove T052_ZDART from payment term selection | |
| SD_BaseTable | Remove T052_ZDART from payment term selection | |
| 2.2.2 2023-11-29 | Root_Cause_Analyse.R | Column names are now correctly processed |
| Fuzzy_Duplicates_in_Stammdaten_suchen.R | Now all findings are handed over to SQL | |
| All Analytics | Fixed decimal shift calculation for TCURX | |
| AR_CPD | Fixed AR_CPD_NotUnique table missing | |
| Fuzzy_Duplicates_in_Stammdaten_suchen.R | Reduce amount of print statements to increase performance | |
| DQM-Scripts | Added missing fields TELF1 and STCEG For Duplicates changed datatype of Duplicate_ID to INT | |
| 2.2.1 2023-11-09 | PU_OutlineAgreement | Fixed multiple entries for one contract in contract list |
| CU_DuplicatesEnhanced & VE_DuplicatesEnhanced | Additional fields needed for R script; Added new field Category; Implemented error handling | |
| CU_Outliers & VE_Outliers | Additional fields needed for R script; Implemented error handling | |
| Fuzzy_Duplicates_in_Stammdaten_suchen.R | Added new columns; Empty result is now processable | |
| Monkey_Typing_in_Stammdaten_suchen.R | Added new columns; Empty result is now processable | |
| Fuzzy_Duplicates_in_Stammdaten_suchen.R-Script | Duplicate_ID is now filled with values | |
| CU_DuplicatesEnhanced & VE_DuplicatesEnhanced | Use PSTLZ from Basetables and do not use NULL as default value anymore | |
| 2.2.0 2023-11-06 | Master package | Updated the bundled master package to the new package variant format; For content usage dab Nexus >= 1.11 is now required |
| AR_RootCause | Execute Root Cause AI for nearly every AR Analytic Step | |
| All AR Analytics | Added required fields for execution of Root Cause AI | |
| Root_Cause_Analyse.R | Updated to newest Version of R Script 1.13 | |
| PU_RootCause | Execute Root Cause AI for nearly every PU Analytic Step | |
| All PU Analytics | Added required fields for execution of Root Cause AI | |
| BL_RootCause | Execute Root Cause AI for nearly every BL Analytic Step | |
| All BL Analytics | Added required fields for execution of Root Cause AI | |
| MM_Inventory_Coverage | Added T001K_BUKRS to standard result set | |
| MM_LocationCodes | Renamed c_UpdateKey to c_UpdateKey_AnalyticStep | |
| MM_MaterialTextChanges | Added c_UpdateKey_AnalyticStep to standard result set to avoid duplicates; Removed c_UpdateKey and MARC_WERKS from standard result set to avoid duplicates; Added c_Language, USR02_USTYP, c_USR02_USTYP_Text to standard result set | |
| MM_NoMinPOQty | Added T001K_BUKRS, T001W_NAME1, MBEW_LBKUM, c_MBEW_SALK3_RC, MARA_MTART and T134T_MTBEZ to standard result set | |
| MM_PriceComparison | Changed calculation for c_SD_Invoice_NETPR_RC; Added c_VBRP_NETWR_RC and c_EKBE_NETWR_RC to standard result set | |
| MM_QuantityUnitChanges | Added c_UpdateKey_AnalyticStep to standard result set to avoid duplicates; Removed c_UpdateKey and MARC_WERKS from standard result set to avoid duplicates; Added USR02_USTYP and c_USR02_USTYP_Text to standard result set |