Which tables does I_InsurInsurableObjectBldng use?

I_InsurInsurableObjectBldng reads from 1 data source(s): I_InsurInsrblObjectBasic.

How many fields does I_InsurInsurableObjectBldng have?

I_InsurInsurableObjectBldng has 32 fields. Key fields: InsurInsrblObjUUID, InsurInsrblObjJrnlNmbr, InsurInsrblObj.

I_InsurInsurableObjectBldng

DDL: I_INSURINSURABLEOBJECTBLDNG Type: view_entity COMPOSITE

Insurable Object Building

I_InsurInsurableObjectBldng is a Composite CDS View that provides data about "Insurable Object Building" in SAP S/4HANA. It reads from 1 data source (I_InsurInsrblObjectBasic) and exposes 32 fields with key fields InsurInsrblObjUUID, InsurInsrblObjJrnlNmbr, InsurInsrblObj. It has 6 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_InsurInsrblObjectBasic	InsurableObjectBldng	from

Associations (6)

Cardinality	Target	Alias	Condition
[1..1]	I_InsurInsrblObjOutWallType	_InsurInsrblObjOutWallType	`$projection.InsurInsrblObjOuterWallType = _InsurInsrblObjOutWallType.InsurInsrblObjOuterWallType`
[1..1]	I_InsurInsrblObjRoofing	_InsurInsrblObjRoofing	`$projection.InsurInsrblObjRoofing = _InsurInsrblObjRoofing.InsurInsrblObjRoofing`
[1..1]	I_InsurInsrblObjBldngCat	_InsurInsrblObjBldngCat	`$projection.InsurInsrblObjBldngCategory = _InsurInsrblObjBldngCat.InsurInsrblObjBldngCategory`
[1..1]	I_InsurInsrblObjBldngType	_InsurInsrblObjBldngType	`$projection.InsurInsrblObjBldngType = _InsurInsrblObjBldngType.InsurInsrblObjBldngType`
[1..1]	I_InsurInsrblObjPartPrpty	_InsurInsrblObjPartPrpty	`$projection.InsurInsrblObjPartPrpty = _InsurInsrblObjPartPrpty.InsurInsrblObjPartPrpty`
[0..1]	I_BusinessPartner	_BusinessPartner	`$projection.InsurInsrblObjPartner = _BusinessPartner.BusinessPartner`

Annotations (11)

Name	Value	Level
EndUserText.label	Insurable Object Building	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ObjectModel.representativeKey	InsurInsrblObjUUID	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
Metadata.allowExtensions	false	view
Metadata.ignorePropagatedAnnotations	false	view
Analytics.technicalName	IInsrblObjBldng	view

Fields (32)

