I_INSURPLCYLIMITBASIC

CDS View

Limit in Insurance Policy

I_INSURPLCYLIMITBASIC is a CDS View in S/4HANA. Limit in Insurance Policy. It contains 13 fields. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
I_InsOpApContrSubCoverageLimit view_entity from COMPOSITE SubCoverage Limit of Contr in InsOpAppl
I_InsurancePolicyContrLimit view_entity from COMPOSITE Contract Limit in Insurance Policy
I_InsurancePolicyCvrgLimit view_entity from COMPOSITE Cvrg Limit of Cvrg Pckg in Insur Plcy
I_InsurancePolicyLimit view_entity from COMPOSITE SubCoverage Limit of CvPcg in Plcy
I_InsurApplContrCvrgLimit view_entity inner COMPOSITE Coverage Limit of Contract in Insur Appl
I_InsurApplContrLimit view_entity inner COMPOSITE Contract Limit in Insurance Application
I_InsurApplContrSubCvrgLimit view_entity inner COMPOSITE SubCoverage Limit of Contr in Insur Appl
I_InsurApplCoverageLimit view_entity inner COMPOSITE Cvrg Limit of Cvrg Pckg in Insur Appl
I_InsurApplLimit view_entity inner COMPOSITE SubCoverage Limit of CvPcg in Appl
I_InsurOpenApplContractLimit view_entity from COMPOSITE Contract Limit in InsurOpenAppl
I_InsurOpenApplContrCvrgLimit view_entity from COMPOSITE Coverage Limit of Contract in InsOpAppl
I_InsurOpenApplCoverageLimit view_entity from COMPOSITE Cvrg Limit of Cvrg Pckg in InsurOpenAppl
I_InsurOpenApplLimit view_entity from COMPOSITE SubCoverage Limit of CvPcg in InsOpAppl
I_InsurPlcyContrCvrgLimit view_entity from COMPOSITE Coverage Limit of Contract in Insur Plcy
I_InsurPlcyContrSubCvrgLimit view_entity from COMPOSITE SubCoverage Limit of Contr in Insur Plcy
P_InsurOpenApplLimit view_entity from COMPOSITE Insurance Open Application Limit
P_InsurOpenApplLimit view_entity union COMPOSITE Insurance Open Application Limit
R_InsurPlcyContractLimitTP_2 view_entity from TRANSACTIONAL Limit under Contract
R_InsurPlcyCvrgLimitTP_2 view_entity from TRANSACTIONAL Limit under Coverage
R_InsurPlcySbcvrgLimitTP view_entity from TRANSACTIONAL Limit under Subcoverage

Fields (13)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyCoverageID InsurPlcyCoverageID 16
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID 16
KEY InsurPlcyInsurContr InsurPlcyInsurContr 16
KEY InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 16
KEY InsurPlcyLimitID InsurPlcyLimitID 16
KEY InsurPlcySubCvrgID InsurPlcySubCvrgID 16
KEY InsurPlcyUUID InsurPlcyUUID 10
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 15
InsurPlcyLimitAmount InsurPlcyLimitAmount 15
InsurPlcyLimitCurrency InsurPlcyLimitCurrency 15
InsurPlcyLimitTemplate InsurPlcyLimitTemplate 15
InsurPlcyProductPackageID InsurPlcyProductPackageID 15
LastChangeDateTime LastChangeDateTime 15

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.

-- Limit in Insurance Policy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYLIMITBASIC (
    INSURPLCYCOVERAGEID,
    INSURPLCYCOVERAGEPACKAGEID,
    INSURPLCYINSURCONTR,
    INSURPLCYJRNLNMBR,
    INSURPLCYLIMITID,
    INSURPLCYSUBCVRGID,
    INSURPLCYUUID,
    INSURPLCYJRNLENDNMBR,
    INSURPLCYLIMITAMOUNT,
    INSURPLCYLIMITCURRENCY,
    INSURPLCYLIMITTEMPLATE,
    INSURPLCYPRODUCTPACKAGEID,
    LASTCHANGEDATETIME,
    PRIMARY KEY (INSURPLCYCOVERAGEID, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYINSURCONTR, INSURPLCYJRNLNMBR, INSURPLCYLIMITID, INSURPLCYSUBCVRGID, INSURPLCYUUID)
);