I_InsurPlcyExtReferenceVersion

DDL: I_INSURPLCYEXTREFERENCEVERSION Type: view_entity COMPOSITE
40 Fields 4 Data Sources

External Reference

I_InsurPlcyExtReferenceVersion is a Composite CDS View that provides data about "External Reference" in SAP S/4HANA. It reads from 4 data sources (I_InsurPlcyExtReferenceBasic, I_InsurPlcyExtReferenceBasic, P_InsurPlcyExtRefLoadJrnlAppl, P_InsurPlcyExtRefLoadJrnlAppl) and exposes 40 fields with key fields InsurPlcyUUID, InsurPlcyOrderNumber, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID.

Data Sources (4)

SourceAliasJoin Type
I_InsurPlcyExtReferenceBasic ExternalReference from
I_InsurPlcyExtReferenceBasic ExternalReference union
P_InsurPlcyExtRefLoadJrnlAppl ExtRefLoadJrnlAppl inner
P_InsurPlcyExtRefLoadJrnlAppl ExtRefLoadJrnlAppl inner

Annotations (7)

NameValueLevelField
EndUserText.label External Reference view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID
KEY InsurPlcyOrderNumber P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyOrderNumber Sequence Number
KEY InsurPlcyInsurContr P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyInsuredObjectID P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyInsuredObjectID Ins. Obj. No.
KEY InsurPlcyExternalReferenceID P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyExternalReferenceID Ext. Ref. ID
InsurPlcyApplUUID
InsurPlcyBusProcType P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlNmbr I_InsurPlcyExtReferenceBasic InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyExtReferenceBasic InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurPlcyExtReferenceBasic InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyExtRefIsCancelled I_InsurPlcyExtReferenceBasic InsurPlcyExtRefIsCancelled Rev. Flag
InsurPlcyExtRefCompany I_InsurPlcyExtReferenceBasic InsurPlcyExtRefCompany Ref. Comp.
InsurPlcyExtRefReferenceNumber I_InsurPlcyExtReferenceBasic InsurPlcyExtRefReferenceNumber Ref. No.
InsurPlcyExtRefReferenceType I_InsurPlcyExtReferenceBasic InsurPlcyExtRefReferenceType Reference Type
InsurPlcyExtRefTemplate I_InsurPlcyExtReferenceBasic InsurPlcyExtRefTemplate Template ID
InsurPlcyBusinessObject I_InsurPlcyExtReferenceBasic InsurPlcyBusinessObject Process.Status
KEY InsurPlcyOrderNumber P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyOrderNumber Sequence Number
KEY InsurPlcyInsurContr P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyInsuredObjectID P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyInsuredObjectID Ins. Obj. No.
KEY InsurPlcyExternalReferenceID P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyExternalReferenceID Ext. Ref. ID
InsurPlcyApplUUID
InsurPlcyBusProcType P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator P_InsurPlcyExtRefLoadJrnlAppl InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlNmbr I_InsurPlcyExtReferenceBasic InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyExtReferenceBasic InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurPlcyExtReferenceBasic InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyExtRefIsCancelled I_InsurPlcyExtReferenceBasic InsurPlcyExtRefIsCancelled Rev. Flag
InsurPlcyExtRefCompany I_InsurPlcyExtReferenceBasic InsurPlcyExtRefCompany Ref. Comp.
InsurPlcyExtRefReferenceNumber I_InsurPlcyExtReferenceBasic InsurPlcyExtRefReferenceNumber Ref. No.
InsurPlcyExtRefReferenceType I_InsurPlcyExtReferenceBasic InsurPlcyExtRefReferenceType Reference Type
InsurPlcyExtRefTemplate I_InsurPlcyExtReferenceBasic InsurPlcyExtRefTemplate Template ID
InsurPlcyBusinessObject I_InsurPlcyExtReferenceBasic InsurPlcyBusinessObject Process.Status
LastChangeDateTime I_InsurPlcyExtReferenceBasic LastChangeDateTime Timestamp

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_InsurPlcyExtReferenceVersion.
-- 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_InsurPlcyExtReferenceVersion AS
SELECT
  cast( ExtRefLoadJrnlAppl.InsurPlcyUUID as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
  ExtRefLoadJrnlAppl.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  ExtRefLoadJrnlAppl.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  ExtRefLoadJrnlAppl.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  ExtRefLoadJrnlAppl.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  ExtRefLoadJrnlAppl.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  ExtRefLoadJrnlAppl.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  ExtRefLoadJrnlAppl.InsurPlcyExternalReferenceID AS InsurPlcyExternalReferenceID,
  cast( ExtRefLoadJrnlAppl.InsurPlcyApplUUID as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyApplUUID,
  ExtRefLoadJrnlAppl.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  ExtRefLoadJrnlAppl.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  ExternalReference.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  ExternalReference.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  ExternalReference.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  ExternalReference.InsurPlcyExtRefIsCancelled AS InsurPlcyExtRefIsCancelled,
  ExternalReference.InsurPlcyExtRefCompany AS InsurPlcyExtRefCompany,
  ExternalReference.InsurPlcyExtRefReferenceNumber AS InsurPlcyExtRefReferenceNumber,
  ExternalReference.InsurPlcyExtRefReferenceType AS InsurPlcyExtRefReferenceType,
  ExternalReference.InsurPlcyExtRefTemplate AS InsurPlcyExtRefTemplate,
  ExternalReference.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  ExternalReference.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPlcyExtReferenceBasic AS ExternalReference
INNER JOIN P_InsurPlcyExtRefLoadJrnlAppl AS ExtRefLoadJrnlAppl ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_InsurPlcyExtReferenceBasic
;

Learn More