I_REKEYASSGMT

CDS View

Real Estate Key Assgmt

I_REKEYASSGMT is a CDS View in S/4HANA. Real Estate Key Assgmt. It contains 13 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 13 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_REObjectByIntFinNumber view from BASIC Real Estate Obj by Internal FIN Number
I_REObjectByStatusObject view from COMPOSITE Real Estate Object by Status Object
I_REObjectTypeDetails view from COMPOSITE Real Estate Object Type Details

Fields (13)

KeyField CDS FieldsUsed in Views
ArchitecturalObject ArchitecturalObject 1
CompanyCode CompanyCode 1
RealEstateBuilding RealEstateBuilding 1
RealEstateContract RealEstateContract 1
RealEstateObjectType RealEstateObjectType 1
RealEstateProperty RealEstateProperty 1
REBusinessEntity REBusinessEntity 1
REIdentificationKey REIdentificationKey 1
REInternalFinNumber REInternalFinNumber 1
RERentalObject RERentalObject 1
REServiceChargeKey REServiceChargeKey 1
RESettlementUnitID RESettlementUnitID 1
REStatusObject REStatusObjectParent 1 
@AbapCatalog.sqlViewName: 'IREKEYASS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Key Assgmt'

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'InternalRealEstateNumber'
@ObjectModel.semanticKey: [ 'InternalRealEstateNumber' ]

define view I_REKeyAssgmt
  as select from vicaintreno as _REKeyAssgmt

  association [1..1] to I_REObjectType as _REObjectType on $projection.RealEstateObjectType = _REObjectType.RealEstateObjectType
  association [1..1] to I_CompanyCode  as _CompanyCode  on $projection.CompanyCode = _CompanyCode.CompanyCode

{
  key       intreno                                      as InternalRealEstateNumber,
            @ObjectModel.foreignKey.association: '_REObjectType'
            objtype                                      as RealEstateObjectType,
            identkey                                     as REIdentificationKey,
            objnr                                        as REStatusObject,
            cast(imkey as recaimkeyfi preserving type )  as REInternalFinNumber,
            @ObjectModel.foreignKey.association: '_CompanyCode'
            bukrs                                        as CompanyCode,
            cast(recnnr as recnvdmcnnr preserving type ) as RealEstateContract, 
            cast(swenr as rebdvdmbeno  preserving type ) as REBusinessEntity,
            cast(smenr as rebdvdmrono preserving type )  as RERentalObject,
            cast(sgenr as rebdvdmbuno preserving type )  as RealEstateBuilding,
            cast(sgrnr as rebdvdmprno preserving type )  as RealEstateProperty,
            aoid                                         as ArchitecturalObject,
            //PGID

            cast(snksl as rescvdmsckey preserving type ) as REServiceChargeKey,
            cast(sempsl as rescvdmsuid preserving type ) as RESettlementUnitID,
            //COMPGRP

            _REObjectType,
            _CompanyCode

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VICAINTRENO"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_REOBJECTTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More