SAP ABAP View PTDW_PWS_VIEW (DB View: Time Data Extract (Hours from PWS 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_PWS_VIEW
Short Description	DB View: Time Data Extract (Hours from PWS WPBP_ Fields)
Root table	PTDW_PWS_DB	Time Data Extract (Hours from Personal Work Schedule)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PTDW_PWS_DB	PTDW_PWS_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_PWS_DB	MANDT	JL	EQ				0	0
2	PTDW_WPBP_DB	MANDT	JR	EQ			AND	0	0
3	PTDW_PWS_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_PWS_DB	*		☐		☐
2	MANDT	PTDW_PWS_DB	MANDT		☐	MANDT	☐	Client
3	DWLFNR	PTDW_PWS_DB	DWLFNR		☐	DWLFNR	☐	Sequence Number for InfoSources in Time Management
4	PERNR	PTDW_PWS_DB	PERNR		☐	PERNR_D	☐	Personnel Number
5	KMONTH	PTDW_PWS_DB	KMONTH		☐	RSCALMONTH	☐	Calendar year / month
6	KDAY	PTDW_PWS_DB	KDAY		☐	RSCALDAY	☐	Calendar day
7	DWLFNRWP	PTDW_PWS_DB	DWLFNRWP		☐	DWLFNRWP	☐	Pointer to PTDW_WPBP_DB
8	PLHRS	PTDW_PWS_DB	PLHRS		☐	PTDW_PLHRS	☐	Planned Time According to Personal Work Schedule
9	WRHRS	PTDW_PWS_DB	WRHRS		☐	PTDW_WRHRS	☐	Planned Time Without Public Holidays
10	UNIT	PTDW_PWS_DB	UNIT		☐	ROUNIT	☐	Unit of Measure
11	REPTT	PTDW_PWS_DB	REPTT		☐	REPRTT	☐	Reporting Time Type
12	*	PTDW_WPBP_DB	*		☐		☐
13	-	PTDW_WPBP_DB	MANDT		☐	MANDT	☐	Client
14	-	PTDW_WPBP_DB	DWLFNR		☐	DWLFNR	☐	Sequence Number for InfoSources in Time Management
15	ORG_UNIT_WP	PTDW_WPBP_DB	ORG_UNIT_WP		☐	ORGEH	☐	Organizational Unit
16	JOB_WP	PTDW_WPBP_DB	JOB_WP		☐	STELL	☐	Job
17	POSITION_WP	PTDW_WPBP_DB	POSITION_WP		☐	PLANS	☐	Position
18	PERS_AREA_WP	PTDW_WPBP_DB	PERS_AREA_WP		☐	PERSA	☐	Personnel Area
19	PERS_SUBAREA_WP	PTDW_WPBP_DB	PERS_SUBAREA_WP		☐	BTRTL	☐	Personnel Subarea
20	EMPL_GROUP_WP	PTDW_WPBP_DB	EMPL_GROUP_WP		☐	PERSG	☐	Employee Group
21	EMPL_SUBGROUP_WP	PTDW_WPBP_DB	EMPL_SUBGROUP_WP		☐	PERSK	☐	Employee Subgroup
22	CO_AREA_WP	PTDW_WPBP_DB	CO_AREA_WP		☐	MAST_COAR	☐	Controlling Area of Master Cost Center
23	COSTCENTER_WP	PTDW_WPBP_DB	COSTCENTER_WP		☐	MAST_CCTR	☐	Master Cost Center
24	COMP_CODE_WP	PTDW_WPBP_DB	COMP_CODE_WP		☐	BUKRS	☐	Company Code
25	BUS_AREA_WP	PTDW_WPBP_DB	BUS_AREA_WP		☐	GSBER	☐	Business Area
26	TIME_STATUS_WP	PTDW_WPBP_DB	TIME_STATUS_WP		☐	PT_ZTERF	☐	Employee Time Management Status
27	FM_AREA_WP	PTDW_WPBP_DB	FM_AREA_WP		☐	FIKRS	☐	Financial Management Area
28	FUND_WP	PTDW_WPBP_DB	FUND_WP		☐	BP_GEBER	☐	Fund
29	FUNC_AREA_WP	PTDW_WPBP_DB	FUNC_AREA_WP		☐	FKBER	☐	Functional Area
30	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