I_REObjectToObjectGroup

DDL: I_REOBJECTTOOBJECTGROUP SQL: IREOBJOBJGRPASMT Type: view BASIC

Object to Object Group Assignments

I_REObjectToObjectGroup is a Basic CDS View that provides data about "Object to Object Group Assignments" in SAP S/4HANA. It reads from 1 data source (vibdobjass) and exposes 9 fields with key fields REStatusObjectSource, REObjectAssignmentType, REStatusObjectTarget, ValidityStartDate. It has 3 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
vibdobjass vibdobjass from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_REObjectGroup _REObjectGroup $projection.REStatusObjectSource = _REObjectGroup.InternalRealEstateNumber or $projection.REStatusObjectTarget = _REObjectGroup.InternalRealEstateNumber
[1..1] I_REObjectAssgmt _REObjectAssgmt $projection.REStatusObjectSource = _REObjectAssgmt.REStatusObjectTarget and _REObjectAssgmt.REObjectAssignmentType = '10'
[1..1] I_REObjectAssignmentType _REObjectAssignmentType $projection.REObjectAssignmentType = _REObjectAssignmentType.REObjectAssignmentType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IREOBJOBJGRPASMT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Object to Object Group Assignments view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY REStatusObjectSource objnrsrc
KEY REObjectAssignmentType objasstype
KEY REStatusObjectTarget objnrtrg
KEY ValidityStartDate ValidityStartDate
REStatusObjectParent _REObjectAssgmt REStatusObjectSource
REGroupNumber _REObjectGroup REGroupNumber
REObjectGroupName _REObjectGroup REObjectGroupName
_REObjectGroup _REObjectGroup
_REObjectAssignmentType _REObjectAssignmentType 
@AbapCatalog.sqlViewName: 'IREOBJOBJGRPASMT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Object to Object Group Assignments'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

@VDM.viewType: #BASIC
//@Search.searchable: true

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

define view I_REObjectToObjectGroup
  as select from vibdobjass

  association [1..1] to I_REObjectGroup          as _REObjectGroup          on $projection.REStatusObjectSource = _REObjectGroup.InternalRealEstateNumber
                                                                            or $projection.REStatusObjectTarget = _REObjectGroup.InternalRealEstateNumber
  association [1..1] to I_REObjectAssgmt         as _REObjectAssgmt         on $projection.REStatusObjectSource = _REObjectAssgmt.REStatusObjectTarget and
                                                                               _REObjectAssgmt.REObjectAssignmentType = '10'
  association [1..1] to I_REObjectAssignmentType as _REObjectAssignmentType on $projection.REObjectAssignmentType = _REObjectAssignmentType.REObjectAssignmentType
{

  key objnrsrc                         as REStatusObjectSource,
      @ObjectModel.foreignKey.association: '_REObjectAssignmentType'
  key objasstype                       as REObjectAssignmentType,
  key objnrtrg                         as REStatusObjectTarget,
      @EndUserText.label: 'ValidityStartDate'
  key cast( validfrom as dats )        as ValidityStartDate,
  _REObjectAssgmt.REStatusObjectSource as REStatusObjectParent,
      //      @EndUserText.label: 'ValidityEndDate'

      //      cast( validto as dats )   as ValidityEndDate,

      //      assignonlyinfo            as REOnlyInfoAssgmt,

      //      objnrsrcarch              as REStatusObjectSourceIsArchived,

      //        @ObjectModel.foreignKey.association: '_REGenerationType'

      //      flgentype                 as REGenerationType,

      //      ismainasset               as REIsMainAsset,

      //      ismultiassgen             as REAssignmentHasMultiple,

      //      possdatefrom              as REObjectPossessionStartDate,

      //      possdateto                as REObjectPossessionEndDate,


      _REObjectGroup.REGroupNumber     as REGroupNumber,
      _REObjectGroup.REObjectGroupName as REObjectGroupName,

      _REObjectGroup,
      _REObjectAssignmentType

}
where
//  objasstype = '10' or

  objasstype = '11'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_REOBJECTASSGMT",
"I_REOBJECTGROUP",
"VIBDOBJASS"
],
"ASSOCIATED":
[
"I_REOBJECTASSGMT",
"I_REOBJECTASSIGNMENTTYPE",
"I_REOBJECTGROUP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More