FMLT_PRICE - Material Price

Material Price information is stored in SAP table FMLT_PRICE.
It is part of development package FINS_ML_PRICE_TABLE in software component CO-PC-ML. This development package consists of objects that can be grouped under "Material Ledger - Price Table".

Fields for table FMLT_PRICE

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		FMLS_PRICE_KEY	0
MANDT	Client	X	MANDT	CLNT	6	*
.INCLUDE		X		FMLS_PRICE_FUNCTIONAL_KEY	0
KALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	X	CK_KALNR	NUMC	24	*
RLDNR	Ledger in General Ledger Accounting	X	FINS_LEDGER	CHAR	4
EXT_CURTYPE	External Currency Type and Valuation View	X	FINS_EXT_CURTYPE	CHAR	4	*
PRICE_TYPE	Material Price Type	X	FML_PRICE_TYPE	CHAR	16
PRICE_SUBTYPE	Material Price Sub-Type	X	FML_PRICE_SUBTYPE	CHAR	24
DATE_FROM	Valid From	X	FML_DATE_FROM	DATS	16
.INCLUDE				FMLS_PRICE_ATTRIBUTES	0
.INCLUDE				FMLS_PRICE_VALIDITY	0
DATE_TO	Valid To		FML_DATE_TO	DATS	16
YRPER_FROM	Fiscal Period From		FML_PERIOD_YEAR_FROM	NUMC	14
GJAHR_FROM	From Fiscal Year		FML_GJAHR_FROM	NUMC	8
PERIOD_FROM	From Period		FML_PERIOD_FROM	NUMC	6
YRPER_TO	Fiscal Period To		FML_PERIOD_YEAR_TO	NUMC	14
GJAHR_TO	To Fiscal Year		FML_GJAHR_TO	NUMC	8
PERIOD_TO	To Period		FML_PERIOD_TO	NUMC	6
.INCLUDE				FMLS_PRICE_MAIN	0
PRICE	Material Ledger Price		FML_PRICE	CURR	12
WAERS	Currency Key		WAERS	CUKY	10	*
PEINH	Price unit		PEINH	DEC	3
VALUM	Valuation Unit of Measure		VALUM	UNIT	6	*
PRICE_NUMERATOR	Price Value for Value/Quantity Notation		FML_PR_VALUE	CURR	12
PRICE_DENOMINATOR	Price Quantity for Value/Quantity Notation		FML_PR_QTY	QUAN	12
VPRSV	Price control indicator		VPRSV	CHAR	2
PRICE_FIXED	Material Ledger Price: Fixed Portion		FML_PRICE_FIXED	CURR	12
LBWST	Val. Strat. for Current Plan Price, Sales Order/Proj. Stock		CK_LBWST	CHAR	2
CE_STAGE	Stage of Standard Cost Estimate		FML_CE_STAGE	CHAR	2
SALKV_COMPAT	Value based on moving average price (only with price ctrl S)		FML_SALKV_COMPAT	CURR	12
.INCLUDE				FMLS_PRICE_XBEW_KEY	0
MATNR	Material Number		MATNR	CHAR	80
BWKEY	Valuation area		BWKEY	CHAR	8	*
BWTAR	Valuation Type		BWTAR_D	CHAR	20	*
SOBKZ	Special Stock Indicator		SOBKZ	CHAR	2	*
KDAUF	Sales order number of valuated sales order stock		MAT_KDAUF	CHAR	20
KDPOS	Sales Order Item of Valuated Sales Order Stock		MAT_KDPOS	NUMC	12
PSPNR	Valuated Sales Order Stock WBS Element		MAT_PSPNR	NUMC	16	*
LIFNR	Valuated Vendor Stocks		MAT_LIFNR	CHAR	20	*
BUKRS	Company Code		BUKRS	CHAR	8
OTYPE	Type of Valuation Segment		FML_OTYPE	CHAR	2
.INCLUDE				FMLS_PRICE_REFERENCE	0
ORIGIN_EXTREF_CATEGORY	External Reference Category		FML_ORIGIN_EXTREF_CATEGORY	CHAR	4
ORIGIN_EXTREF_DATA	External Reference Data		FML_ORIGIN_EXTREF_DATA	CHAR	160
INIT_OBJ_EXTREF_CATEGORY	External Reference Category		FML_INIT_OBJ_EXTREF_CATEGORY	CHAR	4
INIT_OBJ_EXTREF_DATA	External Reference Data		FML_INIT_OBJ_EXTREF_DATA	CHAR	160
.INCLUDE				FMLS_PRICE_IDENTITY	0
CREATED_BY_USER	User who created record		ANNAM	CHAR	24
CREATED_ON	Date/Time: when record has been added		FML_CREATED_ON_TSL	DEC	11
CHANGED_BY_USER	Name of Person Who Changed Object		AENAM	CHAR	24
CHANGED_ON	Date/Time: when record has been last changed		FML_CHANGED_ON_TSL	DEC	11
CCB_ID	CCB: Cost Component Breakdown ID		FCO_CCB_ID	RAW	16
PRICE_ID	ML Price ID (UUID)		FML_PRICE_ID	RAW	16