SAP table CKMLVARIANT (FIFO Costing Variant)

SAP table CKMLVARIANT has 2 primary key fields being MANDT,FIFOVAR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

CKMLVARIANT foreign key relationships

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