I_InsurPlcyProcDependentBasic

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_InsurPlcyProcDependentBasic.
-- 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_InsurPlcyProcDependentBasic AS
SELECT
  cast( ProcessDepdntCndn.policy_id as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
  ProcessDepdntCndn.policyproduct_id AS InsurPlcyInsurContr,
  ProcessDepdntCndn.journalendno_id AS InsurPlcyPremJournalEndNumber,
  cast( ProcessDepdntCndn.journalno_id as /pm0/vdm_journal_number_id preserving type ) AS InsurPlcyPremiumJournalNumber,
  ProcessDepdntCndn.resdepc_id AS InsurPlcyProcDepdntCndnID,
  ProcessDepdntCndn.ppdpac_id AS InsurPlcyProductPackageID,
  ProcessDepdntCndn.cancel_fg AS InsurPlcyProcDpCndIsCancelled,
  ProcessDepdntCndn.pm_id AS InsurPlcyProcDpCndProdMgrID,
  ProcessDepdntCndn.resdepctype_cd AS InsurPlcyProcDpCndCategory,
  ProcessDepdntCndn.lossratio_vl AS InsurPlcyProcDpCndLossPct,
  ProcessDepdntCndn.maxloss_am AS InsurPlcyProcDpCndMaxLossAmt,
  ProcessDepdntCndn.refundofprem_vl AS InsurPlcyProcDpCndRfndPercent,
  ProcessDepdntCndn.settlemode_cd AS InsurPlcyProcDpCndSettlmtMode,
  ProcessDepdntCndn.valuationend_dt AS InsurPlcyProcDpCndSettlmtDte,
  ProcessDepdntCndn.losscarryforw_am AS InsurPlcyProcDpCndCarryFwdAmt,
  ProcessDepdntCndn.losssum_am AS InsurPlcyProcDpCndLossRlvtAmt,
  ProcessDepdntCndn.lossratioam_am AS InsurPlcyProcDpCndLossRatioAmt,
  ProcessDepdntCndn.losssumres_am AS InsurPlcyProcDpCndLossIcrrdAmt,
  ProcessDepdntCndn.loscarforwnew_am AS InsurPlcyProcDpCndLossCurAmt,
  ProcessDepdntCndn.profit_am AS InsurPlcyProcDpCndPrftCurAmt,
  ProcessDepdntCndn.refundpremam_am AS InsurPlcyProcDpCndRfndAmt,
  ProcessDepdntCndn.currency_id AS InsurPlcyProcDpCndCrcy,
  ProcessDepdntCndn.lossdepdisc_vl AS InsurPlcyProcDpCndLossRate,
  ProcessDepdntCndn.bo_cd AS InsurPlcyBusinessObject,
  ProcessDepdntCndn.change_ts AS LastChangeDateTime
FROM /pm0/abdaresdepc AS ProcessDepdntCndn
LEFT OUTER JOIN I_Currency AS _Currency ON InsurPlcyProcDpCndCrcy = _Currency.Currency  -- association [1..1]
;