SAP ABAP Table PS0442 (Company car)
Hierarchy
☛
SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
⤷ PA-PA (Application Component) Personnel Administration
⤷ PBCC (Package) HR master data: Company Car
⤷ PA-PA (Application Component) Personnel Administration
⤷ PBCC (Package) HR master data: Company Car
Basic Data
Table Category | INTTAB | Structure |
Structure | PS0442 | Table Relationship Diagram |
Short Description | 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 | RGNDA | P_RGNDA | DATUM | DATS | 8 | 0 | Registration Date | ||
2 | BUYDA | P_BUYDA | DATUM | DATS | 8 | 0 | Buy Date | ||
3 | FACTO | P_FACTO | P_FACTO | CHAR | 2 | 0 | Car manufacturer | T51C1 | |
4 | MODEL | P_MODEL | P_MODEL | CHAR | 6 | 0 | Car Model | T51C3 | |
5 | REGNO | P_KFZKZ | CHAR10 | CHAR | 10 | 0 | License plate number | ||
6 | ASTNO | ANLNR | ANLNR | CHAR | 20 | 0 | Car Asset Number | ||
7 | REASN | P_REASN | P_REASN | CHAR | 1 | 0 | Unavailability Reason | T51CC | |
8 | FREEM | P_FREEM | XFELD | CHAR | 1 | 0 | Free maintenance | ||
9 | INSUR | P_INSUR | XFIELD | CHAR | 1 | 0 | Including insurance | ||
10 | INCFL | P_INCFL | XFELD | CHAR | 1 | 0 | Including fuel | ||
11 | PRVDR | P_PRVDR | NUMC6 | NUMC | 6 | 0 | Private driving per year | ||
12 | DUTDR | P_DUTDR | NUMC6 | NUMC | 6 | 0 | Duty driving per year | ||
13 | LISTP | P_LISTP | WERT15 | CURR | 15 | 2 | Car List Price | ||
14 | DSCNT | P_DSCNT | P_DSCNT | DEC | 5 | 2 | Discount in percentage | ||
15 | ACCSS | P_ACCSS | WERT15 | CURR | 15 | 2 | Paid for Accessories | ||
16 | PAIDP | P_PAIDP | WERT15 | CURR | 15 | 2 | Car Paid Price | ||
17 | ONEPD | P_ONEPD | WERT15 | CURR | 15 | 2 | One time with hold payment | ||
18 | REGPD | P_REGPD | WERT15 | CURR | 15 | 2 | Regular with hold payment | ||
19 | BNFTV | P_BNFTV | WERT15 | CURR | 15 | 2 | Benefit value | ||
20 | CRNCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
21 | RANGE | P_RANGE | NUMC1 | NUMC | 1 | 0 | Sequence number | ||
22 | DSTNC | P_DSTNC | DEC3 | DEC | 3 | 0 | Distance to work | ||
23 | DSTN2 | P_ENTKM | DEC4 | DEC | 4 | 0 | Distance to home | ||
24 | CALCB | P_CALCB | XFELD | CHAR | 1 | 0 | Calculate benefit value | ||
25 | CARRG | P_PKWGL | PKWGL | CHAR | 1 | 0 | Regulation for taxation of company car | T544A | |
26 | MNTRL | P_MNTRL | P_MNTRL | CHAR | 1 | 0 | Regulation for maintenance of company car | T51C8 | |
27 | PAYMO | MODE1 | MODEL | CHAR | 4 | 0 | Payment Model | T549W | |
28 | CCSSC | P_CCSSC | WERT15 | CURR | 15 | 2 | Company car salary sacrifice | ||
29 | TTYPE | P_TTYPE | P_TTYPE | CHAR | 1 | 0 | Car transmission types (for UK only) | T5GC3 | |
30 | DPLAN | P_DPLAN | P_DPLAN | CHAR | 4 | 0 | Car Door plan (for UK only) | T5GC3 | |
31 | ADDAC | P_ADDAC | WERT15 | CURR | 15 | 2 | Further Accessories | ||
32 | FUELR | P_FUELR | P_FUELR | CHAR | 3 | 0 | Fuel rule | ||
33 | UAVAL | P_UAVAL | XFELD | CHAR | 1 | 0 | Car is unavailable | ||
34 | VEHCL | P_VEHCL | SUBTY_591A | CHAR | 4 | 0 | Vehicle Classification | * | |
35 | CO2EM | P_CO2EM | NUMC03 | NUMC | 3 | 0 | Car C02 Emissions | ||
36 | CVPSH | P_CVPSH | P_CVPSH | DEC | 5 | 2 | Van sharing percentage (for UK only) | ||
37 | CVFSH | P_CVFSH | XFELD | CHAR | 1 | 0 | Van Fuel Sharing (for UK only) | ||
38 | POLLC | P_POLLC | P_POLLC | CHAR | 2 | 0 | Pollution Category | T51CE | |
39 | LEASC | P_LEASC | P_LEASC | CHAR | 2 | 0 | Leasing Category (for NL only) | T51CF | |
40 | CMPID | P_CMPID | P_CMPID | CHAR | 4 | 0 | Leasing Company (for NL only) | T51CG | |
41 | P46CDT | P_P46CDT | DATS | DATS | 8 | 0 | P46Car issued date | ||
42 | P46CID | P_P46CID | CHAR1 | CHAR | 1 | 0 | P46Car has been issued indicator | ||
43 | TOTDS | P_TOTDS | WERT15 | CURR | 15 | 2 | VAT on Discounts | ||
44 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PS0442 | CARRG | T544A | PKWRG | |||
2 | PS0442 | CMPID | T51CG | CMPID | KEY | 1 | CN |
3 | PS0442 | CRNCY | TCURC | WAERS | 1 | CN | |
4 | PS0442 | DPLAN | T5GC3 | DPLAN | KEY | 1 | CN |
5 | PS0442 | FACTO | T51C1 | FACTO | 1 | CN | |
6 | PS0442 | LEASC | T51CF | LEASC | KEY | 1 | CN |
7 | PS0442 | MNTRL | T51C8 | MNTRL | KEY | 1 | CN |
8 | PS0442 | MODEL | T51C3 | MODEL | 1 | CN | |
9 | PS0442 | PAYMO | T549W | MODEL | KEY | 1 | CN |
10 | PS0442 | POLLC | T51CE | POLLC | KEY | 1 | CN |
11 | PS0442 | REASN | T51CC | REASN | KEY | 1 | CN |
12 | PS0442 | TTYPE | T5GC3 | TTYPE | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |