SAP ABAP Table S121 (Material aggregation - POS)
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 S121   Table Relationship Diagram
Short Description Material aggregation - POS    
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 MATKL MATKL MATKL CHAR 9   0   Material Group T023
9 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
10 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
11 AKTNR WAKTION WAKTION CHAR 10   0   Promotion WAKH
12 KSCHL V_KSCHA KSCHL CHAR 4   0   Condition type, sales T685
13 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
14 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
15 BASME MEINS MEINS UNIT 3   0   Base Unit of Measure T006
16 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
17 UMSMNG W_UMSMNG MENGV15_3 QUAN 15   3   Transaction sales - quantity in base unit of measure  
18 UMSGVP W_UMSVPM WERTV10 CURR 19   2   Retail price w/tax from sales as per receipts/aggreg.sales  
19 UMSGVO W_UMSVPO WERTV10 CURR 19   2   Rtl price from sales as per receipts/aggreg.sales  
20 UMSGEO W_UMSEP WERTV10 CURR 19   2   Sales transactions (till receipts) at cost  
21 PRSNLS W_PRSNL WERTV10 CURR 19   2   Price reduction  
22 PDIFF W_PDIFF WERTV10 CURR 19   2   Trnsctn price diff. between R/3 -> and sales price at POS  
23 BZIRK W_BEZIRK BZIRK CHAR 6   0   Sales district T171
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S121 AKTNR WAKH AKTNR    
2 S121 BASME T006 MSEHI    
3 S121 BZIRK T171 BZIRK 1 CN
4 S121 KSCHL T685 KSCHL C 1
5 S121 MANDT T000 MANDT    
6 S121 MATKL T023 MATKL    
7 S121 MATNR MARA MATNR    
8 S121 WAERK TCURC WAERS    
9 S121 WERKS T001W WERKS    
History
Last changed by/on SAP  20050411 
SAP Release Created in