SAP ABAP View PTDW_QUOT_VIEW (DB View: Time Data Extract (Quota Transaction WPBP_ Fields))

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PT (Application Component) Personnel Time Management
     ⤷ PTDW (Package) Time Data Transfer to Business Information Warehouse (BW)

Basic Data

View Type	D	Database View
Database View	PTDW_QUOT_VIEW
Short Description	DB View: Time Data Extract (Quota Transaction WPBP_ Fields)
Root table	PTDW_QUOT_DB	Time Data Extract (Quota Transaction)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PTDW_QUOT_DB	PTDW_QUOT_DB
2	PTDW_WPBP_DB

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	PTDW_QUOT_DB	MANDT	JL	EQ				0	0
2	PTDW_WPBP_DB	MANDT	JR	EQ			AND	0	0
3	PTDW_QUOT_DB	DWLFNRWP	JL	EQ				0	0
4	PTDW_WPBP_DB	DWLFNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	PTDW_QUOT_DB	*		☐		☐
2	MANDT	PTDW_QUOT_DB	MANDT		☐	MANDT	☐	Client
3	DWLFNR	PTDW_QUOT_DB	DWLFNR		☐	DWLFNR	☐	Sequence Number for InfoSources in Time Management
4	PERNR	PTDW_QUOT_DB	PERNR		☐	PERNR_D	☐	Personnel Number
5	KMONTH	PTDW_QUOT_DB	KMONTH		☐	RSCALMONTH	☐	Calendar year / month
6	KDAY	PTDW_QUOT_DB	KDAY		☐	RSCALDAY	☐	Calendar day
7	DWLFNRWP	PTDW_QUOT_DB	DWLFNRWP		☐	DWLFNRWP	☐	Pointer to PTDW_WPBP_DB
8	QUOTA	PTDW_QUOT_DB	QUOTA		☐	QUOTAT	☐	Reporting Quota Type
9	ENTITLE	PTDW_QUOT_DB	ENTITLE		☐	PTDW_ENTITLE_Q	☐	Available entitlement of a personnel time quota
10	TAKEN	PTDW_QUOT_DB	TAKEN		☐	PTDW_REDUCED_Q	☐	Deducted Entitlement of a Personnel Time Quota
11	REPAYED	PTDW_QUOT_DB	REPAYED		☐	PTDW_REPAYED_Q	☐	Compensated entitlement of a personnel time quota
12	ACCRUED	PTDW_QUOT_DB	ACCRUED		☐	PTDW_ADDED_Q	☐	Inflow to a personnel time quota
13	LAPSED	PTDW_QUOT_DB	LAPSED		☐	PTDW_LEFT_Q	☐	Forfeited Entitlement of a Personnel Time Quota
14	UNIT	PTDW_QUOT_DB	UNIT		☐	ROUNIT	☐	Unit of Measure
15	*	PTDW_WPBP_DB	*		☐		☐
16	-	PTDW_WPBP_DB	MANDT		☐	MANDT	☐	Client
17	-	PTDW_WPBP_DB	DWLFNR		☐	DWLFNR	☐	Sequence Number for InfoSources in Time Management
18	ORG_UNIT_WP	PTDW_WPBP_DB	ORG_UNIT_WP		☐	ORGEH	☐	Organizational Unit
19	JOB_WP	PTDW_WPBP_DB	JOB_WP		☐	STELL	☐	Job
20	POSITION_WP	PTDW_WPBP_DB	POSITION_WP		☐	PLANS	☐	Position
21	PERS_AREA_WP	PTDW_WPBP_DB	PERS_AREA_WP		☐	PERSA	☐	Personnel Area
22	PERS_SUBAREA_WP	PTDW_WPBP_DB	PERS_SUBAREA_WP		☐	BTRTL	☐	Personnel Subarea
23	EMPL_GROUP_WP	PTDW_WPBP_DB	EMPL_GROUP_WP		☐	PERSG	☐	Employee Group
24	EMPL_SUBGROUP_WP	PTDW_WPBP_DB	EMPL_SUBGROUP_WP		☐	PERSK	☐	Employee Subgroup
25	CO_AREA_WP	PTDW_WPBP_DB	CO_AREA_WP		☐	MAST_COAR	☐	Controlling Area of Master Cost Center
26	COSTCENTER_WP	PTDW_WPBP_DB	COSTCENTER_WP		☐	MAST_CCTR	☐	Master Cost Center
27	COMP_CODE_WP	PTDW_WPBP_DB	COMP_CODE_WP		☐	BUKRS	☐	Company Code
28	BUS_AREA_WP	PTDW_WPBP_DB	BUS_AREA_WP		☐	GSBER	☐	Business Area
29	TIME_STATUS_WP	PTDW_WPBP_DB	TIME_STATUS_WP		☐	PT_ZTERF	☐	Employee Time Management Status
30	FM_AREA_WP	PTDW_WPBP_DB	FM_AREA_WP		☐	FIKRS	☐	Financial Management Area
31	FUND_WP	PTDW_WPBP_DB	FUND_WP		☐	BP_GEBER	☐	Fund
32	FUNC_AREA_WP	PTDW_WPBP_DB	FUNC_AREA_WP		☐	FKBER	☐	Functional Area
33	GRANT_NBR_WP	PTDW_WPBP_DB	GRANT_NBR_WP		☐	GM_GRANT_NBR	☐	Grant

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