SAP Table CKMLVARIANT

FIFO Costing Variant

CKMLVARIANT (FIFO Costing Variant) 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 CKMLVARIANT to other SAP tables.

CKMLVARIANT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
FIFOVAR FIFO Costing Variant (Material Ledger) CKMLBB_FIFOVAR CHAR 4 0
RSCHEMA Key Figure Scheme in Material Ledger CKMLBB_SCHEMA CKMLRSCHEMA CHAR 2 0
XKDM Indicator: Include Exchange Rate Differences CKMLBB_XKDM CHAR 1 0
X Yes
NULL No
XMULTI Indicator: Include Multi-Level Differences CKMLBB_XMULTI CHAR 1 0
X Yes
NULL No
XEBEW Indicator: Process Valuated Sales Order Stocks CKMLBB_XEBEW CHAR 1 0
X Yes
NULL No
XQBEW Indicator: Edit Valuated Project Stock CKMLBB_XQBEW CHAR 1 0
X Yes
NULL No
EXPOL Tolerance limit for FIFO valuation: calculated price from MY_EXPOL DEC 4 1
ALTNT Tolerance limit for FIFO valuation: alternative value from MY_ALTNT DEC 4 1
SOCLE Alernative value for FIFO valuation: base receipt record MY_SOCLE CHAR 1 0
X Yes
NULL No
LASTR Alternative options for FIFO valuation: last FIFO result MY_LASTR CHAR 1 0
X Yes
NULL No
MATPR Alternative value for FIFO valuation: material price MY_MATPR CHAR 1 0
X Yes
NULL No
XALLCR Indicator: Process All Material Ledger Currencies CKMLBB_XALLCR CHAR 1 0
X Yes
NULL No
CURT1 FIFO-Relevant Currency Types/Valuation Views CKMLBB_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
CURT2 FIFO-Relevant Currency Types/Valuation Views CKMLBB_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
CURT3 FIFO-Relevant Currency Types/Valuation Views CKMLBB_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
PRKZG Price Name for Ending Inventory/Balance Sheet Valuation CK_PRICE_KZG TCKMLPR_EB CHAR 3 0

CKMLVARIANT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CKMLVARIANT PRKZG CKMLVARIANT MANDT TCKMLPR_EB Customizing for Bal. Sheet Valuation: Define Valuation Areas MANDT
CKMLVARIANT PRKZG CKMLVARIANT PRKZG TCKMLPR_EB Customizing for Bal. Sheet Valuation: Define Valuation Areas PRKZG
CKMLVARIANT RSCHEMA CKMLVARIANT MANDT CKMLRSCHEMA Key Figure Scheme in Material Ledger MANDT
CKMLVARIANT RSCHEMA CKMLVARIANT RSCHEMA CKMLRSCHEMA Key Figure Scheme in Material Ledger RSCHEMA