I_InsurPlcyBeneficiaryBasic_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_InsurPlcyBeneficiaryBasic_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_InsurPlcyBeneficiaryBasic_2 AS
SELECT
  cast( Beneficiary.policy_id as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
  Beneficiary.policyproduct_id AS InsurPlcyInsurContr,
  Beneficiary.journalendno_id AS InsurPlcyJrnlEndNmbr,
  cast( Beneficiary.journalno_id as /pm0/vdm_journal_number_id preserving type ) AS InsurPlcyJrnlNmbr,
  Beneficiary.covpac_id AS InsurPlcyCoveragePackageID,
  Beneficiary.coverage_id AS InsurPlcyCoverageID,
  Beneficiary.bnfcry_id AS InsurancePolicyBeneficiaryID,
  Beneficiary.ppdpac_id AS InsurPlcyProductPackageID,
  Beneficiary.partner_id AS InsurancePolicyBeneficiary,
  Beneficiary.share_am AS InsurPlcyBeneficiaryShrAmount,
  Beneficiary.share_vl AS InsurPlcyBnfcyShareInPercent,
  Beneficiary.bnftp_cd AS InsurancePolicyBeneficiaryType,
  cast ( Beneficiary.covcptype_cd as /pm0/vdm_covcptype_cd preserving type ) AS InsurPlcyBnfcyCoverageType,
  Beneficiary.rankvl_cd AS InsurancePolicyBeneficiaryRank,
  Beneficiary.refusal_cd AS InsurPlcyBnfcyRevocability,
  Beneficiary.currency_id AS InsurPlcyBeneficiaryCurrency,
  Beneficiary.pm_id AS InsurPlcyBeneficiaryControl,
  Beneficiary.bo_cd AS InsurPlcyBusinessObject,
  Beneficiary.change_ts AS LastChangeDateTime,
  Beneficiary.cancel_fg AS InsurPlcyBeneficiaryIsCanceled,
  cast( Beneficiary.addressnumber_id as /pm0/vdm_address_id preserving type ) AS InsurPlcyBnfcyAddrNmbr,
  Beneficiary.comment_tt AS InsurPlcyBnfcyCmntTxt,
  Beneficiary.definedat_dt AS InsurPlcyBnfcyDefinedAtDate,
  Beneficiary.subscdeadl_dt AS InsurPlcyBnfcyValidUntilDate,
  Beneficiary.agrbnfcry_fg AS InsurPlcyIsBnfcySubjToApprvl
FROM /pm0/abdabnfcry AS Beneficiary
LEFT OUTER JOIN I_Currency AS _Currency ON InsurPlcyBeneficiaryCurrency = _Currency.Currency  -- association [1..1]
;