IFW_ITEM - Invoice forecasting item

Invoice forecasting item information is stored in SAP table IFW_ITEM.
It is part of development package CIWB in software component LO-AB-IFW. This development package consists of objects that can be grouped under "Invoice Forecasting Worklist: Core objects".

Fields for table IFW_ITEM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	T000
ROOT_DOC_TYPE	Source Document Type	X	CIWB_DE_ROOT_DOC_TYPE	CHAR	4	IFW_HEADER
ROOT_DOC	Source Document	X	IFW_DE_ROOT_DOC	CHAR	40	IFW_HEADER
ROOT_DOC_ITEM	Source Document Item	X	IFW_DE_ROOT_ITEM	NUMC	12	*
INV_TYPE	Invoice Reference Type	X	IFW_DE_INV_TYPE	CHAR	4	IFW_HEADER
INV_NR	Invoice Reference Number	X	IFW_DE_INV_NR	CHAR	32	IFW_HEADER
INV_ITEM	Invoice Item	X	IFW_DE_INV_ITEM	NUMC	12	*
INV_CAT	Invoice Category		IFW_DE_INV_CAT	CHAR	2
BILL_SCEN	SD Billing Scenario		IFW_DE_BILL_SCEN	CHAR	2
BILL_BLOCK	Billing: Blocking Reason for Document Items		IFW_DE_BILL_BLOCK	CHAR	4
PAIR_ITEM	Pair item (Negative of item from predecessor invoice)		IFW_DE_INV_PAIR_ITEM	NUMC	12	*
ITEM_CANCELLED	Item Cancelled		IFW_DE_ITEM_CANCELLED	CHAR	2
REF_TYPE	Type of Invoice Reference Object		IFW_DE_REF_TYPE	CHAR	4
REF_OBJ	Invoice Reference Object		IFW_DE_REF_OBJ	CHAR	32
NET_VAL	Net Value in Document Currency		NETWR	CURR	8
TAX_VAL	Tax Amount in Document Currency		MWSBP	CURR	7
DOC_CUKY	SD Document Currency		WAERK	CUKY	10	*
FX_RATE	Exchange rate		KURSF	DEC	5
QUANTITY	Actual billed quantity		FKIMG	QUAN	7
MEINS	Base Unit of Measure		MEINS	UNIT	6	*
PR_CONDTYPE	Condition Type		KSCHL	CHAR	8	*
PR_STATUS	Status of Evaluation for Pricing		IFW_DE_PR_STATUS	NUMC	4
PRICE	Condition Value for Basic Net Price		IFW_DE_PRICE	CURR	7
PRCUR	Condition Currency (for Cumulation Fields)		KWAEH	CUKY	10	*
PRUNI	Condition Pricing Unit		KPEIN	DEC	3
PRUOM	Condition Unit in the Document		KVMEI	UNIT	6	*
PR_START_DATE	Pricing Start Date		IFW_DE_PR_START_DATE	DATS	16
PR_END_DATE	Pricing End Date		IFW_DE_PR_END_DATE	DATS	16
FX_START_DATE	Foreign Exchange Rate Start Date		IFW_DE_FX_START_DATE	DATS	16
FX_END_DATE	Foreign Exchange Rate End Date		IFW_DE_FX_END_DATE	DATS	16
PRICE_RD	Net Price of Source Document Item		IFW_DE_PRICE_RD	CURR	6
PRCUR_RD	Currency of Net Price for Source Document Item		IFW_DE_PRCUR_RD	CUKY	10	*
PRUNI_RD	Price Unit of Net Price for Source Document Item		IFW_DE_PRUNI_RD	DEC	3
PRUOM_RD	Unit of Measure of Net Price for Source Document Item		IFW_DE_PRUOM_RD	UNIT	6	*
WERKS	Plant		WERKS_D	CHAR	8	*
MATNR	Material Number		MATNR	CHAR	80	*
INV_DUE_DATE_PRO	Provisional Invoice Due Date		IFW_DE_INV_DATE_PRO	DATS	16
INV_DUE_DATE_FIN	Final Invoice Due Date		IFW_DE_INV_DATE_FIN	DATS	16
PAY_DUE_DATE_PRO	Payment Due Date		IFW_DE_PAY_DATE	DATS	16
PAYDD_DET_PRO	Payment Due Date Control		IFW_DE_PAYDD_DET	CHAR	2
PAY_DUE_DATE_FIN	Payment Due Date		IFW_DE_PAY_DATE	DATS	16
PAYDD_DET_FIN	Payment Due Date Control		IFW_DE_PAYDD_DET	CHAR	2
INVDD_DET_FIN	Invoice due date control		IFW_DE_INVDD_DET	CHAR	2
OUTDATED	Invoice Data Obsolete		IFW_DE_OUTDATED	CHAR	2
TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8