I_INSURPLCYSURCHARGEDISCBASIC

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);