SAP ABAP Table S119 (Transaction Number (Till Receipt))
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 S119   Table Relationship Diagram
Short Description Transaction Number (Till Receipt)    
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 SPTAG SPTAG DATUM DATS 8   0   Period to analyze - current date  
3 BONNR W_BONNR W_BONNR NUMC 15   0   Transaction number (till receipt)  
4 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
5 AFLAG MCW_AFLAG MCW_AFLAG NUMC 1   0   Promotion indicator  
6 KALWOC MCW_KALWOC NUM02 NUMC 2   0   Calendar week  
7 WOCHTG MCW_WOCHTG DAYS17 NUMC 1   0   Weekday  
8 TGZTKL MCW_TGZTKL MCW_TGZTKL CHAR 4   0   Time of day class TMCWW
9 VKSTD W_VKSTD W_VKSTD NUMC 2   0   Hour of sale  
10 VRSIO VRSIO VRSIO CHAR 3   0   Version number in the information structure *
11 SPMON SPMON MCPERIOD NUMC 6   0   Period to analyze - month  
12 SPWOC SPWOC MCPERIOD NUMC 6   0   Period to analyze - week  
13 SPBUP SPBUP MCPERIOD NUMC 6   0   Period to analyze - posting period  
14 SSOUR SSOUR SSOUR CHAR 4   0   Statistic(s) origin  
15 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
16 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
17 BASME MEINS MEINS UNIT 3   0   Base Unit of Measure T006
18 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
19 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
20 KUNDK W_KUNDK W_KUNDK CHAR 1   0   Customer ID  
21 KUNNR KUND1 KUNNR CHAR 10   0   Customer No. KNA1
22 CCNUM CCNUM CCNUM CHAR 25   0   Payment cards: Card number *
23 UMSMNG W_UMSMNG MENGV15_3 QUAN 15   3   Transaction sales - quantity in base unit of measure  
24 VKMNG W_VKMNG MENGV15_3 QUAN 15   3   Transaction sales - quantity in sales unit  
25 UMSATZ MCW_UMSATZ WERTV10 CURR 19   2   Sales POS  
26 WERTUM MCW_WERTUM WERTV10 CURR 19   2   Sales value POS (exact value)  
27 ANZBON MCW_ANZBON MCZAEHLINT INT4 10   0   Number of transactions (till receipts)  
28 ANZPOS MCW_ANZPOS MCZAEHLINT INT4 10   0   Number of transaction items (till receipts)  
29 ANZWGR MCW_ANZWGR MCZAEHLINT INT4 10   0   Number of material groups in transaction (till receipt)  
30 PRSNLS W_PRSNLS WERTV10 CURR 19   2   Price reduction from sales as per receipts/aggregated sales  
31 ANZAAR MCW_ANZAAR MCZAEHLINT INT4 10   0   Number of promotion items  
32 ANZBKK MCW_ANZBKK MCZAEHLINT INT4 10   0   Number of known customers  
33 ANZAKM MCW_ANZAKM MCZAEHLINT INT4 10   0   Number of anonymous customers (with payment card)  
34 ANZAKO MCW_ANZAKO MCZAEHLINT INT4 10   0   Number of anonymous customers  
35 UHZEIT MCW_UHZEIT UZEIT TIMS 6   0   Time sale was entered  
36 KMONAT MCW_MONAT AM_MONAT NUMC 2   0   Calendar month  
37 QUARTAL MCW_QUARTL NUM01 NUMC 1   0   Quarter  
38 JAHR MCJAHR GJAHR NUMC 4   0   Year  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S119 BASME T006 MSEHI    
2 S119 KUNNR KNA1 KUNNR    
3 S119 MANDT T000 MANDT KEY    
4 S119 TGZTKL TMCWW TGZTKL KEY    
5 S119 VRKME T006 MSEHI    
6 S119 WAERK TCURC WAERS    
7 S119 WERKS T001W WERKS KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in