I_InsurPlcyAnswRskAssmtBasic_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_InsurPlcyAnswRskAssmtBasic_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_InsurPlcyAnswRskAssmtBasic_2 AS
SELECT
  cast( AnswRskAssmt.policy_id as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
  AnswRskAssmt.policyproduct_id AS InsurPlcyInsurContr,
  AnswRskAssmt.journalendno_id AS InsurPlcyJrnlEndNmbr,
  cast( AnswRskAssmt.journalno_id as /pm0/vdm_journal_number_id preserving type ) AS InsurPlcyJrnlNmbr,
  AnswRskAssmt.covpac_id AS InsurPlcyCoveragePackageID,
  AnswRskAssmt.coverage_id AS InsurPlcyCoverageID,
  AnswRskAssmt.quest_id AS InsurPlcyRskAssmtQstnID,
  AnswRskAssmt.answer_id AS InsurPlcyRskAssmtAnswID,
  AnswRskAssmt.ppdpac_id AS InsurPlcyProductPackageID,
  AnswRskAssmt.cancel_fg AS InsurPlcyAnswRskAssmtIsCancld,
  AnswRskAssmt.quest_cd AS InsurPlcyRskAssmtQstnApplQstn,
  AnswRskAssmt.noanswer_fg AS InsurPlcyRskAssmtIsNotAnswered,
  AnswRskAssmt.complete_fg AS InsurPlcyAnswIsCmpltlyAnswered,
  AnswRskAssmt.addictivedrug_id AS InsurPlcyAnswRskAddictiveDrug,
  AnswRskAssmt.frequency_cd AS InsurPlcyAnswRskAssmtFrequency,
  AnswRskAssmt.height_vl AS InsurPlcyAnswRskAssmtPersnHght,
  AnswRskAssmt.weight_vl AS InsurPlcyAnswRskAssmtPersnWgt,
  AnswRskAssmt.begin_dt AS InsurPlcyAnswRskAssmtStartDate,
  AnswRskAssmt.end_dt AS InsurPlcyAnswRskAssmtEndDate,
  AnswRskAssmt.hobby_id AS InsurPlcyAnswRskAssmtHobby,
  AnswRskAssmt.disease_id AS InsurPlcyAnswRskAssmtPrevIlln,
  AnswRskAssmt.country_cd AS InsurPlcyAnswRskAssmtCountry,
  AnswRskAssmt.partner_id AS InsurPlcyAnswRskAssmtBP,
  cast ( AnswRskAssmt.addressnumber_id as /pm0/vdm_address_id preserving type ) AS InsurPlcyAnswRskAssmtAddr,
  AnswRskAssmt.date_cd AS InsurPlcyAnswRskAssmtDte,
  AnswRskAssmt.drug_cd AS InsurPlcyAnswRskAssmtDrug,
  AnswRskAssmt.shortinfo_tt AS InsurPlcyAnswRskAssmtCmntTxt,
  AnswRskAssmt.amount_am AS InsurPlcyAnswRskAssmtAmt,
  AnswRskAssmt.duryear_vl AS InsurPlcyAnswRskAssmtDurnYrs,
  AnswRskAssmt.durmonth_vl AS InsurPlcyAnswRskAssmtDurnMnths,
  AnswRskAssmt.durday_vl AS InsurPlcyAnswRskAssmtDurnDays,
  cast( AnswRskAssmt.comment_id as /pm0/vdm_note_longtext_uuid preserving type ) AS InsurPlcyAnswRskAssmtCmntID,
  AnswRskAssmt.yesno_cd AS InsurPlcyAnswRskAssmtAnswYesNo,
  AnswRskAssmt.currency_id AS InsurPlcyAnswRskAssmtCrcy,
  AnswRskAssmt.bmi_vl AS InsurPlcyAnswRskBodyMassIdxVal,
  AnswRskAssmt.bmicorr_vl AS InsurPlcyBodyMassIdxCrrtnVal,
  AnswRskAssmt.weight_ut AS InsurPlcyAnswRskAssmtWgtUnit,
  AnswRskAssmt.height_ut AS InsurPlcyAnswRskAssmtHghtUnit,
  AnswRskAssmt.bo_cd AS InsurPlcyBusinessObject,
  AnswRskAssmt.change_ts AS LastChangeDateTime
FROM /pm0/abdaanswer AS AnswRskAssmt
LEFT OUTER JOIN I_Currency AS _Currency ON InsurPlcyAnswRskAssmtCrcy = _Currency.Currency  -- association [1..1]
;