A_InsOpApCvrgInsuredObject

DDL: A_INSOPAPCVRGINSUREDOBJECT Type: view_entity CONSUMPTION
96 Fields 1 Data Sources

Insrd Obj under Cvrg for New Biz Appl

A_InsOpApCvrgInsuredObject is a Consumption CDS View that provides data about "Insrd Obj under Cvrg for New Biz Appl" in SAP S/4HANA. It reads from 1 data source (R_InsurPlcyCvrgInsuredObjectTP) and exposes 96 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcyCoverageOptionID.

Data Sources (1)

SourceAliasJoin Type
R_InsurPlcyCvrgInsuredObjectTP R_InsurPlcyCvrgInsuredObjectTP projection

Annotations (15)

NameValueLevelField
EndUserText.label Insrd Obj under Cvrg for New Biz Appl view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
OData.entityType.name InsOpApCvrgInsuredObject_Type view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix IOB view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.allowNewCompositions true view
AbapCatalog.extensibility.quota.maximumFields 250 view
AbapCatalog.extensibility.quota.maximumBytes 2500 view

Fields (96)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID 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.
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr Journal Number
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
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
InsurPlcyInsrdPersnProfession InsurPlcyInsrdPersnProfession IP Occup.Status
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
InsurPlcyInsrdObjInteriorQty InsurPlcyInsrdObjInteriorQty
InsurPlcyInsrdObjIsBuildUpArea InsurPlcyInsrdObjIsBuildUpArea Built-Up Area
InsurPlcyInsrdObjOuterWallType InsurPlcyInsrdObjOuterWallType Ext.Wall Type
InsurPlcyInsrdObjIsPrefabHouse InsurPlcyInsrdObjIsPrefabHouse Prefab. House
InsurPlcyInsrdObjLivingAreaQty InsurPlcyInsrdObjLivingAreaQty
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

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 A_InsOpApCvrgInsuredObject.
-- 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 A_InsOpApCvrgInsuredObject AS
SELECT
  InsurPlcyUUID,
  InsurPlcyInsurContr,
  InsurPlcyCoveragePackageID,
  InsurPlcyCoverageID,
  InsurPlcyCoverageOptionID,
  InsurPlcyInsuredObjectID,
  InsurPlcyJrnlEndNmbr,
  InsurPlcyJrnlNmbr,
  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,
  InsurPlcyInsrdPersnProfession,
  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_InsurPlcyCvrgInsuredObjectTP
;

Learn More