/MVA/AMDVMLMAIN - Inquiry and Notification Records for Malus File
Inquiry and Notification Records for Malus File information is stored in SAP table /MVA/AMDVMLMAIN.
It is part of development package /MVA/AMVM_DBA in software component FS-PMA. This development package consists of objects that can be grouped under "FS-PM Auto: Malus File Data Access Layer".
It is part of development package /MVA/AMVM_DBA in software component FS-PMA. This development package consists of objects that can be grouped under "FS-PM Auto: Malus File Data Access Layer".
Fields for table /MVA/AMDVMLMAIN
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | /MVA/AMKVMALUS | 0 | |||
| CLIENT | Client | X | MANDT | CLNT | 6 | * |
| REC_ID | Sequence Number of the Record | X | /MVA/AMD_REC_VL | NUMC | 16 | |
| .INCLUDE | /MVA/AMAVMALUS | 0 | ||||
| INSURER_ID | Four-Digit Number of Insurance Company | /MVA/AMD_INSURER_ID | CHAR | 8 | ||
| OFFICE_ID | Number of the Insurance Company Branch Office | /MVA/AMD_OFFICE_ID | NUMC | 6 | ||
| POLICY_TT | Insurance Policy Number | /MVA/AMD_POLICY_TT | CHAR | 34 | ||
| APPLNR_TT | Contract Number | /MVA/AMD_APPLNR_TT | CHAR | 34 | ||
| BM_ID | Key of the Bonus-Malus | /MVA/AMD_BM_ID | NUMC | 20 | ||
| NAME_TT | Policyholder's Last Name | /MVA/AMD_NAME_TT | CHAR | 50 | ||
| FIRST_NAME_TT | Policyholder's First Name | /MVA/AMD_FIRST_NAME_TT | CHAR | 30 | ||
| STREET_TT | Street of the Policyholder's Address | /MVA/AMD_STREET_TT | CHAR | 40 | ||
| CITY_TT | City of the Policyholder's Address | /MVA/AMD_CITY_TT | CHAR | 40 | ||
| LICENCE_TT | License Plate of Insurable Object | /MVA/AMD_LICENCE_ID | CHAR | 24 | ||
| CANCEL_DT | Date of the Contract Reversal at the Reporting Insurer | /MVA/AMD_CANCEL_ID | DATS | 16 | ||
| CLASS_ID | Claim-Free Class at Reporting Insurance Company | /MVA/AMD_CLASS_ID | NUMC | 4 | ||
| NO_OF_CLAIMS_VL | Number of Claims Displayed in Reporting Year | /MVA/AMD_CLAIMS_ID | NUMC | 4 | ||
| MODIF_TP | Change Type | /MVA/AMD_MODIF_TP | NUMC | 2 | ||
| MODIF_DT | Change Date | /MVA/AMD_MODIF_DT | DATS | 16 | ||
| REC_TP | Record Type at the German Insurance Association | /MVA/AMD_REC_TP | NUMC | 4 | ||
| .INCLUDE | /MVA/AMAVMALMGR | 0 | ||||
| DELIVERY_VL | Number of the Delivery in which Record Was Transferred | /MVA/AMD_DELIVERY_VL | NUMC | 8 | ||
| DELIVERY_DT | Date Record Delivered to German Insurance Association | /MVA/AMD_DELIVERY_DT | DATS | 16 | ||
| POLICY_ID | Obsolete (GUID) | /PM0/ABD_OBSOLETE3 | CHAR | 44 | ||
| BP_ID | Business Partner Key | /MVA/AMD_BP_ID | CHAR | 20 | ||
| .INCLUDE | /MVA/AMAATMSTMP | 0 | ||||
| CHANGEUSR_TT | User Name of Last Person To Change Entry | /MVA/AMD_CHANGEUSR_TT | CHAR | 24 | * | |
| CHANGE_TS | UTC Time Stamp of Last Change | /PM0/ABD_CHANGE_TS | DEC | 11 | ||
| RECORDUSR_TT | User Name of Creator of Entry | /MVA/AMD_RECORDUSR_TT | CHAR | 24 | * | |
| RECORD_TS | UTC Time Stamp for Entry | /PM0/ABD_RECORD_TS | DEC | 11 |