I_DocumentProdnRsceTool

DDL: I_DOCUMENTPRODNRSCETOOL SQL: IPPDOCUMENTPRT Type: view BASIC Package: VDM_PP_MD_PRT

Document Production Resource Tool

I_DocumentProdnRsceTool is a Basic CDS View (Dimension) that provides data about "Document Production Resource Tool" in SAP S/4HANA. It reads from 1 data source (I_DocumentPRTByInternalKey) and exposes 19 fields with key fields DocumentType, DocumentInfoRecord, DocumentVersion. Part of development package VDM_PP_MD_PRT.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_DocumentPRTByInternalKey PRT from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IPPDOCUMENTPRT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey DocumentPart view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label Document Production Resource Tool view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY DocumentType I_DocumentPRTByInternalKey DocumentType
KEY DocumentInfoRecord I_DocumentPRTByInternalKey DocumentInfoRecord
KEY DocumentVersion I_DocumentPRTByInternalKey DocumentVersion
DocumentPartasDocumentPart
ProductionResourceType I_DocumentPRTByInternalKey ProductionResourceType
ProductionResourceInternalID I_DocumentPRTByInternalKey ProductionResourceInternalID
AuthorizationGroup AuthorizationGroup
InternalDocumentStatus InternalDocumentStatus
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
_DocumentType _DocumentType
_DocumentNumber _DocumentNumber
_DocumentVersion _DocumentVersion
_DocumentInfoRecord _DocumentInfoRecord
_ProductionResourceType _ProductionResourceType
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser 
@AbapCatalog.sqlViewName: 'IPPDOCUMENTPRT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@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", "CALCULATED_FIELD_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,

      // Internal key

      @ObjectModel.foreignKey.association: '_ProductionResourceType'
      PRT.ProductionResourceType,
      PRT.ProductionResourceInternalID,

      // for DCLS

      AuthorizationGroup,
      InternalDocumentStatus,

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

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

//    @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
};

Learn More