CDS标准视图:测量点数据 I_MeasuringPointData
- 视图名称:测量点数据 I_MeasuringPointData
- 视图类型:基础视图
- 视图代码:
点击查看代码
@AbapCatalog.sqlViewName: 'IMEASPOINTDATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Measuring Point Data'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'MeasuringPoint'
@Metadata.ignorePropagatedAnnotations: true
@Analytics: {
dataCategory: #DIMENSION,
dataExtraction: {
enabled: true
}
}
@ObjectModel: {
usageType: {
dataClass: #MASTER,
serviceQuality: #B,
sizeCategory: #M
}
}
@Metadata.allowExtensions: true
@ObjectModel.modelingPattern: #EXTRACTION_DATA_SOURCE
@ObjectModel.supportedCapabilities: [ #EXTRACTION_DATA_SOURCE ]
define view I_MeasuringPointData
as select from I_MeasuringPoint
{
key MeasuringPoint,
@ObjectModel.foreignKey.association: '_Language'
Language,
MeasuringPointDescription,
MeasuringPointShortText,
@ObjectModel.foreignKey.association: '_ControllingObject'
MeasuringPointObjectIdentifier,
MeasuringPointPositionNumber,
@ObjectModel.foreignKey.association: '_MeasuringPointCategory'
MeasuringPointCategory,
@Semantics.systemDate.createdAt: true
CreationDate,
@Semantics.systemDate.lastChangedAt: true
LastChangeDate,
AuthorizationGroup,
MeasuringPointIsInactive,
MeasuringPointIsCounter,
MultiLevelDeletionLogicStatus,
@ObjectModel.foreignKey.association: '_Product'
Assembly,
@ObjectModel.foreignKey.association: '_ReferenceMeasuringPoint'
ReferenceMeasuringPoint,
MsrgPtInternalCharacteristic,
MeasuringPointExponent,
MeasuringPointDecimalPlaces,
MeasuringPointMinimumThreshold,
MeasuringPointMaximumThreshold,
@ObjectModel.foreignKey.association: '_UnitOfMeasure'
MeasurementRangeUnit,
MeasuringPointSIUnitOfMeasure,
MsrgPtIsCountingBackwards,
@ObjectModel.foreignKey.association: '_MsmtRdngSourceMeasuringPoint'
MsmtRdngSourceMeasuringPoint,
CounterOverflowRdngThreshold,
MeasuringPointAnnualEstimate,
@ObjectModel.foreignKey.association: '_MeasuringPointCatalogType'
MeasuringPointCatalogType,
@ObjectModel.foreignKey.association: '_MeasuringPointCodeGroup'
MeasuringPointCodeGroup,
ValuationCodeIsSufficient,
MeasuringPointHasLongText,
// Propagate association(s)
_Language,
_ControllingObject,
_MeasuringPointCategory,
_Product,
_ReferenceMeasuringPoint,
_UnitOfMeasure,
_MsmtRdngSourceMeasuringPoint,
_MeasuringPointCatalogType,
_MeasuringPointCodeGroup
}
where MeasuringPointObjectType = 'IE'
or MeasuringPointObjectType = 'IF'
-
事务代码:IK03
技术对象、测量点 -
视图结构:
| 字段名称 | 技术名称 |
|---|---|
| 测量点 | MEASURINGPOINT |
| 语言 | LANGUAGE |
| 描述 | MEASURINGPOINTDESCRIPTION |
| 文本 | MEASURINGPOINTSHORTTEXT |
| 计量点对象编号 | MEASURINGPOINTOBJECTIDENTIFIER |
| 计量位置 | MEASURINGPOINTPOSITIONNUMBER |
| 计量点种类 | MEASURINGPOINTCATEGORY |
| 创建日期 | CREATIONDATE |
| 更改日期 | LASTCHANGEDATE |
| 授权组 | AUTHORIZATIONGROUP |
| 计量点没激活 | MEASURINGPOINTISINACTIVE |
| 计数器 | MEASURINGPOINTISCOUNTER |
| 删除标识 | MULTILEVELDELETIONLOGICSTATUS |
| 装配 | ASSEMBLY |
| 参考计量点 | REFERENCEMEASURINGPOINT |
| 内部特性 | MSRGPTINTERNALCHARACTERISTIC |
| 浮点指数 | MEASURINGPOINTEXPONENT |
| 十进制位 | MEASURINGPOINTDECIMALPLACES |
| 计量范围下限 | MEASURINGPOINTMINIMUMTHRESHOLD |
| UpMRLimit | MEASURINGPOINTMAXIMUMTHRESHOLD |
| 计量范围单位 | MEASUREMENTRANGEUNIT |
| SI 单位 | MEASURINGPOINTSIUNITOFMEASURE |
| 反向 | MSRGPTISCOUNTINGBACKWARDS |
| 读数传输从 | MSMTRDNGSOURCEMEASURINGPOINT |
| 计数器溢出读数 | COUNTEROVERFLOWRDNGTHRESHOLD |
| 年估算 | MEASURINGPOINTANNUALESTIMATE |
| 目录类型 | MEASURINGPOINTCATALOGTYPE |
| 代码组 | MEASURINGPOINTCODEGROUP |
| 评估代码充足 | VALUATIONCODEISSUFFICIENT |
| 长文本 | MEASURINGPOINTHASLONGTEXT |

本文来自博客园,作者:观兴,转载请注明原文链接:https://www.cnblogs.com/guanxing/p/18657722

浙公网安备 33010602011771号