...
Version | Changes | Effective Date |
1.0 | First approved version 3Keys MDLP Add-On Note 2024_0102_21 | 1127-JanFeb-2024 |
1. Overview
This document describes changes in the 3Keys MDLP connector ABAP part.
2. Description
New MDLP Analytic reporting methods added functionality adjustment to the 3Keys MDLP connector Add-On:
...
GENERAL_PRICING_REPORT
...
GENERAL_REPORT_ON_MOVEMENT
...
GENERAL_REPORT_ON_REMAINING_ITEM
...
MDLP API version 4.58 changes:
new JSON field processing logic added to scheduler programs (0616_IC_Operation_MDLP_period_all, 1031_IC_Period_Week_all). Field value is filled automatically based on internal date calculation logic
new selection screen field “Source type” added to scheduler programs
new report field support (field “Source type”) added to CSV file parse
New interfaces added to receive response ZIP file from Java part by chunks to support massive ZIP files processing.
In some scenarios ZIP file could not been processed due to runtime error STRING_TOO_LONG related to response ZIP file size. To correct this problem new approach implemented to function module /K3T/RU_MAR_EXEC_GEN_SAVE to unzip file using OS command and split file (using OS command or using stream file reading). This approach is active by default and could be deactivated using parameter PARAMXXX.
New MDLP Analytic reporting methods added to the 3Keys MDLP connector Add-On:
GENERAL_PRICING_REPORT
GENERAL_REPORT_ON_MOVEMENT
GENERAL_REPORT_ON_REMAINING_ITEM
GENERAL_REPORT_ON_DISPOSAL
Corrections for transaction /K3T/RU_MAR_MONITOR Russia MDLP Analytics: Task monitor:
...
in case response is not empty check first character. If it is not “{“ it means connector returns file as base64 without JSON and JSON parse is not required. Return response without correction
Otherwise response is JSON and JSON transformation is required. Read parameter MR_JSON_ZIP_PARSE_MODE and transform JSON to ABAP structure fields depending on specified parse mode:
empty or “1” - use parse mode based on string search. Reduce string length after search
“3” - use ID transformation (recommended approach to transform JSON). In case of big size files runtime error occurs because of memory consumption
3. Solution
Import related to the transport request.
3.1 Correction instruction ATTP 3.0
Transport request | Description / Dependencies |
A1DK900621 | 3Keys MDLP Add-On 3.0 Note 2024_01_02 Required transport A1DK900554 |
3.2 Correction instruction ATTP 3.1
Transport request | Description / Dependencies |
A2DK900691 | 3Keys MDLP Add-On 3.1 Note 2024_01_02 Required transport A2DK900615 |
3.3 Correction instruction ATTP 3.2
Transport request | Description / Dependencies |
A3DK900276 | 3Keys MDLP Add-On 3.2 Note 2024_01_02 Required transport A3DK900190 |
3.4 Correction instruction ATTP 3.3
Transport request | Description / Dependencies |
A4DK900080 | 3Keys MDLP Add-On 3.3 Note 2024_01_02 Required transport A4DK900045 or SAPK-303COINK3T |
4. Recommendation
Implement new methods for analytic data processing from MDLP as old methods marked as obsolete at MDLP API documentation. Update MDLP connector java part to the latest version.
5. Source code objects
Short description | Program | Object type | Object name |
Translation for: Domain | LANG | DOMA | /K3T/D_MR_PERIOD_TYPE |
Translation for: Data Element | LANG | DTEL | /K3T/D_MR_CSV_FILE |
Translation for: Data Element | LANG | DTEL | /K3T/D_MR_PERIODFROM |
Translation for: Data Element | LANG | DTEL | /K3T/D_MR_PERIODTO |
Translation for: Data Element | LANG | DTEL | /K3T/D_MR_PERIOD_TYPE |
Translation for: Data Element | LANG | DTEL | /K3T/D_MR_PERIOD_TYPE_TEXT |
Translation for: Single Message | LANG | MESS | /K3T/REP_RU_MR045 |
Translation for: Report Texts | LANG | REPT | /K3T/RU_MAR_SCD_GEN_MD |
Translation for: Report Texts | LANG | REPT | /K3T/RU_MAR_SCD_GEN_ON_MV |
Translation for: Report Texts | LANG | REPT | /K3T/RU_MAR_SCD_GEN_PR |
Translation for: Report Texts | LANG | REPT | /K3T/RU_MAR_SCD_GEN_RM |
Class Definition (ABAP Objects) | LIMU | CLSD | /K3T/CL_MDLP_API_JOB_DEL_RSLT |
Class Definition (ABAP Objects) | LIMU | CLSD | /K3T/CL_MDLP_API_JOB_GEN_R_DP |
Class Definition (ABAP Objects) | LIMU | CLSD | /K3T/CL_MDLP_API_JOB_GEN_R_PR |
Class Definition (ABAP Objects) | LIMU | CLSD | /K3T/CL_MDLP_API_JOB_GEN_R_RM |
Class Definition (ABAP Objects) | LIMU | CLSD | /K3T/CL_MDLP_API_JOB_RESULTS |
Class Definition (ABAP Objects) | LIMU | CLSD | /K3T/CL_MDLP_API_JOB_RSLT |
Class Definition (ABAP Objects) | LIMU | CLSD | /K3T/CL_MDLP_API_JOB_SEARCH |
Class Definition (ABAP Objects) | LIMU | CLSD | /K3T/CL_MDLP_API_JOB_STATUS |
Class Definition (ABAP Objects) | LIMU | CLSD | /K3T/CL_MR_CONSTANTS |
Class Definition (ABAP Objects) | LIMU | CLSD | /K3T/CL_MR_UI_HELPER |
Class Definition (ABAP Objects) | LIMU | CLSD | /K3T/CL_MR_UTILS |
Private Header (ABAP Objects) | LIMU | CPRI | /K3T/CL_MR_UTILS |
Protected Header (ABAP Objects) | LIMU | CPRO | /K3T/CL_MDLP_API_JOB_DEL_RSLT |
Protected Header (ABAP Objects) | LIMU | CPRO | /K3T/CL_MDLP_API_JOB_GEN_R_DP |
Protected Header (ABAP Objects) | LIMU | CPRO | /K3T/CL_MDLP_API_JOB_GEN_R_MV |
Protected Header (ABAP Objects) | LIMU | CPRO | /K3T/CL_MDLP_API_JOB_GEN_R_PR |
Protected Header (ABAP Objects) | LIMU | CPRO | /K3T/CL_MDLP_API_JOB_GEN_R_RM |
Protected Header (ABAP Objects) | LIMU | CPRO | /K3T/CL_MDLP_API_JOB_RESULTS |
Protected Header (ABAP Objects) | LIMU | CPRO | /K3T/CL_MDLP_API_JOB_RSLT |
Protected Header (ABAP Objects) | LIMU | CPRO | /K3T/CL_MDLP_API_JOB_SEARCH |
Protected Header (ABAP Objects) | LIMU | CPRO | /K3T/CL_MDLP_API_JOB_STATUS |
Protected Header (ABAP Objects) | LIMU | CPRO | /K3T/CL_MR_UI_HELPER |
Protected Header (ABAP Objects) | LIMU | CPRO | /K3T/CL_MR_UTILS |
Public Header (ABAP Objects) | LIMU | CPUB | /K3T/CL_MDLP_API_JOB_DEL_RSLT |
Public Header (ABAP Objects) | LIMU | CPUB | /K3T/CL_MDLP_API_JOB_GEN_R_DP |
Public Header (ABAP Objects) | LIMU | CPUB | /K3T/CL_MDLP_API_JOB_GEN_R_PR |
Public Header (ABAP Objects) | LIMU | CPUB | /K3T/CL_MDLP_API_JOB_GEN_R_RM |
Public Header (ABAP Objects) | LIMU | CPUB | /K3T/CL_MDLP_API_JOB_RESULTS |
Public Header (ABAP Objects) | LIMU | CPUB | /K3T/CL_MDLP_API_JOB_RSLT |
Public Header (ABAP Objects) | LIMU | CPUB | /K3T/CL_MDLP_API_JOB_SEARCH |
Public Header (ABAP Objects) | LIMU | CPUB | /K3T/CL_MDLP_API_JOB_STATUS |
Public Header (ABAP Objects) | LIMU | CPUB | /K3T/CL_MR_CONSTANTS |
Public Header (ABAP Objects) | LIMU | CPUB | /K3T/CL_MR_UI_HELPER |
Public Header (ABAP Objects) | LIMU | CPUB | /K3T/CL_MR_UTILS |
Documentation | LIMU | DOCU | NA/K3T/REP_RU_MR043 |
Documentation | LIMU | DOCU | NA/K3T/REP_RU_MR044 |
Documentation | LIMU | DOCU | NA/K3T/REP_RU_MR045 |
Domain Definition | LIMU | DOMD | /K3T/D_MR_ACTION |
Function Module | LIMU | FUNC | /K3T/RU_MAR_EXEC_GEN_SAVE |
Function Module | LIMU | FUNC | /K3T/RU_MAR_EXEC_SAVE |
Single Message | LIMU | MESS | /K3T/REP_RU_MR043 |
Single Message | LIMU | MESS | /K3T/REP_RU_MR044 |
Single Message | LIMU | MESS | /K3T/REP_RU_MR045 |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_DEL_RSLT CLASS_CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_DEL_RSLT CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_DEL_RSLT EXECUTE |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_GEN_R_DP CLASS_CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_GEN_R_DP CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_GEN_R_MV CLASS_CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_GEN_R_MV CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_GEN_R_PR CLASS_CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_GEN_R_PR CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_GEN_R_RM CLASS_CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_GEN_R_RM CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_RESULTS CLASS_CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_RESULTS COMPOSE_REQUEST |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_RESULTS CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_RSLT CLASS_CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_RSLT CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_RSLT EXECUTE |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_RSLT EXECUTE_MEMORY_OPT |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_SEARCH CLASS_CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_SEARCH CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_STATUS CLASS_CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MDLP_API_JOB_STATUS CONSTRUCTOR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UI_HELPER GET_PERIOD_TYPE_DESCR |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS CONVERT_DATE_EXT_TO_INT |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS CONVERT_DISPOSAL_TYPE |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS DECODE_RESPONSE_ZIP |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS DELETE_CSV_FILE_LOB |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS GET_FIRST_LAST_DAY_OF_MONTH |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS GET_FIRST_LAST_DAY_OF_WEEK |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS GET_MONTH_NUMBER |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS GET_REPORT_TABLE |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS MAP_AND_SAVE |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS MAP_GEN_AND_SAVE |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS PARSE_BP |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS PREPARE_CSV_FILE_LOB |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS SET_GEN_MAPPER |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS SET_MAPPER |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS SPLIT_CSV_FILE_HEADER |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS SPLIT_CSV_FILE_PART |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS SPLIT_CSV_FILE_PART_WITH_LOB |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS TRANSFORM_JSON_ZIP_TO_ABAP |
Method (ABAP Objects) | LIMU | METH | /K3T/CL_MR_UTILS UPLOAD_CSV_TABLE |
Report Source Code | LIMU | REPS | /K3T/LRU_MAR_EXECUXX |
Report Source Code | LIMU | REPS | /K3T/RU_MAR_MONITOR_C01 |
Report Source Code | LIMU | REPS | /K3T/RU_MAR_REP_PROC_C01 |
Report Source Code | LIMU | REPS | /K3T/RU_MAR_SCD_GEN_MD_C01 |
Report Source Code | LIMU | REPS | /K3T/RU_MAR_SCD_GEN_MD_SSC |
Report Source Code | LIMU | REPS | /K3T/RU_MAR_SCD_GEN_ON_MV_C01 |
Report Source Code | LIMU | REPS | /K3T/RU_MAR_SCD_GEN_ON_MV_SSC |
Report Source Code | LIMU | REPS | /K3T/RU_MAR_SCD_GEN_PR_C01 |
Report Source Code | LIMU | REPS | /K3T/RU_MAR_SCD_GEN_PR_SSC |
Report Source Code | LIMU | REPS | /K3T/RU_MAR_SCD_GEN_RM_C01 |
Report Source Code | LIMU | REPS | /K3T/RU_MAR_SCD_GEN_RM_SSC |
Report Source Code | LIMU | REPS | /K3T/RU_MAR_SCD_MD_C01 |
Report Texts | LIMU | REPT | /K3T/RU_MAR_MONITOR |
Report Texts | LIMU | REPT | /K3T/RU_MAR_REP_PROC_C01 |
Report Texts | LIMU | REPT | /K3T/RU_MAR_SCD_GEN_MD |
Report Texts | LIMU | REPT | /K3T/RU_MAR_SCD_GEN_ON_MV |
Report Texts | LIMU | REPT | /K3T/RU_MAR_SCD_GEN_PR |
Report Texts | LIMU | REPT | /K3T/RU_MAR_SCD_GEN_RM |
Table Definition | LIMU | TABD | /K3T/RU_ALV_MR |
Table Definition | LIMU | TABD | /K3T/RU_R_BP |
Table Definition | LIMU | TABD | /K3T/RU_R_FILE |
Table Definition | LIMU | TABD | /K3T/RU_R_TSK |
Domain | R3TR | DOMA | /K3T/D_MR_EXIT_TYPE |
Domain | R3TR | DOMA | /K3T/D_MR_PERIOD_TYPE |
Domain | R3TR | DOMA | /K3T/RU_NOTE2024_01_02V1 |
Data Element | R3TR | DTEL | /K3T/D_MR_ADDRESS |
Data Element | R3TR | DTEL | /K3T/D_MR_CSV_FILE |
Data Element | R3TR | DTEL | /K3T/D_MR_EXIT_DATE |
Data Element | R3TR | DTEL | /K3T/D_MR_EXIT_TYPE |
Data Element | R3TR | DTEL | /K3T/D_MR_FILE_NAME |
Data Element | R3TR | DTEL | /K3T/D_MR_FILE_PART_NUMBER |
Data Element | R3TR | DTEL | /K3T/D_MR_PERIODFROM |
Data Element | R3TR | DTEL | /K3T/D_MR_PERIODTO |
Data Element | R3TR | DTEL | /K3T/D_MR_PERIOD_TYPE |
Data Element | R3TR | DTEL | /K3T/D_MR_PERIOD_TYPE_TEXT |
Table | R3TR | TABL | /K3T/RU_R_FILE |
Table | R3TR | TABL | /K3T/RU_R_G_MD |
Table | R3TR | TABL | /K3T/RU_R_G_MV |
Table | R3TR | TABL | /K3T/RU_R_G_PR |
Table | R3TR | TABL | /K3T/RU_R_G_RM |
View | R3TR | VIEW | /K3T/RU_R_G_MD_V |
View | R3TR | VIEW | /K3T/RU_R_G_MV_V |
View | R3TR | VIEW | /K3T/RU_R_G_PR_VRM |
View | R3TR | VIEW | /K3T/RU_R_G_RMMD_V |
...
View |
...
| name | ATTP30_Note_2024_01_2_3Keys_MDLP_Connector_1.0.zip |
|---|
| View file | ||
|---|---|---|
|
| View file | ||
|---|---|---|
|
R3TR | VIEW | /K3T/RU_R_G_MV_V | |
View | R3TR | VIEW | /K3T/RU_R_G_PR_V |
View | R3TR | VIEW | /K3T/RU_R_G_RM_V |