I_INSURPLCYLIFECOVERAGEVERSION
Life Coverage
I_INSURPLCYLIFECOVERAGEVERSION is a CDS View in S/4HANA. Life Coverage. It contains 60 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_InsurPolicyLifeCoverageTP | view_entity | from | TRANSACTIONAL | Life Coverage - TP |
Fields (60)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InsurPlcyApplUUID | InsurPlcyApplUUID,InsurPlcyApplUUIDForEdit | 1 |
| KEY | InsurPlcyCoverageID | InsurPlcyCoverageID,InsurPlcyCoverageIDForEdit | 1 |
| KEY | InsurPlcyCoveragePackageID | InsurPlcyCoveragePackageID,InsurPlcyCvPcgIDForEdit | 1 |
| KEY | InsurPlcyInsurContr | InsurPlcyInsurContr,InsurPlcyInsurContrForEdit | 1 |
| KEY | InsurPlcyUUID | InsurPlcyUUID,InsurPlcyUUIDForEdit | 1 |
| _Currency | _Currency | 1 | |
| InsPlcyCvrgElementaryProdType | InsPlcyCvrgElementaryProdType | 1 | |
| InsPlcyCvrgExtnOptnIsExercised | InsPlcyCvrgExtnOptnIsExercised | 1 | |
| InsPlcyCvrgInvestedFundAstAmt | InsPlcyCvrgInvestedFundAstAmt | 1 | |
| InsPlcyLifeCvrgGuaranteedOptn | InsPlcyLifeCvrgGuaranteedOptn | 1 | |
| InsPlcyLifeCvrgIsInvldInAdjmt | InsPlcyLifeCvrgIsInvldInAdjmt | 1 | |
| InsPlcyLifeCvrgIsYrlyRollover | InsPlcyLifeCvrgIsYrlyRollover | 1 | |
| InsPlcyLifeCvrgNrOfInsrdPersn | InsPlcyLifeCvrgNrOfInsrdPersn | 1 | |
| InsPlcyLifeCvrgOptnPhseEndDate | InsPlcyLifeCvrgOptnPhseEndDate | 1 | |
| InsPlcyLifeCvrgOptnPhseIsPosbl | InsPlcyLifeCvrgOptnPhseIsPosbl | 1 | |
| InsPlcyLifeCvrgOptnStrtAgeVal | InsPlcyLifeCvrgOptnStrtAgeVal | 1 | |
| InsPlcyLifeCvrgRskTypeIsDtmnd | InsPlcyLifeCvrgRskTypeIsDtmnd | 1 | |
| InsurPlcyBusinessObject | InsurPlcyBusinessObject | 1 | |
| InsurPlcyBusProcessNumerator | InsurPlcyBusProcessNumerator | 1 | |
| InsurPlcyBusProcType | InsurPlcyBusProcType | 1 | |
| InsurPlcyCvrgAnnuDisbmtType | InsurPlcyCvrgAnnuDisbmtType | 1 | |
| InsurPlcyCvrgDvdndAllcdDayMnth | InsurPlcyCvrgDvdndAllcdDayMnth | 1 | |
| InsurPlcyCvrgDvdndCrdtIsTrnsfd | InsurPlcyCvrgDvdndCrdtIsTrnsfd | 1 | |
| InsurPlcyCvrgFundDistrIsTrnsfd | InsurPlcyCvrgFundDistrIsTrnsfd | 1 | |
| InsurPlcyCvrgHasSuplmntyInsur | InsurPlcyCvrgHasSuplmntyInsur | 1 | |
| InsurPlcyCvrgIsExprtnIsExtd | InsurPlcyCvrgIsExprtnIsExtd | 1 | |
| InsurPlcyCvrgPrptySrrndrAmt | InsurPlcyCvrgPrptySrrndrAmt | 1 | |
| InsurPlcyCvrgUntLinkdInvmtDte | InsurPlcyCvrgUntLinkdInvmtDte | 1 | |
| InsurPlcyJrnlEndNmbr | InsurPlcyJrnlEndNmbr | 1 | |
| InsurPlcyJrnlNmbr | InsurPlcyJrnlNmbr | 1 | |
| InsurPlcyLifeCvrgAcctgVarAnnu | InsurPlcyLifeCvrgAcctgVarAnnu | 1 | |
| InsurPlcyLifeCvrgAnnuRcptType | InsurPlcyLifeCvrgAnnuRcptType | 1 | |
| InsurPlcyLifeCvrgBnftDvdndUsge | InsurPlcyLifeCvrgBnftDvdndUsge | 1 | |
| InsurPlcyLifeCvrgBusGrpIsDtmnd | InsurPlcyLifeCvrgBusGrpIsDtmnd | 1 | |
| InsurPlcyLifeCvrgCalcRuleType | InsurPlcyLifeCvrgCalcRuleType | 1 | |
| InsurPlcyLifeCvrgCurrency | InsurPlcyLifeCvrgCurrency | 1 | |
| InsurPlcyLifeCvrgFundAstMaxAmt | InsurPlcyLifeCvrgFundAstMaxAmt | 1 | |
| InsurPlcyLifeCvrgFundCrdtAmt | InsurPlcyLifeCvrgFundCrdtAmt | 1 | |
| InsurPlcyLifeCvrgFundCrdtPrpty | InsurPlcyLifeCvrgFundCrdtPrpty | 1 | |
| InsurPlcyLifeCvrgFundPaletteID | InsurPlcyLifeCvrgFundPaletteID | 1 | |
| InsurPlcyLifeCvrgFundRangeID | InsurPlcyLifeCvrgFundRangeID | 1 | |
| InsurPlcyLifeCvrgFundShiftID | InsurPlcyLifeCvrgFundShiftID | 1 | |
| InsurPlcyLifeCvrgIsCanceled | InsurPlcyLifeCvrgIsCanceled | 1 | |
| InsurPlcyLifeCvrgIsInOptnPhase | InsurPlcyLifeCvrgIsInOptnPhase | 1 | |
| InsurPlcyLifeCvrgIsSubjToTax | InsurPlcyLifeCvrgIsSubjToTax | 1 | |
| InsurPlcyLifeCvrgMaxNrOfShifts | InsurPlcyLifeCvrgMaxNrOfShifts | 1 | |
| InsurPlcyLifeCvrgMaxOptnPhseYr | InsurPlcyLifeCvrgMaxOptnPhseYr | 1 | |
| InsurPlcyLifeCvrgOption | InsurPlcyLifeCvrgOption | 1 | |
| InsurPlcyLifeCvrgOptnBeginDate | InsurPlcyLifeCvrgOptnBeginDate | 1 | |
| InsurPlcyLifeCvrgOptnFnlAgeVal | InsurPlcyLifeCvrgOptnFnlAgeVal | 1 | |
| InsurPlcyLifeCvrgOptnPhseInYr | InsurPlcyLifeCvrgOptnPhseInYr | 1 | |
| InsurPlcyLifeCvrgOptnPhseMnths | InsurPlcyLifeCvrgOptnPhseMnths | 1 | |
| InsurPlcyLifeCvrgPremExempt | InsurPlcyLifeCvrgPremExempt | 1 | |
| InsurPlcyLifeCvrgPremOblgn | InsurPlcyLifeCvrgPremOblgn | 1 | |
| InsurPlcyLifeCvrgSuprordCvrgID | InsurPlcyLifeCvrgSuprordCvrgID | 1 | |
| InsurPlcyLifeCvrgTgtFundRngeID | InsurPlcyLifeCvrgTgtFundRngeID | 1 | |
| InsurPlcyLifeCvrgWaitingPeriod | InsurPlcyLifeCvrgWaitingPeriod | 1 | |
| InsurPlcyOrderNumber | InsurPlcyOrderNumber | 1 | |
| InsurPlcyProductPackageID | InsurPlcyProductPackageID | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Life Coverage
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYLIFECOVERAGEVERSION (
INSURPLCYAPPLUUID,
INSURPLCYCOVERAGEID,
INSURPLCYCOVERAGEPACKAGEID,
INSURPLCYINSURCONTR,
INSURPLCYUUID,
_CURRENCY,
INSPLCYCVRGELEMENTARYPRODTYPE,
INSPLCYCVRGEXTNOPTNISEXERCISED,
INSPLCYCVRGINVESTEDFUNDASTAMT,
INSPLCYLIFECVRGGUARANTEEDOPTN,
INSPLCYLIFECVRGISINVLDINADJMT,
INSPLCYLIFECVRGISYRLYROLLOVER,
INSPLCYLIFECVRGNROFINSRDPERSN,
INSPLCYLIFECVRGOPTNPHSEENDDATE,
INSPLCYLIFECVRGOPTNPHSEISPOSBL,
INSPLCYLIFECVRGOPTNSTRTAGEVAL,
INSPLCYLIFECVRGRSKTYPEISDTMND,
INSURPLCYBUSINESSOBJECT,
INSURPLCYBUSPROCESSNUMERATOR,
INSURPLCYBUSPROCTYPE,
INSURPLCYCVRGANNUDISBMTTYPE,
INSURPLCYCVRGDVDNDALLCDDAYMNTH,
INSURPLCYCVRGDVDNDCRDTISTRNSFD,
INSURPLCYCVRGFUNDDISTRISTRNSFD,
INSURPLCYCVRGHASSUPLMNTYINSUR,
INSURPLCYCVRGISEXPRTNISEXTD,
INSURPLCYCVRGPRPTYSRRNDRAMT,
INSURPLCYCVRGUNTLINKDINVMTDTE,
INSURPLCYJRNLENDNMBR,
INSURPLCYJRNLNMBR,
INSURPLCYLIFECVRGACCTGVARANNU,
INSURPLCYLIFECVRGANNURCPTTYPE,
INSURPLCYLIFECVRGBNFTDVDNDUSGE,
INSURPLCYLIFECVRGBUSGRPISDTMND,
INSURPLCYLIFECVRGCALCRULETYPE,
INSURPLCYLIFECVRGCURRENCY,
INSURPLCYLIFECVRGFUNDASTMAXAMT,
INSURPLCYLIFECVRGFUNDCRDTAMT,
INSURPLCYLIFECVRGFUNDCRDTPRPTY,
INSURPLCYLIFECVRGFUNDPALETTEID,
INSURPLCYLIFECVRGFUNDRANGEID,
INSURPLCYLIFECVRGFUNDSHIFTID,
INSURPLCYLIFECVRGISCANCELED,
INSURPLCYLIFECVRGISINOPTNPHASE,
INSURPLCYLIFECVRGISSUBJTOTAX,
INSURPLCYLIFECVRGMAXNROFSHIFTS,
INSURPLCYLIFECVRGMAXOPTNPHSEYR,
INSURPLCYLIFECVRGOPTION,
INSURPLCYLIFECVRGOPTNBEGINDATE,
INSURPLCYLIFECVRGOPTNFNLAGEVAL,
INSURPLCYLIFECVRGOPTNPHSEINYR,
INSURPLCYLIFECVRGOPTNPHSEMNTHS,
INSURPLCYLIFECVRGPREMEXEMPT,
INSURPLCYLIFECVRGPREMOBLGN,
INSURPLCYLIFECVRGSUPRORDCVRGID,
INSURPLCYLIFECVRGTGTFUNDRNGEID,
INSURPLCYLIFECVRGWAITINGPERIOD,
INSURPLCYORDERNUMBER,
INSURPLCYPRODUCTPACKAGEID,
LASTCHANGEDATETIME,
PRIMARY KEY (INSURPLCYAPPLUUID, INSURPLCYCOVERAGEID, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYINSURCONTR, INSURPLCYUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA