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_entity 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'

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Key Assgmt'
@Analytics.internalName: #LOCAL
@ObjectModel: {
  representativeKey: 'InternalRealEstateNumber',
  semanticKey: ['InternalRealEstateNumber'],
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #L
  },
  modelingPattern: #NONE,
  supportedCapabilities: [
    #CDS_MODELING_ASSOCIATION_TARGET
  ]
}
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC

define view entity 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

}

Learn More