SAP ABAP View V_PDBKUR (Construction Industry Social Fund Proced: URMEL Data Records)

Hierarchy

☛ SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
   ⤷ PY-DE-CI (Application Component) Construction Industry
     ⤷ P01B (Package) Payroll: Construction Industry

Basic Data

View Type	D	Database View
Database View	V_PDBKUR
Short Description	Construction Industry Social Fund Proced: URMEL Data Records
Root table	PDBKUR	Construction Industry Social Fund Proced: URMEL Data Records

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PDBKUR	PDBKUR
2	PDBKAD

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	PDBKUR	MANDT	JL	EQ				0	0
2	PDBKAD	MANDT	JR	EQ			AND	0	0
3	PDBKUR	PERNR	JL	EQ				0	0
4	PDBKAD	PERNR	JR	EQ			AND	0	0
5	PDBKUR	INPER	JL	EQ				0	0
6	PDBKAD	INPER	JR	EQ			AND	0	0
7	PDBKUR	FPPER	JL	EQ				0	0
8	PDBKAD	FPPER	JR	EQ			AND	0	0
9	PDBKUR	SEQNO	JL	EQ				0	0
10	PDBKAD	SEQNO	JR	EQ			AND	0	0
11	PDBKUR	KENID	JL	EQ				0	0
12	PDBKAD	KENID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	PDBKAD	MANDT		☐	MANDT	☐	Client
2	PERNR	PDBKAD	PERNR		☐	PERNR_D	☐	Personnel Number
3	INPER	PDBKAD	INPER		☐	P01B_BKINP	☐	In-Period for Evaluation for Social Fund Procedure
4	FPPER	PDBKAD	FPPER		☐	P01B_BKFUP	☐	For-Period for Evaluation for Social Fund Procedure
5	SEQNO	PDBKAD	SEQNO		☐	P01B_BKSEQ	☐	Key Field Sequence Number for SFP Data Records
6	KENID	PDBKAD	KENID		☐	P01B_BKSID	☐	Identifier of Record
7	ZVKAS	PDBKAD	ZVKAS		☐	P01B_ZVKAS	☐	Social Fund
8	STATS	PDBKAD	STATS		☐	P01B_BKSTA	☐	Status of Data Record in Social Fund Procedure
9	BESCH	PDBKAD	BESCH		☐	P01B_BKBES	☐	Indicator for Certified Data Record
10	WERKS	PDBKAD	WERKS		☐	P01B_BKPEB	☐	Sending Personnel Area
11	BTRTL	PDBKAD	BTRTL		☐	P01B_BKPTB	☐	Sending Personnel Subarea
12	RZNSK	PDBKUR	RZNSK		☐	P01B_BKRZE	☐	Data Center Number of Social Fund (R)
13	RZNAG	PDBKUR	RZNAG		☐	P01B_BKRZA	☐	Data Center Number for Company for Social Fund (R)
14	BNRSK	PDBKUR	BNRSK		☐	P01B_BKBNR	☐	Company Number at a Social Fund - Construction Industry
15	NUS01	PDBKUR	NUS01		☐	P01B_BKNU7	☐	Unused Numeric Field - Length 7
16	NUS02	PDBKUR	NUS02		☐	CHAR2	☐	Version Number Component
17	RZDAT	PDBKUR	RZDAT		☐	P01B_RZDAT	☐	Creation Date of Data Medium
18	VERNR	PDBKUR	VERNR		☐	P01B_BKVNR	☐	Version of Data Medium Exchange
19	FNAME	PDBKUR	FNAME		☐	P01B_BKFNA	☐	Name of Company for Social Fund
20	ZVKAN	PDBKUR	ZVKAN		☐	P01B_BKANR	☐	Employee Number at a Construction Social Insurance Fund
21	SKPNR	PDBKUR	SKPNR		☐	P01B_BKPNR	☐	Personnel Number for Notifications in SFP
22	MDART	PDBKUR	MDART		☐	P01B_BKMAU	☐	Notification Type for Data Record URMEL
23	ABRMO	PDBKUR	ABRMO		☐	P01B_BKAMO	☐	Payroll Month in Social Fund Procedure
24	ABRJA	PDBKUR	ABRJA		☐	P01B_BKAJA	☐	Payroll Year in Social Fund Procedure
25	BEGDA	PDBKUR	BEGDA		☐	P01B_BKBEG	☐	Start of Notification Period
26	ENDDA	PDBKUR	ENDDA		☐	P01B_BKEND	☐	End of Notification Period
27	STONR	PDBKUR	STONR		☐	P01B_BKSNR	☐	Number of Cancellation for Evaluation Data Records SFP
28	WAERS	PDBKUR	WAERS		☐	P01B_BKWAE	☐	Currency Key for Social Fund Procedure
29	BTAGE	PDBKUR	BTAGE		☐	P01B_BKBTG	☐	Employment Days for Data Record URMEL
30	BLOHN	PDBKUR	BLOHN		☐	P01B_BKBLO	☐	Gross Wage for Data Record URMEL
31	AFSTD	PDBKUR	AFSTD		☐	P01B_BKAFS	☐	Number of Lost Hours for Data Record URMEL
32	NUS03	PDBKUR	NUS03		☐	CHAR16	☐	Field of length 16
33	GTAGE	PDBKUR	GTAGE		☐	P01B_BKGTG	☐	Granted Leave Days for Data Record URMEL
34	GVERG	PDBKUR	GVERG		☐	P01B_BKGVG	☐	Leave Remuneration Granted for Data Record URMEL
35	GZUTG	PDBKUR	GZUTG		☐	P01B_BKZUT	☐	Retained Leave Days for Data Record URMEL
36	NUS06	PDBKUR	NUS06		☐	CHAR4	☐	Not More Closely Defined Area, Possibly Used for Patchlevels
37	GSTDG	PDBKUR	GSTDG		☐	P01B_BKSTG	☐	Hours Worked for Data Record URMEL (Berlin
38	GSTDB	PDBKUR	GSTDB		☐	P01B_BKSTB	☐	Hours Paid for Data Record URMEL (Berlin)
39	GBRTL	PDBKUR	GBRTL		☐	P01B_BKBST	☐	Gross Hourly Wage for Record URMEL (Berlin)
40	GLGRP	PDBKUR	GLGRP		☐	P01B_BKGRP	☐	Wage Group (Berlin)
41	NACHN	PDBKUR	NACHN		☐	P01B_BKNAM	☐	Last Name
42	VORNA	PDBKUR	VORNA		☐	P01B_BKVNA	☐	First Name
43	NUS05	PDBKUR	NUS05		☐	CHAR9	☐	Character field of 9 digits
44	WEGAZ	PDBKUR	WEGAZ		☐	P01B_WEGAZ	☐	Travel Allowance for Trainee Social Fund Berlin
45	UEBGB	PDBKUR	UEBGB		☐	P01B_UEBGB	☐	Projected Hours Interim Payment Scaffolding Division Berlin
46	WUZGB	PDBKUR	WUZGB		☐	P01B_WUZGB	☐	Winter Leave Supplement Scaffolding Division Berlin
47	AUSFK	PDBKUR	AUSFK		☐	P01B_AUSFK	☐	Minimum Leave Remuneration - Lost Hours Illness
48	AUSSK	PDBKUR	AUSSK		☐	P01B_AUSSK	☐	Minimum Leave Remuneration - Lost Hours Seasonal RHC
49	MUVAK	PDBKUR	MUVAK		☐	P01B_MUVAK	☐	Minimum Leave Remuneration - Amount Lost Hours Illness
50	MUVSK	PDBKUR	MUVSK		☐	P01B_MUVSK	☐	Minimum Leave Remuneration - Amount Seasonal RHC

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	20131127
SAP Release Created in