SAP ABAP Table VMCW_AA_QRYFLD (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VMCW_AA_QRYFLD	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	RFCDEST	☑	MCW_AA_TARGET_SYS	LOGSYS	CHAR	10	0	Target System for Executing a Query	TMCW_AA_QRY
3	QUERY	☑	MCW_AA_QUERY	MCW_AA_QUERY_ID	CHAR	55	0	Query in Analytical Application	TMCW_AA_QRY
4	FLD_NR	☑	MCW_AA_LFDNR	NUMC3	NUMC	3	0	Field Sequence Number for a BW Query in OLTP
5	FLD_QUERY	☐	MCW_AA_FLD_OLAP	RSIOBJNM	CHAR	30	0	Query Field Name from OLAP System (BW)
6	FLD_FUNC	☐	MCW_AA_FLD_FUNCT	MCW_AA_FLD_FUNCTION	CHAR	2	0	Function of a Query Field
7	FLD_SOURCE	☐	MCW_AA_FLD_OLTP	RSIOBJNM	CHAR	30	0	Query Field Name from OLTP System (R3)
8	FLD_DATATYPE	☐	DATATYPE_D	DATATYPE	CHAR	4	0	Data Type in ABAP Dictionary
9	FLD_LENGTH	☐	DDLENG	DDLENG	NUMC	6	0	Length (No. of Characters)
10	FLD_SELTYPE	☐	MCW_AA_FLD_SELTYPE	MCW_AA_FLD_SELTYPE	CHAR	1	0	Query Field Selection Type
11	FLD_SELENTRY	☐	MCW_AA_FLD_SELENTRY	MCW_AA_FLD_SELENTRY	CHAR	1	0	Entry Type of a Query Field
12	FLD_TIMETYPE	☐	MCW_AA_FLD_TIMETYPE	MCW_AA_FLD_TIMETYPE	CHAR	2	0	Period Category of a Time Characteristic

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VMCW_AA_QRYFLD	MANDT	T000	MANDT	KEY
2	VMCW_AA_QRYFLD	QUERY	TMCW_AA_QRY	QUERY	KEY
3	VMCW_AA_QRYFLD	RFCDEST	TMCW_AA_QRY	RFCDEST	KEY

History

Last changed by/on	SAP	20110901
SAP Release Created in