SAP ABAP Table WRF_APC_PASF_STY (Planned Material Screen Fields)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ LO-MD-RA (Application Component) Assortment
     ⤷ WRF_APC (Package) Operational Assortment Planning and Control

Basic Data

Table Category	INTTAB	Structure
Structure	WRF_APC_PASF_STY	Table Relationship Diagram
Short Description	Planned Material Screen Fields

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	MATNR	☑	WRF_PLNART	MATNR	CHAR	18	0	Planned Material Number	*
2	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
3	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
4	CHAR_PROF	☐	WRF_CHARPROF	KLASSE	CHAR	18	0	Characteristic Profile
5	HIER_ID	☐	WRF_HIER_CNT	WRF_HIERCNT	CHAR	2	0	Hierarchy	WRF_MATGRP_HIER
6	NODE_ID	☐	WRF_STRUC_NODE	WRF_NODES	CHAR	18	0	Hierarchy Node
7	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
8	ATTYP_T	☐	ATYPX	TEXT40	CHAR	40	0	Description of material category
9	REF_MATL	☐	REF_MATNR	MATNR	CHAR	18	0	Reference material	*
10	REF_MATL_DESC	☐	MAKTX	TEXT40	CHAR	40	0	Material description
11	REF_MATL_ATTYP_T	☐	ATYPX	TEXT40	CHAR	40	0	Description of material category
12	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
13	REL_FLAG	☐	WRF_APC_ARTREL_FLAG	WRF_APC_ARTREL_FLAG	CHAR	1	0	Planned Material: Release Flag
14	DEL_FLAG	☐	WRF_APC_ARTDEL_FLAG	XFELD	CHAR	1	0	Planned Material Deletion Flag (OAPC)
15	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
16	MATL_DESC	☐	MAKTX	TEXT40	CHAR	40	0	Material description
17	ESOKZ	☑	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
18	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
19	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
20	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
21	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
22	NETPR_VEN	☐	WRF_PRICE_VEN	WERTV6	CURR	11	2	Operational APC: Purchase Price in Vendor Currency
23	WAERS_VEN	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
24	NETPR_PURCH_PO	☐	WRF_PRICE_PO	WERTV6	CURR	11	2	Operational APC: Purchase Price Current PO Vendor Currency
25	WAERS_PURCH_PO	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
26	NETPR_PURCH	☐	WRF_PRICE_BASIC	WERTV6	CURR	11	2	Operational APC: Basic Purchase Price
27	WAERS_PURCH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
28	NETPR_SALES_DC	☐	WRF_SALES_PRICE	WERTV6	CURR	11	2	Operational APC: Sales Price
29	WAERS_SALES_DC	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
30	NETPR_SALES_STORE	☐	WRF_SALES_PRICE	WERTV6	CURR	11	2	Operational APC: Sales Price
31	WAERS_SALES_STORE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
32	MARKUP1	☐	WRF_MARKUP1	WRF_MARKUP	DEC	5	1	Markup 1: Basic Purchase Price - PP Net/Net
33	MARKUP2	☐	WRF_MARKUP2	WRF_MARKUP	DEC	5	1	Markup 2: PP Net/Net - Sales Price
34	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
35	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
36	VLFKZ	☑	VLFKZ	VLFKZ	CHAR	1	0	Plant category
37	VKPNE	☐	VKPNE	WERTV6	CURR	11	2	Sales price (net)
38	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC
39	AUFSG	☐	AUFSG	WERTV6	CURR	11	2	Actual Markup in Sales Price Calculation
40	UNIT	☑	LRMEI	MEINS	UNIT	3	0	Alternative Unit of Measure for Stockkeeping Unit	T006
41	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
42	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
43	EANNR	☐	EANNR	CHAR13	CHAR	13	0	European Article Number (EAN) - obsolete!!!!!
44	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
45	NUMTP	☐	NUMTP	NUMTP	CHAR	2	0	Category of International Article Number (EAN)	*
46	VARNR	☑	VATNR	MATNR	CHAR	18	0	Variant number	*
47	PRINBR	☐	PRINBR	PRINBR	CHAR	10	0	PRICAT: Unique internal catalog number	PRICAT_K001
48	EAN_UPC_BASE	☐	PRIEANBASIS	PRIEAN	CHAR	35	0	PRICAT: EAN/UPC Code of the Base Unit of Measure
49	VALIDITY_BASE	☐	PRIVALIDITY	DATUM	DATS	8	0	Price Catalog Inbound Start of Validity Period
50	EAN_UPC_TYPE	☐	PRIEANTYP	PRIEANTYP	CHAR	2	0	Type of material identification
51	PROFILE	☐	WRF_SSMPROF	WRF_SSMPROF	CHAR	10	0	Markdown Profile
52	FPRFM	☐	FPRFM	MPPRF	CHAR	3	0	Distribution profile of material in plant	TMFPF
53	PRICAT_FLAG	☐	WRF_APC_PRICAT_FLAG	XFELD	CHAR	1	0	Planned Material Originates from PRICAT (OAPC)
54	SALES_PRICE_DC_FIX	☐	WRF_SPDC_FIX	XFELD	CHAR	1	0	Sales Price Distribution Channel Fixed
55	PURCH_PRICE_FIX	☐	WRF_PP_FIX	XFELD	CHAR	1	0	Purchasing Price Fixed
56	SALES_PRICE_STORE_FIX	☐	WRF_SPST_FIX	XFELD	CHAR	1	0	Sales Price Store Fixed
57	MARKUP1_FIX	☐	WRF_MARKUP1_FIX	XFELD	CHAR	1	0	Markup 1 Fixed
58	MARKUP2_FIX	☐	WRF_MARKUP2_FIX	XFELD	CHAR	1	0	Markup 2 Fixed
59	VZWRK	☐	VZWRK	WERKS	CHAR	4	0	Distribution center as plant	T001W
60	FIWRK	☐	FIWRK	WERKS	CHAR	4	0	Store as plant	T001W
61	MAINFLG	☐	WRF_MAIN_FLAG	WRF_MAIN_FLAG	CHAR	1	0	Main Assignment
62	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
63	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year	TWSAI
64	COLOR	☐	WRF_COLOR	WRF_ATWRT	CHAR	18	0	Characteristic Value for Colors of Variants
65	SIZE1	☐	WRF_SIZE1	WRF_ATWRT	CHAR	18	0	Characteristic Value for Main Sizes of Variants
66	SIZE2	☐	WRF_SIZE2	WRF_ATWRT	CHAR	18	0	Characteristic Value for Second Size for Variants
67	NETNETPR	☐	WRF_PRICE_NET	WERTV6	CURR	11	2	Operational APC: Purchase Price Net/Net
68	KWAER	☐	KAWAER	WAERS	CUKY	5	0	Sales Pricing: Pricing Currency	TCURC
69	NETNETPR_FIX	☐	WRF_NETNETPR_FIX	XFELD	CHAR	1	0	Purchase Price Net/Net Fixed
70	CHAR1	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
71	CHAR2	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
72	CHAR3	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
73	MARKET_NO	☐	WRF_MARKETNO	WRF_MARKETNO	CHAR	10	0	Number for Market Buying
74	PPACT_NETPR	☐	WRF_PRICE_PPACT	WERTV6	CURR	11	2	Operational APC: Saved Purchasing Price Prepack
75	PPACT_WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
76	PPCALC_NETPR	☐	WRF_PRICE_PPCALC	WERTV6	CURR	11	2	Operational APC: Calculated Purchasing Price Prepack
77	PPCALC_WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
78	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
79	EX_R3MAT	☐	WRF_EX_R3MAT	XFELD	CHAR	1	0	Exclude Existing Materials
80	VEN_NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
81	VKORG_ACTUAL	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
82	VTWEG_ACTUAL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
83	PO_NETPR_OWN	☐	WRF_NPRPO_OWN	WERTV6	CURR	11	2	Operational APC: Purchase Price Current PO Own Currency
84	PO_WAERS_OWN	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
85	TEXT	☐	TEXT100	TEXT100	CHAR	100	0	Text (100 characters)
86	BSTAT	☐	WRFBSTAT	WRFBSTAT	CHAR	2	0	Creation Status - Seasonal Procurement	WRFMATBSTAT
87	DELTO_STATUS	☐	WRF_DELTO_STATUS	ICON	CHAR	4	0	Overdelivery tolerance - icon ( operational APC)	*
88	DELTO_VALUE	☐	WRF_DELTO_VALUE	DECV8	DEC	8	0	Overdelivery tolerance - value (operational APC)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WRF_APC_PASF_STY	BASE_UOM	T006	MSEHI
2	WRF_APC_PASF_STY	BSTAT	WRFMATBSTAT	BSTAT
3	WRF_APC_PASF_STY	EKGRP	T024	EKGRP
4	WRF_APC_PASF_STY	EKORG	T024E	EKORG
5	WRF_APC_PASF_STY	FIWRK	T001W	WERKS
6	WRF_APC_PASF_STY	FPRFM	TMFPF	FPRFM
7	WRF_APC_PASF_STY	HIER_ID	WRF_MATGRP_HIER	HIER_ID
8	WRF_APC_PASF_STY	KWAER	TCURC	WAERS
9	WRF_APC_PASF_STY	LIFNR	LFA1	LIFNR
10	WRF_APC_PASF_STY	MATKL	T023	MATKL
11	WRF_APC_PASF_STY	MTART	T134	MTART
12	WRF_APC_PASF_STY	PPACT_WAERS	TCURC	WAERS
13	WRF_APC_PASF_STY	PPCALC_WAERS	TCURC	WAERS
14	WRF_APC_PASF_STY	PRINBR	PRICAT_K001	PRINBR
15	WRF_APC_PASF_STY	SAISJ	TWSAI	KJAHR
16	WRF_APC_PASF_STY	SAISO	T6WSP	SAISO
17	WRF_APC_PASF_STY	SPRAS	T002	SPRAS
18	WRF_APC_PASF_STY	UNIT	T006	MSEHI
19	WRF_APC_PASF_STY	VKORG	TVKO	VKORG
20	WRF_APC_PASF_STY	VKORG_ACTUAL	TVKO	VKORG
21	WRF_APC_PASF_STY	VTWEG	TVTW	VTWEG
22	WRF_APC_PASF_STY	VTWEG_ACTUAL	TVTW	VTWEG
23	WRF_APC_PASF_STY	VWAER	TCURC	WAERS
24	WRF_APC_PASF_STY	VZWRK	T001W	WERKS
25	WRF_APC_PASF_STY	WAERS	TCURC	WAERS
26	WRF_APC_PASF_STY	WAERS_PURCH	TCURC	WAERS
27	WRF_APC_PASF_STY	WAERS_PURCH_PO	TCURC	WAERS
28	WRF_APC_PASF_STY	WAERS_SALES_DC	TCURC	WAERS
29	WRF_APC_PASF_STY	WAERS_SALES_STORE	TCURC	WAERS
30	WRF_APC_PASF_STY	WAERS_VEN	TCURC	WAERS

History

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