R_REUsableObjectTP

DDL: R_REUSABLEOBJECTTP Type: view_entity TRANSACTIONAL Package: RAP_RE_GO

Real Estate Usable Object TP

R_REUsableObjectTP is a Transactional CDS View that provides data about "Real Estate Usable Object TP" in SAP S/4HANA. It reads from 1 data source (I_REUsableObject) and exposes 43 fields with key field RealEstateUsableObjectUUID. It has 8 associations to related views. Part of development package RAP_RE_GO.

Data Sources (1)

SourceAliasJoin Type
I_REUsableObject _REUsableObject from

Associations (8)

CardinalityTargetAliasCondition
[0..*] I_ChangeDocument_2 _REUsableObjectChgDoc _REUsableObjectChgDoc.ChangeDocObjectClass = 'REGO_REGO' and _REUsableObjectChgDoc.ChangeDocObject = $projection.ChangeDocObject
[1..*] R_REUsblObjLdngAcctAssgmtObjTP _REUsblObjLdngAcctAssgmtObj
[1..*] R_REUsblObjAddlAcctAssgmtObjTP _REUsblObjAddlAcctAssgmtObj
[0..*] R_REUsableObjectMeasurementTP _REUsableObjectMeasurement
[0..*] R_REUsableObjectStatusObjectTP _REUsableObjectStatusObject
[0..*] R_REUsblObjToContractAssgmtTP _REUsblObjToContractAssgmt
[0..*] R_REUsblObjArchtrUsageTP _REUsblObjArchitectureUsage
[0..*] R_REUsblObjToRntblObjAssgmtTP _REUsblObjToRntblObjAssgmt

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Real Estate Usable Object TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name RealEstateUsableObject view
ObjectModel.objectIdentifier.oidElement RealEstateUsableObjectOID view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY RealEstateUsableObjectUUID RealEstateUsableObjectUUID
REGenericRentalObjectType REGenericRentalObjectType
InternalRealEstateNumber InternalRealEstateNumber
REStatusObject REStatusObject
RealEstateUsableObjectOID RealEstateUsableObjectOID
RealEstateUsableObjectNumber RealEstateUsableObjectNumber
REUsableObjectNumberForEdit RealEstateUsableObjectNumber
REGnrcRntlObjectAlternativeID REGnrcRntlObjectAlternativeID
REUsableObjectName REUsableObjectName
REIdentificationKey REIdentificationKey
CompanyCode CompanyCode
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
REAuthorizationGroup REAuthorizationGroup
REGnrcRentalObjUsageCategory REGnrcRentalObjUsageCategory
REGenericRentalObjectUsageType REGenericRentalObjectUsageType
REGnrcRentalObjPortfolioID REGnrcRentalObjPortfolioID
REGnrcRentalObjOwnershipID REGnrcRentalObjOwnershipID
REGenericRentalObjParentUUID REGenericRentalObjParentUUID
REArchtrObjectNumberBldngLand
StatusProfile _StatusObject StatusProfile
CreationDateTime CreationDateTime
LastChangeDateTime LastChangeDateTime
LocalLastChangeDateTime LocalLastChangeDateTime
ChangeDocObject
_CompanyCode _CompanyCode
_REAuthorizationGroup _REAuthorizationGroup
_REGnrcRentalObjUsageCategory _REGnrcRentalObjUsageCategory
_REGnrcRentalObjUsageType _REGnrcRentalObjUsageType
_REGnrcRentalObjPortfolio _REGnrcRentalObjPortfolio
_REGnrcRentalObjOwnership _REGnrcRentalObjOwnership
_REArchitectureObject _REArchitectureObject
_StatusObject _StatusObject
_StatusObjectStatus _StatusObjectStatus
_REGenericRentalObjectType _REGenericRentalObjectType
_REUsblObjLdngAcctAssgmtObj _REUsblObjLdngAcctAssgmtObj
_REUsblObjAddlAcctAssgmtObj _REUsblObjAddlAcctAssgmtObj
_REUsableObjectMeasurement _REUsableObjectMeasurement
_REUsableObjectStatusObject _REUsableObjectStatusObject
_REUsblObjToContractAssgmt _REUsblObjToContractAssgmt
_REUsblObjArchitectureUsage _REUsblObjArchitectureUsage
_REUsblObjToRntblObjAssgmt _REUsblObjToRntblObjAssgmt
_REUsableObjectChgDoc _REUsableObjectChgDoc
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.privilegedAssociations: ['_REUsableObjectChgDoc']
@EndUserText.label: 'Real Estate Usable Object TP'
@ObjectModel.usageType: {
        serviceQuality: #C,
        dataClass: #TRANSACTIONAL,
        sizeCategory: #XL
    }

