SAP ABAP Table S497E (S497 - Structural information)
Hierarchy
ECC-DIMP (Software Component) DIMP
   IS-HT-DRM (Application Component) Distributor-Reseller-Management
     DRM4 (Package) Development class for LIS structures
Basic Data
Table Category TRANSP    Transparent table 
Transparent table S497E   Table Relationship Diagram
Short Description S497 - 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 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number BUT000
4 ENDCUST END_CUST BU_PARTNER CHAR 10   0   Customer to whom distributor/ reseller made resale BUT000
5 SALES_ORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
6 DIST_CHNL VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
7 DIVN SPART SPART CHAR 2   0   Division TSPA
8 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
9 BASME MEINS MEINS UNIT 3   0   Base Unit of Measure T006
10 STWAE STWAE WAERS CUKY 5   0   Statistics currency TCURC
11 UBASME UMREFF FLTP FLTP 16   16   Conversion factor: quantities  
12 USTWAE UMREFF FLTP FLTP 16   16   Conversion factor: quantities  
13 PLOBJ PLOBJ CHAR18 CHAR 18   0   Planning object  
14 PERKZ PERVR PERVR CHAR 1   0   Period indicator  
15 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant T009
16 PLTKZ PLTKZ CHAR01 CHAR 1   0   Indicator: element used in planning  
17 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 S497E BASME T006 MSEHI    
2 S497E DIST_CHNL TVTW VTWEG KEY    
3 S497E DIVN TSPA SPART KEY    
4 S497E ENDCUST BUT000 PARTNER KEY    
5 S497E MANDT T000 MANDT KEY 1 CN
6 S497E MATNR MARA MATNR KEY    
7 S497E PARTNER BUT000 PARTNER KEY    
8 S497E PERIV T009 PERIV 1 CN
9 S497E SALES_ORG TVKO VKORG KEY    
10 S497E STWAE TCURC WAERS    
History
Last changed by/on SAP  20130529 
SAP Release Created in