SAP ABAP Table WSOH (Assortment Modules SAP Retail)

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	TRANSP	Transparent table
Transparent table	WSOH	Table Relationship Diagram
Short Description	Assortment Modules SAP Retail

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	SKOPF	☑	W_SORTK	WSORTK	CHAR	18	0	Assortment Module
3	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
4	DATUB	☐	DATBI	DATUM	DATS	8	0	Valid To Date
5	STYPB	☐	BAUSTYP	BAUSTYP	CHAR	1	0	Module type
6	LVORM	☐	WLOEK	WLOEK	CHAR	1	0	Deletion indicator IS-R tables
7	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	PFLKN	☐	W_PFLKN	PFLKS	CHAR	1	0	Assortment Priority	*
10	STAT1	☐	W_SSTAT	XFELD	CHAR	1	0	Status (active/inactive)
11	STAT2	☐	W_ASTAT	XFELD	CHAR	1	0	Status assignment promotion
12	STAT3	☐	W_ZSTAT	XFELD	CHAR	1	0	Status of assignment to assortments
13	DATAE	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	AKTIO	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
16	THEMA	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
17	FILIA	☐	W_SP_FIL	ASORT	CHAR	10	0	Assortment assignment (profile modules)	WRS1
18	WAGRP	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
19	LOKAL	☐	WLOKL	KUNNR	CHAR	10	0	Local assortment for a retail plant	KNA1
20	TYPIN	☐	W_TYPINT	FLAG	CHAR	1	0	Local module for the inclusion of (automat.) relistings
21	WKLOK	☐	WERKL	WERKS	CHAR	4	0	Retail plant with a local assortment module	T001W
22	WKWAG	☐	WERKF	WERKS	CHAR	4	0	Retail plant with profile module assignment	T001W
23	LIFNR	☐	W_RACKJOB	LIFNR	CHAR	10	0	Vendor number of a rack jobber	LFA1
24	RJPRO	☐	RJPRO	RJPRO	CHAR	1	0	Type of Rackjobber Processing
25	LAYGR	☐	LAYGR	LAYGR	CHAR	10	0	Layout Module	TWML
26	LAYMOD_VER	☐	LAYMOD_VER	LAYMOD_VER	NUMC	4	0	Layout Module Version	WLMV

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WSOH	AKTIO	WAKH	AKTNR	KEY	1	CN
2	WSOH	FILIA	WRS1	ASORT		1	CN
3	WSOH	LAYGR	TWML	LAYGR
4	WSOH	LAYMOD_VER	WLMV	LAYMOD_VER
5	WSOH	LIFNR	LFA1	LIFNR		1	CN
6	WSOH	LOKAL	KNA1	KUNNR	KEY	1	CN
7	WSOH	MANDT	T000	MANDT	KEY	1	CN
8	WSOH	THEMA	TWAT	AKTHE	KEY	1	CN
9	WSOH	WAGRP	T023	MATKL	KEY	1	CN
10	WSOH	WKLOK	T001W	WERKS	KEY	1	CN
11	WSOH	WKWAG	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in