SAP ABAP Table WSOH_UEB (WSOH with a few extra fields)

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	WSOH_UEB	Table Relationship Diagram
Short Description	WSOH with a few extra 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	.INCLUDE	☐				0	0	Assortment Modules SAP Retail
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	SKOPF	☐	W_SORTK	WSORTK	CHAR	18	0	Assortment Module	*
4	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
5	DATUB	☐	DATBI	DATUM	DATS	8	0	Valid To Date
6	STYPB	☐	BAUSTYP	BAUSTYP	CHAR	1	0	Module type
7	LVORM	☐	WLOEK	WLOEK	CHAR	1	0	Deletion indicator IS-R tables
8	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
9	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
10	PFLKN	☐	W_PFLKN	PFLKS	CHAR	1	0	Assortment Priority	*
11	STAT1	☐	W_SSTAT	XFELD	CHAR	1	0	Status (active/inactive)
12	STAT2	☐	W_ASTAT	XFELD	CHAR	1	0	Status assignment promotion
13	STAT3	☐	W_ZSTAT	XFELD	CHAR	1	0	Status of assignment to assortments
14	DATAE	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
15	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
16	AKTIO	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
17	THEMA	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
18	FILIA	☐	W_SP_FIL	ASORT	CHAR	10	0	Assortment assignment (profile modules)	WRS1
19	WAGRP	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
20	LOKAL	☐	WLOKL	KUNNR	CHAR	10	0	Local assortment for a retail plant	KNA1
21	TYPIN	☐	W_TYPINT	FLAG	CHAR	1	0	Local module for the inclusion of (automat.) relistings
22	WKLOK	☐	WERKL	WERKS	CHAR	4	0	Retail plant with a local assortment module	T001W
23	WKWAG	☐	WERKF	WERKS	CHAR	4	0	Retail plant with profile module assignment	T001W
24	LIFNR	☐	W_RACKJOB	LIFNR	CHAR	10	0	Vendor number of a rack jobber	LFA1
25	RJPRO	☐	RJPRO	RJPRO	CHAR	1	0	Type of Rackjobber Processing
26	LAYGR	☐	LAYGR	LAYGR	CHAR	10	0	Layout Module	TWML
27	LAYMOD_VER	☐	LAYMOD_VER	LAYMOD_VER	NUMC	4	0	Layout Module Version	WLMV
28	CHANGEID	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
29	.INCLUDE	☐				0	0	Additional Fields for Data Transfer
30	TRANC	☐	TRANSCOUNT	NUMC10	NUMC	10	0	Transaction counter for data transfer
31	D_IND	☐	M_DELIND	NUMC10	NUMC	10	0	Which number within a transaction must be reset?
32	KZ_RES	☐	XFELD	XFELD	CHAR	1	0	Checkbox
33	CHANGENR	☐	CDCHANGENR	CDCHANGENR	CHAR	10	0	Document change number
34	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	*

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in