I_REMeasurementType

DDL: I_REMEASUREMENTTYPE SQL: IREMSMTTYPE Type: view BASIC

Measurement Type

I_REMeasurementType is a Basic CDS View (Dimension) that provides data about "Measurement Type" in SAP S/4HANA. It reads from 1 data source (tivbdmeas) and exposes 38 fields with key field REMeasurementType. It has 10 associations to related views.

Data Sources (1)

SourceAliasJoin Type
tivbdmeas tivbdmeas from

Associations (10)

CardinalityTargetAliasCondition
[0..*] I_REMeasurementTypeText _Text $projection.REMeasurementType = _Text.REMeasurementType
[0..1] I_RESettlmtBasicComponent _RESettlmtBasicComponent $projection.RESettlmtBasicComponent = _RESettlmtBasicComponent.RESettlmtBasicComponent
[0..1] I_REMsmtAllowedUsages _REMsmtUsageForArchlObj $projection.REMsmtUsageForArchitecturalObj = _REMsmtUsageForArchlObj.REMsmtAllowedUsages
[0..1] I_REMsmtAllowedUsages _REMsmtUsageForRentalObj $projection.REMsmtUsageForRentalObject = _REMsmtUsageForRentalObj.REMsmtAllowedUsages
[0..1] I_REMsmtAllowedUsages _REMsmtUsageForBusinessEntity $projection.REMsmtUsageForBusinessEntity = _REMsmtUsageForBusinessEntity.REMsmtAllowedUsages
[0..1] I_REMsmtAllowedUsages _REMsmtUsageForLand $projection.REMsmtUsageForLand = _REMsmtUsageForLand.REMsmtAllowedUsages
[0..1] I_REMsmtAllowedUsages _REMsmtUsageForBuilding $projection.REMsmtUsageForBuilding = _REMsmtUsageForBuilding.REMsmtAllowedUsages
[0..1] I_REMsmtAllowedUsages _REMsmtUsageForContract $projection.REMsmtUsageForContract = _REMsmtUsageForContract.REMsmtAllowedUsages
[0..1] I_REMsmtAllowedUsages _REMsmtUsageForParcels $projection.REMsmtUsageForParcels = _REMsmtUsageForParcels.REMsmtAllowedUsages
[0..1] I_REDifferingMeasurement _REDifferingMeasurement $projection.REDifferingMeasurement = _REDifferingMeasurement.REDifferingMeasurement

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IREMSMTTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Measurement Type view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey REMeasurementType view
VDM.viewType #BASIC view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY REMeasurementType meas
REMeasurementIsTotal issummeas
RESettlmtBasicComponent baserate
REMeasurementIsZeroForVacancy setzeroifvacant
REValueIsPresentedAsPercentage ispercent
REMsmtHasEqualApportionment ispropapport
REMsmtIsDeterminedByCndnType getbycondtype
REMsmtTypeIsUsedForConsumption isconsumption
REMeterIsResettable isresetable
REDefaultMeasurementUnit measunitdef
REMsmtUsageForArchitecturalObj usageforao
REMsmtUsageForRentalObject usageforro
REMsmtUsageForBusinessEntity usageforbe
REMsmtUsageForLand usageforpr
REMsmtUsageForBuilding usageforbu
REMsmtUsageForContract usageforcn
REMsmtUsageForParcels usageforpl
REMsmtUsageForGenericObject usageforgo
REMsmtTypeIsAreaMeasurement isspcfactor
REMsmtTypeIsUsedForApprtmt usedforapport
REExcptnRntlObjIsNotPossible disableexceptro
REExcptnArchlObjIsNotPossible disableexceptao
REExcptnContrTypeIsNotPossible disableexceptcn
REDifferingMeasurement objrelprop
RETypeIsRprstvForOwnrShipShare iscoshare
RERefFactorIsRelatedToKeyDate sckeydaterel
RENoCompressionIsActive nocompression
REIsExclForNewAssgmt cuexcludeassign
_Text _Text
_RESettlmtBasicComponent _RESettlmtBasicComponent
_REMsmtUsageForArchlObj _REMsmtUsageForArchlObj
_REMsmtUsageForRentalObj _REMsmtUsageForRentalObj
_REMsmtUsageForBusinessEntity _REMsmtUsageForBusinessEntity
_REMsmtUsageForLand _REMsmtUsageForLand
_REMsmtUsageForBuilding _REMsmtUsageForBuilding
_REMsmtUsageForContract _REMsmtUsageForContract
_REMsmtUsageForParcels _REMsmtUsageForParcels
_REDifferingMeasurement _REDifferingMeasurement
@AbapCatalog.sqlViewName: 'IREMSMTTYPE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName:#LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Measurement Type'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.representativeKey: 'REMeasurementType'
@ObjectModel.semanticKey: ['REMeasurementType']
@VDM.viewType: #BASIC
define view I_REMeasurementType
  as select from tivbdmeas
  association [0..*] to I_REMeasurementTypeText   as _Text                         on $projection.REMeasurementType = _Text.REMeasurementType
  association [0..1] to I_RESettlmtBasicComponent as _RESettlmtBasicComponent      on $projection.RESettlmtBasicComponent = _RESettlmtBasicComponent.RESettlmtBasicComponent
  association [0..1] to I_REMsmtAllowedUsages     as _REMsmtUsageForArchlObj       on $projection.REMsmtUsageForArchitecturalObj = _REMsmtUsageForArchlObj.REMsmtAllowedUsages
  association [0..1] to I_REMsmtAllowedUsages     as _REMsmtUsageForRentalObj      on $projection.REMsmtUsageForRentalObject = _REMsmtUsageForRentalObj.REMsmtAllowedUsages
  association [0..1] to I_REMsmtAllowedUsages     as _REMsmtUsageForBusinessEntity on $projection.REMsmtUsageForBusinessEntity = _REMsmtUsageForBusinessEntity.REMsmtAllowedUsages
  association [0..1] to I_REMsmtAllowedUsages     as _REMsmtUsageForLand           on $projection.REMsmtUsageForLand = _REMsmtUsageForLand.REMsmtAllowedUsages
  association [0..1] to I_REMsmtAllowedUsages     as _REMsmtUsageForBuilding       on $projection.REMsmtUsageForBuilding = _REMsmtUsageForBuilding.REMsmtAllowedUsages
  association [0..1] to I_REMsmtAllowedUsages     as _REMsmtUsageForContract       on $projection.REMsmtUsageForContract = _REMsmtUsageForContract.REMsmtAllowedUsages
  association [0..1] to I_REMsmtAllowedUsages     as _REMsmtUsageForParcels        on $projection.REMsmtUsageForParcels = _REMsmtUsageForParcels.REMsmtAllowedUsages
  //  association [0..1] to I_REMsmtAllowedUsages     as _REMsmtUsageForIntegObject    on $projection.REMsmtUsageForIntegrationObj = _REMsmtUsageForIntegObject.REMsmtAllowedUsages

  association [0..1] to I_REDifferingMeasurement  as _REDifferingMeasurement       on $projection.REDifferingMeasurement = _REDifferingMeasurement.REDifferingMeasurement
{
  key meas            as REMeasurementType,
      issummeas       as REMeasurementIsTotal,
      @ObjectModel.foreignKey.association: '_RESettlmtBasicComponent'
      baserate        as RESettlmtBasicComponent,
      setzeroifvacant as REMeasurementIsZeroForVacancy,
      ispercent       as REValueIsPresentedAsPercentage,
      ispropapport    as REMsmtHasEqualApportionment,
      getbycondtype   as REMsmtIsDeterminedByCndnType,
      isconsumption   as REMsmtTypeIsUsedForConsumption,
      isresetable     as REMeterIsResettable,
      measunitdef     as REDefaultMeasurementUnit,
      @ObjectModel.foreignKey.association: '_REMsmtUsageForArchlObj'
      usageforao      as REMsmtUsageForArchitecturalObj,
      @ObjectModel.foreignKey.association: '_REMsmtUsageForRentalObj'
      usageforro      as REMsmtUsageForRentalObject,
      @ObjectModel.foreignKey.association: '_REMsmtUsageForBusinessEntity'
      usageforbe      as REMsmtUsageForBusinessEntity,
      @ObjectModel.foreignKey.association: '_REMsmtUsageForLand'
      usageforpr      as REMsmtUsageForLand,
      @ObjectModel.foreignKey.association: '_REMsmtUsageForBuilding'
      usageforbu      as REMsmtUsageForBuilding,
      @ObjectModel.foreignKey.association: '_REMsmtUsageForContract'
      usageforcn      as REMsmtUsageForContract,
      @ObjectModel.foreignKey.association: '_REMsmtUsageForParcels'
      usageforpl      as REMsmtUsageForParcels,
      usageforgo      as REMsmtUsageForGenericObject,

      //      @ObjectModel.foreignKey.association: '_REMsmtUsageForIntegObject'

      //      usageforio      as REMsmtUsageForIntegrationObj,

      isspcfactor     as REMsmtTypeIsAreaMeasurement,
      usedforapport   as REMsmtTypeIsUsedForApprtmt,
      disableexceptro as REExcptnRntlObjIsNotPossible,
      disableexceptao as REExcptnArchlObjIsNotPossible,
      disableexceptcn as REExcptnContrTypeIsNotPossible,
      @ObjectModel.foreignKey.association: '_REDifferingMeasurement'
      objrelprop      as REDifferingMeasurement,
      iscoshare       as RETypeIsRprstvForOwnrShipShare,
      sckeydaterel    as RERefFactorIsRelatedToKeyDate,
      nocompression   as RENoCompressionIsActive,
      cuexcludeassign as REIsExclForNewAssgmt,

      _Text,
      _RESettlmtBasicComponent,
      _REMsmtUsageForArchlObj,
      _REMsmtUsageForRentalObj,
      _REMsmtUsageForBusinessEntity,
      _REMsmtUsageForLand,
      _REMsmtUsageForBuilding,
      _REMsmtUsageForContract,
      _REMsmtUsageForParcels,
      //      _REMsmtUsageForIntegObject,

      _REDifferingMeasurement
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TIVBDMEAS"
],
"ASSOCIATED":
[
"I_REDIFFERINGMEASUREMENT",
"I_REMEASUREMENTTYPETEXT",
"I_REMSMTALLOWEDUSAGES",
"I_RESETTLMTBASICCOMPONENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/