SAP Note
1639462 - ERP accelerators: enhancements in ML drilldown reporting
Component: CO-PC-ACT (Controlling > Product Cost Controlling > Actual Costing), Version: 6, Released On:
23.01.2013
Symptom
This SAP Note deals with the following new functions:
Global variables with free selection (transaction KKMLV), which can then be used in the
drilldown reporting form and in the drilldown report for the selection conditions
instead of simple ranges
Read upon each navigation step (transaction KKML2 -> "Options"). This results in a
clearer improvement in performance, because only the totals records are determined in
the first reading. The detailed information is determined only as required. (Example:
The data records for individual material numbers are not determined until the user wants
to see the data of a material.)
Use of the new material ledger tables (FCML_MAT, FCML_REP) The new ML database tables
contain the material ledger data that is relevant for the drilldown reporting in a
format that can be read quickly. Prerequisite: These tables must be filled with the
current data in advance using the report FCML_FILL_REPORTING_TABLES (transaction
FCML_FILL).
New material ledger tables are read by the HDB (hybrid database, SAP HANA for example).
The tables FCML_MAT and FCML_REP can be read directly by the HDB. This has clear
advantages in terms of performance. There is also the option for these database tables
to be read by the ERP database.
Selection of the material ledger data using further characteristics (data types:
SOBKZ, PRCTR, RUN_ACT, RUN_APP, KOKRS and so on). In addition, a further five fields are
provided (CUST01, CUST02, CUST03, CUST04 and CUST05), which can be filled using the
report FCML_FILL_REPORTING_TABLES and derivation rules (transaction FCML_AGG) according
to customer-specific rules. (See also SAP Note 1654225 for more information.)
Other Terms
Transactions KKML0, KKML1, KKML2, KKML5
Function group KKBM
Function modules K_KKB_ML_DATA_READ, RECHERCHE_READ_DATA_RKKML
Table KKBML
Drilldown reporting
HDBC - Finance and Controlling accelerator
Reason and Prerequisites
You use Actual Costing/Material Ledger.
Solution
1. Program change
Implement the attached corrections.
Check whether the following entries exist and add them if necessary:
2. Function module interface
The interface of the function module RECHERCHE_READ_DATA_RKKML should contain the following
export parameters:
SEL_DATE
SEL_TIME
3. Structure KKBML
(Transaction SE11)
The following fields should be added to the structure KKBML.
For this, see also the documents KKBML_1.pdf and KKBML_2.pdf attached to this SAP Note.
Field Data element
-----------------------
SOBKZ SOBKZ
PRCTR PRCTR
VSZHL VSZHL
CUST01 CHAR30
CUST02 CHAR30
CUST03 CHAR30
CUST04 CHAR10
CUST05 TEXT50
RUN_ACT CKML_RUN_TYPE
RUN_APPL CKML_RUN_APPL
BWKEY BWKEY
KOKRS KOKRS
In addition, the following fields should receive a connection to the corresponding check
table:
Field Check table
-----------------------
BKLAS T025
BWTAR T149D
MEINS T006
SOBKZ T148
PRCTR CEPC
KOKRS TKA01
4. Table maintenance:
(Transaction SE16)
Table TKAFA:
Field Value
APPLC KKML
TABNM KKBML
FIENM
Table TKAF
For the table TKAF, see the document TKAF.pdf attached to this SAP Note.
APPLC FIENM
--------------
KKML BDATJ
KKML BEWER
KKML BKLAS
KKML BUKRS
KKML BWTAR
KKML CATEG
KKML CURTP
KKML CUST01
KKML CUST02
KKML CUST03
KKML CUST04
KKML CUST05
KKML JAHRPER
KKML KABWE_E
KKML KABWE_M
KKML KOKRS
KKML MATKL
KKML MATNR
KKML MEINS
KKML MENGE
KKML MLAST
KKML MTART
KKML PABWE_E
KKML PABWE_M
KKML POPER
KKML POSNR
KKML PRCTR
KKML PRODH
KKML PSPNR
KKML PTYP
KKML RUN_ACT
KKML RUN_APPL
KKML SOBKZ
KKML SPART
KKML VBELN
KKML VSZHL
KKML WAERS
KKML WERKS
5. View maintenance
(Transaction SM30):
View V_TRKB1U:
Appl. class KKML
Table Name KKBML
-> Field Label: Read (German: "Nachlesen")
Field: NACHLESEN
Data element CFNEWSELECT
=> Select checkbox
-> Field Label: Parameter/Selectopt.
Field: SELECT_OPTION
Data element CFVPARSEL
=> Change the value from "Parameters" to "Select option".
(See document V_TRKB1U.PDF attached to this SAP Note.)
6. Authorization objects:
(Transaction SU21)
Enhance the authorization objects
K_ML_MTART
K_TP_VALU
by adding activity 16 (Execute).
7. Global variables for the material ledger drilldown reporting
(Transaction KKMLV)
Create global variables for all fields that you want to use freely in the ML drilldown
reporting if they are not yet in the list of global variables delivered by SAP.
Example:
Appl.class KKML
Type of variable Characteristic value
Variable Name &0BDATJ
Field BDATJ
Replacement type Entry
Optional entry Optional entry
Parameter/Selectopt. Selectoption
Short text Year
Description Year
Text Year
It makes sense to create the following global variables:
Variable type Field Variable name Description
---------------------------------------------------------
1 BDATJ &0BDATJ Year
1 BKLAS &0BKLAS Valuation class
1 BUKRS &0BUKRS Company code
1 BWTAR &0BWTAR Valuation type
1 CURTP &0CURTP Currency type/Valuation
1 CUST01 &0CUST01 CUST01
1 CUST02 &0CUST02 CUST02
1 CUST03 &0CUST03 CUST03
1 CUST04 &0CUST04 CUST04
1 CUST05 &0CUST05 CUST05
1 MATKL &0MATKL Material group
1 MATNR &0MATNR Material number
1 MEINS &0MEINS Base unit of measure
1 MLAST &0MLAST Price determination
1 MTART &0MTART Material type
1 POPER &0POPER Posting period
1 POSNR &0POSNR Item (SD)
1 PRCTR &0PRCTR Profit center
1 PRODH &0PRODH Product hierarchy
1 RUN_ACT &0RUNACT Costing run
1 RUN_APPL &0RUNAPPL Application
1 SOBKZ &0SOBKZ Special stock
1 SPART &0SPART Division
1 VBELN &0VBELN Sales and distribution document
1 WAERS &0WAERS Currency
1 WERKS &0WERKS Plant
(You can find further details in the documents KKMLV_1.PDF, KKMLV_2.PDF and KKMLV_3.PDF
attached to this SAP Note.)
8. Form for the ML drilldown reporting
Create a form using transaction KKML4.
(You can find further details in the documents KKML4_1.PDF, KKML4_2.PDF, KKML4_3.PDF,
KKML4_4.PDF and KKML4_5.PDF attached to this SAP Note.)
Remark: When you try to save the form, the system might issue the error message KH 263 - "An
error was found in form &". If this error ocurs, implement SAP Note 1642628.
9. Report for the ML drilldown reporting
Create a report using transaction KKML1.
(You can find further details in the documents KKML1_1.PDF, KKML1_2.PDF, KKML1_3.PDF and
KKML4_4.PDF attached to this SAP Note.)
10. Executing the report
Transaction KKML0
You can find a sample execution in the documents KKML0_1.PDF and KKML0_2.PDF attached to
this SAP Note.
Software Components
Software Component From To
SAP_APPL 600 600
SAP_APPL 602 602
SAP_APPL 603 603
SAP_APPL 604 604
SAP_APPL 605 605
SAP_APPL 606 606
Correction Instructions
Software Component Number of Correction Instructions
SAP_APPL 1
Prerequisites
Software Component From To SAP Note/KBA Title Component
SAP_APPL 470 605 1457089 KKML0 - wrong amount/quantity displayed CO-PC-IS
SAP_APPL 600 600 1540295 Drlldwn rprtng materl ledgr: Incrr beginning inventory value CO-PC-IS
SAP_APPL 602 602 1540295 Drlldwn rprtng materl ledgr: Incrr beginning inventory value CO-PC-IS
SAP_APPL 603 603 1540295 Drlldwn rprtng materl ledgr: Incrr beginning inventory value CO-PC-IS
SAP_APPL 604 604 1540295 Drlldwn rprtng materl ledgr: Incrr beginning inventory value CO-PC-IS
SAP_APPL 605 605 1540295 Drlldwn rprtng materl ledgr: Incrr beginning inventory value CO-PC-IS
Support Package
Software Component Version Support Package
SAP_APPL 600 SAPKH60021
SAP_APPL 600 SAPKH60022
SAP_APPL 602 SAPKH60211
SAP_APPL 602 SAPKH60212
SAP_APPL 603 SAPKH60310
SAP_APPL 604 SAPKH60411
SAP_APPL 605 SAPKH60508
SAP_APPL 606 SAPKH60602
SAP_APPL 606 SAPKH60603
This document refers to
SAP Note/KBA Component Title
1792216 CO-PC-ACT
1714702 CO-PC-ACT ERP Accelerators:Material Ledger missing Customizing Entries
1654255 CO-PC-ACT ERP Accelerators: Material Ledger - Drill-Down Reporting
1654225 CO-PC-ACT Derivation of customer specific fields in table FCML_MAT
1620213 FI-GL ERP Accelerators: Enhancement Application Settings
This document is referenced by
SAP Note/KBA Component Title
2476887 Material Price Analysis for multiple materials: Material Ledger drill-down reporting
2424007 CO-PC-ACT Drilldown reporting in Material Ledger: FCML tables can be used even without HANA DB
2419686 CO-PC-ACT TIME_OUT or long runtime in KKML0: drilldown reporting in Material Ledger
1620213 CO-PC-ACT ERP Accelerators: Enhancement Application Settings
1792216 CO-PC-ACT KKML0 - Incorrect value for Category 'Not Distributed'
1714702 CO-PC-ACT ERP Accelerators:Material Ledger missing Customizing Entries
1654225 CO-PC-ACT Derivation of customer specific fields in table FCML_MAT
1654255 CO-PC-ACT ERP Accelerators: Material Ledger - Drill-Down Reporting
Attachments
File Name File Size Mime Type
TKAF.pdf 89 application/pdf
KKML1_3.pdf 37 application/pdf
V_TRKB1U.pdf 65 application/pdf
KKML0_2.pdf 63 application/pdf
KKML1_2.pdf 56 application/pdf
KKMLV_3.pdf 36 application/pdf
KKMLV_2.pdf 43 application/pdf
KKML1_4.pdf 44 application/pdf
KKBML_2.pdf 42 application/pdf
KKBML_1.pdf 95 application/pdf
KKMLV_1.pdf 42 application/pdf
KKML4_2.pdf 23 application/pdf
KKML1_1.pdf 63 application/pdf
KKML4_4.pdf 18 application/pdf
KKML4_1.pdf 30 application/pdf
KKML0_1.pdf 55 application/pdf
CA_Drilldown_Reporting.pdf 92 application/pdf
KKML4_5.pdf 34 application/pdf
KKML4_3.pdf 22 application/pdf
