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   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