SAP ABAP Table WRF1 (Plant data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WFIL (Package) IS-R: Store master

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	WRF1	Table Relationship Diagram
Short Description	Plant data

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LOCNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
3	EROED	☐	EROED	DATUM	DATS	8	0	Opening date
4	SCHLD	☐	SCHLD	DATUM	DATS	8	0	Closing date
5	SPDAB	☐	SPDAB	DATUM	DATS	8	0	Block from
6	SPDBI	☐	SPDBI	DATUM	DATS	8	0	Block to
7	AUTOB	☐	AUTOB	CHAR001	CHAR	1	0	Automatic purchase order
8	KOPRO	☐	POSKOPRO	POSKOPRO	CHAR	4	0	POS outbound profile	TWPFI
9	LAYVR	☐	LAYVAR	LAYVAR	CHAR	10	0	Layout	TWGV
10	FLVAR	☐	FLVAR	FLVAR	CHAR	4	0	Area schema	TWGF
11	STFAK	☐	STKAL	WFCID	CHAR	2	0	Calendar	TFACD
12	WANID	☐	WANID	WANID	CHAR	3	0	Goods receiving hours ID (default value)	TVWA
13	MOAB1	☐	WAMOAB1	UHRZT	TIMS	6	0	Goods receipt times: Monday morning from ...
14	MOBI1	☐	WAMOBI1	UHRZT	TIMS	6	0	Goods receiving hours: Monday morning until ...
15	MOAB2	☐	WAMOAB2	UHRZT	TIMS	6	0	Goods receiving hours: Monday afternoon from ...
16	MOBI2	☐	WAMOBI2	UHRZT	TIMS	6	0	Goods receiving hours: Monday afternoon until ...
17	DIAB1	☐	WADIAB1	UHRZT	TIMS	6	0	Goods receiving hours: Tuesday morning from...
18	DIBI1	☐	WADIBI1	UHRZT	TIMS	6	0	Goods receipt times: Tuesday morning until ...
19	DIAB2	☐	WADIAB2	UHRZT	TIMS	6	0	Goods receiving hours: Tuesday afternoon from ...
20	DIBI2	☐	WADIBI2	UHRZT	TIMS	6	0	Goods receiving hours: Tuesday afternoon until ...
21	MIAB1	☐	WAMIAB1	UHRZT	TIMS	6	0	Goods receiving hours: Wednesday morning from ...
22	MIBI1	☐	WAMIBI1	UHRZT	TIMS	6	0	Goods receiving hours: Wednesday morning until ...
23	MIAB2	☐	WAMIAB2	UHRZT	TIMS	6	0	Goods receiving hours: Wednesday afternoon from ...
24	MIBI2	☐	WAMIBI2	UHRZT	TIMS	6	0	Goods receiving hours: Wednesday afternoon until ...
25	DOAB1	☐	WADOAB1	UHRZT	TIMS	6	0	Goods receiving hours: Thursday morning from ...
26	DOBI1	☐	WADOBI1	UHRZT	TIMS	6	0	Goods receiving hours: Thursday morning until ...
27	DOAB2	☐	WADOAB2	UHRZT	TIMS	6	0	Goods receiving hours: Thursday afternoon from ...
28	DOBI2	☐	WADOBI2	UHRZT	TIMS	6	0	Goods receiving hours: Thursday afternoon until...
29	FRAB1	☐	WAFRAB1	UHRZT	TIMS	6	0	Goods receiving hours: Friday morning from ...
30	FRBI1	☐	WAFRBI1	UHRZT	TIMS	6	0	Goods receiving hours: Friday morning until ...
31	FRAB2	☐	WAFRAB2	UHRZT	TIMS	6	0	Goods receiving hours: Friday afternoon from ...
32	FRBI2	☐	WAFRBI2	UHRZT	TIMS	6	0	Goods receiving hours: Friday afternoon until ...
33	SAAB1	☐	WASAAB1	UHRZT	TIMS	6	0	Goods receiving hours: Saturday morning from ...
34	SABI1	☐	WASABI1	UHRZT	TIMS	6	0	Goods receiving hours: Saturday morning from ...
35	SAAB2	☐	WASAAB2	UHRZT	TIMS	6	0	Goods receiving hours: Saturday afternoon from ...
36	SABI2	☐	WASABI2	UHRZT	TIMS	6	0	Goods receiving hours: Saturday afternoon until ...
37	SOAB1	☐	WASOAB1	UHRZT	TIMS	6	0	Goods receiving hours: Sunday morning from ...
38	SOBI1	☐	WASOBI1	UHRZT	TIMS	6	0	Goods receiving hours: Sunday morning until ...
39	SOAB2	☐	WASOAB2	UHRZT	TIMS	6	0	Goods receiving hours: Sunday afternoon from ...
40	SOBI2	☐	WASOBI2	UHRZT	TIMS	6	0	Goods receiving hours: Sunday afternoon until ...
41	VERFL	☐	VERFL_WWS	VERFL_WWS	QUAN	6	0	Sales area (floor space)
42	VERFE	☐	VERFE_WWS	MEINS	UNIT	3	0	Sales area (floor space) unit	T006
43	SPGR1	☐	SPGR1	SPGR1	CHAR	2	0	Blocking reason	TWRF11
44	INPRO	☐	POSINTPROF	POSINTPROF	CHAR	4	0	POS inbound profile	TWPIS
45	EKOAR	☐	POSEKOAR	POSEKOAR	CHAR	4	0	POS outbound: condition type group	TWPPK
46	KZLIK	☐	KZLIK	XFELD	CHAR	1	0	Listing conditions should be created per assortment
47	BETRP	☐	BETRP	BETRP	CHAR	4	0	Plant profile	TWRF2
48	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
49	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
50	NLMATFB	☐	NLMATFB	NLMATFB	CHAR	1	0	ID: Carry out subsequent listing
51	BWWRK	☐	BWWRK	WERKS	CHAR	4	0	Plant for retail price determination	T001W
52	BWVKO	☐	BWVKO	VKORG	CHAR	4	0	Sales organization for retail price determination	TVKO
53	BWVTW	☐	BWVTW	VTWEG	CHAR	2	0	Distribution channel for retail price determination	TVTW
54	BBPRO	☐	BBPRO	BBPRO	CHAR	4	0	Assortment list profile	TWBP
55	VKBUR_WRK	☐	VKBUR_WRK	VKBUR	CHAR	4	0	Sales office	*
56	VLFKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
57	LSTFL	☐	LSTFL	LSTFL	CHAR	2	0	Listing procedure for store or other assortment categories	TWLV
58	LIGRD	☐	WLIGRD	WLIGRD	CHAR	1	0	Basic listing rule for assortments
59	VKORG	☐	VKOIV	VKORG	CHAR	4	0	Sales organization for intercompany billing	TVKO
60	VTWEG	☐	VTWIV	VTWEG	CHAR	2	0	Distribution channel for intercompany billing	TVTW
61	DESROI	☐	DESROI	DEC3_2	DEC	5	2	ROI required
62	TIMINC	☐	TIMINC	DEC5	DEC	5	0	Time increment for investement buying algorithm
63	POSWS	☐	POSWS	WAERS	CUKY	5	0	Currency of POS systems	TCURC
64	SSOPT_PRO	☐	SSOPT_PRO	SSOPT_PRO	CHAR	4	0	Space management profile	TWSSO
65	WBPRO	☐	WBPRO	WBPRO	CHAR	4	0	Profile for value-based inventory management	TWPR
66	.INCLU--AP	☐				0	0	APPEND Structure for Original Price and RMA Addt'l Fields
67	ORGPRICE	☐	E2WRF_ORGPRICES	E2WRF_ORGPRICES	CHAR	1	0	Retail: Original Price for Segment Definition E2WRF1M
68	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
69	RMA_PROF	☐	E2WRMA_PROF	E2WRMA_PROF	CHAR	4	0	Retail: RMA Profile for Segment Definition E2WRF1M
70	RMA_VKORG	☐	WCAT_VKORG	VKORG	CHAR	4	0	Cost allocation sales organization	TVKO
71	RMA_VTWEG	☐	WCAT_VTWEG	VTWEG	CHAR	2	0	Cost allocation distribution channel	TVTW

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WRF1	BBPRO	TWBP	BBPRO
2	WRF1	BETRP	TWRF2	BETRP
3	WRF1	BWVKO	TVKO	VKORG	KEY	1	CN
4	WRF1	BWVTW	TVTW	VTWEG	KEY	1	CN
5	WRF1	BWWRK	T001W	WERKS	KEY	1	CN
6	WRF1	EKOAR	TWPPK	EKOAR	KEY	1	CN
7	WRF1	FLVAR	TWGF	FLVAR	REF	C	CN
8	WRF1	INPRO	TWPIS	INPRO	KEY	1	CN
9	WRF1	KOPRO	TWPFI	KOPRO	KEY	1	CN
10	WRF1	LAYVR	TWGV	LAYVR	KEY	1	CN
11	WRF1	LOCNR	KNA1	KUNNR	KEY	1	CN
12	WRF1	LSTFL	TWLV	LSTFL
13	WRF1	MANDT	T000	MANDT	KEY	1	CN
14	WRF1	POSWS	TCURC	WAERS	REF	1	CN
15	WRF1	RMA_VKORG	TVKO	VKORG	KEY	1	CN
16	WRF1	RMA_VTWEG	TVTW	VTWEG	KEY	1	CN
17	WRF1	SPGR1	TWRF11	SPGR1	KEY	1	CN
18	WRF1	SSOPT_PRO	TWSSO	SSOPT_PRO	KEY	1	CN
19	WRF1	STFAK	TFACD	IDENT	KEY	1	CN
20	WRF1	VERFE	T006	MSEHI	KEY	1	CN
21	WRF1	VKORG	TVKO	VKORG	REF	1	CN
22	WRF1	VTWEG	TVTW	VTWEG	REF	C	CN
23	WRF1	WANID	TVWA	WANID	REF	C	CN
24	WRF1	WBPRO	TWPR	WBPRO	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in