SAP ABAP Table IFW_UI_ITEM (Invoice forecasting item for UI)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	IFW_UI_ITEM	Table Relationship Diagram
Short Description	Invoice forecasting item for UI

Delivery and Maintenance

Pool/cluster
Delivery Class
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	STATUS	☐	IFW_DE_STATUS		CHAR	3	0	Status
2	STATUS_ICON	☐	IFW_DE_ICON	ICON	CHAR	4	0	Icon	*
3	STATUS_ICON_PRIORITY	☐	IFW_DE_ICON_PRIORITY	NUMC2	NUMC	2	0	Priority for Status Icon Sorting
4	STATUS_ICON_TOOLTIP	☐	IFW_DE_TOOLTIP	TEXT30	CHAR	30	0	Tooltip
5	STATUS_DESC	☐	IFW_DE_STATUS_DESC	TEXT40	CHAR	40	0	Status Text
6	INV_DOC_DESC	☐	IWF_DE_INV_DOC_DESC		CHAR	50	0	Invoice Item Description
7	TRADE_TYPE	☐	IFW_DE_TRADE_TYPE		CHAR	10	0	Trade type (Buy/Sell)
8	ROOT_DOC_TYPE	☐	CIWB_DE_ROOT_DOC_TYPE	CIWB_DO_ROOT_DOC_TYPE	CHAR	2	0	Source Document Type
9	ROOT_DOC	☐	IFW_DE_ROOT_DOC	IFW_DO_ROOT_DOC	CHAR	20	0	Source Document
10	ROOT_DOC_ITEM	☐	IFW_DE_ROOT_ITEM	POSNR	NUMC	6	0	Source Document Item	*
11	INV_TYPE	☐	IFW_DE_INV_TYPE	IFW_DO_INV_TYPE	CHAR	2	0	Invoice Reference Type
12	INV_NR	☐	IFW_DE_INV_NR	IFW_DO_INV_NR	CHAR	16	0	Invoice Reference Number
13	INV_ITEM	☐	IFW_DE_INV_ITEM	POSNR	NUMC	6	0	Invoice Item	*
14	ITEM_CANCELLED	☐	IFW_DE_ITEM_CANCELLED	XFELD	CHAR	1	0	Item Cancelled
15	INV_CAT	☐	IFW_DE_INV_CAT	IFW_DO_INV_CAT	CHAR	1	0	Invoice Category
16	NET_VAL	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
17	TAX_VAL	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
18	DOC_CUKY	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
19	FX_RATE	☐	KURSF	KURSF	DEC	9	5	Exchange rate
20	QUANTITY	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
21	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
22	PR_CONDTYPE	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
23	PR_STATUS	☐	IFW_DE_PR_STATUS	NUMC2	NUMC	2	0	Status of Evaluation for Pricing
24	PRICE	☐	KWERT	WERTV7	CURR	13	2	Condition Value
25	PRCUR	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
26	PRUNI	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
27	PRUOM	☐	KVMEI	MEINS	UNIT	3	0	Condition unit in the document	*
28	PR_START_DATE	☐	IFW_DE_PR_START_DATE	DATS	DATS	8	0	Pricing Start Date
29	PR_END_DATE	☐	IFW_DE_PR_END_DATE	DATS	DATS	8	0	Pricing End Date
30	FX_START_DATE	☐	IFW_DE_FX_START_DATE	DATS	DATS	8	0	Foreign Exchange Rate Start Date
31	FX_END_DATE	☐	IFW_DE_FX_END_DATE	DATS	DATS	8	0	Foreign Exchange Rate End Date
32	PRICE_RD	☐	IFW_DE_PRICE_RD	WERTV6	CURR	11	2	Net Price of Source Document Item
33	PRCUR_RD	☐	IFW_DE_PRCUR_RD	WAERS	CUKY	5	0	Currency of Net Price for Source Document Item	*
34	PRUNI_RD	☐	IFW_DE_PRUNI_RD	DEC5	DEC	5	0	Price Unit of Net Price for Source Document Item
35	PRUOM_RD	☐	IFW_DE_PRUOM_RD	MEINS	UNIT	3	0	Unit of Measure of Net Price for Source Document Item	*
36	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
37	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
38	INV_DUE_DATE	☐	IFW_DE_INV_DATE	DATUM	DATS	8	0	Invoice Due Date
39	PAY_DUE_DATE	☐	IFW_DE_PAY_DATE	DATUM	DATS	8	0	Payment Due Date
40	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
41	CANCELLED	☐	FKSTO	XFELD	CHAR	1	0	Billing document is cancelled
42	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
43	BILL_TYPE	☐	IFW_DE_BILL_TYPE	IFW_DO_BILL_TYPE	CHAR	4	0	Billing Document Type
44	ITEM_PAID	☐	IFW_DE_ITEM_PAID	IFW_DO_ITEM_PAID	CHAR	1	0	Indicator: Item Paid
45	BILL_BLOCK	☐	IFW_DE_BILL_BLOCK	IFW_DO_BILL_BLOCK	CHAR	2	0	Billing: Blocking Reason for Document Items

History

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