SAP ABAP View VMCW_AA_QRYFLD (Maintain Query Components for Analytical Applications)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-RIS (Application Component) Retail Information System (RIS)
     ⤷ MCW_AA (Package) Analytical Applications in Retail

Basic Data

View Type	C	Maintenance View
Maintenance View	VMCW_AA_QRYFLD
Short Description	Maintain Query Components for Analytical Applications
Root table	TMCW_AA_QRY_DAT	MCCW_AA: Queries in Analytical Applications - Field Definit.

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TMCW_AA_QRY_DAT	TMCW_AA_QRY_DAT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TMCW_AA_QRY_DAT	MANDT		☐	MANDT	☐	Client
2	RFCDEST	TMCW_AA_QRY_DAT	RFCDEST		☐	MCW_AA_TARGET_SYS	☐	Target System for Executing a Query
3	QUERY	TMCW_AA_QRY_DAT	QUERY		☐	MCW_AA_QUERY	☐	Query in Analytical Application
4	FLD_NR	TMCW_AA_QRY_DAT	FLD_NR		☐	MCW_AA_LFDNR	☐	Field Sequence Number for a BW Query in OLTP
5	FLD_QUERY	TMCW_AA_QRY_DAT	FLD_QUERY		☐	MCW_AA_FLD_OLAP	☐	Query Field Name from OLAP System (BW)
6	FLD_FUNC	TMCW_AA_QRY_DAT	FLD_FUNC		☐	MCW_AA_FLD_FUNCT	☐	Function of a Query Field
7	FLD_SOURCE	TMCW_AA_QRY_DAT	FLD_SOURCE		☐	MCW_AA_FLD_OLTP	☐	Query Field Name from OLTP System (R3)
8	FLD_DATATYPE	TMCW_AA_QRY_DAT	FLD_DATATYPE		☐	DATATYPE_D	☐	Data Type in ABAP Dictionary
9	FLD_LENGTH	TMCW_AA_QRY_DAT	FLD_LENGTH		☐	DDLENG	☐	Length (No. of Characters)
10	FLD_SELTYPE	TMCW_AA_QRY_DAT	FLD_SELTYPE		☐	MCW_AA_FLD_SELTYPE	☐	Query Field Selection Type
11	FLD_SELENTRY	TMCW_AA_QRY_DAT	FLD_SELENTRY		☐	MCW_AA_FLD_SELENTRY	☐	Entry Type of a Query Field
12	FLD_TIMETYPE	TMCW_AA_QRY_DAT	FLD_TIMETYPE		☐	MCW_AA_FLD_TIMETYPE	☐	Period Category of a Time Characteristic

Maintenance Status

Access

☐   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☑   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110901
SAP Release Created in