I_REIntegrationObjectStatusObj

DDL: I_REINTEGRATIONOBJECTSTATUSOBJ SQL: IREINTOBJSTAT Type: view COMPOSITE

Real Estate Integration Object Status

I_REIntegrationObjectStatusObj is a Composite CDS View that provides data about "Real Estate Integration Object Status" in SAP S/4HANA. It reads from 1 data source (I_REIntegrationObjectBasicData) and exposes 8 fields with key fields InternalRealEstateNumber, REStatusObject, StatusProfile, StatusCode.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_REIntegrationObjectBasicData _REIntegrationObject from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IREINTOBJSTAT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Integration Object Status view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber I_REIntegrationObjectBasicData InternalRealEstateNumber
KEY REStatusObject I_REIntegrationObjectBasicData REStatusObject
KEY StatusProfile _StatusObjectStatus StatusProfile
KEY StatusCode _StatusObjectStatus StatusCode
IsUserStatus
StatusIsInactive
_StatusCode _StatusObjectStatus _StatusCode
_StatusProfile _StatusObjectStatus _StatusProfile 
@AbapCatalog.sqlViewName: 'IREINTOBJSTAT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Integration Object Status'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true

define view I_REIntegrationObjectStatusObj
    as select from I_REIntegrationObjectBasicData as _REIntegrationObject
    left outer to many join I_StatusObjectStatus as _StatusObjectStatus on _REIntegrationObject.REStatusObject = _StatusObjectStatus.StatusObject
{
  key _REIntegrationObject.InternalRealEstateNumber,
  key _REIntegrationObject.REStatusObject,
      @ObjectModel.foreignKey.association: '_StatusProfile'
  key _StatusObjectStatus.StatusProfile                                                 as StatusProfile,
      @ObjectModel.foreignKey.association: '_StatusCode'
  key _StatusObjectStatus.StatusCode                                                    as StatusCode,
  
      cast(_StatusObjectStatus.IsUserStatus as recavdmisuserstatus preserving type )    as IsUserStatus,
      cast(_StatusObjectStatus.StatusIsInactive as recavdmstatusinact preserving type ) as StatusIsInactive,

      _StatusObjectStatus._StatusCode                                                   as _StatusCode,
      _StatusObjectStatus._StatusProfile                                                as _StatusProfile

}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_REINTEGRATIONOBJECTBASICDATA",
"I_STATUSOBJECTSTATUS"
],
"ASSOCIATED":
[
"I_STATUSCODE",
"I_STATUSPROFILE"
],
"BASE":
[
"I_STATUSOBJECTSTATUS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More