TMCW_AA_QRY_DAT SAP table for – MCCW_AA: Queries in Analytical Applications – Field Definit.

Here we would like to draw your attention to TMCW_AA_QRY_DAT 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_DAT is a SAP standard transparent table used for storing MCCW_AA: Queries in Analytical Applications – Field Definit. related data in SAP. It comes under the package MCW_AA.

SAP TMCW_AA_QRY_DAT table

Table TMCW_AA_QRY_DAT technical data

TableTMCW_AA_QRY_DAT
Data storingMCCW_AA: Queries in Analytical Applications – Field Definit.
ModuleLO
ComponentLO-RIS
SAP PackageMCW_AA
Delivery ClassC – Customer table, data is only maintained by the customer
Table CategoryTRANSPARENT

SAP TMCW_AA_QRY_DAT 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_DAT table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • FLD_SELTYPE
    Its data type is C (Character String) with field length 1
  • FLD_SELENTRY
    Its data type is C (Character String) with field length 1
  • FLD_TIMETYPE
    Its data type is C (Character String) with field length 2
  • 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
  • FLD_NR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 3
  • FLD_QUERY
    Its data type is C (Character String) with field length 30
  • FLD_FUNC
    Its data type is C (Character String) with field length 2
  • FLD_SOURCE
    Its data type is C (Character String) with field length 30
  • FLD_DATATYPE
    Its data type is C (Character String) with field length 4
  • FLD_LENGTH
    Its data type is N (Character String with Digits Only) with field length 6