R_InsurPolicyInsuredObjectTP_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 R_InsurPolicyInsuredObjectTP_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 R_InsurPolicyInsuredObjectTP_2 AS
SELECT
  InsuredObject.InsurPlcyUUID AS InsurPlcyUUID,
  InsuredObject.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  InsuredObject.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  InsuredObject.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  InsuredObject.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  InsuredObject.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  InsuredObject.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  InsuredObject.InsurPlcyUUID AS InsurPlcyUUIDForEdit,
  InsuredObject.InsurPlcyApplUUID AS InsurPlcyApplUUIDForEdit,
  InsuredObject.InsurPlcyInsurContr AS InsurPlcyInsurContrForEdit,
  InsuredObject.InsurPlcyCoveragePackageID AS InsurPlcyCvPcgIDForEdit,
  InsuredObject.InsurPlcyCoverageID AS InsurPlcyCoverageIDForEdit,
  InsuredObject.InsurPlcyCoverageOptionID AS InsurPlcyCvrgOptnIDForEdit,
  InsuredObject.InsurPlcyInsuredObjectID AS InsurPlcyInsrdObjIDForEdit,
  cast(0 as /pm0/abd_uwdcn_id ) AS InsurPlcyUndrwrtgDcsnRiskID,
  cast(0 as /pm0/abd_covcpco_id ) AS InsurPlcySubCvrgID,
  InsuredObject.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  InsuredObject.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  InsuredObject.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  InsuredObject.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  InsuredObject.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  InsuredObject.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  InsuredObject.InsurPlcyInsrdObjectTemplate AS InsurPlcyInsrdObjectTemplate,
  InsuredObject.InsurPlcyInsuredObjectCategory AS InsurPlcyInsuredObjectCategory,
  InsuredObject.InsurPlcyInsrdObjSubCategory AS InsurPlcyInsrdObjSubCategory,
  InsuredObject.InsurPlcyInsrdObjUnqID AS InsurPlcyInsrdObjUnqID,
  InsuredObject.InsurInsrblObjJrnlNmbr AS InsurInsrblObjJrnlNmbr,
  InsuredObject.InsurPlcyInsrdObjIsCancelled AS InsurPlcyInsrdObjIsCancelled,
  InsuredObject.InsurPlcyInsuredPersonID AS InsurPlcyInsuredPersonID,
  InsuredObject.InsurPlcyInsrdObjEffctvDte AS InsurPlcyInsrdObjEffctvDte,
  InsuredObject.InsurPlcyInsrdObjAwardReason AS InsurPlcyInsrdObjAwardReason,
  InsuredObject.InsurPlcyInsrdObjIsUpdateNeed AS InsurPlcyInsrdObjIsUpdateNeed,
  InsuredObject.InsurPlcyInsrdObjTypeChannel AS InsurPlcyInsrdObjTypeChannel,
  InsuredObject.InsurPlcyInsrdObjCatChannel AS InsurPlcyInsrdObjCatChannel,
  InsuredObject.InsurPlcyInsrdObjSuperChannel AS InsurPlcyInsrdObjSuperChannel,
  InsuredObject.InsurPlcyInsrdObjCurrency AS InsurPlcyInsrdObjCurrency,
  InsuredObject.InsurPlcyInsrdObjDeclaration AS InsurPlcyInsrdObjDeclaration,
  InsuredObject.InsurPlcyInsrdObjPositionSqnc AS InsurPlcyInsrdObjPositionSqnc,
  InsuredObject.InsurPlcyInsrdObjIsNoPremRaise AS InsurPlcyInsrdObjIsNoPremRaise,
  InsuredObject.InsurPlcyInsrdObjIsLocChanged AS InsurPlcyInsrdObjIsLocChanged,
  InsuredObject.InsurPlcyInsrdObjRiskGrpNumber AS InsurPlcyInsrdObjRiskGrpNumber,
  InsuredObject.InsurPlcyInsrdObjOccptnRdyDte AS InsurPlcyInsrdObjOccptnRdyDte,
  InsuredObject.InsurPlcyInsrdObjIsInCnstrctn AS InsurPlcyInsrdObjIsInCnstrctn,
  InsuredObject.InsurPlcyInsrdObjStormZone AS InsurPlcyInsrdObjStormZone,
  InsuredObject.InsurPlcyInsrdObjHazardClass AS InsurPlcyInsrdObjHazardClass,
  InsuredObject.InsurPlcyInsrdObjCnstrctnType AS InsurPlcyInsrdObjCnstrctnType,
  InsuredObject.InsurPlcyInsrdObjUsblAreaQty AS InsurPlcyInsrdObjUsblAreaQty,
  InsuredObject.InsurPlcyInsrdObjCommlUsgePct AS InsurPlcyInsrdObjCommlUsgePct,
  InsuredObject.InsurPlcyInsrdObjTariffZone AS InsurPlcyInsrdObjTariffZone,
  InsuredObject.InsurPlcyInsrdPersonBirthDate AS InsurPlcyInsrdPersonBirthDate,
  InsuredObject.InsurPlcyInsrdPersonName AS InsurPlcyInsrdPersonName,
  InsuredObject.InsurPlcyInsrdPersonStatus AS InsurPlcyInsrdPersonStatus,
  InsuredObject.InsurPlcyInsrdPersonAddr AS InsurPlcyInsrdPersonAddr,
  InsuredObject.InsurPlcyInsrdPersonIsOwner AS InsurPlcyInsrdPersonIsOwner,
  InsuredObject.InsurPlcyInsrdPersonJob AS InsurPlcyInsrdPersonJob,
  InsuredObject.InsurPlcyInsrdPersonIsSmoker AS InsurPlcyInsrdPersonIsSmoker,
  InsuredObject.InsurPlcyInsrdPersonRskGrp AS InsurPlcyInsrdPersonRskGrp,
  InsuredObject.InsurPlcyInsrdPersonGender AS InsurPlcyInsrdPersonGender,
  InsuredObject.InsurPlcyInsrdPersnBeginValue AS InsurPlcyInsrdPersnBeginValue,
  InsuredObject.InsurPlcyInsrdPersnFinalValue AS InsurPlcyInsrdPersnFinalValue,
  InsuredObject.InsurPlcyInsrdPersnAgeGrp AS InsurPlcyInsrdPersnAgeGrp,
  InsuredObject.InsurPlcyInsrdPersnRole AS InsurPlcyInsrdPersnRole,
  InsuredObject.InsurPlcyInsrdPersnJobClass AS InsurPlcyInsrdPersnJobClass,
  InsuredObject.InsurPlcyInsrdPersnProfession AS InsurPlcyInsrdPersnProfession,
  InsuredObject.InsurPlcyInsrdObjNmbrOfAnimal AS InsurPlcyInsrdObjNmbrOfAnimal,
  InsuredObject.InsurPlcyInsrdObjValueAmount AS InsurPlcyInsrdObjValueAmount,
  InsuredObject.InsurPlcyInsrdObjLonValue AS InsurPlcyInsrdObjLonValue,
  InsuredObject.InsurPlcyInsrdObjLonMinsValue AS InsurPlcyInsrdObjLonMinsValue,
  InsuredObject.InsurPlcyInsrdObjLonSecsValue AS InsurPlcyInsrdObjLonSecsValue,
  InsuredObject.InsurPlcyInsrdObjLatitudeValue AS InsurPlcyInsrdObjLatitudeValue,
  InsuredObject.InsurPlcyInsrdObjLatMinsValue AS InsurPlcyInsrdObjLatMinsValue,
  InsuredObject.InsurPlcyInsrdObjLatSecsValue AS InsurPlcyInsrdObjLatSecsValue,
  InsuredObject.InsurPlcyPostCodeTxt AS InsurPlcyPostCodeTxt,
  InsuredObject.InsurPlcyInsrdObjStreetName AS InsurPlcyInsrdObjStreetName,
  InsuredObject.InsurPlcyInsrdObjCountry AS InsurPlcyInsrdObjCountry,
  InsuredObject.InsurPlcyInsrdObjValueType AS InsurPlcyInsrdObjValueType,
  InsuredObject.InsurPlcyInsrdObjDtmnYearValue AS InsurPlcyInsrdObjDtmnYearValue,
  InsuredObject.InsurPlcyInsrdObjCityName AS InsurPlcyInsrdObjCityName,
  InsuredObject.InsurPlcyInsrdObjHouseNumber AS InsurPlcyInsrdObjHouseNumber,
  InsuredObject.InsurPlcyInsrdObjUsblAreaUnit AS InsurPlcyInsrdObjUsblAreaUnit,
  InsuredObject.InsurPlcyInsrdObj2LonValue AS InsurPlcyInsrdObj2LonValue,
  InsuredObject.InsurPlcyInsrdObj2LonMinsValue AS InsurPlcyInsrdObj2LonMinsValue,
  InsuredObject.InsurPlcyInsrdObj2LonSecsValue AS InsurPlcyInsrdObj2LonSecsValue,
  InsuredObject.InsurPlcyInsrdObj2LatValue AS InsurPlcyInsrdObj2LatValue,
  InsuredObject.InsurPlcyInsrdObj2LatMinsValue AS InsurPlcyInsrdObj2LatMinsValue,
  InsuredObject.InsurPlcyInsrdObj2LatSecsValue AS InsurPlcyInsrdObj2LatSecsValue,
  InsuredObject.InsurPlcyInsrdObj2StreetName AS InsurPlcyInsrdObj2StreetName,
  InsuredObject.InsurPlcyInsrdObjPostCodeTxt AS InsurPlcyInsrdObjPostCodeTxt,
  InsuredObject.InsurPlcyInsrdObj2Country AS InsurPlcyInsrdObj2Country,
  InsuredObject.InsurPlcyInsrdObj2CnstrctnType AS InsurPlcyInsrdObj2CnstrctnType,
  InsuredObject.InsurPlcyInsrdObj2CityName AS InsurPlcyInsrdObj2CityName,
  InsuredObject.InsurPlcyInsrdObj2HouseNumber AS InsurPlcyInsrdObj2HouseNumber,
  InsuredObject.InsurPlcyInsrdObjIsTmpCvrg AS InsurPlcyInsrdObjIsTmpCvrg,
  InsuredObject.InsurPlcyInsrdObjGlazingQty AS InsurPlcyInsrdObjGlazingQty,
  InsuredObject.InsurPlcyInsrdObjInteriorQty AS InsurPlcyInsrdObjInteriorQty,
  InsuredObject.InsurPlcyInsrdObjIsBuildUpArea AS InsurPlcyInsrdObjIsBuildUpArea,
  InsuredObject.InsurPlcyInsrdObjOuterWallType AS InsurPlcyInsrdObjOuterWallType,
  InsuredObject.InsurPlcyInsrdObjIsPrefabHouse AS InsurPlcyInsrdObjIsPrefabHouse,
  InsuredObject.InsurPlcyInsrdObjLivingAreaQty AS InsurPlcyInsrdObjLivingAreaQty,
  InsuredObject.InsurPlcyInsrdObjLivingAreaUnt AS InsurPlcyInsrdObjLivingAreaUnt,
  InsuredObject.InsurPlcyInsrdObjRoofing AS InsurPlcyInsrdObjRoofing,
  InsuredObject.InsurPlcyInsrdObjGlazingUnit AS InsurPlcyInsrdObjGlazingUnit,
  InsuredObject.InsurPlcyInsrdObjPrtnPrpty AS InsurPlcyInsrdObjPrtnPrpty,
  InsuredObject.InsurPlcyInsrdObjPartner AS InsurPlcyInsrdObjPartner,
  InsuredObject.InsurPlcyInsrdObjInteriorGlaze AS InsurPlcyInsrdObjInteriorGlaze,
  InsuredObject.InsurPlcyInsrdObj2HazardClass AS InsurPlcyInsrdObj2HazardClass,
  InsuredObject.InsurPlcyInsrdObj2TariffZone AS InsurPlcyInsrdObj2TariffZone,
  InsuredObject.InsurPlcyInsrdObjHasAlarm AS InsurPlcyInsrdObjHasAlarm,
  InsuredObject.InsurPlcyInsrdObjBldngType AS InsurPlcyInsrdObjBldngType,
  InsuredObject.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  InsuredObject.LastChangeDateTime AS LastChangeDateTime,
  InsuredObject. _Currency AS _Currency
