I_INSURPLCYPREMIUMVERSION
Premium
I_INSURPLCYPREMIUMVERSION is a CDS View in S/4HANA. Premium. It contains 72 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_InsurancePolicyPremiumTP | view_entity | from | TRANSACTIONAL | Premium - TP |
Fields (72)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InsurancePolicyPremium | InsurancePolicyPremium,InsurancePolicyPremiumForEdit | 1 |
| KEY | InsurPlcyApplUUID | InsurPlcyApplUUID,InsurPlcyApplUUIDForEdit | 1 |
| KEY | InsurPlcyCoverageID | InsurPlcyCoverageID,InsurPlcyCoverageIDForEdit | 1 |
| KEY | InsurPlcyCoverageOptionID | InsurPlcyCoverageOptionID,InsurPlcyCvrgOptnIDForEdit | 1 |
| KEY | InsurPlcyCoveragePackageID | InsurPlcyCoveragePackageID,InsurPlcyCvPcgIDForEdit | 1 |
| KEY | InsurPlcyInsurContr | InsurPlcyInsurContr,InsurPlcyInsurContrForEdit | 1 |
| KEY | InsurPlcyInsuredObjectID | InsurPlcyInsrdObjIDForEdit,InsurPlcyInsuredObjectID | 1 |
| KEY | InsurPlcyUUID | InsurPlcyUUID,InsurPlcyUUIDForEdit | 1 |
| _Currency | _Currency | 1 | |
| InsPlcyPremAftTaxPrvsnlRptdAmt | InsPlcyPremAftTaxPrvsnlRptdAmt | 1 | |
| InsPlcyPremInstlmntSuplmntAmt | InsPlcyPremInstlmntSuplmntAmt | 1 | |
| InsPlcyPremMedlRskSurchrgAmt | InsPlcyPremMedlRskSurchrgAmt | 1 | |
| InsPlcyPremPrptnlDvdndClrgAmt | InsPlcyPremPrptnlDvdndClrgAmt | 1 | |
| InsurPerdPremAftTaxPaytAmt | InsurPerdPremAftTaxPaytAmt | 1 | |
| InsurPerdPremBfrTaxPaytAmt | InsurPerdPremBfrTaxPaytAmt | 1 | |
| InsurPlcyBusinessObject | InsurPlcyBusinessObject | 1 | |
| InsurPlcyBusProcessNumerator | InsurPlcyBusProcessNumerator | 1 | |
| InsurPlcyBusProcType | InsurPlcyBusProcType | 1 | |
| InsurPlcyCvrgIsPremiumExempt | InsurPlcyCvrgIsPremiumExempt | 1 | |
| InsurPlcyCvrgPremExmpEndDate | InsurPlcyCvrgPremExmpEndDate | 1 | |
| InsurPlcyJrnlEndNmbr | InsurPlcyJrnlEndNmbr | 1 | |
| InsurPlcyJrnlNmbr | InsurPlcyJrnlNmbr | 1 | |
| InsurPlcyMainDueDayMonth | InsurPlcyMainDueDayMonth | 1 | |
| InsurPlcyOrderNumber | InsurPlcyOrderNumber | 1 | |
| InsurPlcyPerdPremBfrTxPaytAmt | InsurPlcyPerdPremBfrTxPaytAmt | 1 | |
| InsurPlcyPremAnnGrssPremAmount | InsurPlcyPremAnnGrssPremAmount | 1 | |
| InsurPlcyPremBfrTaxEnteredAmt | InsurPlcyPremBfrTaxEnteredAmt | 1 | |
| InsurPlcyPremCollectionType | InsurPlcyPremCollectionType | 1 | |
| InsurPlcyPremCumltvTaxChrgsAmt | InsurPlcyPremCumltvTaxChrgsAmt | 1 | |
| InsurPlcyPremDiffDvdndClrgAmt | InsurPlcyPremDiffDvdndClrgAmt | 1 | |
| InsurPlcyPremDiffGrssPremAmt | InsurPlcyPremDiffGrssPremAmt | 1 | |
| InsurPlcyPremDiscAmount | InsurPlcyPremDiscAmount | 1 | |
| InsurPlcyPremDvdndClrgAmount | InsurPlcyPremDvdndClrgAmount | 1 | |
| InsurPlcyPremEntirePaytTotAmt | InsurPlcyPremEntirePaytTotAmt | 1 | |
| InsurPlcyPremFinalAgeVal | InsurPlcyPremFinalAgeVal | 1 | |
| InsurPlcyPremGrssPremBfrTxAmt | InsurPlcyPremGrssPremBfrTxAmt | 1 | |
| InsurPlcyPremInitPremAmount | InsurPlcyPremInitPremAmount | 1 | |
| InsurPlcyPremIntCrrtdAmount | InsurPlcyPremIntCrrtdAmount | 1 | |
| InsurPlcyPremIntPaymentMethod | InsurPlcyPremIntPaymentMethod | 1 | |
| InsurPlcyPremIsCanceled | InsurPlcyPremIsCanceled | 1 | |
| InsurPlcyPremIsManualRating | InsurPlcyPremIsManualRating | 1 | |
| InsurPlcyPremiumCurrency | InsurPlcyPremiumCurrency | 1 | |
| InsurPlcyPremiumTemplate | InsurPlcyPremiumTemplate | 1 | |
| InsurPlcyPremLineOfBusiness | InsurPlcyPremLineOfBusiness | 1 | |
| InsurPlcyPremMappgInfo | InsurPlcyPremMappgInfo | 1 | |
| InsurPlcyPremNetYrlyPremAmount | InsurPlcyPremNetYrlyPremAmount | 1 | |
| InsurPlcyPremNonMedlSuDscAmt | InsurPlcyPremNonMedlSuDscAmt | 1 | |
| InsurPlcyPremOthRskSurchrgAmt | InsurPlcyPremOthRskSurchrgAmt | 1 | |
| InsurPlcyPremPaytFrqcyStrtDate | InsurPlcyPremPaytFrqcyStrtDate | 1 | |
| InsurPlcyPremPaytPeriodEndDate | InsurPlcyPremPaytPeriodEndDate | 1 | |
| InsurPlcyPremRatePrvsnlRptdPct | InsurPlcyPremRatePrvsnlRptdPct | 1 | |
| InsurPlcyPremRateUntForMnlRatg | InsurPlcyPremRateUntForMnlRatg | 1 | |
| InsurPlcyPremRndngCrrtnAmount | InsurPlcyPremRndngCrrtnAmount | 1 | |
| InsurPlcyPremSftySurchrgAmount | InsurPlcyPremSftySurchrgAmount | 1 | |
| InsurPlcyPremStartDate | InsurPlcyPremStartDate | 1 | |
| InsurPlcyPremSuDscTotAmount | InsurPlcyPremSuDscTotAmount | 1 | |
| InsurPlcyPremSuDscYearlyAmount | InsurPlcyPremSuDscYearlyAmount | 1 | |
| InsurPlcyPremSumInsuredRate | InsurPlcyPremSumInsuredRate | 1 | |
| InsurPlcyPremToBeTaxedAmount | InsurPlcyPremToBeTaxedAmount | 1 | |
| InsurPlcyPremTotDiscountAmount | InsurPlcyPremTotDiscountAmount | 1 | |
| InsurPlcyPremTotTrifPremAmount | InsurPlcyPremTotTrifPremAmount | 1 | |
| InsurPlcyPremTrifPerUnitSumAmt | InsurPlcyPremTrifPerUnitSumAmt | 1 | |
| InsurPlcyPremTrifPremAmount | InsurPlcyPremTrifPremAmount | 1 | |
| InsurPlcyPremTrifPremPrptnlAmt | InsurPlcyPremTrifPremPrptnlAmt | 1 | |
| InsurPlcyPremUnitCostAmount | InsurPlcyPremUnitCostAmount | 1 | |
| InsurPlcyPremWvrAnnulmentRsn | InsurPlcyPremWvrAnnulmentRsn | 1 | |
| InsurPlcyPremYrlyPremAmount | InsurPlcyPremYrlyPremAmount | 1 | |
| InsurPlcyProductPackageID | InsurPlcyProductPackageID | 1 | |
| InsurPlcyTotAnnPremAmt | InsurPlcyTotAnnPremAmt | 1 | |
| InsurPremSpecPaytRcrrcFrqcy | InsurPremSpecPaytRcrrcFrqcy | 1 | |
| InsurPremType | InsurPremType | 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.
-- Premium
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYPREMIUMVERSION (
INSURANCEPOLICYPREMIUM,
INSURPLCYAPPLUUID,
INSURPLCYCOVERAGEID,
INSURPLCYCOVERAGEOPTIONID,
INSURPLCYCOVERAGEPACKAGEID,
INSURPLCYINSURCONTR,
INSURPLCYINSUREDOBJECTID,
INSURPLCYUUID,
_CURRENCY,
INSPLCYPREMAFTTAXPRVSNLRPTDAMT,
INSPLCYPREMINSTLMNTSUPLMNTAMT,
INSPLCYPREMMEDLRSKSURCHRGAMT,
INSPLCYPREMPRPTNLDVDNDCLRGAMT,
INSURPERDPREMAFTTAXPAYTAMT,
INSURPERDPREMBFRTAXPAYTAMT,
INSURPLCYBUSINESSOBJECT,
INSURPLCYBUSPROCESSNUMERATOR,
INSURPLCYBUSPROCTYPE,
INSURPLCYCVRGISPREMIUMEXEMPT,
INSURPLCYCVRGPREMEXMPENDDATE,
INSURPLCYJRNLENDNMBR,
INSURPLCYJRNLNMBR,
INSURPLCYMAINDUEDAYMONTH,
INSURPLCYORDERNUMBER,
INSURPLCYPERDPREMBFRTXPAYTAMT,
INSURPLCYPREMANNGRSSPREMAMOUNT,
INSURPLCYPREMBFRTAXENTEREDAMT,
INSURPLCYPREMCOLLECTIONTYPE,
INSURPLCYPREMCUMLTVTAXCHRGSAMT,
INSURPLCYPREMDIFFDVDNDCLRGAMT,
INSURPLCYPREMDIFFGRSSPREMAMT,
INSURPLCYPREMDISCAMOUNT,
INSURPLCYPREMDVDNDCLRGAMOUNT,
INSURPLCYPREMENTIREPAYTTOTAMT,
INSURPLCYPREMFINALAGEVAL,
INSURPLCYPREMGRSSPREMBFRTXAMT,
INSURPLCYPREMINITPREMAMOUNT,
INSURPLCYPREMINTCRRTDAMOUNT,
INSURPLCYPREMINTPAYMENTMETHOD,
INSURPLCYPREMISCANCELED,
INSURPLCYPREMISMANUALRATING,
INSURPLCYPREMIUMCURRENCY,
INSURPLCYPREMIUMTEMPLATE,
INSURPLCYPREMLINEOFBUSINESS,
INSURPLCYPREMMAPPGINFO,
INSURPLCYPREMNETYRLYPREMAMOUNT,
INSURPLCYPREMNONMEDLSUDSCAMT,
INSURPLCYPREMOTHRSKSURCHRGAMT,
INSURPLCYPREMPAYTFRQCYSTRTDATE,
INSURPLCYPREMPAYTPERIODENDDATE,
INSURPLCYPREMRATEPRVSNLRPTDPCT,
INSURPLCYPREMRATEUNTFORMNLRATG,
INSURPLCYPREMRNDNGCRRTNAMOUNT,
INSURPLCYPREMSFTYSURCHRGAMOUNT,
INSURPLCYPREMSTARTDATE,
INSURPLCYPREMSUDSCTOTAMOUNT,
INSURPLCYPREMSUDSCYEARLYAMOUNT,
INSURPLCYPREMSUMINSUREDRATE,
INSURPLCYPREMTOBETAXEDAMOUNT,
INSURPLCYPREMTOTDISCOUNTAMOUNT,
INSURPLCYPREMTOTTRIFPREMAMOUNT,
INSURPLCYPREMTRIFPERUNITSUMAMT,
INSURPLCYPREMTRIFPREMAMOUNT,
INSURPLCYPREMTRIFPREMPRPTNLAMT,
INSURPLCYPREMUNITCOSTAMOUNT,
INSURPLCYPREMWVRANNULMENTRSN,
INSURPLCYPREMYRLYPREMAMOUNT,
INSURPLCYPRODUCTPACKAGEID,
INSURPLCYTOTANNPREMAMT,
INSURPREMSPECPAYTRCRRCFRQCY,
INSURPREMTYPE,
LASTCHANGEDATETIME,
PRIMARY KEY (INSURANCEPOLICYPREMIUM, INSURPLCYAPPLUUID, INSURPLCYCOVERAGEID, INSURPLCYCOVERAGEOPTIONID, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYINSURCONTR, INSURPLCYINSUREDOBJECTID, 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