@VDM: {
    viewType: #TRANSACTIONAL,
    lifecycle.contract.type: #SAP_INTERNAL_API,
    usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
    }
@ObjectModel.sapObjectNodeType.name: 'RealEstateUsableObject'
@ObjectModel.objectIdentifier.oidElement: 'RealEstateUsableObjectOID'
@ObjectModel.alternativeKey: [{ element: [ 'RealEstateUsableObjectOID' ], id: 'OID', uniqueness: #UNIQUE_IF_NOT_INITIAL }]
define root view entity R_REUsableObjectTP
  as select from I_REUsableObject as _REUsableObject
  composition [1..*] of R_REUsblObjLdngAcctAssgmtObjTP as _REUsblObjLdngAcctAssgmtObj
  composition [1..*] of R_REUsblObjAddlAcctAssgmtObjTP as _REUsblObjAddlAcctAssgmtObj
  composition [0..*] of R_REUsableObjectMeasurementTP  as _REUsableObjectMeasurement
  composition [0..*] of R_REUsableObjectStatusObjectTP as _REUsableObjectStatusObject
  composition [0..*] of R_REUsblObjToContractAssgmtTP  as _REUsblObjToContractAssgmt
  composition [0..*] of R_REUsblObjArchtrUsageTP       as _REUsblObjArchitectureUsage
  composition [0..*] of R_REUsblObjToRntblObjAssgmtTP  as _REUsblObjToRntblObjAssgmt
  
  //  Change Documents

  association [0..*] to I_ChangeDocument_2             as _REUsableObjectChgDoc on _REUsableObjectChgDoc.ChangeDocObjectClass = 'REGO_REGO'
                                                                                and _REUsableObjectChgDoc.ChangeDocObject = $projection.ChangeDocObject
{
  key RealEstateUsableObjectUUID,
      REGenericRentalObjectType,
      InternalRealEstateNumber,
      REStatusObject,
      RealEstateUsableObjectOID,
      RealEstateUsableObjectNumber,
      @ObjectModel.editableFieldFor: 'RealEstateUsableObjectNumber'
      RealEstateUsableObjectNumber as REUsableObjectNumberForEdit,
      REGnrcRntlObjectAlternativeID,   
      REUsableObjectName,
      REIdentificationKey,
      CompanyCode,
      ValidityStartDate,
      ValidityEndDate,
      REAuthorizationGroup,
      REGnrcRentalObjUsageCategory,
      REGenericRentalObjectUsageType,
      REGnrcRentalObjPortfolioID,
      REGnrcRentalObjOwnershipID,
      REGenericRentalObjParentUUID,
      cast (_REArchitectureObject.REArchitectureObjectNumber as reobvdmobnrbuildingland preserving type ) as REArchtrObjectNumberBldngLand,
      _StatusObject.StatusProfile,
      CreationDateTime,
      LastChangeDateTime,
      LocalLastChangeDateTime,
      
      // convert the UUID into string to use in ON condition in association to change documents

      cast( bintohex( RealEstateUsableObjectUUID ) as cdobjectv ) as ChangeDocObject,

      /* Associations */
      _CompanyCode,
      _REAuthorizationGroup,
      _REGnrcRentalObjUsageCategory,
      _REGnrcRentalObjUsageType,
      _REGnrcRentalObjPortfolio,
      _REGnrcRentalObjOwnership,
      _REArchitectureObject,
      _StatusObject,
      _StatusObjectStatus,
      _REGenericRentalObjectType,

      /* Compositions */
      _REUsblObjLdngAcctAssgmtObj,
      _REUsblObjAddlAcctAssgmtObj,
      _REUsableObjectMeasurement,
      _REUsableObjectStatusObject,
      _REUsblObjToContractAssgmt,
      _REUsblObjArchitectureUsage,
      @Semantics.valueRange.maximum: '1'
      _REUsblObjToRntblObjAssgmt,
      _REUsableObjectChgDoc
}