SAP ABAP Table WINT_ALLAS (Central admin. structure for assortment <-> mat. maintenance)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	WINT_ALLAS	Table Relationship Diagram
Short Description	Central admin. structure for assortment <-> mat. maintenance

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	OK	☐	FLAG	FLAG	CHAR	1	0	General Flag
2	ACCEPT	☐	FLAG	FLAG	CHAR	1	0	General Flag
3	WCODE	☐	W_WCODE	CHAR1	CHAR	1	0	Main. code item transfer assortments -> int. mat. maint.
4	TO_CHECK	☐	FLAG	FLAG	CHAR	1	0	General Flag
5	TO_LIST	☐	FLAG	FLAG	CHAR	1	0	General Flag
6	TO_DELIST	☐	FLAG	FLAG	CHAR	1	0	General Flag
7	.INCLU-1	☐				0	0	Structure for the optical separation of complex structures
8	F1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
9	ASORT	☐	ASORT	ASORT	CHAR	10	0	Assortment	*
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
11	MATNR_EXTERN	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
12	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
13	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
14	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
15	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
16	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
17	DATAB_MAT	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
18	DATUB_MAT	☐	DATUB	DATUM	DATS	8	0	Valid-to date
19	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
20	DATUB	☐	DATUB	DATUM	DATS	8	0	Valid-to date
21	VAR_EQUAL	☐	FLAG	FLAG	CHAR	1	0	General Flag
22	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
23	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	*
24	BWSCL_N	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	*
25	KOMPO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
26	.INCLU-2	☐				0	0	Structure for the optical separation of complex structures
27	F2	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
28	IA_LIST_IN	☐	W_WCODE_IA	W_WCODE_IA	CHAR	1	0	Transfer code, Listing <-> Integrated Material Maintenance
29	LOCNR	☐	LOCNR	KUNNR	CHAR	10	0	Customer Number for Plant	*
30	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
31	SKOPF	☐	BAUSTEIN	WSORTK	CHAR	18	0	IS-R assortment module	*
32	SOTYP	☐	W_SOTYP	W_SOTYP	CHAR	1	0	Assortment Category
33	SONUT	☐	W_SONUT	W_SONUT	CHAR	1	0	Category of assortment user
34	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
35	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
36	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
37	VKORG_ASS	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
38	VTWEG_ASS	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
39	LSTUF	☐	W_LSTUFE	W_LSTUFE	CHAR	1	0	Del. lev, warehouse proc.
40	LIFWK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
41	LIFSO	☐	ASORT	ASORT	CHAR	10	0	Assortment	*
42	BWSCL_EXTERN	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	*
43	ZUSER	☐	W_Z_USER	NUMC5	NUMC	5	0	Number of assortment users per assortment
44	ZUSER_CUST	☐	W_Z_USER	NUMC5	NUMC	5	0	Number of assortment users per assortment
45	VLFKZ	☐	W_SONUT	W_SONUT	CHAR	1	0	Category of assortment user
46	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
47	.INCLU-3	☐				0	0	Structure for the optical separation of complex structures
48	F3	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
49	ASS_CODE	☐	W_ASSCODE	CHAR1	CHAR	1	0	Assignment code interface assortment->integrated mat. main.
50	TIME_CODE	☐	W_TIMECODE	CHAR1	CHAR	1	0	Time assignment code, interface astmts -> int. mat. maint.
51	LIST_EXC	☐	LIST_EXC	CHAR1	CHAR	1	0	Listing information / errors
52	LSTFL	☐	LSTVF	LSTFL	CHAR	2	0	Listing procedure	*
53	SSTUF	☐	SSTUF	SSTUF	CHAR	2	0	Assortment grade	*
54	PFLKN	☐	PFLKS	PFLKS	CHAR	1	0	External assortment priority	*
55	ERRNR	☐	MSGNR	MSGNR	CHAR	3	0	Message number	*
56	MARC_MUST	☐	XFELD	XFELD	CHAR	1	0	Checkbox
57	WLK1_MUST	☐	XFELD	XFELD	CHAR	1	0	Checkbox
58	WLK2_MUST	☐	XFELD	XFELD	CHAR	1	0	Checkbox
59	MBEW_MUST	☐	XFELD	XFELD	CHAR	1	0	Checkbox
60	MVKE_MUST	☐	XFELD	XFELD	CHAR	1	0	Checkbox
61	SEGMENTS	☐	XFELD	XFELD	CHAR	1	0	Checkbox
62	M_VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
63	M_VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
64	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
65	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
66	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
67	BWTAR2	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
68	BWTAR3	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
69	BWT_CHECKD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
70	MANSEL_VOR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
71	MANSEL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
72	SKOPF_SELECT	☐	W_SORTK	WSORTK	CHAR	18	0	Assortment Module	*
73	SKOPF_DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
74	SKOPF_DATUB	☐	DATUB	DATUM	DATS	8	0	Valid-to date
75	SKOPF_STAT2	☐	W_FSTAT	FLAG	CHAR	1	0	Status of assortment owner assignment
76	SKOPF_NUMBERS	☐	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
77	SKOPF_PROFIL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
78	.INCLU-4	☐				0	0	Structure for the optical separation of complex structures
79	F4	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
80	LISTED	☐	W_LISTED	XFELD	CHAR	1	0	Material already listed in assortment
81	FILIA_WLKA	☑	ASORT	ASORT	CHAR	10	0	Assortment	*
82	ARTNR_WLKA	☑	MATNR	MATNR	CHAR	18	0	Material Number	*
83	VRKME_WLKA	☑	VRKME	MEINS	UNIT	3	0	Sales unit	*
84	DATBI_WLKA	☑	DATBI	DATUM	DATS	8	0	Valid To Date
85	LFDNR_WLKA	☑	LFDN3	NUMC3	NUMC	3	0	Sequence number
86	DATAB_WLKA	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
87	URSAC_WLKA	☐	W_URSAC_BS	WSORTK	CHAR	18	0	Module that has caused the listing	*
88	QUELL_WLKA	☐	W_URSAC_LI	W_URSAC_LI	CHAR	1	0	Listing source (transaction / function environment)
89	PFLKN_WLKA	☐	W_PFLKN	PFLKS	CHAR	1	0	Assortment Priority	*
90	ANZAL_WLKA	☐	W_BAU_ZAHL	NUMC3	NUMC	3	0	- obsolete - No. of modules that have resulted in listing
91	DATAE_WLKA	☐	DATAE	DATUM	DATS	8	0	Date of last change
92	NEGAT_WLKA	☐	W_NEG_SORT	FLAG	CHAR	1	0	Negation of assortment item or materials
93	AKTIO_WLKA	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
94	THEMA_WLKA	☐	WAKT_THEMA	THEMA	CHAR	4	0	Promotion theme IS-R	*
95	STRLI_WLKA	☐	W_STRULI	W_STRULI	CHAR	1	0	List as component of a structured material
96	SSTAT_WLKA	☐	W_SORTSTAT	W_SORTSTAT	CHAR	1	0	Assortment status
97	LIFNR_WLKA	☐	W_RACKJOB	LIFNR	CHAR	10	0	Vendor number of a rack jobber	*
98	DATE_SHARE	☐	FLAG	FLAG	CHAR	1	0	General Flag
99	.INCLU-5	☐				0	0	Structure for the optical separation of complex structures
100	F5	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
101	FILIA_WLKN	☑	ASORT	ASORT	CHAR	10	0	Assortment	*
102	ARTNR_WLKN	☑	MATNR	MATNR	CHAR	18	0	Material Number	*
103	VRKME_WLKN	☑	VRKME	MEINS	UNIT	3	0	Sales unit	*
104	DATBI_WLKN	☑	DATBI	DATUM	DATS	8	0	Valid To Date
105	LFDNR_WLKN	☑	LFDN3	NUMC3	NUMC	3	0	Sequence number
106	DATAB_WLKN	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
107	URSAC_WLKN	☐	W_URSAC_BS	WSORTK	CHAR	18	0	Module that has caused the listing	*
108	QUELL_WLKN	☐	W_URSAC_LI	W_URSAC_LI	CHAR	1	0	Listing source (transaction / function environment)
109	PFLKN_WLKN	☐	W_PFLKN	PFLKS	CHAR	1	0	Assortment Priority	*
110	ANZAL_WLKN	☐	W_BAU_ZAHL	NUMC3	NUMC	3	0	- obsolete - No. of modules that have resulted in listing
111	DATAE_WLKN	☐	DATAE	DATUM	DATS	8	0	Date of last change
112	NEGAT_WLKN	☐	W_NEG_SORT	FLAG	CHAR	1	0	Negation of assortment item or materials
113	AKTIO_WLKN	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
114	THEMA_WLKN	☐	WAKT_THEMA	THEMA	CHAR	4	0	Promotion theme IS-R	*
115	STRLI_WLKN	☐	W_STRULI	W_STRULI	CHAR	1	0	List as component of a structured material
116	SSTAT_WLKN	☐	W_SORTSTAT	W_SORTSTAT	CHAR	1	0	Assortment status
117	LIFNR_WLKN	☐	W_RACKJOB	LIFNR	CHAR	10	0	Vendor number of a rack jobber	*
118	.INCLU-6	☐				0	0	Structure for the optical separation of complex structures
119	F6	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
120	PFLKN_SL	☐	W_PFLKN	PFLKS	CHAR	1	0	Assortment Priority	*
121	SSTUF_SL	☐	SSTUF	SSTUF	CHAR	2	0	Assortment grade	*
122	LSTFL_SL	☐	LSTFL	LSTFL	CHAR	2	0	Listing procedure for store or other assortment categories	*
123	LSTVZ_SL	☐	LSTVZ	LSTFL	CHAR	2	0	Listing procedure for distr. center assortment categories	*
124	STAT1_SL	☐	W_SSTAT	XFELD	CHAR	1	0	Status (active/inactive)
125	DAB_SH	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
126	DUB_SH	☐	DATBI	DATUM	DATS	8	0	Valid To Date
127	DAB_DC	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
128	DUB_DC	☐	DATUB	DATUM	DATS	8	0	Valid-to date
129	PF_NEW	☐	W_PFLKN	PFLKS	CHAR	1	0	Assortment Priority	*
130	SS_NEW	☐	SSTUF	SSTUF	CHAR	2	0	Assortment grade	*
131	LF_NEW	☐	LSTFL	LSTFL	CHAR	2	0	Listing procedure for store or other assortment categories	*
132	LV_NEW	☐	LSTVZ	LSTFL	CHAR	2	0	Listing procedure for distr. center assortment categories	*
133	ST_NEW	☐	W_SSTAT	XFELD	CHAR	1	0	Status (active/inactive)
134	DAB_SH_N	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
135	DUB_SH_N	☐	DATUB	DATUM	DATS	8	0	Valid-to date
136	DAB_DC_N	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
137	DUB_DC_N	☐	DATUB	DATUM	DATS	8	0	Valid-to date
138	MANPF	☐	FLAG	FLAG	CHAR	1	0	General Flag
139	SSTAT_N	☐	W_SORTSTAT	W_SORTSTAT	CHAR	1	0	Assortment status
140	.INCLU-7	☐				0	0	Structure for the optical separation of complex structures
141	F7	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
142	SDLINE_NEW	☐	XFELD	XFELD	CHAR	1	0	Checkbox
143	Q_SSTAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
144	Q_LSTFL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
145	Q_LSTVZ	☐	XFELD	XFELD	CHAR	1	0	Checkbox
146	Q_SSTUF	☐	XFELD	XFELD	CHAR	1	0	Checkbox
147	Q_PRIO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
148	Q_DATUM_FIL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
149	Q_DATUM_VZ	☐	XFELD	XFELD	CHAR	1	0	Checkbox
150	Q_ABWEICH	☐	XFELD	XFELD	CHAR	1	0	Checkbox
151	.INCLU-8	☐				0	0	Structure for the optical separation of complex structures
152	F8	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
153	VARIA_NEW	☐	XFELD	XFELD	CHAR	1	0	Checkbox
154	Q_BWSCL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
155	Q_CLASS	☐	XFELD	XFELD	CHAR	1	0	Checkbox
156	Q_LTIME	☐	XFELD	XFELD	CHAR	1	0	Checkbox
157	Q_LAYOUT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
158	.INCLU-9	☐				0	0	Structure for the optical separation of complex structures
159	F9	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
160	C_RESERV1	☐	FLAG	FLAG	CHAR	1	0	General Flag
161	C_RESERV2	☐	FLAG	FLAG	CHAR	1	0	General Flag

History

Last changed by/on	SAP	20130529
SAP Release Created in