SAP ABAP Table TMCW_AA_QRY_DAT (MCCW_AA: Queries in Analytical Applications - Field Definit.)
Hierarchy
☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-RIS (Application Component) Retail Information System (RIS)
     ⤷ MCW_AA (Package) Analytical Applications in Retail
Basic Data
Table Category TRANSP    Transparent table 
Transparent table TMCW_AA_QRY_DAT   Table Relationship Diagram
Short Description MCCW_AA: Queries in Analytical Applications - Field Definit.    
Delivery and Maintenance
Pool/cluster      
Delivery Class C   Customizing table, maintenance only by cust., not SAP import 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
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 RFCDEST MCW_AA_TARGET_SYS LOGSYS CHAR 10   0   Target System for Executing a Query TMCW_AA_QRY
3 QUERY MCW_AA_QUERY MCW_AA_QUERY_ID CHAR 55   0   Query in Analytical Application TMCW_AA_QRY
4 FLD_NR MCW_AA_LFDNR NUMC3 NUMC 3   0   Field Sequence Number for a BW Query in OLTP  
5 FLD_QUERY MCW_AA_FLD_OLAP RSIOBJNM CHAR 30   0   Query Field Name from OLAP System (BW)  
6 FLD_FUNC MCW_AA_FLD_FUNCT MCW_AA_FLD_FUNCTION CHAR 2   0   Function of a Query Field  
7 FLD_SOURCE MCW_AA_FLD_OLTP RSIOBJNM CHAR 30   0   Query Field Name from OLTP System (R3)  
8 FLD_DATATYPE DATATYPE_D DATATYPE CHAR 4   0   Data Type in ABAP Dictionary  
9 FLD_LENGTH DDLENG DDLENG NUMC 6   0   Length (No. of Characters)  
10 FLD_SELTYPE MCW_AA_FLD_SELTYPE MCW_AA_FLD_SELTYPE CHAR 1   0   Query Field Selection Type  
11 FLD_SELENTRY MCW_AA_FLD_SELENTRY MCW_AA_FLD_SELENTRY CHAR 1   0   Entry Type of a Query Field  
12 FLD_TIMETYPE MCW_AA_FLD_TIMETYPE MCW_AA_FLD_TIMETYPE CHAR 2   0   Period Category of a Time Characteristic  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TMCW_AA_QRY_DAT MANDT T000 MANDT KEY    
2 TMCW_AA_QRY_DAT QUERY TMCW_AA_QRY QUERY KEY    
3 TMCW_AA_QRY_DAT RFCDEST TMCW_AA_QRY RFCDEST KEY    
History
Last changed by/on SAP  20110901 
SAP Release Created in