I_INSURPLCYSUBCOVERAGEBASIC

CDS View

SubCoverage in Insurance Policy

I_INSURPLCYSUBCOVERAGEBASIC is a CDS View in S/4HANA. SubCoverage in Insurance Policy. It contains 17 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_InsOpApContrCvrgSubCoverage view_entity from COMPOSITE Cvrg SubCoverage of Contr in InsOpenAppl
I_InsurApplContrCvrgSubCvrg view_entity inner COMPOSITE Cvrg SubCoverage of Contr in Insur Appl
I_InsurApplSubCoverage view_entity inner COMPOSITE Cvrg SubCoverage of CvPcg in Insur Appl
I_InsurOpenApplSubCoverage view_entity from COMPOSITE Cvrg SubCoverage of CvPcg in InsOpenAppl
I_InsurPlcyContrCvrgSubCvrg view_entity from COMPOSITE Cvrg SubCoverage of Contr in Insur Plcy
I_InsurPlcySubCoverage view_entity from COMPOSITE Cvrg SubCoverage of CvPcg in Insur Plcy
P_InsurOpenApplSubCoverage view_entity from COMPOSITE
P_InsurOpenApplSubCoverage view_entity union COMPOSITE
R_InsurPlcySubcoverageTP_2 view_entity from TRANSACTIONAL Subcoverage

Fields (17)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyCoverageID InsurPlcyCoverageID 7
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID 7
KEY InsurPlcyInsurContr InsurPlcyInsurContr 7
KEY InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 7
KEY InsurPlcySubCvrgID InsurPlcySubCvrgID 7
KEY InsurPlcyUUID InsurPlcyUUID 4
InsurPlcyInsuranceSubCoverage InsurPlcyInsuranceSubCoverage 6
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 6
InsurPlcyProductPackageID InsurPlcyProductPackageID 6
InsurPlcySubCoverageCurrency InsurPlcySubCoverageCurrency 6
InsurPlcySubCoverageEndDate InsurPlcySubCoverageEndDate 6
InsurPlcySubCoverageStartDate InsurPlcySubCoverageStartDate 6
InsurPlcySubCoverageTemplate InsurPlcySubCoverageTemplate 6
InsurPlcySubCvrgInsrdSumAmount InsurPlcySubCvrgInsrdSumAmount 6
InsurPlcySubCvrgInsrdSumCalc InsurPlcySubCvrgInsrdSumCalc 6
InsurPlcySubCvrgInsuredSumPct InsurPlcySubCvrgInsuredSumPct 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.

-- SubCoverage in Insurance Policy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYSUBCOVERAGEBASIC (
    INSURPLCYCOVERAGEID,
    INSURPLCYCOVERAGEPACKAGEID,
    INSURPLCYINSURCONTR,
    INSURPLCYJRNLNMBR,
    INSURPLCYSUBCVRGID,
    INSURPLCYUUID,
    INSURPLCYINSURANCESUBCOVERAGE,
    INSURPLCYJRNLENDNMBR,
    INSURPLCYPRODUCTPACKAGEID,
    INSURPLCYSUBCOVERAGECURRENCY,
    INSURPLCYSUBCOVERAGEENDDATE,
    INSURPLCYSUBCOVERAGESTARTDATE,
    INSURPLCYSUBCOVERAGETEMPLATE,
    INSURPLCYSUBCVRGINSRDSUMAMOUNT,
    INSURPLCYSUBCVRGINSRDSUMCALC,
    INSURPLCYSUBCVRGINSUREDSUMPCT,
    LASTCHANGEDATETIME,
    PRIMARY KEY (INSURPLCYCOVERAGEID, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYINSURCONTR, INSURPLCYJRNLNMBR, INSURPLCYSUBCVRGID, INSURPLCYUUID)
);