I_INSURPLCYLIMITBASIC
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
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