R_InsurPlcyReltdContrClaimTP_2

DDL: R_INSURPLCYRELTDCONTRCLAIMTP_2 Type: view_entity TRANSACTIONAL
26 Fields 2 Data Sources 2 Associations

Related Contract Claim - TP

R_InsurPlcyReltdContrClaimTP_2 is a Transactional CDS View that provides data about "Related Contract Claim - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyHghstVersPerAppl, I_InsurPlcyReltdContrClmVers) and exposes 26 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyHghstVersPerAppl HighestVersion inner
I_InsurPlcyReltdContrClmVers ReltdContrClaim from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_InsurancePolicyTP_3 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID
[1..1] E_InsurPolicyReltdContrClaim _Extension $projection.InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID and ( $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID or $projection.InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.InsurPlcyRelatedContrClaimID = _Extension.InsurPlcyRelatedContrClaimID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr and $projection.InsurPlcyReltdContrID = _Extension.InsurPlcyReltdContrID and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID

Annotations (11)

NameValueLevelField
EndUserText.label Related Contract Claim - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.sapObjectNodeType.name InsurancePolicyReltdContrClaim view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix EPC view
AbapCatalog.extensibility.allowNewDatasources false view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyReltdContrClmVers InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyReltdContrClmVers InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyReltdContrClmVers InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyReltdContrClmVers InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyReltdContrClmVers InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID I_InsurPlcyReltdContrClmVers InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyInsuredObjectID I_InsurPlcyReltdContrClmVers InsurPlcyInsuredObjectID Ins. Obj. No.
KEY InsurPlcyReltdContrID I_InsurPlcyReltdContrClmVers InsurPlcyReltdContrID Rel.Contract ID
KEY InsurPlcyRelatedContrClaimID I_InsurPlcyReltdContrClmVers InsurPlcyRelatedContrClaimID RelCtr Claim ID
InsurPlcyOrderNumber I_InsurPlcyReltdContrClmVers InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyReltdContrClmVers InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyReltdContrClmVers InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurPlcyReltdContrClmVers InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPlcyReltdContrClmVers InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPlcyReltdContrClmVers InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyReltdContrClmIsRvsd I_InsurPlcyReltdContrClmVers InsurPlcyReltdContrClmIsRvsd Rev. Flag
InsurPlcyReltdContrClmCompnAmt I_InsurPlcyReltdContrClmVers InsurPlcyReltdContrClmCompnAmt Compensation
InsurPlcyReltdContrNmbrOfClaim I_InsurPlcyReltdContrClmVers InsurPlcyReltdContrNmbrOfClaim Claim Count
InsurPlcyReltdClmLineOfBus I_InsurPlcyReltdContrClmVers InsurPlcyReltdClmLineOfBus Claim LOB
InsurPlcyReltdContrClaimDate I_InsurPlcyReltdContrClmVers InsurPlcyReltdContrClaimDate Date of Loss
InsurPlcyReltdContrClmCurrency I_InsurPlcyReltdContrClmVers InsurPlcyReltdContrClmCurrency Currency
InsurPlcyReltdContrClmTemplate I_InsurPlcyReltdContrClmVers InsurPlcyReltdContrClmTemplate Template ID
InsurPlcyBusinessObject I_InsurPlcyReltdContrClmVers InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyReltdContrClmVers LastChangeDateTime Timestamp
_Currency I_InsurPlcyReltdContrClmVers _Currency
_Policy _Policy

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_InsurPlcyReltdContrClaimTP_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_InsurPlcyReltdContrClaimTP_2 AS
SELECT
  ReltdContrClaim.InsurPlcyUUID AS InsurPlcyUUID,
  ReltdContrClaim.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  ReltdContrClaim.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  ReltdContrClaim.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  ReltdContrClaim.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  ReltdContrClaim.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  ReltdContrClaim.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  ReltdContrClaim.InsurPlcyReltdContrID AS InsurPlcyReltdContrID,
  ReltdContrClaim.InsurPlcyRelatedContrClaimID AS InsurPlcyRelatedContrClaimID,
  ReltdContrClaim.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  ReltdContrClaim.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  ReltdContrClaim.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  ReltdContrClaim.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  ReltdContrClaim.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  ReltdContrClaim.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  ReltdContrClaim.InsurPlcyReltdContrClmIsRvsd AS InsurPlcyReltdContrClmIsRvsd,
  ReltdContrClaim.InsurPlcyReltdContrClmCompnAmt AS InsurPlcyReltdContrClmCompnAmt,
  ReltdContrClaim.InsurPlcyReltdContrNmbrOfClaim AS InsurPlcyReltdContrNmbrOfClaim,
  ReltdContrClaim.InsurPlcyReltdClmLineOfBus AS InsurPlcyReltdClmLineOfBus,
  ReltdContrClaim.InsurPlcyReltdContrClaimDate AS InsurPlcyReltdContrClaimDate,
  ReltdContrClaim.InsurPlcyReltdContrClmCurrency AS InsurPlcyReltdContrClmCurrency,
  ReltdContrClaim.InsurPlcyReltdContrClmTemplate AS InsurPlcyReltdContrClmTemplate,
  ReltdContrClaim.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  ReltdContrClaim.LastChangeDateTime AS LastChangeDateTime,
  ReltdContrClaim._Currency AS _Currency
FROM I_InsurPlcyReltdContrClmVers AS ReltdContrClaim
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_InsurancePolicyTP_3 AS _Policy ON InsurPlcyUUID = _Policy.InsurPlcyUUID AND InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID  -- association [1..1]
LEFT OUTER JOIN E_InsurPolicyReltdContrClaim AS _Extension ON InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID AND ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyRelatedContrClaimID = _Extension.InsurPlcyRelatedContrClaimID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyReltdContrID = _Extension.InsurPlcyReltdContrID AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID  -- association [1..1]
;

Learn More