I_REUSABLEOBJECT

CDS View

Real Estate Usable Object

I_REUSABLEOBJECT is a CDS View in S/4HANA. Real Estate Usable Object. It contains 5 fields. 17 CDS views read from this table.

Used by 17 CDS view(s) 5 fields

CDS Views using this table (17)

ViewTypeJoinVDMDescription
C_REUsableObjectDEX view_entity from CONSUMPTION Extraction RE Usable Object
C_REUsableObjectMeasurementDEX view_entity inner CONSUMPTION Extractor for RE Usable Obj Measurement
C_REUsblObjAddlAcctAssgmtDEX view_entity inner CONSUMPTION Extractor RE Usbl Obj Addl Acct Assign
C_REUsblObjLdngAcctAssgmtDEX view_entity inner CONSUMPTION Extractor RE Usbl Obj Ldng Acct Assign
ESH_N_REUSBLOBJ view from Anchor view -REUSBLOBJ
I_REArchtrObjectUsageHNRltn view_entity from COMPOSITE RE Architecture Object Usage Hierarchy Node Relation
I_REUsableObjectMeasurement view_entity inner COMPOSITE Real Estate Usable Object Measurement
I_REUsableObjectVH view_entity from COMPOSITE Real Estate Usable Object
I_REUsblObjAddlAcctAssgmtObj view_entity inner COMPOSITE RE Usable Object Addl Account Assign
I_REUsblObjectToContractAssgmt view_entity inner COMPOSITE RE Usable Object Contract Assignment
I_REUsblObjLdngAcctAssgmtObj view_entity inner COMPOSITE RE Usable Object Leading Account Assign
P_REArchtrObjAssgmtCalc4 view_entity inner COMPOSITE RE AO Controlling Object Assgmt Calc 4
P_REArchtrObjAssgmtCalc6 view_entity inner COMPOSITE RE Review Booklet: Relevant Account Assignment Objects
R_REUsableObjectMeasurementTP view_entity inner TRANSACTIONAL RE Usable Object Measurement TP
R_REUsableObjectTP view_entity from TRANSACTIONAL Real Estate Usable Object TP
R_REUsblObjAddlAcctAssgmtObjTP view_entity inner TRANSACTIONAL RE Usable Object Addl Account Assign TP
R_REUsblObjLdngAcctAssgmtObjTP view_entity inner TRANSACTIONAL RE Usable Object Leading Account Assign TP

Fields (5)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY RealEstateUsableObjectUUID RealEstateUsableObjectUUID 11
KEY ValidityStartDate UsableObjectStartDate,ValidityStartDate 1
REGnrcRentalObjUsageCategory REGnrcRentalObjUsageCategory 1
ValidityEndDate UsableObjectEndDate,ValidityEndDate 1 
@AccessControl: {
  authorizationCheck: #MANDATORY,
  privilegedAssociations: ['_StatusObject', '_StatusObjectStatus']
}
@EndUserText.label: 'Real Estate Usable Object'
@Analytics: {
  dataCategory: #DIMENSION,
  internalName: #LOCAL,
  dataExtraction.enabled: true
}
@ObjectModel: {
  representativeKey: 'RealEstateUsableObjectUUID',
  semanticKey: ['RealEstateUsableObjectNumber'],
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #L
  },
  modelingPattern: #ANALYTICAL_DIMENSION,
  supportedCapabilities: [
    #ANALYTICAL_DIMENSION, 
    #CDS_MODELING_ASSOCIATION_TARGET,
    #EXTRACTION_DATA_SOURCE
  ],
  objectIdentifier.oidElement: 'RealEstateUsableObjectOID',
  sapObjectNodeType.name: 'RealEstateUsableObject'
}
@ODM.oid: 'RealEstateUsableObjectOID'
@Metadata: {
  allowExtensions: true,
  ignorePropagatedAnnotations: true
}
@VDM.viewType: #COMPOSITE

