I_InsurPlcyContractBeneficiary

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_InsurPlcyContractBeneficiary.
-- 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_InsurPlcyContractBeneficiary AS
SELECT
  Beneficiary.InsurPlcyUUID AS InsurPlcyUUID,
  Beneficiary.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Beneficiary.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Beneficiary.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  Beneficiary.InsurancePolicyBeneficiaryID AS InsurancePolicyBeneficiaryID,
  Beneficiary.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Beneficiary.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Beneficiary.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  Beneficiary.InsurancePolicyBeneficiary AS InsurancePolicyBeneficiary,
  Beneficiary.InsurPlcyBeneficiaryShrAmount AS InsurPlcyBeneficiaryShrAmount,
  Beneficiary.InsurPlcyBnfcyShareInPercent AS InsurPlcyBnfcyShareInPercent,
  Beneficiary.InsurancePolicyBeneficiaryType AS InsurancePolicyBeneficiaryType,
  Beneficiary.InsurPlcyBnfcyCoverageType AS InsurPlcyBnfcyCoverageType,
  Beneficiary.InsurancePolicyBeneficiaryRank AS InsurancePolicyBeneficiaryRank,
  Beneficiary.InsurPlcyBnfcyRevocability AS InsurPlcyBnfcyRevocability,
  Beneficiary.InsurPlcyBeneficiaryCurrency AS InsurPlcyBeneficiaryCurrency,
  Beneficiary.InsurPlcyBeneficiaryControl AS InsurPlcyBeneficiaryControl,
  Beneficiary.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPolicyBeneficiaryBasic AS Beneficiary
LEFT OUTER JOIN I_Currency AS _Currency ON InsurPlcyBeneficiaryCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcyTemplateT ON InsurPlcyBeneficiaryControl = _InsurPlcyTemplateT.InsurPlcyTemplate  -- association [1..*]
LEFT OUTER JOIN I_InsurPlcyBnfcyRevocability AS _InsurPlcyBnfcyRevocability ON InsurPlcyBnfcyRevocability = _InsurPlcyBnfcyRevocability.InsurPlcyBnfcyRevocability  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON InsurancePolicyBeneficiary = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_InsurPlcyBnfcyCvrgTypeLink AS _InsurPlcyBnfcyCoverageType ON InsurPlcyBnfcyCoverageType = _InsurPlcyBnfcyCoverageType.InsurPlcyBnfcyCoverageType AND InsurPlcyBeneficiaryControl = _InsurPlcyBnfcyCoverageType.InsurPlcyProductTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyBeneficiaryType AS _InsurPlcyBeneficiaryType ON InsurancePolicyBeneficiaryType = _InsurPlcyBeneficiaryType.InsurancePolicyBeneficiaryType  -- association [1..1]
;