SAP ABAP Table USRM3 (Material Master User Settings: Retail Organizational Levels)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MGW (Package) Application development R/3 material master Retail
Basic Data
Table Category TRANSP    Transparent table 
Transparent table USRM3   Table Relationship Diagram
Short Description Material Master User Settings: Retail Organizational Levels    
Delivery and Maintenance
Pool/cluster      
Delivery Class C   Customizing table, maintenance only by cust., not SAP import 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
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 UNAME USERN XUBNAME CHAR 12   0   User name USR02
3 BILDS BILDSQ BILDSQ CHAR 2   0   Screen Sequence Number T133S
4 MTART MTART MTART CHAR 4   0   Material type T134
5 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
6 LIFNR ELIFN LIFNR CHAR 10   0   Vendor's account number LFA1
7 LTSNR LTSNR LTSNR CHAR 6   0   Vendor Subrange WYT1
8 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
9 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
10 FIWRK FIWRK WERKS CHAR 4   0   Store as plant T001W
11 VZWRK VZWRK WERKS CHAR 4   0   Distribution center as plant T001W
12 ASCHL ASCHL XFELD CHAR 1   0   Indicator: org. levels/profiles only on request  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 USRM3 BILDS T133S BILDS 1 CN
2 USRM3 EKORG T024E EKORG C CN
3 USRM3 FIWRK T001W WERKS C CN
4 USRM3 LIFNR LFA1 LIFNR C CN
5 USRM3 LTSNR WYT1 LTSNR C CN
6 USRM3 MANDT T000 MANDT 1 CN
7 USRM3 MTART T134 MTART C CN
8 USRM3 UNAME USR02 BNAME    
9 USRM3 VKORG TVKO VKORG C CN
10 USRM3 VTWEG TVTW VTWEG C CN
11 USRM3 VZWRK T001W WERKS C CN
History
Last changed by/on SAP  20110901 
SAP Release Created in