define view entity I_REUsableObject
  as select from I_REGenericRentalObject

  association [0..*] to I_RERntblObjToUsblObjAssgmt as _REUsblObjToRntblObjAssgmt on $projection.RealEstateUsableObjectUUID = _REUsblObjToRntblObjAssgmt.RealEstateUsableObjectUUID
  association [0..*] to I_REUsblObjToRntblObjAssgmt as _RERntblObjToUsblObjAssgmt on $projection.RealEstateUsableObjectUUID = _RERntblObjToUsblObjAssgmt.RealEstateUsableObjectUUID

  association [0..*] to I_REUsableObjectMeasurement  as _REUsableObjectMeasurement  on $projection.RealEstateUsableObjectUUID = _REUsableObjectMeasurement.RealEstateUsableObjectUUID
  association [0..*] to I_REUsblObjLdngAcctAssgmtObj as _REUsblObjLdngAcctAssgmtObj on $projection.RealEstateUsableObjectUUID = _REUsblObjLdngAcctAssgmtObj.RealEstateUsableObjectUUID
  association [0..*] to I_REUsblObjAddlAcctAssgmtObj as _REUsblObjAddlAcctAssgmtObj on $projection.RealEstateUsableObjectUUID = _REUsblObjAddlAcctAssgmtObj.RealEstateUsableObjectUUID
  association [0..*] to I_REUsblObjArchtrUsage       as _REUsblObjArchtrUsage       on $projection.RealEstateUsableObjectUUID = _REUsblObjArchtrUsage.RealEstateUsableObjectUUID
  association [0..*] to I_REUsableObjectStatusObject as _REUsableObjectStatusObject on $projection.RealEstateUsableObjectUUID = _REUsableObjectStatusObject.RealEstateUsableObjectUUID

{
  key REGenericRentalObjectUUID                                                           as RealEstateUsableObjectUUID,
      @ObjectModel.foreignKey.association: '_REGenericRentalObjectType'
      REGenericRentalObjectType,
      InternalRealEstateNumber,
      @ObjectModel.foreignKey.association: '_StatusObject'
      REStatusObject,
      REGenericRentalObjectOID                                                            as RealEstateUsableObjectOID,
      REGnrcRntlObjectAlternativeID,
      cast( REGenericRentalObjectNumber as regogonrusable preserving type )               as RealEstateUsableObjectNumber,
      cast( REGenericRentalObjectName   as regovdmxusableobject preserving type )         as REUsableObjectName,
      REIdentificationKey,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      CompanyCode,
      ValidityStartDate,
      ValidityEndDate,
      @ObjectModel.foreignKey.association: '_REAuthorizationGroup'
      REAuthorizationGroup,
      @ObjectModel.foreignKey.association: '_REGnrcRentalObjUsageCategory'
      REGnrcRentalObjUsageCategory,
      @ObjectModel.foreignKey.association: '_REGnrcRentalObjUsageType'
      cast( REGenericRentalObjectUsageType as regovdmusableobjusagetype preserving type ) as REGenericRentalObjectUsageType,
      @ObjectModel.foreignKey.association: '_REArchitectureObject'
      REGenericRentalObjParentUUID,
      @ObjectModel.foreignKey.association: '_REGnrcRentalObjPortfolio'
      REGnrcRentalObjPortfolioID,
      @ObjectModel.foreignKey.association: '_REGnrcRentalObjOwnership'
      REGnrcRentalObjOwnershipID,

      @Semantics.systemDateTime.createdAt: true
      CreationDateTime,
      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime,
      @Semantics.systemDateTime.localInstanceLastChangedAt: true
      LocalLastChangeDateTime,

      /* Associations */
      _REKeyAssgmt,
      _CompanyCode,
      _REAuthorizationGroup,
      _REGnrcRentalObjUsageCategory,
      _REGnrcRentalObjUsageType,
      _REGnrcRentalObjOwnership,
      _REGnrcRentalObjPortfolio,
//      _REParentGenericRentalObject,

      _REGenericRentalObjectType,
      _REArchitectureObject,
      _StatusObject,
      _StatusObjectStatus,
      _REUsblObjToRntblObjAssgmt,
      _RERntblObjToUsblObjAssgmt,
      _REUsableObjectMeasurement,
      _REUsblObjLdngAcctAssgmtObj,
      _REUsblObjAddlAcctAssgmtObj,
      _REUsblObjArchtrUsage,
      _REUsableObjectStatusObject
}
where
     REGenericRentalObjectType = 'U' //Usable Object

Learn More