SAP ABAP Table V_T5QLR (Generated Table for View)

Basic Data

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

Delivery and Maintenance

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

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	MOURA	☑	MOURA	MODIF	NUMC	2	0	Personnel Subarea Grouping for Leave Types
3	URART	☑	URAR	URART	CHAR	2	0	Leave type	T533
4	ACCID	☑	P13Q_ACCID	P13Q_ACCID	NUMC	2	0	Leave Accrual Identifier Australia
5	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
6	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
7	ACCFL	☐	P13Q_ACCFL	P13Q_ACCFL	CHAR	1	0	Leave Accrual - Accrual Flag
8	ACCRT	☐	P13Q_ACCRT	P13Q_ACCRT	DEC	9	5	Leave Accrual Rate
9	ACCFR	☐	P13Q_ACCFR	P13Q_ACCFR	CHAR	1	0	Leave Accrual Frequency
10	ACCWV	☐	P13Q_ACCWV	P13Q_ACCWV	DEC	6	2	Leave Accrual Warning Value
11	ACCMV	☐	P13Q_ACCMV	P13Q_ACCMV	DEC	6	2	Leave Accrual Maximum Value
12	ACCDV	☐	P13Q_ACCDV	P13Q_ACCDV	DEC	6	2	Leave Accrual Default Value
13	ANNTY	☐	P13Q_ANNTY	P13Q_ANNTY	CHAR	1	0	Leave Accrual Anniversary Type
14	ANNDU	☐	P13Q_ANNDU	P13Q_ANNDU	NUMC	3	0	Leave Accrual Anniversary Distance
15	ANNDT	☐	P13Q_ANNDT	P13Q_ANNDT	CHAR	1	0	Leave Accrual Anniversary Distance Type
16	INTNR	☐	P13Q_INTNR	P13Q_INTNR	NUMC	4	0	Internal Number for Leave Type Assignment
17	ANNFD	☐	P13Q_ANNFD	P13Q_ANNFD	NUMC	4	0	Leave Accrual Anniversary Fixed Date
18	ANNFV	☐	P13Q_ANNFV	P13Q_ANNFV	DEC	6	2	Leave Accrual Anniversary Fixed Value
19	ANNOP	☐	P13Q_ANNOP	P13Q_ANNOP	CHAR	1	0	Leave Accrual Anniversary Operation
20	NACID	☐	P13Q_ACCID	P13Q_ACCID	NUMC	2	0	Leave Accrual Identifier Australia	T5QLR
21	NALTY	☐	URAR	URART	CHAR	2	0	Leave type	T533
22	LLDTY	☐	P13Q_LLDTY	P13Q_LLDTY	CHAR	1	0	Leave Loading Type
23	LLPER	☐	P13Q_LLPER	P13Q_LLPER	DEC	5	2	Leave Loading Percentage
24	LLWTY	☐	P13Q_LLWTY	LGART	CHAR	4	0	Payable Leave Loading Wage Type	T512W
25	LLFDT	☐	P13Q_LLFDT	P13Q_LLFDT	NUMC	4	0	Fixed Date for Leave Loading
26	LVGRP	☐	P13Q_LVGRP	P13Q_LVGRP	CHAR	2	0	Leave Type/Quota Grouping	T5QLG
27	URTX1	☐	URTXT	TEXT20	CHAR	20	0	Leave name
28	LGTXT	☐	LGTXT	TEXT25	CHAR	25	0	Wage Type Long Text
29	URTX2	☐	URTXT	TEXT20	CHAR	20	0	Leave name
30	LGRTX	☐	P13Q_LGRTX	CHAR20	CHAR	20	0	Leave Type Grouping Text
31	ACCTX	☐	P13Q_ACCTX	CHAR20	CHAR	20	0	Leave Accrual ID Description Australia

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_T5QLR	LLWTY	T512W	LGART	REF	1	CN
2	V_T5QLR	LVGRP	T5QLG	LVGRP	KEY	1	CN
3	V_T5QLR	MANDT	T000	MANDT	KEY	1	CN
4	V_T5QLR	NACID	T5QLR	ACCID
5	V_T5QLR	NALTY	T533	URAR	KEY	1	CN
6	V_T5QLR	URART	T533	URAR	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in