SAP ABAP Table WDFR1 (Requirements Planning for Perishables)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-PUR (Application Component) Purchasing
     ⤷ WO+G (Package) Retail Development for Perishables

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	WDFR1	Table Relationship Diagram
Short Description	Requirements Planning for Perishables

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MARKFELD	☐	CHAR0001	CHAR0001	CHAR	1	0	Individual, User-Defined Character
3	BESTELLT	☐	CHAR0001	CHAR0001	CHAR	1	0	Individual, User-Defined Character
4	SATKZ	☐	CHAR0001	CHAR0001	CHAR	1	0	Individual, User-Defined Character
5	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
6	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
7	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
8	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
9	LNAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
10	UMSMNG	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
11	LABST	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
12	UAVMNG	☐	MCW_UAVMNG	MENGV15_3	QUAN	15	3	Stock transport order 2 (supplying site view), quantity
13	BVLMNG	☐	MCW_BVLMNG	MENGV15_3	QUAN	15	3	Order volume quantity Retail
14	DIFMNG	☐	MCW_BVLMNG	MENGV15_3	QUAN	15	3	Order volume quantity Retail
15	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
16	MENGE	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
17	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
18	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
19	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
20	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
21	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
22	WERKS	☐	EWERKS	WERKS	CHAR	4	0	Plant for individual capacity	T001W
23	FACTR	☐	BB_FACTR	CHAR6	CHAR	6	0	Conversion factor for order Un to sales Un for astmt. list
24	LOCNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
25	BBTYP	☐	BBTYP	BBTYP	CHAR	1	0	Assortment List Type	TWBB
26	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
27	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
28	KWAER	☐	KWAER	WAERS	CUKY	5	0	Controlling area currency	TCURC
29	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC
30	HWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC
31	VRKPE	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
32	EKPNN	☐	EKPNN	WERTV6	CURR	11	2	Sales Pricing: Purchase Price (Net/Net)
33	EKPGR	☐	EKPGR	WERTV6	CURR	11	2	Purchase Price Calculation: (Basic Purchase Price)
34	SPABA	☐	SPABA	WERTV6	CURR	11	2	Current margin (gross)
35	SPANE	☐	SPANE	WERTV6	CURR	11	2	Margin (net) in sales price calculation
36	ENDPA	☐	ENDPA	WERTV6	CURR	11	2	Current Final Price
37	VKPNE	☐	VKPNE	WERTV6	CURR	11	2	Sales price (net)
38	WBTYP	☐	VWWSBTYPVO	VWWSBTYPVO	CHAR	1	0	Default doc. category, store order inbound - replenishment
39	EKKAM	☐	EKKAM	DATUM	DATS	8	0	Key date for purchase price conditions
40	VKKAM	☐	VKKAM	DATUM	DATS	8	0	Key date for sales price conditions
41	BESAB	☐	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
42	BESBI	☐	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
43	PROAB	☐	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
44	PROBI	☐	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
45	SSTUF	☐	SSTUF	SSTUF	CHAR	2	0	Assortment grade	*
46	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
47	RELIF	☐	RELIF	XFELD	CHAR	1	0	Regular Vendor
48	SAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
49	KOEIN	☐	KOEIN	KOEIN	CUKY	5	0	Rate unit (currency, sales unit, or %)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WDFR1	BASME	T006	MSEHI
2	WDFR1	BBTYP	TWBB	BBTYP
3	WDFR1	EKGRP	T024	EKGRP
4	WDFR1	HWAER	TCURC	WAERS
5	WDFR1	KWAER	TCURC	WAERS
6	WDFR1	LOCNR	KNA1	KUNNR
7	WDFR1	MANDT	T000	MANDT
8	WDFR1	MEINS	T006	MSEHI
9	WDFR1	MWSKZ	T007A	MWSKZ
10	WDFR1	SATNR	MARA	MATNR
11	WDFR1	VRKME	T006	MSEHI
12	WDFR1	VWAER	TCURC	WAERS
13	WDFR1	WAERS	TCURC	WAERS
14	WDFR1	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in