I_InsuranceObjectType

DDL: I_INSURANCEOBJECTTYPE Type: view BASIC Package: CMS_VDM

Insurance Type

I_InsuranceObjectType (Basic)

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

Cross Applications

I_InsuranceObjectType is a Basic CDS View (Dimension) that provides data about "Insurance Type" in SAP S/4HANA. It reads from 1 data source (tcms_ins_typ) and exposes 5 fields with key fields InsuranceObjectCategory, InsuranceObjectType. It has 2 associations to related views. Part of development package CMS_VDM.

SAP Help Documentation

CategoryCollateral Object
Data CategoryDimension
StatusDeprecated
Data Extraction TypeFull extraction
Corresponding DataSourceIINSOBJTYPE
Purpose
This CDS view provides the prerequisites to answer the following business question: What is the insurance type?

Prerequisites
Not applicable.

Structure
Measures and attributes Some important measures and attributes are: InsuranceObjectCategory InsuranceObjectType

SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. For details about the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content .

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateDeprecated
Line of BusinessCross Applications
Application ComponentFS-CMS
CapabilitiesData Source for Data Extraction,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Analytical Dimension,Data Source in SQL Select
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
tcms_ins_typ tcms_ins_typ from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CollateralObjectCategory _InsuranceObjectCategory $projection.InsuranceObjectCategory = _InsuranceObjectCategory.CollateralObjectCategory
[0..*] I_InsuranceObjectTypeText _Text $projection.InsuranceObjectCategory = _Text.InsuranceObjectCategory and $projection.InsuranceObjectType = _Text.InsuranceObjectType

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IINSOBJTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality A view
ObjectModel.usageType.sizeCategory S view
ObjectModel.usageType.dataClass CUSTOMIZING view
ObjectModel.representativeKey InsuranceObjectType view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Insurance Type view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY InsuranceObjectCategory ins_category Object Category
KEY InsuranceObjectType ins_typ Insurance Type
CollateralProcessControlKey proc_cky Process Control Key
_InsuranceObjectCategory _InsuranceObjectCategory
_Text _Text

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_InsuranceObjectType.
-- 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_InsuranceObjectType AS
SELECT
  ins_category AS InsuranceObjectCategory,
  ins_typ AS InsuranceObjectType,
  proc_cky AS CollateralProcessControlKey
FROM tcms_ins_typ
LEFT OUTER JOIN I_CollateralObjectCategory AS _InsuranceObjectCategory ON InsuranceObjectCategory = _InsuranceObjectCategory.CollateralObjectCategory  -- association [0..1]
LEFT OUTER JOIN I_InsuranceObjectTypeText AS _Text ON InsuranceObjectCategory = _Text.InsuranceObjectCategory AND InsuranceObjectType = _Text.InsuranceObjectType  -- association [0..*]
;