SAP ABAP Table S117E (S117 - Structural Information)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
Basic Data
Table Category TRANSP    Transparent table 
Transparent table S117E   Table Relationship Diagram
Short Description S117 - Structural Information    
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 SSOUR SSOUR SSOUR CHAR 4   0   Statistic(s) origin  
3 BONNR W_BONNR W_BONNR NUMC 15   0   Transaction number (till receipt)  
4 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
5 MATKL MATKL MATKL CHAR 9   0   Material Group T023
6 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
7 AFLAG MCW_AFLAG MCW_AFLAG NUMC 1   0   Promotion indicator  
8 KALWOC MCW_KALWOC NUM02 NUMC 2   0   Calendar week  
9 WOCHTG MCW_WOCHTG DAYS17 NUMC 1   0   Weekday  
10 TGZTKL MCW_TGZTKL MCW_TGZTKL CHAR 4   0   Time of day class TMCWW
11 VKSTD W_VKSTD W_VKSTD NUMC 2   0   Hour of sale  
12 BASME MEINS MEINS UNIT 3   0   Base Unit of Measure T006
13 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
14 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
15 UBASME UMREFF FLTP FLTP 16   16   Conversion factor: quantities  
16 UVRKME UMREFF FLTP FLTP 16   16   Conversion factor: quantities  
17 UWAERK UMREFF FLTP FLTP 16   16   Conversion factor: quantities  
18 PLOBJ PLOBJ CHAR18 CHAR 18   0   Planning object  
19 PERKZ PERVR PERVR CHAR 1   0   Period indicator  
20 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant T009
21 PLTKZ PLTKZ CHAR01 CHAR 1   0   Indicator: element used in planning  
22 ANTEI DANTEF FLTP FLTP 16   16   Proportional factor (%) for disaggregation of product group  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S117E BASME T006 MSEHI    
2 S117E MANDT T000 MANDT KEY 1 CN
3 S117E MATKL T023 MATKL KEY    
4 S117E MATNR MARA MATNR KEY    
5 S117E PERIV T009 PERIV 1 CN
6 S117E TGZTKL TMCWW TGZTKL KEY    
7 S117E VRKME T006 MSEHI    
8 S117E WAERK TCURC WAERS    
9 S117E WERKS T001W WERKS KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in