I_INSURPLCYADJUSTMENTBASIC

CDS View
79 Fields 6 CDS Views

Adjustment in Insurance Policy

I_INSURPLCYADJUSTMENTBASIC is a CDS View in S/4HANA. Adjustment in Insurance Policy. It contains 79 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_InsurPlcyAdjustmentVersion view_entity from COMPOSITE Adjustment
I_InsurPlcyAdjustmentVersion view_entity union COMPOSITE Adjustment
P_InsurPlcyAdjmtLoadJrnlId view_entity inner COMPOSITE
R_InsurPlcyContrAdjustmentTP view_entity from TRANSACTIONAL Adjustment under Contract
R_InsurPlcyCvPcgCvrgAdjmtTP view_entity from TRANSACTIONAL Adjustment under CVPackage CV
R_InsurPlcyCvrgAdjustmentTP view_entity from TRANSACTIONAL Adjustment under Coverage

Fields (79)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyCoverageID InsurPlcyCoverageID 1
KEY InsurPlcyCoverageOptionID InsurPlcyCoverageOptionID 1
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID 1
KEY InsurPlcyInsuredObjectID InsurPlcyInsuredObjectID 1
KEY InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 2
_Currency _Currency 1
InsurPlcyAdjmtAmount InsurPlcyAdjmtAmount 1
InsurPlcyAdjmtCreateIndexType InsurPlcyAdjmtCreateIndexType 1
InsurPlcyAdjmtCurIdxAmount InsurPlcyAdjmtCurIdxAmount 1
InsurPlcyAdjmtCurIdxPos InsurPlcyAdjmtCurIdxPos 1
InsurPlcyAdjmtCurIncrPercent InsurPlcyAdjmtCurIncrPercent 1
InsurPlcyAdjmtCurrency InsurPlcyAdjmtCurrency 1
InsurPlcyAdjmtEndDate InsurPlcyAdjmtEndDate 1
InsurPlcyAdjmtExprtnAgeValue InsurPlcyAdjmtExprtnAgeValue 1
InsurPlcyAdjmtFirstIdxEndDate InsurPlcyAdjmtFirstIdxEndDate 1
InsurPlcyAdjmtFirstIdxPosID InsurPlcyAdjmtFirstIdxPosID 1
InsurPlcyAdjmtFirstIdxStrtDte InsurPlcyAdjmtFirstIdxStrtDte 1
InsurPlcyAdjmtFirstIncrPercent InsurPlcyAdjmtFirstIncrPercent 1
InsurPlcyAdjmtFirstIndexAmount InsurPlcyAdjmtFirstIndexAmount 1
InsurPlcyAdjmtFrequencyYear InsurPlcyAdjmtFrequencyYear 1
InsurPlcyAdjmtIdxCategory InsurPlcyAdjmtIdxCategory 1
InsurPlcyAdjmtIdxIsChanged InsurPlcyAdjmtIdxIsChanged 1
InsurPlcyAdjmtIdxValdStrtDte InsurPlcyAdjmtIdxValdStrtDte 1
InsurPlcyAdjmtIdxValidEndDate InsurPlcyAdjmtIdxValidEndDate 1
InsurPlcyAdjmtIncrAmtPercent InsurPlcyAdjmtIncrAmtPercent 1
InsurPlcyAdjmtIncreaseBasis InsurPlcyAdjmtIncreaseBasis 1
InsurPlcyAdjmtIndexGroup InsurPlcyAdjmtIndexGroup 1
InsurPlcyAdjmtIndexPercent InsurPlcyAdjmtIndexPercent 1
InsurPlcyAdjmtIndexShare InsurPlcyAdjmtIndexShare 1
InsurPlcyAdjmtIndexType InsurPlcyAdjmtIndexType 1
InsurPlcyAdjmtInitPremAmount InsurPlcyAdjmtInitPremAmount 1
InsurPlcyAdjmtIsCancelled InsurPlcyAdjmtIsCancelled 1
InsurPlcyAdjmtIsIdxCompUsed InsurPlcyAdjmtIsIdxCompUsed 1
InsurPlcyAdjmtIsMnlIndThldVal InsurPlcyAdjmtIsMnlIndThldVal 1
InsurPlcyAdjmtIsModified InsurPlcyAdjmtIsModified 1
InsurPlcyAdjmtIsPerformed InsurPlcyAdjmtIsPerformed 1
InsurPlcyAdjmtIsProgressive InsurPlcyAdjmtIsProgressive 1
InsurPlcyAdjmtIsSuspended InsurPlcyAdjmtIsSuspended 1
InsurPlcyAdjmtIsTblTransferred InsurPlcyAdjmtIsTblTransferred 1
InsurPlcyAdjmtLastDate InsurPlcyAdjmtLastDate 1
InsurPlcyAdjmtLastExectdDte InsurPlcyAdjmtLastExectdDte 1
InsurPlcyAdjmtLastIdxPosID InsurPlcyAdjmtLastIdxPosID 1
InsurPlcyAdjmtLastIdxStartDate InsurPlcyAdjmtLastIdxStartDate 1
InsurPlcyAdjmtLastIncrPercent InsurPlcyAdjmtLastIncrPercent 1
InsurPlcyAdjmtLastIndexAmount InsurPlcyAdjmtLastIndexAmount 1
InsurPlcyAdjmtLastIndexValue InsurPlcyAdjmtLastIndexValue 1
InsurPlcyAdjmtLastNonRjcnDte InsurPlcyAdjmtLastNonRjcnDte 1
InsurPlcyAdjmtLastValdEndDte InsurPlcyAdjmtLastValdEndDte 1
InsurPlcyAdjmtLastValdStrtDte InsurPlcyAdjmtLastValdStrtDte 1
InsurPlcyAdjmtMaxAmount InsurPlcyAdjmtMaxAmount 1
InsurPlcyAdjmtMaximumAge InsurPlcyAdjmtMaximumAge 1
InsurPlcyAdjmtMaxPctgRate InsurPlcyAdjmtMaxPctgRate 1
InsurPlcyAdjmtMaxPeriodValue InsurPlcyAdjmtMaxPeriodValue 1
InsurPlcyAdjmtMinAmount InsurPlcyAdjmtMinAmount 1
InsurPlcyAdjmtMinimumPercent InsurPlcyAdjmtMinimumPercent 1
InsurPlcyAdjmtNextCoverageDate InsurPlcyAdjmtNextCoverageDate 1
InsurPlcyAdjmtNextDate InsurPlcyAdjmtNextDate 1
InsurPlcyAdjmtNrOfSqntlRjcn InsurPlcyAdjmtNrOfSqntlRjcn 1
InsurPlcyAdjmtNrOfSuspension InsurPlcyAdjmtNrOfSuspension 1
InsurPlcyAdjmtNrOfTmeOpposed InsurPlcyAdjmtNrOfTmeOpposed 1
InsurPlcyAdjmtPctgShrOfIndex InsurPlcyAdjmtPctgShrOfIndex 1
InsurPlcyAdjmtPrevYrIndexValue InsurPlcyAdjmtPrevYrIndexValue 1
InsurPlcyAdjmtStartAgeValue InsurPlcyAdjmtStartAgeValue 1
InsurPlcyAdjmtStartDate InsurPlcyAdjmtStartDate 1
InsurPlcyAdjmtStatus InsurPlcyAdjmtStatus 1
InsurPlcyAdjmtStrtgIndexValue InsurPlcyAdjmtStrtgIndexValue 1
InsurPlcyAdjmtSumInsrdContrAmt InsurPlcyAdjmtSumInsrdContrAmt 1
InsurPlcyAdjmtSuspendedEndDte InsurPlcyAdjmtSuspendedEndDte 1
InsurPlcyAdjmtSuspendedReason InsurPlcyAdjmtSuspendedReason 1
InsurPlcyAdjmtSuspendedStrtDte InsurPlcyAdjmtSuspendedStrtDte 1
InsurPlcyAdjmtSuspnVariant InsurPlcyAdjmtSuspnVariant 1
InsurPlcyAdjmtTemplate InsurPlcyAdjmtTemplate 1
InsurPlcyAdjmtThresholdValue InsurPlcyAdjmtThresholdValue 1
InsurPlcyAdjmtVariantType InsurPlcyAdjmtVariantType 1
InsurPlcyAdjustmentType InsurPlcyAdjustmentType 1
InsurPlcyBusinessObject InsurPlcyBusinessObject 1
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 1
InsurPlcyProductPackageID InsurPlcyProductPackageID 1
LastChangeDateTime LastChangeDateTime 1

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.