FROM I_InsurPlcyInsrdObjEntyVersion AS InsuredObject
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_InsurancePolicyInsuredObject AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID  -- 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_InsurPlcyClauseTP_3 AS _Clause ON InsurPlcyUUIDForEdit = _Clause.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Clause.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _Clause.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _Clause.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _Clause.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _Clause.InsurPlcyCoverageOptionID AND InsurPlcyInsrdObjIDForEdit = _Clause.InsurPlcyInsuredObjectID AND InsurPlcyUndrwrtgDcsnRiskID = _Clause.InsurPlcyUndrwrtgDcsnRiskID AND InsurPlcySubCvrgID = _Clause.InsurPlcySubCvrgID  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyCreditorTP AS _Creditor ON InsurPlcyUUIDForEdit = _Creditor.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Creditor.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _Creditor.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _Creditor.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _Creditor.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _Creditor.InsurPlcyCoverageOptionID AND InsurPlcyInsrdObjIDForEdit = _Creditor.InsurPlcyInsuredObjectID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyDeductibleTP_2 AS _Deductible ON InsurPlcyUUIDForEdit = _Deductible.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Deductible.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _Deductible.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _Deductible.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _Deductible.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _Deductible.InsurPlcyCoverageOptionID AND InsurPlcyInsrdObjIDForEdit = _Deductible.InsurPlcyInsuredObjectID AND InsurPlcyUndrwrtgDcsnRiskID = _Deductible.InsurPlcyUndrwrtgDcsnRiskID AND InsurPlcySubCvrgID = _Deductible.InsurPlcySubCvrgID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyDiagnosisCodeTP_2 AS _DiagnosisCode ON InsurPlcyUUIDForEdit = _DiagnosisCode.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _DiagnosisCode.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _DiagnosisCode.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _DiagnosisCode.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _DiagnosisCode.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _DiagnosisCode.InsurPlcyCoverageOptionID AND InsurPlcyInsrdObjIDForEdit = _DiagnosisCode.InsurPlcyInsuredObjectID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyExtRefTP_2 AS _ExternalReference ON InsurPlcyUUIDForEdit = _ExternalReference.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _ExternalReference.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _ExternalReference.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _ExternalReference.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _ExternalReference.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _ExternalReference.InsurPlcyCoverageOptionID AND InsurPlcyInsrdObjIDForEdit = _ExternalReference.InsurPlcyInsuredObjectID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyInsObAddressTP AS _InsObAddress ON InsurPlcyUUIDForEdit = _InsObAddress.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _InsObAddress.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _InsObAddress.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _InsObAddress.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _InsObAddress.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _InsObAddress.InsurPlcyCoverageOptionID AND InsurPlcyInsrdObjIDForEdit = _InsObAddress.InsurPlcyInsuredObjectID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyReltdContractTP_2 AS _RelatedContract ON InsurPlcyUUIDForEdit = _RelatedContract.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _RelatedContract.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _RelatedContract.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _RelatedContract.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _RelatedContract.InsurPlcyCoverageIDForEdit AND InsurPlcyCvrgOptnIDForEdit = _RelatedContract.InsurPlcyCvrgOptnIDForEdit AND InsurPlcyInsrdObjIDForEdit = _RelatedContract.InsurPlcyInsrdObjIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcySurchrgDiscTP_2 AS _SurchargeDiscount ON InsurPlcyUUIDForEdit = _SurchargeDiscount.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _SurchargeDiscount.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _SurchargeDiscount.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _SurchargeDiscount.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _SurchargeDiscount.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _SurchargeDiscount.InsurPlcyCoverageOptionID AND InsurPlcyInsrdObjIDForEdit = _SurchargeDiscount.InsurPlcyInsuredObjectID AND InsurPlcyUndrwrtgDcsnRiskID = _SurchargeDiscount.InsurPlcyUndrwrtgDcsnRiskID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyUndrwrtgDcsnTP AS _UnderwritingDecision ON InsurPlcyUUIDForEdit = _UnderwritingDecision.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _UnderwritingDecision.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _UnderwritingDecision.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _UnderwritingDecision.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _UnderwritingDecision.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _UnderwritingDecision.InsurPlcyCoverageOptionID AND InsurPlcyInsrdObjIDForEdit = _UnderwritingDecision.InsurPlcyInsuredObjectID  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyAdjustmentTP AS _Adjustment ON InsurPlcyUUIDForEdit = _Adjustment.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Adjustment.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _Adjustment.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _Adjustment.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _Adjustment.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _Adjustment.InsurPlcyCoverageOptionID AND InsurPlcyInsrdObjIDForEdit = _Adjustment.InsurPlcyInsuredObjectID  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyPremiumTP AS _Premium ON InsurPlcyUUIDForEdit = _Premium.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _Premium.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _Premium.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _Premium.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _Premium.InsurPlcyCoverageIDForEdit AND InsurPlcyCvrgOptnIDForEdit = _Premium.InsurPlcyCvrgOptnIDForEdit AND InsurPlcyInsrdObjIDForEdit = _Premium.InsurPlcyInsrdObjIDForEdit  -- association [0..*]
;