I_InsurPlcyInsuredObjectTP

DDL: I_INSURPLCYINSUREDOBJECTTP Type: view_entity TRANSACTIONAL
109 Fields 1 Data Sources

Insured Object - TP

I_InsurPlcyInsuredObjectTP is a Transactional CDS View that provides data about "Insured Object - TP" in SAP S/4HANA. It reads from 1 data source (R_InsurPolicyInsuredObjectTP_2) and exposes 109 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID.

Data Sources (1)

SourceAliasJoin Type
R_InsurPolicyInsuredObjectTP_2 R_InsurPolicyInsuredObjectTP_2 projection

Annotations (14)

NameValueLevelField
EndUserText.label Insured Object - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name InsurancePolicyInsuredObject view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix IOB view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.allowNewCompositions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view

Fields (109)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyInsuredObjectID InsurPlcyInsuredObjectID Ins. Obj. No.
InsurPlcyUUIDForEdit InsurPlcyUUIDForEdit Policy UUID
InsurPlcyApplUUIDForEdit InsurPlcyApplUUIDForEdit Policy UUID
InsurPlcyInsurContrForEdit InsurPlcyInsurContrForEdit Contract Key
InsurPlcyCvPcgIDForEdit InsurPlcyCvPcgIDForEdit Cov.Package ID
InsurPlcyCoverageIDForEdit InsurPlcyCoverageIDForEdit Coverage Key
InsurPlcyCvrgOptnIDForEdit InsurPlcyCvrgOptnIDForEdit Cov. Option Key
InsurPlcyInsrdObjIDForEdit InsurPlcyInsrdObjIDForEdit Ins. Obj. No.
InsurPlcyUndrwrtgDcsnRiskID InsurPlcyUndrwrtgDcsnRiskID UndWritDecision
InsurPlcySubCvrgID InsurPlcySubCvrgID Subcoverage Key
InsurPlcyOrderNumber InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyInsrdObjectTemplate InsurPlcyInsrdObjectTemplate Object Module
InsurPlcyInsuredObjectCategory InsurPlcyInsuredObjectCategory Object Category
InsurPlcyInsrdObjSubCategory InsurPlcyInsrdObjSubCategory Object Type
InsurPlcyInsrdObjUnqID InsurPlcyInsrdObjUnqID Insurable Obj.
InsurInsrblObjJrnlNmbr InsurInsrblObjJrnlNmbr INSBO JournStat
InsurPlcyInsrdObjIsCancelled InsurPlcyInsrdObjIsCancelled Rev. Flag
InsurPlcyInsuredPersonID InsurPlcyInsuredPersonID BusPartner
InsurPlcyInsrdObjEffctvDte InsurPlcyInsrdObjEffctvDte Effective Date
InsurPlcyInsrdObjAwardReason InsurPlcyInsrdObjAwardReason Assign. Reason
InsurPlcyInsrdObjIsUpdateNeed InsurPlcyInsrdObjIsUpdateNeed Oblig. Update
InsurPlcyInsrdObjTypeChannel InsurPlcyInsrdObjTypeChannel ObjTypeChStruc.
InsurPlcyInsrdObjCatChannel InsurPlcyInsrdObjCatChannel Obj. Cat. ChStr
InsurPlcyInsrdObjSuperChannel InsurPlcyInsrdObjSuperChannel ObjSuperChStruc
InsurPlcyInsrdObjCurrency InsurPlcyInsrdObjCurrency Currency
InsurPlcyInsrdObjDeclaration InsurPlcyInsrdObjDeclaration Declaration No.
InsurPlcyInsrdObjPositionSqnc InsurPlcyInsrdObjPositionSqnc Item No.
InsurPlcyInsrdObjIsNoPremRaise InsurPlcyInsrdObjIsNoPremRaise No Prem.Incr.
InsurPlcyInsrdObjIsLocChanged InsurPlcyInsrdObjIsLocChanged Location Change
InsurPlcyInsrdObjRiskGrpNumber InsurPlcyInsrdObjRiskGrpNumber Risk Group No.
InsurPlcyInsrdObjOccptnRdyDte InsurPlcyInsrdObjOccptnRdyDte Ready for Occ.
InsurPlcyInsrdObjIsInCnstrctn InsurPlcyInsrdObjIsInCnstrctn Building Str.
InsurPlcyInsrdObjStormZone InsurPlcyInsrdObjStormZone Storm Zone
InsurPlcyInsrdObjHazardClass InsurPlcyInsrdObjHazardClass Risk Class
InsurPlcyInsrdObjCnstrctnType InsurPlcyInsrdObjCnstrctnType Const.TypeCl
InsurPlcyInsrdObjUsblAreaQty InsurPlcyInsrdObjUsblAreaQty InsurPlcyInsrdObjUsblAreaUnit
InsurPlcyInsrdObjCommlUsgePct InsurPlcyInsrdObjCommlUsgePct Comm. Usage (%)
InsurPlcyInsrdObjTariffZone InsurPlcyInsrdObjTariffZone Tariff Zone
InsurPlcyInsrdPersonBirthDate InsurPlcyInsrdPersonBirthDate Date of Birth
InsurPlcyInsrdPersonName InsurPlcyInsrdPersonName Name at Birth
InsurPlcyInsrdPersonStatus InsurPlcyInsrdPersonStatus IP/IO Status
InsurPlcyInsrdPersonAddr InsurPlcyInsrdPersonAddr Address
InsurPlcyInsrdPersonIsOwner InsurPlcyInsrdPersonIsOwner Owner in Assoc.
InsurPlcyInsrdPersonJob InsurPlcyInsrdPersonJob IP Occupation
InsurPlcyInsrdPersonIsSmoker InsurPlcyInsrdPersonIsSmoker Smoker
InsurPlcyInsrdPersonRskGrp InsurPlcyInsrdPersonRskGrp Risk Group
InsurPlcyInsrdPersonGender InsurPlcyInsrdPersonGender Gender
InsurPlcyInsrdPersnBeginValue InsurPlcyInsrdPersnBeginValue Age at Entry
InsurPlcyInsrdPersnFinalValue InsurPlcyInsrdPersnFinalValue Final Age
InsurPlcyInsrdPersnAgeGrp InsurPlcyInsrdPersnAgeGrp Age Group
InsurPlcyInsrdPersnRole InsurPlcyInsrdPersnRole Ins.Person Role
InsurPlcyInsrdPersnJobClass InsurPlcyInsrdPersnJobClass Occupatnl Class
InsurPlcyInsrdObjNmbrOfAnimal InsurPlcyInsrdObjNmbrOfAnimal No. of Animals
InsurPlcyInsrdObjValueAmount InsurPlcyInsrdObjValueAmount Object Value
InsurPlcyInsrdObjLonValue InsurPlcyInsrdObjLonValue Add. Longitude
InsurPlcyInsrdObjLonMinsValue InsurPlcyInsrdObjLonMinsValue Long. in Mins
InsurPlcyInsrdObjLonSecsValue InsurPlcyInsrdObjLonSecsValue Long. in Secs
InsurPlcyInsrdObjLatitudeValue InsurPlcyInsrdObjLatitudeValue Lat.for Address
InsurPlcyInsrdObjLatMinsValue InsurPlcyInsrdObjLatMinsValue Lat. in Minutes
InsurPlcyInsrdObjLatSecsValue InsurPlcyInsrdObjLatSecsValue Lat. in Seconds
InsurPlcyPostCodeTxt InsurPlcyPostCodeTxt Postal Code
InsurPlcyInsrdObjStreetName InsurPlcyInsrdObjStreetName Street
InsurPlcyInsrdObjCountry InsurPlcyInsrdObjCountry Country/Reg.
InsurPlcyInsrdObjValueType InsurPlcyInsrdObjValueType Obj. Value Type
InsurPlcyInsrdObjDtmnYearValue InsurPlcyInsrdObjDtmnYearValue Value Det. (Yr)
InsurPlcyInsrdObjCityName InsurPlcyInsrdObjCityName City
InsurPlcyInsrdObjHouseNumber InsurPlcyInsrdObjHouseNumber House Number
InsurPlcyInsrdObjUsblAreaUnit InsurPlcyInsrdObjUsblAreaUnit Occup.Area Unit
InsurPlcyInsrdObj2LonValue InsurPlcyInsrdObj2LonValue Add. Longitude
InsurPlcyInsrdObj2LonMinsValue InsurPlcyInsrdObj2LonMinsValue Long. in Mins
InsurPlcyInsrdObj2LonSecsValue InsurPlcyInsrdObj2LonSecsValue Long. in Secs
InsurPlcyInsrdObj2LatValue InsurPlcyInsrdObj2LatValue Lat.for Address
InsurPlcyInsrdObj2LatMinsValue InsurPlcyInsrdObj2LatMinsValue Lat. in Minutes
InsurPlcyInsrdObj2LatSecsValue InsurPlcyInsrdObj2LatSecsValue Lat. in Seconds
InsurPlcyInsrdObj2StreetName InsurPlcyInsrdObj2StreetName Street
InsurPlcyInsrdObjPostCodeTxt InsurPlcyInsrdObjPostCodeTxt Postal Code
InsurPlcyInsrdObj2Country InsurPlcyInsrdObj2Country Country/Reg.
InsurPlcyInsrdObj2CnstrctnType InsurPlcyInsrdObj2CnstrctnType Const.TypeCl
InsurPlcyInsrdObj2CityName InsurPlcyInsrdObj2CityName City
InsurPlcyInsrdObj2HouseNumber InsurPlcyInsrdObj2HouseNumber House Number
InsurPlcyInsrdObjIsTmpCvrg InsurPlcyInsrdObjIsTmpCvrg Temporary
InsurPlcyInsrdObjGlazingQty InsurPlcyInsrdObjGlazingQty InsurPlcyInsrdObjGlazingUnit
InsurPlcyInsrdObjInteriorQty InsurPlcyInsrdObjInteriorQty InsurPlcyInsrdObjInteriorGlaze
InsurPlcyInsrdObjIsBuildUpArea InsurPlcyInsrdObjIsBuildUpArea Built-Up Area
InsurPlcyInsrdObjOuterWallType InsurPlcyInsrdObjOuterWallType Ext.Wall Type
InsurPlcyInsrdObjIsPrefabHouse InsurPlcyInsrdObjIsPrefabHouse Prefab. House
InsurPlcyInsrdObjLivingAreaQty InsurPlcyInsrdObjLivingAreaQty InsurPlcyInsrdObjLivingAreaUnt
InsurPlcyInsrdObjLivingAreaUnt InsurPlcyInsrdObjLivingAreaUnt Living Area UOM
InsurPlcyInsrdObjRoofing InsurPlcyInsrdObjRoofing Roofing
InsurPlcyInsrdObjGlazingUnit InsurPlcyInsrdObjGlazingUnit ExtGlaze Area UM
InsurPlcyInsrdObjPrtnPrpty InsurPlcyInsrdObjPrtnPrpty Partner Prop.
InsurPlcyInsrdObjPartner InsurPlcyInsrdObjPartner BusPartner
InsurPlcyInsrdObjInteriorGlaze InsurPlcyInsrdObjInteriorGlaze IntGlaze Area UM
InsurPlcyInsrdObj2HazardClass InsurPlcyInsrdObj2HazardClass Risk Class
InsurPlcyInsrdObj2TariffZone InsurPlcyInsrdObj2TariffZone Tariff Zone
InsurPlcyInsrdObjHasAlarm InsurPlcyInsrdObjHasAlarm Alarm System
InsurPlcyInsrdObjBldngType InsurPlcyInsrdObjBldngType Building Type
_PolicyredirectedtoI_InsurancePolicyTP

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_InsurPlcyInsuredObjectTP.
-- 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_InsurPlcyInsuredObjectTP AS
SELECT
  InsurPlcyUUID,
  InsurPlcyApplUUID,
  InsurPlcyInsurContr,
  InsurPlcyCoveragePackageID,
  InsurPlcyCoverageID,
  InsurPlcyCoverageOptionID,
  InsurPlcyInsuredObjectID,
  InsurPlcyUUIDForEdit,
  InsurPlcyApplUUIDForEdit,
  InsurPlcyInsurContrForEdit,
  InsurPlcyCvPcgIDForEdit,
  InsurPlcyCoverageIDForEdit,
  InsurPlcyCvrgOptnIDForEdit,
  InsurPlcyInsrdObjIDForEdit,
  InsurPlcyUndrwrtgDcsnRiskID,
  InsurPlcySubCvrgID,
  InsurPlcyOrderNumber,
  InsurPlcyBusProcType,
  InsurPlcyBusProcessNumerator,
  InsurPlcyJrnlNmbr,
  InsurPlcyJrnlEndNmbr,
  InsurPlcyProductPackageID,
  InsurPlcyInsrdObjectTemplate,
  InsurPlcyInsuredObjectCategory,
  InsurPlcyInsrdObjSubCategory,
  InsurPlcyInsrdObjUnqID,
  InsurInsrblObjJrnlNmbr,
  InsurPlcyInsrdObjIsCancelled,
  InsurPlcyInsuredPersonID,
  InsurPlcyInsrdObjEffctvDte,
  InsurPlcyInsrdObjAwardReason,
  InsurPlcyInsrdObjIsUpdateNeed,
  InsurPlcyInsrdObjTypeChannel,
  InsurPlcyInsrdObjCatChannel,
  InsurPlcyInsrdObjSuperChannel,
  InsurPlcyInsrdObjCurrency,
  InsurPlcyInsrdObjDeclaration,
  InsurPlcyInsrdObjPositionSqnc,
  InsurPlcyInsrdObjIsNoPremRaise,
  InsurPlcyInsrdObjIsLocChanged,
  InsurPlcyInsrdObjRiskGrpNumber,
  InsurPlcyInsrdObjOccptnRdyDte,
  InsurPlcyInsrdObjIsInCnstrctn,
  InsurPlcyInsrdObjStormZone,
  InsurPlcyInsrdObjHazardClass,
  InsurPlcyInsrdObjCnstrctnType,
  InsurPlcyInsrdObjUsblAreaQty,
  InsurPlcyInsrdObjCommlUsgePct,
  InsurPlcyInsrdObjTariffZone,
  InsurPlcyInsrdPersonBirthDate,
  InsurPlcyInsrdPersonName,
  InsurPlcyInsrdPersonStatus,
  InsurPlcyInsrdPersonAddr,
  InsurPlcyInsrdPersonIsOwner,
  InsurPlcyInsrdPersonJob,
  InsurPlcyInsrdPersonIsSmoker,
  InsurPlcyInsrdPersonRskGrp,
  InsurPlcyInsrdPersonGender,
  InsurPlcyInsrdPersnBeginValue,
  InsurPlcyInsrdPersnFinalValue,
  InsurPlcyInsrdPersnAgeGrp,
  InsurPlcyInsrdPersnRole,
  InsurPlcyInsrdPersnJobClass,
  InsurPlcyInsrdObjNmbrOfAnimal,
  InsurPlcyInsrdObjValueAmount,
  InsurPlcyInsrdObjLonValue,
  InsurPlcyInsrdObjLonMinsValue,
  InsurPlcyInsrdObjLonSecsValue,
  InsurPlcyInsrdObjLatitudeValue,
  InsurPlcyInsrdObjLatMinsValue,
  InsurPlcyInsrdObjLatSecsValue,
  InsurPlcyPostCodeTxt,
  InsurPlcyInsrdObjStreetName,
  InsurPlcyInsrdObjCountry,
  InsurPlcyInsrdObjValueType,
  InsurPlcyInsrdObjDtmnYearValue,
  InsurPlcyInsrdObjCityName,
  InsurPlcyInsrdObjHouseNumber,
  InsurPlcyInsrdObjUsblAreaUnit,
  InsurPlcyInsrdObj2LonValue,
  InsurPlcyInsrdObj2LonMinsValue,
  InsurPlcyInsrdObj2LonSecsValue,
  InsurPlcyInsrdObj2LatValue,
  InsurPlcyInsrdObj2LatMinsValue,
  InsurPlcyInsrdObj2LatSecsValue,
  InsurPlcyInsrdObj2StreetName,
  InsurPlcyInsrdObjPostCodeTxt,
  InsurPlcyInsrdObj2Country,
  InsurPlcyInsrdObj2CnstrctnType,
  InsurPlcyInsrdObj2CityName,
  InsurPlcyInsrdObj2HouseNumber,
  InsurPlcyInsrdObjIsTmpCvrg,
  InsurPlcyInsrdObjGlazingQty,
  InsurPlcyInsrdObjInteriorQty,
  InsurPlcyInsrdObjIsBuildUpArea,
  InsurPlcyInsrdObjOuterWallType,
  InsurPlcyInsrdObjIsPrefabHouse,
  InsurPlcyInsrdObjLivingAreaQty,
  InsurPlcyInsrdObjLivingAreaUnt,
  InsurPlcyInsrdObjRoofing,
  InsurPlcyInsrdObjGlazingUnit,
  InsurPlcyInsrdObjPrtnPrpty,
  InsurPlcyInsrdObjPartner,
  InsurPlcyInsrdObjInteriorGlaze,
  InsurPlcyInsrdObj2HazardClass,
  InsurPlcyInsrdObj2TariffZone,
  InsurPlcyInsrdObjHasAlarm,
  InsurPlcyInsrdObjBldngType
FROM R_InsurPolicyInsuredObjectTP_2
;

Learn More