I_INSURPLCYREPORTEDVALBASIC
Reported Value in Insurance Policy
I_INSURPLCYREPORTEDVALBASIC is a CDS View in S/4HANA. Reported Value in Insurance Policy. It contains 34 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsurPlcyRptdValueVersion | view_entity | from | COMPOSITE | Reported Value |
| I_InsurPlcyRptdValueVersion | view_entity | union | COMPOSITE | Reported Value |
| P_InsurPlcyRptdValLoadJrnlId | view_entity | inner | COMPOSITE | |
| R_InsurPlcyCvPcgCvrgRptdValTP | view_entity | from | TRANSACTIONAL | Reported Value under CVPackage CV |
| R_InsurPlcyReportedValueTP | view_entity | from | TRANSACTIONAL | Reported Value |
Fields (34)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InsurPlcyCoverageID | InsurPlcyCoverageID | 3 |
| KEY | InsurPlcyCoveragePackageID | InsurPlcyCoveragePackageID | 3 |
| KEY | InsurPlcyInsurContr | InsurPlcyInsurContr | 2 |
| KEY | InsurPlcyJrnlNmbr | InsurPlcyJrnlNmbr | 4 |
| KEY | InsurPlcyRptdValID | InsurPlcyRptdValID | 3 |
| KEY | InsurPlcyUUID | InsurPlcyUUID | 2 |
| _Currency | _Currency | 3 | |
| InsurPlcyAdvncPaytOfPremPct | InsurPlcyAdvncPaytOfPremPct | 3 | |
| InsurPlcyBusinessObject | InsurPlcyBusinessObject | 3 | |
| InsurPlcyFiscalYearHandling | InsurPlcyFiscalYearHandling | 3 | |
| InsurPlcyIsPnltyEndorsement | InsurPlcyIsPnltyEndorsement | 3 | |
| InsurPlcyJrnlEndNmbr | InsurPlcyJrnlEndNmbr | 3 | |
| InsurPlcyMonetaryRptdValAmt | InsurPlcyMonetaryRptdValAmt | 3 | |
| InsurPlcyNotifPerdNumberOfDays | InsurPlcyNotifPerdNumberOfDays | 3 | |
| InsurPlcyPnltyEndorsementMode | InsurPlcyPnltyEndorsementMode | 3 | |
| InsurPlcyPnltyFctrPercent | InsurPlcyPnltyFctrPercent | 3 | |
| InsurPlcyProductPackageID | InsurPlcyProductPackageID | 3 | |
| InsurPlcyRptdSettlmtEndDate | InsurPlcyRptdSettlmtEndDate | 3 | |
| InsurPlcyRptdSettlmtStartDate | InsurPlcyRptdSettlmtStartDate | 3 | |
| InsurPlcyRptdValCat | InsurPlcyRptdValCat | 3 | |
| InsurPlcyRptdValCl | InsurPlcyRptdValCl | 3 | |
| InsurPlcyRptdValCurrency | InsurPlcyRptdValCurrency | 3 | |
| InsurPlcyRptdValDueDteKey | InsurPlcyRptdValDueDteKey | 3 | |
| InsurPlcyRptdValIsCancld | InsurPlcyRptdValIsCancld | 3 | |
| InsurPlcyRptdValQuantity | InsurPlcyRptdValQuantity | 3 | |
| InsurPlcyRptdValQuantityUnit | InsurPlcyRptdValQuantityUnit | 3 | |
| InsurPlcyRptdValSettlmtCyc | InsurPlcyRptdValSettlmtCyc | 3 | |
| InsurPlcyRptdValSettlmtMode | InsurPlcyRptdValSettlmtMode | 3 | |
| InsurPlcyRptdValSettlmtWvr | InsurPlcyRptdValSettlmtWvr | 3 | |
| InsurPlcyRptdValSts | InsurPlcyRptdValSts | 3 | |
| InsurPlcyRptdValTemplateID | InsurPlcyRptdValTemplateID | 3 | |
| InsurPlcyRptdValTmeRef | InsurPlcyRptdValTmeRef | 3 | |
| InsurPlcyRptgCyc | InsurPlcyRptgCyc | 3 | |
| LastChangeDateTime | LastChangeDateTime | 3 |
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.
-- Reported Value in Insurance Policy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYREPORTEDVALBASIC (
INSURPLCYCOVERAGEID,
INSURPLCYCOVERAGEPACKAGEID,
INSURPLCYINSURCONTR,
INSURPLCYJRNLNMBR,
INSURPLCYRPTDVALID,
INSURPLCYUUID,
_CURRENCY,
INSURPLCYADVNCPAYTOFPREMPCT,
INSURPLCYBUSINESSOBJECT,
INSURPLCYFISCALYEARHANDLING,
INSURPLCYISPNLTYENDORSEMENT,
INSURPLCYJRNLENDNMBR,
INSURPLCYMONETARYRPTDVALAMT,
INSURPLCYNOTIFPERDNUMBEROFDAYS,
INSURPLCYPNLTYENDORSEMENTMODE,
INSURPLCYPNLTYFCTRPERCENT,
INSURPLCYPRODUCTPACKAGEID,
INSURPLCYRPTDSETTLMTENDDATE,
INSURPLCYRPTDSETTLMTSTARTDATE,
INSURPLCYRPTDVALCAT,
INSURPLCYRPTDVALCL,
INSURPLCYRPTDVALCURRENCY,
INSURPLCYRPTDVALDUEDTEKEY,
INSURPLCYRPTDVALISCANCLD,
INSURPLCYRPTDVALQUANTITY,
INSURPLCYRPTDVALQUANTITYUNIT,
INSURPLCYRPTDVALSETTLMTCYC,
INSURPLCYRPTDVALSETTLMTMODE,
INSURPLCYRPTDVALSETTLMTWVR,
INSURPLCYRPTDVALSTS,
INSURPLCYRPTDVALTEMPLATEID,
INSURPLCYRPTDVALTMEREF,
INSURPLCYRPTGCYC,
LASTCHANGEDATETIME,
PRIMARY KEY (INSURPLCYCOVERAGEID, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYINSURCONTR, INSURPLCYJRNLNMBR, INSURPLCYRPTDVALID, 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