R_InsurPlcyModelCalculationD

DDL: R_INSURPLCYMODELCALCULATIOND Type: view_entity BASIC

Model Calculation - Draft

R_InsurPlcyModelCalculationD is a Basic CDS View that provides data about "Model Calculation - Draft" in SAP S/4HANA. It reads from 1 data source (/pm0/aldrprojec) and exposes 118 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/pm0/aldrprojec /pm0/aldrprojec from

Associations (3)

CardinalityTargetAliasCondition
[1..1] E_InsurPlcyModelCalculationD _Extension $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Extension.InsurPlcyApplUUID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.InsurPlcyModCalcID = _Extension.InsurPlcyModCalcID and $projection.DraftUUID = _Extension.DraftUUID
[0..*] R_InsurPlcyModCalculationTaxD _ModelCalTax $projection.InsurPlcyUUIDForEdit = _ModelCalTax.InsurPlcyUUID and $projection.InsurPlcyApplUUIDForEdit = _ModelCalTax.InsurPlcyApplUUID and $projection.InsurPlcyInsurContrForEdit = _ModelCalTax.InsurPlcyInsurContr and $projection.InsurPlcyCvPcgIDForEdit = _ModelCalTax.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageIDForEdit = _ModelCalTax.InsurPlcyCoverageID and $projection.InsurPlcyModCalcIDForEdit = _ModelCalTax.InsurPlcyModCalcID
[0..*] R_InsurPlcyFundDistrSimlnDraft _FundDistrSimln $projection.InsurPlcyUUIDForEdit = _FundDistrSimln.InsurPlcyUUID and $projection.InsurPlcyApplUUIDForEdit = _FundDistrSimln.InsurPlcyApplUUID and $projection.InsurPlcyInsurContrForEdit = _FundDistrSimln.InsurPlcyInsurContr and $projection.InsurPlcyCvPcgIDForEdit = _FundDistrSimln.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageIDForEdit = _FundDistrSimln.InsurPlcyCoverageID and $projection.InsurPlcyModCalcIDForEdit = _FundDistrSimln.InsurPlcyModCalcID

Annotations (10)

