SAP ABAP Table T5DB9 (Construction Pay Evaluation Records for Social Fund Proc.)

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

Table Category	TRANSP	Transparent table
Transparent table	T5DB9	Table Relationship Diagram
Short Description	Construction Pay Evaluation Records for Social Fund Proc.

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	Key Fields for T5DB9 (without Client)
3	PERNR	☑	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	FORNR	☑	P01B_FORNR	NUMC2	NUMC	2	0	Number of Evaluation in Social Fund Procedure - Const. Ind.
5	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
6	SEQNO	☑	P01B_SEQN2	NUMC2	NUMC	2	0	Sequence Number 2 Places
7	.INCLUDE	☐				0	0	Basic Information Fields for T5DB9
8	ZVKAS	☐	P01B_ZVKAS	P01B_ZVKAS	CHAR	2	0	Social Fund	T5DBA
9	BNRSK	☐	P01B_BNRSK	BTRNR	CHAR	8	0	Company Number at a Social Fund - Construction Industry
10	RZNUM	☐	P01B_RZNUM	P01B_RZNUM	CHAR	8	0	Data Center Number for Construction Industry Social Fund	T5DBY
11	RZDAT	☐	P01B_RZDAT	SYDATS	DATS	8	0	Creation Date of Data Medium
12	SEQN2	☐	P01B_SEQN2	NUMC2	NUMC	2	0	Sequence Number 2 Places
13	MODIF	☐	P01B_MODIF	P01B_MODIF	CHAR	1	0	Modification Status for Evaluation Records SFP Construction
14	STATS	☐	P01B_STATS	P01B_STATS	CHAR	1	0	Utilization Status for Evaluation Records SFP Construction
15	STORN	☐	P01B_STORN	P01B_STORN	CHAR	1	0	Cancellation Status for Evaluation Records SFP Construction
16	ERROR	☐	P01B_ERROR	P01B_ERROR	CHAR	4	0	Error Status for Evaluation Records SFP Construction
17	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
18	ZVKAN	☐	P01B_ZVKAN	P01B_ZVKAN	CHAR	13	0	Employee Number at a Construction Social Insurance Fund
19	BAUTY	☐	P01B_BAUTY	P01B_BAUTY	CHAR	1	0	Employee Subgroup Grouping for Construction Pay
20	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	*
21	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	*
22	SBMOD	☐	SBMOD	CHAR4	CHAR	4	0	Administrator Group
23	SACHA	☐	SACHA	SACHA	CHAR	3	0	Payroll Administrator
24	ANAME	☐	P01B_ANAME	TEXT20	CHAR	20	0	Edited Name (Sortable)
25	XDATA	☐	P01B_XDATA	TEXT240	CHAR	240	0	Data Packet for Evaluation Data Record SFP Construction

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5DB9	MANDT	T000	MANDT		1	CN
2	T5DB9	RZNUM	T5DBY	RZNUM		1	CN
3	T5DB9	ZVKAS	T5DBA	ZVKAS		1	CN

History

Last changed by/on	SAP	20080626
SAP Release Created in