I_INSURPLCYSHIFTSWITCHBASIC
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsurPlcyShiftSwitchVersion | view_entity | from | COMPOSITE | Shift Switch |
| I_InsurPlcyShiftSwitchVersion | view_entity | union | COMPOSITE | Shift Switch |
| P_InPlShiftSwitchLoadJrnlId | view_entity | inner | COMPOSITE |
Fields (41)
| Key | Field | CDS Fields | Used 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)
);
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