NameValueLevelField
EndUserText.label Model Calculation - Draft view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix PMC view
AbapCatalog.extensibility.allowNewDatasources false view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (118)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID insurplcyuuid Policy UUID
KEY InsurPlcyApplUUID insurplcyappluuid Policy UUID
KEY InsurPlcyInsurContr insurplcyinsurcontr Contract Key
KEY InsurPlcyCoveragePackageID insurplcycoveragepackageid Cov.Package ID
KEY InsurPlcyCoverageID insurplcycoverageid Coverage Key
KEY InsurPlcyModCalcID insurplcymodcalcid Model Calc. ID
KEY DraftUUID draftuuid UUID
InsurPlcyUUIDForEdit insurplcyuuid Policy UUID
InsurPlcyApplUUIDForEdit insurplcyappluuid Policy UUID
InsurPlcyInsurContrForEdit insurplcyinsurcontr Contract Key
InsurPlcyCvPcgIDForEdit insurplcycoveragepackageid Cov.Package ID
InsurPlcyCoverageIDForEdit insurplcycoverageid Coverage Key
InsurPlcyModCalcIDForEdit insurplcymodcalcid Model Calc. ID
InsurPlcyOrderNumber insurplcyordernumber Sequence Number
InsurPlcyBusProcType insurplcybusproctype Bus. Process
InsurPlcyBusProcessNumerator insurplcybusprocessnumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr insurplcyjrnlendnmbr Term. Jour. No.
InsurPlcyJrnlNmbr insurplcyjrnlnmbr Journal Number
InsurPlcyProductPackageID insurplcyproductpackageid Prod. Pckg. Key
InsurPlcyModCalcIsCancelled insurplcymodcalciscancelled Rev. Flag
InsurancePolicy insurancepolicy Policy Number
InsurancePolicyContract insurancepolicycontract Contract Number
InsurancePolicyApplication insurancepolicyapplication Application No.
InsurPlcyModCalcActivityID insurplcymodcalcactivityid Activity ID
InsurPlcyModCalcIsPlcyLoanRplc insurplcymodcalcisplcyloanrplc Replace Pol. Ln
InsurPlcyModCalcPayoutDate insurplcymodcalcpayoutdate Payout Date
InsurPlcyModCalcYearView insurplcymodcalcyearview Res. Disp. Int.
InsurPlcyMClcIntrstDvdndRate insurplcymclcintrstdvdndrate Int.Div.Rate %
InsurPlcyMClcInvcIntrstRate insurplcymclcinvcintrstrate Inv.Int.Rate(%)
InsurPlcyMClcBaseDividendRate insurplcymclcbasedividendrate Base Div.Rate %
InsurPlcyMClcFnlDividendRate insurplcymclcfnldividendrate Fin.Div.Rate %
InsurPlcyModCalcAvailLoanAmt insurplcymodcalcavailloanamt AvailLoanAmount
InsurPlcyMClcTotBnftAftTaxAmt insurplcymclctotbnftafttaxamt Total After Tax
InsurPlcyModCalcInsuredPersnID insurplcymodcalcinsuredpersnid Selected Person
InsurPlcyMClcHasModelCalcAdjmt insurplcymclchasmodelcalcadjmt Calc. with Adj.
InsurPlcyMClcGuarDeathBnftAmt insurplcymclcguardeathbnftamt Guar.Death Ben.
InsurPlcyMClcDthBnftDvdndAmt insurplcymclcdthbnftdvdndamt Death Ben. Div.
InsurPlcyMClcEndowmentBnftAmt insurplcymclcendowmentbnftamt End. Ben. Guar.
InsurPlcyModCalcGuarSrrndrAmt insurplcymodcalcguarsrrndramt Guar.Surr.Value
InsurPlcyMClcSrrndrDividendAmt insurplcymclcsrrndrdividendamt SurrValSurplus
InsurPlcyMClcAnnuExmptDthAmt insurplcymclcannuexmptdthamt PremExemptAnnui
InsurPlcyMClcPremExmptPremAmt insurplcymclcpremexmptpremamt PrmEx DeathBen
InsurPlcyMClcExmptEndowmentAmt insurplcymclcexmptendowmentamt PrmExmptEndwBen
InsurPlcyModCalcPremiumTotAmt insurplcymodcalcpremiumtotamt Premium Total
InsurPlcyMClcDthBnftBonusAmt insurplcymclcdthbnftbonusamt Death Ben. Bon.
InsurPlcyMClcEndowmentBonusAmt insurplcymclcendowmentbonusamt EndowBenBonus
InsurPlcyMClcFinalDividendAmt insurplcymclcfinaldividendamt Final Surplus
InsurPlcyMClcAnnuDividendAmt insurplcymclcannudividendamt YA From Surplus
InsurPlcyMClcGuarYearlyAnnuAmt insurplcymclcguaryearlyannuamt Guaranteed YA
InsurPlcyMClcMonetaryGuarAmt insurplcymclcmonetaryguaramt MontCompGuarant
InsurPlcyMClcCompsDvdndAmt insurplcymclccompsdvdndamt MontComp Div.
InsurPlcyMClcPrtlPaytGuarAmt insurplcymclcprtlpaytguaramt Part. Payt Guar
InsurPlcyMClcPrtlTotGuarAmt insurplcymclcprtltotguaramt Prt.PaytTotGuar
InsurPlcyMClcPrtlPaytDvdndAmt insurplcymclcprtlpaytdvdndamt Part.Pmnt Div.
InsurPlcyMClcTotPrtlDvdndAmt insurplcymclctotprtldvdndamt TotPart.PmntDiv
InsurPlcyMClcTotAnnuDvdndAmt insurplcymclctotannudvdndamt TotYrlyAntyWDiv
InsurPlcyMClcBonusMarriageAmt insurplcymclcbonusmarriageamt Marriage Bonus
InsurPlcyMClcBnsBnftOnRsrvAmt insurplcymclcbnsbnftonrsrvamt Bonus Reserve
InsurPlcyModCalcRsrvAmt insurplcymodcalcrsrvamt Reserve
InsurPlcyMClcBnftOnMarriageAmt insurplcymclcbnftonmarriageamt Marriage Ben.
InsurPlcyMClcMarriageGuarAmt insurplcymclcmarriageguaramt MarrBen.Guaran.
InsurPlcyModCalcMttyBnftAmt insurplcymodcalcmttybnftamt Maturity Ben.
InsurPlcyMClcBnsBnftSrrndrAmt insurplcymclcbnsbnftsrrndramt Bon. Ben. Surr.
InsurPlcyMClcAccmltdIntrstAmt insurplcymclcaccmltdintrstamt Accum. Interest
InsurPlcyMClcDividendSrrndrAmt insurplcymclcdividendsrrndramt Fin.Div.Surr.
InsurPlcyMClcOccptlDsbltyAmt insurplcymclcoccptldsbltyamt Final Div. OD
InsurPlcyMClcFnlDividendDthAmt insurplcymclcfnldividenddthamt Fin. Div.Death
InsurPlcyMClcBnftTotLessLnAmt insurplcymclcbnfttotlesslnamt Totl Less PolLn
InsurPlcyModCalcMaxLoanAmt insurplcymodcalcmaxloanamt Max. Loan Amt
InsurPlcyModCalcDisplay insurplcymodcalcdisplay Display
InsurPlcyModCalcEvent insurplcymodcalcevent Event
InsurPlcyMClcInstntPremDiscAmt insurplcymclcinstntpremdiscamt Inst. Prem. Dis
InsurPlcyMClcBnftDthBnfcyAmt insurplcymclcbnftdthbnfcyamt Ben. Death Prov
InsurPlcyMClcHasIntrstCorridor insurplcymclchasintrstcorridor Interest Corr.
InsurPlcyModCalcForPersn insurplcymodcalcforpersn Calc. for Pers.
InsurPlcyModCalcdCurAmt insurplcymodcalcdcuramt Calc. Curr. Val
InsurPlcyMClcElementaryProdID insurplcymclcelementaryprodid Element. Prod.
InsurPlcyModCalcCurrency insurplcymodcalccurrency Currency
InsurPlcyModCalcGuaranteedAmt insurplcymodcalcguaranteedamt Guaranteed Amt
InsurPlcyMClcProjtdGuarAmt insurplcymclcprojtdguaramt PrjctGuar.Total
InsurPlcyModCalcCurPremTotAmt insurplcymodcalccurpremtotamt Cur. Prem. Tot.
InsurPlcyMClcProjtdPremTotAmt insurplcymclcprojtdpremtotamt Proj.Prem. Tot.
InsurPlcyMClcCurSubsidyPremAmt insurplcymclccursubsidypremamt CurrSubsPremTot
InsurPlcyMClcProjtdSubsidyAmt insurplcymclcprojtdsubsidyamt PrjctdSubsdyPrm
InsurPlcyModCalcMinRskAmt insurplcymodcalcminrskamt Min. Risk Amt
InsurPlcyMClcRvslDeductionAmt insurplcymclcrvsldeductionamt Reversal Dedctn
InsurPlcyModCalcMinDthBnftAmt insurplcymodcalcmindthbnftamt Min.Death Ben.
InsurPlcyModCalcSmltdLoanAmt insurplcymodcalcsmltdloanamt Sim. Loan Amt
InsurPlcyModCalcIntrstPayFrq insurplcymodcalcintrstpayfrq Payment Frequency
InsurPlcyMClcLnAmtAftSimlnAmt insurplcymclclnamtaftsimlnamt AvailLoanAmtAfterSim
InsurPlcyMClcEffctvIntrstMeth insurplcymclceffctvintrstmeth Eff.int.meth.
InsurPlcyMClcEffctvIntrstRate insurplcymclceffctvintrstrate Eff.Int.Rate(%)
InsurPlcyModCalcIntrstCalcMeth insurplcymodcalcintrstcalcmeth Int.Calc.Method
InsurPlcyMClcNextInstlmntAmt insurplcymclcnextinstlmntamt NxtWholeIntInst
InsurPlcyModCalcTotalLoanAmt insurplcymodcalctotalloanamt Total Loan Amount
InsurPlcyModCalcScenario insurplcymodcalcscenario Scenario
InsurPlcyMClcAgreedIntrstRate insurplcymclcagreedintrstrate Agreed Int.Rt %
InsurPlcyMClcStsOfFundAssetAmt insurplcymclcstsoffundassetamt Fund Assets
InsurPlcyModCalcPremAftTaxAmt insurplcymodcalcpremafttaxamt Prem. After Tax
InsurPlcyModCalcAnnAnnuityAmt insurplcymodcalcannannuityamt Annual Annuity
InsurPlcyModCalcPayFrq insurplcymodcalcpayfrq Payment Frequency
InsurPlcyModCalcPensionAmt insurplcymodcalcpensionamt Ann. (Pay.Freq)
InsurPlcyMClcStrtPremExmpDte insurplcymclcstrtpremexmpdte Prem Exem.Start
InsurPlcyModCalcTotPaidPremAmt insurplcymodcalctotpaidpremamt TotPaidPymtPrem
InsurPlcyModCalcNomIntrstRate insurplcymodcalcnomintrstrate Nom.Int.Rate(%)
InsurPlcyModCalcIntrstAgrmtID insurplcymodcalcintrstagrmtid Int. Agreement
InsurPlcyModCalcAnniversary insurplcymodcalcanniversary Anniversary
InsurPlcyMClcDividendFndsAmt insurplcymclcdividendfndsamt Div. from Funds
InsurPlcyModCalcCauseOfLoss insurplcymodcalccauseofloss Cause of Loss
LastChangeDateTime lastchangedatetime Timestamp
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
_ModelCalTax _ModelCalTax
_FundDistrSimln _FundDistrSimln

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_InsurPlcyModelCalculationD.
-- 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_InsurPlcyModelCalculationD AS
SELECT
  InsurPlcyUUID,
  InsurPlcyApplUUID,
  InsurPlcyInsurContr,
  InsurPlcyCoveragePackageID,
  InsurPlcyCoverageID,
  InsurPlcyModCalcID,
  DraftUUID,
  insurplcyuuid AS InsurPlcyUUIDForEdit,
  insurplcyappluuid AS InsurPlcyApplUUIDForEdit,
  insurplcyinsurcontr AS InsurPlcyInsurContrForEdit,
  insurplcycoveragepackageid AS InsurPlcyCvPcgIDForEdit,
  insurplcycoverageid AS InsurPlcyCoverageIDForEdit,
  insurplcymodcalcid AS InsurPlcyModCalcIDForEdit,
  InsurPlcyOrderNumber,
  InsurPlcyBusProcType,
  InsurPlcyBusProcessNumerator,
  InsurPlcyJrnlEndNmbr,
  InsurPlcyJrnlNmbr,
  InsurPlcyProductPackageID,
  InsurPlcyModCalcIsCancelled,
  InsurancePolicy,
  InsurancePolicyContract,
  InsurancePolicyApplication,
  InsurPlcyModCalcActivityID,
  InsurPlcyModCalcIsPlcyLoanRplc,
  InsurPlcyModCalcPayoutDate,
  InsurPlcyModCalcYearView,
  InsurPlcyMClcIntrstDvdndRate,
  InsurPlcyMClcInvcIntrstRate,
  InsurPlcyMClcBaseDividendRate,
  InsurPlcyMClcFnlDividendRate,
  InsurPlcyModCalcAvailLoanAmt,
  InsurPlcyMClcTotBnftAftTaxAmt,
  InsurPlcyModCalcInsuredPersnID,
  InsurPlcyMClcHasModelCalcAdjmt,
  InsurPlcyMClcGuarDeathBnftAmt,
  InsurPlcyMClcDthBnftDvdndAmt,
  InsurPlcyMClcEndowmentBnftAmt,
  InsurPlcyModCalcGuarSrrndrAmt,
  InsurPlcyMClcSrrndrDividendAmt,
  InsurPlcyMClcAnnuExmptDthAmt,
  InsurPlcyMClcPremExmptPremAmt,
  InsurPlcyMClcExmptEndowmentAmt,
  InsurPlcyModCalcPremiumTotAmt,
  InsurPlcyMClcDthBnftBonusAmt,
  InsurPlcyMClcEndowmentBonusAmt,
  InsurPlcyMClcFinalDividendAmt,
  InsurPlcyMClcAnnuDividendAmt,
  InsurPlcyMClcGuarYearlyAnnuAmt,
  InsurPlcyMClcMonetaryGuarAmt,
  InsurPlcyMClcCompsDvdndAmt,
  InsurPlcyMClcPrtlPaytGuarAmt,
  InsurPlcyMClcPrtlTotGuarAmt,
  InsurPlcyMClcPrtlPaytDvdndAmt,
  InsurPlcyMClcTotPrtlDvdndAmt,
  InsurPlcyMClcTotAnnuDvdndAmt,
  InsurPlcyMClcBonusMarriageAmt,
  InsurPlcyMClcBnsBnftOnRsrvAmt,
  InsurPlcyModCalcRsrvAmt,
  InsurPlcyMClcBnftOnMarriageAmt,
  InsurPlcyMClcMarriageGuarAmt,
  InsurPlcyModCalcMttyBnftAmt,
  InsurPlcyMClcBnsBnftSrrndrAmt,
  InsurPlcyMClcAccmltdIntrstAmt,
  InsurPlcyMClcDividendSrrndrAmt,
  InsurPlcyMClcOccptlDsbltyAmt,
  InsurPlcyMClcFnlDividendDthAmt,
  InsurPlcyMClcBnftTotLessLnAmt,
  InsurPlcyModCalcMaxLoanAmt,
  InsurPlcyModCalcDisplay,
  InsurPlcyModCalcEvent,
  InsurPlcyMClcInstntPremDiscAmt,
  InsurPlcyMClcBnftDthBnfcyAmt,
  InsurPlcyMClcHasIntrstCorridor,
  InsurPlcyModCalcForPersn,
  InsurPlcyModCalcdCurAmt,
  InsurPlcyMClcElementaryProdID,
  InsurPlcyModCalcCurrency,
  InsurPlcyModCalcGuaranteedAmt,
  InsurPlcyMClcProjtdGuarAmt,
  InsurPlcyModCalcCurPremTotAmt,
  InsurPlcyMClcProjtdPremTotAmt,
  InsurPlcyMClcCurSubsidyPremAmt,
  InsurPlcyMClcProjtdSubsidyAmt,
  InsurPlcyModCalcMinRskAmt,
  InsurPlcyMClcRvslDeductionAmt,
  InsurPlcyModCalcMinDthBnftAmt,
  InsurPlcyModCalcSmltdLoanAmt,
  InsurPlcyModCalcIntrstPayFrq,
  InsurPlcyMClcLnAmtAftSimlnAmt,
  InsurPlcyMClcEffctvIntrstMeth,
  InsurPlcyMClcEffctvIntrstRate,
  InsurPlcyModCalcIntrstCalcMeth,
  InsurPlcyMClcNextInstlmntAmt,
  InsurPlcyModCalcTotalLoanAmt,
  InsurPlcyModCalcScenario,
  InsurPlcyMClcAgreedIntrstRate,
  InsurPlcyMClcStsOfFundAssetAmt,
  InsurPlcyModCalcPremAftTaxAmt,
  InsurPlcyModCalcAnnAnnuityAmt,
  InsurPlcyModCalcPayFrq,
  InsurPlcyModCalcPensionAmt,
  InsurPlcyMClcStrtPremExmpDte,
  InsurPlcyModCalcTotPaidPremAmt,
  InsurPlcyModCalcNomIntrstRate,
  InsurPlcyModCalcIntrstAgrmtID,
  InsurPlcyModCalcAnniversary,
  InsurPlcyMClcDividendFndsAmt,
  InsurPlcyModCalcCauseOfLoss,
  LastChangeDateTime,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM /pm0/aldrprojec
LEFT OUTER JOIN E_InsurPlcyModelCalculationD AS _Extension ON InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyApplUUID = _Extension.InsurPlcyApplUUID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyModCalcID = _Extension.InsurPlcyModCalcID AND DraftUUID = _Extension.DraftUUID  -- association [1..1]
LEFT OUTER JOIN R_InsurPlcyModCalculationTaxD AS _ModelCalTax ON InsurPlcyUUIDForEdit = _ModelCalTax.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _ModelCalTax.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _ModelCalTax.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _ModelCalTax.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _ModelCalTax.InsurPlcyCoverageID AND InsurPlcyModCalcIDForEdit = _ModelCalTax.InsurPlcyModCalcID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyFundDistrSimlnDraft AS _FundDistrSimln ON InsurPlcyUUIDForEdit = _FundDistrSimln.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _FundDistrSimln.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _FundDistrSimln.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _FundDistrSimln.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _FundDistrSimln.InsurPlcyCoverageID AND InsurPlcyModCalcIDForEdit = _FundDistrSimln.InsurPlcyModCalcID  -- association [0..*]
;