SAP ABAP Table S174BIW2 (S174BIW2 * Activities)
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 S174BIW2   Table Relationship Diagram
Short Description S174BIW2 * Activities    
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 SRVPOS ASNUM ASNUM CHAR 18   0   Activity Number ASMD
9 LIFNR ELIFN LIFNR CHAR 10   0   Vendor's account number LFA1
10 MATKL MATKL MATKL CHAR 9   0   Material Group T023
11 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
12 WERKS EWERK WERKS CHAR 4   0   Plant T001W
13 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
14 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
15 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
16 BASME S174MEINS MEINS UNIT 3   0   Base unit of measure T006
17 BSTWA BSTWA WAERS CUKY 5   0   Purchase order currency TCURC
18 HWAER HWAER WAERS CUKY 5   0   Local Currency TCURC
19 QUAN QUAN_PO MENGV15_3 QUAN 15   3   Purchase order quantity  
20 VAL VAL_PO WERTV8 CURR 15   2   Order value in document currency  
21 QUAN_ACC QUAN_ACC MENGV15_3 QUAN 15   3   Accepted quantity  
22 VAL_ACC VAL_ACC WERTV8 CURR 15   2   Accepted value in local currency  
23 VAL_ACCUP VAL_ACCUP WERTV8 CURR 15   2   Unplanned portion of accepted value  
24 VAL_ACCUP2 VAL_ACCUP2W WERTV8 CURR 15   2   Unplanned portion (w/o ref. to contract) of accepted value  
25 QUAN_IV QUAN_INV MENGV15_3 QUAN 15   3   Invoice receipt quantity  
26 VAL_IV VAL_INV WERTV8 CURR 15   2   Invoice value in local currency  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S174BIW2 BASME T006 MSEHI    
2 S174BIW2 BSTWA TCURC WAERS    
3 S174BIW2 EKORG T024E EKORG    
4 S174BIW2 HWAER TCURC WAERS    
5 S174BIW2 LIFNR LFA1 LIFNR    
6 S174BIW2 MANDT T000 MANDT    
7 S174BIW2 MATKL T023 MATKL    
8 S174BIW2 MEINS T006 MSEHI    
9 S174BIW2 SRVPOS ASMD ASNUM    
10 S174BIW2 WERKS T001W WERKS    
History
Last changed by/on SAP  20050411 
SAP Release Created in