I_InsurPlcyInsrblVehIntlType

DDL: I_INSURPLCYINSRBLVEHINTLTYPE Type: view_entity BASIC
6 Fields 1 Data Sources 2 Associations

International Type of Insrbl Vehicle

I_InsurPlcyInsrblVehIntlType is a Basic CDS View (Dimension) that provides data about "International Type of Insrbl Vehicle" in SAP S/4HANA. It reads from 1 data source (iclpropty) and exposes 6 fields with key fields InsurPlcyInsrblVehIntlMfrID, InsurPlcyInsrblVehIntlModelID, InsurPlcyInsrblVehIntlTypeID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
iclpropty iclpropty from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_InsurPlcyVehIntlTypeList _InsurPlcyVehIntlTypeList $projection.InsurPlcyInsrblVehIntlMfrID = _InsurPlcyVehIntlTypeList.InsurPlcyInsrblVehIntlMfrID
[0..1] I_InsurPlcyVehIntlModelList _InsurPlcyVehIntlModelList $projection.InsurPlcyInsrblVehIntlModelID = _InsurPlcyVehIntlModelList.InsurPlcyInsrblVehIntlModelID and $projection.InsurPlcyInsrblVehIntlMfrID = _InsurPlcyVehIntlModelList.InsurPlcyInsrblVehIntlMfrID

Annotations (16)

NameValueLevelField
EndUserText.label International Type of Insrbl Vehicle view
ObjectModel.representativeKey InsurPlcyInsrblVehIntlTypeID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.resultSet.sizeCategory #XS view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.technicalName InsVehIntlType view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyInsrblVehIntlMfrID iclpropty propmake Make
KEY InsurPlcyInsrblVehIntlModelID iclpropty propmodel Model
KEY InsurPlcyInsrblVehIntlTypeID iclpropty modelty Category
InsurPlcyInsrblVehIntlTypeName iclpropty modeltyn Type Name
_InsurPlcyVehIntlTypeList _InsurPlcyVehIntlTypeList
_InsurPlcyVehIntlModelList _InsurPlcyVehIntlModelList

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_InsurPlcyInsrblVehIntlType.
-- 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_InsurPlcyInsrblVehIntlType AS
SELECT
  iclpropty.propmake AS InsurPlcyInsrblVehIntlMfrID,
  iclpropty.propmodel AS InsurPlcyInsrblVehIntlModelID,
  iclpropty.modelty AS InsurPlcyInsrblVehIntlTypeID,
  iclpropty.modeltyn AS InsurPlcyInsrblVehIntlTypeName
FROM iclpropty
LEFT OUTER JOIN I_InsurPlcyVehIntlTypeList AS _InsurPlcyVehIntlTypeList ON InsurPlcyInsrblVehIntlMfrID = _InsurPlcyVehIntlTypeList.InsurPlcyInsrblVehIntlMfrID  -- association [0..1]
LEFT OUTER JOIN I_InsurPlcyVehIntlModelList AS _InsurPlcyVehIntlModelList ON InsurPlcyInsrblVehIntlModelID = _InsurPlcyVehIntlModelList.InsurPlcyInsrblVehIntlModelID AND InsurPlcyInsrblVehIntlMfrID = _InsurPlcyVehIntlModelList.InsurPlcyInsrblVehIntlMfrID  -- association [0..1]
;

Learn More