R_InsurancePolicyTP_3

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_InsurancePolicyTP_3.
-- 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_InsurancePolicyTP_3 AS
SELECT
  Policy.InsurPlcyUUID AS InsurPlcyUUID,
  Policy.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  Policy.InsurPlcyUUID AS InsurPlcyUUIDForEdit,
  Policy.InsurPlcyApplUUID AS InsurPlcyApplUUIDForEdit,
  cast(0 as /pm0/abd_polpr_id ) AS InsurPlcyInsurContr,
  cast(0 as /pm0/abd_covpac_id ) AS InsurPlcyCoveragePackageID,
  cast(0 as /pm0/abd_coverage_id ) AS InsurPlcyCoverageID,
  cast(0 as /pm0/abd_covcp_id ) AS InsurPlcyCoverageOptionID,
  cast(0 as /pm0/abd_subj_id ) AS InsurPlcyInsuredObjectID,
  cast(0 as /pm0/abd_uwdcn_id ) AS InsurPlcyUndrwrtgDcsnRiskID,
  cast(0 as /pm0/abd_covcpco_id ) AS InsurPlcySubCvrgID,
  Policy.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  Policy.InsurancePolicy AS InsurancePolicy,
  Policy.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  Policy.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  Policy.InsurPlcyBusProcEffectiveDate AS InsurPlcyBusProcEffectiveDate,
  Policy.InsurApplSgntrDte AS InsurApplSgntrDte,
  Policy.InsurApplRcptDte AS InsurApplRcptDte,
  Policy.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Policy.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Policy.InsurPlcyAuthznSlsProductGroup AS InsurPlcyAuthznSlsProductGroup,
  Policy.InsurPlcyStartDateTime AS InsurPlcyStartDateTime,
  Policy.InsurPolicyStartDate AS InsurPolicyStartDate,
  Policy.InsurancePolicyStartTime AS InsurancePolicyStartTime,
  Policy.InsurancePolicyStartTimeZone AS InsurancePolicyStartTimeZone,
  Policy.InsurApplLifeCycSts AS InsurApplLifeCycSts,
  Policy.InsurPlcyDistrChnl AS InsurPlcyDistrChnl,
  Policy.InsrrIDByInsrr AS InsrrIDByInsrr,
  Policy.InsurPlcySalesProductTemplate AS InsurPlcySalesProductTemplate,
  Policy.InsurPlcyAcqnType AS InsurPlcyAcqnType,
  Policy.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  Policy.PrdcssrInsurancePolicy AS PrdcssrInsurancePolicy,
  Policy.LastChangeDateTime AS LastChangeDateTime,
  Policy.InsurPolicyCancellationStatus AS InsurPolicyCancellationStatus,
  Policy.InsurancePlcyPolicyIsCancelled AS InsurancePlcyPolicyIsCancelled,
  Policy.InsurancePolicyNumberOld AS InsurancePolicyNumberOld,
  Policy.InsurPlcyExchRateType AS InsurPlcyExchRateType,
  Policy.InsurPlcyCrcy AS InsurPlcyCrcy,
  Policy.InsurancePolicyNoteIdentifier AS InsurancePolicyNoteIdentifier,
  Policy.InsurPlcyExtApplNmbr AS InsurPlcyExtApplNmbr,
  Policy.InsurPlcyCommissionPostingCode AS InsurPlcyCommissionPostingCode,
  Policy.InsurancePolicyDuplicateID AS InsurancePolicyDuplicateID,
  Policy.InsurancePolicyGenerationDate AS InsurancePolicyGenerationDate,
  Policy.InsurPlcySrceOfGnrtnDteCode AS InsurPlcySrceOfGnrtnDteCode,
  Policy.InsurancePolicyKey AS InsurancePolicyKey,
  Policy.InsurPlcySrceDocStsDateTime AS InsurPlcySrceDocStsDateTime,
  Policy.InsurPlcyChangeOptionNumber AS InsurPlcyChangeOptionNumber,
  Policy.InsurPlcyChgOptnApplID AS InsurPlcyChgOptnApplID,
  Policy.InsurPlcyChangeOptionText AS InsurPlcyChangeOptionText,
  Policy.InsurancePolicyIsChangeOption AS InsurancePolicyIsChangeOption,
  Policy.InsurPlcyHasPndgCommsnCase AS InsurPlcyHasPndgCommsnCase,
  Policy.InsurPlcyChangeOptionCategory AS InsurPlcyChangeOptionCategory,
  Policy.InsurMstrPlcyJrnlNmbr AS InsurMstrPlcyJrnlNmbr,
  Policy.InsurMstrPlcySmplApplID AS InsurMstrPlcySmplApplID,
  Policy.InsurPlcyChgOptnRsn AS InsurPlcyChgOptnRsn,
  Policy.InsuranceMasterPolicyNumber AS InsuranceMasterPolicyNumber,
  Policy.InsurPlcyIsCoinsurPrtcpnt AS InsurPlcyIsCoinsurPrtcpnt,
  Policy.InsurPlcyGnrtnDetnDte AS InsurPlcyGnrtnDetnDte,
  Policy.InsurPlcyHasPolicyProcessing AS InsurPlcyHasPolicyProcessing,
  Policy.InsurancePolicyShiftType AS InsurancePolicyShiftType,
  Policy.InsurancePolicySubjectCode AS InsurancePolicySubjectCode,
  Policy.InsurancePolicyHasReassessment AS InsurancePolicyHasReassessment,
  Policy.InsurPlcyReassessmentNoteID AS InsurPlcyReassessmentNoteID,
  Policy.InsurPlcyPremWvrAnnulmentRsn AS InsurPlcyPremWvrAnnulmentRsn,
  Policy.InsurPlcyContractualDpndcySts AS InsurPlcyContractualDpndcySts,
  cast ( ' ' as boolean preserving type ) AS InsurPlcyIsRvslNotification,
  cast ( '00000' as /pm0/abd_cancreas_cd preserving type ) AS InsurPlcyContrCanclnRsn
