TMCW_AA_QRY SAP table for – MCCW_AA: Queries for Analytical Applications

Here we would like to draw your attention to TMCW_AA_QRY table in SAP. As we know it is being mainly used with the SAP LO-RIS (Retail Information System (RIS) in LO) component which is coming under LO module (Logistics). TMCW_AA_QRY is a SAP standard transparent table used for storing MCCW_AA: Queries for Analytical Applications related data in SAP. It comes under the package MCW_AA.

SAP TMCW_AA_QRY table

Table TMCW_AA_QRY technical data

TableTMCW_AA_QRY
Data storingMCCW_AA: Queries for Analytical Applications
ModuleLO
ComponentLO-RIS
SAP PackageMCW_AA
Delivery ClassC – Customer table, data is only maintained by the customer
Table CategoryTRANSPARENT

SAP TMCW_AA_QRY Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in TMCW_AA_QRY table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • RFCDEST : Logical Destination (Specified in Function Call)
    Its a key field. Its data type is C (Character String) with field length 10
  • QUERY
    Its a key field. Its data type is C (Character String) with field length 55