R_InsurPlcyBeneficiaryTP

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 R_InsurPlcyBeneficiaryTP.
-- 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 R_InsurPlcyBeneficiaryTP AS
SELECT
  Beneficiary.InsurPlcyUUID AS InsurPlcyUUID,
  Beneficiary.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  Beneficiary.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Beneficiary.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Beneficiary.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  Beneficiary.InsurancePolicyBeneficiaryID AS InsurancePolicyBeneficiaryID,
  Beneficiary.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  Beneficiary.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  Beneficiary.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  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.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  Beneficiary.LastChangeDateTime AS LastChangeDateTime,
  Beneficiary.InsurPlcyBeneficiaryIsCanceled AS InsurPlcyBeneficiaryIsCanceled,
  Beneficiary.InsurPlcyBnfcyAddrNmbr AS InsurPlcyBnfcyAddrNmbr,
  Beneficiary.InsurPlcyBnfcyCmntTxt AS InsurPlcyBnfcyCmntTxt,
  Beneficiary.InsurPlcyBnfcyDefinedAtDate AS InsurPlcyBnfcyDefinedAtDate,
  Beneficiary.InsurPlcyBnfcyValidUntilDate AS InsurPlcyBnfcyValidUntilDate,
  Beneficiary.InsurPlcyIsBnfcySubjToApprvl AS InsurPlcyIsBnfcySubjToApprvl,
  Beneficiary._Currency AS _Currency
FROM I_InsurPlcyBeneficiaryVersion AS Beneficiary
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_InsurancePolicyBeneficiary AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurancePolicyBeneficiaryID = _Extension.InsurancePolicyBeneficiaryID  -- association [1..1]
LEFT OUTER JOIN R_InsurancePolicyTP_3 AS _Policy ON InsurPlcyUUID = _Policy.InsurPlcyUUID AND InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID  -- association [1..1]
;