SAP ABAP Table S451 (IS-M/SD: Sales Office Statistics)
Hierarchy
IS-M (Software Component) SAP MEDIA
   IS-M (Application Component) SAP Media
     JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
Basic Data
Table Category TRANSP    Transparent table 
Transparent table S451   Table Relationship Diagram
Short Description IS-M/SD: Sales Office Statistics    
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 VRSIO VRSIO VRSIO CHAR 3   0   Version number in the information structure *
4 SPMON SPMON MCPERIOD NUMC 6   0   Period to analyze - month  
5 SPTAG SPTAG DATUM DATS 8   0   Period to analyze - current date  
6 SPWOC SPWOC MCPERIOD NUMC 6   0   Period to analyze - week  
7 SPBUP SPBUP MCPERIOD NUMC 6   0   Period to analyze - posting period  
8 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVBUR
9 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVKGR
10 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
11 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
12 SPART SPART_AK SPART CHAR 2   0   Division for order header TSPA
13 DRERZ DRERZ DRERZ CHAR 8   0   Publication JDTDRER
14 PVA PVA PVA CHAR 8   0   Edition JDTPVA
15 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
16 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
17 ETMEINS ETMEINS MEINS UNIT 3   0   IS-M: Sales Unit for Sales Order T006
18 STWAE STWAE WAERS CUKY 5   0   Statistics currency TCURC
19 LFMNGAU JMC_LFMNGZ JMC_QUAN15 QUAN 15   0   Quantity delivered (for order schedule line)  
20 REMMENGE JMC_REMMNG JMC_MENGE QUAN 14   0   Quantity returned  
21 ANZREM JMC_ANZREM MCZAEHLER DEC 9   0   Number of returns  
22 ANZREMPOS JMC_ANZREP MCZAEHLER DEC 9   0   Number of return items  
23 REKMENGE JMC_REKMNG JMC_MENGE QUAN 14   0   Complaint quantity  
24 NLMENGE JMC_NLMENG JMC_MENGE QUAN 14   0   Subsequent delivery quantity  
25 BEZMENGE JMC_BEZOGM JMC_MENGE QUAN 14   0   Quantity purchased for complaint  
26 ANZREK JMC_ANZREK MCZAEHLER DEC 9   0   Number of complaints  
27 ANZREKPOS JMC_ANZRKP MCZAEHLER DEC 9   0   Number of complaint items  
28 UMNETWR MC_UMNETWR WERTV10 CURR 19   2   Net value of invoiced sales  
29 UMBRTWR JMC_UMBR WERTV10 CURR 19   2   Gross sales volume  
30 GUNETWR MC_GUNETWR WERTV10 CURR 19   2   Net value of credit memos  
31 GUBRTWR JMC_GUBR WERTV10 CURR 19   2   Gross credit memo value  
32 UMKZWI1 JMC_UMKZW1 WERTV9 CURR 17   2   Sales volume pricing subtotal 1  
33 UMKZWI2 JMC_UMKZW2 WERTV9 CURR 17   2   Sales volume pricing subtotal 2  
34 UMKZWI3 JMC_UMKZW3 WERTV9 CURR 17   2   Sales volume pricing subtotal  
35 UMKZWI4 JMC_UMKZW4 WERTV9 CURR 17   2   Sales volume pricing subtotal 4  
36 UMKZWI5 JMC_UMKZW5 WERTV9 CURR 17   2   Sales volume pricing subtotal 5  
37 UMKZWI6 JMC_UMKZW6 WERTV9 CURR 17   2   Sales volume pricing subtotal 6  
38 GUKZWI1 JMC_GUKZW1 WERTV9 CURR 17   2   Credit memo pricing subtotal 1  
39 GUKZWI2 JMC_GUKZW2 WERTV9 CURR 17   2   Credit memo pricing subtotal 2  
40 GUKZWI3 JMC_GUKZW3 WERTV9 CURR 17   2   Credit memo pricing subtotal 3  
41 GUKZWI4 JMC_GUKZW4 WERTV9 CURR 17   2   Credit memo pricing subtotal 4  
42 GUKZWI5 JMC_GUKZW5 WERTV9 CURR 17   2   Credit memo pricing subtotal 5  
43 GUKZWI6 JMC_GUKZW6 WERTV9 CURR 17   2   Credit memo pricing subtotal 6  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S451 DRERZ JDTDRER DRERZ    
2 S451 ETMEINS T006 MSEHI    
3 S451 MANDT T000 MANDT    
4 S451 PVA JDTPVA PVA    
5 S451 SPART TSPA SPART    
6 S451 STWAE TCURC WAERS    
7 S451 VKBUR TVBUR VKBUR    
8 S451 VKGRP TVKGR VKGRP    
9 S451 VKORG TVKO VKORG    
10 S451 VTWEG TVTW VTWEG    
History
Last changed by/on SAP  20050224 
SAP Release Created in