R_InsurancePolicyLifeBenefitTP

DDL: R_INSURANCEPOLICYLIFEBENEFITTP Type: view_entity TRANSACTIONAL
51 Fields 2 Data Sources 2 Associations

Life Benefit - TP

R_InsurancePolicyLifeBenefitTP is a Transactional CDS View that provides data about "Life Benefit - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyHghstVersPerAppl, I_InsurPlcyLifeBenefitVersion) and exposes 51 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_InsurPlcyLifeBenefitVersion LifeBenefit from

Associations (2)

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

Annotations (13)

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

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyLifeBenefitVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyLifeBenefitVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyLifeBenefitVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyLifeBenefitVersion InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyLifeBenefitVersion InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID I_InsurPlcyLifeBenefitVersion InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyBenefitID I_InsurPlcyLifeBenefitVersion InsurPlcyBenefitID Benefit
InsurPlcyUUIDForEdit I_InsurPlcyLifeBenefitVersion InsurPlcyUUID Policy UUID
InsurPlcyApplUUIDForEdit I_InsurPlcyLifeBenefitVersion InsurPlcyApplUUID Policy UUID
InsurPlcyInsurContrForEdit I_InsurPlcyLifeBenefitVersion InsurPlcyInsurContr Contract Key
InsurPlcyCvPcgIDForEdit I_InsurPlcyLifeBenefitVersion InsurPlcyCoveragePackageID Cov.Package ID
InsurPlcyCoverageIDForEdit I_InsurPlcyLifeBenefitVersion InsurPlcyCoverageID Coverage Key
InsurPlcyCvrgOptnIDForEdit I_InsurPlcyLifeBenefitVersion InsurPlcyCoverageOptionID Cov. Option Key
InsurPlcyBenefitIDForEdit I_InsurPlcyLifeBenefitVersion InsurPlcyBenefitID Benefit
InsurPlcyOrderNumber I_InsurPlcyLifeBenefitVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyLifeBenefitVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyLifeBenefitVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurPlcyLifeBenefitVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPlcyLifeBenefitVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPlcyLifeBenefitVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyBnftIsCancld I_InsurPlcyLifeBenefitVersion InsurPlcyBnftIsCancld Rev. Flag
InsurPlcyBnftPayFrq I_InsurPlcyLifeBenefitVersion InsurPlcyBnftPayFrq PaymentFreq.
InsurPlcyBnftAnnuGuarStartDate I_InsurPlcyLifeBenefitVersion InsurPlcyBnftAnnuGuarStartDate Annuity Start
InsurPlcyBnftAnnuGuarEndDate I_InsurPlcyLifeBenefitVersion InsurPlcyBnftAnnuGuarEndDate Ann. Guar. End
InsurPlcyBnftMinRskAmt I_InsurPlcyLifeBenefitVersion InsurPlcyBnftMinRskAmt Min. Risk Amt
InsurPlcyBnftEndowmentTotalAmt I_InsurPlcyLifeBenefitVersion InsurPlcyBnftEndowmentTotalAmt End. Ben. Total
InsurPlcyBnftDeathTotalAmt I_InsurPlcyLifeBenefitVersion InsurPlcyBnftDeathTotalAmt Death B. Total
InsurPlcyBnftMinDeathTotalAmt I_InsurPlcyLifeBenefitVersion InsurPlcyBnftMinDeathTotalAmt Min. Death Ben.
InsurPlcyBnftHasPremiumRefund I_InsurPlcyLifeBenefitVersion InsurPlcyBnftHasPremiumRefund Premium Refund
InsurPlcyBnftAnnAnnuityAmt I_InsurPlcyLifeBenefitVersion InsurPlcyBnftAnnAnnuityAmt Annual Annuity
InsurPlcyBnftAnnuityPaytMode I_InsurPlcyLifeBenefitVersion InsurPlcyBnftAnnuityPaytMode Payment Mode
InsurPlcyEndowmentFctrVal I_InsurPlcyLifeBenefitVersion InsurPlcyEndowmentFctrVal SInEndBenTotFac
InsurPlcyBnftAbsltInsrdSumAmt I_InsurPlcyLifeBenefitVersion InsurPlcyBnftAbsltInsrdSumAmt Abs. Sum Ins.
InsurPlcyBnftRltvInsrdSumAmt I_InsurPlcyLifeBenefitVersion InsurPlcyBnftRltvInsrdSumAmt Rel. Sum Ins.
InsurPlcyBnftPensionAmt I_InsurPlcyLifeBenefitVersion InsurPlcyBnftPensionAmt Ann. (Pay.Freq)
InsurPlcyBnftDeathTotalRate I_InsurPlcyLifeBenefitVersion InsurPlcyBnftDeathTotalRate DeathBen Ttl %
InsurPlcyBnftAnnAnnuityRate I_InsurPlcyLifeBenefitVersion InsurPlcyBnftAnnAnnuityRate Annual Ann. %
InsurPlcyBnftMinDeathTotalRate I_InsurPlcyLifeBenefitVersion InsurPlcyBnftMinDeathTotalRate MinDeath Ben(%)
InsurPlcyBnftSpecDeath I_InsurPlcyLifeBenefitVersion InsurPlcyBnftSpecDeath BenSpecDeath
InsurPlcyBnftSpecPayment I_InsurPlcyLifeBenefitVersion InsurPlcyBnftSpecPayment Benefit Spec.
InsurPlcyBnftSpecAnnAnnuity I_InsurPlcyLifeBenefitVersion InsurPlcyBnftSpecAnnAnnuity BenSpAlAnnuity
InsurPlcyBnftSpecMinDeath I_InsurPlcyLifeBenefitVersion InsurPlcyBnftSpecMinDeath Min. Death Ben.
InsurPlcyBnftMinRiskAmtRate I_InsurPlcyLifeBenefitVersion InsurPlcyBnftMinRiskAmtRate Min. Risk Amt %
InsurPlcyBnftCrcy I_InsurPlcyLifeBenefitVersion InsurPlcyBnftCrcy Currency
InsurPlcyBnftChangeFrqcy I_InsurPlcyLifeBenefitVersion InsurPlcyBnftChangeFrqcy Change Frequency
InsurPlcyBnftDthSuplmntyRate I_InsurPlcyLifeBenefitVersion InsurPlcyBnftDthSuplmntyRate Unit-Link DSI %
InsurPlcyBnftCvrgOption I_InsurPlcyLifeBenefitVersion InsurPlcyBnftCvrgOption Option
InsurPlcyBusinessObject I_InsurPlcyLifeBenefitVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyLifeBenefitVersion LastChangeDateTime Timestamp
_Currency I_InsurPlcyLifeBenefitVersion _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_InsurancePolicyLifeBenefitTP.
-- 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_InsurancePolicyLifeBenefitTP AS
SELECT
  LifeBenefit.InsurPlcyUUID AS InsurPlcyUUID,
  LifeBenefit.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  LifeBenefit.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  LifeBenefit.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  LifeBenefit.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  LifeBenefit.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  LifeBenefit.InsurPlcyBenefitID AS InsurPlcyBenefitID,
  LifeBenefit.InsurPlcyUUID AS InsurPlcyUUIDForEdit,
  LifeBenefit.InsurPlcyApplUUID AS InsurPlcyApplUUIDForEdit,
  LifeBenefit.InsurPlcyInsurContr AS InsurPlcyInsurContrForEdit,
  LifeBenefit.InsurPlcyCoveragePackageID AS InsurPlcyCvPcgIDForEdit,
  LifeBenefit.InsurPlcyCoverageID AS InsurPlcyCoverageIDForEdit,
  LifeBenefit.InsurPlcyCoverageOptionID AS InsurPlcyCvrgOptnIDForEdit,
  LifeBenefit.InsurPlcyBenefitID AS InsurPlcyBenefitIDForEdit,
  LifeBenefit.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  LifeBenefit.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  LifeBenefit.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  LifeBenefit.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  LifeBenefit.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  LifeBenefit.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  LifeBenefit.InsurPlcyBnftIsCancld AS InsurPlcyBnftIsCancld,
  LifeBenefit.InsurPlcyBnftPayFrq AS InsurPlcyBnftPayFrq,
  LifeBenefit.InsurPlcyBnftAnnuGuarStartDate AS InsurPlcyBnftAnnuGuarStartDate,
  LifeBenefit.InsurPlcyBnftAnnuGuarEndDate AS InsurPlcyBnftAnnuGuarEndDate,
  LifeBenefit.InsurPlcyBnftMinRskAmt AS InsurPlcyBnftMinRskAmt,
  LifeBenefit.InsurPlcyBnftEndowmentTotalAmt AS InsurPlcyBnftEndowmentTotalAmt,
  LifeBenefit.InsurPlcyBnftDeathTotalAmt AS InsurPlcyBnftDeathTotalAmt,
  LifeBenefit.InsurPlcyBnftMinDeathTotalAmt AS InsurPlcyBnftMinDeathTotalAmt,
  LifeBenefit.InsurPlcyBnftHasPremiumRefund AS InsurPlcyBnftHasPremiumRefund,
  LifeBenefit.InsurPlcyBnftAnnAnnuityAmt AS InsurPlcyBnftAnnAnnuityAmt,
  LifeBenefit.InsurPlcyBnftAnnuityPaytMode AS InsurPlcyBnftAnnuityPaytMode,
  LifeBenefit.InsurPlcyEndowmentFctrVal AS InsurPlcyEndowmentFctrVal,
  LifeBenefit.InsurPlcyBnftAbsltInsrdSumAmt AS InsurPlcyBnftAbsltInsrdSumAmt,
  LifeBenefit.InsurPlcyBnftRltvInsrdSumAmt AS InsurPlcyBnftRltvInsrdSumAmt,
  LifeBenefit.InsurPlcyBnftPensionAmt AS InsurPlcyBnftPensionAmt,
  LifeBenefit.InsurPlcyBnftDeathTotalRate AS InsurPlcyBnftDeathTotalRate,
  LifeBenefit.InsurPlcyBnftAnnAnnuityRate AS InsurPlcyBnftAnnAnnuityRate,
  LifeBenefit.InsurPlcyBnftMinDeathTotalRate AS InsurPlcyBnftMinDeathTotalRate,
  LifeBenefit.InsurPlcyBnftSpecDeath AS InsurPlcyBnftSpecDeath,
  LifeBenefit.InsurPlcyBnftSpecPayment AS InsurPlcyBnftSpecPayment,
  LifeBenefit.InsurPlcyBnftSpecAnnAnnuity AS InsurPlcyBnftSpecAnnAnnuity,
  LifeBenefit.InsurPlcyBnftSpecMinDeath AS InsurPlcyBnftSpecMinDeath,
  LifeBenefit.InsurPlcyBnftMinRiskAmtRate AS InsurPlcyBnftMinRiskAmtRate,
  LifeBenefit.InsurPlcyBnftCrcy AS InsurPlcyBnftCrcy,
  LifeBenefit.InsurPlcyBnftChangeFrqcy AS InsurPlcyBnftChangeFrqcy,
  LifeBenefit.InsurPlcyBnftDthSuplmntyRate AS InsurPlcyBnftDthSuplmntyRate,
  LifeBenefit.InsurPlcyBnftCvrgOption AS InsurPlcyBnftCvrgOption,
  LifeBenefit.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  LifeBenefit.LastChangeDateTime AS LastChangeDateTime,
  LifeBenefit._Currency AS _Currency
FROM I_InsurPlcyLifeBenefitVersion AS LifeBenefit
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_InsurancePolicyLifeBenefit AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyBenefitID = _Extension.InsurPlcyBenefitID  -- association [1..1]
;

Learn More