Key	Field	Source Table	Source Field
KEY	InsurInsrblObjUUID	I_InsurInsrblObjectBasic	InsurInsrblObjUUID
KEY	InsurInsrblObjJrnlNmbr	I_InsurInsrblObjectBasic	InsurInsrblObjJrnlNmbr
KEY	InsurInsrblObj	I_InsurInsrblObjectBasic	InsurInsrblObj
	InsurInsrblObjIsPrefabHouse	I_InsurInsrblObjectBasic	InsurInsrblObjIsPrefabHouse
	InsurInsrblObjIsTmpCvrg	I_InsurInsrblObjectBasic	InsurInsrblObjIsTmpCvrg
	InsurInsrblObjOuterWallType	I_InsurInsrblObjectBasic	InsurInsrblObjOuterWallType
	InsurInsrblObjRoofing	I_InsurInsrblObjectBasic	InsurInsrblObjRoofing
	InsurInsrblObjCubicSpaceQty	I_InsurInsrblObjectBasic	InsurInsrblObjCubicSpaceQty
	InsurInsrblObjCubicSpaceUnit	I_InsurInsrblObjectBasic	InsurInsrblObjCubicSpaceUnit
	InsurInsrblObjConstructYear	I_InsurInsrblObjectBasic	InsurInsrblObjConstructYear
	InsurInsrblObjGlazingQty	I_InsurInsrblObjectBasic	InsurInsrblObjGlazingQty
	InsurInsrblObjGlazingUnit	I_InsurInsrblObjectBasic	InsurInsrblObjGlazingUnit
	InsurInsrblObjIsBuildUpArea	I_InsurInsrblObjectBasic	InsurInsrblObjIsBuildUpArea
	InsurInsrblObjPropertyAreaQty	I_InsurInsrblObjectBasic	InsurInsrblObjPropertyAreaQty
	InsurInsrblObjPropertyAreaUnit	I_InsurInsrblObjectBasic	InsurInsrblObjPropertyAreaUnit
	InsurInsrblObjPartner	I_InsurInsrblObjectBasic	InsurInsrblObjPartner
	InsurInsrblObjPartPrpty	I_InsurInsrblObjectBasic	InsurInsrblObjPartPrpty
	InsurInsrblObjBldngCategory	I_InsurInsrblObjectBasic	InsurInsrblObjBldngCategory
	InsurInsrblObjBldngType	I_InsurInsrblObjectBasic	InsurInsrblObjBldngType
	InsurInsrblObjNmbrOfFloors	I_InsurInsrblObjectBasic	InsurInsrblObjNmbrOfFloors
	InsurInsrblObjNmbrOfLiving	I_InsurInsrblObjectBasic	InsurInsrblObjNmbrOfLiving
	InsurInsrblObjIsOccupiedBldng	I_InsurInsrblObjectBasic	InsurInsrblObjIsOccupiedBldng
	InsurInsrblObjYearOfCleanup	I_InsurInsrblObjectBasic	InsurInsrblObjYearOfCleanup
	InsurInsrblObjUsableSpaceQty	I_InsurInsrblObjectBasic	InsurInsrblObjUsableSpaceQty
	InsurInsrblObjUsableSpaceUnit	I_InsurInsrblObjectBasic	InsurInsrblObjUsableSpaceUnit
	_InsurInsrblObjOutWallType		_InsurInsrblObjOutWallType
	_InsurInsrblObjRoofing		_InsurInsrblObjRoofing
	_InsurInsrblObjBldngCat		_InsurInsrblObjBldngCat
	_InsurInsrblObjBldngType		_InsurInsrblObjBldngType
	_InsurInsrblObjPartPrpty		_InsurInsrblObjPartPrpty
	_BusinessPartner		_BusinessPartner
	_InsurInsurableObject		_InsurInsurableObject

@EndUserText.label                    : 'Insurable Object Building'

