I_INSURPLCYPREMIUMVERSION

CDS View

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)

ViewTypeJoinVDMDescription
R_InsurancePolicyPremiumTP view_entity from TRANSACTIONAL Premium - TP

Fields (72)

KeyField CDS FieldsUsed 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)
);