I_DocumentProdnRsceTool

@AbapCatalog.sqlViewName: 'IPPDOCUMENTPRT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_CreatedByUser', '_LastChangedByUser'] 
@Analytics.dataCategory: #DIMENSION
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE]
@ObjectModel.representativeKey: 'DocumentPart'
@ObjectModel.semanticKey: ['DocumentType', 'DocumentInfoRecord', 'DocumentVersion', 'DocumentPart']
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER}
//@Search.searchable: true

@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Document Production Resource Tool'

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view I_DocumentProdnRsceTool
  as select from I_DocumentPRTByInternalKey as PRT

{
      @ObjectModel.foreignKey.association: '_DocumentType'
  key PRT.DocumentType                                                                                                                                                                                                                            as     DocumentType,
      @ObjectModel.foreignKey.association: '_DocumentNumber'
//    @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}

  key PRT.DocumentInfoRecord                                                                                                                                                                                                                      as     DocumentInfoRecord,
      @ObjectModel.foreignKey.association: '_DocumentVersion'
  key PRT.DocumentVersion                                                                                                                                                                                                                         as     DocumentVersion,
      -- representative key
  key PRT.DocumentPart                                                                                                                                                                                                                            as     DocumentPart,

      // for DCLS

      AuthorizationGroup,
      InternalDocumentStatus,

//    **** The following fields cannot be maintained in CV01N ****

//    **** Therefore they are always empty                    ****

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

//    PRT.ProductionResourceType,

//    PRT.ProductionResourceInternalID,

//    @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}

//    PRT.ProductionResourceToolGroup1,

//    @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}

//    PRT.ProductionResourceToolGroup2,

//    PRT.ProductionResourceUsage,

//    ProdnRsceToolControlProfile,

//    EngineeringChangeOrder,

//    ProdnRsceToolStandardTextCode,

//    ProdnRsceToolTotQtyCalcFormula,

//    ProdnRsceToolUsageQtyCalcFmla,

//    StartDateOffsetReferenceCode,

//    EndDateOffsetReferenceCode,

//

//    @Semantics.quantity.unitOfMeasure: 'StartDateOffsetDurationUnit'

//    @DefaultAggregation: #SUM

//    StartDateOffsetDuration,

//    @Semantics.unitOfMeasure: true

//    StartDateOffsetDurationUnit,

//    @Semantics.quantity.unitOfMeasure: 'EndDateOffsetDurationUnit'

//    @DefaultAggregation: #SUM

//    EndDateOffsetDuration,

//    @Semantics.unitOfMeasure: true

//    EndDateOffsetDurationUnit,

//    **** End of fields that cannot be maintained in CV01N ****


      // Admin data

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

      // Associations

      _DocumentType,
      _DocumentNumber,
      _DocumentVersion,
      _DocumentInfoRecord,
//    _ProductionResourceType,

//    _ProdnRsceToolGroup1,

//    _ProdnRsceToolGroup2,

//    _ProductionResourceUsage,

//    _ProdnRsceToolControlProfile,

//    _ProdnRsceToolStandardText,

//    _ProdnRsceToolTotQtyCalcFmla,

//    _ProdnRsceToolUsageQtyCalcFmla,

//    _StartDateOffsetReferenceCode,

//    _EndDateOffsetReferenceCode,

//    _StartDateOffsetDurationUnit,

//    _EndDateOffsetDurationUnit,

      _CreatedByUser,
      _LastChangedByUser
};                                                                                 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DOCUMENTPRTBYINTERNALKEY"
],
"ASSOCIATED":
[
"I_DOCUMENTINFORECORD",
"I_DOCUMENTINFORECORDDOCNUMBER",
"I_DOCUMENTINFORECORDDOCTYPE",
"I_DOCUMENTINFORECORDDOCVERSION",
"I_USER"
],
"BASE":
[
"I_DOCUMENTPRTBYINTERNALKEY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/