I_INSURPLCYBSCLAUSEBASIC

CDS View
24 Fields 6 CDS Views

Clause in Insurance Policy

I_INSURPLCYBSCLAUSEBASIC is a CDS View in S/4HANA. Clause in Insurance Policy. It contains 24 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
R_InsurPlcyClauseTP_2 view_entity from TRANSACTIONAL Clause under Policy
R_InsurPlcyContrClauseTP_2 view_entity from TRANSACTIONAL Clause under Contract
R_InsurPlcyCvPcgClauseTP_2 view_entity from TRANSACTIONAL Clause under Coverage Package
R_InsurPlcyCvrgClauseTP_2 view_entity from TRANSACTIONAL Clause under Coverage
R_InsurPlcyInsObClauseTP view_entity from TRANSACTIONAL Clause under Insured Object
R_InsurPlcySbcvrgClauseTP view_entity from TRANSACTIONAL Clause under Subcoverage

Fields (24)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyClauseID InsurPlcyClauseID 5
KEY InsurPlcyCoverageID InsurPlcyCoverageID 5
KEY InsurPlcyCoverageOptionID InsurPlcyCoverageOptionID 5
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID 5
KEY InsurPlcyInsurContr InsurPlcyInsurContr 5
KEY InsurPlcyInsuredObjectID InsurPlcyInsuredObjectID 5
KEY InsurPlcySubCvrgID InsurPlcySubCvrgID 5
KEY InsurPlcyUndrwrtgDcsnRiskID InsurPlcyUndrwrtgDcsnRiskID 5
KEY InsurPlcyUUID InsurPlcyUUID 5
InsurancePolicyApplication InsurancePolicyApplication 5
InsurPlcyBusinessObject InsurPlcyBusinessObject 5
InsurPlcyClauseClauseNumber InsurPlcyClauseClauseNumber 5
InsurPlcyClauseDetailTextUUID InsurPlcyClauseDetailTextUUID 5
InsurPlcyClauseEndDate InsurPlcyClauseEndDate 5
InsurPlcyClauseIsCanceled InsurPlcyClauseIsCanceled 5
InsurPlcyClauseIsDrvtnMstrPlcy InsurPlcyClauseIsDrvtnMstrPlcy 5
InsurPlcyClauseStartDate InsurPlcyClauseStartDate 5
InsurPlcyClauseTemplate InsurPlcyClauseTemplate 5
InsurPlcyClauseType InsurPlcyClauseType 5
InsurPlcyIndivClauseAgrmtText InsurPlcyIndivClauseAgrmtText 5
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 5
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 5
InsurPlcyProductPackageID InsurPlcyProductPackageID 5
LastChangeDateTime LastChangeDateTime 5

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.

-- Clause in Insurance Policy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYBSCLAUSEBASIC (
    INSURPLCYCLAUSEID,
    INSURPLCYCOVERAGEID,
    INSURPLCYCOVERAGEOPTIONID,
    INSURPLCYCOVERAGEPACKAGEID,
    INSURPLCYINSURCONTR,
    INSURPLCYINSUREDOBJECTID,
    INSURPLCYSUBCVRGID,
    INSURPLCYUNDRWRTGDCSNRISKID,
    INSURPLCYUUID,
    INSURANCEPOLICYAPPLICATION,
    INSURPLCYBUSINESSOBJECT,
    INSURPLCYCLAUSECLAUSENUMBER,
    INSURPLCYCLAUSEDETAILTEXTUUID,
    INSURPLCYCLAUSEENDDATE,
    INSURPLCYCLAUSEISCANCELED,
    INSURPLCYCLAUSEISDRVTNMSTRPLCY,
    INSURPLCYCLAUSESTARTDATE,
    INSURPLCYCLAUSETEMPLATE,
    INSURPLCYCLAUSETYPE,
    INSURPLCYINDIVCLAUSEAGRMTTEXT,
    INSURPLCYJRNLENDNMBR,
    INSURPLCYJRNLNMBR,
    INSURPLCYPRODUCTPACKAGEID,
    LASTCHANGEDATETIME,
    PRIMARY KEY (INSURPLCYCLAUSEID, INSURPLCYCOVERAGEID, INSURPLCYCOVERAGEOPTIONID, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYINSURCONTR, INSURPLCYINSUREDOBJECTID, INSURPLCYSUBCVRGID, INSURPLCYUNDRWRTGDCSNRISKID, INSURPLCYUUID)
);

Learn More