	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

261 COLUMNS | 1 INDEXES | ERP 6.0 | WDFR_POS TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Materials Management :: Purchasing
1	ERP EHP7	6.0	WDFR_POS	261	1	Perishables Planninng Item	Purchasing

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, FBELN, FPOSN, FPOSB, FPOSA, IBELN, WERKS, DISPNR, MATNR, LIFNR, LOCNR, TABIX, SELKZ, IPOSN, IPOSB, IPOSA, LINPUTKZ, LIEFNR, LNAME1, LORT01, FWERKS, FNAME1, FORT01, DEBNR, FLOCNR, BUKRS, VKORG, VTWEG, SPART, LAND1, MAKTX, EMATN, ATTYP, UEBPO, UPTYP, UPVOR, KTMNG, MENGE, PLANM, MEINS, BPRME, BPUMZ, BPUMN, UMREZ, UMREN, NETPR, PEINH, NETWR, BRTWR, WAERS, BMENGE, BMEINS, EBELN, EBELP, LOEKZ, STATU, AEDAT, LGORT, BEDNR, MATKL, INFNR, IDNLF, AGDAT, WEBAZ, MWSKZ, BONUS, INSMK, SPINF, PRSDR, SCHPR, MAHNZ, MAHN1, MAHN2, MAHN3, UEBTO, UEBTK, UNTTO, BWTAR, BWTTY, ABSKZ, AGMEM, ELIKZ, EREKZ, BSART, PSTYP, KNTTP, KTMNG_ABG, BKTMNG_ABG, RANG, EKPNN, EKPGR, EKPGR_K, EKPGR_VME, SPABA, SPANE, SPANA, ENDPA, VKPNE, VRKME, HWAER, KWAER, VWAER, PROZ, MENGE_BAS, UMSMNG_BAS, UAVMNG_BAS, BVLMNG_BAS, DIFMNG_BAS, TEMMNG_BAS, LABST_BAS, ATPBST_BAS, BSTBDRF_BAS, BASME, UMSMNG_ANZ, UAVMNG_ANZ, BVLMNG_ANZ, DIFMNG_ANZ, TEMMNG_ANZ, LABST_ANZ, ATPBST_ANZ, BSTBDRF_ANZ, ANZME, INDMN1, INDMN2, INDMN3, INDMN4, INDMN5, INDBAS, INDMA1, INDMA2, INDMA3, INDMA4, INDMA5, INDANZ, INDPR1, INDPR2, INDPR3, INDWA1, INDWA2, INDWA3, INDA08, INDA16, INDA32, INDA081, INDA161, INDA321, INDST1, INDST2, INDST3, INDST4, INDST5, LIWKZ, LMENGE_S, LWPRZ_S, BMENGE_S, MEINS_S, BMEINS_S, LMENGE_1, LEIND_1, LZEIT_1, LWPRZ_1, BMENGE_1, LMENGE_2, LEIND_2, LZEIT_2, LWPRZ_2, BMENGE_2, LMENGE_3, LEIND_3, LZEIT_3, LWPRZ_3, BMENGE_3, LMENGE_4, LEIND_4, LZEIT_4, LWPRZ_4, BMENGE_4, LMENGE_5, LEIND_5, LZEIT_5, LWPRZ_5, BMENGE_5, LMENGE_6, LEIND_6, LZEIT_6, LWPRZ_6, BMENGE_6, LMENGE_7, LEIND_7, LZEIT_7, LWPRZ_7, BMENGE_7, DISART, ABGART, AUFAR, APSTP, SBELN, ASTRA, ABELN, ABELP, LISTG, RUNDG, RESTV, AAVIT, BERMIMA, BSTGE, BEZCH, AFDTP, AFDAT, VKDTP, VKDAT, FBDAT, FUDAT, FLDAT, FBDTP, FUDTP, FLDTP, WBTYP, AKTBE, I_BELNR, I_POSNR, LEIND, LZEIT, ALIFNR, ABSMNG, ABSMEI, AMENGE, AMEINS, IA_SAMMELBEST, UPDKZ, BESKZ, SATKZ, AKTKZ, ABNKZ, EINDT, BESAB, BESBI, AINDT, ABGAB, ABGBI, AUSAB, AUSBI, LFDAT_AB, LFDAT_BI, UHRAB, UHRBI, DTIME, DHOUR, CD, FT, PA, CD_FT, CD_PA, KABE, BEBE, BRBE, OPTI, AVAIL, ROULE, STOCK, SAMKZ FROM WDFR_POS

