R_InsurancePolicyBenefitTP

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_InsurancePolicyBenefitTP.
-- 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_InsurancePolicyBenefitTP AS
SELECT
  _Benefit.InsurPlcyUUID AS InsurPlcyUUID,
  _Benefit.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  _Benefit.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  _Benefit.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  _Benefit.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  _Benefit.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  _Benefit.InsurPlcyBenefitID AS InsurPlcyBenefitID,
  cast( 0 as /pm0/abd_subj_id ) AS InsurPlcyInsuredObjectID,
  cast( 0 as /pm0/abd_prem_id) AS InsurancePolicyPremium,
  cast( 0 as /pm0/abd_bnfcalc_id ) AS InsurPlcyBnftDetnID,
  _Benefit.InsurPlcyUUID AS InsurPlcyUUIDForEdit,
  _Benefit.InsurPlcyApplUUID AS InsurPlcyApplUUIDForEdit,
  _Benefit.InsurPlcyInsurContr AS InsurPlcyInsurContrForEdit,
  _Benefit.InsurPlcyCoveragePackageID AS InsurPlcyCvPcgIDForEdit,
  _Benefit.InsurPlcyCoverageID AS InsurPlcyCoverageIDForEdit,
  _Benefit.InsurPlcyCoverageOptionID AS InsurPlcyCvrgOptnIDForEdit,
  _Benefit.InsurPlcyBenefitID AS InsurPlcyBenefitIDForEdit,
  _Benefit.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  _Benefit.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  _Benefit.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  _Benefit.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  _Benefit.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  _Benefit.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  _Benefit.InsurPlcyBnftIsCancld AS InsurPlcyBnftIsCancld,
  _Benefit.InsurPlcyLineOfBusiness AS InsurPlcyLineOfBusiness,
  _Benefit.InsurPlcyBnftNrOfWaitPerdDays AS InsurPlcyBnftNrOfWaitPerdDays,
  _Benefit.InsurPlcyBenefitsEndDate AS InsurPlcyBenefitsEndDate,
  _Benefit.InsurPlcyBenefitsTemplate AS InsurPlcyBenefitsTemplate,
  _Benefit.InsurPlcyBenefitsCurrency AS InsurPlcyBenefitsCurrency,
  _Benefit.InsurPlcyBnftMappgInfInsurMath AS InsurPlcyBnftMappgInfInsurMath,
  _Benefit.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  _Benefit.LastChangeDateTime AS LastChangeDateTime,
  _Benefit._Currency AS _Currency
FROM I_InsurPolicyBenefitVersion AS _Benefit
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_InsurancePolicyBenefit AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyBenefitID = _Extension.InsurPlcyBenefitID  -- association [1..1]
LEFT OUTER JOIN R_InsurancePolicyTP_3 AS _Policy ON InsurPlcyUUID = _Policy.InsurPlcyUUID AND InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID  -- association [1..1]
LEFT OUTER JOIN R_InsurancePolicyLifeBenefitTP AS _LifeBenefit ON InsurPlcyUUIDForEdit = _LifeBenefit.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _LifeBenefit.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _LifeBenefit.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _LifeBenefit.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _LifeBenefit.InsurPlcyCoverageIDForEdit AND InsurPlcyCvrgOptnIDForEdit = _LifeBenefit.InsurPlcyCvrgOptnIDForEdit AND InsurPlcyBenefitIDForEdit = _LifeBenefit.InsurPlcyBenefitIDForEdit  -- association [0..1]
LEFT OUTER JOIN R_InsurPlcyFundAssignmentTP_2 AS _FundAssignment ON InsurPlcyUUIDForEdit = _FundAssignment.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _FundAssignment.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _FundAssignment.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _FundAssignment.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _FundAssignment.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _FundAssignment.InsurPlcyCoverageOptionID AND InsurPlcyBenefitIDForEdit = _FundAssignment.InsurPlcyBenefitID AND InsurPlcyInsuredObjectID = _FundAssignment.InsurPlcyInsuredObjectID AND InsurancePolicyPremium = _FundAssignment.InsurancePolicyPremium AND InsurPlcyBnftDetnID = _FundAssignment.InsurPlcyBnftDetnID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyPrtlDisbmtTP AS _PartialDisbursement ON InsurPlcyUUIDForEdit = _PartialDisbursement.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _PartialDisbursement.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _PartialDisbursement.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _PartialDisbursement.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _PartialDisbursement.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _PartialDisbursement.InsurPlcyCoverageOptionID AND InsurPlcyBenefitIDForEdit = _PartialDisbursement.InsurPlcyBenefitID  -- association [0..*]
;