Which tables does I_REServiceGroupBasicData use?

I_REServiceGroupBasicData reads from 1 data source(s): vicssg.

How many fields does I_REServiceGroupBasicData have?

I_REServiceGroupBasicData has 40 fields. Key fields: InternalRealEstateNumber.

I_REServiceGroupBasicData

DDL: I_RESERVICEGROUPBASICDATA SQL: IRESERVICEGRPBSC Type: view_entity BASIC

Real Estate Service Group

I_REServiceGroupBasicData is a Basic CDS View that provides data about "Real Estate Service Group" in SAP S/4HANA. It reads from 1 data source (vicssg) and exposes 40 fields with key field InternalRealEstateNumber. It has 22 associations to related views.

Data Sources (1)

Source	Alias	Join Type
vicssg	vicssg	from

Associations (22)

Cardinality	Target	Alias	Condition
[0..1]	I_User	_CreatedByUser	`$projection.CreatedByUser = _CreatedByUser.UserID`
[0..1]	I_User	_ChangedByUser	`$projection.LastChangedByUser = _ChangedByUser.UserID`
[0..1]	I_User	_ResponsibleUser	`$projection.Responsible = _ResponsibleUser.UserID`
[1..1]	I_REKeyAssgmt	_REKeyAssgmt	`$projection.InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber`
[0..1]	I_REAuthorizationGroup	_REAuthorizationGroup	`$projection.REAuthorizationGroup = _REAuthorizationGroup.REAuthorizationGroup and _REAuthorizationGroup.RealEstateObjectType = 'J6'`
[1..1]	I_REServiceGroupType	_REServiceGroupType	`$projection.REServiceGroupType = _REServiceGroupType.REServiceGroupType`
[1..1]	I_REServiceGroupCategory	_REServiceGroupCategory	`$projection.REServiceGroupCategory = _REServiceGroupCategory.REServiceGroupCategory`
[0..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[0..1]	I_StatusObject	_StatusObject	`$projection.REStatusObject = _StatusObject.StatusObject`
[1..*]	I_StatusObjectStatus	_StatusObjectStatus	`$projection.REStatusObject = _StatusObjectStatus.StatusObject`
[1..*]	I_RESrvcGrpToContractAssgmt	_RESrvcGrpToContractAssgmt	`$projection.REStatusObject = _RESrvcGrpToContractAssgmt.REStatusObjectSource`
[0..1]	I_REIntegrationObject	_REParentIntegrationObject	`$projection.REParentIntRealEstateNumber = _REParentIntegrationObject.InternalRealEstateNumber`
[0..*]	I_RESrvcGrpObjectRelation	_RESrvcGrpObjectRelation	`$projection.InternalRealEstateNumber = _RESrvcGrpObjectRelation.InternalRealEstateNumber`
[0..*]	I_RESrvcGrpSettlementRule	_RESrvcGrpSettlementRule	`$projection.InternalRealEstateNumber = _RESrvcGrpSettlementRule.InternalRealEstateNumber`
[0..*]	I_RESrvcGrpSettlmtRule2CostCat	_RESrvcGrpSettlmtRule2CostCat	`$projection.InternalRealEstateNumber = _RESrvcGrpSettlmtRule2CostCat.InternalRealEstateNumber`
[0..*]	I_REApportionmentRule	_REApportionmentRule	`$projection.InternalRealEstateNumber = _REApportionmentRule.InternalRealEstateNumber`
[0..*]	I_REDenominatorRule	_REDenominatorRule	`$projection.InternalRealEstateNumber = _REDenominatorRule.InternalRealEstateNumber`
[0..*]	I_REPartnerAssgmt	_REPartnerAssgmt	`$projection.InternalRealEstateNumber = _REPartnerAssgmt.InternalRealEstateNumber`
[0..*]	I_REObjectAssgmt	_REObjectAssgmt	`$projection.REStatusObject = _REObjectAssgmt.REStatusObjectSource`
[0..*]	I_REReminderObjRule	_REReminderRule	`$projection.InternalRealEstateNumber = _REReminderRule.InternalRealEstateNumber`
[0..*]	I_REServiceGroupAcctObjAssgmt	_REServiceGroupAcctObjAssgmt	`$projection.InternalRealEstateNumber = _REServiceGroupAcctObjAssgmt.InternalRealEstateNumber`
[1..1]	E_REServiceGroup	_Extension	`$projection.InternalRealEstateNumber = _Extension.InternalRealEstateNumber`

Annotations (8)

Name	Value	Level
EndUserText.label	Real Estate Service Group	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.representativeKey	InternalRealEstateNumber	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
Metadata.allowExtensions	true	view
VDM.viewType	#BASIC	view

Fields (40)

Key	Field	Source Field
KEY	InternalRealEstateNumber	intreno
	REStatusObject	objnr
	RealEstateServiceGroupNumber	sgnr
	REServiceGroupType	sgtype
	REServiceGroupCategory	sgcategory
	REServiceGroupName	sgxstext
	REServiceGroupLongName	sgxltext
	REParentIntRealEstateNumber	parentintreno
	CompanyCode	bukrs
	CreatedByUser	rerf
	CreationDate	derf
	CreationTime	terf
	RESourceOfCreation	reher
	LastChangedByUser	rbear
	LastChangeDate	dbear
	LastChangeTime	tbear
	RESourceOfChange	rbher
	Responsible	responsible
	REAuthorizationGroup	authgrp
	_CreatedByUser	_CreatedByUser
	_ChangedByUser	_ChangedByUser
	_ResponsibleUser	_ResponsibleUser
	_REAuthorizationGroup	_REAuthorizationGroup
	_REServiceGroupType	_REServiceGroupType
	_REServiceGroupCategory	_REServiceGroupCategory
	_REKeyAssgmt	_REKeyAssgmt
	_StatusObject	_StatusObject
	_StatusObjectStatus	_StatusObjectStatus
	_REParentIntegrationObject	_REParentIntegrationObject
	_CompanyCode	_CompanyCode
	_REPartnerAssgmt	_REPartnerAssgmt
	_REObjectAssgmt	_REObjectAssgmt
	_REReminderRule	_REReminderRule
	_RESrvcGrpObjectRelation	_RESrvcGrpObjectRelation
	_RESrvcGrpToContractAssgmt	_RESrvcGrpToContractAssgmt
	_REServiceGroupAcctObjAssgmt	_REServiceGroupAcctObjAssgmt
	_RESrvcGrpSettlementRule	_RESrvcGrpSettlementRule
	_RESrvcGrpSettlmtRule2CostCat	_RESrvcGrpSettlmtRule2CostCat
	_REApportionmentRule	_REApportionmentRule
	_REDenominatorRule	_REDenominatorRule

//@AbapCatalog.sqlViewName: 'IRESERVICEGRPBSC'

@EndUserText.label: 'Real Estate Service Group'


@AccessControl.authorizationCheck: #MANDATORY

@ObjectModel.representativeKey: 'InternalRealEstateNumber'
@ObjectModel.semanticKey: ['RealEstateServiceGroupNumber']
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

//@Analytics.internalName:#LOCAL

//@Analytics:{

//    dataCategory: #DIMENSION,

//    dataExtraction: {

//        enabled: true,

//        delta.changeDataCapture: {

//        automatic: true

//        }

//    }

//}


@Metadata.allowExtensions: true

@VDM.viewType: #BASIC

define view entity I_REServiceGroupBasicData
  as select from vicssg
  association [0..1] to I_User                         as _CreatedByUser                on  $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User                         as _ChangedByUser                on  $projection.LastChangedByUser = _ChangedByUser.UserID
  association [0..1] to I_User                         as _ResponsibleUser              on  $projection.Responsible = _ResponsibleUser.UserID
  association [1..1] to I_REKeyAssgmt                  as _REKeyAssgmt                  on  $projection.InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber
  association [0..1] to I_REAuthorizationGroup         as _REAuthorizationGroup         on  $projection.REAuthorizationGroup           = _REAuthorizationGroup.REAuthorizationGroup
                                                                                        and _REAuthorizationGroup.RealEstateObjectType = 'J6'
  //  association [1..1] to I_REServiceCategory            as _REServiceCategory            on  $projection.REServiceCategory = _REServiceCategory.REServiceCategory

  association [1..1] to I_REServiceGroupType           as _REServiceGroupType           on  $projection.REServiceGroupType = _REServiceGroupType.REServiceGroupType
  association [1..1] to I_REServiceGroupCategory       as _REServiceGroupCategory       on  $projection.REServiceGroupCategory = _REServiceGroupCategory.REServiceGroupCategory
  association [0..1] to I_CompanyCode                  as _CompanyCode                  on  $projection.CompanyCode = _CompanyCode.CompanyCode

  association [0..1] to I_StatusObject                 as _StatusObject                 on  $projection.REStatusObject = _StatusObject.StatusObject
  association [1..*] to I_StatusObjectStatus           as _StatusObjectStatus           on  $projection.REStatusObject = _StatusObjectStatus.StatusObject
  //  association [0..1] to I_REObjectAddress              as _REObjectAddress              on  $projection.InternalRealEstateNumber = _REObjectAddress.InternalRealEstateNumber

  association [1..*] to I_RESrvcGrpToContractAssgmt    as _RESrvcGrpToContractAssgmt    on  $projection.REStatusObject = _RESrvcGrpToContractAssgmt.REStatusObjectSource

  //   parent

  association [0..1] to I_REIntegrationObject          as _REParentIntegrationObject    on  $projection.REParentIntRealEstateNumber = _REParentIntegrationObject.InternalRealEstateNumber
  //  children

  association [0..*] to I_RESrvcGrpObjectRelation      as _RESrvcGrpObjectRelation      on  $projection.InternalRealEstateNumber = _RESrvcGrpObjectRelation.InternalRealEstateNumber
  association [0..*] to I_RESrvcGrpSettlementRule      as _RESrvcGrpSettlementRule      on  $projection.InternalRealEstateNumber = _RESrvcGrpSettlementRule.InternalRealEstateNumber
  association [0..*] to I_RESrvcGrpSettlmtRule2CostCat as _RESrvcGrpSettlmtRule2CostCat on  $projection.InternalRealEstateNumber = _RESrvcGrpSettlmtRule2CostCat.InternalRealEstateNumber
  association [0..*] to I_REApportionmentRule          as _REApportionmentRule          on  $projection.InternalRealEstateNumber = _REApportionmentRule.InternalRealEstateNumber
  association [0..*] to I_REDenominatorRule            as _REDenominatorRule            on  $projection.InternalRealEstateNumber = _REDenominatorRule.InternalRealEstateNumber
  //  association [0..*] to I_REIntegObjectRelationPartial as _REIntegObjectRelationPartial on  $projection.InternalRealEstateNumber = _REIntegObjectRelationPartial.InternalRealEstateNumber

  association [0..*] to I_REPartnerAssgmt              as _REPartnerAssgmt              on  $projection.InternalRealEstateNumber = _REPartnerAssgmt.InternalRealEstateNumber
  association [0..*] to I_REObjectAssgmt               as _REObjectAssgmt               on  $projection.REStatusObject = _REObjectAssgmt.REStatusObjectSource
  association [0..*] to I_REReminderObjRule            as _REReminderRule               on  $projection.InternalRealEstateNumber = _REReminderRule.InternalRealEstateNumber
//  association [0..*] to I_REServiceGroupMeasurement    as _REMeasurement                on  $projection.InternalRealEstateNumber = _REMeasurement.InternalRealEstateNumber

  association [0..*] to I_REServiceGroupAcctObjAssgmt  as _REServiceGroupAcctObjAssgmt  on  $projection.InternalRealEstateNumber = _REServiceGroupAcctObjAssgmt.InternalRealEstateNumber
  //  Extensibility

  association [1..1] to E_REServiceGroup               as _Extension                    on  $projection.InternalRealEstateNumber = _Extension.InternalRealEstateNumber
{
  key intreno       as InternalRealEstateNumber,
      @ObjectModel.foreignKey.association: '_StatusObject'
      objnr         as REStatusObject,
      sgnr          as RealEstateServiceGroupNumber,
      @ObjectModel.foreignKey.association: '_REServiceGroupType'
      sgtype        as REServiceGroupType,
      @ObjectModel.foreignKey.association: '_REServiceGroupCategory'
      sgcategory    as REServiceGroupCategory,
      sgxstext      as REServiceGroupName,
      sgxltext      as REServiceGroupLongName,
      parentintreno as REParentIntRealEstateNumber,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      bukrs         as CompanyCode,
      rerf          as CreatedByUser,
      derf          as CreationDate,
      terf          as CreationTime,
      reher         as RESourceOfCreation,
      rbear         as LastChangedByUser,
      dbear         as LastChangeDate,
      tbear         as LastChangeTime,
      rbher         as RESourceOfChange,
      responsible   as Responsible,
      @ObjectModel.foreignKey.association: '_REAuthorizationGroup'
      authgrp       as REAuthorizationGroup,

      _CreatedByUser,
      _ChangedByUser,
      _ResponsibleUser,
      _REAuthorizationGroup,
      _REServiceGroupType,
      _REServiceGroupCategory,
      _REKeyAssgmt,
      _StatusObject,
      _StatusObjectStatus,
      _REParentIntegrationObject,
      _CompanyCode,
      _REPartnerAssgmt,
      _REObjectAssgmt,
      _REReminderRule,
//      _REMeasurement,

      _RESrvcGrpObjectRelation,
      _RESrvcGrpToContractAssgmt,
      _REServiceGroupAcctObjAssgmt,
      _RESrvcGrpSettlementRule,
      _RESrvcGrpSettlmtRule2CostCat,
      _REApportionmentRule,
      _REDenominatorRule
}

Depth:

I_REServiceGroupBasicData view_entity

vicssg

I_REIntegObjectObject2SrvcGrp view_entity
I_REServiceGroup view_entity
I_REServiceGroupValidity view_entity