TOP ERP 6.0 | WDFR_POS COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	FBELN	Perishables Planning Number	nvarchar	10	0	CHAR	(N' ')	No	WDFR_DISP	WDFR_FBELN	Allow NULL?
3	FPOSN	Item Number for Perishables Planning List	nvarchar	5	0	NUMC	(N'00000')	No		WDFR_FPOSN	Allow NULL?
4	FPOSB	Item Number for Procurement	nvarchar	5	0	NUMC	(N'00000')	No		WDFR_FPOSB	Allow NULL?
5	FPOSA	Item Number for the Goods Issue	nvarchar	5	0	NUMC	(N'00000')	No		WDFR_FPOSA	Allow NULL?
6	IBELN	Perishables Planning Number	nvarchar	10	0	CHAR	(N' ')	Yes		WDFR_FBELN	Allow NULL?
7	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	WERKS_D	Allow NULL?
8	DISPNR	Item number of inbound document buffer	nvarchar	5	0	NUMC	(N'00000')	Yes		WDFR_NUM5	Allow NULL?
9	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	MATNR	Allow NULL?
10	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	LIFNR	Allow NULL?
11	LOCNR	Customer Number for Plant	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	LOCNR	Allow NULL?
12	TABIX	Row Index of Internal Tables	int	10	0	INT4	((0))	Yes		SYTABIX	Allow NULL?
13	SELKZ	Selection flag	char	1	0	CHAR	(N' ')	Yes		SELKZ	Allow NULL?
14	IPOSN	Item Number for Perishables Planning List	nvarchar	5	0	NUMC	(N'00000')	Yes		WDFR_FPOSN	Allow NULL?
15	IPOSB	Item Number for Procurement	nvarchar	5	0	NUMC	(N'00000')	Yes		WDFR_FPOSB	Allow NULL?
16	IPOSA	Item Number for the Goods Issue	nvarchar	5	0	NUMC	(N'00000')	Yes		WDFR_FPOSA	Allow NULL?
17	LINPUTKZ	Input code for vendor number	char	1	0	CHAR	(N' ')	Yes		WDFR_LINPUTKZ	Allow NULL?
18	LIEFNR	Vendor number that can be filled as desired	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	WDFR_LIEFNR	Allow NULL?
19	LNAME1	Name	nvarchar	30	0	CHAR	(N' ')	Yes		NAME1	Allow NULL?
20	LORT01	City	nvarchar	25	0	CHAR	(N' ')	Yes		ORT01	Allow NULL?
21	FWERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
22	FNAME1	Name	nvarchar	30	0	CHAR	(N' ')	Yes		NAME1	Allow NULL?
23	FORT01	City	nvarchar	25	0	CHAR	(N' ')	Yes		ORT01	Allow NULL?
24	DEBNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KUNNR	Allow NULL?
25	FLOCNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KUNNR	Allow NULL?
26	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
27	VKORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	Yes	TVKO	VKORG	Allow NULL?
28	VTWEG	Distribution Channel	nvarchar	2	0	CHAR	(N' ')	Yes	TVTW	VTWEG	Allow NULL?
29	SPART	Division	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	SPART	Allow NULL?
30	LAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LAND1	Allow NULL?
31	MAKTX	Material Description (Short Text)	nvarchar	40	0	CHAR	(N' ')	Yes		MAKTX	Allow NULL?
32	EMATN	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	EMATNR	Allow NULL?
33	ATTYP	Material Category	nvarchar	2	0	CHAR	(N' ')	Yes		ATTYP	Allow NULL?
34	UEBPO	Higher-Level Item in Purchasing Documents	nvarchar	5	0	NUMC	(N'00000')	Yes	*	UEBPO	Allow NULL?
35	UPTYP	Subitem Category, Purchasing Document	char	1	0	CHAR	(N' ')	Yes	*	UPTYP	Allow NULL?
36	UPVOR	Subitems Exist	char	1	0	CHAR	(N' ')	Yes		UPVOR	Allow NULL?
37	KTMNG	Target Quantity	decimal	13	3	QUAN	((0))	Yes		KTMNG
38	MENGE	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
39	PLANM	Planned Quantity	decimal	13	3	QUAN	((0))	Yes		WDFR_PLANM
40	MEINS	Purchase Order Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BSTME	Allow NULL?
41	BPRME	Order Price Unit (Purchasing)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BBPRM	Allow NULL?
42	BPUMZ	Numerator for Conversion of Order Price Unit into Order Unit	decimal	5	0	DEC	((0))	Yes		BPUMZ
43	BPUMN	Denominator for Conv. of Order Price Unit into Order Unit	decimal	5	0	DEC	((0))	Yes		BPUMN
44	UMREZ	Numerator for Conversion of Order Unit to Base Unit	decimal	5	0	DEC	((0))	Yes		UMBSZ
45	UMREN	Denominator for Conversion of Order Unit to Base Unit	decimal	5	0	DEC	((0))	Yes		UMBSN
46	NETPR	Net Price in Purchasing Document (in Document Currency)	decimal	11	2	CURR	((0))	Yes		BPREI
47	PEINH	Price Unit	decimal	5	0	DEC	((0))	Yes		EPEIN
48	NETWR	Net Order Value in PO Currency	decimal	13	2	CURR	((0))	Yes		BWERT
49	BRTWR	Gross order value in PO currency	decimal	13	2	CURR	((0))	Yes		BBWERT
50	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
51	BMENGE	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
52	BMEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
53	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	EBELN	Allow NULL?
54	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	*	EBELP	Allow NULL?
55	LOEKZ	Deletion Indicator in Purchasing Document	char	1	0	CHAR	(N' ')	Yes		ELOEK	Allow NULL?
56	STATU	RFQ status	char	1	0	CHAR	(N' ')	Yes		ASTAT	Allow NULL?
57	AEDAT	Purchasing Document Item Change Date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAEDT	Allow NULL?
58	LGORT	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	*	LGORT_D	Allow NULL?
59	BEDNR	Requirement Tracking Number	nvarchar	10	0	CHAR	(N' ')	Yes		BEDNR	Allow NULL?
60	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	T023	MATKL	Allow NULL?
61	INFNR	Number of Purchasing Info Record	nvarchar	10	0	CHAR	(N' ')	Yes	*	INFNR	Allow NULL?
62	IDNLF	Material Number Used by Vendor	nvarchar	35	0	CHAR	(N' ')	Yes		IDNLF	Allow NULL?
63	AGDAT	Deadline for Submission of Bid/Quotation	nvarchar	8	0	DATS	(N'00000000')	Yes		ANGAB	Allow NULL?
64	WEBAZ	Goods Receipt Processing Time in Days	decimal	3	0	DEC	((0))	Yes		WEBAZ
65	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKZ	Allow NULL?
66	BONUS	Settlement Group 1 (Purchasing)	nvarchar	2	0	CHAR	(N' ')	Yes		EBONU	Allow NULL?
67	INSMK	Stock Type	char	1	0	CHAR	(N' ')	Yes		INSMK	Allow NULL?
68	SPINF	Indicator: Update Info Record	char	1	0	CHAR	(N' ')	Yes		SPINF	Allow NULL?
69	PRSDR	Price Printout	char	1	0	CHAR	(N' ')	Yes		PRSDR	Allow NULL?
70	SCHPR	Indicator: Estimated Price	char	1	0	CHAR	(N' ')	Yes		SCHPR	Allow NULL?
71	MAHNZ	Number of Reminders/Expediters	decimal	3	0	DEC	((0))	Yes		MAHNZ
72	MAHN1	Number of Days for First Reminder/Expediter	decimal	3	0	DEC	((0))	Yes		MAHN1
73	MAHN2	Number of Days for Second Reminder/Expediter	decimal	3	0	DEC	((0))	Yes		MAHN2
74	MAHN3	Number of Days for Third Reminder/Expediter	decimal	3	0	DEC	((0))	Yes		MAHN3
75	UEBTO	Overdelivery Tolerance Limit	decimal	3	1	DEC	((0))	Yes		UEBTO
76	UEBTK	Indicator: Unlimited Overdelivery Allowed	char	1	0	CHAR	(N' ')	Yes		UEBTK	Allow NULL?
77	UNTTO	Underdelivery Tolerance Limit	decimal	3	1	DEC	((0))	Yes		UNTTO
78	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	BWTAR_D	Allow NULL?
79	BWTTY	Valuation Category	char	1	0	CHAR	(N' ')	Yes	*	BWTTY_D	Allow NULL?
80	ABSKZ	Rejection Indicator	char	1	0	CHAR	(N' ')	Yes		ABSKZ	Allow NULL?
81	AGMEM	Internal Comment on Quotation	nvarchar	3	0	CHAR	(N' ')	Yes	*	AGMEM	Allow NULL?
82	ELIKZ	"Delivery Completed" Indicator	char	1	0	CHAR	(N' ')	Yes		ELIKZ	Allow NULL?
83	EREKZ	Final Invoice Indicator	char	1	0	CHAR	(N' ')	Yes		EREKZ	Allow NULL?
84	BSART	Purchasing Document Type	nvarchar	4	0	CHAR	(N' ')	Yes	T161	ESART	Allow NULL?
85	PSTYP	Item Category in Purchasing Document	char	1	0	CHAR	(N' ')	Yes	T163	PSTYP	Allow NULL?
86	KNTTP	Account Assignment Category	char	1	0	CHAR	(N' ')	Yes	T163K	KNTTP	Allow NULL?
87	KTMNG_ABG	Target Quantity	decimal	13	3	QUAN	((0))	Yes		KTMNG
88	BKTMNG_ABG	Target Quantity	decimal	13	3	QUAN	((0))	Yes		KTMNG
89	RANG	WDR: Ranking for Sorting	nvarchar	32	0	CHAR	(N' ')	Yes		WDFR_RANG	Allow NULL?
90	EKPNN	Sales Pricing: Purchase Price (Net/Net)	decimal	11	2	CURR	((0))	Yes		EKPNN
91	EKPGR	Purchase Price Calculation: (Basic Purchase Price)	decimal	11	2	CURR	((0))	Yes		EKPGR
92	EKPGR_K	Purchase Price Calculation: (Basic Purchase Price)	decimal	11	2	CURR	((0))	Yes		EKPGR
93	EKPGR_VME	Purchase Price Calculation: (Basic Purchase Price)	decimal	11	2	CURR	((0))	Yes		EKPGR
94	SPABA	Current margin (gross)	decimal	11	2	CURR	((0))	Yes		SPABA
95	SPANE	Margin (net) in sales price calculation	decimal	11	2	CURR	((0))	Yes		SPANE
96	SPANA	Current margin (net)	decimal	11	2	CURR	((0))	Yes		SPANA
97	ENDPA	Current Final Price	decimal	11	2	CURR	((0))	Yes		ENDPA
98	VKPNE	Sales price (net)	decimal	11	2	CURR	((0))	Yes		VKPNE
99	VRKME	Sales unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VRKME	Allow NULL?
100	HWAER	Local Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	HWAER	Allow NULL?
101	KWAER	Controlling area currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	KWAER	Allow NULL?
102	VWAER	Sales currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	VWAER	Allow NULL?
103	PROZ	Rate unit (currency, sales unit, or %)	nvarchar	5	0	CUKY	(N' ')	Yes		KOEIN	Allow NULL?
104	MENGE_BAS	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
105	UMSMNG_BAS	Quantity sold at POS in order units	decimal	15	3	QUAN	((0))	Yes		WDFR_UMSMNG
106	UAVMNG_BAS	Store orders in order units	decimal	15	3	QUAN	((0))	Yes		WDFR_UAVMNG
107	BVLMNG_BAS	Vendor orders in order units	decimal	15	3	QUAN	((0))	Yes		WDFR_BVLMNG
108	DIFMNG_BAS	Remaining Quantity in Order Units	decimal	15	3	QUAN	((0))	Yes		WDFR_DIFMNG
109	TEMMNG_BAS	Temporary PO Quantity	decimal	15	3	QUAN	((0))	Yes		WDFR_TEMMNG
110	LABST_BAS	Valuated Unrestricted-Use Stock	decimal	13	3	QUAN	((0))	Yes		LABST
111	ATPBST_BAS	ATP quantity (Available To Promise)	decimal	13	3	QUAN	((0))	Yes		ATPMN
112	BSTBDRF_BAS	ATP stock quantity (+/-)	decimal	15	3	QUAN	((0))	Yes		WDFR_BSTBDRF
113	BASME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
114	UMSMNG_ANZ	Quantity sold at POS in order units	decimal	15	3	QUAN	((0))	Yes		WDFR_UMSMNG
115	UAVMNG_ANZ	Store orders in order units	decimal	15	3	QUAN	((0))	Yes		WDFR_UAVMNG
116	BVLMNG_ANZ	Vendor orders in order units	decimal	15	3	QUAN	((0))	Yes		WDFR_BVLMNG
117	DIFMNG_ANZ	Remaining Quantity in Order Units	decimal	15	3	QUAN	((0))	Yes		WDFR_DIFMNG
118	TEMMNG_ANZ	Temporary PO Quantity	decimal	15	3	QUAN	((0))	Yes		WDFR_TEMMNG
119	LABST_ANZ	Valuated Unrestricted-Use Stock	decimal	13	3	QUAN	((0))	Yes		LABST
120	ATPBST_ANZ	ATP quantity (Available To Promise)	decimal	13	3	QUAN	((0))	Yes		ATPMN
121	BSTBDRF_ANZ	ATP stock quantity (+/-)	decimal	15	3	QUAN	((0))	Yes		WDFR_BSTBDRF
122	ANZME	Purchase Order Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BSTME	Allow NULL?
123	INDMN1	Individual Quantity	decimal	15	3	QUAN	((0))	Yes		WDFR_INDMNG
124	INDMN2	Individual Quantity	decimal	15	3	QUAN	((0))	Yes		WDFR_INDMNG
125	INDMN3	Individual Quantity	decimal	15	3	QUAN	((0))	Yes		WDFR_INDMNG
126	INDMN4	Individual Quantity	decimal	15	3	QUAN	((0))	Yes		WDFR_INDMNG
127	INDMN5	Individual Quantity	decimal	15	3	QUAN	((0))	Yes		WDFR_INDMNG
128	INDBAS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
129	INDMA1	Individual Quantity	decimal	15	3	QUAN	((0))	Yes		WDFR_INDMNG
130	INDMA2	Individual Quantity	decimal	15	3	QUAN	((0))	Yes		WDFR_INDMNG
131	INDMA3	Individual Quantity	decimal	15	3	QUAN	((0))	Yes		WDFR_INDMNG
132	INDMA4	Individual Quantity	decimal	15	3	QUAN	((0))	Yes		WDFR_INDMNG
133	INDMA5	Individual Quantity	decimal	15	3	QUAN	((0))	Yes		WDFR_INDMNG
134	INDANZ	Purchase Order Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BSTME	Allow NULL?
135	INDPR1	Price	decimal	11	2	CURR	((0))	Yes		PREIS
136	INDPR2	Price	decimal	11	2	CURR	((0))	Yes		PREIS
137	INDPR3	Price	decimal	11	2	CURR	((0))	Yes		PREIS
138	INDWA1	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
139	INDWA2	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
140	INDWA3	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
141	INDA08	Character String - 8 User-Defined Characters	nvarchar	8	0	CHAR	(N' ')	Yes		CHAR0008	Allow NULL?
142	INDA16	Character String - 16 User-Defined Characters	nvarchar	16	0	CHAR	(N' ')	Yes		CHAR0016	Allow NULL?
143	INDA32	Character String - 32 User-Defined Characters	nvarchar	32	0	CHAR	(N' ')	Yes		CHAR0032	Allow NULL?
144	INDA081	Character String - 8 User-Defined Characters	nvarchar	8	0	CHAR	(N' ')	Yes		CHAR0008	Allow NULL?
145	INDA161	Character String - 16 User-Defined Characters	nvarchar	16	0	CHAR	(N' ')	Yes		CHAR0016	Allow NULL?
146	INDA321	Character String - 32 User-Defined Characters	nvarchar	32	0	CHAR	(N' ')	Yes		CHAR0032	Allow NULL?
147	INDST1	Character String - 8 User-Defined Characters	nvarchar	8	0	CHAR	(N' ')	Yes		CHAR0008	Allow NULL?
148	INDST2	Character String - 8 User-Defined Characters	nvarchar	8	0	CHAR	(N' ')	Yes		CHAR0008	Allow NULL?
149	INDST3	Character String - 8 User-Defined Characters	nvarchar	8	0	CHAR	(N' ')	Yes		CHAR0008	Allow NULL?
150	INDST4	Character String - 8 User-Defined Characters	nvarchar	8	0	CHAR	(N' ')	Yes		CHAR0008	Allow NULL?
151	INDST5	Character String - 8 User-Defined Characters	nvarchar	8	0	CHAR	(N' ')	Yes		CHAR0008	Allow NULL?
152	LIWKZ	Individual, User-Defined Character	char	1	0	CHAR	(N' ')	Yes		CHAR0001	Allow NULL?
153	LMENGE_S	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
154	LWPRZ_S	Delivery phase in percent of total qty	nvarchar	3	0	NUMC	(N'000')	Yes		LWPRZ	Allow NULL?
155	BMENGE_S	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
156	MEINS_S	Purchase Order Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BSTME	Allow NULL?
157	BMEINS_S	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
158	LMENGE_1	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
159	LEIND_1	Item Delivery Date	nvarchar	8	0	DATS	(N'00000000')	Yes		EINDT	Allow NULL?
160	LZEIT_1	Time	nvarchar	6	0	TIMS	(N'000000')	Yes		UZEIT	Allow NULL?
161	LWPRZ_1	Delivery phase in percent of total qty	nvarchar	3	0	NUMC	(N'000')	Yes		LWPRZ	Allow NULL?
162	BMENGE_1	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
163	LMENGE_2	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
164	LEIND_2	Item Delivery Date	nvarchar	8	0	DATS	(N'00000000')	Yes		EINDT	Allow NULL?
165	LZEIT_2	Time	nvarchar	6	0	TIMS	(N'000000')	Yes		UZEIT	Allow NULL?
166	LWPRZ_2	Delivery phase in percent of total qty	nvarchar	3	0	NUMC	(N'000')	Yes		LWPRZ	Allow NULL?
167	BMENGE_2	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
168	LMENGE_3	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
169	LEIND_3	Item Delivery Date	nvarchar	8	0	DATS	(N'00000000')	Yes		EINDT	Allow NULL?
170	LZEIT_3	Time	nvarchar	6	0	TIMS	(N'000000')	Yes		UZEIT	Allow NULL?
171	LWPRZ_3	Delivery phase in percent of total qty	nvarchar	3	0	NUMC	(N'000')	Yes		LWPRZ	Allow NULL?
172	BMENGE_3	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
173	LMENGE_4	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
174	LEIND_4	Item Delivery Date	nvarchar	8	0	DATS	(N'00000000')	Yes		EINDT	Allow NULL?
175	LZEIT_4	Time	nvarchar	6	0	TIMS	(N'000000')	Yes		UZEIT	Allow NULL?
176	LWPRZ_4	Delivery phase in percent of total qty	nvarchar	3	0	NUMC	(N'000')	Yes		LWPRZ	Allow NULL?
177	BMENGE_4	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
178	LMENGE_5	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
179	LEIND_5	Item Delivery Date	nvarchar	8	0	DATS	(N'00000000')	Yes		EINDT	Allow NULL?
180	LZEIT_5	Time	nvarchar	6	0	TIMS	(N'000000')	Yes		UZEIT	Allow NULL?
181	LWPRZ_5	Delivery phase in percent of total qty	nvarchar	3	0	NUMC	(N'000')	Yes		LWPRZ	Allow NULL?
182	BMENGE_5	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
183	LMENGE_6	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
184	LEIND_6	Item Delivery Date	nvarchar	8	0	DATS	(N'00000000')	Yes		EINDT	Allow NULL?
185	LZEIT_6	Time	nvarchar	6	0	TIMS	(N'000000')	Yes		UZEIT	Allow NULL?
186	LWPRZ_6	Delivery phase in percent of total qty	nvarchar	3	0	NUMC	(N'000')	Yes		LWPRZ	Allow NULL?
187	BMENGE_6	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
188	LMENGE_7	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
189	LEIND_7	Item Delivery Date	nvarchar	8	0	DATS	(N'00000000')	Yes		EINDT	Allow NULL?
190	LZEIT_7	Time	nvarchar	6	0	TIMS	(N'000000')	Yes		UZEIT	Allow NULL?
191	LWPRZ_7	Delivery phase in percent of total qty	nvarchar	3	0	NUMC	(N'000')	Yes		LWPRZ	Allow NULL?
192	BMENGE_7	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
193	DISART	WDFR MRP procedure	nvarchar	2	0	CHAR	(N' ')	Yes		WDFR_DISART	Allow NULL?
194	ABGART	WDFR issue type	nvarchar	2	0	CHAR	(N' ')	Yes		WDFR_ABGART	Allow NULL?
195	AUFAR	Allocation Table Type	nvarchar	4	0	CHAR	(N' ')	Yes	T620	AUFAR	Allow NULL?
196	APSTP	Item category of allocation table	nvarchar	4	0	CHAR	(N' ')	Yes	T621	APSTP	Allow NULL?
197	SBELN	No. of allocation rule	nvarchar	10	0	CHAR	(N' ')	Yes	SVKO	SBELN	Allow NULL?
198	ASTRA	Allocation Strategy	nvarchar	4	0	CHAR	(N' ')	Yes	T627	ASTRA	Allow NULL?
199	ABELN	Allocation Table Number	nvarchar	10	0	CHAR	(N' ')	Yes	AUKO	ABELN	Allow NULL?
200	ABELP	Item number of allocation table	nvarchar	5	0	NUMC	(N'00000')	Yes	AUPO	ABELP	Allow NULL?
201	LISTG	Listing Indicator	char	1	0	CHAR	(N' ')	Yes		LISTG	Allow NULL?
202	RUNDG	Rounding off in allocation table	char	1	0	CHAR	(N' ')	Yes		RUNDG	Allow NULL?
203	RESTV	Split remainder	char	1	0	CHAR	(N' ')	Yes		RESTV	Allow NULL?
204	AAVIT	Notification Category Allocation: Info Exchance HQ - Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T626	AAVIT	Allow NULL?
205	BERMIMA	Include Minimum and Maximum Quantities	char	1	0	CHAR	(N' ')	Yes		BERMIMA	Allow NULL?
206	BSTGE	Goods recipient of vendor purchase order	char	1	0	CHAR	(N' ')	Yes		BSTGE	Allow NULL?
207	BEZCH	Description	nvarchar	40	0	CHAR	(N' ')	Yes		BEZEI40	Allow NULL?
208	AFDTP	External date type	char	1	0	CHAR	(N' ')	Yes	TPRG	PRGBZ	Allow NULL?
209	AFDAT	Confirmation request date	nvarchar	8	0	DATS	(N'00000000')	Yes		AFIDT	Allow NULL?
210	VKDTP	External date type	char	1	0	CHAR	(N' ')	Yes	TPRG	PRGBZ	Allow NULL?
211	VKDAT	Date of start of sales at plant	nvarchar	8	0	DATS	(N'00000000')	Yes		VKIDT	Allow NULL?
212	FBDAT	Release date of PO generation	nvarchar	8	0	DATS	(N'00000000')	Yes		FBIDT	Allow NULL?
213	FUDAT	Release date for generation of stock transfer	nvarchar	8	0	DATS	(N'00000000')	Yes		FUIDT	Allow NULL?
214	FLDAT	Release date for generation of delivery note	nvarchar	8	0	DATS	(N'00000000')	Yes		FLIDT	Allow NULL?
215	FBDTP	External date type	char	1	0	CHAR	(N' ')	Yes	*	PRGBZ	Allow NULL?
216	FUDTP	External date type	char	1	0	CHAR	(N' ')	Yes	*	PRGBZ	Allow NULL?
217	FLDTP	External date type	char	1	0	CHAR	(N' ')	Yes	*	PRGBZ	Allow NULL?
218	WBTYP	Default doc. category, store order inbound - replenishment	char	1	0	CHAR	(N' ')	Yes		VWWSBTYPVO	Allow NULL?
219	AKTBE	Promotion	nvarchar	10	0	CHAR	(N' ')	Yes	WAKH	WAKTION	Allow NULL?
220	I_BELNR	Document number of store order document buffer	nvarchar	10	0	CHAR	(N' ')	Yes	*	WGSREQN	Allow NULL?
221	I_POSNR	Item number of inbound document buffer	nvarchar	5	0	NUMC	(N'00000')	Yes	*	WGSREQP	Allow NULL?
222	LEIND	Delivery Date	nvarchar	10	0	CHAR	(N' ')	Yes		EEIND	Allow NULL?
223	LZEIT	Delivery Date Time-Spot	nvarchar	6	0	TIMS	(N'000000')	Yes		LZEIT	Allow NULL?
224	ALIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	LIFNR	Allow NULL?
225	ABSMNG	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
226	ABSMEI	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
227	AMENGE	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
228	AMEINS	Purchase Order Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BSTME	Allow NULL?
229	IA_SAMMELBEST	Individual, User-Defined Character	char	1	0	CHAR	(N' ')	Yes		CHAR0001	Allow NULL?
230	UPDKZ	Change Type (U, I, S, D)	char	1	0	CHAR	(N' ')	Yes		CDCHNGIND	Allow NULL?
231	BESKZ	Order indicator	char	1	0	CHAR	(N' ')	Yes		WDFR_BESKZ	Allow NULL?
232	SATKZ	Indicates generic material	nvarchar	2	0	CHAR	(N' ')	Yes		WDFR_SATKZ	Allow NULL?
233	AKTKZ	Individual, User-Defined Character	char	1	0	CHAR	(N' ')	Yes		CHAR0001	Allow NULL?
234	ABNKZ	Individual, User-Defined Character	char	1	0	CHAR	(N' ')	Yes		CHAR0001	Allow NULL?
235	EINDT	Delivery date of purchase order	nvarchar	8	0	DATS	(N'00000000')	Yes		WDFR_EINDT	Allow NULL?
236	BESAB	Procurement date	nvarchar	8	0	DATS	(N'00000000')	Yes		WDFR_BDAT	Allow NULL?
237	BESBI	Procurement date	nvarchar	8	0	DATS	(N'00000000')	Yes		WDFR_BDAT	Allow NULL?
238	AINDT	Inbound Delivery Date for PO	nvarchar	8	0	DATS	(N'00000000')	Yes		WDFR_AINDT	Allow NULL?
239	ABGAB	Issue date	nvarchar	8	0	DATS	(N'00000000')	Yes		WDFR_ABGDAT	Allow NULL?
240	ABGBI	Issue date	nvarchar	8	0	DATS	(N'00000000')	Yes		WDFR_ABGDAT	Allow NULL?
241	AUSAB	POS selling period	nvarchar	8	0	DATS	(N'00000000')	Yes		WDFR_AUSDAT	Allow NULL?
242	AUSBI	POS selling period	nvarchar	8	0	DATS	(N'00000000')	Yes		WDFR_AUSDAT	Allow NULL?
243	LFDAT_AB	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		FRMDATUM	Allow NULL?
244	LFDAT_BI	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		FRMDATUM	Allow NULL?
245	UHRAB	Procurement period: time	nvarchar	6	0	TIMS	(N'000000')	Yes		FRM_PROC_TIME	Allow NULL?
246	UHRBI	Procurement period: time	nvarchar	6	0	TIMS	(N'000000')	Yes		FRM_PROC_TIME	Allow NULL?
247	DTIME	Schedule-line interval (days)	smallint	5	0	INT2	((0))	Yes		FRM_LIEWR
248	DHOUR	Schedule-line interval (hours)	decimal	4	2	DEC	((0))	Yes		FRM_LIEWR_H
249	CD	Cross-docking	char	1	0	CHAR	(N' ')	Yes		WDFR_CD	Allow NULL?
250	FT	Flow-through	char	1	0	CHAR	(N' ')	Yes		WDFR_FT	Allow NULL?
251	PA	Putaway	char	1	0	CHAR	(N' ')	Yes		WDFR_PA	Allow NULL?
252	CD_FT	Cross-docking/flow-through	char	1	0	CHAR	(N' ')	Yes		WDFR_CD_FT	Allow NULL?
253	CD_PA	Cross-docking/putaway	char	1	0	CHAR	(N' ')	Yes		WDFR_CD_PA	Allow NULL?
254	KABE	Include sales orders	char	1	0	CHAR	(N' ')	Yes		WDFR_KABE	Allow NULL?
255	BEBE	Include purchase orders	char	1	0	CHAR	(N' ')	Yes		WDFR_BEBE	Allow NULL?
256	BRBE	Include backorders	char	1	0	CHAR	(N' ')	Yes		FRMTALL	Allow NULL?
257	OPTI	Order Optimizing	char	1	0	CHAR	(N' ')	Yes		FRMBEST	Allow NULL?
258	AVAIL	Check if merchandise already procured	char	1	0	CHAR	(N' ')	Yes		FRM_PR_CHECK	Allow NULL?
259	ROULE	Checking Rule for Availability Check	nvarchar	2	0	CHAR	(N' ')	Yes	T441R	PRREG	Allow NULL?
260	STOCK	Exclude stock from check	char	1	0	CHAR	(N' ')	Yes		FRM_IN_CHECK	Allow NULL?
261	SAMKZ	Mark item for collective purchase order	char	1	0	CHAR	(N' ')	Yes		WDFR_SAMKZ	Allow NULL?

TOP ERP 6.0 | WDFR_POS INDEXES

Name	Primary	Unique	Type	Columns
WDFR_POS~0	Yes	Yes	CLUSTERED	MANDT, FBELN, FPOSN, FPOSB, FPOSA

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

261 COLUMNS | 1 INDEXES | ERP 6.0 | WDFR_POS TABLE

TOP ERP 6.0 | WDFR_POS COLUMNS

TOP ERP 6.0 | WDFR_POS INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

261 COLUMNS | 1 INDEXES | ERP 6.0 | WDFR_POS TABLE

TOPERP 6.0 | WDFR_POS COLUMNS

TOPERP 6.0 | WDFR_POS INDEXES

TOP ERP 6.0 | WDFR_POS COLUMNS

TOP ERP 6.0 | WDFR_POS INDEXES