SAP Table TMCW_AA_QRY_DAT - MCCW_AA: Queries in Analytical Applications - Field Definit.

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
RFCDEST X MCW_AA_TARGET_SYS CHAR 3 10 0 Target System for Executing a Query
QUERY X MCW_AA_QUERY CHAR 13 55 0 TMCW_AA_QRY Query in Analytical Application
FLD_NR X MCW_AA_LFDNR NUMC 68 3 0 Field Sequence Number for a BW Query in OLTP
FLD_QUERY MCW_AA_FLD_OLAP CHAR 71 30 0 Query Field Name from OLAP System (BW)
FLD_FUNC MCW_AA_FLD_FUNCT CHAR 101 2 0 Function of a Query Field
FLD_SOURCE MCW_AA_FLD_OLTP CHAR 103 30 0 Query Field Name from OLTP System (R3)
FLD_DATATYPE DATATYPE_D CHAR 133 4 0 Data Type in ABAP Dictionary
FLD_LENGTH DDLENG NUMC 137 6 0 Length (No. of Characters)
FLD_SELTYPE MCW_AA_FLD_SELTYPE CHAR 143 1 0 Query Field Selection Type
FLD_SELENTRY MCW_AA_FLD_SELENTRY CHAR 144 1 0 Entry Type of a Query Field
FLD_TIMETYPE MCW_AA_FLD_TIMETYPE CHAR 145 2 0 Period Category of a Time Characteristic