I_MeasuringPointCategory

DDL: I_MEASURINGPOINTCATEGORY SQL: IMEASPOINTCAT Type: view BASIC

Measuring Point Category

I_MeasuringPointCategory is a Basic CDS View that provides data about "Measuring Point Category" in SAP S/4HANA. It reads from 1 data source (t370p) and exposes 10 fields with key field MeasuringPointCategory. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t370p t370p from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MeasuringPointCatText _MeasuringPointCategoryText $projection.MeasuringPointCategory = _MeasuringPointCategoryText.MeasuringPointCategory
[0..1] I_Inspectioncatalog _MeasuringPointCatalog $projection.MeasuringPointCatalogType = _MeasuringPointCatalog.InspectionCatalog

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMEASPOINTCAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Measuring Point Category view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey MeasuringPointCategory view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MeasuringPointCategory mptyp
MeasurementPositionNumber suniq
MeasuringPointCatalogType codct
OnlineMessageType mrmes
MsmtDocumentTimeDiffThreshold toler
MsrgPtCategoryIsValid valid
MsrgPtHasLinearAttributes lfe_ind
MsrgPtCategoryIsBusEvtEnabled event_ind
_MeasuringPointCategoryText _MeasuringPointCategoryText
_MeasuringPointCatalog _MeasuringPointCatalog
@AbapCatalog.sqlViewName: 'IMEASPOINTCAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Measuring Point Category'

@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'MeasuringPointCategory'

@ObjectModel: {
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #C,
    sizeCategory: #S
  }
}
@Metadata.ignorePropagatedAnnotations:true
@Analytics: {dataExtraction.enabled: true }
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE , #EXTRACTION_DATA_SOURCE ]

define view I_MeasuringPointCategory
  as select from t370p
  association [0..*] to I_MeasuringPointCatText as _MeasuringPointCategoryText on $projection.MeasuringPointCategory = _MeasuringPointCategoryText.MeasuringPointCategory
  association [0..1] to I_Inspectioncatalog     as _MeasuringPointCatalog      on $projection.MeasuringPointCatalogType = _MeasuringPointCatalog.InspectionCatalog
{
      @ObjectModel.text.association: '_MeasuringPointCategoryText'
  key mptyp     as MeasuringPointCategory,

      suniq     as MeasurementPositionNumber,

      @ObjectModel.foreignKey.association: '_MeasuringPointCatalog'
      codct     as MeasuringPointCatalogType,

      mrmes     as OnlineMessageType,

      toler     as MsmtDocumentTimeDiffThreshold,

      valid     as MsrgPtCategoryIsValid,

      lfe_ind   as MsrgPtHasLinearAttributes,

      event_ind as MsrgPtCategoryIsBusEvtEnabled,

      // Propagate association(s)

      _MeasuringPointCategoryText,
      _MeasuringPointCatalog

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T370P"
],
"ASSOCIATED":
[
"I_INSPECTIONCATALOG",
"I_MEASURINGPOINTCATTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/