SAP ABAP Table IFW_ITEM (Invoice forecasting item)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-AB-IFW (Application Component) Invoice Forecasting
     ⤷ CIWB (Package) Invoice Forecasting Worklist: Core objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	IFW_ITEM	Table Relationship Diagram
Short Description	Invoice forecasting item

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ROOT_DOC_TYPE	☑	CIWB_DE_ROOT_DOC_TYPE	CIWB_DO_ROOT_DOC_TYPE	CHAR	2	0	Source Document Type	IFW_HEADER
3	ROOT_DOC	☑	IFW_DE_ROOT_DOC	IFW_DO_ROOT_DOC	CHAR	20	0	Source Document	IFW_HEADER
4	ROOT_DOC_ITEM	☑	IFW_DE_ROOT_ITEM	POSNR	NUMC	6	0	Source Document Item	*
5	INV_TYPE	☑	IFW_DE_INV_TYPE	IFW_DO_INV_TYPE	CHAR	2	0	Invoice Reference Type	IFW_HEADER
6	INV_NR	☑	IFW_DE_INV_NR	IFW_DO_INV_NR	CHAR	16	0	Invoice Reference Number	IFW_HEADER
7	INV_ITEM	☑	IFW_DE_INV_ITEM	POSNR	NUMC	6	0	Invoice Item	*
8	INV_CAT	☐	IFW_DE_INV_CAT	IFW_DO_INV_CAT	CHAR	1	0	Invoice Category
9	BILL_SCEN	☐	IFW_DE_BILL_SCEN	IFW_DO_BILL_SCEN	CHAR	1	0	SD Billing Scenario
10	BILL_BLOCK	☐	IFW_DE_BILL_BLOCK	IFW_DO_BILL_BLOCK	CHAR	2	0	Billing: Blocking Reason for Document Items
11	PAIR_ITEM	☐	IFW_DE_INV_PAIR_ITEM	POSNR	NUMC	6	0	Pair item (Negative of item from predecessor invoice)	*
12	ITEM_CANCELLED	☐	IFW_DE_ITEM_CANCELLED	XFELD	CHAR	1	0	Item Cancelled
13	REF_TYPE	☐	IFW_DE_REF_TYPE	IFW_DO_REF_TYPE	CHAR	2	0	Type of Invoice Reference Object
14	REF_OBJ	☐	IFW_DE_REF_OBJ	IFW_DO_REF_OBJ	CHAR	16	0	Invoice Reference Object
15	NET_VAL	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
16	TAX_VAL	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
17	DOC_CUKY	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
18	FX_RATE	☐	KURSF	KURSF	DEC	9	5	Exchange rate
19	QUANTITY	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
20	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
21	PR_CONDTYPE	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
22	PR_STATUS	☐	IFW_DE_PR_STATUS	NUMC2	NUMC	2	0	Status of Evaluation for Pricing
23	PRICE	☐	IFW_DE_PRICE	WERTV7	CURR	13	2	Condition Value for Basic Net Price
24	PRCUR	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
25	PRUNI	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
26	PRUOM	☐	KVMEI	MEINS	UNIT	3	0	Condition unit in the document	*
27	PR_START_DATE	☐	IFW_DE_PR_START_DATE	DATS	DATS	8	0	Pricing Start Date
28	PR_END_DATE	☐	IFW_DE_PR_END_DATE	DATS	DATS	8	0	Pricing End Date
29	FX_START_DATE	☐	IFW_DE_FX_START_DATE	DATS	DATS	8	0	Foreign Exchange Rate Start Date
30	FX_END_DATE	☐	IFW_DE_FX_END_DATE	DATS	DATS	8	0	Foreign Exchange Rate End Date
31	PRICE_RD	☐	IFW_DE_PRICE_RD	WERTV6	CURR	11	2	Net Price of Source Document Item
32	PRCUR_RD	☐	IFW_DE_PRCUR_RD	WAERS	CUKY	5	0	Currency of Net Price for Source Document Item	*
33	PRUNI_RD	☐	IFW_DE_PRUNI_RD	DEC5	DEC	5	0	Price Unit of Net Price for Source Document Item
34	PRUOM_RD	☐	IFW_DE_PRUOM_RD	MEINS	UNIT	3	0	Unit of Measure of Net Price for Source Document Item	*
35	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
36	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
37	INV_DUE_DATE_PRO	☐	IFW_DE_INV_DATE_PRO	DATUM	DATS	8	0	Provisional Invoice Due Date
38	INV_DUE_DATE_FIN	☐	IFW_DE_INV_DATE_FIN	DATUM	DATS	8	0	Final Invoice Due Date
39	PAY_DUE_DATE_PRO	☐	IFW_DE_PAY_DATE	DATUM	DATS	8	0	Payment Due Date
40	PAYDD_DET_PRO	☐	IFW_DE_PAYDD_DET	IFW_DO_PAYDD_DET	CHAR	1	0	Payment Due Date Control
41	PAY_DUE_DATE_FIN	☐	IFW_DE_PAY_DATE	DATUM	DATS	8	0	Payment Due Date
42	PAYDD_DET_FIN	☐	IFW_DE_PAYDD_DET	IFW_DO_PAYDD_DET	CHAR	1	0	Payment Due Date Control
43	INVDD_DET_FIN	☐	IFW_DE_INVDD_DET	IFW_DO_INVDD_DET	CHAR	1	0	Invoice due date control
44	OUTDATED	☐	IFW_DE_OUTDATED	XFELD	CHAR	1	0	Invoice Data Obsolete
45	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IFW_ITEM	CLIENT	T000	MANDT
2	IFW_ITEM	INV_NR	IFW_HEADER	INV_NR	KEY	1	N
3	IFW_ITEM	INV_TYPE	IFW_HEADER	INV_TYPE	KEY	1	N
4	IFW_ITEM	ROOT_DOC	IFW_HEADER	ROOT_DOC	KEY	1	N
5	IFW_ITEM	ROOT_DOC_TYPE	IFW_HEADER	ROOT_DOC_TYPE	KEY	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in	606