SAP ABAP Table PA3230 (Personnel Master Record for Infotype 3230)

Hierarchy

☛ SAP_HRCCH (Software Component) Sub component SAP_HRCCH of SAP_HR
   ⤷ PA-PF-CH (Application Component) Pension Fund Switzerland
     ⤷ P02F (Package) Pension fund: Switzerland

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA3230	Table Relationship Diagram
Short Description	Personnel Master Record for Infotype 3230

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	*
2	.INCLUDE	☑				0	0	Key for HR Master Data
3	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
4	SUBTY	☑	SUBTY	SUBTY	CHAR	4	0	Subtype
5	OBJPS	☑	OBJPS	OBJPS	CHAR	2	0	Object Identification
6	SPRPS	☑	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
7	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
8	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
9	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
10	.INCLUDE	☐				0	0	HR Master Record: Control Field
11	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
14	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
15	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
16	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
17	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
18	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
19	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
20	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
24	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
26	.INCLUDE	☐				0	0	Infotype 3230 Non-Recurring Payments (PA-PF-CH)
27	KASSE	☐	P02K_KASSE	P02K_KASSE	CHAR	4	0	Pension fund	T5CP0
28	STATUS	☐	P02F_DTA_STATUS	P02F_DTA_STATUS	CHAR	1	0	Status of DTA Posting of Value Types
29	KONNR	☐	P02K_KONNR	NUMC10	NUMC	10	0	Individual PF account number	*
30	BUDAT	☐	P02K_BUDAT	DATS	DATS	8	0	Posting date of a PF posting
31	SEQPF	☐	P02K_SEQNR	NUMC5	NUMC	5	0	Sequence number of posting per day	*
32	VALTY	☐	P02_VALTY	P02_VALTY	CHAR	4	0	PC Value Type	T5CA2
33	VALUE	☐	P02_VAL	P02_VAL	CHAR	18	0	Value within processing control
34	VADAT	☐	P02K_VADAT	DATS	DATS	8	0	Value date for PF posting
35	DTAID	☐	LAUFI	LAUFI	CHAR	6	0	Additional Identification
36	QLSTR	☐	P02F_QUELLENSTEUER	P_AMT07V	CURR	13	2	Calculated Withholding Tax for Non-Recurring Payment
37	AMAQS	☐	P02F_AMOUNT_AFTER_QST	P_AMT07V	CURR	13	2	Val.of Non-Recurring Pymts Acc. to Withholding Tax Deduction
38	EMFSL	☐	EMFSL_521B	EMFSL_521B	CHAR	8	0	Payee key for bank transfers	T521B
39	EMFNA	☐	EMFNA	TEXT25	CHAR	25	0	Payee name
40	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
41	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
42	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
43	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
44	BKKTO	☐	BANKN	BANKN	CHAR	18	0	Bank account number
45	ZLSCH	☐	PCODE	ZLSCH	CHAR	1	0	Payment Method	T042Z
46	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
47	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
48	ETEXT	☐	EMFTX	TEXT40	CHAR	40	0	Payee Text
49	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
50	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
51	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
52	EBNAM	☐	P02F_EBNAM	TEXT40	CHAR	40	0	Name of End Beneficiary for Non-Recurring Payment
53	EBSTR	☐	P02F_EBSTR	PAD_STRAS	CHAR	60	0	Street and House Number of End Beneficiary for NrP
54	EBPLZ	☐	P02F_EBPLZ	PSTLZ	CHAR	10	0	Postal Code of End Beneficiary for Non-Recurring Payment
55	EBORT	☐	P02F_EBORT	PAD_ORT01	CHAR	40	0	City of Residence of End Beneficiary for NrP
56	EBREG	☐	P02F_EBREG	REGIO	CHAR	3	0	Canton/Region of End Beneficiary for Non-Recurring Payment	T005S
57	EBLND	☐	P02F_EBLAND	LAND1	CHAR	3	0	Country of Residence of End Beneficiary for NonRecurring Pyt	T005
58	BUNUM	☐	P05K_BUNUM	NUMC10	NUMC	10	0	Buchungsnummer
59	NEWST	☐	P02F_NEW_STATUS	XFELD	CHAR	1	0	New Status set for RPCDTPC0
60	BKRF2	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
61	BKRF3	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
62	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA3230	BANKS	T005	LAND1	KEY	C	CN
2	PA3230	EBLND	T005	LAND1	KEY	C	CN
3	PA3230	EBREG	T005S	BLAND	KEY	C	CN
4	PA3230	EMFSL	T521B	EMFSL	KEY	C	CN
5	PA3230	KASSE	T5CP0	KASSE	KEY	1	CN
6	PA3230	PERNR	PA0003	PERNR
7	PA3230	PREAS	T530E	PREAS
8	PA3230	STATE	T005S	BLAND	KEY	C	CN
9	PA3230	VALTY	T5CA2	VALTY	KEY	1	CN
10	PA3230	ZLSCH	T042Z	ZLSCH	KEY	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in