I_INSURPLCYUNDRWRTGDCSNBASIC
Underwrtg Dcsn Risk Assmt in Insur Plcy
I_INSURPLCYUNDRWRTGDCSNBASIC is a CDS View in S/4HANA. Underwrtg Dcsn Risk Assmt in Insur Plcy. It contains 19 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsurPlcyUndrwrtgDcsnVersion | view_entity | from | COMPOSITE | Underwriting Decision |
| I_InsurPlcyUndrwrtgDcsnVersion | view_entity | union | COMPOSITE | Underwriting Decision |
| P_InPlUndrwrtgDcsnLoadJrnlId | view_entity | inner | COMPOSITE |
Fields (19)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InsurPlcyCoverageID | InsurPlcyCoverageID | 1 |
| KEY | InsurPlcyCoverageOptionID | InsurPlcyCoverageOptionID | 1 |
| KEY | InsurPlcyCoveragePackageID | InsurPlcyCoveragePackageID | 1 |
| KEY | InsurPlcyInsuredObjectID | InsurPlcyInsuredObjectID | 1 |
| KEY | InsurPlcyJrnlNmbr | InsurPlcyJrnlNmbr | 2 |
| KEY | InsurPlcyUndrwrtgDcsnRiskID | InsurPlcyUndrwrtgDcsnRiskID | 1 |
| InsurancePolicy | InsurancePolicy | 1 | |
| InsurancePolicyApplication | InsurancePolicyApplication | 1 | |
| InsurancePolicyContract | InsurancePolicyContract | 1 | |
| InsurPlcyBusinessObject | InsurPlcyBusinessObject | 1 | |
| InsurPlcyJrnlEndNmbr | InsurPlcyJrnlEndNmbr | 1 | |
| InsurPlcyProductPackageID | InsurPlcyProductPackageID | 1 | |
| InsurPlcyUndrwrtgDcsnCommentID | InsurPlcyUndrwrtgDcsnCommentID | 1 | |
| InsurPlcyUndrwrtgDcsnPartnerID | InsurPlcyUndrwrtgDcsnPartnerID | 1 | |
| InsurPlcyUndrwrtgDcsnResetRsn | InsurPlcyUndrwrtgDcsnResetRsn | 1 | |
| InsurPlcyUndrwrtgDcsnType | InsurPlcyUndrwrtgDcsnType | 1 | |
| InsurPlcyUndrwrtgElementProd | InsurPlcyUndrwrtgElementProd | 1 | |
| InsurPlcyUndrwrtgIsCancelled | InsurPlcyUndrwrtgIsCancelled | 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.
-- Underwrtg Dcsn Risk Assmt in Insur Plcy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYUNDRWRTGDCSNBASIC (
INSURPLCYCOVERAGEID,
INSURPLCYCOVERAGEOPTIONID,
INSURPLCYCOVERAGEPACKAGEID,
INSURPLCYINSUREDOBJECTID,
INSURPLCYJRNLNMBR,
INSURPLCYUNDRWRTGDCSNRISKID,
INSURANCEPOLICY,
INSURANCEPOLICYAPPLICATION,
INSURANCEPOLICYCONTRACT,
INSURPLCYBUSINESSOBJECT,
INSURPLCYJRNLENDNMBR,
INSURPLCYPRODUCTPACKAGEID,
INSURPLCYUNDRWRTGDCSNCOMMENTID,
INSURPLCYUNDRWRTGDCSNPARTNERID,
INSURPLCYUNDRWRTGDCSNRESETRSN,
INSURPLCYUNDRWRTGDCSNTYPE,
INSURPLCYUNDRWRTGELEMENTPROD,
INSURPLCYUNDRWRTGISCANCELLED,
LASTCHANGEDATETIME,
PRIMARY KEY (INSURPLCYCOVERAGEID, INSURPLCYCOVERAGEOPTIONID, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYINSUREDOBJECTID, INSURPLCYJRNLNMBR, INSURPLCYUNDRWRTGDCSNRISKID)
);
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