R_InsurPlcyReltdContractTP_2

DDL: R_INSURPLCYRELTDCONTRACTTP_2 Type: view_entity TRANSACTIONAL
43 Fields 2 Data Sources 3 Associations

Related Contract - TP

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

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyHghstVersPerAppl HighestVersion inner
I_InsurPlcyReltdContrVersion ReltdContr from

Associations (3)

CardinalityTargetAliasCondition
[1..1] R_InsurancePolicyTP_3 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID
[0..*] R_InsurPlcyReltdContrClaimTP_2 _ReltdContrClaim $projection.InsurPlcyUUIDForEdit = _ReltdContrClaim.InsurPlcyUUID and $projection.InsurPlcyApplUUIDForEdit = _ReltdContrClaim.InsurPlcyApplUUID and $projection.InsurPlcyInsurContrForEdit = _ReltdContrClaim.InsurPlcyInsurContr and $projection.InsurPlcyCvPcgIDForEdit = _ReltdContrClaim.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageIDForEdit = _ReltdContrClaim.InsurPlcyCoverageID and $projection.InsurPlcyCvrgOptnIDForEdit = _ReltdContrClaim.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsrdObjIDForEdit = _ReltdContrClaim.InsurPlcyInsuredObjectID and $projection.InsurPlcyReltdContrIDForEdit = _ReltdContrClaim.InsurPlcyReltdContrID
[1..1] E_InsurPolicyRelatedContract _Extension ( $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID or $projection.InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID and $projection.InsurPlcyReltdContrID = _Extension.InsurPlcyReltdContrID and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr

Annotations (12)

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

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyReltdContrVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyReltdContrVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyReltdContrVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyReltdContrVersion InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyReltdContrVersion InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID I_InsurPlcyReltdContrVersion InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyInsuredObjectID I_InsurPlcyReltdContrVersion InsurPlcyInsuredObjectID Ins. Obj. No.
KEY InsurPlcyReltdContrID I_InsurPlcyReltdContrVersion InsurPlcyReltdContrID Rel.Contract ID
InsurPlcyUUIDForEdit I_InsurPlcyReltdContrVersion InsurPlcyUUID Policy UUID
InsurPlcyApplUUIDForEdit I_InsurPlcyReltdContrVersion InsurPlcyApplUUID Policy UUID
InsurPlcyInsurContrForEdit I_InsurPlcyReltdContrVersion InsurPlcyInsurContr Contract Key
InsurPlcyCvPcgIDForEdit I_InsurPlcyReltdContrVersion InsurPlcyCoveragePackageID Cov.Package ID
InsurPlcyCoverageIDForEdit I_InsurPlcyReltdContrVersion InsurPlcyCoverageID Coverage Key
InsurPlcyCvrgOptnIDForEdit I_InsurPlcyReltdContrVersion InsurPlcyCoverageOptionID Cov. Option Key
InsurPlcyInsrdObjIDForEdit I_InsurPlcyReltdContrVersion InsurPlcyInsuredObjectID Ins. Obj. No.
InsurPlcyReltdContrIDForEdit I_InsurPlcyReltdContrVersion InsurPlcyReltdContrID Rel.Contract ID
InsurPlcyOrderNumber I_InsurPlcyReltdContrVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyReltdContrVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyReltdContrVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlNmbr I_InsurPlcyReltdContrVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyReltdContrVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurPlcyReltdContrVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyReltdContrIsCancelled I_InsurPlcyReltdContrVersion InsurPlcyReltdContrIsCancelled Rev. Flag
InsurPlcyReltdContrSumInsrdAmt I_InsurPlcyReltdContrVersion InsurPlcyReltdContrSumInsrdAmt Sum Insured
InsurPlcyReltdContrNrOfClmDspd I_InsurPlcyReltdContrVersion InsurPlcyReltdContrNrOfClmDspd Total Claims
InsurPlcyReltdContrTotCompnAmt I_InsurPlcyReltdContrVersion InsurPlcyReltdContrTotCompnAmt Total Comp.
InsurPlcyReltdContrType I_InsurPlcyReltdContrVersion InsurPlcyReltdContrType Rel. Pol. Type
InsurPlcyReltdContrPlcyNmbr I_InsurPlcyReltdContrVersion InsurPlcyReltdContrPlcyNmbr Policy Number
InsurPlcyReltdContrStartDate I_InsurPlcyReltdContrVersion InsurPlcyReltdContrStartDate Start Date
InsurPlcyReltdContrExprtnDate I_InsurPlcyReltdContrVersion InsurPlcyReltdContrExprtnDate Expiration Date
InsurPlcyReltdContrPremAmount I_InsurPlcyReltdContrVersion InsurPlcyReltdContrPremAmount Premium
InsurPlcyReltdContrSharePct I_InsurPlcyReltdContrVersion InsurPlcyReltdContrSharePct Share (%) AI
InsurPlcyReltdContrRvslReason I_InsurPlcyReltdContrVersion InsurPlcyReltdContrRvslReason Reversal Reason
InsurPlcyReltdContrPartnerID I_InsurPlcyReltdContrVersion InsurPlcyReltdContrPartnerID BusPartner
InsurPlcyReltdContrAddrNumber I_InsurPlcyReltdContrVersion InsurPlcyReltdContrAddrNumber Address
InsurPlcyReltdContrCommentID I_InsurPlcyReltdContrVersion InsurPlcyReltdContrCommentID Note Long Text
InsurPlcyReltdContrCurrency I_InsurPlcyReltdContrVersion InsurPlcyReltdContrCurrency Currency
InsurPlcyReltdContrTemplate I_InsurPlcyReltdContrVersion InsurPlcyReltdContrTemplate Template ID
InsurPlcyBusinessObject I_InsurPlcyReltdContrVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyReltdContrVersion LastChangeDateTime Timestamp
_Currency I_InsurPlcyReltdContrVersion _Currency
_ReltdContrClaim _ReltdContrClaim
_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_InsurPlcyReltdContractTP_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_InsurPlcyReltdContractTP_2 AS
SELECT
  ReltdContr.InsurPlcyUUID AS InsurPlcyUUID,
  ReltdContr.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  ReltdContr.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  ReltdContr.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  ReltdContr.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  ReltdContr.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  ReltdContr.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  ReltdContr.InsurPlcyReltdContrID AS InsurPlcyReltdContrID,
  ReltdContr.InsurPlcyUUID AS InsurPlcyUUIDForEdit,
  ReltdContr.InsurPlcyApplUUID AS InsurPlcyApplUUIDForEdit,
  ReltdContr.InsurPlcyInsurContr AS InsurPlcyInsurContrForEdit,
  ReltdContr.InsurPlcyCoveragePackageID AS InsurPlcyCvPcgIDForEdit,
  ReltdContr.InsurPlcyCoverageID AS InsurPlcyCoverageIDForEdit,
  ReltdContr.InsurPlcyCoverageOptionID AS InsurPlcyCvrgOptnIDForEdit,
  ReltdContr.InsurPlcyInsuredObjectID AS InsurPlcyInsrdObjIDForEdit,
  ReltdContr.InsurPlcyReltdContrID AS InsurPlcyReltdContrIDForEdit,
  ReltdContr.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  ReltdContr.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  ReltdContr.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  ReltdContr.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  ReltdContr.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  ReltdContr.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  ReltdContr.InsurPlcyReltdContrIsCancelled AS InsurPlcyReltdContrIsCancelled,
  ReltdContr.InsurPlcyReltdContrSumInsrdAmt AS InsurPlcyReltdContrSumInsrdAmt,
  ReltdContr.InsurPlcyReltdContrNrOfClmDspd AS InsurPlcyReltdContrNrOfClmDspd,
  ReltdContr.InsurPlcyReltdContrTotCompnAmt AS InsurPlcyReltdContrTotCompnAmt,
  ReltdContr.InsurPlcyReltdContrType AS InsurPlcyReltdContrType,
  ReltdContr.InsurPlcyReltdContrPlcyNmbr AS InsurPlcyReltdContrPlcyNmbr,
  ReltdContr.InsurPlcyReltdContrStartDate AS InsurPlcyReltdContrStartDate,
  ReltdContr.InsurPlcyReltdContrExprtnDate AS InsurPlcyReltdContrExprtnDate,
  ReltdContr.InsurPlcyReltdContrPremAmount AS InsurPlcyReltdContrPremAmount,
  ReltdContr.InsurPlcyReltdContrSharePct AS InsurPlcyReltdContrSharePct,
  ReltdContr.InsurPlcyReltdContrRvslReason AS InsurPlcyReltdContrRvslReason,
  ReltdContr.InsurPlcyReltdContrPartnerID AS InsurPlcyReltdContrPartnerID,
  ReltdContr.InsurPlcyReltdContrAddrNumber AS InsurPlcyReltdContrAddrNumber,
  ReltdContr.InsurPlcyReltdContrCommentID AS InsurPlcyReltdContrCommentID,
  ReltdContr.InsurPlcyReltdContrCurrency AS InsurPlcyReltdContrCurrency,
  ReltdContr.InsurPlcyReltdContrTemplate AS InsurPlcyReltdContrTemplate,
  ReltdContr.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  ReltdContr.LastChangeDateTime AS LastChangeDateTime,
  ReltdContr._Currency AS _Currency
FROM I_InsurPlcyReltdContrVersion AS ReltdContr
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 R_InsurPlcyReltdContrClaimTP_2 AS _ReltdContrClaim ON InsurPlcyUUIDForEdit = _ReltdContrClaim.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _ReltdContrClaim.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _ReltdContrClaim.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _ReltdContrClaim.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _ReltdContrClaim.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _ReltdContrClaim.InsurPlcyCoverageOptionID AND InsurPlcyInsrdObjIDForEdit = _ReltdContrClaim.InsurPlcyInsuredObjectID AND InsurPlcyReltdContrIDForEdit = _ReltdContrClaim.InsurPlcyReltdContrID  -- association [0..*]
LEFT OUTER JOIN E_InsurPolicyRelatedContract AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID AND InsurPlcyReltdContrID = _Extension.InsurPlcyReltdContrID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr  -- association [1..1]
;

Learn More