SAP ABAP Table P08P_P46_ALV_TABS (Stucture for P46 alv-output)

Hierarchy

☛ SAP_HRCGB (Software Component) Sub component SAP_HRCGB of SAP_HR
   ⤷ PY-GB-PS (Application Component) Öffentlicher Dienst
     ⤷ P08P1 (Package) HR Public Sector Great Britain

Basic Data

Table Category	INTTAB	Structure
Structure	P08P_P46_ALV_TABS	Table Relationship Diagram
Short Description	Stucture for P46 alv-output

Delivery and Maintenance

Pool/cluster
Delivery Class
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	CHECKBOX	☐	CHAR01	CHAR1	CHAR	1	0	Character Field Length 1
2	.INCLUDE	☐				0	0	HR-GB: Reporting structure P46 Company Car
3	.INCLUDE	☐				0	0	HR-GB: General List output header
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
5	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
6	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
7	NAME1	☐	PBTXT	TEXT30	CHAR	30	0	Personnel Area Text
8	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
9	BTEXT	☐	BTRTX	TEXT15	CHAR	15	0	Personnel Subarea Text
10	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	T501
11	PGTXT	☐	PGTXT	TEXT20	CHAR	20	0	Name of Employee Group
12	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	T503K
13	PKTXT	☐	PKTXT	TEXT20	CHAR	20	0	Name of Employee Subgroup
14	ORGEH	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	T527X
15	ORGTX	☐	ORGTX	TEXT25	CHAR	25	0	Short Text of Organizational Unit
16	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
17	KOSTT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
18	ABKRS	☐	ABKRS	ABKRS	CHAR	2	0	Payroll Area	T549A
19	ABKTX	☐	ABKTX	TEXT20	CHAR	20	0	Payroll Area Text
20	PERNR	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
21	ER_NAME	☐	AD_NAME1_C	TEXT40	CHAR	40	0	Company name
22	ER_TELN	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
23	TDREF	☐	TDRCE	TDRCE	CHAR	10	0	Tax district indicator	*
24	TDNUM	☐	TDNUM	TDNUM	CHAR	3	0	Tax district number	*
25	PERID	☐	NINUM	NINUM	CHAR	9	0	National Insurance number
26	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
27	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
28	MIDNM	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
29	FREAS	☐	P08_FREAS	P08_FREAS	CHAR	2	0	HR-GB: Form reason
30	FREAS_TXT	☐	P08_FRTXT	TEXT50	CHAR	50	0	HR-GB: Form Reason Text
31	ERR_COD	☐	MSGNR	MSGNR	CHAR	3	0	Message number	*
32	MES_CLS	☐	ARBGB	ARBGB	CHAR	20	0	Application Area	*
33	EARPR	☐	P08_EARPR	WERT15	CURR	15	2	HR-GB: Employee's calculated year rate
34	AVADA	☐	P08_AVADA	DATUM	DATS	8	0	HR-GB: P46 Date the car was first available from
35	RGNDA	☐	P_RGNDA	DATUM	DATS	8	0	Registration Date
36	WITDA	☐	P08_WITDA	DATUM	DATS	8	0	HR-GB: P46 Car withdrawal date
37	FACTO	☐	P_FACTO	P_FACTO	CHAR	2	0	Car manufacturer	*
38	MODEL	☐	P_MODEL	P_MODEL	CHAR	6	0	Car Model	*
39	MTEXT	☐	P_MODTX	TEXT40	CHAR	40	0	Car Model Text
40	FTEXT	☐	P_FACTX	TEXT32	CHAR	32	0	Car manufacturer text
41	REGNO	☐	P_KFZKZ	CHAR10	CHAR	10	0	License plate number
42	TTYPE	☐	P_TTYPE	P_TTYPE	CHAR	1	0	Car transmission types (for UK only)
43	DPLAN	☐	P_DPLAN	P_DPLAN	CHAR	4	0	Car Door plan (for UK only)
44	CUBIC	☐	P08_CUBIC	NUMC4	NUMC	4	0	HR-GB:Car Engine Size
45	EGTYP	☐	P_EGTYP	P_EGTYP	CHAR	1	0	Fuel type
46	EGTYP_TXT	☐	P08_EGTX	TEXT10	CHAR	10	0	HR-GB: Engine type text
47	INCFL	☐	P_INCFL	XFELD	CHAR	1	0	Including fuel
48	FUELR	☐	P_FUELR	P_FUELR	CHAR	3	0	Fuel rule
49	CO2EM	☐	P_CO2EM	NUMC03	NUMC	3	0	Car C02 Emissions
50	LISTP	☐	P_LISTP	WERT15	CURR	15	2	Car List Price
51	ACCSS	☐	P_ACCSS	WERT15	CURR	15	2	Paid for Accessories
52	ADDAC	☐	P_ADDAC	WERT15	CURR	15	2	Further Accessories
53	SUMACC	☐	P_SUMACC	WERT15	CURR	15	2	Sum paid for accessories
54	ONEPD	☐	P_ONEPD	WERT15	CURR	15	2	One time with hold payment
55	REGPD	☐	P_REGPD	WERT15	CURR	15	2	Regular with hold payment
56	PAYMO	☐	MODE1	MODEL	CHAR	4	0	Payment Model	*
57	LIMCA	☐	P08_LIMCA	CHECKBOX	CHAR	1	0	Ee Earnings exceed P11D limit (or Ee is director)
58	PFREQ	☐	PFREQ	PFREQ	NUMC	2	0	Payroll time units
59	PERFQ_TXT	☐	P08_PFRQTX	TEXT30	CHAR	30	0	Payroll Frequency Text
60	RREGNO	☐	P08_RKFZKZ	CHAR10	CHAR	10	0	HR-GB: License plate number of the replaced car
61	RRGNDA	☐	P08_RRGNDA	DATUM	DATS	8	0	HR-GB: Registration date of the replaced car
62	RFACTO	☐	P08_RFACTO	P_FACTO	CHAR	2	0	HR-GB: Replaced Car Manufacturer	*
63	RMODEL	☐	P08_RMODEL	P_MODEL	CHAR	6	0	HR-GB: Replaced Car Model	*
64	RMTEXT	☐	P08_RMTXT	TEXT40	CHAR	40	0	HR-GB: Replaced Car Model Text
65	RFTEXT	☐	P08_RFTXT	TEXT32	CHAR	32	0	HR-GB: Replaced Car Manufacturer Text
66	RCUBIC	☐	P08_RCUBIC	NUMC4	NUMC	4	0	HR-GB: Replaced Car Engine Size
67	ISSDATE	☐	P08_AUSDT	DATUM	DATS	8	0	HR-GB: P46-Form Date of Issue
68	DECCAP	☐	P08_DECCAP	TEXT20	CHAR	20	0	HR-GB: Capacity in which signed
69	RCARI	☐	P08_RPCARI	CHAR3	CHAR	3	0	HR-GB:Replaced Car Indicator
70	WMODEL	☐	P08_VMODEL	CHAR35	CHAR	35	0	HR-GB:Withdraw Car Model
71	WCUBIC	☐	P08_VCUBIC	NUMC4	NUMC	4	0	HR-GB:Withdraw Car Engine size
72	WCARI	☐	P08_VCARI	CHAR3	CHAR	3	0	HR-GB:Withdraw Car Indicator
73	PCARI	☐	P08_PCARI	CHAR3	CHAR	3	0	HR-GB:Provided Car Indicator
74	PCUBIC	☐	P_PCUBIC	NUMC4	NUMC	4	0	HR-GB:Provided Car Engine Size
75	PMODEL	☐	P_PMODEL	CHAR35	CHAR	35	0	HR-GB:Provided Car Model
76	CO2EMS	☐	P08_CO2EMS	CHAR3	CHAR	3	0	HR-GB:Emissions
77	B1998	☐	P08_B1998	CHAR3	CHAR	3	0	HR-GB:Before 1998 (Was Car Registered)
78	NOAPVD	☐	P08_NOAPVD	CHAR3	CHAR	3	0	HR-GB:No Approved
79	CCNTRS	☐	P08_CCNTRS	NUMC6	NUMC	6	0	HR-GB:Capital Contributions
80	PPYMT	☐	P08_PPYMT	NUMC8	NUMC	8	0	HR-GB:Private Use Payment
81	FPVTI	☐	P08_FPVTI	CHAR3	CHAR	3	0	HR-GB:Fuel For Private Use Indicator
82	FPAID	☐	P08_FPAID	CHAR3	CHAR	3	0	HR-GB:Fuel Paid By Employee
83	P46DCL	☐	P08_P46DCL	CHAR3	CHAR	3	0	HR-GB:P46 Car Ceclaration
84	MCARI	☐	P08_MCARI	CHAR3	CHAR	3	0	HR-GB:Multiple Car Indicator
85	SCARI	☐	P08_SCARI	CHAR3	CHAR	3	0	HR-GB:Second/Further Car Indicator
86	ERDRI	☐	P08_ERDRI	CHAR3	CHAR	3	0	HR-GB: Earnings Or Director Indicator
87	IPYMT	☐	P08_IPMT	CHAR1	CHAR	1	0	HR-GB: Interval Of Payment
88	ENGCT	☐	P08_ENGCT	NUMC1	NUMC	1	0	HR-GB:EngineCategory
89	P46RC	☐	P08_P46RC	NUMC1	NUMC	1	0	HR-GB:P46CarRecordCount
90	P11DRC	☐	P08_P11DRC		CHAR	7	0	HR-GB:P11DRecordCount
91	P9DRC	☐	P08_P9DRC	NUMC1	NUMC	1	0	HR-GB:P9DRecordCount
92	P11DINC	☐	P08_P11DINC	CHAR12	CHAR	12	0	HR-GB:P11DIncluded
93	ANRED	☐	ANREX	ANREX	CHAR	5	0	Form of address text
94	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
95	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
96	GENDER	☐	P08_GENDER	CHAR6	CHAR	6	0	HR-GB: Gender Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P08P_P46_ALV_TABS	ABKRS	T549A	ABKRS
2	P08P_P46_ALV_TABS	BTRTL	T001P	BTRTL
3	P08P_P46_ALV_TABS	ORGEH	T527X	ORGEH
4	P08P_P46_ALV_TABS	PERSG	T501	PERSG
5	P08P_P46_ALV_TABS	PERSK	T503K	PERSK
6	P08P_P46_ALV_TABS	WERKS	T500P	PERSA

History

Last changed by/on	SAP	20131127
SAP Release Created in	470