R_InsurPolicyLifeCoverageTP

DDL: R_INSURPOLICYLIFECOVERAGETP Type: view_entity TRANSACTIONAL
66 Fields 2 Data Sources 2 Associations

Life Coverage - TP

R_InsurPolicyLifeCoverageTP is a Transactional CDS View that provides data about "Life Coverage - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyHghstVersPerAppl, I_InsurPlcyLifeCoverageVersion) and exposes 66 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyHghstVersPerAppl HighestVersion inner
I_InsurPlcyLifeCoverageVersion LifeCoverage from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_InsurancePolicyTP_3 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID
[1..1] E_InsuranceLifeCoverage _Extension ( $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID or $projection.InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr

Annotations (13)

NameValueLevelField
EndUserText.label Life Coverage - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix LCV view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.allowNewCompositions false view
ObjectModel.sapObjectNodeType.name InsuranceLifeCoverage view
Metadata.ignorePropagatedAnnotations true view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyLifeCoverageVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyLifeCoverageVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyLifeCoverageVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyLifeCoverageVersion InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyLifeCoverageVersion InsurPlcyCoverageID Coverage Key
InsurPlcyUUIDForEdit I_InsurPlcyLifeCoverageVersion InsurPlcyUUID Policy UUID
InsurPlcyApplUUIDForEdit I_InsurPlcyLifeCoverageVersion InsurPlcyApplUUID Policy UUID
InsurPlcyInsurContrForEdit I_InsurPlcyLifeCoverageVersion InsurPlcyInsurContr Contract Key
InsurPlcyCvPcgIDForEdit I_InsurPlcyLifeCoverageVersion InsurPlcyCoveragePackageID Cov.Package ID
InsurPlcyCoverageIDForEdit I_InsurPlcyLifeCoverageVersion InsurPlcyCoverageID Coverage Key
InsurPlcyOrderNumber I_InsurPlcyLifeCoverageVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyLifeCoverageVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyLifeCoverageVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurPlcyLifeCoverageVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPlcyLifeCoverageVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPlcyLifeCoverageVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyLifeCvrgIsCanceled I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgIsCanceled Rev. Flag
InsPlcyLifeCvrgOptnPhseEndDate I_InsurPlcyLifeCoverageVersion InsPlcyLifeCvrgOptnPhseEndDate Opt. Phase End
InsPlcyLifeCvrgIsInvldInAdjmt I_InsurPlcyLifeCoverageVersion InsPlcyLifeCvrgIsInvldInAdjmt Adjustment
InsPlcyLifeCvrgNrOfInsrdPersn I_InsurPlcyLifeCoverageVersion InsPlcyLifeCvrgNrOfInsrdPersn No. Ins. Prsns
InsurPlcyLifeCvrgSuprordCvrgID I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgSuprordCvrgID Superord. Cov.
InsPlcyLifeCvrgGuaranteedOptn I_InsurPlcyLifeCoverageVersion InsPlcyLifeCvrgGuaranteedOptn Guaranteed Option
InsurPlcyLifeCvrgFundRangeID I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgFundRangeID Fund Range
InsurPlcyCvrgUntLinkdInvmtDte I_InsurPlcyLifeCoverageVersion InsurPlcyCvrgUntLinkdInvmtDte Ins. Inv. Date
InsurPlcyLifeCvrgOptnBeginDate I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgOptnBeginDate OptPhaseStart
InsPlcyCvrgElementaryProdType I_InsurPlcyLifeCoverageVersion InsPlcyCvrgElementaryProdType EP Type
InsurPlcyLifeCvrgPremOblgn I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgPremOblgn Premium Oblig.
InsurPlcyLifeCvrgPremExempt I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgPremExempt Premium Exempt
InsurPlcyLifeCvrgBnftDvdndUsge I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgBnftDvdndUsge Compensable
InsPlcyLifeCvrgOptnPhseIsPosbl I_InsurPlcyLifeCoverageVersion InsPlcyLifeCvrgOptnPhseIsPosbl Opt. Spec. Flag
InsurPlcyLifeCvrgOptnPhseInYr I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgOptnPhseInYr Opt. Phase (Y)
InsurPlcyLifeCvrgOptnPhseMnths I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgOptnPhseMnths OptPhase (RM)
InsurPlcyLifeCvrgOptnFnlAgeVal I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgOptnFnlAgeVal Opt. Final Age
InsPlcyLifeCvrgOptnStrtAgeVal I_InsurPlcyLifeCoverageVersion InsPlcyLifeCvrgOptnStrtAgeVal Opt. Start. Age
InsurPlcyCvrgHasSuplmntyInsur I_InsurPlcyLifeCoverageVersion InsurPlcyCvrgHasSuplmntyInsur Suppl. Ins.
InsurPlcyLifeCvrgMaxOptnPhseYr I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgMaxOptnPhseYr Max. Opt. Phase
InsurPlcyLifeCvrgFundCrdtAmt I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgFundCrdtAmt Fund Assets
InsurPlcyLifeCvrgMaxNrOfShifts I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgMaxNrOfShifts Max. No. Shifts
InsurPlcyLifeCvrgFundShiftID I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgFundShiftID Shift/Chge Type
InsurPlcyLifeCvrgTgtFundRngeID I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgTgtFundRngeID TargetFundRange
InsurPlcyLifeCvrgIsSubjToTax I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgIsSubjToTax CapForm Life In
InsurPlcyLifeCvrgCurrency I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgCurrency Currency
InsurPlcyLifeCvrgBusGrpIsDtmnd I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgBusGrpIsDtmnd Deriv. IFB Grp
InsPlcyLifeCvrgRskTypeIsDtmnd I_InsurPlcyLifeCoverageVersion InsPlcyLifeCvrgRskTypeIsDtmnd Der. Risk Type
InsurPlcyLifeCvrgFundCrdtPrpty I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgFundCrdtPrpty FundCredit Prop
InsurPlcyLifeCvrgAnnuRcptType I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgAnnuRcptType AnnuityRecType
InsurPlcyLifeCvrgOption I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgOption Option
InsurPlcyCvrgDvdndAllcdDayMnth I_InsurPlcyLifeCoverageVersion InsurPlcyCvrgDvdndAllcdDayMnth Dividend Usage Date
InsurPlcyLifeCvrgIsInOptnPhase I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgIsInOptnPhase In Option Phase
InsPlcyCvrgExtnOptnIsExercised I_InsurPlcyLifeCoverageVersion InsPlcyCvrgExtnOptnIsExercised ExtensionOption
InsPlcyLifeCvrgIsYrlyRollover I_InsurPlcyLifeCoverageVersion InsPlcyLifeCvrgIsYrlyRollover Yearly Rollover
InsurPlcyCvrgIsExprtnIsExtd I_InsurPlcyLifeCoverageVersion InsurPlcyCvrgIsExprtnIsExtd ParticRollover
InsurPlcyLifeCvrgFundAstMaxAmt I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgFundAstMaxAmt HighestCashVal
InsurPlcyLifeCvrgAcctgVarAnnu I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgAcctgVarAnnu AccVarAnnuity
InsurPlcyCvrgAnnuDisbmtType I_InsurPlcyLifeCoverageVersion InsurPlcyCvrgAnnuDisbmtType DisburseType
InsurPlcyCvrgPrptySrrndrAmt I_InsurPlcyLifeCoverageVersion InsurPlcyCvrgPrptySrrndrAmt Property SV
InsurPlcyLifeCvrgWaitingPeriod I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgWaitingPeriod Wait. Per. (Days)
InsurPlcyCvrgDvdndCrdtIsTrnsfd I_InsurPlcyLifeCoverageVersion InsurPlcyCvrgDvdndCrdtIsTrnsfd Trans. DIv.Cred
InsurPlcyLifeCvrgFundPaletteID I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgFundPaletteID Fund Range ID
InsurPlcyCvrgFundDistrIsTrnsfd I_InsurPlcyLifeCoverageVersion InsurPlcyCvrgFundDistrIsTrnsfd Transfer TFD
InsPlcyCvrgInvestedFundAstAmt I_InsurPlcyLifeCoverageVersion InsPlcyCvrgInvestedFundAstAmt Fund Assets
InsurPlcyLifeCvrgCalcRuleType I_InsurPlcyLifeCoverageVersion InsurPlcyLifeCvrgCalcRuleType Calc. Rule Type
InsurPlcyBusinessObject I_InsurPlcyLifeCoverageVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyLifeCoverageVersion LastChangeDateTime Timestamp
_Currency I_InsurPlcyLifeCoverageVersion _Currency
_Policy _Policy

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_InsurPolicyLifeCoverageTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_InsurPolicyLifeCoverageTP AS
SELECT
  LifeCoverage.InsurPlcyUUID AS InsurPlcyUUID,
  LifeCoverage.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  LifeCoverage.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  LifeCoverage.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  LifeCoverage.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  LifeCoverage.InsurPlcyUUID AS InsurPlcyUUIDForEdit,
  LifeCoverage.InsurPlcyApplUUID AS InsurPlcyApplUUIDForEdit,
  LifeCoverage.InsurPlcyInsurContr AS InsurPlcyInsurContrForEdit,
  LifeCoverage.InsurPlcyCoveragePackageID AS InsurPlcyCvPcgIDForEdit,
  LifeCoverage.InsurPlcyCoverageID AS InsurPlcyCoverageIDForEdit,
  LifeCoverage.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  LifeCoverage.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  LifeCoverage.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  LifeCoverage.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  LifeCoverage.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  LifeCoverage.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  LifeCoverage.InsurPlcyLifeCvrgIsCanceled AS InsurPlcyLifeCvrgIsCanceled,
  LifeCoverage.InsPlcyLifeCvrgOptnPhseEndDate AS InsPlcyLifeCvrgOptnPhseEndDate,
  LifeCoverage.InsPlcyLifeCvrgIsInvldInAdjmt AS InsPlcyLifeCvrgIsInvldInAdjmt,
  LifeCoverage.InsPlcyLifeCvrgNrOfInsrdPersn AS InsPlcyLifeCvrgNrOfInsrdPersn,
  LifeCoverage.InsurPlcyLifeCvrgSuprordCvrgID AS InsurPlcyLifeCvrgSuprordCvrgID,
  LifeCoverage.InsPlcyLifeCvrgGuaranteedOptn AS InsPlcyLifeCvrgGuaranteedOptn,
  LifeCoverage.InsurPlcyLifeCvrgFundRangeID AS InsurPlcyLifeCvrgFundRangeID,
  LifeCoverage.InsurPlcyCvrgUntLinkdInvmtDte AS InsurPlcyCvrgUntLinkdInvmtDte,
  LifeCoverage.InsurPlcyLifeCvrgOptnBeginDate AS InsurPlcyLifeCvrgOptnBeginDate,
  LifeCoverage.InsPlcyCvrgElementaryProdType AS InsPlcyCvrgElementaryProdType,
  LifeCoverage.InsurPlcyLifeCvrgPremOblgn AS InsurPlcyLifeCvrgPremOblgn,
  LifeCoverage.InsurPlcyLifeCvrgPremExempt AS InsurPlcyLifeCvrgPremExempt,
  LifeCoverage.InsurPlcyLifeCvrgBnftDvdndUsge AS InsurPlcyLifeCvrgBnftDvdndUsge,
  LifeCoverage.InsPlcyLifeCvrgOptnPhseIsPosbl AS InsPlcyLifeCvrgOptnPhseIsPosbl,
  LifeCoverage.InsurPlcyLifeCvrgOptnPhseInYr AS InsurPlcyLifeCvrgOptnPhseInYr,
  LifeCoverage.InsurPlcyLifeCvrgOptnPhseMnths AS InsurPlcyLifeCvrgOptnPhseMnths,
  LifeCoverage.InsurPlcyLifeCvrgOptnFnlAgeVal AS InsurPlcyLifeCvrgOptnFnlAgeVal,
  LifeCoverage.InsPlcyLifeCvrgOptnStrtAgeVal AS InsPlcyLifeCvrgOptnStrtAgeVal,
  LifeCoverage.InsurPlcyCvrgHasSuplmntyInsur AS InsurPlcyCvrgHasSuplmntyInsur,
  LifeCoverage.InsurPlcyLifeCvrgMaxOptnPhseYr AS InsurPlcyLifeCvrgMaxOptnPhseYr,
  LifeCoverage.InsurPlcyLifeCvrgFundCrdtAmt AS InsurPlcyLifeCvrgFundCrdtAmt,
  LifeCoverage.InsurPlcyLifeCvrgMaxNrOfShifts AS InsurPlcyLifeCvrgMaxNrOfShifts,
  LifeCoverage.InsurPlcyLifeCvrgFundShiftID AS InsurPlcyLifeCvrgFundShiftID,
  LifeCoverage.InsurPlcyLifeCvrgTgtFundRngeID AS InsurPlcyLifeCvrgTgtFundRngeID,
  LifeCoverage.InsurPlcyLifeCvrgIsSubjToTax AS InsurPlcyLifeCvrgIsSubjToTax,
  LifeCoverage.InsurPlcyLifeCvrgCurrency AS InsurPlcyLifeCvrgCurrency,
  LifeCoverage.InsurPlcyLifeCvrgBusGrpIsDtmnd AS InsurPlcyLifeCvrgBusGrpIsDtmnd,
  LifeCoverage.InsPlcyLifeCvrgRskTypeIsDtmnd AS InsPlcyLifeCvrgRskTypeIsDtmnd,
  LifeCoverage.InsurPlcyLifeCvrgFundCrdtPrpty AS InsurPlcyLifeCvrgFundCrdtPrpty,
  LifeCoverage.InsurPlcyLifeCvrgAnnuRcptType AS InsurPlcyLifeCvrgAnnuRcptType,
  LifeCoverage.InsurPlcyLifeCvrgOption AS InsurPlcyLifeCvrgOption,
  LifeCoverage.InsurPlcyCvrgDvdndAllcdDayMnth AS InsurPlcyCvrgDvdndAllcdDayMnth,
  LifeCoverage.InsurPlcyLifeCvrgIsInOptnPhase AS InsurPlcyLifeCvrgIsInOptnPhase,
  LifeCoverage.InsPlcyCvrgExtnOptnIsExercised AS InsPlcyCvrgExtnOptnIsExercised,
  LifeCoverage.InsPlcyLifeCvrgIsYrlyRollover AS InsPlcyLifeCvrgIsYrlyRollover,
  LifeCoverage.InsurPlcyCvrgIsExprtnIsExtd AS InsurPlcyCvrgIsExprtnIsExtd,
  LifeCoverage.InsurPlcyLifeCvrgFundAstMaxAmt AS InsurPlcyLifeCvrgFundAstMaxAmt,
  LifeCoverage.InsurPlcyLifeCvrgAcctgVarAnnu AS InsurPlcyLifeCvrgAcctgVarAnnu,
  LifeCoverage.InsurPlcyCvrgAnnuDisbmtType AS InsurPlcyCvrgAnnuDisbmtType,
  LifeCoverage.InsurPlcyCvrgPrptySrrndrAmt AS InsurPlcyCvrgPrptySrrndrAmt,
  LifeCoverage.InsurPlcyLifeCvrgWaitingPeriod AS InsurPlcyLifeCvrgWaitingPeriod,
  LifeCoverage.InsurPlcyCvrgDvdndCrdtIsTrnsfd AS InsurPlcyCvrgDvdndCrdtIsTrnsfd,
  LifeCoverage.InsurPlcyLifeCvrgFundPaletteID AS InsurPlcyLifeCvrgFundPaletteID,
  LifeCoverage.InsurPlcyCvrgFundDistrIsTrnsfd AS InsurPlcyCvrgFundDistrIsTrnsfd,
  LifeCoverage.InsPlcyCvrgInvestedFundAstAmt AS InsPlcyCvrgInvestedFundAstAmt,
  LifeCoverage.InsurPlcyLifeCvrgCalcRuleType AS InsurPlcyLifeCvrgCalcRuleType,
  LifeCoverage.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  LifeCoverage.LastChangeDateTime AS LastChangeDateTime,
  LifeCoverage._Currency AS _Currency
FROM I_InsurPlcyLifeCoverageVersion AS LifeCoverage
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_InsurancePolicyTP_3 AS _Policy ON InsurPlcyUUID = _Policy.InsurPlcyUUID AND InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID  -- association [1..1]
LEFT OUTER JOIN E_InsuranceLifeCoverage AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr  -- association [1..1]
;

Learn More