SAP Table T5G_P46ARV

HR-GB: Archive for P46(Car)-Forms

T5G_P46ARV (HR-GB: Archive for P46(Car)-Forms) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T5G_P46ARV to other SAP tables.

T5G_P46ARV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
SERNR HR-GB: Serial number of P46(Car)-Forms for employee P08_SERNR NUMC 4 0
PERNR Personnel number PERSNO PA0003 NUMC 8 0
REGNO License plate number P_KFZKZ CHAR 10 0
FACTO Car manufacturer P_FACTO T51C1 CHAR 2 0
MODEL Car Model P_MODEL T51C3 CHAR 6 0
TTYPE Car transmission types (for UK only) P_TTYPE CHAR 1 0
M Manual
A Automatic
C Cont. Variable
S Semi Automatic
X T.Type (Not Specified)
DPLAN Car Door plan (for UK only) P_DPLAN CHAR 4 0
3H/B 3 Door Hatch Back
5H/B 5 Door Hatch Back
4SAL 4 Door Saloon
5EST 5 Door Estate
2CON 2 Door Convertible
0CON 0 Door Convertible
2CPE 2 Door Coupe
3CPE 3 Door Coupe
5MPV 5 Door Multi Pur. Vehicle
XXXX D.Plan (Not Specified)
RGNDA Registration Date P_RGNDA DATS 8 0
AVADA HR-GB: P46 Date the car was first available from P08_AVADA DATS 8 0
WITDA HR-GB: P46 Car withdrawal date P08_WITDA DATS 8 0
EGTYP Fuel type P_EGTYP CHAR 1 0
1 Regular unleaded
2 Premium unleaded
3 Premium leaded
4 Diesel
5 Butangas
6 Electro
7 Natural Oil (e.g. Corn)
H Hybrid (Petrol/Electric)
B Bi-fuel (Petrol/Gas)
G E85 (Bio Ethanol/Petrol)
A Diesel/Electric Hybrid
FUELR Fuel rule P_FUELR CHAR 3 0
DUC Diesel Euro 1V ultra clean
BIO Bi- fuel C02 emissions refer to the petrol emissions
ELE Company Van: Electric
CO2EM Car C02 Emissions P_CO2EM NUMC 3 0
INCFL Including fuel P_INCFL CHAR 1 0
X Yes
NULL No
LISTP Car List Price P_LISTP CURR 15 2
ACCSS Paid for Accessories P_ACCSS CURR 15 2
ADDAC Further Accessories P_ADDAC CURR 15 2
ONEPD One time with hold payment P_ONEPD CURR 15 2
REGPD Regular with hold payment P_REGPD CURR 15 2
PAYMO Payment Model MODE1 CHAR 4 0
LIMCA Ee Earnings exceed P11D limit (or Ee is director) P08_LIMCA CHAR 1 0
X Selection
NULL Deselection
EARPR HR-GB: Employee's calculated year rate P08_EARPR CURR 15 2
RREGNO HR-GB: License plate number of the replaced car P08_RKFZKZ CHAR 10 0
RRGNDA HR-GB: Registration date of the replaced car P08_RRGNDA DATS 8 0
RFACTO HR-GB: Replaced Car Manufacturer P08_RFACTO T51C1 CHAR 2 0
RMODEL HR-GB: Replaced Car Model P08_RMODEL T51C3 CHAR 6 0
FREAS HR-GB: Form reason P08_FREAS CHAR 2 0
N New car
S Second or subsequent car
R Replacement car
L Employee earning at the limit/became a director
W Withdrawn car
F Employees provided with free fuel
NL New car, Ee earning at the limit/became a director
SL Second car, Ee earning at the limit/became a director
RL Replacement car, Ee earning at the limit/became a director
NC Master data changes(New car)
SC Master data changes(Second car)
RC Master data changes(Replacment car)
FC Master data changes(Provided with free fuel)
LC Master data changes(Earning at the limit/Director)
ERR_COD Message number MSGNR T100 CHAR 3 0
MES_CLS Application Area ARBGB T100A CHAR 20 0
TAXYR HR-GB: Tax year (for reports) P08_TAXYR NUMC 4 0
ISSDATE HR-GB: P46-Form Date of Issue P08_AUSDT DATS 8 0
UNAME HR-GB: User Name P08_UNAME CHAR 40 0
CRDAT HR-GB: P46-Form Date of Creation P08_CRDAT DATS 8 0

T5G_P46ARV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T5G_P46ARV ERR_COD T5G_P46ARV MES_CLS T100 Messages ARBGB
T5G_P46ARV ERR_COD T5G_P46ARV ERR_COD T100 Messages MSGNR
T5G_P46ARV ERR_COD SYST LANGU T100 Messages SPRSL
T5G_P46ARV FACTO T5G_P46ARV MANDT T51C1 Car factory definition table MANDT
T5G_P46ARV FACTO T5G_P46ARV FACTO T51C1 Car factory definition table FACTO
T5G_P46ARV MES_CLS T5G_P46ARV MES_CLS T100A Message IDs for T100 ARBGB
T5G_P46ARV MODEL T5G_P46ARV MANDT T51C3 Car model definition table MANDT
T5G_P46ARV MODEL T5G_P46ARV FACTO T51C3 Car model definition table FACTO
T5G_P46ARV MODEL T5G_P46ARV MODEL T51C3 Car model definition table MODEL
T5G_P46ARV MODEL * T51C3 Car model definition table ENDDA
T5G_P46ARV PERNR T5G_P46ARV MANDT PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
T5G_P46ARV PERNR T5G_P46ARV PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
T5G_P46ARV RFACTO T5G_P46ARV MANDT T51C1 Car factory definition table MANDT
T5G_P46ARV RFACTO T5G_P46ARV RFACTO T51C1 Car factory definition table FACTO
T5G_P46ARV RMODEL T5G_P46ARV MANDT T51C3 Car model definition table MANDT
T5G_P46ARV RMODEL T5G_P46ARV FACTO T51C3 Car model definition table FACTO
T5G_P46ARV RMODEL T5G_P46ARV RMODEL T51C3 Car model definition table MODEL
T5G_P46ARV RMODEL * T51C3 Car model definition table ENDDA