R_InsurClmSrvcsInsurClaimTP

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_InsurClmSrvcsInsurClaimTP.
-- 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_InsurClmSrvcsInsurClaimTP AS
SELECT
  I_InsurClmSrvcsClaim.InsuranceClaim AS InsuranceClaim,
  I_InsurClmSrvcsClaim.InsuranceContract AS InsuranceContract,
  I_InsurClmSrvcsClaim.InsurClmPolicyProduct AS InsurClmPolicyProduct,
  I_InsurClmSrvcsClaim.ChangedOnDateTime AS ChangedOnDateTime,
  I_InsurClmSrvcsClaim.LastChangedByUser AS LastChangedByUser,
  I_InsurClmSrvcsClaim.CreationDateTime AS CreationDateTime,
  I_InsurClmSrvcsClaim.CreatedByUser AS CreatedByUser,
  I_InsurClmSrvcsClaim.InsurClmWholeClmChgdBy AS InsurClmWholeClmChgdBy,
  I_InsurClmSrvcsClaim.InsurClmWholeClmChgDteTme AS InsurClmWholeClmChgDteTme,
  I_InsurClmSrvcsClaim.InsurClmExternalNumberCategory AS InsurClmExternalNumberCategory,
  I_InsurClmSrvcsClaim.InsurClmLifeCycSts AS InsurClmLifeCycSts,
  I_InsurClmSrvcsClaim.InsurClmStsChgdOnDteTime AS InsurClmStsChgdOnDteTime,
  I_InsurClmSrvcsClaim.InsuranceClaimIsStatusHandler AS InsuranceClaimIsStatusHandler,
  I_InsurClmSrvcsClaim.InsuranceClaimIsNoClaimMade AS InsuranceClaimIsNoClaimMade,
  I_InsurClmSrvcsClaim.InsuranceClaimIsStatusClosed AS InsuranceClaimIsStatusClosed,
  I_InsurClmSrvcsClaim.InsurClmStatReason AS InsurClmStatReason,
  I_InsurClmSrvcsClaim.InsurClmType AS InsurClmType,
  I_InsurClmSrvcsClaim.InsurClmAuthznGrp AS InsurClmAuthznGrp,
  I_InsurClmSrvcsClaim.InsurClmPolicyProdGeneration AS InsurClmPolicyProdGeneration,
  I_InsurClmSrvcsClaim.InsurClmPolicyProductVersion AS InsurClmPolicyProductVersion,
  I_InsurClmSrvcsClaim.InsurClmIncdntType AS InsurClmIncdntType,
  I_InsurClmSrvcsClaim.InsurClmDateOfLoss AS InsurClmDateOfLoss,
  I_InsurClmSrvcsClaim.InsurClmCauseOfLoss AS InsurClmCauseOfLoss,
  I_InsurClmSrvcsClaim.InsurClmLossLocAddressID AS InsurClmLossLocAddressID,
  I_InsurClmSrvcsClaim.InsurClmTypeGeneration AS InsurClmTypeGeneration,
  I_InsurClmSrvcsClaim.InsurClmTypeVers AS InsurClmTypeVers,
  I_InsurClmSrvcsClaim.InsuranceClaimBundleLossEvent AS InsuranceClaimBundleLossEvent,
  I_InsurClmSrvcsClaim.InsuranceClaimReinsurancePeril AS InsuranceClaimReinsurancePeril,
  I_InsurClmSrvcsClaim.InsurClmTimeOfLoss AS InsurClmTimeOfLoss,
  I_InsurClmSrvcsClaim.InsurClmTimeZoneOfLoss AS InsurClmTimeZoneOfLoss,
  I_InsurClmSrvcsClaim.InsuranceClaimIsDateEstimate AS InsuranceClaimIsDateEstimate,
  I_InsurClmSrvcsClaim.InsuranceClaimDateChangeReason AS InsuranceClaimDateChangeReason,
  I_InsurClmSrvcsClaim.InsurClmIsRptdToAuth AS InsurClmIsRptdToAuth,
  I_InsurClmSrvcsClaim.InsurClmContractLastRenewal AS InsurClmContractLastRenewal,
  I_InsurClmSrvcsClaim.InsurClmVersionChangeTime AS InsurClmVersionChangeTime,
  I_InsurClmSrvcsClaim.InsurClmAssignUUID AS InsurClmAssignUUID,
  I_InsurClmSrvcsClaim.InsurClmComplexity AS InsurClmComplexity,
  I_InsurClmSrvcsClaim.InsurClmJurisdictionCountry AS InsurClmJurisdictionCountry,
  I_InsurClmSrvcsClaim.InsurClmJurisdictionRegion AS InsurClmJurisdictionRegion,
  I_InsurClmSrvcsClaim.InsurClmActyAssgmtSts AS InsurClmActyAssgmtSts,
  I_InsurClmSrvcsClaim.InsuranceClaimOwnerType AS InsuranceClaimOwnerType,
  I_InsurClmSrvcsClaim.InsuranceClaimOwner AS InsuranceClaimOwner,
  I_InsurClmSrvcsClaim.InsuranceClaimOwnerTypeGroup AS InsuranceClaimOwnerTypeGroup,
  I_InsurClmSrvcsClaim.InsuranceClaimOwnerGroup AS InsuranceClaimOwnerGroup,
  I_InsurClmSrvcsClaim.InsuranceClaimIsCumulative AS InsuranceClaimIsCumulative,
  I_InsurClmSrvcsClaim.InsuranceClaimViewFault AS InsuranceClaimViewFault,
  I_InsurClmSrvcsClaim.InsurClmVwFaultPlcyHldr AS InsurClmVwFaultPlcyHldr,
  I_InsurClmSrvcsClaim.InsurClmIsThirdPartyKnown AS InsurClmIsThirdPartyKnown,
  I_InsurClmSrvcsClaim.InsurClmCovered AS InsurClmCovered,
  I_InsurClmSrvcsClaim.InsurClmIsEntrInPaytAmtAuthzns AS InsurClmIsEntrInPaytAmtAuthzns,
  I_InsurClmSrvcsClaim.InsuranceClaimIsNoNotif AS InsuranceClaimIsNoNotif,
  I_InsurClmSrvcsClaim.InsuranceClaimIsReserve AS InsuranceClaimIsReserve,
  I_InsurClmSrvcsClaim.InsurClmWrkflwExecDteTme AS InsurClmWrkflwExecDteTme,
  I_InsurClmSrvcsClaim.InsurClmWorkflowStatus AS InsurClmWorkflowStatus,
  I_InsurClmSrvcsClaim.InsurClmOpenDate AS InsurClmOpenDate,
  I_InsurClmSrvcsClaim.InsuranceClaimMaxItemNumber AS InsuranceClaimMaxItemNumber,
  I_InsurClmSrvcsClaim.InsurClmSecondInjuryFundStatus AS InsurClmSecondInjuryFundStatus,
  I_InsurClmSrvcsClaim.InsurClmIncdntInvstgnSts AS InsurClmIncdntInvstgnSts,
  I_InsurClmSrvcsClaim.InsuranceClaimEffectiveDate AS InsuranceClaimEffectiveDate,
  I_InsurClmSrvcsClaim.InsuranceClaimLossRepDate AS InsuranceClaimLossRepDate,
  I_InsurClmSrvcsClaim.InsuranceClaimIsLumpSumOption AS InsuranceClaimIsLumpSumOption,
  I_InsurClmSrvcsClaim.InsurClmStatutoryPensionType AS InsurClmStatutoryPensionType,
  I_InsurClmSrvcsClaim.InsurClmWithdrawAmt AS InsurClmWithdrawAmt,
  I_InsurClmSrvcsClaim.InsurClmWithdrawCrcy AS InsurClmWithdrawCrcy,
  I_InsurClmSrvcsClaim.InsurClmWthdrwlSqnc AS InsurClmWthdrwlSqnc,
  I_InsurClmSrvcsClaim.InsuranceClaimAlternateBenefit AS InsuranceClaimAlternateBenefit,
  I_InsurClmSrvcsClaim.InsuranceClaimSpecialRiskNotif AS InsuranceClaimSpecialRiskNotif,
  I_InsurClmSrvcsClaim.InsuranceClaimNotifReason AS InsuranceClaimNotifReason,
  I_InsurClmSrvcsClaim.InsuranceClaimAutoResubmission AS InsuranceClaimAutoResubmission,
  I_InsurClmSrvcsClaim.InsuranceClaimFollowUpDate AS InsuranceClaimFollowUpDate,
  I_InsurClmSrvcsClaim.InsuranceClaimProcessingDate AS InsuranceClaimProcessingDate,
  I_InsurClmSrvcsClaim.InsuranceClaimStatusObjectNmbr AS InsuranceClaimStatusObjectNmbr,
  I_InsurClmSrvcsClaim.InsuranceClaimDunningStatus AS InsuranceClaimDunningStatus,
  I_InsurClmSrvcsClaim.InsuranceClaimClearDate AS InsuranceClaimClearDate,
  I_InsurClmSrvcsClaim.InsurClmPremiumBalanceAmount AS InsurClmPremiumBalanceAmount,
  I_InsurClmSrvcsClaim.InsurClmPremiumBalanceCurrency AS InsurClmPremiumBalanceCurrency,
  I_InsurClmSrvcsClaim.InsuranceClaimWithdrawalType AS InsuranceClaimWithdrawalType,
  I_InsurClmSrvcsClaim.InsuranceClaimReactDate AS InsuranceClaimReactDate,
  I_InsurClmSrvcsClaim.InsurClmSpecialRiskMsgDateTime AS InsurClmSpecialRiskMsgDateTime,
  I_InsurClmSrvcsClaim.InsurClmIncrrtBnftCalcDateTime AS InsurClmIncrrtBnftCalcDateTime,
  I_InsurClmSrvcsClaim.InsuranceClaimPolicySystem AS InsuranceClaimPolicySystem,
  I_InsurClmSrvcsClaim.InsurClmBenefitTypeTree AS InsurClmBenefitTypeTree,
  I_InsurClmSrvcsClaim.InsurClmBnftTypeTreeGeneration AS InsurClmBnftTypeTreeGeneration,
  I_InsurClmSrvcsClaim.InsurClmBnftTypeTreeVersion AS InsurClmBnftTypeTreeVersion,
  I_InsurClmSrvcsClaim.InsurClmIsWithoutProduct AS InsurClmIsWithoutProduct,
  I_InsurClmSrvcsClaim.InsurClmIsDummyClaim AS InsurClmIsDummyClaim,
  I_InsurClmSrvcsClaim.InsurClmReportedDate AS InsurClmReportedDate,
  I_InsurClmSrvcsClaim.InsurClmAgentReportedDate AS InsurClmAgentReportedDate,
  I_InsurClmSrvcsClaim.InsurClmSensitiveClaim AS InsurClmSensitiveClaim,
  I_InsurClmSrvcsClaim.InsuranceClaimExternalNumber AS InsuranceClaimExternalNumber,
  I_InsurClmSrvcsClaim.InsuranceClaimDraftIdentifier AS InsuranceClaimDraftIdentifier,
  I_InsurClmSrvcsClaim.InsurClmArchivingStatus AS InsurClmArchivingStatus,
  I_InsurClmSrvcsClaim.InsurClmArchResubmsnDte AS InsurClmArchResubmsnDte,
  I_InsurClmSrvcsClaim.InsurClmArchRjcnRsn AS InsurClmArchRjcnRsn,
  I_InsurClmSrvcsClaim.InsurClmDescriptionOfLossLoc AS InsurClmDescriptionOfLossLoc,
  I_InsurClmSrvcsClaim.InsurClmIncidentDetailsText AS InsurClmIncidentDetailsText,
  _LossLocationAddress.StreetName AS InsurClmLossLocStreet,
  _LossLocationAddress.HouseNumber AS InsurClmLossLocHouseNumber,
  _LossLocationAddress.CityName AS InsurClmLossLocCity,
  _LossLocationAddress.Region AS InsurClmLossLocRegion,
  _LossLocationAddress.PostalCode AS InsurClmLossLocPostalCode,
  _LossLocationAddress.Country AS InsurClmLossLocCountry,
  I_InsurClmSrvcsClaim._AllwdSubclmType AS _AllwdSubclmType,
  I_InsurClmSrvcsClaim._LossDesc AS _LossDesc,
  I_InsurClmSrvcsClaim._LossLocDesc AS _LossLocDesc,
  I_InsurClmSrvcsClaim._PolicyProduct AS _PolicyProduct,
  I_InsurClmSrvcsClaim._PolicySnapshot AS _PolicySnapshot,
  cast('' as boole_d preserving type ) AS InsuranceClaimIsSFCChange,
  cast('' as bu_aktyp ) AS InsuranceClaimActivityCategory,
  cast('' as icl_formset01 preserving type) AS InsurClmHasGrandChild,
  cast('' as icl_formset01 preserving type) AS InsurClmHasSubclmGrandChild
