SAP ABAP View V_PDBKAN (Construction Industry Social Fund Proced: ANMEL 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_PDBKAN
Short Description	Construction Industry Social Fund Proced: ANMEL Data Records
Root table	PDBKAN	Construction Industry Social Fund Proced: ANMEL Data Records

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	PDBKAN	MANDT	JL	EQ				0	0
2	PDBKAD	MANDT	JR	EQ			AND	0	0
3	PDBKAN	PERNR	JL	EQ				0	0
4	PDBKAD	PERNR	JR	EQ			AND	0	0
5	PDBKAN	INPER	JL	EQ				0	0
6	PDBKAD	INPER	JR	EQ			AND	0	0
7	PDBKAN	FPPER	JL	EQ				0	0
8	PDBKAD	FPPER	JR	EQ			AND	0	0
9	PDBKAN	SEQNO	JL	EQ				0	0
10	PDBKAD	SEQNO	JR	EQ			AND	0	0
11	PDBKAN	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	PDBKAN	RZNSK		☐	P01B_BKRZE	☐	Data Center Number of Social Fund (R)
13	RZNAG	PDBKAN	RZNAG		☐	P01B_BKRZA	☐	Data Center Number for Company for Social Fund (R)
14	BNRSK	PDBKAN	BNRSK		☐	P01B_BKBNR	☐	Company Number at a Social Fund - Construction Industry
15	NUS01	PDBKAN	NUS01		☐	P01B_BKNU7	☐	Unused Numeric Field - Length 7
16	NUS02	PDBKAN	NUS02		☐	CHAR2	☐	Version Number Component
17	RZDAT	PDBKAN	RZDAT		☐	P01B_RZDAT	☐	Creation Date of Data Medium
18	VERNR	PDBKAN	VERNR		☐	P01B_BKVNR	☐	Version of Data Medium Exchange
19	FNAME	PDBKAN	FNAME		☐	P01B_BKFNA	☐	Name of Company for Social Fund
20	ZVKAN	PDBKAN	ZVKAN		☐	P01B_BKANR	☐	Employee Number at a Construction Social Insurance Fund
21	SKPNR	PDBKAN	SKPNR		☐	P01B_BKPNR	☐	Personnel Number for Notifications in SFP
22	MSCHL	PDBKAN	MSCHL		☐	P01B_BKMSA	☐	Notification Key for Data Record ANMEL
23	BEGDA	PDBKAN	BEGDA		☐	P01B_BKBEG	☐	Start of Notification Period
24	ENDDA	PDBKAN	ENDDA		☐	P01B_BKEND	☐	End of Notification Period
25	ANGRP	PDBKAN	ANGRP		☐	P01B_BKAGP	☐	Employee Group for Data Record ANMEL
26	NACHN	PDBKAN	NACHN		☐	P01B_BKNAM	☐	Last Name
27	VORNA	PDBKAN	VORNA		☐	P01B_BKVNA	☐	First Name
28	GBDAT	PDBKAN	GBDAT		☐	P01B_BKGBD	☐	Date of Birth
29	GBORT	PDBKAN	GBORT		☐	P01B_BKGBO	☐	Birthplace
30	STRAS	PDBKAN	STRAS		☐	P01B_BKSTR	☐	House Number and Street
31	PSTLZ	PDBKAN	PSTLZ		☐	P01B_BKPLZ	☐	Postal Code
32	ORT01	PDBKAN	ORT01		☐	P01B_BKORT	☐	City
33	LAND1	PDBKAN	LAND1		☐	P01B_BKLAN	☐	Country Indicator
34	EMAIL	PDBKAN	EMAIL		☐	P01B_BKEMA	☐	E-mail Address
35	GESCH	PDBKAN	GESCH		☐	P01B_BKGES	☐	Gender Key
36	WOSTD	PDBKAN	WOSTD		☐	P01B_BKWOS	☐	Weekly Working Time for Social Fund Procedure
37	NATIO	PDBKAN	NATIO		☐	P01B_BKNAT	☐	Nationality
38	SPRSL	PDBKAN	SPRSL		☐	P01B_BKSPR	☐	Language of Communication
39	BANKL	PDBKAN	BANKL		☐	P01B_BKBKL	☐	Bank Number
40	BANKN	PDBKAN	BANKN		☐	P01B_BKBAN	☐	Bank Account Number
41	EMFTX	PDBKAN	EMFTX		☐	P01B_BKBEM	☐	Payee Text
42	BANKS	PDBKAN	BANKS		☐	P01B_BKBKS	☐	Bank Country Key
43	HEFTA	PDBKAN	HEFTA		☐	P01B_BKHAF	☐	Book Request for Data Record ANMEL
44	NUS03	PDBKAN	NUS03		☐	CHAR16	☐	Field of length 16
45	BANKA	PDBKAN	BANKA		☐	P01B_BKBAA	☐	Foreign Bank Details
46	BANKI	PDBKAN	BANKI		☐	P01B_BKBAI	☐	Bank Account Holder

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