I_INSURPLCYSHIFTSWITCHBASIC

CDS View

Shift Switch Position in Insurance Plcy

I_INSURPLCYSHIFTSWITCHBASIC is a CDS View in S/4HANA. Shift Switch Position in Insurance Plcy. It contains 41 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_InsurPlcyShiftSwitchVersion view_entity from COMPOSITE Shift Switch
I_InsurPlcyShiftSwitchVersion view_entity union COMPOSITE Shift Switch
P_InPlShiftSwitchLoadJrnlId view_entity inner COMPOSITE

Fields (41)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyCoverageID InsurPlcyCoverageID 1
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID 1
KEY InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 2
KEY InsurPlcyShftSwitchID InsurPlcyShftSwitchID 1
KEY InsurPlcyShiftSwitchHeaderID InsurPlcyShiftSwitchHeaderID 1
_Currency _Currency 1
InsurPlcyAssgdAmt InsurPlcyAssgdAmt 1
InsurPlcyAssgdPctgRate InsurPlcyAssgdPctgRate 1
InsurPlcyBusinessObject InsurPlcyBusinessObject 1
InsurPlcyChgUntFundAllocKey InsurPlcyChgUntFundAllocKey 1
InsurPlcyCnvrsnTgtRate InsurPlcyCnvrsnTgtRate 1
InsurPlcyCurDistrRate InsurPlcyCurDistrRate 1
InsurPlcyCurPrAmt InsurPlcyCurPrAmt 1
InsurPlcyFundRngeID InsurPlcyFundRngeID 1
InsurPlcyFundSharesRate InsurPlcyFundSharesRate 1
InsurPlcyIssuanceRate InsurPlcyIssuanceRate 1
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 1
InsurPlcyNrOfCurShares InsurPlcyNrOfCurShares 1
InsurPlcyNrOfSharesAssgd InsurPlcyNrOfSharesAssgd 1
InsurPlcyProductPackageID InsurPlcyProductPackageID 1
InsurPlcyReldAmt InsurPlcyReldAmt 1
InsurPlcyReldPctgRate InsurPlcyReldPctgRate 1
InsurPlcyShftChgProdMgrID InsurPlcyShftChgProdMgrID 1
InsurPlcyShftSwitchAllocKey InsurPlcyShftSwitchAllocKey 1
InsurPlcyShftSwitchChrgSched InsurPlcyShftSwitchChrgSched 1
InsurPlcyShftSwitchChrgType InsurPlcyShftSwitchChrgType 1
InsurPlcyShftSwitchCollMeth InsurPlcyShftSwitchCollMeth 1
InsurPlcyShftSwitchCurAmt InsurPlcyShftSwitchCurAmt 1
InsurPlcyShftSwitchIsCancelled InsurPlcyShftSwitchIsCancelled 1
InsurPlcyShftSwitchIsTotTransf InsurPlcyShftSwitchIsTotTransf 1
InsurPlcyShftSwitchMgmtFeeRate InsurPlcyShftSwitchMgmtFeeRate 1
InsurPlcyShftSwitchMinFundQty InsurPlcyShftSwitchMinFundQty 1
InsurPlcyShftSwitchParID InsurPlcyShftSwitchParID 1
InsurPlcyShftSwitchPrDte InsurPlcyShftSwitchPrDte 1
InsurPlcyShftSwitchPrtnID InsurPlcyShftSwitchPrtnID 1
InsurPlcyShftSwitchSrceTgtCode InsurPlcyShftSwitchSrceTgtCode 1
InsurPlcyShiftSwitchCurrency InsurPlcyShiftSwitchCurrency 1
InsurPlcySourceFundID InsurPlcySourceFundID 1
InsurPlcySrceCnvrsnRate InsurPlcySrceCnvrsnRate 1
InsurPlcyTgtFundID InsurPlcyTgtFundID 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.

-- Shift Switch Position in Insurance Plcy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSURPLCYSHIFTSWITCHBASIC (
    INSURPLCYCOVERAGEID,
    INSURPLCYCOVERAGEPACKAGEID,
    INSURPLCYJRNLNMBR,
    INSURPLCYSHFTSWITCHID,
    INSURPLCYSHIFTSWITCHHEADERID,
    _CURRENCY,
    INSURPLCYASSGDAMT,
    INSURPLCYASSGDPCTGRATE,
    INSURPLCYBUSINESSOBJECT,
    INSURPLCYCHGUNTFUNDALLOCKEY,
    INSURPLCYCNVRSNTGTRATE,
    INSURPLCYCURDISTRRATE,
    INSURPLCYCURPRAMT,
    INSURPLCYFUNDRNGEID,
    INSURPLCYFUNDSHARESRATE,
    INSURPLCYISSUANCERATE,
    INSURPLCYJRNLENDNMBR,
    INSURPLCYNROFCURSHARES,
    INSURPLCYNROFSHARESASSGD,
    INSURPLCYPRODUCTPACKAGEID,
    INSURPLCYRELDAMT,
    INSURPLCYRELDPCTGRATE,
    INSURPLCYSHFTCHGPRODMGRID,
    INSURPLCYSHFTSWITCHALLOCKEY,
    INSURPLCYSHFTSWITCHCHRGSCHED,
    INSURPLCYSHFTSWITCHCHRGTYPE,
    INSURPLCYSHFTSWITCHCOLLMETH,
    INSURPLCYSHFTSWITCHCURAMT,
    INSURPLCYSHFTSWITCHISCANCELLED,
    INSURPLCYSHFTSWITCHISTOTTRANSF,
    INSURPLCYSHFTSWITCHMGMTFEERATE,
    INSURPLCYSHFTSWITCHMINFUNDQTY,
    INSURPLCYSHFTSWITCHPARID,
    INSURPLCYSHFTSWITCHPRDTE,
    INSURPLCYSHFTSWITCHPRTNID,
    INSURPLCYSHFTSWITCHSRCETGTCODE,
    INSURPLCYSHIFTSWITCHCURRENCY,
    INSURPLCYSOURCEFUNDID,
    INSURPLCYSRCECNVRSNRATE,
    INSURPLCYTGTFUNDID,
    LASTCHANGEDATETIME,
    PRIMARY KEY (INSURPLCYCOVERAGEID, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYJRNLNMBR, INSURPLCYSHFTSWITCHID, INSURPLCYSHIFTSWITCHHEADERID)
);