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