SAP ABAP Table HCMT_BSP_PA_NL_R0442 (HCMT_BSP_PA_NL_R0442)
Hierarchy
☛
EA-HRCNL (Software Component) Sub component EA-HRCNL of EA-HR
⤷ PA-PA-NL (Application Component) Netherlands
⤷ PAOC_PAD_UI_INFTY_0442_NL (Package) User Interface for IT 0442 - Netherlands
⤷ PA-PA-NL (Application Component) Netherlands
⤷ PAOC_PAD_UI_INFTY_0442_NL (Package) User Interface for IT 0442 - Netherlands
Basic Data
Table Category | INTTAB | Structure |
Structure | HCMT_BSP_PA_NL_R0442 | Table Relationship Diagram |
Short Description |
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 | OBJECT_KEY | HCM_OBJECT_KEY | CHAR | 100 | 0 | HCM Object Key | |||
2 | .INCLUDE | 0 | 0 | Header Fields of an Infotype Version | |||||
3 | .INCLUDE | 0 | 0 | Header Fields of an Infotype Version | |||||
4 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
5 | AEDTM | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
6 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
7 | SPRPS | SPRPS | SPRPS | CHAR | 1 | 0 | Lock Indicator for HR Master Data Record | ||
8 | SPRTX | SPRPSTEXT | SPRPSTEXT | CHAR | 40 | 0 | Lock indicator for HR master record (text) | ||
9 | ITBLD | ITBLD | CHAR2 | CHAR | 2 | 0 | Infotype Screen Control | ||
10 | BEGDA | PAD_BEGDA | DATUM | DATS | 8 | 0 | Valid-From Date | ||
11 | ENDDA | PAD_ENDDA | DATUM | DATS | 8 | 0 | Valid To Date | ||
12 | .INCLUDE | 0 | 0 | ||||||
13 | VEHCL | P_VEHCL | SUBTY_591A | CHAR | 4 | 0 | Vehicle Classification | T591A | |
14 | FACTO | P_FACTO | P_FACTO | CHAR | 2 | 0 | Car manufacturer | T51C1 | |
15 | EGTXT | P_EGTXT | DDTEXT | CHAR | 60 | 0 | Company car Fuel type | ||
16 | MODEL | P_MODEL | P_MODEL | CHAR | 6 | 0 | Car Model | T51C3 | |
17 | MTEXT | P_MODTX | TEXT40 | CHAR | 40 | 0 | Car Model Text | ||
18 | CUBIC | P_CUBIC | NUM8 | NUMC | 8 | 0 | Engine Size | ||
19 | TTYDP | P_TTYDP | CHAR5 | CHAR | 5 | 0 | Transmission Type & Door Plan | ||
20 | TDTXT | TEXT40 | TEXT40 | CHAR | 40 | 0 | Text, 40 Characters Long | ||
21 | CO2EM | P_CO2EM | NUMC03 | NUMC | 3 | 0 | Car C02 Emissions | ||
22 | BUYDA | P_BUYDA | DATUM | DATS | 8 | 0 | Buy Date | ||
23 | REGNO | P_KFZKZ | CHAR10 | CHAR | 10 | 0 | License plate number | ||
24 | RGNDA | P_RGNDA | DATUM | DATS | 8 | 0 | Registration Date | ||
25 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
26 | ASTNO | ANLNR | ANLNR | CHAR | 20 | 0 | Car Asset Number | ||
27 | MAINNO | BF_ANLN1 | BF_ANLN1 | CHAR | 12 | 0 | Main Asset Number | ||
28 | SUBNO | BF_ANLN2 | BF_ANLN2 | CHAR | 4 | 0 | Asset Subnumber | ||
29 | TEXT | BF_TXA50 | TEXT50 | CHAR | 50 | 0 | Asset Description | ||
30 | RANGE | P_RANGE | NUMC1 | NUMC | 1 | 0 | Sequence number | ||
31 | UAVAL | P_UAVAL | XFELD | CHAR | 1 | 0 | Car is unavailable | ||
32 | REASN | P_REASN | P_REASN | CHAR | 1 | 0 | Unavailability Reason | T51CC | |
33 | LEASC | P_LEASC | P_LEASC | CHAR | 2 | 0 | Leasing Category (for NL only) | T51CF | |
34 | CMPID | P_CMPID | P_CMPID | CHAR | 4 | 0 | Leasing Company (for NL only) | T51CG | |
35 | .INCLUDE | 0 | 0 | ||||||
36 | LISTP | P_LISTP | WERT15 | CURR | 15 | 2 | Car List Price | ||
37 | CRNC1 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
38 | ACCSS | P_ACCSS | WERT15 | CURR | 15 | 2 | Paid for Accessories | ||
39 | CRNC2 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
40 | ADDAC | P_ADDAC | WERT15 | CURR | 15 | 2 | Further Accessories | ||
41 | CRNC3 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
42 | PAIDP | P05_UI_PAIDP | WERT15 | CURR | 15 | 2 | |||
43 | CRNC4 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
44 | ONEPD | P05_UI_ONEPD | WERT15 | CURR | 15 | 2 | |||
45 | CRNC5 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
46 | CALCB | P_CALCB | XFELD | CHAR | 1 | 0 | Calculate benefit value | ||
47 | BNFTV | P_BNFTV | WERT15 | CURR | 15 | 2 | Benefit value | ||
48 | REGPD | P_REGPD | WERT15 | CURR | 15 | 2 | Regular with hold payment | ||
49 | CRNCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
50 | PAYMO | MODE1 | MODEL | CHAR | 4 | 0 | Payment Model | T549W | |
51 | MODTX | TEXT50 | TEXT50 | CHAR | 50 | 0 | Text Field | ||
52 | POLLC | P_POLLC | P_POLLC | CHAR | 2 | 0 | Pollution Category | T51CE | |
53 | .INCLUDE | 0 | 0 | ||||||
54 | INCFL | P05_UI_INCFL | XFELD | CHAR | 1 | 0 | |||
55 | FUELR | P_FUELR | P_FUELR | CHAR | 3 | 0 | Fuel rule | ||
56 | PRVDR | P_PRVDR | NUMC6 | NUMC | 6 | 0 | Private driving per year | ||
57 | DUTDR | P_DUTDR | NUMC6 | NUMC | 6 | 0 | Duty driving per year | ||
58 | DSTNC | P_DSTNC | DEC3 | DEC | 3 | 0 | Distance to work | ||
59 | FREEM | P_FREEM | XFELD | CHAR | 1 | 0 | Free maintenance | ||
60 | INSUR | P_INSUR | XFIELD | CHAR | 1 | 0 | Including insurance | ||
61 | MNTRL | P_MNTRL | P_MNTRL | CHAR | 1 | 0 | Regulation for maintenance of company car | * | |
62 | DSTN2 | P_ENTKM | DEC4 | DEC | 4 | 0 | Distance to home | ||
63 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | HCMT_BSP_PA_NL_R0442 | CMPID | T51CG | CMPID | KEY | 1 | CN |
2 | HCMT_BSP_PA_NL_R0442 | CRNCY | TCURC | WAERS | 1 | CN | |
3 | HCMT_BSP_PA_NL_R0442 | FACTO | T51C1 | FACTO | 1 | CN | |
4 | HCMT_BSP_PA_NL_R0442 | LEASC | T51CF | LEASC | KEY | 1 | CN |
5 | HCMT_BSP_PA_NL_R0442 | MODEL | T51C3 | MODEL | 1 | CN | |
6 | HCMT_BSP_PA_NL_R0442 | PAYMO | T549W | MODEL | KEY | 1 | CN |
7 | HCMT_BSP_PA_NL_R0442 | POLLC | T51CE | POLLC | KEY | 1 | CN |
8 | HCMT_BSP_PA_NL_R0442 | REASN | T51CC | REASN | KEY | 1 | CN |
9 | HCMT_BSP_PA_NL_R0442 | VEHCL | T591A | SUBTY | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |