R_InsurPlcyContrBndlTP_2

DDL: R_INSURPLCYCONTRBNDLTP_2 Type: view_entity TRANSACTIONAL
13 Fields 2 Data Sources 2 Associations

Contract Bundle - TP

R_InsurPlcyContrBndlTP_2 is a Transactional CDS View that provides data about "Contract Bundle - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyContrBundleVersion, I_InsurPlcyHghstVersPerAppl) and exposes 13 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyProductPackageID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyContrBundleVersion ContrBundle 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_InsurPolicyContractBundle _Extension ( $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID or $projection.InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyProductPackageID = _Extension.InsurPlcyProductPackageID

Annotations (12)

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

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyContrBundleVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyContrBundleVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyProductPackageID I_InsurPlcyContrBundleVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyOrderNumber I_InsurPlcyContrBundleVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyContrBundleVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyContrBundleVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlNmbr I_InsurPlcyContrBundleVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyContrBundleVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyContrBndlIsCancld I_InsurPlcyContrBundleVersion InsurPlcyContrBndlIsCancld Rev. Flag
InsurPlcyContrBndlProdPckg I_InsurPlcyContrBundleVersion InsurPlcyContrBndlProdPckg Prod.Engine ID
InsurPlcyBusinessObject I_InsurPlcyContrBundleVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyContrBundleVersion 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_InsurPlcyContrBndlTP_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_InsurPlcyContrBndlTP_2 AS
SELECT
  ContrBundle.InsurPlcyUUID AS InsurPlcyUUID,
  ContrBundle.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  ContrBundle.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  ContrBundle.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  ContrBundle.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  ContrBundle.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  ContrBundle.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  ContrBundle.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  ContrBundle.InsurPlcyContrBndlIsCancld AS InsurPlcyContrBndlIsCancld,
  ContrBundle.InsurPlcyContrBndlProdPckg AS InsurPlcyContrBndlProdPckg,
  ContrBundle.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  ContrBundle.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPlcyContrBundleVersion AS ContrBundle
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_InsurPolicyContractBundle AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyProductPackageID = _Extension.InsurPlcyProductPackageID  -- association [1..1]
;

Learn More