@VDM                                  : {
    viewType                          : #COMPOSITE,
    lifecycle.contract.type           : #PUBLIC_LOCAL_API }

@AccessControl                        : {
    authorizationCheck                : #PRIVILEGED_ONLY,
    personalData.blocking             : #('TRANSACTIONAL_DATA')
}

@ObjectModel                          : {
    representativeKey                 : 'InsurInsrblObjUUID',
    semanticKey                       : [ 'InsurInsrblObjUUID' ],
    usageType                         : {
    dataClass                         : #TRANSACTIONAL,
    serviceQuality                    : #C,
    sizeCategory                      : #XL },
    supportedCapabilities             : [ #CDS_MODELING_DATA_SOURCE ] }

@Metadata.allowExtensions             : false
@Metadata.ignorePropagatedAnnotations : false
@Analytics                            : {
    technicalName                     : 'IInsrblObjBldng'}

define view entity I_InsurInsurableObjectBldng

  as select from I_InsurInsrblObjectBasic as InsurableObjectBldng

  association        to parent I_InsurInsurableObject as _InsurInsurableObject      on  $projection.InsurInsrblObjUUID     = _InsurInsurableObject.InsurInsrblObjUUID
                                                                                    and $projection.InsurInsrblObjJrnlNmbr = _InsurInsurableObject.InsurInsrblObjJrnlNmbr
                                                                                    and $projection.InsurInsrblObj         = _InsurInsurableObject.InsurInsrblObj

  association [1..1] to I_InsurInsrblObjOutWallType   as _InsurInsrblObjOutWallType on  $projection.InsurInsrblObjOuterWallType = _InsurInsrblObjOutWallType.InsurInsrblObjOuterWallType
  association [1..1] to I_InsurInsrblObjRoofing       as _InsurInsrblObjRoofing     on  $projection.InsurInsrblObjRoofing = _InsurInsrblObjRoofing.InsurInsrblObjRoofing
  association [1..1] to I_InsurInsrblObjBldngCat      as _InsurInsrblObjBldngCat    on  $projection.InsurInsrblObjBldngCategory = _InsurInsrblObjBldngCat.InsurInsrblObjBldngCategory
  association [1..1] to I_InsurInsrblObjBldngType     as _InsurInsrblObjBldngType   on  $projection.InsurInsrblObjBldngType = _InsurInsrblObjBldngType.InsurInsrblObjBldngType
  association [1..1] to I_InsurInsrblObjPartPrpty     as _InsurInsrblObjPartPrpty   on  $projection.InsurInsrblObjPartPrpty = _InsurInsrblObjPartPrpty.InsurInsrblObjPartPrpty
  association [0..1] to I_BusinessPartner             as _BusinessPartner           on  $projection.InsurInsrblObjPartner = _BusinessPartner.BusinessPartner

{
  key InsurableObjectBldng.InsurInsrblObjUUID,
  key InsurableObjectBldng.InsurInsrblObjJrnlNmbr,
  key InsurableObjectBldng.InsurInsrblObj,
      @Semantics.booleanIndicator :true
      InsurableObjectBldng.InsurInsrblObjIsPrefabHouse,
      @Semantics.booleanIndicator :true
      InsurableObjectBldng.InsurInsrblObjIsTmpCvrg,
      @ObjectModel.foreignKey.association: '_InsurInsrblObjOutWallType'
      InsurableObjectBldng.InsurInsrblObjOuterWallType,
      @ObjectModel.foreignKey.association: '_InsurInsrblObjRoofing'
      InsurableObjectBldng.InsurInsrblObjRoofing,
      InsurableObjectBldng.InsurInsrblObjCubicSpaceQty,
      InsurableObjectBldng.InsurInsrblObjCubicSpaceUnit,
      InsurableObjectBldng.InsurInsrblObjConstructYear,
      InsurableObjectBldng.InsurInsrblObjGlazingQty,
      InsurableObjectBldng.InsurInsrblObjGlazingUnit,
      InsurableObjectBldng.InsurInsrblObjIsBuildUpArea,
      InsurableObjectBldng.InsurInsrblObjPropertyAreaQty,
      InsurableObjectBldng.InsurInsrblObjPropertyAreaUnit,
      @ObjectModel.foreignKey.association: '_BusinessPartner'
      InsurableObjectBldng.InsurInsrblObjPartner,
      @ObjectModel.foreignKey.association: '_InsurInsrblObjPartPrpty'
      InsurableObjectBldng.InsurInsrblObjPartPrpty,
      @ObjectModel.foreignKey.association: '_InsurInsrblObjBldngCat'
      InsurableObjectBldng.InsurInsrblObjBldngCategory,
      @ObjectModel.foreignKey.association: '_InsurInsrblObjBldngType'
      InsurableObjectBldng.InsurInsrblObjBldngType,
      InsurableObjectBldng.InsurInsrblObjNmbrOfFloors,
      InsurableObjectBldng.InsurInsrblObjNmbrOfLiving,
      @Semantics.booleanIndicator :true
      InsurableObjectBldng.InsurInsrblObjIsOccupiedBldng,
      InsurableObjectBldng.InsurInsrblObjYearOfCleanup,
      InsurableObjectBldng.InsurInsrblObjUsableSpaceQty,
      InsurableObjectBldng.InsurInsrblObjUsableSpaceUnit,



      @Consumption.hidden: true
      _InsurInsrblObjOutWallType,
      @Consumption.hidden: true
      _InsurInsrblObjRoofing,
      @Consumption.hidden: true
      _InsurInsrblObjBldngCat,
      @Consumption.hidden: true
      _InsurInsrblObjBldngType,
      @Consumption.hidden: true
      _InsurInsrblObjPartPrpty,
      _BusinessPartner,
      _InsurInsurableObject
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURINSRBLOBJECTBASIC"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_INSURINSRBLOBJBLDNGCAT",
"I_INSURINSRBLOBJBLDNGTYPE",
"I_INSURINSRBLOBJOUTWALLTYPE",
"I_INSURINSRBLOBJPARTPRPTY",
"I_INSURINSRBLOBJROOFING",
"I_INSURINSURABLEOBJECT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_InsurInsurableObjectBldng view_entity

I_InsurInsrblObjectBasic view_entity