SAP ABAP Table WRSZ (Assignment of assortment user to assortment)
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 WRSZ   Table Relationship Diagram
Short Description Assignment of assortment user to assortment    
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 ASORT ASORT ASORT CHAR 10   0   Assortment WRS1
3 LFDNR LFDNR5 NUMC5 NUMC 5   0   Sequence number  
4 LOCNR LOCNR KUNNR CHAR 10   0   Customer Number for Plant KNA1
5 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
6 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
7 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
8 SPART SPART SPART CHAR 2   0   Division TSPA
9 SONUT W_SONUT W_SONUT CHAR 1   0   Category of assortment user  
10 DATAB DATAB DATUM DATS 8   0   Valid-From Date  
11 DATBI DATBI DATUM DATS 8   0   Valid To Date  
12 RANGF W_S_RANGF W_S_RANGF CHAR 1   0   Ranking for assortment assignment  
13 LIGRD WLIGRD WLIGRD CHAR 1   0   Basic listing rule for assortments  
14 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
15 ERZET ERZET UZEIT TIMS 6   0   Entry time  
16 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
17 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
18 AEZET AEZET UZEIT TIMS 6   0   Time last change was made  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 WRSZ ASORT WRS1 ASORT 1 CN
2 WRSZ KUNNR KNA1 KUNNR 1 CN
3 WRSZ LOCNR KNA1 KUNNR 1 CN
4 WRSZ MANDT T000 MANDT 1 CN
5 WRSZ SPART TSPA SPART 1 CN
6 WRSZ VKORG TVKO VKORG 1 CN
7 WRSZ VTWEG TVTW VTWEG 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in