-- Adjustment in Insurance Policy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYADJUSTMENTBASIC (
    INSURPLCYCOVERAGEID,
    INSURPLCYCOVERAGEOPTIONID,
    INSURPLCYCOVERAGEPACKAGEID,
    INSURPLCYINSUREDOBJECTID,
    INSURPLCYJRNLNMBR,
    _CURRENCY,
    INSURPLCYADJMTAMOUNT,
    INSURPLCYADJMTCREATEINDEXTYPE,
    INSURPLCYADJMTCURIDXAMOUNT,
    INSURPLCYADJMTCURIDXPOS,
    INSURPLCYADJMTCURINCRPERCENT,
    INSURPLCYADJMTCURRENCY,
    INSURPLCYADJMTENDDATE,
    INSURPLCYADJMTEXPRTNAGEVALUE,
    INSURPLCYADJMTFIRSTIDXENDDATE,
    INSURPLCYADJMTFIRSTIDXPOSID,
    INSURPLCYADJMTFIRSTIDXSTRTDTE,
    INSURPLCYADJMTFIRSTINCRPERCENT,
    INSURPLCYADJMTFIRSTINDEXAMOUNT,
    INSURPLCYADJMTFREQUENCYYEAR,
    INSURPLCYADJMTIDXCATEGORY,
    INSURPLCYADJMTIDXISCHANGED,
    INSURPLCYADJMTIDXVALDSTRTDTE,
    INSURPLCYADJMTIDXVALIDENDDATE,
    INSURPLCYADJMTINCRAMTPERCENT,
    INSURPLCYADJMTINCREASEBASIS,
    INSURPLCYADJMTINDEXGROUP,
    INSURPLCYADJMTINDEXPERCENT,
    INSURPLCYADJMTINDEXSHARE,
    INSURPLCYADJMTINDEXTYPE,
    INSURPLCYADJMTINITPREMAMOUNT,
    INSURPLCYADJMTISCANCELLED,
    INSURPLCYADJMTISIDXCOMPUSED,
    INSURPLCYADJMTISMNLINDTHLDVAL,
    INSURPLCYADJMTISMODIFIED,
    INSURPLCYADJMTISPERFORMED,
    INSURPLCYADJMTISPROGRESSIVE,
    INSURPLCYADJMTISSUSPENDED,
    INSURPLCYADJMTISTBLTRANSFERRED,
    INSURPLCYADJMTLASTDATE,
    INSURPLCYADJMTLASTEXECTDDTE,
    INSURPLCYADJMTLASTIDXPOSID,
    INSURPLCYADJMTLASTIDXSTARTDATE,
    INSURPLCYADJMTLASTINCRPERCENT,
    INSURPLCYADJMTLASTINDEXAMOUNT,
    INSURPLCYADJMTLASTINDEXVALUE,
    INSURPLCYADJMTLASTNONRJCNDTE,
    INSURPLCYADJMTLASTVALDENDDTE,
    INSURPLCYADJMTLASTVALDSTRTDTE,
    INSURPLCYADJMTMAXAMOUNT,
    INSURPLCYADJMTMAXIMUMAGE,
    INSURPLCYADJMTMAXPCTGRATE,
    INSURPLCYADJMTMAXPERIODVALUE,
    INSURPLCYADJMTMINAMOUNT,
    INSURPLCYADJMTMINIMUMPERCENT,
    INSURPLCYADJMTNEXTCOVERAGEDATE,
    INSURPLCYADJMTNEXTDATE,
    INSURPLCYADJMTNROFSQNTLRJCN,
    INSURPLCYADJMTNROFSUSPENSION,
    INSURPLCYADJMTNROFTMEOPPOSED,
    INSURPLCYADJMTPCTGSHROFINDEX,
    INSURPLCYADJMTPREVYRINDEXVALUE,
    INSURPLCYADJMTSTARTAGEVALUE,
    INSURPLCYADJMTSTARTDATE,
    INSURPLCYADJMTSTATUS,
    INSURPLCYADJMTSTRTGINDEXVALUE,
    INSURPLCYADJMTSUMINSRDCONTRAMT,
    INSURPLCYADJMTSUSPENDEDENDDTE,
    INSURPLCYADJMTSUSPENDEDREASON,
    INSURPLCYADJMTSUSPENDEDSTRTDTE,
    INSURPLCYADJMTSUSPNVARIANT,
    INSURPLCYADJMTTEMPLATE,
    INSURPLCYADJMTTHRESHOLDVALUE,
    INSURPLCYADJMTVARIANTTYPE,
    INSURPLCYADJUSTMENTTYPE,
    INSURPLCYBUSINESSOBJECT,
    INSURPLCYJRNLENDNMBR,
    INSURPLCYPRODUCTPACKAGEID,
    LASTCHANGEDATETIME,
    PRIMARY KEY (INSURPLCYCOVERAGEID, INSURPLCYCOVERAGEOPTIONID, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYINSUREDOBJECTID, INSURPLCYJRNLNMBR)
);

Learn More