R_InsurPlcyInsObAddressTP

DDL: R_INSURPLCYINSOBADDRESSTP Type: view_entity TRANSACTIONAL
22 Fields 2 Data Sources 2 Associations

Insured Object Address - TP

R_InsurPlcyInsObAddressTP is a Transactional CDS View that provides data about "Insured Object Address - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyHghstVersPerAppl, I_InsurPlcyInsrdObjAddrVersion) and exposes 22 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_InsurPlcyInsrdObjAddrVersion InsuredObjectAddress from

Associations (2)

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

Annotations (11)

NameValueLevelField
EndUserText.label Insured Object Address - 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 #XL view
ObjectModel.sapObjectNodeType.name InsurancePolicyInsuredAddress view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix IOA view
Metadata.ignorePropagatedAnnotations true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyInsrdObjAddrVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyInsrdObjAddrVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyInsrdObjAddrVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyInsrdObjAddrVersion InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyInsrdObjAddrVersion InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID I_InsurPlcyInsrdObjAddrVersion InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyInsuredObjectID I_InsurPlcyInsrdObjAddrVersion InsurPlcyInsuredObjectID Ins. Obj. No.
KEY InsurPlcyAddrID I_InsurPlcyInsrdObjAddrVersion InsurPlcyAddrID Address ID
InsurPlcyOrderNumber I_InsurPlcyInsrdObjAddrVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyInsrdObjAddrVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyInsrdObjAddrVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlNmbr I_InsurPlcyInsrdObjAddrVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyInsrdObjAddrVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurPlcyInsrdObjAddrVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyInsrdObjAddrIsCancld I_InsurPlcyInsrdObjAddrVersion InsurPlcyInsrdObjAddrIsCancld Rev. Flag
InsurInsrblObjIsStdAddr I_InsurPlcyInsrdObjAddrVersion InsurInsrblObjIsStdAddr Standard Addr.
InsurInsrblObjAddrKey I_InsurPlcyInsrdObjAddrVersion InsurInsrblObjAddrKey Address
InsurPlcyPostCodeTxt I_InsurPlcyInsrdObjAddrVersion InsurPlcyPostCodeTxt Postal Code
InsurPlcyAddrTemplate I_InsurPlcyInsrdObjAddrVersion InsurPlcyAddrTemplate InsObjAddrAssgn
InsurPlcyBusinessObject I_InsurPlcyInsrdObjAddrVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyInsrdObjAddrVersion LastChangeDateTime Timestamp
_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_InsurPlcyInsObAddressTP.
-- 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_InsurPlcyInsObAddressTP AS
SELECT
  InsuredObjectAddress.InsurPlcyUUID AS InsurPlcyUUID,
  InsuredObjectAddress.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  InsuredObjectAddress.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  InsuredObjectAddress.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  InsuredObjectAddress.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  InsuredObjectAddress.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  InsuredObjectAddress.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  InsuredObjectAddress.InsurPlcyAddrID AS InsurPlcyAddrID,
  InsuredObjectAddress.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  InsuredObjectAddress.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  InsuredObjectAddress.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  InsuredObjectAddress.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  InsuredObjectAddress.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  InsuredObjectAddress.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  InsuredObjectAddress.InsurPlcyInsrdObjAddrIsCancld AS InsurPlcyInsrdObjAddrIsCancld,
  InsuredObjectAddress.InsurInsrblObjIsStdAddr AS InsurInsrblObjIsStdAddr,
  InsuredObjectAddress.InsurInsrblObjAddrKey AS InsurInsrblObjAddrKey,
  InsuredObjectAddress.InsurPlcyPostCodeTxt AS InsurPlcyPostCodeTxt,
  InsuredObjectAddress.InsurPlcyAddrTemplate AS InsurPlcyAddrTemplate,
  InsuredObjectAddress.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  InsuredObjectAddress.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPlcyInsrdObjAddrVersion AS InsuredObjectAddress
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_InsurPolicyInsuredAddress AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID AND InsurPlcyAddrID = _Extension.InsurPlcyAddrID  -- association [1..1]
;

Learn More