R_InsurPlcyExtRefTP_2

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

External Reference - TP

R_InsurPlcyExtRefTP_2 is a Transactional CDS View that provides data about "External Reference - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyExtReferenceVersion, I_InsurPlcyHghstVersPerAppl) 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_InsurPlcyExtReferenceVersion ExtReference from
I_InsurPlcyHghstVersPerAppl HighestVersion inner

Associations (2)

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

Annotations (12)

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

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyExtReferenceVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyExtReferenceVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyExtReferenceVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyExtReferenceVersion InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyExtReferenceVersion InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID I_InsurPlcyExtReferenceVersion InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyInsuredObjectID I_InsurPlcyExtReferenceVersion InsurPlcyInsuredObjectID Ins. Obj. No.
KEY InsurPlcyExternalReferenceID I_InsurPlcyExtReferenceVersion InsurPlcyExternalReferenceID Ext. Ref. ID
InsurPlcyOrderNumber I_InsurPlcyExtReferenceVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyExtReferenceVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyExtReferenceVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlNmbr I_InsurPlcyExtReferenceVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyExtReferenceVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurPlcyExtReferenceVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyExtRefIsCancelled I_InsurPlcyExtReferenceVersion InsurPlcyExtRefIsCancelled Rev. Flag
InsurPlcyExtRefCompany I_InsurPlcyExtReferenceVersion InsurPlcyExtRefCompany Ref. Comp.
InsurPlcyExtRefReferenceNumber I_InsurPlcyExtReferenceVersion InsurPlcyExtRefReferenceNumber Ref. No.
InsurPlcyExtRefReferenceType I_InsurPlcyExtReferenceVersion InsurPlcyExtRefReferenceType Reference Type
InsurPlcyExtRefTemplate I_InsurPlcyExtReferenceVersion InsurPlcyExtRefTemplate Template ID
InsurPlcyBusinessObject I_InsurPlcyExtReferenceVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyExtReferenceVersion 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_InsurPlcyExtRefTP_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_InsurPlcyExtRefTP_2 AS
SELECT
  ExtReference.InsurPlcyUUID AS InsurPlcyUUID,
  ExtReference.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  ExtReference.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  ExtReference.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  ExtReference.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  ExtReference.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  ExtReference.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  ExtReference.InsurPlcyExternalReferenceID AS InsurPlcyExternalReferenceID,
  ExtReference.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  ExtReference.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  ExtReference.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  ExtReference.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  ExtReference.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  ExtReference.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  ExtReference.InsurPlcyExtRefIsCancelled AS InsurPlcyExtRefIsCancelled,
  ExtReference.InsurPlcyExtRefCompany AS InsurPlcyExtRefCompany,
  ExtReference.InsurPlcyExtRefReferenceNumber AS InsurPlcyExtRefReferenceNumber,
  ExtReference.InsurPlcyExtRefReferenceType AS InsurPlcyExtRefReferenceType,
  ExtReference.InsurPlcyExtRefTemplate AS InsurPlcyExtRefTemplate,
  ExtReference.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  ExtReference.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPlcyExtReferenceVersion AS ExtReference
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_InsurPlcyExtRef AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID AND InsurPlcyExternalReferenceID = _Extension.InsurPlcyExternalReferenceID  -- association [1..1]
;

Learn More