I_INSURPLCYEXTREFERENCEBASIC

CDS View
15 Fields 7 CDS Views

External Reference in Insurance Policy

I_INSURPLCYEXTREFERENCEBASIC is a CDS View in S/4HANA. External Reference in Insurance Policy. It contains 15 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_InsurPlcyExtReferenceVersion view_entity from COMPOSITE External Reference
I_InsurPlcyExtReferenceVersion view_entity union COMPOSITE External Reference
P_InsurPlcyExtRefLoadJrnlId view_entity inner COMPOSITE
R_InsurPlcyContrExtRefTP view_entity from TRANSACTIONAL External Reference under Contract
R_InsurPlcyCvPcgCvrgExtRefTP view_entity from TRANSACTIONAL External Reference under CVPackage CV
R_InsurPlcyCvrgExtRefTP view_entity from TRANSACTIONAL External Reference under Coverage
R_InsurPlcyExternalReferenceTP view_entity from TRANSACTIONAL External Reference under Policy

Fields (15)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyCoverageID InsurPlcyCoverageID 1
KEY InsurPlcyCoverageOptionID InsurPlcyCoverageOptionID 1
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID 1
KEY InsurPlcyExternalReferenceID InsurPlcyExternalReferenceID 1
KEY InsurPlcyInsuredObjectID InsurPlcyInsuredObjectID 1
KEY InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 2
InsurPlcyBusinessObject InsurPlcyBusinessObject 1
InsurPlcyExtRefCompany InsurPlcyExtRefCompany 1
InsurPlcyExtRefIsCancelled InsurPlcyExtRefIsCancelled 1
InsurPlcyExtRefReferenceNumber InsurPlcyExtRefReferenceNumber 1
InsurPlcyExtRefReferenceType InsurPlcyExtRefReferenceType 1
InsurPlcyExtRefTemplate InsurPlcyExtRefTemplate 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.

-- External Reference in Insurance Policy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYEXTREFERENCEBASIC (
    INSURPLCYCOVERAGEID,
    INSURPLCYCOVERAGEOPTIONID,
    INSURPLCYCOVERAGEPACKAGEID,
    INSURPLCYEXTERNALREFERENCEID,
    INSURPLCYINSUREDOBJECTID,
    INSURPLCYJRNLNMBR,
    INSURPLCYBUSINESSOBJECT,
    INSURPLCYEXTREFCOMPANY,
    INSURPLCYEXTREFISCANCELLED,
    INSURPLCYEXTREFREFERENCENUMBER,
    INSURPLCYEXTREFREFERENCETYPE,
    INSURPLCYEXTREFTEMPLATE,
    INSURPLCYJRNLENDNMBR,
    INSURPLCYPRODUCTPACKAGEID,
    LASTCHANGEDATETIME,
    PRIMARY KEY (INSURPLCYCOVERAGEID, INSURPLCYCOVERAGEOPTIONID, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYEXTERNALREFERENCEID, INSURPLCYINSUREDOBJECTID, INSURPLCYJRNLNMBR)
);

Learn More