FROM I_InsurClmSrvcsClaim
LEFT OUTER JOIN R_InsurClmSrvcsPaymentItemTP AS _InsuranceClaimPaymentItem ON InsuranceClaim = _InsuranceClaimPaymentItem.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsSubclmAttchTP AS _InsurClmSrvcsSubclmAttch ON InsuranceClaim = _InsurClmSrvcsSubclmAttch.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsSubclmItmGrpgTP AS _InsurClmSrvcsSubclmItmGrpg ON InsuranceClaim = _InsurClmSrvcsSubclmItmGrpg.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsSubclmItemTP AS _InsurClmSrvcsSubclmItem ON InsuranceClaim = _InsurClmSrvcsSubclmItem.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsSubclmDiagnTP AS _InsurClmSrvcsSubclmDiagn ON InsuranceClaim = _InsurClmSrvcsSubclmDiagn.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsSubclmPaymentTP AS _InsurClmSrvcsSubclmPayment ON InsuranceClaim = _InsurClmSrvcsSubclmPayment.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsSubclmPaytItmTP AS _InsurClmSrvcsSubclmPaytItem ON InsuranceClaim = _InsurClmSrvcsSubclmPaytItem.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsSubclmPerfrmrTP AS _InsurClmSrvcsSubclmPerfrmr ON InsuranceClaim = _InsurClmSrvcsSubclmPerfrmr.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsSubclmReserveTP AS _InsurClmSrvcsSubclmReserve ON InsuranceClaim = _InsurClmSrvcsSubclmReserve.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsClmSrvcsPrtcpntSFCTP AS _InsurClmPrtcpntSFC ON InsuranceClaim = _InsurClmPrtcpntSFC.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsSubrogtnItemTP AS _InsurClmSubrogtnItem ON InsuranceClaim = _InsurClmSubrogtnItem.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsRblsHeaderTP AS _InsurClmSubrogtnRbls ON InsuranceClaim = _InsurClmSubrogtnRbls.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsRblsItemTP AS _InsuranceClaimRblsItem ON InsuranceClaim = _InsuranceClaimRblsItem.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsDmgdVehTP AS _InsurClmSrvcsDmgdVeh ON InsuranceClaim = _InsurClmSrvcsDmgdVeh.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsDmgdVehSalvgTP AS _InsurClmSrvcsDmgdVehSalvg ON InsuranceClaim = _InsurClmSrvcsDmgdVehSalvg.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsDmgdInjuredTP AS _InsurClmSrvcsDmgdInjured ON InsuranceClaim = _InsurClmSrvcsDmgdInjured.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsClmSrvcsDamagedPropertyTP AS _InsurClmSrvcsDmgdPrpty ON InsuranceClaim = _InsurClmSrvcsDmgdPrpty.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmServicesDiagnosisTP AS _InsurClmSrvcsDiagnosis ON InsuranceClaim = _InsurClmSrvcsDiagnosis.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN I_Address_2 AS _LossLocationAddress ON InsurClmLossLocAddressID = _LossLocationAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN R_InsurClmSrvcsFundItmTP AS _InsurClmSrvcsFundItm ON InsuranceClaim = _InsurClmSrvcsFundItm.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsClmSrvcsBnftSpltItmTP AS _InsClmSrvcsBnftSpltItm ON InsuranceClaim = _InsClmSrvcsBnftSpltItm.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsClmSrvcsTaxItemTP AS _InsurClmSrvcsTaxItm ON InsuranceClaim = _InsurClmSrvcsTaxItm.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsClmSrvcPerdcBnftSpltItmTP AS _InsClmSrvcPerdcBnftSpltItm ON InsuranceClaim = _InsClmSrvcPerdcBnftSpltItm.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsLoanItemTP AS _InsurClmSrvcsLoanItem ON InsuranceClaim = _InsurClmSrvcsLoanItem.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClaimServicesSubclaimTP AS _InsurClmSubclm ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsTaskTP AS _InsurClmSrvcsTask ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsNoteTP AS _InsurClmSrvcsNote ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsClmSrvcsLossLocSFCTP AS _InsClmSrvcsLossLocSFC ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsClmSrvcsOrignOfLsSFCTP AS _InsurClmSrvcsOrignOfLsSFC ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsClmSrvcsDmgdObjSFCTP AS _InsurClmSrvcsDmgdObjSFC ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsPrtcpntTP AS _InsurClmSrvcsParticipant ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsReserveTP AS _InsurClmSrvcsReserve ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsPaymentTP AS _InsurClmSrvcsPayment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsClaimItemTP AS _InsurClmSrvcsItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsCorrespncTP AS _InsurClmCorrespnc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsDamagedObjectTP AS _InsurClmDmgdObject ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsSubrogationTP AS _InsurClmSubrogtn ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsClmSrvcsBnftSpltHdrTP AS _InsClmSrvcsBnftSpltHdr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsFundHdrTP AS _InsurClmSrvcsFundHdr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsClmItmGrpgTP AS _InsurClmSrvcsClmItmGrpg ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsClmSrvcsTaxHeaderTP AS _InsurClmSrvcsTaxHdr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmLifeSrvcsClmItmTP AS _InsurClmSrvcsLifeClmItm ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsClmSrvcsPerdcBnftSpltTP AS _InsClmSrvcsPerdcBnftSplt ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsImpairmentTP AS _InsurClmSrvcsImpairment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsClmSrvcsLifePrivilegeTP AS _InsClmSrvcsLifePrivilege ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsWaitPerdTP AS _InsurClmSrvcsWaitPerd ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSrvcsLoanHdrTP AS _InsurClmSrvcsLoanHdr ON /* condition not available in parsed metadata */  -- association [0..*]
;