SAP ABAP View PTDW_TIMES_VIEW (DB View: Time Data Extract (Pers. Times WPBP & Acct Assigmt))

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_TIMES_VIEW
Short Description	DB View: Time Data Extract (Pers. Times WPBP & Acct Assigmt)
Root table	PTDW_TIMES_DB	Time Data Extract (Working Times)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PTDW_TIMES_DB	PTDW_TIMES_DB
2	PTDW_COST_DB
3	PTDW_ACTS_DB
4	PTDW_ACTR_DB
5	PTDW_WPBP_DB

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	PTDW_COST_DB	MANDT	JL	EQ				0	0
2	PTDW_TIMES_DB	MANDT	JR	EQ			AND	0	0
3	PTDW_COST_DB	DWLFNR	JL	EQ				0	0
4	PTDW_TIMES_DB	DWLFNRCO	JR	EQ			AND	0	0
5	PTDW_ACTS_DB	MANDT	JL	EQ				0	0
6	PTDW_TIMES_DB	MANDT	JR	EQ			AND	0	0
7	PTDW_ACTS_DB	DWLFNR	JL	EQ				0	0
8	PTDW_TIMES_DB	DWLFNRAS	JR	EQ			AND	0	0
9	PTDW_ACTR_DB	MANDT	JL	EQ				0	0
10	PTDW_TIMES_DB	MANDT	JR	EQ			AND	0	0
11	PTDW_ACTR_DB	DWLFNR	JL	EQ				0	0
12	PTDW_TIMES_DB	DWLFNRAR	JR	EQ			AND	0	0
13	PTDW_WPBP_DB	MANDT	JL	EQ				0	0
14	PTDW_TIMES_DB	MANDT	JR	EQ			AND	0	0
15	PTDW_WPBP_DB	DWLFNR	JL	EQ				0	0
16	PTDW_TIMES_DB	DWLFNRWP	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	PTDW_TIMES_DB	*		☐		☐
2	MANDT	PTDW_TIMES_DB	MANDT		☐	MANDT	☐	Client
3	DWLFNR	PTDW_TIMES_DB	DWLFNR		☐	DWLFNR	☐	Sequence Number for InfoSources in Time Management
4	PERNR	PTDW_TIMES_DB	PERNR		☐	PERNR_D	☐	Personnel Number
5	KMONTH	PTDW_TIMES_DB	KMONTH		☐	RSCALMONTH	☐	Calendar year / month
6	KDAY	PTDW_TIMES_DB	KDAY		☐	RSCALDAY	☐	Calendar day
7	DWLFNRWP	PTDW_TIMES_DB	DWLFNRWP		☐	DWLFNRWP	☐	Pointer to PTDW_WPBP_DB
8	DWLFNRCO	PTDW_TIMES_DB	DWLFNRCO		☐	DWLFNRCO	☐	Pointer to PTDW_COST_DB
9	DWLFNRAR	PTDW_TIMES_DB	DWLFNRAR		☐	DWLFNRAC	☐	Pointer to PTDW_ACTR_DB
10	DWLFNRAS	PTDW_TIMES_DB	DWLFNRAS		☐	DWLFNRAS	☐	Pointer to PTDW_ACTS_DB
11	ALP_POSITION	PTDW_TIMES_DB	ALP_POSITION		☐	ALP_POSTN	☐	Alternative position
12	ALP_RATE	PTDW_TIMES_DB	ALP_RATE		☐	ALP_RATE	☐	Alternative valuation basis
13	ALP_AMOUNT	PTDW_TIMES_DB	ALP_AMOUNT		☐	PAD_AMT7S	☐	Wage Type Amount for Payments
14	ALP_CURRENCY	PTDW_TIMES_DB	ALP_CURRENCY		☐	WAERS	☐	Currency Key
15	REPTT	PTDW_TIMES_DB	REPTT		☐	REPRTT	☐	Reporting Time Type
16	DUR_ACTUAL	PTDW_TIMES_DB	DUR_ACTUAL		☐	DUR_ACTUAL_Q	☐	Actual time
17	DUR_VALUE	PTDW_TIMES_DB	DUR_VALUE		☐	DUR_VALUE_Q	☐	Account-Relevant Time
18	UNIT	PTDW_TIMES_DB	UNIT		☐	ROUNIT	☐	Unit of Measure
19	*	PTDW_ACTS_DB	*		☐		☐
20	-	PTDW_ACTS_DB	MANDT		☐	MANDT	☐	Client
21	-	PTDW_ACTS_DB	DWLFNR		☐	DWLFNR	☐	Sequence Number for InfoSources in Time Management
22	BUKRS_AS	PTDW_ACTS_DB	BUKRS_AS		☐	BUKRS	☐	Company Code
23	GSBER_AS	PTDW_ACTS_DB	GSBER_AS		☐	GSBER	☐	Business Area
24	KOKRS_AS	PTDW_ACTS_DB	KOKRS_AS		☐	KOKRS	☐	Controlling Area
25	KOSTL_AS	PTDW_ACTS_DB	KOSTL_AS		☐	KOSTL	☐	Cost Center
26	LSTAR_AS	PTDW_ACTS_DB	LSTAR_AS		☐	LSTAR	☐	Activity Type
27	FUND_AS	PTDW_ACTS_DB	FUND_AS		☐	BP_GEBER	☐	Fund
28	FUNC_AREA_AS	PTDW_ACTS_DB	FUNC_AREA_AS		☐	FKBER	☐	Functional Area
29	GRANT_NBR_AS	PTDW_ACTS_DB	GRANT_NBR_AS		☐	GM_GRANT_NBR	☐	Grant
30	*	PTDW_ACTR_DB	*		☐		☐
31	-	PTDW_ACTR_DB	MANDT		☐	MANDT	☐	Client
32	-	PTDW_ACTR_DB	DWLFNR		☐	DWLFNR	☐	Sequence Number for InfoSources in Time Management
33	BUKRS_AR	PTDW_ACTR_DB	BUKRS_AR		☐	BUKRS	☐	Company Code
34	GSBER_AR	PTDW_ACTR_DB	GSBER_AR		☐	GSBER	☐	Business Area
35	KOKRS_AR	PTDW_ACTR_DB	KOKRS_AR		☐	KOKRS	☐	Controlling Area
36	KOSTL_AR	PTDW_ACTR_DB	KOSTL_AR		☐	KOSTL	☐	Cost Center
37	AUFNR_AR	PTDW_ACTR_DB	AUFNR_AR		☐	AUFNR	☐	Order Number
38	PS_POSID_AR	PTDW_ACTR_DB	PS_POSID_AR		☐	PS_POSID	☐	Work Breakdown Structure Element (WBS Element)
39	CO_PRZNR_AR	PTDW_ACTR_DB	CO_PRZNR_AR		☐	CO_PRZNR	☐	Business Process
40	NPLNR_AR	PTDW_ACTR_DB	NPLNR_AR		☐	NPLNR	☐	Network Number for Account Assignment
41	VORNR_AR	PTDW_ACTR_DB	VORNR_AR		☐	VORNR	☐	Operation/Activity Number
42	FUND_AR	PTDW_ACTR_DB	FUND_AR		☐	BP_GEBER	☐	Fund
43	FUNC_AREA_AR	PTDW_ACTR_DB	FUNC_AREA_AR		☐	FKBER	☐	Functional Area
44	GRANT_NBR_AR	PTDW_ACTR_DB	GRANT_NBR_AR		☐	GM_GRANT_NBR	☐	Grant
45	*	PTDW_COST_DB	*		☐		☐
46	-	PTDW_COST_DB	MANDT		☐	MANDT	☐	Client
47	-	PTDW_COST_DB	DWLFNR		☐	DWLFNR	☐	Sequence Number for InfoSources in Time Management
48	BUKRS_CO	PTDW_COST_DB	BUKRS_CO		☐	DEBT_CMPC	☐	Debited company code
49	GSBER_CO	PTDW_COST_DB	GSBER_CO		☐	DEBT_BUSA	☐	Debited business area
50	KOKRS_CO	PTDW_COST_DB	KOKRS_CO		☐	KOKRS	☐	Controlling Area
51	KOSTL_CO	PTDW_COST_DB	KOSTL_CO		☐	DEBT_CCTR	☐	Debited Cost Center
52	AUFNR_CO	PTDW_COST_DB	AUFNR_CO		☐	DEBT_ORDER	☐	Debited Order
53	PS_POSID_CO	PTDW_COST_DB	PS_POSID_CO		☐	DEBT_WBS_E	☐	Debited WBS element
54	LSTAR_CO	PTDW_COST_DB	LSTAR_CO		☐	DEBT_ACTT	☐	Debited Activity Type
55	VORNR_CO	PTDW_COST_DB	VORNR_CO		☐	DEBT_ACTVY	☐	Debited activity
56	NPLNR_CO	PTDW_COST_DB	NPLNR_CO		☐	DEBT_NETW	☐	Debited network
57	FM_AREA_CO	PTDW_COST_DB	FM_AREA_CO		☐	FIKRS	☐	Financial Management Area
58	FUND_CO	PTDW_COST_DB	FUND_CO		☐	BP_GEBER	☐	Fund
59	FUNC_AREA_CO	PTDW_COST_DB	FUNC_AREA_CO		☐	FKBER	☐	Functional Area
60	GRANT_NBR_CO	PTDW_COST_DB	GRANT_NBR_CO		☐	GM_GRANT_NBR	☐	Grant
61	*	PTDW_WPBP_DB	*		☐		☐
62	-	PTDW_WPBP_DB	MANDT		☐	MANDT	☐	Client
63	-	PTDW_WPBP_DB	DWLFNR		☐	DWLFNR	☐	Sequence Number for InfoSources in Time Management
64	ORG_UNIT_WP	PTDW_WPBP_DB	ORG_UNIT_WP		☐	ORGEH	☐	Organizational Unit
65	JOB_WP	PTDW_WPBP_DB	JOB_WP		☐	STELL	☐	Job
66	POSITION_WP	PTDW_WPBP_DB	POSITION_WP		☐	PLANS	☐	Position
67	PERS_AREA_WP	PTDW_WPBP_DB	PERS_AREA_WP		☐	PERSA	☐	Personnel Area
68	PERS_SUBAREA_WP	PTDW_WPBP_DB	PERS_SUBAREA_WP		☐	BTRTL	☐	Personnel Subarea
69	EMPL_GROUP_WP	PTDW_WPBP_DB	EMPL_GROUP_WP		☐	PERSG	☐	Employee Group
70	EMPL_SUBGROUP_WP	PTDW_WPBP_DB	EMPL_SUBGROUP_WP		☐	PERSK	☐	Employee Subgroup
71	CO_AREA_WP	PTDW_WPBP_DB	CO_AREA_WP		☐	MAST_COAR	☐	Controlling Area of Master Cost Center
72	COSTCENTER_WP	PTDW_WPBP_DB	COSTCENTER_WP		☐	MAST_CCTR	☐	Master Cost Center
73	COMP_CODE_WP	PTDW_WPBP_DB	COMP_CODE_WP		☐	BUKRS	☐	Company Code
74	BUS_AREA_WP	PTDW_WPBP_DB	BUS_AREA_WP		☐	GSBER	☐	Business Area
75	TIME_STATUS_WP	PTDW_WPBP_DB	TIME_STATUS_WP		☐	PT_ZTERF	☐	Employee Time Management Status
76	FM_AREA_WP	PTDW_WPBP_DB	FM_AREA_WP		☐	FIKRS	☐	Financial Management Area
77	FUND_WP	PTDW_WPBP_DB	FUND_WP		☐	BP_GEBER	☐	Fund
78	FUNC_AREA_WP	PTDW_WPBP_DB	FUNC_AREA_WP		☐	FKBER	☐	Functional Area
79	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