FROM I_InsurancePolicyVersion AS Policy
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_InsurPlcyAgentTP_2 AS _Agent ON InsurPlcyUUIDForEdit = _Agent.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Agent.InsurPlcyApplUUID AND InsurPlcyInsurContr = _Agent.InsurPlcyInsurContr  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContractTP_2 AS _Contract ON InsurPlcyUUIDForEdit = _Contract.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _Contract.InsurPlcyApplUUIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyBeneficiaryTP AS _Beneficiary ON InsurPlcyUUIDForEdit = _Beneficiary.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Beneficiary.InsurPlcyApplUUID AND InsurPlcyInsurContr = _Beneficiary.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Beneficiary.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Beneficiary.InsurPlcyCoverageID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyClauseTP_3 AS _Clause ON InsurPlcyUUIDForEdit = _Clause.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Clause.InsurPlcyApplUUID AND InsurPlcyInsurContr = _Clause.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Clause.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Clause.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Clause.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Clause.InsurPlcyInsuredObjectID AND InsurPlcyUndrwrtgDcsnRiskID = _Clause.InsurPlcyUndrwrtgDcsnRiskID AND InsurPlcySubCvrgID = _Clause.InsurPlcySubCvrgID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyCommissionTP_2 AS _Commission ON InsurPlcyUUIDForEdit = _Commission.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _Commission.InsurPlcyApplUUIDForEdit AND InsurPlcyOrderNumber = _Commission.InsurPlcyOrderNumber AND InsurPlcyInsurContr = _Commission.InsurPlcyInsurContrForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyDifntCmmPntTP AS _DiffntCommissionParticipant ON InsurPlcyUUIDForEdit = _DiffntCommissionParticipant.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _DiffntCommissionParticipant.InsurPlcyApplUUID AND InsurPlcyInsurContr = _DiffntCommissionParticipant.InsurPlcyInsurContr  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyCreditorTP AS _Creditor ON InsurPlcyUUIDForEdit = _Creditor.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Creditor.InsurPlcyApplUUID AND InsurPlcyInsurContr = _Creditor.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Creditor.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Creditor.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Creditor.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Creditor.InsurPlcyInsuredObjectID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyDeductibleTP_2 AS _Deductible ON InsurPlcyUUIDForEdit = _Deductible.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Deductible.InsurPlcyApplUUID AND InsurPlcyInsurContr = _Deductible.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Deductible.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Deductible.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Deductible.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Deductible.InsurPlcyInsuredObjectID AND InsurPlcyUndrwrtgDcsnRiskID = _Deductible.InsurPlcyUndrwrtgDcsnRiskID AND InsurPlcySubCvrgID = _Deductible.InsurPlcySubCvrgID  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyDependencyTP AS _PolicyDependency ON InsurPlcyUUIDForEdit = _PolicyDependency.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _PolicyDependency.InsurPlcyApplUUIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyDistrPlnRelshpTP_3 AS _DistributionPlan ON InsurPlcyUUIDForEdit = _DistributionPlan.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _DistributionPlan.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContr = _DistributionPlan.InsurPlcyInsurContrForEdit AND InsurPlcyCoveragePackageID = _DistributionPlan.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageID = _DistributionPlan.InsurPlcyCoverageIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyExtRefTP_2 AS _ExternalReference ON InsurPlcyUUIDForEdit = _ExternalReference.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _ExternalReference.InsurPlcyApplUUID AND InsurPlcyInsurContr = _ExternalReference.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _ExternalReference.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _ExternalReference.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _ExternalReference.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _ExternalReference.InsurPlcyInsuredObjectID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyReltdContractTP_2 AS _RelatedContract ON InsurPlcyUUIDForEdit = _RelatedContract.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _RelatedContract.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContr = _RelatedContract.InsurPlcyInsurContrForEdit AND InsurPlcyCoveragePackageID = _RelatedContract.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageID = _RelatedContract.InsurPlcyCoverageIDForEdit AND InsurPlcyCoverageOptionID = _RelatedContract.InsurPlcyCvrgOptnIDForEdit AND InsurPlcyInsuredObjectID = _RelatedContract.InsurPlcyInsrdObjIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyPolicyHolderTP_3 AS _PolicyHolder ON InsurPlcyUUIDForEdit = _PolicyHolder.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _PolicyHolder.InsurPlcyApplUUID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContrBndlTP_2 AS _ContractBundle ON InsurPlcyUUIDForEdit = _ContractBundle.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _ContractBundle.InsurPlcyApplUUID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContrJrnlHdrTP AS _ContractJournalHeader ON InsurPlcyUUID = _ContractJournalHeader.InsurPlcyUUID  -- association [1..*]
LEFT OUTER JOIN R_InsurPlcyApplJrnlHdrTP AS _ApplicationJournalHeader ON InsurPlcyUUID = _ApplicationJournalHeader.InsurPlcyUUID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyCashFlowHdrTP AS _CashFlowDocumentHeader ON InsurPlcyUUID = _CashFlowDocumentHeader.InsurPlcyUUID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyCBCCashFlowHdrTP AS _CBCCashFlowDocumentHeader ON InsurPlcyUUID = _CBCCashFlowDocumentHeader.InsurPlcyUUID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyCBCOverviewTP AS _CBCOverview ON InsurPlcyUUID = _CBCOverview.InsurPlcyUUID OR InsurPlcyUUID = _CBCOverview.InsurPlcyApplUUID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyAccountingTP_2 AS _TransferSettle ON InsurancePolicy = _TransferSettle.InsurPlcyAcctgExtPlcyNmbr  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyAccountingTP_2 AS _TransferSettleRef ON InsurancePolicy = _TransferSettleRef.InsurPlcyAcctgRefPlcyNmbr  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyDualControlTP AS _DualControl ON InsurPlcyUUID = _DualControl.InsurPlcyUUID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyBnftCasesAndClaimTP AS _BenefitCasesAndClaims ON InsurPlcyUUID = _BenefitCasesAndClaims.InsurPlcyUUID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyCoinsurCashFlowTP AS _CoinsuranceCashFlow ON InsurPlcyUUID = _CoinsuranceCashFlow.InsurPlcyUUID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyRenewalHistoryTP AS _RenewalHistory ON InsurPlcyUUID = _RenewalHistory.InsurPlcyUUID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyCrspncHistTP AS _CorrespncHist ON InsurancePolicy = _CorrespncHist.InsurancePolicy  -- association [0..*]
LEFT OUTER JOIN E_InsurancePolicy AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr  -- association [1..1]
;