SAP ABAP Table IFW_UPDATE_INV (Extraction Invoice Forecasting Worklist)

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	INTTAB	Structure
Structure	IFW_UPDATE_INV	Table Relationship Diagram
Short Description	Extraction Invoice Forecasting Worklist

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	ROOT_DOC_TYPE	☐	CIWB_DE_ROOT_DOC_TYPE	CIWB_DO_ROOT_DOC_TYPE	CHAR	2	0	Source Document Type
2	ROOT_DOC	☐	IFW_DE_ROOT_DOC	IFW_DO_ROOT_DOC	CHAR	20	0	Source Document
3	ROOT_DOC_ITEM	☐	IFW_DE_ROOT_ITEM	POSNR	NUMC	6	0	Source Document Item	*
4	INV_TYPE	☐	IFW_DE_INV_TYPE	IFW_DO_INV_TYPE	CHAR	2	0	Invoice Reference Type
5	INV_NR	☐	IFW_DE_INV_NR	IFW_DO_INV_NR	CHAR	16	0	Invoice Reference Number
6	INV_ITEM	☐	IFW_DE_INV_ITEM	POSNR	NUMC	6	0	Invoice Item	*
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
8	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
9	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
10	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
11	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
12	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
13	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
14	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
15	XBLNR	☐	IFW_DE_XBLNR	IFW_DO_XBLNR	CHAR	30	0	Reference Document Number
16	WL_STATUS	☐	IFW_DE_WL_STATUS	IFW_DO_WL_STATUS	CHAR	1	0	Status of Record in Invoice Forecasting Worklist
17	LAST_CALC	☐	IFW_DE_LAST_CALC	DATS	DATS	8	0	Date of Last Invoice Forecast
18	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
19	INV_DUE_DATE	☐	IFW_DE_INV_DATE	DATUM	DATS	8	0	Invoice Due Date
20	PAY_DUE_DATE	☐	IFW_DE_PAY_DATE	DATUM	DATS	8	0	Payment Due Date
21	BILL_TYPE	☐	IFW_DE_BILL_TYPE	IFW_DO_BILL_TYPE	CHAR	4	0	Billing Document Type
22	CANCELLED	☐	FKSTO	XFELD	CHAR	1	0	Billing document is cancelled
23	PRED_INV_NR	☐	IFW_DE_INV_NR	IFW_DO_INV_NR	CHAR	16	0	Invoice Reference Number
24	PRED_INV_TYPE	☐	IFW_DE_INV_TYPE	IFW_DO_INV_TYPE	CHAR	2	0	Invoice Reference Type
25	OUTDATED	☐	IFW_DE_OUTDATED	XFELD	CHAR	1	0	Invoice Data Obsolete
26	INV_CAT	☐	IFW_DE_INV_CAT	IFW_DO_INV_CAT	CHAR	1	0	Invoice Category
27	PAIR_ITEM	☐	IFW_DE_INV_PAIR_ITEM	POSNR	NUMC	6	0	Pair item (Negative of item from predecessor invoice)	*
28	ITEM_CANCELLED	☐	IFW_DE_ITEM_CANCELLED	XFELD	CHAR	1	0	Item Cancelled
29	REF_TYPE	☐	IFW_DE_REF_TYPE	IFW_DO_REF_TYPE	CHAR	2	0	Type of Invoice Reference Object
30	REF_OBJ	☐	IFW_DE_REF_OBJ	IFW_DO_REF_OBJ	CHAR	16	0	Invoice Reference Object
31	NET_VAL	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
32	TAX_VAL	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
33	DOC_CUKY	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
34	FX_RATE	☐	KURSF	KURSF	DEC	9	5	Exchange rate
35	QUANTITY	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
36	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
37	PR_CONDTYPE	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
38	PR_STATUS	☐	IFW_DE_PR_STATUS	NUMC2	NUMC	2	0	Status of Evaluation for Pricing
39	PRICE	☐	KWERT	WERTV7	CURR	13	2	Condition Value
40	PRCUR	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
41	PRUNI	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
42	PRUOM	☐	KVMEI	MEINS	UNIT	3	0	Condition unit in the document	*
43	PR_START_DATE	☐	IFW_DE_PR_START_DATE	DATS	DATS	8	0	Pricing Start Date
44	PR_END_DATE	☐	IFW_DE_PR_END_DATE	DATS	DATS	8	0	Pricing End Date
45	FX_START_DATE	☐	IFW_DE_FX_START_DATE	DATS	DATS	8	0	Foreign Exchange Rate Start Date
46	FX_END_DATE	☐	IFW_DE_FX_END_DATE	DATS	DATS	8	0	Foreign Exchange Rate End Date
47	PRICE_RD	☐	IFW_DE_PRICE_RD	WERTV6	CURR	11	2	Net Price of Source Document Item
48	PRCUR_RD	☐	IFW_DE_PRCUR_RD	WAERS	CUKY	5	0	Currency of Net Price for Source Document Item	*
49	PRUNI_RD	☐	IFW_DE_PRUNI_RD	DEC5	DEC	5	0	Price Unit of Net Price for Source Document Item
50	PRUOM_RD	☐	IFW_DE_PRUOM_RD	MEINS	UNIT	3	0	Unit of Measure of Net Price for Source Document Item	*
51	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
52	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
53	INV_DUE_DATE_PRO	☐	IFW_DE_INV_DATE	DATUM	DATS	8	0	Invoice Due Date
54	INV_DUE_DATE_FIN	☐	IFW_DE_INV_DATE	DATUM	DATS	8	0	Invoice Due Date
55	PAY_DUE_DATE_PRO	☐	IFW_DE_PAY_DATE	DATUM	DATS	8	0	Payment Due Date
56	PAY_DUE_DATE_FIN	☐	IFW_DE_PAY_DATE	DATUM	DATS	8	0	Payment Due Date
57	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

History

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