1. Home
  2. Resources
  3. SAP Tables
  4. KKBML - Drilldown Structure Material Ledger/Actual Costing

SAP Table KKBML

Drilldown Structure Material Ledger/Actual Costing

KKBML (Drilldown Structure Material Ledger/Actual Costing) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link KKBML to other SAP tables.

KKBML table fields

Field Data element Checktable Datatype Length Decimals
BEWER Preliminary Valuation KKB_ML_BEWER CURR 15 2
BKLAS Valuation Class BKLAS T025 CHAR 4 0
BUKRS Company Code BUKRS CHAR 4 0
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
CATEG Category in Material Ledger Data Display CKML_CATEG CHAR 2 0
AB Beginning Inventory
PC Price Changes
ZU Receipts
VP Other Receipts/Consumption
VN Consumption
EB Ending Inventory
NV Not Distributed
KB Cumulative Inventory
NC Not Allocated
CURRTYP Currency Type CURRTYP CHAR 2 0
00 Document currency
10 Company code currency
20 Controlling area currency
30 Group currency
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
80 Ledger currency
90 Profit center accounting currency
A0 Financial management area currency
B0 Operating concern currency
C0 Consolidation unit currency
CURTP Currency Type and Valuation View CURTP CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
BDATJ Posting Date YYYY BDATJ NUMC 4 0
POPER Posting period POPER NUMC 3 0
JAHRPER Period/year JAHRPER NUMC 7 0
KABWE_E Single-Level Exchange Rate Differences KKB_ML_KABWE_E CURR 15 2
KABWE_M Multilevel Exchange Rate Differences KKB_ML_KABWE_M CURR 15 2
MATKL Material Group MATKL CHAR 9 0
MATNR Material Number MATNR CHAR 18 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
MENGE Quantity KKB_ML_MENGE QUAN 15 3
MLAST Material Price Determination: Control CK_ML_ABST CHAR 1 0
2 Transaction-Based
3 Single-/Multilevel
MTART Material Type MTART T134 CHAR 4 0
PABWE_E Single-Level Price Differences KKB_ML_PABWE_E CURR 15 2
PABWE_M Multilevel Price Differences KKB_ML_PABWE_M CURR 15 2
POSNR Item number of the SD document POSNR NUMC 6 0
PRODH Product hierarchy PRODH_D T179 CHAR 18 0
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
PTYP Process Category (Procurement/Consumption) CKML_PROZESS_TYP CHAR 4 0
SPART Division SPART CHAR 2 0
VALUTYP Valuation View VALUTYP NUMC 1 0
0 Legal Valuation
1 Group Valuation
2 Profit Center Valuation
5 Parallel Cost of Goods Manufactured 1
6 Parallel Cost of Goods Manufactured 2
7 Parallel Cost of Goods Manufactured 3
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
WAERS Currency Key WAERS CUKY 5 0
WERKS Plant WERKS_D CHAR 4 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
PRCTR Profit Center PRCTR CHAR 10 0
VSZHL Internal version counter ( ea. version has a unique number) VSZHL NUMC 8 0
CUST01 30 Characters CHAR30 CHAR 30 0
CUST02 30 Characters CHAR30 CHAR 30 0
CUST03 30 Characters CHAR30 CHAR 30 0
CUST04 Character Field Length = 10 CHAR10 CHAR 10 0
CUST05 Text Field TEXT50 CHAR 50 0
RUN_ACT Costing Run in Actual Costing CKML_RUN_TYPE CHAR 8 0
RUN_APPL Material Ledger Costing Run Application CKML_RUN_APPL CHAR 4 0
ACRU Actual Costing
CUM Alternative Valuation
BWKEY Valuation Area BWKEY CHAR 4 0
KOKRS Controlling Area KOKRS CHAR 4 0

KKBML foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KKBML BKLAS SYST MANDT T025 Valuation Classes MANDT
KKBML BKLAS KKBML BKLAS T025 Valuation Classes BKLAS
KKBML BWTAR SYST MANDT T149D Global Valuation Types MANDT
KKBML BWTAR KKBML BWTAR T149D Global Valuation Types BWTAR
KKBML MEINS SYST MANDT T006 Units of Measurement MANDT
KKBML MEINS KKBML MEINS T006 Units of Measurement MSEHI
KKBML MTART SYST MANDT T134 Material Types MANDT
KKBML MTART KKBML MTART T134 Material Types MTART
KKBML PRODH SYST MANDT T179 Materials: Product Hierarchies MANDT
KKBML PRODH KKBML PRODH T179 Materials: Product Hierarchies PRODH
KKBML SOBKZ KKBML SOBKZ T148 Special Stock Indicator SOBKZ
KKBML SOBKZ SYST MANDT T148 Special Stock Indicator MANDT