I_InsurClmSubclaim

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 I_InsurClmSubclaim.
-- 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 I_InsurClmSubclaim AS
SELECT
  claim AS InsuranceClaim,
  subclaim AS InsurClmSubclm,
  cast(createtime as timestamp) AS CreationDateTime,
  cast(changetime as timestamp) AS LastChangeDateTime,
  status AS InsurClmLifeCycSts,
  cast(statuschg as timestamp) AS InsurClmSubclmStsChgdOnDteTime,
  subcltype AS InsurClmSubclmType,
  xsubro AS InsurClmSubrogtnRecoveryStatus,
  subclaimdesc AS InsurClmSubclaimDescription,
  bentree AS InsurClmBenefitTypeTree,
  bentreeg AS InsurClmBnftTypeTreeGeneration,
  bentreev AS InsurClmBnftTypeTreeVersion,
  coverage AS InsurClmCoverage,
  sthandler AS IsInProcess,
  stclosed AS IsClosed,
  assign_guid AS InsurClmSubclaimAssignUUID,
  xcovconfirmed AS InsurClmCvrgConfirmedFlag,
  xfraud AS InsurClmFraudFlag,
  xsalvage AS InsurClmSalvageFlag,
  xlitigation AS InsurClmLitigationFlag,
  xnegotiation AS InsurClmNegotiationFlag,
  statreason AS InsurClmSubclmStsRsn,
  complex AS InsurClmComplexity,
  xotherinsure AS InsurClmIsOtherInsurance,
  subro_potential AS InsurClmSubrogtnPotential,
  covpolvnr AS InsurClmContractVersion
FROM iclsubcl
LEFT OUTER JOIN I_InsuranceClaim AS _Claim ON InsuranceClaim = _Claim.InsuranceClaim  -- association [1]
LEFT OUTER JOIN I_InsurClmCvrgPolicySnapshot AS _CoveragePolicySnapshot ON InsuranceClaim = _CoveragePolicySnapshot.InsuranceClaim AND InsurClmCoverage = _CoveragePolicySnapshot.InsurClmCoverage AND _CoveragePolicySnapshot.InsurClmContractVersion = '00'  -- association [1]
;