SAP Table TMCW_AA_QRY_DAT

MCCW_AA: Queries in Analytical Applications - Field Definit.

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