SAP Table TMCW_AA_QRY_DAT
MCCW_AA: Queries in Analytical Applications - Field Definit.
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table TMCW_AA_QRY_DAT (MCCW_AA: Queries in Analytical Applications - Field Definit.) is a standard table in SAP ERP. It belongs to the package MCW_AA.
Technical Information
| Table | TMCW_AA_QRY_DAT |
| Short Text | MCCW_AA: Queries in Analytical Applications - Field Definit. |
| Package | MCW_AA |
| Table Type | Transparent Table |
Fields for Table TMCW_AA_QRY_DAT
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| RFCDEST | ✔ | Target System for Executing a Query | MCW_AA_TARGET_SYS | CHAR | 10 | TMCW_AA_QRY |
| QUERY | ✔ | Query in Analytical Application | MCW_AA_QUERY | CHAR | 55 | TMCW_AA_QRY |
| FLD_NR | ✔ | Field Sequence Number for a BW Query in OLTP | MCW_AA_LFDNR | NUMC | 3 | |
| FLD_QUERY | Query Field Name from OLAP System (BW) | MCW_AA_FLD_OLAP | CHAR | 30 | ||
| FLD_FUNC | Function of a Query Field | MCW_AA_FLD_FUNCT | CHAR | 2 | ||
| FLD_SOURCE | Query Field Name from OLTP System (R3) | MCW_AA_FLD_OLTP | CHAR | 30 | ||
| FLD_DATATYPE | Data Type in ABAP Dictionary | DATATYPE_D | CHAR | 4 | ||
| FLD_LENGTH | Length (No. of Characters) | DDLENG | NUMC | 6 | ||
| FLD_SELTYPE | Query Field Selection Type | MCW_AA_FLD_SELTYPE | CHAR | 1 | ||
| FLD_SELENTRY | Entry Type of a Query Field | MCW_AA_FLD_SELENTRY | CHAR | 1 | ||
| FLD_TIMETYPE | Period Category of a Time Characteristic | MCW_AA_FLD_TIMETYPE | CHAR | 2 |