Which tables does I_REObjectTypeDetails use?

I_REObjectTypeDetails reads from 1 data source(s): I_REKeyAssgmt.

How many fields does I_REObjectTypeDetails have?

I_REObjectTypeDetails has 16 fields. Key fields: REStatusObject.

I_REObjectTypeDetails

DDL: I_REOBJECTTYPEDETAILS SQL: IREOBJTYPDET Type: view_entity COMPOSITE Package: VDM_RE_CA

Real Estate Object Type Details

I_REObjectTypeDetails is a Composite CDS View (Dimension) that provides data about "Real Estate Object Type Details" in SAP S/4HANA. It reads from 1 data source (I_REKeyAssgmt) and exposes 16 fields with key field REStatusObject. It has 13 associations to related views. Part of development package VDM_RE_CA.

Data Sources (1)

Source	Alias	Join Type
I_REKeyAssgmt	_REObjectTypeDetails	from

Associations (13)

Cardinality	Target	Alias	Condition
[1..1]	I_REKeyAssgmt	_REKeyAssgmt	`$projection.REStatusObject = _REKeyAssgmt.REStatusObject`
[0..1]	I_REObjectTypeText	_REObjectTypeText	`_REObjectTypeText.RealEstateObjectType = $projection.RealEstateObjectType and _REObjectTypeText.Language = $session.system_language`
[0..1]	I_REContract	_REContract	`$projection.REStatusObject = _REContract.REStatusObject`
[0..1]	I_REBusinessEntity	_REBusinessEntity	`$projection.REStatusObject = _REBusinessEntity.REStatusObject`
[0..1]	I_REBuilding	_REBuilding	`$projection.REStatusObject = _REBuilding.REStatusObject`
[0..1]	I_REProperty	_REProperty	`$projection.REStatusObject = _REProperty.REStatusObject`
[0..1]	I_RERentalObject	_RERentalObject	`$projection.REStatusObject = _RERentalObject.REStatusObject`
[0..1]	I_RESettlementUnit	_RESettlementUnit	`$projection.REStatusObject = _RESettlementUnit.REStatusObject`
[0..1]	I_REIntegrationObject	_REIntegrationObject	`$projection.REStatusObject = _REIntegrationObject.REStatusObject`
[0..1]	I_REServiceGroup	_REServiceGroup	`$projection.REStatusObject = _REServiceGroup.REStatusObject`
[0..1]	I_REUsableObject	_REUsableObject	`$projection.REStatusObject = _REUsableObject.REStatusObject`
[0..1]	I_RERentableObject	_RERentableObject	`$projection.REStatusObject = _RERentableObject.REStatusObject`
[0..1]	I_REGenericRentalObject	_REGenericRentalObject	`$projection.REStatusObject = _REGenericRentalObject.REStatusObject`

Annotations (13)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Real Estate Object Type Details	view
Analytics.dataCategory	#DIMENSION	view
Analytics.internalName	#LOCAL	view
Analytics.dataExtraction.enabled	true	view
ObjectModel.representativeKey	REStatusObject	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
ObjectModel.sapObjectNodeType.name	RealEstateObjectDetails	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#COMPOSITE	view

Fields (16)

Key	Field	Source Field
KEY	REStatusObject	REStatusObject
	InternalRealEstateNumber	InternalRealEstateNumber
	RealEstateObjectType	RealEstateObjectType
	REIdentificationKey	REIdentificationKey
	_REKeyAssgmt	_REKeyAssgmt
	_REContract	_REContract
	_REBusinessEntity	_REBusinessEntity
	_REBuilding	_REBuilding
	_REProperty	_REProperty
	_RERentalObject	_RERentalObject
	_RESettlementUnit	_RESettlementUnit
	_REIntegrationObject	_REIntegrationObject
	_REServiceGroup	_REServiceGroup
	_REUsableObject	_REUsableObject
	_RERentableObject	_RERentableObject
	_REGenericRentalObject	_REGenericRentalObject

//@AbapCatalog.sqlViewName: 'IREOBJTYPDET'

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Object Type Details'
@Analytics: {
  dataCategory: #DIMENSION,
  internalName: #LOCAL,
  dataExtraction.enabled: true
}
@ObjectModel: {
  representativeKey: 'REStatusObject',
  semanticKey: [ 'REStatusObject' ],
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #L
  },
  modelingPattern: #ANALYTICAL_DIMENSION,
  supportedCapabilities: [
    #ANALYTICAL_DIMENSION, 
    #CDS_MODELING_ASSOCIATION_TARGET,
    #EXTRACTION_DATA_SOURCE
  ],
  sapObjectNodeType.name: 'RealEstateObjectDetails'
}
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE

define view entity I_REObjectTypeDetails
  as select from I_REKeyAssgmt as _REObjectTypeDetails

  association [1..1] to I_REKeyAssgmt          as _REKeyAssgmt         on  $projection.REStatusObject = _REKeyAssgmt.REStatusObject
  association [0..1] to I_REObjectTypeText     as _REObjectTypeText    on  _REObjectTypeText.RealEstateObjectType = $projection.RealEstateObjectType
                                                                       and _REObjectTypeText.Language             = $session.system_language
  association [0..1] to I_REContract           as _REContract           on  $projection.REStatusObject = _REContract.REStatusObject
  association [0..1] to I_REBusinessEntity     as _REBusinessEntity     on  $projection.REStatusObject = _REBusinessEntity.REStatusObject
  association [0..1] to I_REBuilding           as _REBuilding           on  $projection.REStatusObject = _REBuilding.REStatusObject
  association [0..1] to I_REProperty           as _REProperty           on  $projection.REStatusObject = _REProperty.REStatusObject
  association [0..1] to I_RERentalObject       as _RERentalObject       on  $projection.REStatusObject = _RERentalObject.REStatusObject
  association [0..1] to I_RESettlementUnit     as _RESettlementUnit     on  $projection.REStatusObject = _RESettlementUnit.REStatusObject
  association [0..1] to I_REIntegrationObject  as _REIntegrationObject  on  $projection.REStatusObject = _REIntegrationObject.REStatusObject
  association [0..1] to I_REServiceGroup       as _REServiceGroup       on  $projection.REStatusObject = _REServiceGroup.REStatusObject
  association [0..1] to I_REUsableObject       as _REUsableObject       on  $projection.REStatusObject = _REUsableObject.REStatusObject
  association [0..1] to I_RERentableObject     as _RERentableObject     on  $projection.REStatusObject = _RERentableObject.REStatusObject
  association [0..1] to I_REGenericRentalObject as _REGenericRentalObject on $projection.REStatusObject = _REGenericRentalObject.REStatusObject
{
  key       REStatusObject                                               as REStatusObject,
            InternalRealEstateNumber,
            RealEstateObjectType,
            REIdentificationKey,
            cast(
            concat_with_space(_REObjectTypeText.REObjectTypePrefix,
            REIdentificationKey,1 ) as recaident)                        as REIdentification,
            cast(
            concat_with_space(_REObjectTypeText.RealEstateObjectTypeName,
            REIdentificationKey,1 ) as recaident)                        as REAccountingObjectName,
            
            _REKeyAssgmt,

            _REContract,
            _REBusinessEntity,
            _REBuilding,
            _REProperty,
            _RERentalObject,
            _RESettlementUnit,
            _REIntegrationObject,
            _REServiceGroup,
            _REUsableObject,
            _RERentableObject,
            _REGenericRentalObject
}

Depth:

I_REObjectTypeDetails view_entity

I_REKeyAssgmt view_entity

I_REObjectAssgmtMeasurement view