I_INSURPLCYSURCHARGEDISCBASIC
Surcharge Discount in Insurance Policy
I_INSURPLCYSURCHARGEDISCBASIC is a CDS View in S/4HANA. Surcharge Discount in Insurance Policy. It contains 19 fields. 30 CDS views read from this table.
CDS Views using this table (30)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsOpApContrCvrgObjSurcharge | view_entity | from | COMPOSITE | Cvrg InsOb SurDsc of Contr in InsOpAppl |
| I_InsOpApContrCvrgSurcharge | view_entity | from | COMPOSITE | Cvrg Surchrg Disc of Contr in InsOpAppl |
| I_InsOpApContrObjSurchrgDisc | view_entity | from | COMPOSITE | InsOb SurchrgDisc of Contr in InsOpAppl |
| I_InsOpApContrSurchrgDiscount | view_entity | from | COMPOSITE | Contr Surchrg Discount in InsurOpenAppl |
| I_InsOpApCvrgObjSurchrgDisc | view_entity | from | COMPOSITE | InsOb SurDsc of Cvrg under CvPcg in OpAp |
| I_InsOpApCvrgPckgSurchrgDisc | view_entity | from | COMPOSITE | CvPckg SurDisc of Contr in InsurOpenAppl |
| I_InsOpApCvrgSurchrgDiscount | view_entity | from | COMPOSITE | Cvrg Surchrg Disc of CvPcg in InsOpAppl |
| I_InsurApplContrCvrgObjSurchrg | view_entity | inner | COMPOSITE | Cvrg InsOb SurDsc of Contr in Insur Appl |
| I_InsurApplContrCvrgSurcharge | view_entity | inner | COMPOSITE | Cvrg Surchrg Disc of Contr in Insur Appl |
| I_InsurApplContrObjSurchrgDisc | view_entity | inner | COMPOSITE | InsOb SurDsc of Contr in Insur Appl |
| I_InsurApplContrSurchrgDisc | view_entity | inner | COMPOSITE | Contr Surchrg Discount in Insur Appl |
| I_InsurApplCvrgObjSurchrgDisc | view_entity | inner | COMPOSITE | InsOb SurDsc of Cvrg under CvPcg in Appl |
| I_InsurApplCvrgPckgSurchrgDisc | view_entity | inner | COMPOSITE | CvPcg SurDsc of Contr in Insur Appl |
| I_InsurApplCvrgSurchrgDiscount | view_entity | inner | COMPOSITE | Cvrg Surchrg Disc of CvPcg in Insur Appl |
| I_InsurApplSurchargeDiscount | view_entity | inner | COMPOSITE | InsOb SurDsc of CvPcg in Insur Appl |
| I_InsurOpenApplSurchrgDiscount | view_entity | from | COMPOSITE | InsOb SurDsc of CvrPcg in InsOpenAppl |
| I_InsurPlcyContrCvrgObjSurchrg | view_entity | from | COMPOSITE | Cvrg InsOb SurDsc of Contr in Insur Plcy |
| I_InsurPlcyContrCvrgSurcharge | view_entity | from | COMPOSITE | Cvrg Surchrg Disc of Contr in Insur Plcy |
| I_InsurPlcyContrObjSurchrgDisc | view_entity | from | COMPOSITE | InsOb SurDsc of Contr in Insur Plcy |
| I_InsurPlcyContrSurchrgDisc | view_entity | from | COMPOSITE | Contr Surchrg Discount in Insur Plcy |
| I_InsurPlcyCvrgObjSurchrgDisc | view_entity | from | COMPOSITE | InsOb SurDsc of Cvrg under CvPcg in Plcy |
| I_InsurPlcyCvrgPckgSurchrgDisc | view_entity | from | COMPOSITE | CvPcg SurDsc of Contr in Insur Plcy |
| I_InsurPlcyCvrgSurchrgDiscount | view_entity | from | COMPOSITE | Cvrg Surchrg Disc of CvPcg in Insur Plcy |
| I_InsurPolicySurchargeDiscount | view_entity | from | COMPOSITE | InsOb SurDsc of CvPcg in Insur Plcy |
| P_InsurOpenApplSurchrgDiscount | view_entity | from | COMPOSITE | |
| P_InsurOpenApplSurchrgDiscount | view_entity | union | COMPOSITE | |
| R_InsurPlcyContrSuDscTP | view_entity | from | TRANSACTIONAL | Surcharge or Discount under Contract |
| R_InsurPlcyCvPcgCvrgSuDscTP | view_entity | from | TRANSACTIONAL | Surcharge or Discount under CVPackage CV |
| R_InsurPlcyCvPcgSuDscTP_2 | view_entity | from | TRANSACTIONAL | Surcharge or Discount under CVPackage |
| R_InsurPlcyCvrgSuDscTP | view_entity | from | TRANSACTIONAL | Surcharge or Discount under Coverage |
Fields (19)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InsurPlcyCoverageID | InsurPlcyCoverageID | 25 |
| KEY | InsurPlcyCoveragePackageID | InsurPlcyCoveragePackageID | 25 |
| KEY | InsurPlcyInsurContr | InsurPlcyInsurContr | 25 |
| KEY | InsurPlcyInsuredObjectID | InsurPlcyInsuredObjectID | 25 |
| KEY | InsurPlcyJrnlNmbr | InsurPlcyJrnlNmbr | 25 |
| KEY | InsurPlcySurchargeDiscID | InsurPlcySurchargeDiscID | 25 |
| KEY | InsurPlcyUUID | InsurPlcyUUID | 16 |
| InsurPlcyJrnlEndNmbr | InsurPlcyJrnlEndNmbr | 24 | |
| InsurPlcyProductPackageID | InsurPlcyProductPackageID | 24 | |
| InsurPlcySurchargeDiscAmount | InsurPlcySurchargeDiscAmount | 24 | |
| InsurPlcySurchargeDiscEndDate | InsurPlcySurchargeDiscEndDate | 24 | |
| InsurPlcySurchargeDiscStrtDate | InsurPlcySurchargeDiscStrtDate | 24 | |
| InsurPlcySurchargeDiscTypeID | InsurPlcySurchargeDiscTypeID | 24 | |
| InsurPlcySurchrgDiscAmtType | InsurPlcySurchrgDiscAmtType | 24 | |
| InsurPlcySurchrgDiscAmtUnit | InsurPlcySurchrgDiscAmtUnit | 24 | |
| InsurPlcySurchrgDiscBaseAmtPct | InsurPlcySurchrgDiscBaseAmtPct | 24 | |
| InsurPlcySurchrgDiscCurrency | InsurPlcySurchrgDiscCurrency | 24 | |
| InsurPlcySurchrgDiscTemplate | InsurPlcySurchrgDiscTemplate | 24 | |
| LastChangeDateTime | LastChangeDateTime | 24 |
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.
-- Surcharge Discount in Insurance Policy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYSURCHARGEDISCBASIC (
INSURPLCYCOVERAGEID,
INSURPLCYCOVERAGEPACKAGEID,
INSURPLCYINSURCONTR,
INSURPLCYINSUREDOBJECTID,
INSURPLCYJRNLNMBR,
INSURPLCYSURCHARGEDISCID,
INSURPLCYUUID,
INSURPLCYJRNLENDNMBR,
INSURPLCYPRODUCTPACKAGEID,
INSURPLCYSURCHARGEDISCAMOUNT,
INSURPLCYSURCHARGEDISCENDDATE,
INSURPLCYSURCHARGEDISCSTRTDATE,
INSURPLCYSURCHARGEDISCTYPEID,
INSURPLCYSURCHRGDISCAMTTYPE,
INSURPLCYSURCHRGDISCAMTUNIT,
INSURPLCYSURCHRGDISCBASEAMTPCT,
INSURPLCYSURCHRGDISCCURRENCY,
INSURPLCYSURCHRGDISCTEMPLATE,
LASTCHANGEDATETIME,
PRIMARY KEY (INSURPLCYCOVERAGEID, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYINSURCONTR, INSURPLCYINSUREDOBJECTID, INSURPLCYJRNLNMBR, INSURPLCYSURCHARGEDISCID, 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