TMCW_AA_QRY_DAT - MCCW_AA: Queries in Analytical Applications - Field Definit.
MCCW_AA: Queries in Analytical Applications - Field Definit. information is stored in SAP table TMCW_AA_QRY_DAT.
It is part of development package MCW_AA in software component LO-RFM-BCT. This development package consists of objects that can be grouped under "Analytical Applications in Retail".
It is part of development package MCW_AA in software component LO-RFM-BCT. This development package consists of objects that can be grouped under "Analytical Applications in Retail".
Fields for table TMCW_AA_QRY_DAT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| RFCDEST | Target System for Executing a Query | X | MCW_AA_TARGET_SYS | CHAR | 20 | TMCW_AA_QRY |
| QUERY | Query in Analytical Application | X | MCW_AA_QUERY | CHAR | 110 | TMCW_AA_QRY |
| FLD_NR | Field Sequence Number for a BW Query in OLTP | X | MCW_AA_LFDNR | NUMC | 6 | |
| FLD_QUERY | Query Field Name from OLAP System (BW) | MCW_AA_FLD_OLAP | CHAR | 60 | ||
| FLD_FUNC | Function of a Query Field | MCW_AA_FLD_FUNCT | CHAR | 4 | ||
| FLD_SOURCE | Query Field Name from OLTP System (R3) | MCW_AA_FLD_OLTP | CHAR | 60 | ||
| FLD_DATATYPE | Data Type in ABAP Dictionary | DATATYPE_D | CHAR | 8 | ||
| FLD_LENGTH | Length (No. of Characters) | DDLENG | NUMC | 12 | ||
| FLD_SELTYPE | Query Field Selection Type | MCW_AA_FLD_SELTYPE | CHAR | 2 | ||
| FLD_SELENTRY | Entry Type of a Query Field | MCW_AA_FLD_SELENTRY | CHAR | 2 | ||
| FLD_TIMETYPE | Period Category of a Time Characteristic | MCW_AA_FLD_TIMETYPE | CHAR | 4 |