R_InsuranceClaimTP

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_InsuranceClaimTP.
-- 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_InsuranceClaimTP AS
SELECT
  InsuranceClaim,
  InsuranceContract,
  InsurClmPolicyProduct AS InsuranceClaimContractControl,
  ChangedOnDateTime AS LastChangeDateTime,
  LastChangedByUser,
  CreationDateTime,
  CreatedByUser,
  InsurClmLifeCycSts,
  InsurClmStatReason,
  InsurClmType,
  InsurClmAuthznGrp,
  InsurClmPolicyProdGeneration,
  InsurClmPolicyProductVersion,
  InsurClmIncdntType,
  InsurClmCauseOfLoss,
  InsurClmLossLocAddressID,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  dats_tims_to_tstmp (InsurClmDateOfLoss, InsurClmTimeOfLoss, InsurClmTimeZoneOfLoss, $session.client,'NULL' ) as InsurClmLossDateTime AS clientNULLasInsurClmLossDateTime,
  InsurClmContractLastRenewal,
  InsurClmVersionChangeTime,
  InsurClmAssignUUID,
  InsurClmComplexity,
  InsurClmJurisdictionCountry,
  InsurClmJurisdictionRegion,
  InsurClmCovered,
  InsurClmBenefitTypeTree,
  InsurClmBnftTypeTreeGeneration,
  InsurClmBnftTypeTreeVersion,
  InsurClmIsWithoutProduct,
  InsurClmIsDummyClaim,
  InsurClmReportedDate,
  InsurClmAgentReportedDate,
  InsurClmSensitiveClaim,
  InsurClmWholeClmChgdBy,
  InsurClmWholeClmChgDteTme,
  InsurClmExternalNumberCategory,
  InsurClmSubclmStsChgdOnDteTime,
  InsuranceClaimIsStatusHandler,
  InsuranceClaimIsNoClaimMade,
  InsuranceClaimIsStatusClosed,
  InsuranceClaimBundleLossEvent,
  InsuranceClaimReinsurancePeril,
  InsuranceClaimIsDateEstimate,
  InsuranceClaimDateChangeReason,
  InsurClmIsRptdToAuth,
  InsurClmActyAssgmtSts,
  InsuranceClaimOwnerType,
  InsuranceClaimOwner,
  InsuranceClaimOwnerTypeGroup,
  InsuranceClaimOwnerGroup,
  InsuranceClaimIsCumulative,
  InsuranceClaimViewFault,
  InsurClmVwFaultPlcyHldr,
  InsurClmIsThirdPartyKnown,
  InsurClmIsEntrInPaytAmtAuthzns,
  InsuranceClaimIsNoNotif,
  InsuranceClaimIsReserve,
  InsurClmWrkflwExecDteTme,
  InsurClmWorkflowStatus,
  InsuranceClaimMaxItemNumber,
  InsurClmSecondInjuryFundStatus,
  InsurClmIncdntInvstgnSts,
  InsuranceClaimEffectiveDate,
  InsuranceClaimLossRepDate,
  InsuranceClaimLumpSum,
  InsurClmStatutoryPensionType,
  InsurClmBndlWithdrawAmt,
  InsurClmBndlWithdrawCrcy,
  InsurClmBndlWthdrwlSqnc,
  InsuranceClaimAlternateBenefit,
  InsuranceClaimSpecialRiskNotif,
  InsuranceClaimNotifReason,
  InsuranceClaimAutoResubmission,
  InsClmAutoResubmsnDte,
  InsuranceClaimProcessingDate,
  InsuranceClaimStatusObjectNmbr,
  InsuranceClaimDunningStatus,
  InsuranceClaimClearDate,
  InsurClmPremiumBalanceAmount,
  InsurClmPremiumBalanceCurrency,
  InsuranceClaimWithdrawalType,
  InsuranceClaimReactDate,
  InsurClmSpecialRiskMsgDateTime,
  InsurClmIncrrtBnftCalcDateTime,
  InsuranceClaimPolicySystem,
  InsurClmArchivingStatus,
  InsurClmArchResubmsnDte,
  InsurClmArchRjcnRsn
FROM I_InsuranceClaim
LEFT OUTER JOIN R_InsuranceClaimShadowTP AS _InsuranceClaimShadow ON InsuranceClaim = _InsuranceClaimShadow.InsuranceClaim  -- association [1..*]
LEFT OUTER JOIN R_InsuranceClaimShadow2TP AS _InsuranceClaimShadow2 ON InsuranceClaim = _InsuranceClaimShadow2.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN E_InsuranceClaim_2 AS _Extension ON InsuranceClaim = _Extension.InsuranceClaim  -- association [1..1]
LEFT OUTER JOIN R_InsurClmByDiagnosisGroupTP AS _InsurClmByDiagnosisGroup ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmByLicensePlateNoTP AS _InsurClmByLicensePlateNo ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsuranceClaimByHandlerTP AS _InsuranceClaimByHandler ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsuranceClaimByDateOfLossTP AS _InsuranceClaimByDateOfLoss ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSubclaimTP AS _InsuranceSubclaim ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClaimItemTP AS _InsuranceClmItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClaimTaskTP AS _InsuranceClmTask ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmCoverageReferralTP AS _InsuranceClmCvrgReferral ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmParticipantTP AS _InsuranceClmParticipant ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsuranceClaimPaymentTP AS _InsuranceClaimPayment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsuranceClaimReserveTP AS _InsuranceClaimReserve ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmDamagedObjectTP AS _InsuranceClaimDamagedObject ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmPerformerTP AS _InsuranceClaimPerformer ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmPolicySnapshotTP AS _InsurClmPolicySnapshot ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsuranceClaimNoteTP AS _InsurClmNote ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmFactCaptureTP AS _InsurClmFactCapture ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmObjectAssignmentTP AS _InsurClmObjAssignment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSubrogationTP AS _InsurClmSubrogation ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmLitigationHeaderTP AS _InsurClmLitigationHeader ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmNegotiationHeaderTP AS _InsurClmNegotiationHeader ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsuranceClaimItemGroupingTP AS _InsuranceClaimItemGrouping ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmWaitPeriodTP AS _InsurClmWaitPeriod ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmTaxHeaderTP AS _InsurClmTaxHeader ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmLoanHeaderTP AS _InsurClmLoanHeader ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmImpairmentTP AS _InsurClmImpairment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmBnftSplitPerdcHdrTP AS _InsurClmBnftSplitPerdcHdr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSpclRightBnftSplitTP AS _InsurClmSpclRightBnftSplit ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmFundHeaderTP AS _InsurClmFundHeader ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmBenefitSplitHeaderTP AS _InsurClmBenefitSplitHeader ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmAttachmentOutboundTP AS _InsurClmAttachOutbound ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmAttachmentTP AS _InsurClmAttachment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmArchiveLinkAssgmtTP AS _InsurClmArchiveLinkAssgmt ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmPrtcpntWrkrsCompnTP AS _InsurClmPrtcpntWrkrsCompn ON /* condition not available in parsed metadata */  -- association [0..*]
;