I_InsurPlcyContractBasic_2

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 I_InsurPlcyContractBasic_2.
-- 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 I_InsurPlcyContractBasic_2 AS
SELECT
  cast( Contract.policy_id as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
  Contract.policyproduct_id AS InsurPlcyInsurContr,
  cast( Contract.journalno_id as /pm0/vdm_journal_number_id preserving type ) AS InsurPlcyJrnlNmbr,
  Contract.journalendno_id AS InsurPlcyJrnlEndNmbr,
  Contract.ppdpac_id AS InsurPlcyProductPackageID,
  Contract.cancel_fg AS InsurPlcyContractIsCanceled,
  Contract.applnr_tt AS InsurancePolicyContract,
  Contract.applnrold_tt AS InsurPlcyContrOldContractID,
  Contract.numofcov_am AS InsurPlcyContrNmbrOfCoverage,
  Contract.lob_cd AS InsurPlcyLineOfBusiness,
  Contract.polprodbeg_dt AS InsurPlcyContractStartDate,
  Contract.starttime_tm AS InsurancePolicyStartTime,
  Contract.starttimezone_tt AS InsurancePolicyStartTimeZone,
  Contract.polprodend_dt AS InsurancePolicyContractEndDate,
  Contract.endtime_tm AS InsurancePolicyEndTime,
  Contract.endtimezone_tt AS InsurancePolicyEndTimeZone,
  cast( Contract.comment_id as /pm0/vdm_note_longtext_uuid preserving type ) AS InsurPlcyContrCommentID,
  Contract.companykey_cd AS InsurPlcyContractCompanyID,
  Contract.bostat_cd AS InsurPlcyContractPolicyStatus,
  Contract.polprc_cd AS InsurPlcyContractCategory,
  Contract.actinactst_cd AS InsurPlcyContrLifeCycleStatus,
  Contract.cancreas_cd AS InsurPlcyContrCanclnRsn,
  Contract.ccldate_dt AS InsurPlcyContrCanclnDte,
  Contract.reversal_tm AS InsurPlcyContractReversalTime,
  Contract.revtimezone_tt AS InsurPlcyContrReversalTimeZone,
  Contract.accvar_cd AS InsurPlcyContractAcctVariant,
  Contract.lstatus_cd AS InsurancePolicyContractStatus,
  Contract.susptp_cd AS InsurPlcyContrSuspensionType,
  Contract.suspbeg_dt AS InsurPlcySuspensionBeginDate,
  Contract.suspbeg_tm AS InsurPlcySuspensionBeginTime,
  Contract.suspbegtimez_tt AS InsurPlcySuspnBeginTmeZn,
  Contract.suspend_dt AS InsurPlcySuspensionEndDate,
  Contract.suspend_tm AS InsurPlcySuspensionEndTime,
  Contract.suspendtimez_tt AS InsurPlcySuspensionEndTimeZone,
  Contract.techstart_dt AS InsurPlcyContrMatlStartDate,
  Contract.extvaria_cd AS InsurPlcyContrExtensionVariant,
  Contract.cpspos_fg AS InsPlcyContrIsCoPensnSchmPmtd,
  Contract.dynamic_fg AS InsurPlcyContrIsAdjustment,
  Contract.targrpb_cd AS InsurPlcyContrTariffVariant,
  Contract.mantar_fg AS InsurPlcyContrIsManualRating,
  Contract.generation_dt AS InsurPlcyContrGenerationDate,
  Contract.prt_cd AS InsurPlcyContrProRtTmpVariant,
  Contract.pm_id AS InsurPlcyProductTemplate,
  Contract.ageatexpirat_vl AS InsurPlcyContrExprtnAgeValue,
  Contract.acceptreject_dt AS InsurPlcyContractRejectionDate,
  Contract.refusalreason_cd AS InsurPlcyContrRejectionReason,
  Contract.origstate_ts AS InsPlcyContrSrceDocStsDateTime,
  Contract.insobject_id AS InsurPlcyContrInsurObjectID,
  Contract.commispend_fg AS InsPlcyContrHasPndgCommsnCase,
  Contract.commisposttx_cd AS InsurPlcyContrCommsnPostgCode,
  Contract.wholelife_fg AS InsurPlcyContractIsLifetime,
  Contract.provapplnr_tt AS InsurPlcyPrvsnlContractNumber,
  Contract.country_cd AS InsurPlcyCountry,
  Contract.taxpayerinfo_cd AS InsurPlcyContrTxblPersnInfo,
  Contract.generation_fg AS InsurPlcyContractIsGeneration,
  Contract.region_cd AS InsurPlcyContractRegion,
  Contract.taxexempt_cd AS InsurPlcyContrScpOfPremTxn,
  Contract.polprloaded_fg AS InsurPlcyContrIsAlreadyIncld,
  cast( Contract.diffmaturity_dt as /pm0/vdm_diffmaturity_dt preserving type ) AS InsPlcyContrDiffntMttyDayMnth,
  Contract.awfinitclerk_id AS InsurPlcyContrFirstProcessorID,
  Contract.awfdecclerk_id AS InsurPlcyContrSecondProcsrID,
  Contract.awfrefreason_tt AS InsurPlcyContrRefusalRsnText,
  Contract.awfpending_fg AS InsurPlcyContrIsCheckPending,
  Contract.automatic_pc_fg AS InsurPlcyContrIsAutomProdChg,
  Contract.transfertype_cd AS InsurPlcyContrTransferType,
  Contract.adjusttype_pc_cd AS InsurPlcyContrConversionType,
  Contract.date_pc_dt AS InsurPlcyContrAutomProdChgDate,
  Contract.generatio_det_dt AS InsurPlcyContrGnrtnDetnDate,
  Contract.dupl_fg AS InsurPlcyContractIsDuplicate,
  Contract.shiftmode_cd AS InsurPlcyContractShiftType,
  Contract.finrenewdec_cd AS InsurPlcyContrFnlRnwlDcsn,
  Contract.renewreason_id AS InsurPlcyContrRnwlRefusalRsn,
  Contract.reneweffect_dt AS InsurPlcyContrRenewalDate,
  Contract.renewal_dec_cd AS InsurPlcyContrRnwlDecision,
  Contract.last_renewdec_dt AS InsurPlcyContrRnwlPrepLastDate,
  Contract.bcurrency_id AS InsurPlcyContractCurrency,
  Contract.bpml_am AS InsurPlcyContrAbsltMnlPMLAmt,
  Contract.bpml_vl AS InsurPlcyContrRltvMnlPMLRate,
  Contract.bricheck_fg AS InsurPlcyContrIsMnlPostprocg,
  Contract.bpml_tt AS InsurPlcyContrMnlFldLblAmtText,
  Contract.enhanced_life_cd AS InsurPlcyContrEnhancedLife,
  Contract.loanlimitrate_vl AS InsurPlcyContrLoanLimitRate,
  Contract.aploanoption_cd AS InsPlcyContrAutomPremLoanOptn,
  Contract.maximumloan_am AS InsurPlcyContrMaxLoanAmount,
  Contract.loccurr_cd AS InsurPlcyContractLocalCurrency,
  Contract.riskcurr_cd AS InsurPlcyContractRiskCurrency,
  Contract.invcurr_cd AS InsurPlcyContrInvoiceCurrency,
  cast( Contract.riskexchrate_vl as /pm0/vdm_riskexchrate_vl preserving type ) AS InsurPlcyContrRiskExchRate,
  Contract.riskexchrate_dt AS InsurPlcyContrRiskExchRateDte,
  cast( Contract.invoexchrate_vl as /pm0/vdm_invoexchrate_vl preserving type ) AS InsurPlcyContrInvcCrcyExchRate,
  Contract.invoexchrate_dt AS InsurPlcyContrInvcExchRateDte,
  Contract.xratedettype_cd AS InsurPlcyContrExchRateDetn,
  cast( Contract.riskapplexchrate_vl as /pm0/vdm_applexchrate_vl preserving type ) AS InsurPlcyContrRskApplExchRate,
  Contract.riskapplexchrate_dt AS InsPlcyContrRskApplExchRateDte,
  cast( Contract.invoapplexchrate_vl as /pm0/vdm_applexchrate_vl preserving type ) AS InsurPlcyContrInvcApplExchRate,
  Contract.invoapplexchrate_dt AS InsurPlcyInvcApplExchRateDate,
  Contract.quotevariant_cd AS InsurPlcyContrQuotationVariant,
  Contract.bo_cd AS InsurPlcyBusinessObject,
  Contract.change_ts AS LastChangeDateTime
FROM /pm0/abdapolpr AS Contract
LEFT OUTER JOIN I_Currency AS _Currency ON InsurPlcyContractCurrency = _Currency.Currency  -- association [1..1]
;