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