I_CollateralObjectInsurance

DDL: I_COLLATERALOBJECTINSURANCE Type: view_entity BASIC
76 Fields 2 Data Sources 4 Associations

Collateral Object Insurance Details

I_CollateralObjectInsurance (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_CollateralObjectInsurance is a Basic CDS View (Dimension) that provides data about "Collateral Object Insurance Details" in SAP S/4HANA. It reads from 2 data sources (I_CollateralInsurance, I_CollateralInsuranceLinkData) and exposes 76 fields with key field CollateralInsuranceUUID. It has 4 associations to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentFS-CMS
CapabilitiesAssociation Target for Defining CDS Entities, Analytical Dimension, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
I_CollateralInsurance ColIns inner
I_CollateralInsuranceLinkData ColObjInsLnk from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_CollateralRealEstate _CollateralRealEstate $projection.CollateralObjectReferenceUUID = _CollateralRealEstate.CollateralRealEstateUUID
[0..*] I_CollateralAssetPartner _ColltrlInsurancePartner $projection.CollateralInsuranceUUID = _ColltrlInsurancePartner.CollateralAssetUUID
[0..*] I_CollateralAssetDocument _ColltrlInsuranceDocument $projection.CollateralInsuranceUUID = _ColltrlInsuranceDocument.CollateralAssetUUID
[0..1] I_CollateralReferenceSystem _CollateralReferenceSystem $projection.CollateralReferenceSystem = _CollateralReferenceSystem.CollateralReferenceSystem

Annotations (15)

NameValueLevelField
EndUserText.label Collateral Object Insurance Details view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey CollateralInsuranceUUID view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view

Fields (76)

KeyFieldSource TableSource FieldDescription
KEY CollateralInsuranceUUID I_CollateralInsurance CollateralInsuranceUUID Insurance GUID
CollateralObjectCategory I_CollateralInsurance CollateralObjectCategory Object Category
CollateralInsuranceType I_CollateralInsurance CollateralInsuranceType Insurance Type
CollateralInsuranceDescription I_CollateralInsurance CollateralInsuranceDescription Insurance Description
ColltrlInsuranceBankTaxDebit I_CollateralInsurance ColltrlInsuranceBankTaxDebit Insurance tax to the debit of the bank
ColltrlInsuranceSettlementType I_CollateralInsurance ColltrlInsuranceSettlementType Type of settlement
CollateralInsuranceSumAmount I_CollateralInsurance CollateralInsuranceSumAmount Insurance Sum
CollateralInsuranceSumCurrency I_CollateralInsurance CollateralInsuranceSumCurrency Insurance Currency
CollateralInsurancePremiumRate I_CollateralInsurance CollateralInsurancePremiumRate Premium Rate
ColltrlInsurancePremiumAmount I_CollateralInsurance ColltrlInsurancePremiumAmount Insurance Premium
ColltrlInsurPremiumCurrency I_CollateralInsurance ColltrlInsurPremiumCurrency Insurance Currency
CollateralInsuranceTaxRate I_CollateralInsurance CollateralInsuranceTaxRate Insurance tax rate (in %)
CollateralInsuranceTaxAmount I_CollateralInsurance CollateralInsuranceTaxAmount Insurance tax amount
CollateralInsuranceTaxCurrency I_CollateralInsurance CollateralInsuranceTaxCurrency Tax Currency
CollateralExternalItemNumber I_CollateralInsurance CollateralExternalItemNumber Ext. Item no / Number for identification of the objects
ColltrlExternalReferenceNumber I_CollateralInsurance ColltrlExternalReferenceNumber Reference number for the legacy system
CollateralInsuranceCompanyName I_CollateralInsurance CollateralInsuranceCompanyName Insurance Company
ColltrlInsurPaymentFrequency I_CollateralInsurance ColltrlInsurPaymentFrequency Frequency of Payment
ColltrlInsuranceFrequencyUnit I_CollateralInsurance ColltrlInsuranceFrequencyUnit Indicator: Units of time for revaluation
CollateralInsuranceStartDate I_CollateralInsurance CollateralInsuranceStartDate Start date of insurance
CollateralInsuranceExpiryDate I_CollateralInsurance CollateralInsuranceExpiryDate Date of expiry of insurance
ColltrlInsurRqdCoverAmount I_CollateralInsurance ColltrlInsurRqdCoverAmount Required insurance cover
ColltrlInsurRqdCoverCurrency I_CollateralInsurance ColltrlInsurRqdCoverCurrency Insurance Currency
CollateralInsuranceInsurerName I_CollateralInsurance CollateralInsuranceInsurerName Name of the insurer
ColltrlInsurInsurerDescription I_CollateralInsurance ColltrlInsurInsurerDescription Remarks on insurer
CollateralInsuranceCoverMarket I_CollateralInsurance CollateralInsuranceCoverMarket Cover Market
ColltrlInsurCovrMktShareAmount I_CollateralInsurance ColltrlInsurCovrMktShareAmount Share of cover market
ColltrlInsurCovrMktShrCurrency I_CollateralInsurance ColltrlInsurCovrMktShrCurrency Currency for Share of Cover Market
ColltrlInsurContactFirmName I_CollateralInsurance ColltrlInsurContactFirmName Contact Firm
ColltrlInsurContactPartnerName I_CollateralInsurance ColltrlInsurContactPartnerName Contact partner
ColltrlInsurTariffDescription I_CollateralInsurance ColltrlInsurTariffDescription Insurance tariff
ColltrlInsurContractBeginDate I_CollateralInsurance ColltrlInsurContractBeginDate Contract begin date
ColltrlInsurContractEndDate I_CollateralInsurance ColltrlInsurContractEndDate Contract end date
ColltrlInsurContrCnclsnDate I_CollateralInsurance ColltrlInsurContrCnclsnDate Date of conclusion of contract
CollateralInsuranceStatus I_CollateralInsurance CollateralInsuranceStatus Status of insurance
CollateralInsuranceStatusDate I_CollateralInsurance CollateralInsuranceStatusDate Status date of insurance
ColltrlInsurOneTmeContrbnAmt I_CollateralInsurance ColltrlInsurOneTmeContrbnAmt Sum of one time contribution
ColltrlInsurOneTmeContrbnCrcy I_CollateralInsurance ColltrlInsurOneTmeContrbnCrcy Currency
ColltrlInsurHasDynamicAdaption I_CollateralInsurance ColltrlInsurHasDynamicAdaption Dynamics
ColltrlInsurDynamicsPercent I_CollateralInsurance ColltrlInsurDynamicsPercent Percentage of the dynamics
ColltrlInsurTerminationPeriod I_CollateralInsurance ColltrlInsurTerminationPeriod Termination period
ColltrlInsurTermnPeriodUnit I_CollateralInsurance ColltrlInsurTermnPeriodUnit Indicator: Units of termination period
ColltrlInsuranceRecallPeriod I_CollateralInsurance ColltrlInsuranceRecallPeriod Recall period
ColltrlInsurRecallPeriodUnit I_CollateralInsurance ColltrlInsurRecallPeriodUnit Indicator: Units of Recall Period
ColltrlInsurSurvlBenefitAmount I_CollateralInsurance ColltrlInsurSurvlBenefitAmount Insurance sum incase of survival
ColltrlInsurSurvlBnftCurrency I_CollateralInsurance ColltrlInsurSurvlBnftCurrency Insurance survival Currency
ColltrlInsurDeathBenefitAmount I_CollateralInsurance ColltrlInsurDeathBenefitAmount Insurance sum in case of death
ColltrlInsurDthBenefitCurrency I_CollateralInsurance ColltrlInsurDthBenefitCurrency Death benefit currency
ColltrlInsurExpryBenefitAmount I_CollateralInsurance ColltrlInsurExpryBenefitAmount Probable benefit on expiry
ColltrlInsurExpryBnftCurrency I_CollateralInsurance ColltrlInsurExpryBnftCurrency Currency for probable benefit on expiry
ColltrlInsurExpiryBenefitDate I_CollateralInsurance ColltrlInsurExpiryBenefitDate Date of probable benefit on expiry
CollateralAdminOrgUnit I_CollateralInsurance CollateralAdminOrgUnit Administration Organizational Unit
CollateralBankArea I_CollateralInsurance CollateralBankArea Bank Area in Collateral Management
CollateralInsuranceEnteredBy I_CollateralInsurance CollateralInsuranceEnteredBy Login ID of the User who created the Record
ColltrlInsurEnteredDateTime I_CollateralInsurance ColltrlInsurEnteredDateTime Creation Timestamp
ColltrlInsuranceLastChangedBy I_CollateralInsurance ColltrlInsuranceLastChangedBy Last Changed By
ColltrlInsurLastChgdDateTime I_CollateralInsurance ColltrlInsurLastChgdDateTime Change Timestamp
ColltrlInsuranceEnteredSource I_CollateralInsurance ColltrlInsuranceEnteredSource Source Of Entry
CollateralBusinessProcessUUID I_CollateralInsurance CollateralBusinessProcessUUID Business Process ID
ColltrlBusinessProcessTypeCode I_CollateralInsurance ColltrlBusinessProcessTypeCode Business Process Type Code
CollateralInsuranceLinkUUID I_CollateralInsuranceLinkData CollateralInsuranceLinkUUID Insurance Link GUID
CollateralObjectReferenceUUID I_CollateralInsuranceLinkData CollateralObjectReferenceUUID Object reference GUID
ColltrlInsurObjLinkingSystem I_CollateralInsuranceLinkData ColltrlInsurObjLinkingSystem Object system Linking to Insurance
CollateralInsuranceLinkID I_CollateralInsuranceLinkData CollateralInsuranceLinkID Serial Number
CollateralReferenceSystem I_CollateralInsuranceLinkData CollateralReferenceSystem Object System Reference ID
ColltrlInsurLinkValidFromDate I_CollateralInsuranceLinkData ColltrlInsurLinkValidFromDate Link Valid From Date
ColltrlInsurLinkValidToDate I_CollateralInsuranceLinkData ColltrlInsurLinkValidToDate Link Valid To Date
ColltrlInsuranceLinkEnteredBy I_CollateralInsuranceLinkData ColltrlInsuranceLinkEnteredBy Login ID of the User who created the Record
ColltrlInsurLnkEnteredDateTime I_CollateralInsuranceLinkData ColltrlInsurLnkEnteredDateTime Creation Timestamp
ColltrlInsurLinkLastChangedBy I_CollateralInsuranceLinkData ColltrlInsurLinkLastChangedBy Last Changed By
ColltrlInsurLnkLastChgdDteTime I_CollateralInsuranceLinkData ColltrlInsurLnkLastChgdDteTime Change Timestamp
ColltrlInsurLinkEnteredSource I_CollateralInsuranceLinkData ColltrlInsurLinkEnteredSource Source Of Entry
_CollateralRealEstate _CollateralRealEstate
_ColltrlInsurancePartner _ColltrlInsurancePartner
_ColltrlInsuranceDocument _ColltrlInsuranceDocument
_CollateralReferenceSystem _CollateralReferenceSystem

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_CollateralObjectInsurance.
-- 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_CollateralObjectInsurance AS
SELECT
  ColIns.CollateralInsuranceUUID AS CollateralInsuranceUUID,
  ColIns.CollateralObjectCategory AS CollateralObjectCategory,
  ColIns.CollateralInsuranceType AS CollateralInsuranceType,
  ColIns.CollateralInsuranceDescription AS CollateralInsuranceDescription,
  ColIns.ColltrlInsuranceBankTaxDebit AS ColltrlInsuranceBankTaxDebit,
  ColIns.ColltrlInsuranceSettlementType AS ColltrlInsuranceSettlementType,
  ColIns.CollateralInsuranceSumAmount AS CollateralInsuranceSumAmount,
  ColIns.CollateralInsuranceSumCurrency AS CollateralInsuranceSumCurrency,
  ColIns.CollateralInsurancePremiumRate AS CollateralInsurancePremiumRate,
  ColIns.ColltrlInsurancePremiumAmount AS ColltrlInsurancePremiumAmount,
  ColIns.ColltrlInsurPremiumCurrency AS ColltrlInsurPremiumCurrency,
  ColIns.CollateralInsuranceTaxRate AS CollateralInsuranceTaxRate,
  ColIns.CollateralInsuranceTaxAmount AS CollateralInsuranceTaxAmount,
  ColIns.CollateralInsuranceTaxCurrency AS CollateralInsuranceTaxCurrency,
  ColIns.CollateralExternalItemNumber AS CollateralExternalItemNumber,
  ColIns.ColltrlExternalReferenceNumber AS ColltrlExternalReferenceNumber,
  ColIns.CollateralInsuranceCompanyName AS CollateralInsuranceCompanyName,
  ColIns.ColltrlInsurPaymentFrequency AS ColltrlInsurPaymentFrequency,
  ColIns.ColltrlInsuranceFrequencyUnit AS ColltrlInsuranceFrequencyUnit,
  ColIns.CollateralInsuranceStartDate AS CollateralInsuranceStartDate,
  ColIns.CollateralInsuranceExpiryDate AS CollateralInsuranceExpiryDate,
  ColIns.ColltrlInsurRqdCoverAmount AS ColltrlInsurRqdCoverAmount,
  ColIns.ColltrlInsurRqdCoverCurrency AS ColltrlInsurRqdCoverCurrency,
  ColIns.CollateralInsuranceInsurerName AS CollateralInsuranceInsurerName,
  ColIns.ColltrlInsurInsurerDescription AS ColltrlInsurInsurerDescription,
  ColIns.CollateralInsuranceCoverMarket AS CollateralInsuranceCoverMarket,
  ColIns.ColltrlInsurCovrMktShareAmount AS ColltrlInsurCovrMktShareAmount,
  ColIns.ColltrlInsurCovrMktShrCurrency AS ColltrlInsurCovrMktShrCurrency,
  ColIns.ColltrlInsurContactFirmName AS ColltrlInsurContactFirmName,
  ColIns.ColltrlInsurContactPartnerName AS ColltrlInsurContactPartnerName,
  ColIns.ColltrlInsurTariffDescription AS ColltrlInsurTariffDescription,
  ColIns.ColltrlInsurContractBeginDate AS ColltrlInsurContractBeginDate,
  ColIns.ColltrlInsurContractEndDate AS ColltrlInsurContractEndDate,
  ColIns.ColltrlInsurContrCnclsnDate AS ColltrlInsurContrCnclsnDate,
  ColIns.CollateralInsuranceStatus AS CollateralInsuranceStatus,
  ColIns.CollateralInsuranceStatusDate AS CollateralInsuranceStatusDate,
  ColIns.ColltrlInsurOneTmeContrbnAmt AS ColltrlInsurOneTmeContrbnAmt,
  ColIns.ColltrlInsurOneTmeContrbnCrcy AS ColltrlInsurOneTmeContrbnCrcy,
  ColIns.ColltrlInsurHasDynamicAdaption AS ColltrlInsurHasDynamicAdaption,
  ColIns.ColltrlInsurDynamicsPercent AS ColltrlInsurDynamicsPercent,
  ColIns.ColltrlInsurTerminationPeriod AS ColltrlInsurTerminationPeriod,
  ColIns.ColltrlInsurTermnPeriodUnit AS ColltrlInsurTermnPeriodUnit,
  ColIns.ColltrlInsuranceRecallPeriod AS ColltrlInsuranceRecallPeriod,
  ColIns.ColltrlInsurRecallPeriodUnit AS ColltrlInsurRecallPeriodUnit,
  ColIns.ColltrlInsurSurvlBenefitAmount AS ColltrlInsurSurvlBenefitAmount,
  ColIns.ColltrlInsurSurvlBnftCurrency AS ColltrlInsurSurvlBnftCurrency,
  ColIns.ColltrlInsurDeathBenefitAmount AS ColltrlInsurDeathBenefitAmount,
  ColIns.ColltrlInsurDthBenefitCurrency AS ColltrlInsurDthBenefitCurrency,
  ColIns.ColltrlInsurExpryBenefitAmount AS ColltrlInsurExpryBenefitAmount,
  ColIns.ColltrlInsurExpryBnftCurrency AS ColltrlInsurExpryBnftCurrency,
  ColIns.ColltrlInsurExpiryBenefitDate AS ColltrlInsurExpiryBenefitDate,
  ColIns.CollateralAdminOrgUnit AS CollateralAdminOrgUnit,
  ColIns.CollateralBankArea AS CollateralBankArea,
  ColIns.CollateralInsuranceEnteredBy AS CollateralInsuranceEnteredBy,
  ColIns.ColltrlInsurEnteredDateTime AS ColltrlInsurEnteredDateTime,
  ColIns.ColltrlInsuranceLastChangedBy AS ColltrlInsuranceLastChangedBy,
  ColIns.ColltrlInsurLastChgdDateTime AS ColltrlInsurLastChgdDateTime,
  ColIns.ColltrlInsuranceEnteredSource AS ColltrlInsuranceEnteredSource,
  ColIns.CollateralBusinessProcessUUID AS CollateralBusinessProcessUUID,
  ColIns.ColltrlBusinessProcessTypeCode AS ColltrlBusinessProcessTypeCode,
  ColObjInsLnk.CollateralInsuranceLinkUUID AS CollateralInsuranceLinkUUID,
  ColObjInsLnk.CollateralObjectReferenceUUID AS CollateralObjectReferenceUUID,
  ColObjInsLnk.ColltrlInsurObjLinkingSystem AS ColltrlInsurObjLinkingSystem,
  ColObjInsLnk.CollateralInsuranceLinkID AS CollateralInsuranceLinkID,
  ColObjInsLnk.CollateralReferenceSystem AS CollateralReferenceSystem,
  ColObjInsLnk.ColltrlInsurLinkValidFromDate AS ColltrlInsurLinkValidFromDate,
  ColObjInsLnk.ColltrlInsurLinkValidToDate AS ColltrlInsurLinkValidToDate,
  ColObjInsLnk.ColltrlInsuranceLinkEnteredBy AS ColltrlInsuranceLinkEnteredBy,
  ColObjInsLnk.ColltrlInsurLnkEnteredDateTime AS ColltrlInsurLnkEnteredDateTime,
  ColObjInsLnk.ColltrlInsurLinkLastChangedBy AS ColltrlInsurLinkLastChangedBy,
  ColObjInsLnk.ColltrlInsurLnkLastChgdDteTime AS ColltrlInsurLnkLastChgdDteTime,
  ColObjInsLnk.ColltrlInsurLinkEnteredSource AS ColltrlInsurLinkEnteredSource
FROM I_CollateralInsuranceLinkData AS ColObjInsLnk
INNER JOIN I_CollateralInsurance AS ColIns ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CollateralRealEstate AS _CollateralRealEstate ON CollateralObjectReferenceUUID = _CollateralRealEstate.CollateralRealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralAssetPartner AS _ColltrlInsurancePartner ON CollateralInsuranceUUID = _ColltrlInsurancePartner.CollateralAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAssetDocument AS _ColltrlInsuranceDocument ON CollateralInsuranceUUID = _ColltrlInsuranceDocument.CollateralAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralReferenceSystem AS _CollateralReferenceSystem ON CollateralReferenceSystem = _CollateralReferenceSystem.CollateralReferenceSystem  -- association [0..1]
;

Learn More