R_InsurPlcyGuaranteeValueTP

DDL: R_INSURPLCYGUARANTEEVALUETP Type: view_entity TRANSACTIONAL
23 Fields 2 Data Sources 2 Associations

Guarantee Value - TP

R_InsurPlcyGuaranteeValueTP is a Transactional CDS View that provides data about "Guarantee Value - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyGuarValueVersion, I_InsurPlcyHghstVersPerAppl) and exposes 23 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyGuarValueVersion GuaranteeValue 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_InsurPolicyGuaranteeValue _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.InsurPlcyGuarValsID = _Extension.InsurPlcyGuarValsID

Annotations (13)

NameValueLevelField
EndUserText.label Guarantee Value - 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 #XXL view
ObjectModel.sapObjectNodeType.name InsurancePolicy view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix GVS view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.allowNewCompositions false view
Metadata.ignorePropagatedAnnotations true view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyGuarValueVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyGuarValueVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyGuarValueVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyGuarValueVersion InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyGuarValueVersion InsurPlcyCoverageID Coverage Key
KEY InsurPlcyGuarValsID I_InsurPlcyGuarValueVersion InsurPlcyGuarValsID Key Guar. Vals
InsurPlcyOrderNumber I_InsurPlcyGuarValueVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyGuarValueVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyGuarValueVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurPlcyGuarValueVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPlcyGuarValueVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPlcyGuarValueVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyGuarValsIsCanceled I_InsurPlcyGuarValueVersion InsurPlcyGuarValsIsCanceled Rev. Flag
InsurPlcyGuarValsProdMgrID I_InsurPlcyGuarValueVersion InsurPlcyGuarValsProdMgrID PM ID GuarVals
InsurPlcyGuarValsAnnuExmptAmt I_InsurPlcyGuarValueVersion InsurPlcyGuarValsAnnuExmptAmt PremExemptAnnui
InsurPlcyGuarValsExmptTotAmt I_InsurPlcyGuarValueVersion InsurPlcyGuarValsExmptTotAmt Prem-ExmptTotal
InsurPlcyGuarValsSrrndrAmt I_InsurPlcyGuarValueVersion InsurPlcyGuarValsSrrndrAmt Surrender Value
InsurPlcyGuarValsValdDte I_InsurPlcyGuarValueVersion InsurPlcyGuarValsValdDte Valid
InsurPlcyGuarValsCurrency I_InsurPlcyGuarValueVersion InsurPlcyGuarValsCurrency Currency
InsurPlcyBusinessObject I_InsurPlcyGuarValueVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyGuarValueVersion LastChangeDateTime Timestamp
_Currency I_InsurPlcyGuarValueVersion _Currency
_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_InsurPlcyGuaranteeValueTP.
-- 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_InsurPlcyGuaranteeValueTP AS
SELECT
  GuaranteeValue.InsurPlcyUUID AS InsurPlcyUUID,
  GuaranteeValue.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  GuaranteeValue.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  GuaranteeValue.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  GuaranteeValue.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  GuaranteeValue.InsurPlcyGuarValsID AS InsurPlcyGuarValsID,
  GuaranteeValue.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  GuaranteeValue.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  GuaranteeValue.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  GuaranteeValue.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  GuaranteeValue.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  GuaranteeValue.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  GuaranteeValue.InsurPlcyGuarValsIsCanceled AS InsurPlcyGuarValsIsCanceled,
  GuaranteeValue.InsurPlcyGuarValsProdMgrID AS InsurPlcyGuarValsProdMgrID,
  GuaranteeValue.InsurPlcyGuarValsAnnuExmptAmt AS InsurPlcyGuarValsAnnuExmptAmt,
  GuaranteeValue.InsurPlcyGuarValsExmptTotAmt AS InsurPlcyGuarValsExmptTotAmt,
  GuaranteeValue.InsurPlcyGuarValsSrrndrAmt AS InsurPlcyGuarValsSrrndrAmt,
  GuaranteeValue.InsurPlcyGuarValsValdDte AS InsurPlcyGuarValsValdDte,
  GuaranteeValue.InsurPlcyGuarValsCurrency AS InsurPlcyGuarValsCurrency,
  GuaranteeValue.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  GuaranteeValue.LastChangeDateTime AS LastChangeDateTime,
  GuaranteeValue._Currency AS _Currency
FROM I_InsurPlcyGuarValueVersion AS GuaranteeValue
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_InsurPolicyGuaranteeValue 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 InsurPlcyGuarValsID = _Extension.InsurPlcyGuarValsID  -- association [1..1]
;

Learn More