I_INSURPLCYAGENTBASIC

CDS View
12 Fields 4 CDS Views

Representative in Insurance Policy

I_INSURPLCYAGENTBASIC is a CDS View in S/4HANA. Representative in Insurance Policy. It contains 12 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_InsurancePolicyAgentVersion view_entity from COMPOSITE Policy Agent
I_InsurancePolicyAgentVersion view_entity union COMPOSITE Policy Agent
P_InsurPlcyAgentLoadJrnlId view_entity inner COMPOSITE
R_InsurPlcyAgentTP view_entity from TRANSACTIONAL Agent

Fields (12)

KeyField CDS FieldsUsed in Views
KEY InsurancePolicyAgentIdentifier InsurancePolicyAgentIdentifier 1
KEY InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 2
InsurancePolicyAgentPartner InsurancePolicyAgentPartner 1
InsurPlcyAgentAddrNmbr InsurPlcyAgentAddrNmbr 1
InsurPlcyAgentIsCanceled InsurPlcyAgentIsCanceled 1
InsurPlcyAgentTemplate InsurPlcyAgentTemplate 1
InsurPlcyBusinessObject InsurPlcyBusinessObject 1
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 1
InsurPlcyProductPackageID InsurPlcyProductPackageID 1
InsurPlcyRprstvType InsurPlcyRprstvType 1
InsurPlcyScopeAgent InsurPlcyScopeAgent 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.

-- Representative in Insurance Policy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYAGENTBASIC (
    INSURANCEPOLICYAGENTIDENTIFIER,
    INSURPLCYJRNLNMBR,
    INSURANCEPOLICYAGENTPARTNER,
    INSURPLCYAGENTADDRNMBR,
    INSURPLCYAGENTISCANCELED,
    INSURPLCYAGENTTEMPLATE,
    INSURPLCYBUSINESSOBJECT,
    INSURPLCYJRNLENDNMBR,
    INSURPLCYPRODUCTPACKAGEID,
    INSURPLCYRPRSTVTYPE,
    INSURPLCYSCOPEAGENT,
    LASTCHANGEDATETIME,
    PRIMARY KEY (INSURANCEPOLICYAGENTIDENTIFIER, INSURPLCYJRNLNMBR)
);

Learn More