I_MSRGPOINTPRTBYINTERNALKEY

CDS View

Measuring Point PRT by internal key

I_MSRGPOINTPRTBYINTERNALKEY is a CDS View in S/4HANA. Measuring Point PRT by internal key. It contains 6 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 6 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MsrgPointProdnRsceTool view from BASIC Measuring Point Production Resource Tool

Fields (6)

KeyField CDS FieldsUsed in Views
ChangeNumber ChangeNumber 1
ProductionResourceInternalID ProductionResourceInternalID 1
ProductionResourceToolGroup1 ProductionResourceToolGroup1 1
ProductionResourceToolGroup2 ProductionResourceToolGroup2 1
ProductionResourceType ProductionResourceType 1
ProductionResourceUsage ProductionResourceUsage 1 
@AbapCatalog.sqlViewName: 'IPPMSRGPRTIK'
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'ProductionResourceInternalID'
@ObjectModel.semanticKey: 'MeasuringPoint'
@Analytics: { dataCategory: #DIMENSION }
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Measuring Point PRT by internal key'
@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@Metadata.allowExtensions: true

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view I_MsrgPointPRTByInternalKey
  as select from I_ProdnRsceToolMasterData as PRT
    inner join   crvp_a on  crvp_a.objty = PRT.ProductionResourceType
                        and crvp_a.objid = PRT.ProductionResourceInternalID
    inner join   imptt  on  imptt.point  = crvp_a.meas_point
                        
    association [1..1] to I_MeasuringPoint         as _MeasuringPoint         on $projection.MeasuringPoint = _MeasuringPoint.MeasuringPoint
                        
    association [1..1] to I_MsrgPointProdnRsceTool as _MsrgPointProdnRsceTool on $projection.MeasuringPoint = _MsrgPointProdnRsceTool.MeasuringPoint                  
{
      @ObjectModel.foreignKey.association: '_ProductionResourceType'
  key PRT.ProductionResourceType,
  key PRT.ProductionResourceInternalID,
      @ObjectModel.foreignKey.association: '_MsrgPointProdnRsceTool'
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
      cast(crvp_a.meas_point as pph_imrc_point preserving type) as MeasuringPoint,
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
      PRT.ProductionResourceToolGroup1,
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
      PRT.ProductionResourceToolGroup2,
      PRT.ProductionResourceUsage,
      ProdnRsceToolControlProfile,
      @ObjectModel.foreignKey.association: '_ChangeMaster'
      PRT.ChangeNumber,
      ProdnRsceToolStandardTextCode,
      ProdnRsceToolTotQtyCalcFormula,
      ProdnRsceToolUsageQtyCalcFmla,
      StartDateOffsetReferenceCode,
      EndDateOffsetReferenceCode,
      imptt.begru as AuthorizationGroup,

      @Semantics.quantity.unitOfMeasure: 'StartDateOffsetDurationUnit'
      @DefaultAggregation: #SUM
      StartDateOffsetDuration,
      @Semantics.unitOfMeasure: true
      StartDateOffsetDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'EndDateOffsetDurationUnit'
      @DefaultAggregation: #SUM
      EndDateOffsetDuration,
      @Semantics.unitOfMeasure: true
      EndDateOffsetDurationUnit,

      // Admin

      @Semantics.systemDate.createdAt: true
      CreationDate,
      @Semantics.user.createdBy: true
      CreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,

      _ProductionResourceType,
      _MeasuringPoint,
      _MsrgPointProdnRsceTool,
      _ProdnRsceToolGroup1,
      _ProdnRsceToolGroup2,
      _ProductionResourceUsage,
      _ProdnRsceToolControlProfile,
      _ProdnRsceToolStandardText,
      _ProdnRsceToolTotQtyCalcFmla,
      _ProdnRsceToolUsageQtyCalcFmla,
      _StartDateOffsetReferenceCode,
      _EndDateOffsetReferenceCode,
      _StartDateOffsetDurationUnit,
      _EndDateOffsetDurationUnit,

      _CreatedByUser,
      _LastChangedByUser,
      _ChangeMaster
}
where
  PRT.ProdnRsceToolCategory = 'P' // Measuring Point

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODNRSCETOOLMASTERDATA",
"CRVP_A",
"IMPTT"
],
"ASSOCIATED":
[
"I_CHANGEMASTER",
"I_MEASURINGPOINT",
"I_MSRGPOINTPRODNRSCETOOL",
"I_OPERATIONDATEOFFSETREFCODE",
"I_PRODNRSCETOOLCONTROLPROFILE",
"I_PRODNRSCETOOLGROUP",
"I_PRODNRSCETOOLQTYCALCFORMULA",
"I_PRODNRSCETOOLSTANDARDTEXT",
"I_PRODUCTIONRESOURCETYPE",
"I_PRODUCTIONRESOURCEUSAGE",
"I_UNITOFMEASURE",
"I_USER"
],
"BASE":
[
"I_PRODNRSCETOOLMASTERDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More