SAP VDINSURE_ITEM0 Do Not Use: Insurance - Fields with Changeable Content Table

Overview

VDINSURE_ITEM0 is a standard SAP S/4HANA table that stores Do Not Use: Insurance - Fields with Changeable Content data. There are total 20 fields in the VDINSURE_ITEM0 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VDINSURE_ITEM0 belongs to Loans Management (FS-CML) module and is located in the package Obsolete Objects CML: Insurance Policies (FVVD_DELETE_INSURANCE).

In addition, following links provide an overview of foreign key relationships, if any, that link VDINSURE_ITEM0 to other SAP tables and standard CDS views available based on VDINSURE_ITEM0 table in S/4HANA 2020.

Techincal Settings of VDINSURE_ITEM0

Below are technical details of the table VDINSURE_ITEM0

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VDINSURE_ITEM0 Fields

The following table gives you an overview of the fields available in VDINSURE_ITEM0

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDT*CLNT3
GUIDGUID in 'RAW' formatGUID_16RAW16
DVALID_FROMStart of Term for Insurance PremiumTB_INS_ITEM_VALID_FROMDATS8
DVALID_TOEnd of Term for Insurance PremiumTB_INS_ITEM_VALID_TODATS8
PAYERPayer of Insurance PremiumTB_INS_PAYERBUT000CHAR10
PAYMENT_METHODPayment Method for InsuranceTB_INS_PAYMENT_METHOD*CHAR1
BANKIDBank Details IDTB_BVTYPCHAR4
XACCRUAL_METHODCalculation Method for InsuranceTB_INS_ACCRUAL_METHODCHAR1
PACCRUAL_FACTORPercentage Rate for Insurance CalculationTB_INS_ACCRUAL_FACTORDEC10
APAY_FREQUENCYFrequency in monthsAMMRHYNUMC3
DNEXT_PAY_DATENext Payment Due DateTB_INS_PAYMENT_DATEDATS8
BNEXT_PAY_AMOUNTNext Insurance PremiumTB_INS_PAYMENT_AMOUNTCURR13
WCURR_AMOUNTInsurance CurrencyTB_INS_CURR_PAYMENT_AMOUNTTCURCCUKY5
DSTATEMENT_DATEDate of Next BillTB_INS_STATEMENT_DATEDATS8
DLAST_STATEMENTDate of Last BillTB_INS_LAST_STATEMENT_DATEDATS8
RERFEntered ByRERFCHAR12
REHERSource of Initial EntryREHERCHAR10
RBEAREmployee IDRBEARCHAR12
RBHEREditing SourceRBHERCHAR10
IFLG_CHANGEDData Changed in Customer APPENDTB_INS_FLG_CUSTOM_CHANGEDCHAR1

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VDINSURE_ITEM0

Table NameFieldCardinalityCheck Table
VDINSURE_ITEM0PAYER:BUT000
VDINSURE_ITEM0WCURR_AMOUNT:TCURC

Other References