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 31 fields. Key fields: REServiceGroupUUID.

I_REServiceGroupBasicData

DDL: I_RESERVICEGROUPBASICDATA SQL: IRESERVICEGRPBSC Type: view_entity BASIC Package: VDM_RE_CS

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 31 fields with key field REServiceGroupUUID. It has 15 associations to related views. Part of development package VDM_RE_CS.

Data Sources (1)

Source	Alias	Join Type
vicssg	vicssg	from

Associations (15)

Cardinality	Target	Alias	Condition
[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_REArchitectureObject	_REArchitectureObject	`$projection.REServiceGroupParentUUID = _REArchitectureObject.REArchitectureObjectUUID`
[0..*]	I_RESrvcGrpSettlementRule	_RESrvcGrpSettlementRule	`$projection.REServiceGroupUUID = _RESrvcGrpSettlementRule.REServiceGroupUUID`
[0..*]	I_RESrvcGrpSettlmtRule2CostCat	_RESrvcGrpSettlmtRule2CostCat	`$projection.REServiceGroupUUID = _RESrvcGrpSettlmtRule2CostCat.REServiceGroupUUID`
[0..*]	I_REApportionmentRule	_REApportionmentRule	`$projection.REServiceGroupUUID = _REApportionmentRule.REServiceGroupUUID`
[0..*]	I_RESrvcGrpDenominatorRule	_REDenominatorRule	`$projection.REServiceGroupUUID = _REDenominatorRule.REServiceGroupUUID`
[0..*]	I_REServiceGroupAcctObjAssgmt	_REServiceGroupAcctObjAssgmt	`$projection.REServiceGroupUUID = _REServiceGroupAcctObjAssgmt.REServiceGroupUUID`
[1..1]	E_REServiceGroup	_Extension	`$projection.REServiceGroupUUID = _Extension.REServiceGroupUUID`

Annotations (8)

Name	Value	Level
EndUserText.label	Real Estate Service Group	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.representativeKey	REServiceGroupUUID	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 (31)

Key	Field	Source Field
KEY	REServiceGroupUUID	objectuuid
	InternalRealEstateNumber	intreno
	REStatusObject	objnr
	REServiceGroupOID	oid
	RealEstateServiceGroupNumber	sgnr
	REServiceGroupAlternativeID	alternativeid
	REServiceGroupName	name
	CompanyCode	bukrs
	REServiceGroupParentUUID	parentobjectuuid
	REServiceGroupType	sgtype
	REServiceGroupCategory	sgcategory
	REAuthorizationGroup	authgrp
	ValidityStartDate	validfrom
	ValidityEndDate	validto
	CreationDateTime	creationdatetime
	LastChangeDateTime	lastchangedatetime
	LocalLastChangeDateTime	locallastchangedatetime
	_REAuthorizationGroup	_REAuthorizationGroup
	_REServiceGroupType	_REServiceGroupType
	_REServiceGroupCategory	_REServiceGroupCategory
	_REKeyAssgmt	_REKeyAssgmt
	_StatusObject	_StatusObject
	_StatusObjectStatus	_StatusObjectStatus
	_REArchitectureObject	_REArchitectureObject
	_CompanyCode	_CompanyCode
	_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: 'REServiceGroupUUID'
@ObjectModel.semanticKey: ['RealEstateServiceGroupNumber']
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.privilegedAssociations: ['_StatusObjectStatus', '_StatusObject']
//@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 [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 [1..*] to I_RESrvcGrpToContractAssgmt    as _RESrvcGrpToContractAssgmt    on  $projection.REStatusObject = _RESrvcGrpToContractAssgmt.REStatusObjectSource

  //   Parent Architecture Object

  association [0..1] to I_REArchitectureObject         as _REArchitectureObject         on  $projection.REServiceGroupParentUUID = _REArchitectureObject.REArchitectureObjectUUID
  //  children

  association [0..*] to I_RESrvcGrpSettlementRule      as _RESrvcGrpSettlementRule      on  $projection.REServiceGroupUUID = _RESrvcGrpSettlementRule.REServiceGroupUUID
  association [0..*] to I_RESrvcGrpSettlmtRule2CostCat as _RESrvcGrpSettlmtRule2CostCat on  $projection.REServiceGroupUUID = _RESrvcGrpSettlmtRule2CostCat.REServiceGroupUUID
  association [0..*] to I_REApportionmentRule          as _REApportionmentRule          on  $projection.REServiceGroupUUID = _REApportionmentRule.REServiceGroupUUID
  association [0..*] to I_RESrvcGrpDenominatorRule     as _REDenominatorRule            on  $projection.REServiceGroupUUID = _REDenominatorRule.REServiceGroupUUID
  association [0..*] to I_REServiceGroupAcctObjAssgmt  as _REServiceGroupAcctObjAssgmt  on  $projection.REServiceGroupUUID = _REServiceGroupAcctObjAssgmt.REServiceGroupUUID
  //  Extensibility

  association [1..1] to E_REServiceGroup               as _Extension                    on  $projection.REServiceGroupUUID = _Extension.REServiceGroupUUID
{
  key objectuuid              as REServiceGroupUUID,
      intreno                 as InternalRealEstateNumber,
      @ObjectModel.foreignKey.association: '_StatusObject'
      objnr                   as REStatusObject,
      oid                     as REServiceGroupOID,
      sgnr                    as RealEstateServiceGroupNumber,
      alternativeid           as REServiceGroupAlternativeID,
      name                    as REServiceGroupName,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      bukrs                   as CompanyCode,
      parentobjectuuid        as REServiceGroupParentUUID,
      @ObjectModel.foreignKey.association: '_REServiceGroupType'
      sgtype                  as REServiceGroupType,
      @ObjectModel.foreignKey.association: '_REServiceGroupCategory'
      sgcategory              as REServiceGroupCategory,
      @ObjectModel.foreignKey.association: '_REAuthorizationGroup'
      authgrp                 as REAuthorizationGroup,
      validfrom               as ValidityStartDate,
      validto                 as ValidityEndDate,
      @Semantics.systemDateTime.createdAt: true
      creationdatetime        as CreationDateTime,
      @Semantics.systemDateTime.lastChangedAt: true
      lastchangedatetime      as LastChangeDateTime,
      @Semantics.systemDateTime.localInstanceLastChangedAt: true
      locallastchangedatetime as LocalLastChangeDateTime,

      _REAuthorizationGroup,
      _REServiceGroupType,
      _REServiceGroupCategory,
      _REKeyAssgmt,
      _StatusObject,
      _StatusObjectStatus,
      _REArchitectureObject,
      _CompanyCode,
      _RESrvcGrpToContractAssgmt,
      _REServiceGroupAcctObjAssgmt,
      _RESrvcGrpSettlementRule,
      _RESrvcGrpSettlmtRule2CostCat,
      _REApportionmentRule,
      _REDenominatorRule
}

Depth:

I_REServiceGroupBasicData view_entity

vicssg