I_INSURPLCYPREMIUMCOMPRNBASIC

CDS View
23 Fields 8 CDS Views

Premium Comparison in Insurance Policy

I_INSURPLCYPREMIUMCOMPRNBASIC is a CDS View in S/4HANA. Premium Comparison in Insurance Policy. It contains 23 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_InsOpApContrCvrgPremComprn view_entity from COMPOSITE Cvrg Prem Comprn of Contr in InsurOpAp
I_InsOpApCvrgPremComparison view_entity from COMPOSITE Cvrg Prem Comprn of Cvrg Pckg in InsOpAp
I_InsurApplContrCvrgPremComprn view_entity inner COMPOSITE Cvrg Prem Comprn of Contr in Insur Appl
I_InsurApplCvrgPremComparison view_entity inner COMPOSITE Cv Prem Comprn of Cv Pckg in Insur Appl
I_InsurPlcyContrCvrgPremComprn view_entity from COMPOSITE Cvrg Prem Comprn of Contr in Insur Plcy
I_InsurPlcyCvrgPremComparison view_entity from COMPOSITE Cv Prem Comprn of Cv Pckg in Insur Plcy
P_InsurOpenApplPremComparison view_entity from COMPOSITE
P_InsurOpenApplPremComparison view_entity union COMPOSITE

Fields (23)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyCoverageID InsurPlcyCoverageID 7
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID 7
KEY InsurPlcyInsurContr InsurPlcyInsurContr 7
KEY InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 7
KEY InsurPlcyPremiumComparisonID InsurPlcyPremiumComparisonID 7
KEY InsurPlcyUUID InsurPlcyUUID 4
InsurPlcyComprnAnnPremAmount InsurPlcyComprnAnnPremAmount 6
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 6
InsurPlcyNewAnnPremiumAmount InsurPlcyNewAnnPremiumAmount 6
InsurPlcyNewIntPremiumLevel InsurPlcyNewIntPremiumLevel 6
InsurPlcyNewIntPremiumRate InsurPlcyNewIntPremiumRate 6
InsurPlcyNewRegionalClass InsurPlcyNewRegionalClass 6
InsurPlcyNewTypeClass InsurPlcyNewTypeClass 6
InsurPlcyPremComprnTemplate InsurPlcyPremComprnTemplate 6
InsurPlcyPremiumCurrency InsurPlcyPremiumCurrency 6
InsurPlcyPremiumIsIncreased InsurPlcyPremiumIsIncreased 6
InsurPlcyPrevAnnPremiumAmount InsurPlcyPrevAnnPremiumAmount 6
InsurPlcyPrevIntPremiumLevel InsurPlcyPrevIntPremiumLevel 6
InsurPlcyPrevIntPremiumRate InsurPlcyPrevIntPremiumRate 6
InsurPlcyPreviousRegionalClass InsurPlcyPreviousRegionalClass 6
InsurPlcyPreviousTypeClass InsurPlcyPreviousTypeClass 6
InsurPlcyProductPackageID InsurPlcyProductPackageID 6
LastChangeDateTime LastChangeDateTime 6

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 Comparison in Insurance Policy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYPREMIUMCOMPRNBASIC (
    INSURPLCYCOVERAGEID,
    INSURPLCYCOVERAGEPACKAGEID,
    INSURPLCYINSURCONTR,
    INSURPLCYJRNLNMBR,
    INSURPLCYPREMIUMCOMPARISONID,
    INSURPLCYUUID,
    INSURPLCYCOMPRNANNPREMAMOUNT,
    INSURPLCYJRNLENDNMBR,
    INSURPLCYNEWANNPREMIUMAMOUNT,
    INSURPLCYNEWINTPREMIUMLEVEL,
    INSURPLCYNEWINTPREMIUMRATE,
    INSURPLCYNEWREGIONALCLASS,
    INSURPLCYNEWTYPECLASS,
    INSURPLCYPREMCOMPRNTEMPLATE,
    INSURPLCYPREMIUMCURRENCY,
    INSURPLCYPREMIUMISINCREASED,
    INSURPLCYPREVANNPREMIUMAMOUNT,
    INSURPLCYPREVINTPREMIUMLEVEL,
    INSURPLCYPREVINTPREMIUMRATE,
    INSURPLCYPREVIOUSREGIONALCLASS,
    INSURPLCYPREVIOUSTYPECLASS,
    INSURPLCYPRODUCTPACKAGEID,
    LASTCHANGEDATETIME,
    PRIMARY KEY (INSURPLCYCOVERAGEID, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYINSURCONTR, INSURPLCYJRNLNMBR, INSURPLCYPREMIUMCOMPARISONID, INSURPLCYUUID)
);

Learn More