Which tables does I_REIntegObjectRelationPartial use?

I_REIntegObjectRelationPartial reads from 1 data source(s): viipobjrel.

How many fields does I_REIntegObjectRelationPartial have?

I_REIntegObjectRelationPartial has 13 fields. Key fields: REIntegObjectRelationUUID.

I_REIntegObjectRelationPartial

DDL: I_REINTEGOBJECTRELATIONPARTIAL SQL: IREINTOBJRELPART Type: view BASIC

Real Estate Integ Obj Partial Relation

I_REIntegObjectRelationPartial is a Basic CDS View that provides data about "Real Estate Integ Obj Partial Relation" in SAP S/4HANA. It reads from 1 data source (viipobjrel) and exposes 13 fields with key field REIntegObjectRelationUUID. It has 4 associations to related views.

Data Sources (1)

Source	Alias	Join Type
viipobjrel	_REIntegObjectRelationPartial	from

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	I_REIntegrationObject	_REIntegrationObject	`$projection.InternalRealEstateNumber = _REIntegrationObject.InternalRealEstateNumber`
[1..1]	I_REIntegrationObject	_RERelatedIntegrationObject	`$projection.InternalRealEstateNumberRltn = _RERelatedIntegrationObject.InternalRealEstateNumber`
[1..1]	I_REMeasurementType	_REMeasurementType	`$projection.REMeasurementType = _REMeasurementType.REMeasurementType`
[0..1]	I_UnitOfMeasure	_UnitOfMeasure	`$projection.REMeasurementUnit = _UnitOfMeasure.UnitOfMeasure`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	IREINTOBJRELPART	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Real Estate Integ Obj Partial Relation	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.representativeKey	REIntegObjectRelationUUID	view
ObjectModel.semanticKey	InternalRealEstateNumber	view
VDM.viewType	#BASIC	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.preserveKey	true	view

Fields (13)

Key	Field	Source Field
KEY	REIntegObjectRelationUUID	objrelguid
	InternalRealEstateNumber	intreno
	InternalRealEstateNumberRltn	intrenorel
	ValidityEndDate
	ValidityStartDate
	REIsObjectRelationPartial	isobjectrelpart
	REMeasurementType	meas
	REMeasurementPartialQuantity	measpart
	REMeasurementUnit
	_REIntegrationObject	_REIntegrationObject
	_RERelatedIntegrationObject	_RERelatedIntegrationObject
	_REMeasurementType	_REMeasurementType
	_UnitOfMeasure	_UnitOfMeasure

@AbapCatalog.sqlViewName: 'IREINTOBJRELPART'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Integ Obj Partial Relation'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.representativeKey: 'REIntegObjectRelationUUID'
@ObjectModel.semanticKey: 'InternalRealEstateNumber'
@VDM.viewType: #BASIC
//@Search.searchable: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true

define view I_REIntegObjectRelationPartial
  as select from viipobjrel as _REIntegObjectRelationPartial

  association [1..1] to I_REIntegrationObject as _REIntegrationObject on $projection.InternalRealEstateNumber = _REIntegrationObject.InternalRealEstateNumber
  association [1..1] to I_REIntegrationObject as _RERelatedIntegrationObject on $projection.InternalRealEstateNumberRltn = _RERelatedIntegrationObject.InternalRealEstateNumber
  association [1..1] to I_REMeasurementType   as _REMeasurementType   on $projection.REMeasurementType = _REMeasurementType.REMeasurementType
  association [0..1] to I_UnitOfMeasure       as _UnitOfMeasure       on $projection.REMeasurementUnit = _UnitOfMeasure.UnitOfMeasure
{
  key objrelguid                                            as REIntegObjectRelationUUID,
      intreno                                               as InternalRealEstateNumber,
//      iorelextid                                            as RERelatedIntegObjectExternalID,

      intrenorel                                            as InternalRealEstateNumberRltn,
      @Semantics.businessDate.to: true
      cast( validto as rebdvdmvalidto preserving type )     as ValidityEndDate,
      @Semantics.businessDate.from: true
      cast( validfrom as rebdvdmvalidfrom preserving type ) as ValidityStartDate,
      isobjectrelpart                                       as REIsObjectRelationPartial,
      meas                                                  as REMeasurementType,
      @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
      measpart                                              as REMeasurementPartialQuantity,
//      @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'

//      measfull                                              as REMeasurementTotalQuantity,

      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      @Semantics.unitOfMeasure
      cast (measunit as msehiunit preserving type)          as REMeasurementUnit,

      _REIntegrationObject,
      _RERelatedIntegrationObject,
      _REMeasurementType,
      _UnitOfMeasure

}where isobjectrelpart = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VIIPOBJREL"
],
"ASSOCIATED":
[
"I_REINTEGRATIONOBJECT",
"I_REMEASUREMENTTYPE",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_REIntegObjectRelationPartial view

viipobjrel