I_REObjectByIntFinNumber

DDL: I_REOBJECTBYINTFINNUMBER SQL: IREOBJBYFINUM Type: view BASIC

Real Estate Obj by Internal FIN Number

I_REObjectByIntFinNumber is a Basic CDS View that provides data about "Real Estate Obj by Internal FIN Number" in SAP S/4HANA. It reads from 1 data source (I_REKeyAssgmt) and exposes 15 fields with key field REInternalFinNumber. It has 1 association to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_REKeyAssgmt _REKeyAssgmt from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_REObjectTypeText _REObjectTypeText _REObjectTypeText.RealEstateObjectType = $projection.RealEstateObjectType and _REObjectTypeText.Language = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IREOBJBYFINUM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Obj by Internal FIN Number 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
ObjectModel.representativeKey REInternalFinNumber view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY REInternalFinNumber REInternalFinNumber
REStatusObject REStatusObject
InternalRealEstateNumber InternalRealEstateNumber
RealEstateObjectType RealEstateObjectType
REIdentificationKey REIdentificationKey
CompanyCode CompanyCode
RealEstateContract RealEstateContract
REBusinessEntity REBusinessEntity
RERentalObject RERentalObject
RealEstateBuilding RealEstateBuilding
RealEstateProperty RealEstateProperty
REServiceChargeKey REServiceChargeKey
RESettlementUnitID RESettlementUnitID
_REObjectType _REObjectType
_CompanyCode _CompanyCode 
@AbapCatalog.sqlViewName: 'IREOBJBYFINUM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Obj by Internal FIN Number'

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'REInternalFinNumber'
@ObjectModel.semanticKey: [ 'InternalRealEstateNumber' ]
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET] 
@Metadata.ignorePropagatedAnnotations: true

define view I_REObjectByIntFinNumber
  as select from I_REKeyAssgmt as _REKeyAssgmt
  association [0..1] to I_REObjectTypeText as _REObjectTypeText on  _REObjectTypeText.RealEstateObjectType = $projection.RealEstateObjectType
                                                                and _REObjectTypeText.Language             = $session.system_language
{
  key       REInternalFinNumber,
            REStatusObject,
            InternalRealEstateNumber,
            RealEstateObjectType,
            REIdentificationKey,
            cast(
            concat_with_space(_REObjectTypeText.REObjectTypePrefix,
            REIdentificationKey,1 ) as recaident) as REIdentification,
            cast(
            concat_with_space(_REObjectTypeText.RealEstateObjectTypeName,
            REIdentificationKey,1 ) as recaident) as REAccountingObjectName,
            CompanyCode,
            RealEstateContract,
            REBusinessEntity,
            RERentalObject,
            RealEstateBuilding,
            RealEstateProperty,
            REServiceChargeKey,
            RESettlementUnitID,

            _REObjectType,
            _CompanyCode
}
where
  REInternalFinNumber is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_REKEYASSGMT",
"I_REOBJECTTYPETEXT"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_REOBJECTTYPE",
"I_REOBJECTTYPETEXT"
],
"BASE":
[
"I_REKEYASSGMT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More